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 <[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]
