dev@glassfish.java.net

Re: Using a different Java DB database at Runtime (vs. design-time)

From: John Baker <John.Baker_at_Sun.COM>
Date: Fri, 31 Aug 2007 13:10:19 -0700

cc'ing Glassfish dev to see if I can get an answer :-)

John Baker wrote:
> In the Java DB settings dialog, a user can change the
> Java DB database path used for storing databases.
> However, if the database was created on the Java DB bundled with
> Glassfish then at runtime the user
> wanted to switch from the database referred in NetBeans to a
> database in Glassfish.
>
> To solve this the user set the DatabaseName property of a connection pool
> to the full path of the Java DB database path + database name.
> (See below)
>
> This seems like a hidden feature.
>
> Is there a better or recommended way to switch to use Java DB
> databases in Glassfish for use at runtime ?
>
>
> From user:
>
> "As it turns out I managed to get the application working by adding a
> new JDBC
> Resource called dataSource which used the pre-existing Connection Pool
> derby_netPool (DatabaseName property was adjusted so it included the
> absolute path to the DB). There is an attached screenshot included which
> shows this SJSAS Admin Console.
>
> http://www.nabble.com/file/p12380112/Glassfish%2BAdmin%2BConsole.TIF
> Glassfish Admin Console "
>
> Thanks,
> John
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe_at_db.netbeans.org
> For additional commands, e-mail: dev-help_at_db.netbeans.org
>