Skip to Content

Changes for page JDBC and Entity Modeler

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

Summary

Details

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