-1

We are developing an application and we need to migrate the data from the old db, a Sybase Advantage Local DB.

Until now we were doing it with Java 7 and an odbc/jdbc bridge thanks to java.sql.DriverManager. Now we upgraded our application to java 8 and the same driver doesn't work anymore.

Is there any alternative?

Dario Zamuner
  • 991
  • 2
  • 14
  • 28
  • The Google results I've found until now say it is not possible, and that's why I'm asking here. I would have hoped for something like a non official support library, or someone else experience on the topic. – Dario Zamuner Jul 22 '15 at 12:54
  • Ok, I overlooked the “local”. So, do you want a solution to use the ODBC driver on Java 8 or are you looking for a JDBC driver for Sybase Advantage Local DB? – Holger Jul 22 '15 at 13:13
  • It would be best to find a JDBC driver so I can use it inside a Linux environment, but I could use a bridge also as I did with Java 7 inside Windows. I need to migrate the data from an Advantage Local DB to a PostgreSQL DB. – Dario Zamuner Jul 22 '15 at 13:17

1 Answers1

0

Advantage JDBC uses a direct TCP/IP connection to the Advantage server and is not able to connect to Local Server (which is just a DLL).

joachimduerr
  • 16
  • Luckily at the end I discovered that the db in production is the server version. If only they had told me sooner I would have avoided a lot of hassle. – Dario Zamuner Oct 02 '15 at 13:22