Vijay, If Torque says that IdGenerator is "null", maybe there is an error in the project-schema.xml file...
It should look like : <table name="TEAM" idMethod="native"> (or "none" if you have your own key) Bye, 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 20.02 > A: Apache Torque Users List > Oggetto: Re: R: R: Newbie - Torque with DB2/AS400 new info > > Giulio, > > I was trying to run an init command thru my program and it > was giving all those SQL Exceptions. init command basically > adds a list of teams to the TEAM table. > Another command is like "add Jamie Martin Whitesox" > which adds Jamie Martin in the PITCHERS table and makes his > team to be Whitesox (which is a foreign key). Since Whitesox > or any other team wasn't there in the select and the > subsequent insert failed and I could see the Select SQL being > used in the stack trace. > > Then I manually entered the WhiteSox team in the TEAM table > and tried adding a pitcher again. Here is what I get now, > does this ring any bells : > > 34 [main] DEBUG dsfactory.TorqueDataSourceFactory - Setting > datasource property: url 250 [main] DEBUG > dsfactory.TorqueDataSourceFactory - Setting datasource > property: user 250 [main] DEBUG > dsfactory.TorqueDataSourceFactory - Setting datasource > property: password 250 [main] DEBUG > dsfactory.TorqueDataSourceFactory - Starting > initTorqueClassic 250 [main] DEBUG > dsfactory.TorqueDataSourceFactory - Setting datasource > property: defaultMaxConnections > 265 [main] DEBUG dsfactory.TorqueDataSourceFactory - Setting > datasource property: maxExpiryTime > 297 [main] DEBUG dsfactory.TorqueDataSourceFactory - Setting > datasource property: connectionWaitTimeout > 297 [main] DEBUG torque.Torque - Adding a dummy entry for > default, mapped onto t0064 > 359 [Thread-0] DEBUG oid.IDBroker - IDBroker thread was started. > 969 [main] DEBUG util.BasePeer - SELECT TEAM.TEAM_ID, > TEAM.TEAM_NAME FROM TEAM WHERE TEAM.TEAM_NAME='Whitesox' > 1172 [main] DEBUG util.BasePeer - Elapsed time=203 ms > org.apache.torque.TorqueException: IdGenerator for table > 'PITCHER' is null > at > org.apache.torque.util.BasePeer.doInsert(BasePeer.java:690) > at > com.suz.torque.pitchers.BasePitcherPeer.doInsert(BasePitcherPe > er.java:220) > at > com.suz.torque.pitchers.BasePitcherPeer.doInsert(BasePitcherPe > er.java:570) > at > com.suz.torque.pitchers.BasePitcher.save(BasePitcher.java:762) > at > com.suz.torque.pitchers.BasePitcher.save(BasePitcher.java:724) > at > com.suz.torque.pitchers.BasePitcher.save(BasePitcher.java:704) > at > com.suz.torque.PitcherStats.main(PitcherStats.java:105) > > > > > > > > > > > > > > > > > --- Sonu Vijay <[EMAIL PROTECTED]> wrote: > > Yeah its kinda tricky. I was thinking that since AS400 support is > > there in Torque, there might be some way to make it work. > > I'm still trying to make sure all cases are fine and > stuff. But not > > sure if I'm going in the right direction > > > > Vijay > > > > > > --- Giulio Vezzelli <[EMAIL PROTECTED]> > > wrote: > > > 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. > > __________________________________ > 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]
