Hi Luciano,
I think the test case CheckSupportGeneratedKeys.java from the patch file is
missing
in the svn trunk, will you please check?
Regards,
Amita
On 7/26/07, Luciano Resende (JIRA) <tuscany-dev@ws.apache.org> wrote:
[
https://issues.apache.org/jira/browse/TUSCANY-1353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel]
Luciano Resende resolved TUSCANY-1353.
--------------------------------------
Resolution: Fixed
Patch applied under revision #559580. Thanks Amita.
> Exception attempting to insert rows using DAS w/DataDirect JDBC driver
> ----------------------------------------------------------------------
>
> Key: TUSCANY-1353
> URL: https://issues.apache.org/jira/browse/TUSCANY-1353
> Project: Tuscany
> Issue Type: Bug
> Components: Java DAS RDB
> Affects Versions: Java-DAS-M2, Java-DAS-Next
> Environment: Windows XP, WebLogic 8.1SP6, Sybase 12.5,
DataDirect Sybase JDBC driver (embedded within BEA WebLogic)
> Reporter: Ron Gavlin
> Assignee: Amita Vadhavkar
> Priority: Critical
> Fix For: Java-DAS-Next
>
> Attachments: 1353.patch, 1353.patch
>
>
> Greetings,
> I am having problems inserting rows with Tuscany DAS M2 using the BEA
WebLogic Sybase JDBC driver (DataDirect Connect for JDBC 3.6 June 2007))
which is an embedded version of the popular DataDirect JDBC driver. Although
I have not tested it, I suspect this problem appears in non-Sybase versions
of the driver as well. The code below generates the listed stacktrace. Note:
BEA apparently renames the DataDirect Connect for JDBC classes as part of
its embedding process.
> ...
> 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.
> The DataDirect Connect for JDBC drivers are either supported or embedded
into numerous commercial application servers, including IBM WebSphere 6.1,
jBoss 4.x, and BEA WebSphere. Folks using these platforms are likely to
quickly hit this problem if they attempt to use the DAS.
> - 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]
