users@glassfish.java.net

Re: Ambiguous MySQL Connection Pool Creation

From: Jagadish Prasath Ramu <Jagadish.Ramu_at_Sun.COM>
Date: Fri, 10 Nov 2006 12:23:48 +0530

Thanks a lot Behi,
I have filed 2 issues.
https://glassfish.dev.java.net/issues/show_bug.cgi?id=1460
https://glassfish.dev.java.net/issues/show_bug.cgi?id=1461

-Jagadish

On Fri, 2006-11-10 at 00:58 +0330, Behrang Saeedzadeh wrote:
> One more thing :-)
>
> In the "New Connection Pool (Step 1 of 2)" page, create a new
> connection pool as follows:
>
> Name: Test
> Resource Type: javax.sql.DataSource
> Database Vendor: mysql
>
> and press "Next". Now you should be in "New Connection Pool (Step 2 of
> 2)". Press "Previous".
>
> Change the "Database Vendor" to "Oracle" and press next. Once again,
> press "Previous". Now change the "Resource Type" to
> "javax.sql.ConnectionPoolDataSource". Press "Next". Once again press
> "Previous". Now change the Database Vendor back to mysql. Press
> "Next".
>
> Now, the "Datasource Classname" is filled with wrong value:
> "oracle.jdbc.pool.OracleConnectionPoolDataSource".
>
> Tested with Firefox 2.0 and IE 6.0 under Windows XP. Glassfish Version: 9.0 V1.
>
> Also, I think, from an aesthetics point of view, it would be better to
> use MySQL instead of mysql and, probably, Microsoft SQL Server instead
> of mssql.
>
> With best wishes,
> Behi
>
> On 11/10/06, Behrang Saeedzadeh <behrangsa_at_gmail.com> wrote:
> > Hi,
> >
> > When I select "javax.sql.DataSource" as the type of the connection
> > pool I'm going to create, the "DataSource Classname" field's value is
> > filled with "com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource"
> > but when I select "javax.sql.ConnectionPoolDataSource" as the type of
> > the connection pool, the "Datasource Classname" field's value is left
> > blank. This is a little bit confusing. I thought by selecting
> > javax.sql.ConnectionPoolDataSource, the "Datasource Classname" field's
> > value would become
> > "com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource" (which
> > isn't and is left blank) and by selecting "javax.sql.DataSource" as
> > the type of the pool, I would get
> > "com.mysql.jdbc.jdbc2.optional.MysqlDataSource" (which I don't and
> > instead I get the
> > "com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource").
> >
> > Am I missing something or is this possibly a bug?
> >
> > Best regards,
> > Behi
> >
> > --
> > "Science is a differential equation. Religion is a boundary condition"
> > - Alan Turing
> >
> > Behrang Saeedzadeh
> > http://www.jroller.com/page/behrangsa
> > http://my.opera.com/behrangsa
> >
>
>