simple problem with Ms Access

Thread view:

steven acer - 23 Nov 2006 12:49 GMT

hello
im building a webapp wit hMs Access as a backend database.
The problem is that im unable to retieve auto-generated keys values
after i do an insert operation.
correct me if i was wrong, but auto-generated key values mean the
autonumber column values NOT the rowIDs right ?
i dont know if jdbc-odbc for access supports this, i just need a clue
on what to do !

thanks

Reply to this Message

Arne Vajhøj - 23 Nov 2006 14:28 GMT

> im building a webapp wit hMs Access as a backend database.

Bad idea.

The JDBC ODBC bridge is not suited for multithreaded apps
like web apps.

> The problem is that im unable to retieve auto-generated keys values
> after i do an insert operation.
> correct me if i was wrong, but auto-generated key values mean the
> autonumber column values NOT the rowIDs right ?

Correct.

> i dont know if jdbc-odbc for access supports this, i just need a clue
> on what to do !

I don't know whether stmt.getGeneratedKeys but @@IDENTITY in
SQL will work.

Arne

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...