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:
using this driver:
How to import that driver with that url that require a .so library and the
LD_LIBRARY_PATH correctly configurated (pointing sybase stuff) ?
Thanks
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
-
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 -
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 classpathjava -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 -
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 -
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 listianywhere.ultralite.jdbc.JdbcDriver
but what I should use isianywhere.ml.jdbcodbc.IDriver
the JDBC 2.0 driver for SqlAnywhere 9.0.2
How to let it work? -
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... -
no, is a class, it follows the iAnywhere 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 -
Hi,
could you please point me to the correct Sybase product that I should install so that I can try the JDBC driver? Thanks!
Please sign in to leave a comment.
Comments 7