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
# 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)