Wiki source code of JDBC and Entity Modeler
Version 15.1 by David Holt on 2007/12/02 22:14
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | ==== Problem: You encounter the 'JDBC connection failed for driver ...' error message when trying to generate SQL in Entity Modeler. ==== | ||
| 2 | |||
| 3 | [[image:JDBC connection failed.jpg||]] | ||
| 4 | |||
| 5 | ==== **Discussion** ==== | ||
| 6 | |||
| 7 | Either the JDBC driver genuinely cannot be found, or more likely perhaps, your JDBC settings in Entity Modeler are incorrect. | ||
| 8 | |||
| 9 | On Mac OS X, the /Library/Java/Extensions directory is provided for extensions to the core Java API, and is thus the appropriate place for JDBC drivers. | ||
| 10 | |||
| 11 | Put your JDBC drivers into the /Library/Java/Extensions then, and they should be picked up automatically by Eclipse. | ||
| 12 | |||
| 13 | ==== **Solution - check that your JDBC driver is in your CLASSPATH:** ==== | ||
| 14 | |||
| 15 | Check your classpath settings in Eclipse as follows: | ||
| 16 | [[image:Checking_CLASSPATH.jpg||]] | ||
| 17 | |||
| 18 | * Right-click the project in Package Explorer | ||
| 19 | * Select Java Build Path from the left hand list, and Libraries from the tabs in the main field | ||
| 20 | * Open the JRE System Library list, and you should see your available JDBC driver (see screenshot) | ||
| 21 | * If you cannot see your driver listed, you must add it. instructions required | ||
| 22 | |||
| 23 | ==== **Solution - check JDBC settings in Entity Modeler** ==== | ||
| 24 | |||
| 25 | Check that the settings for your JDBC driver are correct; these details are provided by the suppliers. MySQL settings are shown in the screenshot (see screenshot). Note that drivers have peculiar use of capitalization, and that //this must be correct// for the driver to function | ||
| 26 | |||
| 27 | [[image:JDBC_correct_settings_mysql.jpg||]] | ||
| 28 | | ||
| 29 | |||
| 30 | ==== List of JDBC driver settings ==== | ||
| 31 | |||
| 32 | **MySQL JDBC driver settings:** | ||
| 33 | |||
| 34 | URL: jdbc:mysql:~/~/<hostname>/<database//name>. eg. jdbc:mysql:~/~/localhost/authors | ||
| 35 | Driver: com.mysql.jdbc.Driver// | ||
| 36 | |||
| 37 | **OpenBase JDBC driver settings:** | ||
| 38 | |||
| 39 | URL: jdbc:openbase:~/~/<hostname>/<database//name>. eg. jdbc:openbase:~/~/localhost/authors | ||
| 40 | Driver: com.openbase.jdbc.ObDriver// | ||
| 41 | |||
| 42 | **FrontBase JDBC driver settings:** | ||
| 43 | |||
| 44 | URL: jdbc:FrontBase:~/~/<hostname>/<database//name>. eg. jdbc:FrontBase:~/~/localhost/authors | ||
| 45 | Driver: | ||
| 46 | \\// |