users@glassfish.java.net

Re: Ambiguous MySQL Connection Pool Creation

From: Behrang Saeedzadeh <behrangsa_at_gmail.com>
Date: Fri, 10 Nov 2006 14:39:41 +0330

Thanks Jagadish,

With best wishes,
Behi

On 11/10/06, Jagadish Prasath Ramu <Jagadish.Ramu_at_sun.com> wrote:
> 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
> > >
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
>


-- 
"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