Thanks Felipe for the input we value. We do have this kind automated
tests using CLI commands.
But in Admin GUI, we have not yet automated this, since we do GUI
automation after
GUI freeze, so it is manual testing in this area for now. We tested
this area and it is working for us, now we like to
have more people try on different databases to make this area solid.
Is Admin GUI working fine for you on MySql ? Many thanks if you could
let us know :-)
Judy
Felipe Gaścho wrote:
> 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
>>>
>>>
>>
>
>
>
>