Hi Steve!
That is a quite sweet function. I'll try it out as soon as I can when comming to work tomorrow.
Thanks for the tip
Regards Roland Carlsson
----- Original Message ----- From: "Steve Kirk" <[EMAIL PROTECTED]>
To: "'Tomcat Users List'" <[EMAIL PROTECTED]>
Sent: Wednesday, October 27, 2004 6:20 PM
Subject: RE: GlobalNamingResouces used by other GlobalNamingResources
I've just noticed another (more elegant) solution from another post, and will be changing my code to use it. As long as your database driver supports it, try using statement.getGeneratedKeys()
I got this example from
http://www.datadirect.com/products/jdbc/docs/jdbc30feats/index.ssp
Int rowcount = stmt.executeUpdate (
"insert into LocalGeniusList (name) values ('Karen'),
"employeeID");
ResultSet rs = stmt.getGeneratedKeys (); // Karen's employeeID value is now
available
-----Original Message----- From: Steve Kirk [mailto:[EMAIL PROTECTED] Sent: Wednesday 27 October 2004 13:29 To: 'Tomcat Users List' Subject: RE: GlobalNamingResouces used by other GlobalNamingResources
OK now I see your problem. I have the same issue. I've worked around it with a bit of a hack I'm afraid, and just used the MySQL non-jdbc solution. As you say I will pay the price for this sin later, if I ever need to swap database. However I've taken a view that for my specific situation, this is unlikely in the medium term. So instead of investing time in making the code completely portable to another database, I've invested time in mitigating the impact by genericising my code so that there is only one place I will need to make changes. (Essentially, I've beanified all my database tables so that I have a single method that creates rows in any table in the database and returns the ID).
I think portability and re-use are worth investing time and effort in, but there is a limit to that, and sometimes, you need to make compromises and move on, otherwise you can spend days trying to work around a problem that might never happen.
> -----Original Message----- > From: Roland Carlsson [mailto:[EMAIL PROTECTED] > Sent: Wednesday 27 October 2004 13:03 > To: TomcatUsers > Subject: Sv: GlobalNamingResouces used by other GlobalNamingResources > > > Hi Steve and thanks for you answer. > > Try the following scenario. > > The problem is to get back the primary key when doing an > insert. Say that > you have a master/slave relation between two tables. > > You insert a row into master. Then you are going to insert a few rows > connected to the master into slave. How do you know the > id-number of your > master? > > I know that mysql has a non-jdbc soloution for this but since > one of our > general design goals are portable code...... So, we have > desided to take the > same apporach as Object-Relational Bridge. We created our own > id-generator > to handle the problem. But its has created a new set of > problems now when we > are going to use multiple web-apps and (in a not so distant > future) mutiple > servers. > > Regards > Roland Carlsson > > > > > Den 04-10-27 13.48, skrev "Steve Kirk" > <[EMAIL PROTECTED]>: > > > sorry, can't answer specific Q on whether you can access > datasource from > > generator. but it sounds like you are trying to uniquely > ID rows in a > > database? > > > > if so then the simplest way seems to be to use > auto_increment fields and let > > the database handle it. or are you saying that that isn'y > working - is this > > what you mean by "not supporting the database-generated > id-numbers"? if so > > please say more about why its not working. what database? > code sample? > > > --------------------------------------------------------------------- > 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]
--------------------------------------------------------------------- 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]
