Exception attempting to insert rows using DAS w/BEA WebLogic Sybase JDBC driver
(BEA WebLogic 8.1 SP6)
------------------------------------------------------------------------------------------------------
Key: TUSCANY-1353
URL: https://issues.apache.org/jira/browse/TUSCANY-1353
Project: Tuscany
Issue Type: Bug
Affects Versions: Java-DAS-M2
Environment: Windows XP, WebLogic 8.1SP6, Sybase 12.5, WebLogic Sybase
JDBC driver
Reporter: Ron Gavlin
Priority: Critical
Greetings,
I am having problems inserting rows with Tuscany DAS M2 using the BEA WebLogic
Sybase JDBC driver (BEA WebLogic 8.1 SP6). The code below generates the
following stacktrace:
...
Command insert = das.createCommand("insert into Test (testCol1, testCol2)
values (?, ?)");
insert.setParameter(1, "str1");
insert.setParameter(2, "str2");
insert.execute();
Stacktrace:
Caused by: java.sql.SQLException: [BEA][Sybase JDBC Driver]No rows affected.
at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
at weblogic.jdbc.base.BaseException.getException(Unknown Source)
at weblogic.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
at weblogic.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
at
weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:159)
at
org.apache.tusany.das.rdb.impl.Statement.executeUpdate(Statement.java:173)
at
org.apache.tusany.das.rdb.impl.Statement.executeUpdate(Statement.java:133)
at
org.apache.tusany.das.rdb.impl.InsertCommandImpl.execute(InsertCommandImpl.java:44)
While interactively debugging
org.apache.tuscany.das.rdb.impl.ConnectionImpl.prepareStatement(String
queryString, String[] returnKeys), I noticed if I manually change the boolean
member variable useGetGeneratedKeys to false, no exception is generated and the
insert works as designed. What is the correct fix here?
- Ron
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
