JDBC and Entity Modeler

1

==== Problem: You encounter the 'JDBC connection failed for driver ...' error message when trying to generate SQL in Entity Modeler. ====

2

3

[[image:attach:JDBC connection failed.jpg]]

4

5

==== **Discussion** ====

6

7

Either the JDBC driver genuinely cannot be found, or more likely perhaps, your JDBC settings in Entity Modeler are incorrect.

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.

10

11

Put your JDBC drivers into the /Library/Java/Extensions then, and they should be picked up automatically by Eclipse.

12

13

==== **Solution - check that your JDBC driver is in your CLASSPATH:** ====

14

15

Check your classpath settings in Eclipse as follows:

16

[[image:attach: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. [WOL: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:attach: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?