SQL Anywhere 10 JDBC connectivity issue

[Former Member]

I'm trying to connect to SQL Anywhere 10 database from my Java Application with the following code and connection string

URL url = new URL("jar:file:" + "jodbc.jar"+ "!/");
URLClassLoader urlClassLoader = new URLClassLoader(new URL[] {url});
Driver driver = (Driver) Class.forName(driverClass, true, urlClassLoader).newInstance();
DriverManager.registerDriver(new ConnectionDriver(driver));
Connection connection = DriverManager.getConnection(CONNECTION_URL);


Driver = ianywhere.ml.jdbcodbc.jdbc3.IDriver
CONNECTION_URL = "jdbc:ianywhere:driver=SQL Anywhere 10;Host=%s;uid=%s;pwd=%s"

when database is setup locally, the above code snippet is working but when I am trying to connect it to the remote database server with a connection string

"jdbc:ianywhere:driver=SQL Anywhere 10;Host=xxxxxxx;uid=xxxx;pwd=xxxx;DatabaseName=xxxx;";

then while getting connection it waits for it for a infinite time without giving an exception. Connection connection = DriverManager.getConnection(CONNECTION_URL);

could you please let me know if i am missing anything ?

Any help is appreciated.

[VolkerBarth]

The HOST connection paramater was introduced with SQL Anywhere 12. For older versions, you have to use the CommLinks connection parameter with the HOST network protol option, such as

"jdbc:ianywhere:driver=SQL Anywhere 10;Links=tcpip(Host=xxxxxxx);uid=xxxx;pwd=xxxx;DatabaseName=xxxx;";