Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.0
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT Paradox
Problem connecting paradox database
Sylvain
2007-07-23 21:19:52
Hello,
I didn't manage to connect to a paradox database using your Paradox_JDBC30 api. I took your example1.java src file (from Paradox_JDBC30demo.zip) and changed the url to "jdbc:paradox:///C:/air.db" (I have a air.db paradox database file on my C drive) and I got a "java.sql.SQLException: C:/air.db isn't a database!" error message.
I downloaded another paradox database from the internet ang got the same error message. I tried other url syntax " jdbc:paradox:/C:/air.db", "jdbc:paradox:///C:\\air.db" but I had always the same error.
Could you help me with this ?
Thanks a lot.

Sylvain
Re:Problem connecting paradox database
HXTT Support
2007-07-24 01:40:45
>"jdbc:paradox:///C:/air.db"
You should use
jdbc:paradox:///C:/
or
jdbc:paradox:/C:/
Re:Re:Problem connecting paradox database
Sylvain
2007-07-24 02:39:15
Thanks for your help. That's the solution I also found.
For the people who get the same problem, the url isn't the complete path to the database (including the file name) but it is only the directory where the database file is.
The database is selected after that in the sql statement.
Thanks again.
Re:Re:Re:Problem connecting paradox database
HXTT Support
2007-07-24 02:54:01
Thanks. We will use clearer error message in the next version to tell novice why.
Re:Re:Re:Re:Problem connecting paradox database
Sylvain
2007-07-29 21:39:21
Hi, here is the novice again .. ;o)

I got some problems selecting rows in my database. The database contains several columns (matricule, name, birthdate, num... with matricule a primary key). I would like to select a particular row (for example : GER01 Sylvain 04-12-77 0001) using a select * from air.db where matricule='GER01' but this statement return the names of the columns instead of my particular row.
If I use select * from air.db where matricule="GER01", I got a invalid column GER01 error. (Please note that matricule is a varchar field).
Reading your examples, I tried select * from air.db where matricule>=all(select matricule from air.db) which returns a row with the names of the columns and a row with the last matricule and its name, birthdate, ....

I have another error when I want to insert data into the database : insert into air.db values('GER02','Marc',25-06-75,0002) returns me "Failed to insert a new record into table air - An invalid index data block at position 2048 of C:\air.PX"
I think that this error is related to the first one, certainly a sql syntax trick ?

Thanks a lot if you can help me on this one !

Re:Re:Re:Re:Re:Problem connecting paradox database
HXTT Support
2007-07-29 22:22:41
You should run once "reindex all on air;" to rebuild air.PX.
Then you can use
select * from air where matricule='GER01'

>insert into air.db values('GER02','Marc',25-06-75,0002)
You can use
insert into air values('GER02','Marc',{d '1975-06-25'},2);
If air table has more than 4 columns, you should use
insert into air (matricule, name, birthdate, num) values('GER02','Marc',{d '1975-06-25'},2);
Re:Re:Re:Re:Re:Re:Problem connecting paradox database
Sylvain
2007-07-31 16:39:35
Well .. it works fine ! Thanks ! :o)

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Refund | Sitemap