I.T. Discussion Community!
-Collapse +Expand
Java
Search Java Group:

Advanced
-Collapse +Expand Java To/From
To/FromCODEGuides
-Collapse +Expand Java Store
PRESTWOODSTORE

Prestwood eMagazine

September Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyJava BoardJ2EE Topic   Print This     

PdxJDBC driver & how to get column names

PdxJDBC driver & how to get column names in J2EE topic (part of our Java group).

Quick Search: PdxJDBC   PdxJDBC driver   PdxJDBC driver &   how get   column names  
cdkemp
Frisco, TX, USA
Anyone know anything about a PdxJDBC driver beyond version 1.0? I am writing a Java app to connect to a Paradox database and pull ALL of the data out. I can connect to the DB with no problem, I can get the table names using the getTables() method in the DatabaseMetaData interface, but when I get to the getColumns() method I found out it is not supported in version 1.0 of the driver. Is there another way to get the column names (field names in Pardox-ese)? Is there a way to do it with straight SQL? Like SELECT all_column_names FROM table_name? Any ideas? Any news on a driver that would support the getColumns() method?

Thanks, Chris
 Posted 19 years ago (Thread Starter)
Comment Quote
About cdkemp -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #1508, 1 replies
Thread Started 3/23/2001 12:11:00 PM
View Counter=11744
Last Reply Posted 7/29/2001 10:04:00 PM)
Location=Frisco, TX, USA  
Joined=19 years ago   MB Posts=3  
Most Recent Post
Guardian
Canada
I know this is a little late, and a little hoaky in practice, but have you tried the JDBC-ODBC bridge drivers? This will work with any ODBC supporting platform... I the bridge drivers to connect to a Paradox database recently when I was testing it for an app that used Access (I already had a populated Paradox database at home and no Access one). All the resultsets and metadata seemed to work fine for me, it might be worth a shot.
It does require the extra step of setting up an ODBC data source on your PC, but that is relatively simple.
---
Never take life seriously,
Nobody gets out alive anyway!
 Posted 19 years ago
Comment Quote
About Guardian -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #3082 (Level 1.1)  Reply to 1508
Thread Started 7/29/2001 10:04:00 PM
View Counter=2
Location=Canada  
Joined=19 years ago   MB Posts=5  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1256A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #1508 Counter
11744
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech