Mark,
I am using the
'com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource'
class, which worked fine in 5.0. I've done some
further debugging and figured out a way to get the
datasource to at least run. If I explicitly pass the
"user" and "password" parameters (along with
"serverName", "databaseName", and "port"), rather than
use the JAAS authentication entry I created, I still
get the same error as below, however the datasource
does in fact work.
If I try to use the JAAS entry, it actually connects
to the server, which gives the following error:
""Access denied for user: '[EMAIL PROTECTED]'
(Using password: NO)"
Passing the login as parameters gives me the error
below, but my code can, in fact, access the
datasource.
[2/19/04 21:57:33:376 EST] 3c66be23 DSConfigurati W
DSRA0174W: Warning: GenericDataStoreHelper is being
used.
[2/19/04 21:57:33:706 EST] 3c66be23 ConnectionFac I
J2CA0122I: Resource reference jdbc/staging could not
be located, so default values of the following are
used: [Resource-ref settings]
res-auth: 1 (APPLICATION)
res-isolation-level: 0 (TRANSACTION_NONE)
res-sharing-scope: true (SHAREABLE)
res-resolution-control: 999 (undefined)
[Other attributes]
isCMP1_x: false (not CMP1.x)
isJMS: false (not JMS)
[2/19/04 21:57:34:287 EST] 3c66be23 WSRdbDataSour I
DSRA8203I: Database product name : MySQL
[2/19/04 21:57:34:287 EST] 3c66be23 WSRdbDataSour I
DSRA8204I: Database product version : 4.0.15-max
[2/19/04 21:57:34:287 EST] 3c66be23 WSRdbDataSour I
DSRA8205I: JDBC driver name : MySQL-AB JDBC Driver
[2/19/04 21:57:34:287 EST] 3c66be23 WSRdbDataSour I
DSRA8206I: JDBC driver version :
mysql-connector-java-3.0.10-stable ( $Date: 2004/01/13
21:56:18 $, $Revision: 1.27.2.33 $ )
Tom
--- Mark Matthews <[EMAIL PROTECTED]> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Tom O'Neil wrote:
>
> > I've been running an application on WebSphere 5.0
> > (Linux) that uses the MySql Connector/J 3.10 to
> > connect to a MySql-max 4.0.15 database (also on
> > Linux). All was working fine, until I recently
> > installed WebSphere 5.1. Now my datasources
> > (configured exactly as before) no longer work -
> > WebSphere seems unable to find them. When I start
> the
> > server, I get the following error when my
> application
> > starts:
> >
> > [2/19/04 16:04:40:481 EST] 3c6d95c5 DSConfigurati
> W
> > DSRA0174W: Warning: GenericDataStoreHelper is
> being
> > used.
> > [2/19/04 16:04:40:891 EST] 3c6d95c5 ConnectionFac
> I
> > J2CA0122I: Resource reference jdbc/staging could
> not
> > be located, so default values of the following are
> > used: [Resource-ref settings]
> >
> > res-auth: 1 (APPLICATION)
> > res-isolation-level: 0 (TRANSACTION_NONE)
> > res-sharing-scope: true (SHAREABLE)
> > res-resolution-control: 999 (undefined)
> > [Other attributes]
> >
> > isCMP1_x: false (not CMP1.x)
> > isJMS: false (not JMS)
> >
> > Has anyone else had problems with WAS 5.1 access
> MySql
> > datasources?
>
> Tom,
>
> Make sure you're using
>
'com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource'
> as the
> datasource implementation class that you plug into
> your WebSphere
> config...For some reason, no other classes (Driver
> or plain DataSource)
> seem to work in 5.1sp1 or newer.
>
> FYI, I just tested this yesterday in WS 6.0 preview,
> and it has the same
> issue.
>
> -Mark
>
> - --
> Mr. Mark Matthews
> MySQL AB, Software Development Manager, J2EE and
> Windows Platforms
> Office: +1 708 332 0507
> www.mysql.com
>
> Meet the MySQL Team! April 14-16, 2004
> http://www.mysql.com/uc2004/
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.3 (MingW32)
> Comment: Using GnuPG with Thunderbird -
> http://enigmail.mozdev.org
>
>
iD8DBQFANV/qtvXNTca6JD8RAnWcAKCD9n3If9DLMSJqOwc4ygbNpt+hsgCgmxQ4
> Hd/VPa5IieQfH+Y/jnZfciM=
> =W/GZ
> -----END PGP SIGNATURE-----
=====
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
