Skip to Content

Changes for page JDBC and Entity Modeler

Last modified by Theodore Petrosky on 2017/04/02 18:37
From version 27.1
edited by Theodore Petrosky
on 2017/04/02 18:37
Change comment: There is no comment for this version
To version 25.1
edited by franc
on 2012/05/26 11:29
Change comment: There is no comment for this version

Summary

Details

Page properties
Parent
... ... @@ -1,1 +1,0 @@
1 -WOLips Tutorials
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.tedpet
1 +XWiki.franc
Tags
... ... @@ -1,1 +1,0 @@
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:attach:JDBC connection failed.jpg]]
3 +[[image:JDBC connection failed.jpg||]]
4 4  
5 5  ==== **Discussion** ====
6 6  
... ... @@ -13,52 +13,46 @@
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:attach:Checking_CLASSPATH.jpg]]
16 +[[image: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:attach:JDBC_correct_settings_mysql.jpg]]
28 -
27 + [[image: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:
48 +URL: jdbc:FrontBase:~/~/<hostname>/<database//name>. eg. jdbc:FrontBase:~/~/localhost/authors
49 +Driver:
50 +\\//
50 50  
51 51  **Postgresql JDBC driver settings:**
52 - URL: jdbc:postgresql:~/~/<hostname>/<databasename> eg. jdbc:postgresql:~/~/localhost/authors
53 - Driver: org.postgresql.Driver
54 - Plugin: Postgresql
53 +URL: jdbc:postgresql:~/~/<hostname>/<databasename> eg. jdbc:postgresql:~/~/localhost/authors
54 +Driver: org.postgresql.Driver
55 +Plugin: Postgresql
55 55  
56 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 -
58 +URL: jdbc:h2:,,/<databasename>,,
Checking_CLASSPATH.jpg
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -150.8 KB
Content
JDBC connection failed.jpg
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -40.4 KB
Content
JDBC_correct_settings_mysql.jpg
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.XWikiGuest
Size
... ... @@ -1,1 +1,0 @@
1 -42.7 KB
Content