Skip to Content

Changes for page JDBC and Entity Modeler

Last modified by Theodore Petrosky on 2017/04/02 18:37
From version 26.1
edited by franc
on 2012/05/26 11:29
Change comment: There is no comment for this version
To version 28.2
edited by Theodore Petrosky
on 2017/04/02 18:37
Change comment: Changed document parent to [xwiki:documentation.Home.WOLips Tutorials.WebHome].

Summary

Details

Page properties
Parent
... ... @@ -1,0 +1,1 @@
1 +documentation.Home.WOLips Tutorials.WebHome
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.franc
1 +XWiki.tedpet
Tags
... ... @@ -1,0 +1,1 @@
1 +wikireview
Content
... ... @@ -1,6 +1,6 @@
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  
... ... @@ -13,46 +13,52 @@
13 13  ==== **Solution - check that your JDBC driver is in your CLASSPATH:** ====
14 14  
15 15  Check your classpath settings in Eclipse as follows:
16 -[[image:Checking_CLASSPATH.jpg||]]
16 +[[image:attach:Checking_CLASSPATH.jpg]]
17 17  
18 18  * Right-click the project in Package Explorer
19 19  * Select Java Build Path from the left hand list, and Libraries from the tabs in the main field
20 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 +* If you cannot see your driver listed, you must add it. [WOL:instructions required]
22 22  
23 23  ==== **Solution - check JDBC settings in Entity Modeler** ====
24 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
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 26  
27 - [[image:JDBC_correct_settings_mysql.jpg||]]
28 - 
27 +[[image:attach:JDBC_correct_settings_mysql.jpg]]
28 +
29 29  
30 -==== List of JDBC driver settings  ====
30 +==== List of JDBC driver settings ====
31 31  
32 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?
33 + Embedded Derby, how is it done?
34 + How do you set property derby.system.home so Entity Modeler can be used?
35 35  
36 36  **MySQL JDBC driver settings:**
37 37  
38 -URL: jdbc:mysql:~/~/<hostname>/<database//name>. eg. jdbc:mysql:~/~/localhost/authors
39 -Driver: com.mysql.jdbc.Driver//
38 +URL: jdbc:mysql:~/~/<hostname>/<database_name>. eg. jdbc:mysql:~/~/localhost/authors
39 + Driver: com.mysql.jdbc.Driver
40 40  
41 41  **OpenBase JDBC driver settings:**
42 42  
43 -URL: jdbc:openbase:~/~/<hostname>/<database//name>. eg. jdbc:openbase:~/~/localhost/authors
44 -Driver: com.openbase.jdbc.ObDriver//
43 +URL: jdbc:openbase:~/~/<hostname>/<database_name>. eg. jdbc:openbase:~/~/localhost/authors
44 + Driver: com.openbase.jdbc.ObDriver
45 45  
46 46  **FrontBase JDBC driver settings:**
47 47  
48 -URL: jdbc:FrontBase:~/~/<hostname>/<database//name>. eg. jdbc:FrontBase:~/~/localhost/authors
49 -Driver:
50 -\\//
48 +URL: jdbc:FrontBase:~/~/<hostname>/<database_name>. eg. jdbc:FrontBase:~/~/localhost/authors
49 + Driver:
51 51  
52 52  **Postgresql JDBC driver settings:**
53 -URL: jdbc:postgresql:~/~/<hostname>/<databasename> eg. jdbc:postgresql:~/~/localhost/authors
54 -Driver: org.postgresql.Driver
55 -Plugin: Postgresql
52 + URL: jdbc:postgresql:~/~/<hostname>/<databasename> eg. jdbc:postgresql:~/~/localhost/authors
53 + Driver: org.postgresql.Driver
54 + Plugin: Postgresql
56 56  
57 57  **H2 JDBC driver settings:**
58 -URL: jdbc:h2:,,/<databasename>,,
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