Java sun Application Server 9 error

When trying to deploy an application i get sql error.

Using Netbeans 5.5.

The database is mysql.

Using Create Entity from Database wizard

Any idea what i can do to fix this?

Deploying application in domain failed;

Internal Exception: java.sql.SQLException: Error in allocating a connection. Cause: Class name is wrong or classpath is not set for : com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSourceError Code: 0

C:\Documents and Settings\Other\EnterpriseApplication10\nbproject\build-impl.xml:221: Deployment error:

The module has not been deployed.

See the server log for details.

BUILD FAILED (total time: 25 seconds)

Message was edited by:

infonote

[741 byte] By [infonote] at [2007-11-26 7:28:15]
# 1

For AppServer to access the database drivers,

driver files need to be placed in domains/<domain-name>/lib/ext

for mysql you have to download (from mysql website) and add the following driver

mysql-connector-java-5.0.0-beta-bin.jar

restart the appserver, driver will get recognized.

Thanks,

-Jagadish

JagadishPrasath at 2007-7-6 19:19:15 > top of Java-index,Application & Integration Servers,Application Servers...
# 2
I had put the driver in the directory.Just i had put mysql connector/j version 3It seems it does not accept version 3
infonote at 2007-7-6 19:19:15 > top of Java-index,Application & Integration Servers,Application Servers...
# 3

I put the mysqlconnector 5 in the folder:

C:\Sun\AppServer\domains\domain1\lib\ext

And i restarted server from netbeans runtime panel.

I am still getting the error

Deploying application in domain failed;

Internal Exception: java.sql.SQLException: Error in allocating a connection. Cause: Class name is wrong or classpath is not set for : com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSourceError Code: 0

C:\Documents and Settings\Other\EnterpriseApplication12\nbproject\build-impl.xml:221: Deployment error:

The module has not been deployed.

See the server log for details.

BUILD FAILED (total time: 1 second)

infonote at 2007-7-6 19:19:15 > top of Java-index,Application & Integration Servers,Application Servers...
# 4
It worked, it was my fault.I put in the zipped file and did not extract it DUH.Now it deploys successfully.Thanks a lot for the immediate reply.
infonote at 2007-7-6 19:19:15 > top of Java-index,Application & Integration Servers,Application Servers...