I am attaching a patch with this email since JIra patch attachment does not seem to be working.
The reason for the new patch is the following errors I got
when I ran the junit tests:
1)
testExecuteUpdateNoAutoGenColumnName(org.apache.derbyTesting.functionTests.tests.jdbcapi.StatementJdbc30Test)junit.framework.ComparisonFailure:
Unexpected SQL state. expected:<...E> but was:<...F>
at
org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:624)
at
org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:673)
at
org.apache.derbyTesting.functionTests.tests.jdbcapi.StatementJdbc30Test.assertFailedExecuteUpdate(StatementJdbc30Test.java:235)
at
org.apache.derbyTesting.functionTests.tests.jdbcapi.StatementJdbc30Test.testExecuteUpdateNoAutoGenColumnName(StatementJdbc30Test.java:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at
org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:95)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.extensions.TestSetup.run(TestSetup.java:23)
at
org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
Caused by: java.sql.SQLException: Table 'TAB1' does not have an
auto-generated column named 'I'.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown
Source)
at
org.apache.derbyTesting.functionTests.tests.jdbcapi.StatementJdbc30Test.testExecuteUpdateNoAutoGenColumnName(StatementJdbc30Test.java:176)
... 31 more
Caused by: java.sql.SQLException: Table 'TAB1' does not have an
auto-generated column named 'I'.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
... 41 more
Caused by: ERROR X0X0F: Table 'TAB1' does not have an auto-generated
column named 'I'.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.sql.execute.InsertResultSet.verifyAutoGeneratedColumnsNames(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
... 35 more
On 7/26/07, Ramin Moazeni (JIRA) <[EMAIL PROTECTED]> wrote:
>
> [
> https://issues.apache.org/jira/browse/DERBY-2942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12515879
> ]
>
> Ramin Moazeni commented on DERBY-2942:
> --------------------------------------
>
> Hi Kathey,
>
> no problem. Please feel free to check it in with your changes.
>
> Thanks
> Ramin
>
>
>
> > Convert jdbcapi/statementJdbc30.java to JUnit
> > ---------------------------------------------
> >
> > Key: DERBY-2942
> > URL: https://issues.apache.org/jira/browse/DERBY-2942
> > Project: Derby
> > Issue Type: Task
> > Components: Test
> > Reporter: Ramin Moazeni
> > Assignee: Ramin Moazeni
> > Attachments: DERBY-2942v0.diff, DERBY-2942v0.stat, DERBY-2942v1.diff
> >
> >
>
>
> --
> This message is automatically generated by JIRA.
> -
> You can reply to this email to add a comment to the issue online.
>
>
DERBY-2942v3.diff
Description: Binary data
DERBY-2942v3.stat
Description: Binary data
