[
https://issues.apache.org/jira/browse/GERONIMO-4544?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12679079#action_12679079
]
David Jencks commented on GERONIMO-4544:
----------------------------------------
While resetting autocommit won't hurt anything its not necessary either. When
the connection gets put back in the pool a cleanup method is called to make
sure its in a known state and in particular it resets autocommit. If you
aren't using the tranql wrappers but some other jdbc-jca wrapper this might not
have been implemented correctly but with tranql I'm pretty sure it's working
well.
> Error occured when repeatedly create DB or records
> --------------------------------------------------
>
> Key: GERONIMO-4544
> URL: https://issues.apache.org/jira/browse/GERONIMO-4544
> Project: Geronimo
> Issue Type: Bug
> Security Level: public(Regular issues)
> Components: console
> Affects Versions: 2.1.4
> Environment: JAVA5 + RHEL 5.3 (X86) + Firefox 3.0.5
> Reporter: lily seattle
> Assignee: Jarek Gawor
> Fix For: 2.1.4, 2.2
>
> Attachments: Geronimo-4544-for2.1.patch, Geronimo-4544-forTrunk.patch
>
>
> steps:
> 1. login console
> 2. Click Embedded DB -> DB Manager.
> 3. Filling the Create DB blank with TestDB, click Create.
> 4.Create a table using:
> CREATE TABLE CUSTOMER (
> ID INTEGER NOT NULL PRIMARY KEY,
> NAME VARCHAR(45),
> BIRTHDATE DATE,
> SSS_NO VARCHAR(25),
> ADDRESS VARCHAR(60),
> ANNUAL_SALARY DOUBLE,
> LOAN_AMOUNT DOUBLE
> );
> 5. Insert a record:
> INSERT INTO CUSTOMER VALUES
> (001，'hi','02/19/2009','111','somewhere',100,150);
> Now, if create the same table again, or Insert the same record, errors will
> occur. Also the Table can't be accessed
> any more.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
