Skip to Content

Changes for page JDBC and Entity Modeler

Last modified by Theodore Petrosky on 2017/04/02 18:37
From version 11.1
edited by Lachlan Scott
on 2007/07/11 15:57
Change comment: There is no comment for this version
To version 9.1
edited by franc
on 2012/05/26 11:29
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.lachlan_scott
1 +XWiki.franc
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,29 +13,45 @@
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. 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 +**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 +
32 32  **MySQL JDBC driver settings:**
33 33  
34 -URL: jdbc:mysql:~/~/<hostname>/<database//name>. eg. jdbc:mysql:~/~/localhost/authors
35 -Driver: com.mysql.jdbc.Driver//
38 +URL: jdbc:mysql:~/~/<hostname>/<database_name>. eg. jdbc:mysql:~/~/localhost/authors
39 + Driver: com.mysql.jdbc.Driver
36 36  
37 37  **OpenBase JDBC driver settings:**
38 38  
39 -URL: jdbc:openbase:~/~/<hostname>/<database//name>. eg. jdbc:openbase:~/~/localhost/authors
40 -Driver: com.openbase.jdbc.ObDriver
41 -\\//
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>