geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Piyush Agarwal (JIRA)" <...@geronimo.apache.org>
Subject [jira] Commented: (DAYTRADER-14) Include sql script in the ear and use a gbean to create tables etc
Date Thu, 19 Oct 2006 19:24:35 GMT
    [ http://issues.apache.org/jira/browse/DAYTRADER-14?page=comments#action_12443624 ] 
            
Piyush Agarwal commented on DAYTRADER-14:
-----------------------------------------

Matt, thanks for the headsup and valuable insight. So inorder to keep things simple and not
have to change the logic inside the KeySequnceBeans and also avoid catching the DuplicateKeyExceptions
I propose doing the following -- Drop and Recreate the tables, at end of that the user will
get a prominent message to Stop and Restart their application and then use the link to Repopulate
the daytrader database.

Since the user will be recycling his environment before the repopulation of the tables the
SLSBs will get recycled and the DuplicateKeyExceptions will be avoided.

Thoughts??

> Include sql script in the ear and use a gbean to create tables etc
> ------------------------------------------------------------------
>
>                 Key: DAYTRADER-14
>                 URL: http://issues.apache.org/jira/browse/DAYTRADER-14
>             Project: DayTrader
>          Issue Type: Improvement
>          Components: EJB Tier
>    Affects Versions: 1.2
>            Reporter: David Jencks
>         Attachments: d-j-plan.xml, DAYTRADER-14.patch
>
>
> You can use the DatabaseIntitializationGBean (GERONIMO-2396) in a g. plan and include
the sql script in the ejb module so the database will get created if not already present.
This is way better than the previous hack of including a pre-built database in the car file.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message