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.
Test driver failed : Cannot find class. (with MySQL) Check your CLASSPATH or \lib\ext directory. C:\>C:\Applications\NetBeans3.3\bin\runide.exe -- System Info ---------------------------------------------------------------- Product Version = NetBeans IDE Version 3.3 (Build 200112102331) IDE Versioning = IDE/1 spec=1.43.1.1 impl=200112102331 Operating System = Windows 2000 version 5.0 running on x86 Java; VM; Vendor = Java HotSpot(TM) Client VM 1.3.1_01; Sun Microsystems Inc. Java Home = C:\serveurs\java\JDK13~1.1_0\jre System Locale = fr_FR Home Dir; Current Dir = C:\Documents and Settings\ppp; C:\ IDE Install; User Dir = C:\Applications\NetBeans3.3; C:\Applications\NetBeans3.3\projets CLASSPATH = C:\Applications\NetBeans3.3\lib\patches\openide-compat.jar; C:\Applications\NetBeans3.3\lib\core.jar; C:\Applications\NetBeans3.3\lib\openide.jar; C:\Applications\NetBeans3.3\lib\mm-mysql.jar; C:\Applications\NetBeans3.3\lib\ext\locale\ddl_ja.jar;C:\Applications\NetBeans3.3\lib\ext\crimson.jar;C:\Applications\NetBeans3.3\lib\ext\jh.jar;C:\Applications\NetBeans3.3\lib\ext\regexp.jar;C:\Applications\NetBeans3.3\lib\ext\rmi-ext.jar;C:\Applications\NetBeans3.3\lib\ext\terminalemulator.jar;C:\Applications\NetBeans3.3\lib\ext\xerces.jar;C:\Applications\NetBeans3.3\lib\ext\junit-ext.jar;C:\Applications\NetBeans3.3\lib\ext\junit.jar;C:\Applications\NetBeans3.3\lib\ext\ddl.jar;C:\Applications\NetBeans3.3\lib\ext\logger.jar;C:\Applications\NetBeans3.3\lib\ext\idlcompilers.jar;C:\Applications\NetBeans3.3\lib\ext\openorb-1.0.2.jar;C:\Applications\NetBeans3.3\lib\ext\mm-mysql.jar;C:\serveurs\java\JDK13~1.1_0\lib\dt.jar;C:\serveurs\java\JDK13~1.1_0\lib\tools.jar ------------------------------------------------------------------------------- Existing modules: Ant [org.apache.tools.ant.module/2 2.7.1.1 200112102331] Applet [org.netbeans.modules.applet/1 1.7.1.1 200112102331] Auto Update [org.netbeans.modules.autoupdate/1 1.7.1.1 200112102331] Bean Patterns [org.netbeans.modules.beans/1 1.7.1.1 200112102331] Built-in CVS Client [org.netbeans.modules.cvsclient/1 1.4.1.1 200112102331] ... trying to find a work around action : Recherche de : jdbc.odbc.JdbcOdbcDriver C:\Applications\NetBeans3.3\modules\db.3495-test.jar(6713): driver = "sun.jdbc.odbc.JdbcOdbcDriver"; C:\Applications\NetBeans3.3\modules\db.36696-test.jar(6713): driver = "sun.jdbc.odbc.JdbcOdbcDriver"; C:\Applications\NetBeans3.3\modules\db.48505-test.jar(6713): driver = "sun.jdbc.odbc.JdbcOdbcDriver"; C:\Applications\NetBeans3.3\modules\db.jar(6713): driver = "sun.jdbc.odbc.JdbcOdbcDriver"; ... + binary files : C:\Applications\NetBeans3.3\system\ParserDB\jdk13.jcb(7465): added mm-mysql.jar /modules/ext; it doesn't work added mm-mysql.jar to db.jar; no effect.
It should be enough to place the driver into <netbeans_home>\lib\ext directory and restart the IDE. If this does not help, send me your driver .jar file, please.
MM Mysql Driver http://sourceforge.net/project/showfiles.php?group_id=15923 was using 2.0.8 but nb wasn't able to find the class. (used this version with Poolman2.4b1 and Tomcat3.2.4) New test Driver : with 2.0.9 the driver is recognized but when logging i got "Internal test driver incomplete. The driver may not support the required DatabaseMetadata methods. Take a look at the Ouput Window for details." OUTPUT WINDOW : Testing driver org.gjt.mm.mysql.Driver. Test getTables(): found 5 tables Test getColumns(): Table adm_droit contains 4 columns. Test getPrimaryKeys(): Table adm_droit contains 1 primary keys Test getIndexInfo(): Table adm_droit contains 1 indexes. Warning: No procedure found. Check your database. -------------- Well, that's a good start :) so New Database Connection : Ok i got a new line in the Explorer : 'jdbc:mysql://localhost/mybase ...' but no more. Same result with 2.0.7 and same error.
I downloaded 2.0.8 and 2.0.9 drivers and both were recognized by NetBeans. I'm also able to connect to the database and browse the database structure. (Remember that the downloaded .jar file isn't JDBC driver itself. You have to extract the driver .jar file from the downloaded file.) Plese visit http://db.netbeans.org/doc/faq.html to find what "Internal test driver incomplete" message means. If you expand the connection node in Runtime tab you should be able to browse tables, columns, etc. If you see no tables, try to specify database schema on Advanced tab in the connect dialog.
thks, for your fast reply, but : C:\>C:\Applications\NetBeans3.3\bin\runide.exe -- System Info ---------------------------------------------------------------- Product Version = NetBeans IDE Version 3.3 (Build 200112102331) IDE Versioning = IDE/1 spec=1.43.1.1 impl=200112102331 Operating System = Windows 2000 version 5.0 running on x86 Java; VM; Vendor = 1.3.1_01; Java HotSpot(TM) Client VM 1.3.1_01; Sun Microsystems Inc. Java Home = C:\serveurs\java\JDK13~1.1_0\jre System Locale = fr_FR Home Dir; Current Dir = C:\Documents and Settings\xxx; C:\ IDE Install; User Dir = C:\Applications\NetBeans3.3; C:\Applications\NetBeans3.3\projets CLASSPATH = C:\Applications\NetBeans3.3\lib\patches\openide-compat.jar; C:\Applications\NetBeans3.3\lib\core.jar;C:\Applications\NetBeans3.3\lib\openide.jar; C:\Applications\NetBeans3.3\lib\ext\locale\ddl_ja.jar;C:\Applications\NetBeans3.3\lib\ext\crimson.jar;C:\Applications\NetBeans3.3\lib\ext\jh.jar; C:\Applications\NetBeans3.3\lib\ext\regexp.jar;C:\Applications\NetBeans3.3\lib\ext\rmi-ext.jar;C:\Applications\NetBeans3.3\lib\ext\terminalemulator.jar; C:\Applications\NetBeans3.3\lib\ext\xerces.jar;C:\Applications\NetBeans3.3\lib\ext\junit-ext.jar;C:\Applications\NetBeans3.3\lib\ext\junit.jar; C:\Applications\NetBeans3.3\lib\ext\ddl.jar;C:\Applications\NetBeans3.3\lib\ext\logger.jar;C:\Applications\NetBeans3.3\lib\ext\idlcompilers.jar ;C:\Applications\NetBeans3.3\lib\ext\openorb-1.0.2.jar; C:\Applications\NetBeans3.3\lib\ext\jta-spec1_0_1.jar; C:\Applications\NetBeans3.3\lib\ext\jdbc2_0-stdext.jar; C:\Applications\NetBeans3.3\lib\ext\mm.mysql-2.0.9-bin.jar;C:\serveurs\java\JDK13~1.1_0\lib\dt.jar;C:\serveurs\java\JDK13~1.1_0\lib\tools.jar ------------------------------------------------------------------------------- Existing modules: Ant [org.apache.tools.ant.module/2 2.7.1.1 200112102331] Applet [org.netbeans.modules.applet/1 1.7.1.1 200112102331] Auto Update [org.netbeans.modules.autoupdate/1 1.7.1.1 200112102331] Bean Patterns [org.netbeans.modules.beans/1 1.7.1.1 200112102331] Built-in CVS Client [org.netbeans.modules.cvsclient/1 1.4.1.1 200112102331] CSS Support [org.netbeans.modules.css/1 0.2.5 200201181156] CVS Command-Line Client Backward Compatibility [org.netbeans.modules.vcs.cmdline.compat/1 1.0.1.1 200112102331] Database Explorer [org.netbeans.modules.db/1 1.4.2 ${buildnumber}] Diff [org.netbeans.modules.diff/1 1.2 ${buildnumber}] Editor [org.netbeans.modules.editor/1 1.8.1.1 200112102331] External HTML Browser [org.netbeans.modules.extbrowser/1 0.3.1.1 200112102331] File Copy [org.netbeans.modules.filecopy/1 1.7 20020103] Form Editor [org.netbeans.modules.form/2 1.7.1.1 200112102331] General Online Help [org.netbeans.modules.usersguide/1 1.9.1.1 200112102331] HTML [org.netbeans.modules.html/1 1.8.1.1 200112102331] HTTP Server [org.netbeans.modules.httpserver/1 1.7.1.1 200112102331] IDE Core [org.netbeans.core/1 1.1] Image [org.netbeans.modules.image/1 1.7.1.1 200112102331] Inner-Class Testers [org.netbeans.modules.innertesters 0.5 28-mar-01] JAR Packager [org.netbeans.modules.jarpackager/2 1.9.1.1 200112102331] JPDA Debugger [org.netbeans.modules.debugger.jpda/1 1.9.1.1 200112102331] JSP Syntax Coloring [org.netbeans.modules.web.core.syntax/1 1.5.1.1 200112102331] JSP/Servlet [org.netbeans.modules.web.core/1 1.5.1.1 200112102331] Java Source Files [org.netbeans.modules.java/1 1.7.1.1 200112102331] Javadoc [org.netbeans.modules.javadoc/1 1.7.1.1 200112102331] Logger (TraceLogger) [org.netbeans.modules.logger/1 1.0 22-dec-00] New Module Wizard [org.netbeans.modules.apisupport.lite/1 0.2.1.1 200112102331] Object Browser [org.netbeans.modules.objectbrowser/1 1.7 2001101101500] OpenAPIs Support [org.netbeans.modules.apisupport 2.7 2.7-release-1] OpenAPIs Support with Ant [org.netbeans.modules.apisupport.ant 2.7 2.7-release-1] Projects [org.netbeans.modules.projects/1 1.7.1.1 200112102331] Resource Bundle Syntax Coloring [org.netbeans.modules.properties.syntax/1 1.7.1.1 200112102331] Resource Bundles [org.netbeans.modules.properties/1 1.7.1.1 200112102331] Serial Version UIDs [org.netbeans.modules.serialversion/1 0.2 dev-16] Sourceless Java Classes [org.netbeans.modules.clazz/1 1.8.1.1 200112102331] System Properties [org.netbeans.modules.sysprops 1.5 200112141318] Text [org.netbeans.modules.text/1 1.7.1.1 200112102331] Tomcat 3.2 Server [org.netbeans.modules.web.tomcat/1 1.3.1.1 200112102331] Tools Debugger [org.netbeans.modules.debugger.debug/1 1.9.1.1 200112102331] User Utilities [org.netbeans.modules.utilities/1 1.7.1.1 200112102331] VCS Generic Command-Line Support [org.netbeans.modules.vcs.advanced/1 1.5.1.1 200112102331] XML Backward Compatibility [org.netbeans.modules.xml/2 0.2.5 200201181156] XML Coloring Backward Compatibility [org.netbeans.modules.xml.editor.coloring/2 0.2.5 200201181156] XML Core [org.netbeans.modules.xml.core/1 0.2.5 200201181156] XML Entity Catalog [org.netbeans.modules.xml.catalog/1 0.2.5 200201181156] XML Productivity Tools [org.netbeans.modules.xml.tools/1 0.2.5 200201181156] XML Text Editor [org.netbeans.modules.xml.text/1 0.2.5 200201181156] XML Tree Editor [org.netbeans.modules.xml.tree/1 0.2.5 200201181156] Type Groups Level Module Name ---- ------ ----- ----------- err * 255 * (Default) path="" :jsp: init Internal HTTP server running on port 8088 Internal HTTP server stopped path="" :jsp: init Internal HTTP server running on port 8088 Type Groups Level Module Name ---- ------ ----- ----------- err * 255 * (Default) .... Retried with C:\Applications\NetBeans3.3\lib\extmm.mysql.2.0.9-bin.jar same errors as before with : In properties panel of 'jdbc:m [Properties of jdbc:mysql://localhost/mybase ... ]' ~All values have null, or NullPointerException : " Alter table with add column <java.lang.NullPointerException> Alter table with drop column <java.lang.NullPointerException> Ansi 92 entry level SQL <java.lang.NullPointerException> Ansi 92 full level SQL <java.lang.NullPointerException> Ansi 92 intermediate level SQL <java.lang.NullPointerException> Batch updates <java.lang.NullPointerException> Catalog at start <java.lang.NullPointerException> Catalog separator null Catalog term null Catalogs in DML <java.lang.NullPointerException> Catalogs in index definitions <java.lang.NullPointerException> Catalogs in privilege definitions <java.lang.NullPointerException> Catalogs in procedure calls <java.lang.NullPointerException> Catalogs in table definitions <java.lang.NullPointerException> Column aliasing <java.lang.NullPointerException> Convert <java.lang.NullPointerException> Core SQL grammar <java.lang.NullPointerException> Correlated subqueries <java.lang.NullPointerException> Database product name null Database product version null Database URL jdbc:mysql://localhost/mybase DDL and DML in transactions <java.lang.NullPointerException> DDL causes commit <java.lang.NullPointerException> DDL ignored in transactions <java.lang.NullPointerException> Different table correlation names <java.lang.NullPointerException> DML only <java.lang.NullPointerException> Driver org.gjt.mm.mysql.Driver Driver major version null Driver minor version null Driver name null Driver version null Expressions in order by <java.lang.NullPointerException> Extended SQL grammar <java.lang.NullPointerException> Extra name characters null Full outer joins <java.lang.NullPointerException> Product MySQL ... Remember password False (How to store easily 'Properties panel' in a text file or copying them in clipboard ?) Clicking on <java.lang.NullPointerException> ==> Tue Jan 22 21:51:20 CET 2002: java.lang.NullPointerException: <no message> Annotation: Invalid value. The property Ansi 92 full level SQL could not be set. Reason: null java.lang.NullPointerException at sun.beans.editors.BoolEditor.getAsText(BoolEditor.java:33) at org.openide.explorer.propertysheet.PropertyPanel.getWriterComponent(PropertyPanel.java:894) at org.openide.explorer.propertysheet.PropertyPanel.setWriteState(PropertyPanel.java:434) at org.openide.explorer.propertysheet.PropertyPanel$5.run(PropertyPanel.java:1644) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:154) [catch] at java.awt.EventQueue.dispatchEvent(EventQueue.java:337) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:131) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:98) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) at java.awt.EventDispatchThread.run(EventDispatchThread.java:85) ------------------------------------------------ added lib/ext/jta-spec1_0_1.jar jdbc2_0-stdext.jar but i got same errors and no tables. Ok let's got with database schema : the select list in Advanced panel of Connect Panel is empty ('select a database schema to use') : trivial i have no XML database for Forte.
I have tried mm.mysql-2.0.9-bin.jar (downloaded from sourceforge.net and built on my machine) and all works fine for me. I'm using RedHat and NetBeans 3.3. Are you sure that the problem is on client side? - Do you have any chance to try it against another MySQL server? - Which version of MySQL server do you use? - Did you try fresh installation of NetBeans?
NullPointerExceptions are usually thrown when DatabaseMetaData interface methods are not correctly implemented by the driver but I think this is not that case because I can see the properties (I see only a few exceptions in the properties window; see attached snapshot). I'm not an experienced MySQL user and I don't guess why it doesn't work for you. Could you send description of your problem to nbusers@netbeans.org mailing list, please? I believe that some MySQL user from the NetBeans community can help.
Created attachment 4355 [details] Properties window snapshot
[FIXED] After upgrading to the latest Database Explorer : 1.4.2 Mysql server version : 3.23.46 MM.mysql : 2.0.9 -- System Info ---------------------------------------------------------------- Product Version = NetBeans IDE 3.3.1 RC2 (Build 200201221600) IDE Versioning = IDE/1 spec=1.43.2 impl=200201221600 Operating System = Windows 2000 version 5.0 running on x86 Java; VM; Vendor = 1.3.1_01; Java HotSpot(TM) Client VM 1.3.1_01; Sun Mic rosystems Inc. Java Home = C:\serveurs\java\jdk1.3.1_01\jre System Locale; Encod. = fr_FR; Cp1252 Home Dir; Current Dir = C:\Documents and Settings\ppp; C:\Applications\netbean s\bin IDE Install; User Dir = C:\Applications\netbeans; C:\Applications\NetBeans3.3\ projets CLASSPATH = C:\Applications\netbeans\lib\patches\openide-compat.ja r;C:\Applications\netbeans\lib\core.jar;C:\Applications\netbeans\lib\openide.jar ;C:\Applications\netbeans\lib\ext\locale\ddl_ja.jar;C:\Applications\netbeans\lib \ext\jh.jar;C:\Applications\netbeans\lib\ext\xerces.jar;C:\Applications\netbeans \lib\ext\terminalemulator.jar;C:\Applications\netbeans\lib\ext\crimson.jar;C:\Ap plications\netbeans\lib\ext\regexp.jar;C:\Applications\netbeans\lib\ext\rmi-ext. jar;C:\Applications\netbeans\lib\ext\ddl.jar;C:\Applications\netbeans\lib\ext\mm .mysql-2.0.9-bin.jar;C:\serveurs\java\jdk1.3.1_01\lib\dt.jar;C:\serveurs\java\jd k1.3.1_01\lib\tools.jar ------------------------------------------------------------------------------- Existing modules: Ant [org.apache.tools.ant.module/2 2.7.2 200201221600] Applet [org.netbeans.modules.applet/1 1.7.2 200201221600] Auto Update [org.netbeans.modules.autoupdate/1 2.1.1 200201221600] Bean Patterns [org.netbeans.modules.beans/1 1.7.2 200201221600] Built-in CVS Client [org.netbeans.modules.cvsclient/1 1.4.2 200201221600 ] CSS Support [org.netbeans.modules.css/1 0.2.7 200202081003] CVS Command-Line Client Backward Compatibility [org.netbeans.modules.vcs .cmdline.compat/1 1.0.2 200201221600] Database Explorer [org.netbeans.modules.db/1 1.4.2 ${buildnumber}] Editor [org.netbeans.modules.editor/1 1.8.2 200201221600] External HTML Browser [org.netbeans.modules.extbrowser/1 0.3.2 200201221 600] Form Editor [org.netbeans.modules.form/2 1.7.2 200201221600] General Online Help [org.netbeans.modules.usersguide/1 1.9.2 20020122160 0] HTML [org.netbeans.modules.html/1 1.8.2 200201221600] HTTP Server [org.netbeans.modules.httpserver/1 1.7.2 200201221600] IDE Core [org.netbeans.core/1 1.1] Image [org.netbeans.modules.image/1 1.7.2 200201221600] Inner-Class Testers [org.netbeans.modules.innertesters 0.5 28-mar-01] Internationalization [org.netbeans.modules.i18n/1 1.9.2 200201221600] Internationalization of Form [org.netbeans.modules.i18n.form/2 1.8.2 200 201221600] JAR Packager [org.netbeans.modules.jarpackager/2 1.9.2 200201221600] JNDI [org.netbeans.modules.jndi/1 1.4.2 200201221600] JPDA Debugger [org.netbeans.modules.debugger.jpda/1 1.9.2 200201221600] JSP Syntax Coloring [org.netbeans.modules.web.core.syntax/1 1.5.2 200201 221600] JSP/Servlet [org.netbeans.modules.web.core/1 1.5.2 200201221600] Java Source Files [org.netbeans.modules.java/1 1.7.2 200201221600] Javadoc [org.netbeans.modules.javadoc/1 1.7.2 200201221600] New Module Wizard [org.netbeans.modules.apisupport.lite/1 0.2.2 20020122 1600] Object Browser [org.netbeans.modules.objectbrowser/1 1.7 2001101101500] Open APIs Support [org.netbeans.modules.apisupport 2.10.2 200201182009] Open APIs Support with Ant [org.netbeans.modules.apisupport.ant 2.8.2 20 0201182009] Projects [org.netbeans.modules.projects/1 1.7.2 200201221600] RMI [org.netbeans.modules.rmi/1 1.4.2 200201221600] Resource Bundle Syntax Coloring [org.netbeans.modules.properties.syntax/ 1 1.7.2 200201221600] Resource Bundles [org.netbeans.modules.properties/1 1.7.2 200201221600] Scripting Support [org.netbeans.modules.scripting/1 1.4.2 200201221600] Sourceless Java Classes [org.netbeans.modules.clazz/1 1.8.2 200201221600 ] Text [org.netbeans.modules.text/1 1.7.2 200201221600] Tomcat 3.2 Server [org.netbeans.modules.web.tomcat/1 1.3.2 200201221600] Tools Debugger [org.netbeans.modules.debugger.debug/1 1.9.2 200201221600 ] User Utilities [org.netbeans.modules.utilities/1 1.7.2 200201221600] VCS Generic Command-Line Support [org.netbeans.modules.vcs.advanced/1 1. 5.2 200201221600] XML Backward Compatibility [org.netbeans.modules.xml/2 0.2.7 20020208100 3] XML Coloring Backward Compatibility [org.netbeans.modules.xml.editor.col oring/2 0.2.7 200202081003] XML Core [org.netbeans.modules.xml.core/1 0.2.7 200202081003] XML Entity Catalog [org.netbeans.modules.xml.catalog/1 0.2.7 20020208100 3] XML Productivity Tools [org.netbeans.modules.xml.tools/1 0.2.7 200202081 003] XML Text Editor [org.netbeans.modules.xml.text/1 0.2.7 200202081003] XML Tree Editor [org.netbeans.modules.xml.tree/1 0.2.7 200202081003] path="" :jsp: init Internal HTTP server running on port 8083
VERIFIED
Resolved for 3.3.x or earlier, no new info since then -> closing.