Changes for page JDBC and Entity Modeler

Summary

• Page properties (2 modified, 0 added, 0 removed)

Details

Page properties

Author

...	...	@@ -1,1 +1,1 @@
1		-XWiki.bardi
	1	+XWiki.lachlan_scott

Content

...	...	@@ -1,38 +1,20 @@
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	+**Discussion:** either the JDBC driver genuinely cannot be found, or more likely perhaps, your JDBC settings in Entity Modeler are incorrect.
4	4
5		-==== **Discussion** ====
	5	+**Checking the JDBC driver is in your CLASSPATH:**
6	6
7		-Either the JDBC driver genuinely cannot be found, or more likely perhaps, your JDBC settings in Entity Modeler are incorrect.
	7	+On the Mac, if JDBC drivers are added to /Library/Java/Extensions they should be picked up automatically by Eclipse. Check your classpath settings in Eclipse as follows:
8	8
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.
	9	+Right-click the project in Package Explorer
	10	+Select Java Build Path from the left hand list, and Libraries from the tabs in the main field
	11	+Open the JRE System Library list, and you should see your available JDBC driver see screenshot
	12	+If you cannot see your driver listed, you must add it. instructions required
10	10
11		-Put your JDBC drivers into the /Library/Java/Extensions then, and they should be picked up automatically by Eclipse.
	14	+**Checking the JDBC settings in Entity Modeler:**
12	12
13		-==== **Solution - check that your JDBC driver is in your CLASSPATH:** ====
	16	+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.
14	14
15		-Check your classpath settings in Eclipse as follows:
16		-[[image:Checking_CLASSPATH.jpg||]]
17		-
18		-* Right-click the project in Package Explorer
19		-* Select Java Build Path from the left hand list, and Libraries from the tabs in the main field
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
22		-
23		-==== **Solution - check JDBC settings in Entity Modeler** ====
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
26		-
27		- [[image:JDBC_correct_settings_mysql.jpg||]]
28		- 
29		-
30		-==== List of JDBC driver settings  ====
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	38	URL: jdbc:mysql:~/~/<hostname>/<database//name>. eg. jdbc:mysql:~/~/localhost/authors
...	...	@@ -41,15 +41,5 @@
41	41	**OpenBase JDBC driver settings:**
42	42
43	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		-
52		-**Postgresql JDBC driver settings:**
53		-URL: jdbc:postgresql:~/~/<hostname>/<databasename> eg. jdbc:postgresql:~/~/localhost/authors
54		-Driver: org.postgresql.Driver
55		-Plugin: Postgresql
	26	+Driver: com.openbase.jdbc.ObDriver
	27	+//