Skip to Content

Changes for page JDBC and Entity Modeler

Last modified by Theodore Petrosky on 2017/04/02 18:37
From version 22.1
edited by Lachlan Scott
on 2007/07/10 20:15
Change comment: There is no comment for this version
To version 28.1
edited by Theodore Petrosky
on 2023/11/13 11:58
Change comment: Renamed from xwiki:documentation.JDBC and Entity Modeler

Summary

Details

Page properties
Parent
... ... @@ -1,0 +1,1 @@
1 +WOLips Tutorials
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.lachlan_scott
1 +XWiki.tedpet
Tags
... ... @@ -1,0 +1,1 @@
1 +wikireview
Content
... ... @@ -1,40 +1,64 @@
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 +[[image:attach:JDBC connection failed.jpg]]
4 4  
5 5  ==== **Discussion** ====
6 6  
7 -Either the JDBC driver genuinely cannot be found, or more likely perhaps, your JDBC settings in Entity Modeler are incorrect. On Mac OS X, if JDBC drivers are added to /Library/Java/Extensions they should be picked up automatically by Eclipse.
7 +Either the JDBC driver genuinely cannot be found, or more likely perhaps, your JDBC settings in Entity Modeler are incorrect.
8 8  
9 -==== **Solution - check that the JDBC driver is in your CLASSPATH:** ====
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 10  
11 +Put your JDBC drivers into the /Library/Java/Extensions then, and they should be picked up automatically by Eclipse.
11 11  
12 -\\\\
13 +==== **Solution - check that your JDBC driver is in your CLASSPATH:** ====
13 13  
14 14  Check your classpath settings in Eclipse as follows:
15 - [[image:Checking_CLASSPATH.jpg||]]
16 +[[image:attach:Checking_CLASSPATH.jpg]]
16 16  
17 17  * Right-click the project in Package Explorer
18 18  * Select Java Build Path from the left hand list, and Libraries from the tabs in the main field
19 -* Open the JRE System Library list, and you should see your available JDBC driver see screenshot
20 -* If you cannot see your driver listed, you must add it. instructions required
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. [WOL:instructions required]
21 21  
22 22  ==== **Solution - check JDBC settings in Entity Modeler** ====
23 23  
24 -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.
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!
25 25  
26 - [[image:JDBC_correct_settings_mysql.jpg||]]
27 - 
27 +[[image:attach:JDBC_correct_settings_mysql.jpg]]
28 +
28 28  
29 -==== List of JDBC driver settings  ====
30 +==== List of JDBC driver settings ====
30 30  
32 +**Derby JDBC driver settings:**
33 + Embedded Derby, how is it done?
34 + How do you set property derby.system.home so Entity Modeler can be used?
35 +
31 31  **MySQL JDBC driver settings:**
32 32  
33 -URL: jdbc:mysql:~/~/<hostname>/<database//name>. eg. jdbc:mysql:~/~/localhost/authors
34 -Driver: com.mysql.jdbc.Driver//
38 +URL: jdbc:mysql:~/~/<hostname>/<database_name>. eg. jdbc:mysql:~/~/localhost/authors
39 + Driver: com.mysql.jdbc.Driver
35 35  
36 36  **OpenBase JDBC driver settings:**
37 37  
38 -URL: jdbc:openbase:~/~/<hostname>/<database//name>. eg. jdbc:openbase:~/~/localhost/authors
39 -Driver: com.openbase.jdbc.ObDriver
40 -\\//
43 +URL: jdbc:openbase:~/~/<hostname>/<database_name>. eg. jdbc:openbase:~/~/localhost/authors
44 + Driver: com.openbase.jdbc.ObDriver
45 +
46 +**FrontBase JDBC driver settings:**
47 +
48 +URL: jdbc:FrontBase:~/~/<hostname>/<database_name>. eg. jdbc:FrontBase:~/~/localhost/authors
49 + Driver:
50 +
51 +**Postgresql JDBC driver settings:**
52 + URL: jdbc:postgresql:~/~/<hostname>/<databasename> eg. jdbc:postgresql:~/~/localhost/authors
53 + Driver: org.postgresql.Driver
54 + Plugin: Postgresql
55 +
56 +**H2 JDBC driver settings:**
57 + URL: jdbc:h2:~~/<databasename>\\
58 +
59 +**Oracle JDBC driver settings:**
60 +URL: jdbc:oracle:thin:@<hostname>:1521/SID using Java jar ojdbc6.jar downloaded from Oracle's website (account needed, but free)
61 +
62 +
63 +
64 +
Checking_CLASSPATH.jpg
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +150.8 KB
Content
JDBC connection failed.jpg
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +40.4 KB
Content
JDBC_correct_settings_mysql.jpg
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.XWikiGuest
Size
... ... @@ -1,0 +1,1 @@
1 +42.7 KB
Content