geronimo-dev mailing list archives

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

    [ https://issues.apache.org/jira/browse/GERONIMO-4544?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12678560#action_12678560
] 

Ivan commented on GERONIMO-4544:
--------------------------------

Hi, Jarek:
    I always recover the autocommit to true when finishing the operation on that connection
in the past, or it will force the other user using this connection (assume there is a pool
behind) to call commit action to submit their updates. I found that set action is removed
in the submit patch. Does Geronimo have any extra setting for it ? 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
>            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