[ 
https://issues.apache.org/jira/browse/TUSCANY-1353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ron Gavlin closed TUSCANY-1353.
-------------------------------

    Resolution: Invalid

Upgraded JDBC driver should fix the problem.

> 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]

Reply via email to