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