geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Jencks (JIRA)" <j...@apache.org>
Subject [jira] Commented: (GERONIMO-4544) Error occured when repeatedly create DB or records
Date Thu, 05 Mar 2009 05:25:56 GMT

    [ 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.


Mime
View raw message