You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by "Robert S. Sfeir" <ro...@codepuccino.com> on 2003/02/23 17:34:20 UTC
Can someone please explain why...
Ok So I'm trying to insert a record in a table which has foreignkeys
defined to 2 tables, and for a while there it kept failing with a
message saying the transaction could not be committed the lock failed
for Batch 0.
So I dug my heels in and figured it out, but I don't understand why OJB
doesn't do this auto:
Tables involved:
Homes
homeID
Collection reference to BrokersToHomes
Brokers
brokerID
Collection reference to BrokersToHomes
BrokersToHomes
recordID (prim key auto increment)
brokerID
homeID
foreignkey reference to Homes homeID
foreignkey reference to Brokers homeID
When I first tried to insert data in BrokersToHomes it kept failing.
Then on a hunch, before I did the insert I did:
BrokersToHomes bth = new BrokersToHomes();
bth.setBroker(broker);//Added this which I already had in memory
bth.setHome(home);//Added this which comes from selecting a Home
bth.setBrokerID(broker.getBrokerID());
bth.setHomeID(home.getHomeID());
Then called the insert which basically submits bth for insert.
That worked.
So my question is:
Why do I have to set the Broker and Home objects if I am submitting a
BrokerID and HomeID? Why can't OJB just figure that out for itself?
I'm using the ODMG API as usual.
While this works, it just seems like overhead for me to have to select
a Home object and a Broker object then do the insert. I worked around
it of course by storing the Home object is a session scope so I don't
have to re select it every time the user wants to insert a new Broker
relationship.
There also doesn't seem to be any code examples on the site on how to
do this, and had to guess at it based on previous experiences I had to
go through when I was doing updates, which also needs to have an object
selected first, and then updated.
Thanks.
R
P.S. A VERY cool feature is that when you insert a record in any
table, the primary key if autogenerated gets auto populated to the
object being inserted... now THAT I really dig.
--
Robert S. Sfeir
Senior Java Engineer
Codepuccino, Inc.
robert@codepuccino.com
definition - Codepuccino n:
A Little JSP mixed with lots of Java, usually served with Servlets, a
Datasource, a sprinkle of XML, and sometimes EJB. (See Great MVC
Frameworks)