Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Open paradox / borland database as single file

my question is: how to connect java tp paradox / borland database ".DB" single files?

Here's what I have: screenshot So, it's Paradox 7 database files.

I'm trying drivers: http://www.hxtt.com/paradox.html & https://code.google.com/archive/p/paradoxdriver/ as:

String url = "jdbc:paradox:/D:/BABAK/powerGold/SongTitle.DB";
Connection con = DriverManager.getConnection(url);

But both throws exceptions like:

D:/BABAK/powerGold/SongTitle.DB isn't a database directory path!

As you can see, it is trying to find some database folder, but I have only single files! Also, "jdbc:paradox:/D:/BABAK/powerGold" (path to all .DB files folder) didn't work as well.

So, anybody, please help me to figure out, how to open this type of DB in my Java app.

like image 386
Alex Babak Avatar asked Apr 28 '16 14:04

Alex Babak


1 Answers

jdbc:paradox:D:/BABAK/powerGold is the correct syntax.

One of the open source Paradox drivers you mentioned is now on Github and has had more features added since a couple of years ago, so that may now work.

If it doesn't, can you post the full stack trace (using this library, not the HXTT one) so we can figure out exactly what's going on? I'm not the original author, but I have made several contributions for different field types.

like image 127
Michael Berry Avatar answered Nov 06 '22 22:11

Michael Berry