Re: RE: [JBoss-dev] Autogenerated primary keys etc
Ok, what i was looking for to hear about was the ability to support different databases auto-generated columns. I see the problem with it, just wanted to check if anyone had give it a try for some of the most popular databases... Guess i will wait for JDBC 3.0 :) /Lennart Den 2002-01-11 19:23:44 skrev Dain Sundstrom [EMAIL PROTECTED]: Here is the scoop. Last I checked Oleg was working on this for EJB 2.0, but I have trouble contacting him (our email servers don't like each other). The way it will be implemented is with a lookup in JNDI that returns an object that implements some yet to be defined AutoNumber interface. I think the initial revision uses a sequence table. I don't think we will be able to support auto-generated columns, as this requires special sql in the insert statement or special handling of the prepared statement object. When we start seeing JDBC 3.0 drivers, which support auto-generated columns, we will be able to add generic support. To make a long story short, it should be in JBoss 3.0 final. -dain ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
RE: RE: [JBoss-dev] Autogenerated primary keys etc
If you want to write the code for the most popular data bases, I'll attempt to write a plugable engine for it. -dain -Original Message- From: Lennart Petersson [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 3:18 AM To: [EMAIL PROTECTED] Subject: Re: RE: [JBoss-dev] Autogenerated primary keys etc Ok, what i was looking for to hear about was the ability to support different databases auto-generated columns. I see the problem with it, just wanted to check if anyone had give it a try for some of the most popular databases... Guess i will wait for JDBC 3.0 :) /Lennart Den 2002-01-11 19:23:44 skrev Dain Sundstrom [EMAIL PROTECTED]: Here is the scoop. Last I checked Oleg was working on this for EJB 2.0, but I have trouble contacting him (our email servers don't like each other). The way it will be implemented is with a lookup in JNDI that returns an object that implements some yet to be defined AutoNumber interface. I think the initial revision uses a sequence table. I don't think we will be able to support auto-generated columns, as this requires special sql in the insert statement or special handling of the prepared statement object. When we start seeing JDBC 3.0 drivers, which support auto-generated columns, we will be able to add generic support. To make a long story short, it should be in JBoss 3.0 final. -dain ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
Re: RE: [JBoss-dev] Autogenerated primary keys etc
Sound like a fucking stupid dummy question, but what the hell... What is having the best performance? 1) To let the DB generate next key using some kind of IDENTITY/SEQUENCE function? 2) To do like we do today and many others i guess, something like the HIGH/LOW key generator in Castor. We have a CMP EB that handle this table. Any ideas? Oleg, what have you seen in the Castor work? /Lennart Den 2002-01-14 19:11:05 skrev Dain Sundstrom [EMAIL PROTECTED]: Cool. I think we should look at using this post beta. -dain -Original Message- From: Oleg Nitz [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 10:23 AM To: Dain Sundstrom Subject: Re: [JBoss-dev] Autogenerated primary keys etc Dain Sundstrom wrote: If you want to write the code for the most popular data bases, I'll attempt to write a plugable engine for it. The code is already written in Castor and can be easily reused. There is KeyGenerator interface that can be used independently from other CastorJDO code. And the castor.jar is bundled with JBoss 3.0, isn't it? And Castor KeyGenerators are well tested, don't reinvent the wheel :) Oleg -dain ___ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development