Hi,
Can we print the actual SQL that is made out of the
Criteria.
My selects work but inserts don't, I need to see the
SQL as the following stack trace indicated syntax
errors.
Thanks
Vijay
-----------------------
java.sql.SQLException: [SQL0104] Token ) was not
valid. Valid tokens: DAY PATH YEAR LABEL MONTH OPTION
RESULT CONNECTION TRANSACTION.
at
com.ibm.as400.access.JDError.throwSQLException(JDError.java:388)
at
com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1088)
at
com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JDBCPreparedStatement.java:208)
at
com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:1419)
at
com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:1371)
at
org.apache.commons.dbcp.cpdsadapter.PooledConnectionImpl.prepareStatement(PooledConnectionImpl.java:271)
at
org.apache.commons.dbcp.cpdsadapter.ConnectionImpl.prepareStatement(ConnectionImpl.java:372)
at
com.workingdogs.village.Record.saveWithInsert(Unknown
Source)
at com.workingdogs.village.Record.save(Unknown
Source)
at com.workingdogs.village.Record.save(Unknown
Source)
at
org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:891)
at
org.apache.torque.util.BasePeer.doInsert(BasePeer.java:725)
at
com.suz.torque.pitchers.BaseTeamPeer.doInsert(BaseTeamPeer.java:218)
at
com.suz.torque.pitchers.BaseTeamPeer.doInsert(BaseTeamPeer.java:565)
at com.suz.torque.pitchers.BaseTeam.save(BaseTeam.java:1081)
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
