NetWeaver and RETURN_GENERATED_KEYS

[Former Member]

Whenever I attempt to create a PreparedStatement that returns generated keys I get an AbstractMethodError. I assume that is because my setup of NetWeaver does not support JDBC 3.0. I'm running java 1.4.2_08 on the server.

Does anyone know if there is a workaround to support this functionality or if there are plans to support it in the future?

I'm connecting to SQL Server and have tried the jTDS driver as well as the SQL Server driver.

[Former Member · Accepted solution]

Tom,

JDBC 3.0 <b>API</b> is part of Java itself, JDBC 3.0 <b>implementation</b> is responsibility of concrete JDBC driver.

The default data source in WebAS Java uses SAP OpenSQL JDBC driver. It's anything but practical for application development. So you have to:

1. Find JDBC 3.0 compliant driver for your database. Check DB vendor site first -- typically you can find quite descent driver here.

2. Using VisualAdministrator register your new driver with type Vendor SQL or Native SQL.

3. Using VisualAdministrator register new data source that uses driver created in [2]

4. In application use data source created in [3]

Valery Silaev

SaM Solutions

http://www.sam-solutions.net

[Former Member]

Thank you.