db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Giulio Vezzelli" <giulio.vezze...@infolog.it>
Subject R: R: Newbie - Torque with DB2/AS400
Date Wed, 03 Dec 2003 18:24:53 GMT
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 : giulio.vezzelli@infolog.it
 
 

> -----Messaggio originale-----
> Da: Sonu Vijay [mailto:sonupv@yahoo.com] 
> 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 <giulio.vezzelli@infolog.it>
> 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 : giulio.vezzelli@infolog.it
> >  
> >  
> > 
> > > -----Messaggio originale-----
> > > Da: Sonu Vijay [mailto:sonupv@yahoo.com]
> > > Inviato: mercoledì 3 dicembre 2003 18.46
> > > A: torque-user@db.apache.org
> > > 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:
> > torque-user-unsubscribe@db.apache.org
> > > For additional commands, e-mail:
> > torque-user-help@db.apache.org
> > > 
> > > 
> > 
> >
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> > torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail:
> > torque-user-help@db.apache.org
> > 
> 
> 
> __________________________________
> Do you Yahoo!?
> Free Pop-Up Blocker - Get it now
> http://companion.yahoo.com/
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message