Database connection to SQL Anywhere datasource in CloverGUI

CloverDX Platform
1

Hi all,
I’m on ubuntu with Eclipse 3.4 and I should use CloverETL to transform a Sybase SQL Anywhere ODBC datasource ( .db ) . I’ve just installed CloverGUI and and its users manual and I haven’t understood how to add the JDBC driver that I need to make the internal database connection.
I need the Sybase SQL Anywhere <=9 one.
I can access the db through JDBC-ODBC with this url:

jdbc:odbc:driver=opt/sybase/SYBSsa9/lib/libdbodbc9_r.so;UID=DBA;PWD=SQL;DBF=mydb.db

using this driver:

ianywhere.ml.jdbcodbc.IDriver

How to import that driver with that url that require a .so library and the
LD_LIBRARY_PATH correctly configurated (pointing sybase stuff) ?
Thanks

2

Hi,
you can access the DB through the URL in the CloverGUI or in some other tool?

In general you can load a JDBC driver in the CloverGUI when creating a new DB connection. When you’re creating a new DB connection (e.g. by right clicking on the Connections entry in the graph outline, and selecting Connections → Create internal), you can load a JDBC driver by clicking the + button. To make the .so library available you will probably need to modify your eclipse.ini and add “-Djava.library.path=the_path_to_the_so_directory” and add the same parameter to the Clover graph launch configuration.

Jaro

3

Hi,
I can access the Sybase SQL Anywhere database file with the iAnywhere JDBC driver in this way


   String url = "jdbc:odbc:driver=libdbodbc9_r.so;UID=DBA;PWD=SQL;DBF=Alunni.db"

     String  driver="ianywhere.ml.jdbcodbc.IDriver";
      try {
          Class.forName( driver );
         conn = DriverManager.getConnection( url );
      } catch (Exception ex) {
          ex.printStackTrace();
          System.exit(3);
      }

launching it with the JDBC-ODBC driver in classpath

java -classpath ".:/opt/sybase/SYBSsa9/java/jodbc.jar" MyClass

But, as you can see in this screenshot
http://img405.imageshack.us/img405/2792 … vertn1.png
I can’t add the driver ( jar) that I need, if I select it I can’t see it in the driver list and I can select only postgresql or mysql, what’s wrong?
thanks

4

Hi,
how do you add the driver? Do you click the top-most “+” button? You can also select multiple jar files, so you might try selecting all the jars (the driver may depend on other jars).

If there’s no JDBC driver in any of the selected jars, you should see the message “JDBC driver not found in the jar file”. Is this the case?

Jaro

5

Hi,
I’ve tried to add all jars in the folder and I’ve got a list of available jar to select, but I got
“Driver do not support JDBC url” while trying to Validate connection as you can see here
http://img99.imageshack.us/img99/3858/s … er2bl7.png
I see in the list

ianywhere.ultralite.jdbc.JdbcDriver

but what I should use is

ianywhere.ml.jdbcodbc.IDriver

the JDBC 2.0 driver for SqlAnywhere 9.0.2
How to let it work?

6

Are you sure you should use the class “ianywhere.ml.jdbcodbc.IDriver”? Because if the class follows the common naming conventions then it’s an interface, not the actual JDBC implementation. Check if your JDBC URL really follows the requiremetns of the SQLAnywhere driver…

7

no, is a class, it follows the _i_Anywhere style, everything starts with the i there…
I can only load the ultralite driver that I don’t need, why I can’t load that jodbc.jar driver? I’ve put libs in path as you told me

8

Hi,
could you please point me to the correct Sybase product that I should install so that I can try the JDBC driver? Thanks!