Skip to Content

Changes for page JDBC and Entity Modeler

Last modified by Theodore Petrosky on 2017/04/02 18:37
From version 18.1
edited by Lachlan Scott
on 2007/07/10 20:12
Change comment: There is no comment for this version
To version 19.1
edited by Lachlan Scott
on 2007/07/10 19:57
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,28 +1,20 @@
1 -==== Problem: You encounter the 'JDBC connection failed for driver ...' error message when trying to generate SQL in Entity Modeler.   ====
1 +**Problem:** You encounter the 'JDBC connection failed for driver ...' error message when trying to generate SQL in Entity Modeler.
2 2  
3 -[[image:JDBC connection failed.jpg||]]
3 +**Discussion:** either the JDBC driver genuinely cannot be found, or more likely perhaps, your JDBC settings in Entity Modeler are incorrect.
4 4  
5 -==== **Discussion** ====
5 +**Checking the JDBC driver is in your CLASSPATH:**
6 6  
7 -either the JDBC driver genuinely cannot be found, or more likely perhaps, your JDBC settings in Entity Modeler are incorrect.
7 +On the Mac, if JDBC drivers are added to /Library/Java/Extensions they should be picked up automatically by Eclipse. Check your classpath settings in Eclipse as follows:
8 8  
9 -==== **Solution: Check that the JDBC driver is in your CLASSPATH:**
10 - ====
9 +Right-click the project in Package Explorer
10 +Select Java Build Path from the left hand list, and Libraries from the tabs in the main field
11 +Open the JRE System Library list, and you should see your available JDBC driver see screenshot
12 +If you cannot see your driver listed, you must add it. instructions required
11 11  
12 -On the Mac, if JDBC drivers are added to /Library/Java/Extensions they should be picked up automatically by Eclipse. Check your classpath settings in Eclipse as follows: [[image:Checking_CLASSPATH.jpg||]]
14 +**Checking the JDBC settings in Entity Modeler:**
13 13  
14 -* Right-click the project in Package Explorer
15 -* Select Java Build Path from the left hand list, and Libraries from the tabs in the main field
16 -* Open the JRE System Library list, and you should see your available JDBC driver see screenshot
17 -* If you cannot see your driver listed, you must add it. instructions required
16 +Check that the settings for your JDBC driver are correct. Details should be provided by the suppliers. MySQL settings are shown in the screenshot see screenshot. Note that drivers have peculiar use of upper and lower case and that these must be correct for the driver to function.
18 18  
19 -==== **Check JDBC settings in Entity Modeler** ====
20 -
21 -Check that the settings for your JDBC driver are correct. Details should be provided by the suppliers. MySQL settings are shown in the screenshot see screenshot. Note that drivers have peculiar use of upper and lower case and that these must be correct for the driver to function. [[image:JDBC_correct_settings_mysql.jpg||]]
22 - 
23 -
24 -==== List of JDBC settings  ====
25 -
26 26  **MySQL JDBC driver settings:**
27 27  
28 28  URL: jdbc:mysql:~/~/<hostname>/<database//name>. eg. jdbc:mysql:~/~/localhost/authors
... ... @@ -32,4 +32,4 @@
32 32  
33 33  URL: jdbc:openbase:~/~/<hostname>/<database//name>. eg. jdbc:openbase:~/~/localhost/authors
34 34  Driver: com.openbase.jdbc.ObDriver
35 -\\//
27 +//