This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 189528 - Mysql cannot be seen from application
Summary: Mysql cannot be seen from application
Status: RESOLVED INCOMPLETE
Alias: None
Product: javaee
Classification: Unclassified
Component: Persistence (show other bugs)
Version: 6.x
Hardware: PC Windows XP
: P3 normal (vote)
Assignee: Sergey Petrov
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-08-15 14:15 UTC by terence_57
Modified: 2011-11-16 16:43 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description terence_57 2010-08-15 14:15:03 UTC
I use the MySQL wich is delivered with XAMPP. Want to attach Mysql to Netbeans 6.9.

When setting up a MySQL Database in 6.9/6.9.1 with Win Vista/Win XP there is no problem to see the Database from the Services-Tab (Dienste-Tab). 

In an application however, the error is

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

In the admin console http://localhost:4848 the ping fails:

Ping failed Exception - Class name is wrong or classpath is not set for : com.mysql.jdbc.jdbc2.optional.MysqlDataSource Please check the server.log for more details.

Tryed to put mysql-connector-java-5.1.13-jar in the folder c:\Programme\glassfish-3.0.1\lib\ext => no success
Comment 1 Sergey Petrov 2010-08-15 17:18:54 UTC
why it's p1?
is it netbeans related issue? you said you can see mysql on services  tab. what netbeans can't do with mysql?
Comment 2 Sergey Petrov 2010-08-31 14:52:04 UTC
some details was provided, but it's not enough to start investigation.

Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.1.v20100213-r6600): org.eclipse.persistence.exceptions.DatabaseException

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.MysqlDataSource

Error Code: 0

is likely runtime environment configuration issue like missed jdbc driver in classpath.