Saturday, May 7, 2016

Open paradox / borland database as single file

By Hường Hana 11:30 AM , , , Leave a Comment

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.

1 Answers

Answers 1

you're not trying to open the database doing so but a specific file of the whole DB. In fact your DB is composed of files .db, .px ....

The best approach to do so, is to migrate since this DB is not supported, and realy brings a lot of bugs.

I will recommand you to use migrate your database.

  1. install Paradox Database Reader or Editor
  2. export tables to CSV files
  3. import tables in mysql Database (for example)

If you still want to connect this DB without migration with java, share in private a file .db and will give a try now.

If You Enjoyed This, Take 5 Seconds To Share It

0 comments:

Post a Comment