db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sonu Vijay <son...@yahoo.com>
Subject Re: R: Newbie - Torque with DB2/AS400
Date Wed, 03 Dec 2003 18:19:05 GMT
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.TorqueDataSourceFactory
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(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: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


Mime
View raw message