I suppose the statement Torque tries to execute is malformed in AS/400's manners...
We should need to see the exact SQL which Torque executes... Giulio Vezzelli Infolog S.r.l. Via Alfieri, 28 Modena - 41100 Telefono : +39-059-822446 Sito web : http://www.infolog.it E-mail : [EMAIL PROTECTED] > -----Messaggio originale----- > Da: Sonu Vijay [mailto:[EMAIL PROTECTED] > Inviato: mercoled� 3 dicembre 2003 19.19 > A: Apache Torque Users List > Oggetto: Re: R: Newbie - Torque with DB2/AS400 > > Thanks for your reply. I tried to do the same and now I tried > to use the example schema given in an article on Torque > website. Here is the part from my Torque.properties, where > T0064 in my library.: > > --------------------------------- > torque.database.default=T0064 > torque.database.T0064.adapter=db2app > > ## Using torque's old pool > torque.dsfactory.T0064.factory=org.apache.torque.dsfactory.Tor > queDataSourceFactory > torque.dsfactory.T0064.pool.defaultMaxConnections=10 > torque.dsfactory.T0064.pool.maxExpiryTime=3600 > torque.dsfactory.T0064.pool.connectionWaitTimeout=10 > torque.dsfactory.T0064.connection.driver = > com.ibm.as400.access.AS400JDBCDriver > torque.dsfactory.T0064.connection.url = > jdbc:as400://asmctest/t0064 > torque.dsfactory.T0064.connection.user = T0064 > torque.dsfactory.T0064.connection.password = password > > ---------------------------------------------- > > Again tables are created but can't insert data. Get the > following exceptions: > > > > 265 [main] DEBUG dsfactory.TorqueDataSourceFactory - Setting > datasource property: url > 281 [main] DEBUG dsfactory.TorqueDataSourceFactory - Setting > datasource property: user > 281 [main] DEBUG dsfactory.TorqueDataSourceFactory - Setting > datasource property: password > 281 [main] DEBUG dsfactory.TorqueDataSourceFactory - > Starting initTorqueClassic > 296 [main] DEBUG dsfactory.TorqueDataSourceFactory - Setting > datasource property: defaultMaxConnections > 312 [main] DEBUG dsfactory.TorqueDataSourceFactory - Setting > datasource property: maxExpiryTime > 343 [main] DEBUG dsfactory.TorqueDataSourceFactory - Setting > datasource property: connectionWaitTimeout > 359 [main] DEBUG torque.Torque - Adding a dummy entry for > default, mapped onto T0064 > 421 [Thread-0] DEBUG oid.IDBroker - IDBroker thread was started. > 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(AS400JDB > CStatement.java:1088) > at > com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JD > BCPreparedStatement.java:208) > at > com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS40 > 0JDBCConnection.java:1419) > at > com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS40 > 0JDBCConnection.java:1371) > at > org.apache.commons.dbcp.cpdsadapter.PooledConnectionImpl.prepa > reStatement(PooledConnectionImpl.java:271) > at > org.apache.commons.dbcp.cpdsadapter.ConnectionImpl.prepareStat > ement(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:213) > at > com.suz.torque.pitchers.BaseTeamPeer.doInsert(BaseTeamPeer.java:559) > at > com.suz.torque.pitchers.BaseTeam.save(BaseTeam.java:1072) > at > com.suz.torque.pitchers.BaseTeam.save(BaseTeam.java:1034) > at > com.suz.torque.pitchers.BaseTeam.save(BaseTeam.java:1014) > at > com.suz.torque.PitcherStats.main(PitcherStats.java:40) > rethrown as org.apache.torque.TorqueException: > [SQL0104] Token ) was not valid. Valid tokens: DAY PATH YEAR > LABEL MONTH OPTION RESULT CONNECTION TRANSACTION. > at > org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer. > java:895) > at > org.apache.torque.util.BasePeer.doInsert(BasePeer.java:725) > at > com.suz.torque.pitchers.BaseTeamPeer.doInsert(BaseTeamPeer.java:213) > at > com.suz.torque.pitchers.BaseTeamPeer.doInsert(BaseTeamPeer.java:559) > at > com.suz.torque.pitchers.BaseTeam.save(BaseTeam.java:1072) > at > com.suz.torque.pitchers.BaseTeam.save(BaseTeam.java:1034) > at > com.suz.torque.pitchers.BaseTeam.save(BaseTeam.java:1014) > at > com.suz.torque.PitcherStats.main(PitcherStats.java:40) > rethrown as org.apache.torque.TorqueException: > [SQL0104] Token ) was not valid. Valid tokens: DAY PATH YEAR > LABEL MONTH OPTION RESULT CONNECTION TRANSACTION. > at > org.apache.torque.util.BasePeer.doInsert(BasePeer.java:729) > at > com.suz.torque.pitchers.BaseTeamPeer.doInsert(BaseTeamPeer.java:213) > at > com.suz.torque.pitchers.BaseTeamPeer.doInsert(BaseTeamPeer.java:559) > at > com.suz.torque.pitchers.BaseTeam.save(BaseTeam.java:1072) > at > com.suz.torque.pitchers.BaseTeam.save(BaseTeam.java:1034) > at > com.suz.torque.pitchers.BaseTeam.save(BaseTeam.java:1014) > at > com.suz.torque.PitcherStats.main(PitcherStats.java:40) > > > > > > > > --- Giulio Vezzelli <[EMAIL PROTECTED]> > wrote: > > I think you should consider the "library" > > corresponding to "database", and "file" to "table". > > > > That's how IBM iSeries/Client Access works... Maybe it's your > > solution. > > > > The adapter should be "db2400", and the JDBC driver is > > "com.ibm.as400.access.AS400JDBCDriver", supplied in the > Java toolbox > > which comes with OS/400. > > > > > > My personal opinion is that Torque is not ready yet to create > > libraries/files on AS/400... Or maybe it's just my impression ;) > > > > Beware of case sensitivity issues when specifying databases > > (libraries), tables and columns... AS/400 is quite nosy about it. > > > > > > > > > > Giulio Vezzelli > > Infolog S.r.l. > > Via Alfieri, 28 > > Modena - 41100 > > Telefono : +39-059-822446 > > Sito web : http://www.infolog.it > > E-mail : [EMAIL PROTECTED] > > > > > > > > > -----Messaggio originale----- > > > Da: Sonu Vijay [mailto:[EMAIL PROTECTED] > > > Inviato: mercoled� 3 dicembre 2003 18.46 > > > A: [EMAIL PROTECTED] > > > Oggetto: Newbie - Torque with DB2/AS400 > > > > > > Hi, > > > Am trying to use Torque with DB2/AS400. So far am > > able to > > > create tables and generate java classes. But I'm > > having some > > > problems with using those java classes to enter > > data into the tables. > > > > > > On DB2/AS400 everything is arranged in libraries > > and the > > > conventional concept of a database (like in mysql > > > etc) doesn't exist. So the create-db target didn't > > do > > > anything also. And in the database create and > > build URLs I > > > only gave the URL to the library in which I needed > > the > > > tables, that's the way it worked. > > > > > > Now I'm not sure how to configure the Torque.properties I'm doing > > > this: > > > > > > Like for mysql and stuff I can write > > > > > > torque.database.default=bookstore > > > torque.database.bookstore.adapter=DBDB2App > > > > > > So what needs to written in place of "bookstore" ? > > > > > > The library name ?? > > > > > > And also am I using the right adapter ? > > > > > > And is there any DB2/AS400 specific tutorial > > available ? > > > > > > Pls advice > > > > > > Vijay > > > > > > > > > __________________________________ > > > 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] > > > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > For additional commands, e-mail: > > [EMAIL PROTECTED] > > > > > __________________________________ > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
