ExecuteUpdate is not supported by JDBC

[Former Member]

Exact error:

"method executeUpdate(String) is not supported by open jdbc".

Any ideas how to solve this? We have tried the method "execute" too, but it results in the same error.

I'm little sure we've used this successfully before..

Any ideas would be appreciated.

Adri

[former_member186016 · Accepted solution]

Hi Adri,

Following link shows supported methods from java.sql.Statement.

http://help.sap.com/saphelp_nw04s/helpdata/en/57/666284c1b148a0b38bdf5d4e8da0ad/frameset.htm

Interestingly it list the method executeUpdate(String) and exexute are supported by OpenSQL.

Which SAP AS version, ... DB and its version are you using ? May be there has been update in newer java versions on this !

Regards,

Ashwani Kr Sharma

[Former Member · Accepted solution]

Hi, I'm using the Sneak Preview, downloaded from

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/downloaditem?rid=/library/uuid/cfc19866-0401-0010-35b2-dc8158247fb6">https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/downloaditem?rid=/library/uuid/cfc19866-0401-0010-35b2-dc8158247fb6</a>

(SAP NetWeaver 2004s Java Trial Version SP9)

[former_member186016 · Accepted solution]

It seems to be something with support from JDBC(version..). I have seen this NOT SUPPORTED message while using batches in some cases, but haven't seen for method execute() yet.

Can you install the SAP NetWeaver Application Server available on the same page you mentioned separately. Then try this method !

Regards,

Ashwani Kr Sharma

[Former Member]

I've solved this problem by using batches:

stmt.addBatch();

stmt.executeBatch();

Thanks for your help.