windows-850

[Former Member]

Hi,

I get the following Error when I try to read Data from a dbf/cdx table ( Character type is OEM) with the newest jdbc driver (11.10.0.22/24). It worked with an older Version(11.0.x)...

com.extendedsystems.jdbc.advantage.ADSException: [iAnywhere Solutions][Advantage JDBC]windows-850
at com.extendedsystems.jdbc.advantage.n.a(Unknown Source)
at com.extendedsystems.jdbc.advantage.n.a(Unknown Source)
at com.extendedsystems.jdbc.advantage.m.a(Unknown Source)
at com.extendedsystems.jdbc.advantage.ADSResultSet.if(Unknown Source)
at com.extendedsystems.jdbc.advantage.ADSResultSet.first(Unknown Source)
at com.extendedsystems.jdbc.advantage.ADSResultSet.next(Unknown Source)

The Errorcode is '5423'.

I can reproduce this Error with a fresh DD and a minimal table:

1. Create default DD in Architect
2. connect with DD through e.g. SQuirrel ( connURL: "jdbc:extendedsystems:advantage://localhost:6262;Catalog=D:\test-850\test-850.add;ShowDeleted=false;CharType=OEM;TableType=cdx", adsjdbc: 11.10.0.22/24)
3. execute: "CREATE TABLE table1 ( field1 CHAR(1) ) IN DATABASE"
4. execute: "SELECT * FROM table1" --> works
5. execute: "INSERT INTO table1 VALUES ('1')"
6. execute: "SELECT * FROM table1" --> windows-850

Thanks for any help...

[former_member1253009]

Hi,
I have the same Problem.
Is there any solution after 7 Years ?
Best regards!

[jhoehne]

OEM/CDX? Do you really use a DOS database?

[former_member1253009]

Yes I don't have a choice.

Our merchandise management uses the database and I have to use the database to implement interfaces to our shop system. For this reason I need a patch for this bug.

[jhoehne]

You first asked 6 years ago. As it's very unlikely that this bug will ever be fixed - did you try using a JDBC to ODBC bridge and use the ODBC driver for ADS?