[
https://issues.apache.org/jira/browse/GERONIMO-4544?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12678197#action_12678197
]
Ivan commented on GERONIMO-4544:
--------------------------------
If I did the steps accroding to the description, I could not view the content
of the table's content via the admin console. I guess that a inner transaction
is not closed while some errors occured in the executing the SQL commands.
Thanks for any comment !
> 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
> 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.
