Musachy Barroso wrote:
> I would suggest to put a breakpoint in XWorkMethodAccessor.callMethod
> and see why it is not finding it.

Thanks for the nudge. I finally got a more detailed message ("Method
"isUserSubscribedViaBulletin" failed for object
mumble.model.CommunityClassified) which has as it's cause a
LazyInitializationException. Since I use the OpenSessionInViewFilter,
this must mean that there's something earlier in this action/view that's
breaking the session. I'm not sure of an obvious way to find this
earlier error, but at least now I know that this polymorphic code is not
breaking for one concrete class and not another, but rather simply
breaks for any concrete class if the hibernate session is no longer valid.

-Dale

Let me simplify the question: Has anyone out there managed to create a
working connection to the latest version of MySQL 64-bit via JDBC from
Struts 2?

TG

> Let me simplify the question: Has anyone out there managed to
> create a
> working connection to the latest version of MySQL 64-bit via
> JDBC from
> Struts 2?

I am sure many people have. I run 64 bit servers with MySQL
and Struts 2.

What are you seeing?

Neil

--
Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net
Host your Struts app on a CentOS VPS for only $25/month!
Unmetered bandwidth = no overage charges, 7 day free trial

Todd Grigsby wrote:
>
> Fantastic! The error that I'm getting is,
> "org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
> PoolableConnectionFactory ([Microsoft][ODBC Driver Manager] The
> specified DSN contains an architecture mismatch between the Driver and
> Application." Ever seen that?


My guess is you are using a microsoft ODBC to JDBC driver or something?
Just use the JDBC drivers for MySQL. You can download those and get
docos from MySQL's website.

hth,

Manos

Manos Batsis wrote:
> Todd Grigsby wrote:
>>
>> Fantastic! The error that I'm getting is,
>> "org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
>> PoolableConnectionFactory ([Microsoft][ODBC Driver Manager] The
>> specified DSN contains an architecture mismatch between the Driver
>> and Application." Ever seen that?
> My guess is you are using a microsoft ODBC to JDBC driver or
> something? Just use the JDBC drivers for MySQL. You can download those
> and get docos from MySQL's website.

I would use the MySQL connector directly, but I need to use ODBC to
abstract the database connection. MySQL is not the only database we
connect to. The question is, is it possible to go MySQL -> ODBC -> JDBC
-> Struts 2? It was possible under Struts 1.1 on WinXP, and we are
attempting to migrate to Struts 2 (or trying to) on Win7 64-bit.

TG

What do you mean by "I need to use ODBC to abstract the database connection."??

In most (all?) web containers I know about, there is a standard way of
abstract out the database connection and it is by declaring a
javax.sql.DataSource, which you can get it from JNDI (which is pretty
standard too.)
Declaring the datasource may be app server vendor dependent, but it is
the same mechanism for all database vendors (having a JDBC
drive)...you just declare the fully qualified driver class name, the
username, the password, the connection URL, and the JNDI name.

Also, going to configure an ODBC driver you get the extra complexity
of installing the right version for the OS...I remember a couple of
headaches trying to configure a 32-bit ODBC driver on a 64-bit win2003
server.

Gabriel

2009/12/14 Todd Grigsby <strutsuser@(protected)>:
> Manos Batsis wrote:
>>
>> Todd Grigsby wrote:
>>>
>>> Fantastic!  The error that I'm getting is,
>>> "org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
>>> PoolableConnectionFactory ([Microsoft][ODBC Driver Manager] The specified
>>> DSN contains an architecture mismatch between the Driver and Application."
>>>  Ever seen that?
>>
>> My guess is you are using a microsoft ODBC to JDBC driver or something?
>> Just use the JDBC drivers for MySQL. You can download those and get docos
>> from MySQL's website.
>
> I would use the MySQL connector directly, but I need to use ODBC to abstract
> the database connection.  MySQL is not the only database we connect to.  The
> question is, is it possible to go MySQL -> ODBC -> JDBC -> Struts 2?  It was
> possible under Struts 1.1 on WinXP, and we are attempting to migrate to
> Struts 2 (or trying to) on Win7 64-bit.
>
> TG
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@(protected)
> For additional commands, e-mail: user-help@(protected)
>
>

> Oh, and a relevant follow-up question: do you use JDBC-ODBC
> to connect
> to MySQL?

I never used ODBC to talk to MySQL. I am not sure how well
that would work.

Thanks,
 Neil

--
Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net
Host your MySQL database on a CentOS virtual server for $25/mo
Unmetered bandwidth = no overage charges, 7 day free trial

Not that I wanted to get into a debate about the usefulness of ODBC, but
the Java-based web services we have aren't the only things that connect
to these databases, and going through ODBC has been, for the last 10
years, a very nice and consistent way to connect across all our
applications and utilities. We have, at one time or another, supported
all of the following:

  MySQL
  Oracle
  SQL Server
  Informix
  DB2
  mSQL
  Pervasive SQL
  MS Access (pre-Jet)

And a few others, and we have connected to these databases via ODBC all
along the way. Keeping the connection mechanism consistent has made
development work in a number of languages simple. So while I certainly
appreciate everyone's enthusiasm for talking directly to MySQL, I have a
legacy code base that works *REALLY* well through ODBC, and I'd like to
stick with it.

So one more time for the folks at home: Is there anyone out there who
has managed to get MySQL 64-bit to work via ODBC?

TG

Nguyen,

On 12/13/2009 11:04 PM, Nguyen Xuan Son wrote:
> dear all
> im using PreparedStatement.setNString(int, String)
> to insert the japanese characters into my MySQL database
> but the result is all in "?????????" characters
>
> PreparedStatement pstmt = conn.prepareStatement(sql5);
> pstmt.setNString(3, item.getTitle());
> rs = pstmt.executeUpdate();
>
> do you have any suggestion?
>

Most likely your (1) tables/columns are not using UTF-8 to store data
and (2) neither is your MySQL database connection.

Do a google search to learn how to store international characters in
MySQL and JDBC.

Paul

Here is the best checklist for Java webdev + UTF-8
http://stackoverflow.com/questions/138948/how-to-get-utf-8-working-in-java-webapps

Nguyen Xuan Son-2 wrote:
>
> dear all
> im using PreparedStatement.setNString(int, String)
> to insert the japanese characters into my MySQL database
> but the result is all in "?????????" characters
>
> PreparedStatement pstmt = conn.prepareStatement(sql5);
> pstmt.setNString(3, item.getTitle());
> rs = pstmt.executeUpdate();
>
> do you have any suggestion?
>
> --
> =======================================================================
> Ritsumeikan University, Asia JinZai Project
> Master of Information Science
> Nguyen Xuan Son
>
> Add     : Japan, Shiga-Ken, Kusatsu-Shi, Kasayama 3choume 1-18
> ShiteiHaimu
> Rien, Room 103
> Tel/Fax : 81-(0)90-3976 2246
> Email   : nr0003xx@(protected)
> Mobile  : 81-(0)90-3976 2246       URL : http://www.ritsumei.jp
> =======================================================================
>
>

--
Sent from the Struts - User mailing list archive at Nabble.com.

Greetings and Happy Holidays --

I am sitting down to unwind the Essential Dependencies Only jar
(struts-2.1.8.1-lib.zip) in preparation for the litany of questions the
lawyers are going to ask before accepting the Struts 2.1.8.1 upgrade in
house. Now either I have a different understanding of the word essential,
or this version of our new Struts has really spread her arms. There are
seventy-one jars in the lib folder of the *essential dependencies only jar*
and a quick glance suggests they are *not* all essential. So does essential
!= core or required? Is there a resource where an analysis can be made to
determine compile, testing, run-time dependencies? Untangling this ball of
yarn by hand is going to burn up hours and lead an analyst down many rabbit
holes. Is there a POM that could save the man hours?

Peace,
Scott
--
Sent from the Struts - User mailing list archive at Nabble.com.

Scott, take a look at the mailreader and blank apps. You can also read
through the struts2-core pom (annotated and easier to read here -
http://jarvana.com/jarvana/inspect-pom/org/apache/struts/struts2-core/2.1.8/struts2-core-2.1.8.pom,
that points to 2.1.8, they haven't indexed 2.1.8.1 yet, but there is
no differences in dependencies).

If you just want to cut to the chase, the "essentials" would be -

struts2-core 2.1.8.1
xwork-core 2.1.6
freemarker 2.3.15
ognl 2.7.3

-Wes

On Mon, Dec 14, 2009 at 10:36 AM, stanlick <stanlick@(protected):
>
> Greetings and Happy Holidays --
>
> I am sitting down to unwind the Essential Dependencies Only jar
> (struts-2.1.8.1-lib.zip) in preparation for the litany of questions the
> lawyers are going to ask before accepting the Struts 2.1.8.1 upgrade in
> house.  Now either I have a different understanding of the word essential,
> or this version of our new Struts has really spread her arms.  There are
> seventy-one jars in the lib folder of the *essential dependencies only jar*
> and a quick glance suggests they are *not* all essential.  So does essential
> != core or required?  Is there a resource where an analysis can be made to
> determine compile, testing, run-time dependencies?  Untangling this ball of
> yarn by hand is going to burn up hours and lead an analyst down many rabbit
> holes.  Is there a POM that could save the man hours?
>
> Peace,
> Scott
> --
> View this message in context: http://old.nabble.com/Essential-Dependencies-Only-tp26779724p26779724.html
> Sent from the Struts - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@(protected)
> For additional commands, e-mail: user-help@(protected)
>
>



--
Wes Wannemacher

Head Engineer, WanTii, Inc.
Need Training? Struts, Spring, Maven, Tomcat...
Ask me for a quote!

Is it possible to upload a file to a server, process the data as it needs to
be, and then write the file back to the local machine from which it
originally was uploaded all in a single execute method of a single action
class? Or, am I required to have an action for uploading it to the server,
and another for processing, and another for downloading, or something in
between?
--
Sent from the Struts - User mailing list archive at Nabble.com.

Hello,

  I just recently switched to c3p0 and it fixed some other issues I
was having with dbcp, but another has arisen.
  It seems to be a combination of using the c3p0 data source along
with the JSON plugin. Here's my (slightly shortened) stacktrace:

Caused by: org.apache.struts2.json.JSONException:
org.apache.struts2.json.JSONException:
org.apache.struts2.json.JSONException:
java.lang.reflect.InvocationTargetException
at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:243)
at org.apache.struts2.json.JSONWriter.process (JSONWriter.java:165)
at org.apache.struts2.json.JSONWriter.value (JSONWriter.java:131)
at org.apache.struts2.json.JSONWriter.add (JSONWriter.java:329)
at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:228)
... 91 more
Caused by: org.apache.struts2.json.JSONException:
org.apache.struts2.json.JSONException:
java.lang.reflect.InvocationTargetException
at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:243)
at org.apache.struts2.json.JSONWriter.process (JSONWriter.java:165)
at org.apache.struts2.json.JSONWriter.value (JSONWriter.java:131)
at org.apache.struts2.json.JSONWriter.add (JSONWriter.java:329)
at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:228)
... 95 more
Caused by: org.apache.struts2.json.JSONException:
java.lang.reflect.InvocationTargetException
at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:243)
at org.apache.struts2.json.JSONWriter.process (JSONWriter.java:165)
at org.apache.struts2.json.JSONWriter.value (JSONWriter.java:131)
at org.apache.struts2.json.JSONWriter.add (JSONWriter.java:329)
at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:228)
... 99 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)

at
sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke (Method.java:597)
at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:227)
... 103 more
Caused by: java.sql.SQLException: Unsupported feature: getCursorName
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.BaseResultSet.getCursorName(BaseResultSet.java:37)
at
com.mchange.v2.c3p0.impl.NewProxyResultSet.getCursorName(NewProxyResultSet.java:545)

... 108 more

I'm runing c3p0-0.9.1.2, struts 2.1.8.1 and its corresponding json
plugin, Oracle 10, and Hibernate 3.3.1.GA

Heres my datasource in spring. Just using the defaults:

  <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    <property name="driverClass" value="${database.driver}" />
    <property name="jdbcUrl" value="${database.connectionString}" />
    <property name="user" value="${database.username}" />
    <property name="password" value="${database.password}" />
  </bean>

Should note that other pages seem to work fine and lazy load as well.
Just this json action is giving me problems. If you need more info let
me know.

Thanks!
-Tim

Wild guess.... you are trying to serialize (with JSON plugin) a
Hibernate proxy object.
Maybe your object has a reference to another lazy loaded object or collection.

Using reflection on a proxy object is usually a bad idea.

You may need to clone the object (to get a real one) first before
serializing it with JSON.


Greg

On Mon, Dec 14, 2009 at 3:45 PM, Timothy Orme
<torme@(protected):
> Hello,
>
>   I just recently switched to c3p0 and it fixed some other issues I was
> having with dbcp, but another has arisen.
>   It seems to be a combination of using the c3p0 data source along with the
> JSON plugin. Here's my (slightly shortened) stacktrace:
>
> Caused by: org.apache.struts2.json.JSONException:
> org.apache.struts2.json.JSONException:
> org.apache.struts2.json.JSONException:
> java.lang.reflect.InvocationTargetException
> at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:243)
> at org.apache.struts2.json.JSONWriter.process (JSONWriter.java:165)
> at org.apache.struts2.json.JSONWriter.value (JSONWriter.java:131)
> at org.apache.struts2.json.JSONWriter.add (JSONWriter.java:329)
> at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:228)
> ... 91 more
> Caused by: org.apache.struts2.json.JSONException:
> org.apache.struts2.json.JSONException:
> java.lang.reflect.InvocationTargetException
> at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:243)
> at org.apache.struts2.json.JSONWriter.process (JSONWriter.java:165)
> at org.apache.struts2.json.JSONWriter.value (JSONWriter.java:131)
> at org.apache.struts2.json.JSONWriter.add (JSONWriter.java:329)
> at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:228)
> ... 95 more
> Caused by: org.apache.struts2.json.JSONException:
> java.lang.reflect.InvocationTargetException
> at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:243)
> at org.apache.struts2.json.JSONWriter.process (JSONWriter.java:165)
> at org.apache.struts2.json.JSONWriter.value (JSONWriter.java:131)
> at org.apache.struts2.json.JSONWriter.add (JSONWriter.java:329)
> at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:228)
> ... 99 more
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke (Method.java:597)
> at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:227)
> ... 103 more
> Caused by: java.sql.SQLException: Unsupported feature: getCursorName
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
> at oracle.jdbc.driver.BaseResultSet.getCursorName(BaseResultSet.java:37)
> at
> com.mchange.v2.c3p0.impl.NewProxyResultSet.getCursorName(NewProxyResultSet.java:545)
> ... 108 more
>
> I'm runing c3p0-0.9.1.2, struts 2.1.8.1 and its corresponding json plugin,
> Oracle 10, and Hibernate 3.3.1.GA
>
> Heres my datasource in spring. Just using the defaults:
>
>   <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
>       <property name="driverClass" value="${database.driver}" />
>       <property name="jdbcUrl" value="${database.connectionString}" />
>       <property name="user" value="${database.username}" />
>       <property name="password" value="${database.password}" />
>   </bean>
>
> Should note that other pages seem to work fine and lazy load as well. Just
> this json action is giving me problems. If you need more info let me know.
>
> Thanks!
> -Tim
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@(protected)
> For additional commands, e-mail: user-help@(protected)
>
>

Ill give this a whirl, and you're probably right, but this used to work
while using DBCP. Any idea as to why this would be broken in c3p0? I
tried to do some digging under the hood but couldn't find sources the
classes that were breaking.

Thanks,
-Tim

Greg Lindholm wrote:
> Wild guess.... you are trying to serialize (with JSON plugin) a
> Hibernate proxy object.
> Maybe your object has a reference to another lazy loaded object or collection.
>
> Using reflection on a proxy object is usually a bad idea.
>
> You may need to clone the object (to get a real one) first before
> serializing it with JSON.
>
>
> Greg
>
> On Mon, Dec 14, 2009 at 3:45 PM, Timothy Orme
> <torme@(protected):
>  
>> Hello,
>>
>>  I just recently switched to c3p0 and it fixed some other issues I was
>> having with dbcp, but another has arisen.
>>  It seems to be a combination of using the c3p0 data source along with the
>> JSON plugin. Here's my (slightly shortened) stacktrace:
>>
>> Caused by: org.apache.struts2.json.JSONException:
>> org.apache.struts2.json.JSONException:
>> org.apache.struts2.json.JSONException:
>> java.lang.reflect.InvocationTargetException
>> at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:243)
>> at org.apache.struts2.json.JSONWriter.process (JSONWriter.java:165)
>> at org.apache.struts2.json.JSONWriter.value (JSONWriter.java:131)
>> at org.apache.struts2.json.JSONWriter.add (JSONWriter.java:329)
>> at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:228)
>> ... 91 more
>> Caused by: org.apache.struts2.json.JSONException:
>> org.apache.struts2.json.JSONException:
>> java.lang.reflect.InvocationTargetException
>> at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:243)
>> at org.apache.struts2.json.JSONWriter.process (JSONWriter.java:165)
>> at org.apache.struts2.json.JSONWriter.value (JSONWriter.java:131)
>> at org.apache.struts2.json.JSONWriter.add (JSONWriter.java:329)
>> at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:228)
>> ... 95 more
>> Caused by: org.apache.struts2.json.JSONException:
>> java.lang.reflect.InvocationTargetException
>> at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:243)
>> at org.apache.struts2.json.JSONWriter.process (JSONWriter.java:165)
>> at org.apache.struts2.json.JSONWriter.value (JSONWriter.java:131)
>> at org.apache.struts2.json.JSONWriter.add (JSONWriter.java:329)
>> at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:228)
>> ... 99 more
>> Caused by: java.lang.reflect.InvocationTargetException
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)
>> at java.lang.reflect.Method.invoke (Method.java:597)
>> at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:227)
>> ... 103 more
>> Caused by: java.sql.SQLException: Unsupported feature: getCursorName
>> at
>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>> at
>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>> at oracle.jdbc.driver.BaseResultSet.getCursorName(BaseResultSet.java:37)
>> at
>> com.mchange.v2.c3p0.impl.NewProxyResultSet.getCursorName(NewProxyResultSet.java:545)
>> ... 108 more
>>
>> I'm runing c3p0-0.9.1.2, struts 2.1.8.1 and its corresponding json plugin,
>> Oracle 10, and Hibernate 3.3.1.GA
>>
>> Heres my datasource in spring. Just using the defaults:
>>
>>  <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
>>     <property name="driverClass" value="${database.driver}" />
>>     <property name="jdbcUrl" value="${database.connectionString}" />
>>     <property name="user" value="${database.username}" />
>>     <property name="password" value="${database.password}" />
>>  </bean>
>>
>> Should note that other pages seem to work fine and lazy load as well. Just
>> this json action is giving me problems. If you need more info let me know.
>>
>> Thanks!
>> -Tim
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@(protected)
>> For additional commands, e-mail: user-help@(protected)
>>
>>
>>  
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@(protected)
> For additional commands, e-mail: user-help@(protected)
>
>  

So changing this around seems to correct it. I'm not sure why though, to
my knowledge it shouldn't have been using a proxy.

public class ChangeProcessAction {
  private StatusService statusService;
  private OrderService orderService;

  private Status status;
  private Integer orderId;
 
 
  public String execute() throws Exception {
     
    status = statusService.findByID("C");
    Order order = orderService.findById(orderId);
    order.setStatus(status);
    orderService.update(order);
   
    return SUCCESS;
  }
 

  public Status getStatus() {
    return status;
  }
}

Didn't work when serializing the Status object.

However:

public class ChangeProcessAction {
  private StatusService statusService;
  private OrderService orderService;

  private String statusName;
  private Integer orderId;
 
 
  public String execute() throws Exception {
   
    Status status;

    status = statusService.findByID("C");
    Order order = orderService.findById(orderId);
    order.setStatus(status);
    orderService.update(order);

    statusName = status.getName();
   
    return SUCCESS;
  }
 

  public String getStatusName() {
    return statusName;
  }
}


Works fine. Maybe I'm wrong, but shouldn't the status be the full object
and not a proxy when I do findById?

Thanks,
-Tim

Timothy Orme wrote:
> Ill give this a whirl, and you're probably right, but this used to
> work while using DBCP. Any idea as to why this would be broken in
> c3p0? I tried to do some digging under the hood but couldn't find
> sources the classes that were breaking.
>
> Thanks,
> -Tim
>
> Greg Lindholm wrote:
>> Wild guess.... you are trying to serialize (with JSON plugin) a
>> Hibernate proxy object.
>> Maybe your object has a reference to another lazy loaded object or
>> collection.
>>
>> Using reflection on a proxy object is usually a bad idea.
>>
>> You may need to clone the object (to get a real one) first before
>> serializing it with JSON.
>>
>>
>> Greg
>>
>> On Mon, Dec 14, 2009 at 3:45 PM, Timothy Orme
>> <torme@(protected):
>>
>>> Hello,
>>>
>>>  I just recently switched to c3p0 and it fixed some other issues I was
>>> having with dbcp, but another has arisen.
>>>  It seems to be a combination of using the c3p0 data source along
>>> with the
>>> JSON plugin. Here's my (slightly shortened) stacktrace:
>>>
>>> Caused by: org.apache.struts2.json.JSONException:
>>> org.apache.struts2.json.JSONException:
>>> org.apache.struts2.json.JSONException:
>>> java.lang.reflect.InvocationTargetException
>>> at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:243)
>>> at org.apache.struts2.json.JSONWriter.process (JSONWriter.java:165)
>>> at org.apache.struts2.json.JSONWriter.value (JSONWriter.java:131)
>>> at org.apache.struts2.json.JSONWriter.add (JSONWriter.java:329)
>>> at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:228)
>>> ... 91 more
>>> Caused by: org.apache.struts2.json.JSONException:
>>> org.apache.struts2.json.JSONException:
>>> java.lang.reflect.InvocationTargetException
>>> at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:243)
>>> at org.apache.struts2.json.JSONWriter.process (JSONWriter.java:165)
>>> at org.apache.struts2.json.JSONWriter.value (JSONWriter.java:131)
>>> at org.apache.struts2.json.JSONWriter.add (JSONWriter.java:329)
>>> at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:228)
>>> ... 95 more
>>> Caused by: org.apache.struts2.json.JSONException:
>>> java.lang.reflect.InvocationTargetException
>>> at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:243)
>>> at org.apache.struts2.json.JSONWriter.process (JSONWriter.java:165)
>>> at org.apache.struts2.json.JSONWriter.value (JSONWriter.java:131)
>>> at org.apache.struts2.json.JSONWriter.add (JSONWriter.java:329)
>>> at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:228)
>>> ... 99 more
>>> Caused by: java.lang.reflect.InvocationTargetException
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>> at
>>> sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)
>>>
>>> at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)
>>>
>>> at java.lang.reflect.Method.invoke (Method.java:597)
>>> at org.apache.struts2.json.JSONWriter.bean (JSONWriter.java:227)
>>> ... 103 more
>>> Caused by: java.sql.SQLException: Unsupported feature: getCursorName
>>> at
>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>>>
>>> at
>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>>>
>>> at
>>> oracle.jdbc.driver.BaseResultSet.getCursorName(BaseResultSet.java:37)
>>> at
>>> com.mchange.v2.c3p0.impl.NewProxyResultSet.getCursorName(NewProxyResultSet.java:545)
>>>
>>> ... 108 more
>>>
>>> I'm runing c3p0-0.9.1.2, struts 2.1.8.1 and its corresponding json
>>> plugin,
>>> Oracle 10, and Hibernate 3.3.1.GA
>>>
>>> Heres my datasource in spring. Just using the defaults:
>>>
>>>  <bean id="dataSource"
>>> class="com.mchange.v2.c3p0.ComboPooledDataSource">
>>>     <property name="driverClass" value="${database.driver}" />
>>>     <property name="jdbcUrl" value="${database.connectionString}" />
>>>     <property name="user" value="${database.username}" />
>>>     <property name="password" value="${database.password}" />
>>>  </bean>
>>>
>>> Should note that other pages seem to work fine and lazy load as
>>> well. Just
>>> this json action is giving me problems. If you need more info let me
>>> know.
>>>
>>> Thanks!
>>> -Tim
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-unsubscribe@(protected)
>>> For additional commands, e-mail: user-help@(protected)
>>>
>>>
>>>  
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@(protected)
>> For additional commands, e-mail: user-help@(protected)
>>
>>  
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@(protected)
> For additional commands, e-mail: user-help@(protected)
>

Hi,

I am trying to get JSON response from struts2 action.


My struts.xml contains the fallowing:

<struts>
<package name="example" extends="json-default">
  <action name="testjson" class="tutorial.example.JSONAction">
   <result type="json" />
  </action>
</package>
</struts>


Class JSONAction.java is empty at the moment:


package tutorial.example;


import com.opensymphony.xwork2.ActionSupport;


public class JSONAction extends ActionSupport {
  public String execute() throws Exception {
    //setMessage(getText(MESSAGE));
    return SUCCESS;
  }
}


When I try to access JSON action under
http://localhost:8080/tutorial/testjson URL I get the fallowing error
page:


Struts Problem Report

Struts has detected an unhandled exception:
# Messages:  There is no Action mapped for namespace / and action name testjson.


Any suggestions on how to make JSON action work?

Regards
--
Milos Negovanovic
milos.negovanovic@(protected)