Ok nevermind - I used a "trace=true" option on the jdbc driver. Now I can see the INSERT SQL statement: INSERT INTO RDF( ) VALUES ( )
Is this right? This can't be right. Can someone tell me why this would come up with no fields and no values? Here's a snippet of the problem area - this is after I've clicked "Insert Entry", and typed some data, and clicked the Insert button. as400: PreparedStatement STMT0001 open. as400: PreparedStatement STMT0001: Escape processing = "true". as400: PreparedStatement STMT0001: Fetch direction = "1000". as400: PreparedStatement STMT0001: Fetch size = "0". as400: PreparedStatement STMT0001: Max field size = "0". as400: PreparedStatement STMT0001: Max rows = "0". as400: PreparedStatement STMT0001: Query timeout = "0". as400: PreparedStatement STMT0001: Result set conncurrency = "1007". as400: PreparedStatement STMT0001: Result set type = "1003". as400: PreparedStatement STMT0001: Preparing [INSERT INTO RDF ( ) VALUES ( )]. SQLException: SQLState(42601) vendor code(-104) 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.jav a:1062) ----- Original Message ----- From: "Jeff Owens" <[EMAIL PROTECTED]> To: "Turbine Torque Users List" <[EMAIL PROTECTED]> Sent: Wednesday, September 04, 2002 11:02 AM Subject: Torque's SQL Insert statement > Is there a way to view the INSERT SQL statement > executed by doInsert in the basepeer? > > 1. I'm working on getting the TDK demo app to work > with DB2 running on an AS/400. I believe I have > everything setup correctly. > > 2. Everything works in "ant init". > > 3. When I go to "Insert Entry" in the sample app "Turbine > Data Manager", I get an exception. The message isn't > real helpful, except that it indicates a SQL Syntax error as follows: > Horrible Exception: java.lang.reflect.InvocationTargetException: > java.sql.SQLException: [SQL0104] Token ) was not valid. > Valid tokens: DAY PATH YEAR LABEL MONTH OPTION > RESULT CONNECTION TRANSACTION. > > According to IBM's website a SQL0104 indicates a general syntax > error in the SQL statement. So, my first thought is can I see the > INSERT statement in order to verify that? > > Thanks, > Jeff Owens > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
