Set classpath for jdbc driver mac

broken image
broken image

JDBC URL: jdbc:sqlanywhere:DSN=SQL Anywhere 12 Demo.Connection Name: SQL Anywhere 12 Demo - SAJDBC4.- Browse to 'C:\Program Files\SQL Anywhere 12\java\sajdbc4.jar'.Here is the line I added to my configuration:ĪddVMOption =c:\Program Files\SQL Anywhere 12\bin64 %ORACLE_HOME% %PATH% Without doing this, you will see the exception no dbjdbc found in each time you try to connect with this driver. I need to first shut down ODM and include the SAJDBC4 native library directory in the '\datamodeler\bin\nf' file. Click 'Merge' - the tables will import into your default Relational Model.Check 'GROUPO' for the tables to import, check off tables and views you would like to Import, click 'Next'.JDBC URL: jdbc:sybase:Tds:localhost:2638.Connection Name: SQL Anywhere 12 Demo - JCONNECT.- Browse to 'C:\Program Files\SQL Anywhere 12\java\jconn3.jar'.In ODM, go to Tools -> Preferences, Data Modeller -> Third Party JDBC Drivers.Start the SQL Anywhere 12 Demo Database.Yes - I could connect using this tool without issue over jConnect 6.05 / SAJDBC 12. You are required to source the native libraries in the JVM value in order for the SAJDBC driver to work correctly. It is our supported 'Type-4' ('pure Java') JDBC driver, whereas SQL Anywhere JDBC (SAJDBC) is a mixed managed and native ('Type-2') driver. Yes, jConnect is still 'current' and 'supported'.