ts Users Mailing List"
Sent: Monday, January 31, 2005 7:57 AM
Subject: Re: Another ODBC OT Question
> Depends on your database. Most db's like MaxDB, Oracle and so on which
> support sequences can retreive the current value of the sequence after
> it has been used.
> Usuall
Depends on your database. Most db's like MaxDB, Oracle and so on which
support sequences can retreive the current value of the sequence after
it has been used.
Usually something along the lines of .CURRVAL for Oracle. Typically
you can only use it if you've used the sequence in the first place
Thanks for the post. I didn't realize MySQL had implemented so much of
JDBC 3. A standard API for retrieval of RDBMS-generated keys rocks! This
on top of the recent improvements in driver performance. Awesome.
Erik
Brandon Mercer wrote:
Erik Weber wrote:
Sorry for all those local disk links and
Erik Weber wrote:
Sorry for all those local disk links and other junk. Cut and paste.
Thanks everyone this article
http://dev.mysql.com/tech-resources/articles/autoincrement-with-connectorj.html
was the ticket for me. We all know how it gets when you're writing code
all day long and you start t
Sorry for all those local disk links and other junk. Cut and paste.
Erik
Erik Weber wrote:
You use MySQL's AUTO_INCREMENT function (then omit the value
during an insert and MySQL will insert it for you) and related
syntax, which is all covered in the manual:
You use MySQL's AUTO_INCREMENT function (then omit the value
during an insert and MySQL will insert it for you) and related
syntax, which is all covered in the manual:
21.2.12.3 How to Get the Unique ID for the Last Inserted Row
If you insert a record
ruts Users Mailing List
Subject: [OT] Re: Another ODBC OT Question
I googled this:
http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=GGLD,GGLD:2004-
11,GGLD:en&q=jdbc+mysql+auto%5Fincrement
and found this:
http://dev.mysql.com/tech-resources/articles/autoincrement-with-connec
thing.
Brandon Mercer <[EMAIL PROTECTED]>
01/27/2005 01:17 PM
Please respond to
"Struts Users Mailing List"
To
Struts Users Mailing List
cc
Subject
Re: Another ODBC OT Question
Barnett, Brian W. wrote:
>What rdbms are you using?
>
>
Sorry, that would hav
Barnett, Brian W. wrote:
What rdbms are you using?
Sorry, that would have been helpful huh! lol MySQL Connector/J
(obviously) 3.0.x. I think I know how to get the last id... but do I
create another insert the same way I did the first?
Thanks,
Brandon
What rdbms are you using?
-Original Message-
From: Brandon Mercer [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 10:56 AM
To: Struts Users Mailing List
Subject: Another ODBC OT Question
Hello,
Ok, I've got another off topic question :-P. That's two in a day!
Thr
Hello,
Ok, I've got another off topic question :-P. That's two in a day!
Three strikes and I'm out. lol Anyhow, I am inserting information into
a database and I need to get the auto_increment value from my first
insert and use the value it returns to create an entry in another
table. Does
11 matches
Mail list logo
