geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Christopher James Blythe (JIRA)" <...@geronimo.apache.org>
Subject [jira] Commented: (DAYTRADER-14) Include sql script in the ear and use a gbean to create tables etc
Date Tue, 26 Sep 2006 18:59:50 GMT
    [ http://issues.apache.org/jira/browse/DAYTRADER-14?page=comments#action_12437908 ] 
            
Christopher James Blythe commented on DAYTRADER-14:
---------------------------------------------------

David... this sounds great for use on Geronimo. However, we will still need a method for creating
the database tables and indexes on other app servers like JBoss, WebLogic, WebSphere, etc.

As a side note, the commands needed to create the tables and indexes are SQL statements themselves
and could be executed within the application as JDBC statements. Just brain storming here...
we could hook into the buildDB servlet action which populates the database or we could provide
another link on the config page to execute the code to create the tables. Once the database
is created and we have sufficeint access rights, we should be good to go. The only obsticle
I can think of would be if there are any specifics that we need to account for in the schemas
for various database vendors (ie. Derby, Oracle, DB2, etc.).

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