Hi, Same thing happened to me using Sybase Database. The problem was in Sybase JDBC driver because the ResultSetMetaData.isReadOnly() method returned true for all colums of our table, hence the empty insert. Since there was no update for sybase jdbc driver, the only solution i cam up with to modify village classes. If you are interested in a modified village. jar to try it out just let me know.
Andras. http://www.reea.net ----- Original Message ----- From: "Jeff Owens" <[EMAIL PROTECTED]> To: "Turbine Torque Users List" <[EMAIL PROTECTED]> Sent: Thursday, September 05, 2002 01:17 Subject: No values in INSERT statement. Was:Torque's SQL Insert statement > 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) > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
