IMO: this should be part of the integration tests of GF...
A simple script with asadmin commands can copy the drivers and
destroy-and-create all resources in Glassfish, so I suggest this to be
included in the Glassfish Hudson ...
- the idea is to copy several drivers to ext/lib and use this script
to create 1 jdbc realm for each DB.. you can also use ANSI SQL to
populate the users/roles tables and deploy a mini application and do
execute login for all realms..
IMHO: it is a must have integration test...
* I use the same in my project, and so far GF 3 b69 is able to honor
the script without problems - with MySql...
On Fri, Oct 30, 2009 at 6:45 AM, Richard Kolb <rjdkolb_at_gmail.com> wrote:
> Hi Judy
>
> 1) I tested the Oracle 11g (11.1) JDBC driver connecting to a 10g database.
> copied driver to glassfish/lib/ (not lib/ext)
> 2) Successfully created a connection pool
> 3) deployed an existing application that works on GlassFish 2.1
> 4) Nothing to report, works same as GF 2.1
>
> regards
> Richard
>
>
> 2009/10/30 Judy Tang <Judy.J.Tang_at_sun.com>
>>
>> Hi Fish & Cats,
>>
>> There is one thing you all can help us greatly. Could you please use
>> Admin GUI to
>> do the following tests with the database you have. Then please let us
>> know what database you
>> used and your test experience. If you don't have time to do (2), then if
>> you can help with (1)
>> it would be a big help already. Hope many of you use different databases,
>> that would be idea :-)
>>
>> (1) Go to Resources > JDBC > Connection Pools
>> Verify that we are able to create pools for all major databases (Oracle,
>> MySQL, DB2, Sybase, MSSQL, PostgreSQL...)
>> Verify ping function
>>
>>
>> (2) Go to Resources > JDBC > JDBC Resource
>> Verify that we are able to use the resources from a sample application
>>
>> Thanks so much, looking forward to hearing from you !
>> Judy
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: quality-unsubscribe_at_glassfish.dev.java.net
>> For additional commands, e-mail: quality-help_at_glassfish.dev.java.net
>>
>
>
--
Looking for a client application for this service:
http://fgaucho.dyndns.org:8080/arena-http/wadl