[
https://issues.apache.org/jira/browse/TUSCANY-1353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ron Gavlin reopened TUSCANY-1353:
---------------------------------
This problem seems to appear when using DataDirect JDBC drivers. The problem
may very well be with the DataDirect JDBC drivers themselves. Nevertheless,
many popular application servers either officially support these JDBC drivers
(IBM WebSphere 6.1 - see
http://www-1.ibm.com/support/docview.wss?rs=180&uid=swg27007663) (JBoss - see
http://dataconnectnow.com/2006/12/only-jboss-certified-jdbc-driver.html) or
actually embed these drivers (BEA WebLogic). If a workaround for this problem
is not found, folks using these popular platforms will have an extremely bad
experience trying to use the DAS.
> 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]
