geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "lily seattle (JIRA)" <j...@apache.org>
Subject [jira] Created: (GERONIMO-4544) Error occured when repeatedly create DB or records
Date Thu, 19 Feb 2009 08:49:01 GMT
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.


Mime
View raw message