Skip to Main Content
Forums

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Retrieving Blob field through ODBC on a Paradox database

843859Sep 23 2005 — edited Sep 30 2005
My guess is that this is impossible, at least with freeware software. All my attempts on querying through JDBC:ODBC on Paradox tables containing a blob field seems to show that these fields are invisible for JDBC:ODBC, and the only possibility is to retrieve the other normal fields.
If anyone has faced already this problem and knows the solution or at least something more than me, please help me. Any help will be appreciated. Thank you.

Comments

843859
1. Try to find pdxJDBC (Corel's type 3 Paradox JDBC
driver) according to
http://bdn.borland.com/article/0,1410,21642,00.html
to see whether it supports blob types.
If you know where I can find this driver please tell me.
843859
With your HTXX driver I end up with an Exception:

java.sql.SQLException: An invalid Paradox file header

Don't know what it measn since i can read normal fields through ODBC without any problem. And with this driver I end up with the same exception no matter which field I try to retrieve.
843859
It seems basically impossible to find on the web the so many times mentiones PdxJdbc.jar from Corel. And anyway I am not sure this would solve my problems since by what I have read it's not clear that it supoorts access to paradox graphic blob.

Anyway Yonghong Zhao, there's a problem on giving you the database table that give me the error since it contains personal photos from personnel of my client. The funny thing is that two other similar tables (but not important to me) can be accessed with your driver. And Paradox Tututility says for my table (Paradox 4) that file header is ok, and in fact the non blog fields can be accessed through jdbc.odbc but not with your driver. If this whole description says something to you about what I should do to correct the problem or what's the cause at all, please tell.
843859
then submit the new error code message of exception
to hxtt support page. Then your issue will be solve
soon.

Yonghong Zhao
System Analyst
www.hxtt.net
The exception message is:
An invalid Paradox file header: inner code 0x00A

Thank you very much for your incredible feedback.
843859
It worked! Thank you very much. We will continue to talk about how would it be possible for me to make a usage of your software.
843859
Hi ruijmfernandes,

I am facing the same problem.
I tried it your way but could not access www.hxtt.net.
Can you help, giving out the entire solution.

Regards,
Sharad.
843859
I can't distribute HXTT driver without their authorization. Try again to visit their homepage (hxtt.net) since it should be working (for me it's right now). You can find their the contacts for asking the driver and the documentation for using it with jdbc. If you want you can try the direct path: http://hxtt.net/paradox/. For retrieving the graphic blob use getBytes. That's all I can say about my solution. Good luck!
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 28 2005
Added on Sep 23 2005
#java-database-connectivity-jdbc
12 comments
505 views