I'm still using Oracle and I'm getting closer, but the IDBroker is still causing me
headaches. Below I have a bunch of relevant info about my set up. Any ideas? Thanks
again! -Ryan
Now when I call save() i get the following error:
org.apache.torque.TorqueException: IdGenerator for table 'PERSON' is null
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:690)
...
I have searched the mail archive and found that previous people with this problem had
the adapter set up incorrectly, however my config for oracle is:
torque.database.default=ryan_test
torque.database.ryan_test.adapter=oracle
The following code throws the error (the first lines are to verify that my connection
is working.. it is):
Person person1 = new Person();
person1 = PersonPeer.retrieveByPK(new NumberKey(1));
_log.info("Person1:" + person1.getfName());
person1.setfName("Ryan");
person1.setlName("Clifton");
person1.setNew(true);
person1.setModified(true);
--> person1.save();
Here is what I get in the logs:
931 [main] DEBUG torque.Torque - Adding a dummy entry for default, mapped onto
ryan_test
.1212 [Thread-3] DEBUG oid.IDBroker - IDBroker thread was started.
3846 [main] DEBUG util.BasePeer - SELECT PERSON.ID, PERSON.FNAME, PERSON.LNAME
FROM PERSON WHERE PERSON.ID=1
3876 [main] DEBUG util.BasePeer - Elapsed time=30 ms
4026 [main] INFO testcase.TorqueTestCase - Person1:com.win.core.dao.Person@1f
E..
Time: 3.074
There was 1 error:
1) testPersonDBO(com.win.core.testcase.TorqueTestCase)
org.apache.torque.TorqueException: IdGenerator for table 'PERSON' is null
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:690)
at com.win.core.dao.BasePersonPeer.doInsert(BasePersonPeer.java:216)
at com.win.core.dao.BasePersonPeer.doInsert(BasePersonPeer.java:565)
at com.win.core.dao.BasePerson.save(BasePerson.java:695)
at com.win.core.dao.BasePerson.save(BasePerson.java:657)
at com.win.core.dao.BasePerson.save(BasePerson.java:637)
at com.win.core.testcase.TorqueTestCase.testPersonDBO(TorqueTestCase.jav
a:67)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at com.win.core.testcase.TorqueTestCase.main(TorqueTestCase.java:28)
FAILURES!!!
Tests run: 3, Failures: 0, Errors: 1
-----Original Message-----
From: Quinton McCombs [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 10:33 AM
To: Turbine Users List
Subject: RE: Using IDBroker with existing Oracle sequences
Existing oracle sequences? Hmmm... Torque picks the name of the
sequence to use for each table for you. The format is SEQ_<table_name>.
You can get around this by creating synonyms if you can't change the
names but must still use them.
> -----Original Message-----
> From: Ryan Clifton [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 21, 2003 12:17 PM
> To: [EMAIL PROTECTED]
> Subject: Using IDBroker with existing Oracle sequences
>
>
> Hello,
>
> I have recently installed the stand-alone Torque distribution
> and have basically gotten everything working.. except one
> critical piece. I can't for the life of me figure out how to
> get the IDBroker to link to my existing Oracle sequences and
> use them. I've been searching the internet for a few hours
> and while I've seen plenty of people who say 'use the native
> setting on IDBroker', I've can't find any instructions on how
> to actually set it up.
>
> If you could point me in the right direction or explain how
> to go about doing what I want, I would really appreciate it.
>
> Just to explain a bit more of where I am:
>
> I used the 'jdbc' task to reverse my database into XML. I
> then generated my Torque java classes. I can select existing
> records, so I know that my db connections are working. When
> I insert, I currently get an error stating that the primary
> key is 'null'. I was expecting the save() method to
> automatically fill this in. I've read and figured out how to
> get around that by setting 'setNew(true)' and then it will go
> to the IDBroker. Then I was thinking, how on earth will the
> IDBroker know where to go to get the sequence number? So
> that's where I am..
>
> Thanks!
>
> Ryan Clifton
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
