[ http://issues.apache.org/jira/browse/DAYTRADER-14?page=comments#action_12438524 ] Piyush Agarwal commented on DAYTRADER-14: -----------------------------------------
Matt, Chris, David DatabaseMetaData is implemented by JDBC drivers and allows you to check which DB you are working against. Based on that db-specific SQL statements for dropping, creating the tables, indexes etc can be executed. Creating the Database via JDBC is not supported by most databases and so that will still need to be created by hand. In spite of the above tiny shortcoming, this will make the Daytrader app a lot more self-contained and still open to work on all the different app servers. > 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
