[jira] Updated: (TUSCANY-1353) Exception attempting to insert rows using DAS w/DataDirect JDBC driver
[ https://issues.apache.org/jira/browse/TUSCANY-1353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Luciano Resende updated TUSCANY-1353: - Fix Version/s: Java-DAS-Next Patch Info: [Patch Available] > 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]
[jira] Updated: (TUSCANY-1353) Exception attempting to insert rows using DAS w/DataDirect JDBC driver
[ https://issues.apache.org/jira/browse/TUSCANY-1353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Luciano Resende updated TUSCANY-1353: - Affects Version/s: Java-DAS-Next > 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]
[jira] Updated: (TUSCANY-1353) Exception attempting to insert rows using DAS w/DataDirect JDBC driver
[ https://issues.apache.org/jira/browse/TUSCANY-1353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Amita Vadhavkar updated TUSCANY-1353: - Attachment: 1353.patch patch dated Jul 25 based on http://www.mail-archive.com/tuscany-dev@ws.apache.org/msg20715.html > 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 > 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 > 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]
[jira] Updated: (TUSCANY-1353) Exception attempting to insert rows using DAS w/DataDirect JDBC driver
[ https://issues.apache.org/jira/browse/TUSCANY-1353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Amita Vadhavkar updated TUSCANY-1353: - Attachment: 1353.patch Please see details posted on http://www.mail-archive.com/tuscany-dev@ws.apache.org/msg19752.html thread > 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 > 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 > Attachments: 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]
[jira] Updated: (TUSCANY-1353) Exception attempting to insert rows using DAS w/DataDirect JDBC driver
[ https://issues.apache.org/jira/browse/TUSCANY-1353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jean-Sebastien Delfino updated TUSCANY-1353: Component/s: Java DAS RDB > 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 > Environment: Windows XP, WebLogic 8.1SP6, Sybase 12.5, DataDirect > Sybase JDBC driver (embedded within BEA WebLogic) >Reporter: Ron Gavlin >Priority: Critical > > 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]
[jira] Updated: (TUSCANY-1353) Exception attempting to insert rows using DAS w/DataDirect JDBC driver
[ https://issues.apache.org/jira/browse/TUSCANY-1353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ron Gavlin updated TUSCANY-1353: Description: 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 was: 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 Environment: Windows XP, WebLogic 8.1SP6, Sybase 12.5, DataDirect Sybase JDBC driver (embedded within BEA WebLogic) (was: Windows XP, WebLogic 8.1SP6, Sybase 12.5, WebLogic Sybase JDBC driver) Summary: Exception attempting to insert rows using DAS w/DataDirect JDBC driver (was: Exception attempting to insert rows using DAS w/BEA WebLogic Sybase JDBC driver (BEA WebLogic 8.1 SP6)) > 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 >Affects Versions: Java-DAS-M2 > Environment: Windows XP, WebLogic 8.1SP6, Sybase 12.5, DataDirect > Sybase JDBC driver (embedded within BEA WebLogic) >Reporter: Ron Gavlin >Priority: Critical > > 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: > BE