cancel
Showing results for 
Search instead for 
Did you mean: 

windows-850

Former Member
0 Kudos

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...

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Mark,

I'll verify that the DEV team has seen your report for the change in behavior.

Edgar

Former Member
0 Kudos

Thanks Edgar,

any further information would be greatly appreciated.

Mark

Answers (6)

Answers (6)

0 Kudos

For better reproducing the error I add a simple example repository to github:

https://github.com/rentasad/advantageDatabaseServerConnectionError

I hope this is helpfully.

0 Kudos

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

jhoehne
Participant
0 Kudos

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

0 Kudos

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
Participant
0 Kudos

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?

Former Member
0 Kudos

Any news?

Is this going to be fixed? Any schedule?

Best regards

Mark

HakanHaslaman
Product and Topic Expert
Product and Topic Expert
0 Kudos

The engineering already investigated in this issue. If you want to give this issue a priority, please send me a support incidents, which I can forward to the engineering.

Former Member
0 Kudos

Sorry but that sounds as if SAP knows about the problem, but decided to kick the can down the road...

HakanHaslaman
Product and Topic Expert
Product and Topic Expert
0 Kudos

That what I mean in my last posting is, that the engineering are working on this issue and I request a status update. If I get any feedback from the engineering, I will let you asap know about it.
But if this an issue with priority for you, I would recommend to open a support incident, so we can set a priority.

0 Kudos

Hello,

I have the same Problem. (Systemlanguage: German)

If I'm execute an CREATE and INSERT Query with the JDBC adsjdbc.jar from Version 11.10, then I can't read the tables and get the

[iAnywhere Solutions][Advantage JDBC]windows-850 Error.

If I'm use the adsjdbc.jar from Version 11.0, then the same Procedures worked fine.

The Database Server has the versoin 11.10.0.24 and I connect my Client with the following connection ADS_LOCK_TYPE: "proprietary"

ADS_CHAR_TYPE: "OEM"

ADS_TABLE_TYPE: "cdx"

I believe it is a bug and need a bugfixing!

thanks for your investigation on this issue!

Best regards

M.Staud

HakanHaslaman
Product and Topic Expert
Product and Topic Expert
0 Kudos

The engineering already investigate on this issue.

HakanHaslaman
Product and Topic Expert
Product and Topic Expert
0 Kudos

The Engineering was not able to reproduce this issue. They built a simple Java application with the mentioned connection string and fired you said queries and we are not getting any error/exception/dump. Please provide me a test database for reproduction and specific the client you are using, so I can provide it to the Engineering.

Former Member
0 Kudos

Hey,

thanks for the answer.

You can download the DB here.

user: adssys

pw: blank

The client I used for testing was squirrel.

It happens with every adsjdbc >= 11.10, every time I execute a query on table1...

Hope this helps.

Mark

HakanHaslaman
Product and Topic Expert
Product and Topic Expert
0 Kudos

I already forward it to the engineering and if I get any news, I will let you asap know about it.

HakanHaslaman
Product and Topic Expert
Product and Topic Expert
0 Kudos

The engineering try with your database and client, but still not able to reproduce the issue. You are getting a conversion error, so could you try to change from OEM to ANSI and see if the issue is still occurring please? It can help us to narrow down the problem.

Former Member
0 Kudos

I don't get this error when I change the character type to ANSI...

I don't understand why the engineering doesn't get this error, I get it every time I try to SELECT something from the table, the last working version is adsjdbc-11.0.x, adsjdbc > 11.10.x is not working on any Linux/Windows system I tried...

HakanHaslaman
Product and Topic Expert
Product and Topic Expert
0 Kudos

I forward your result to the engineering. If they have any additional idea, I will let you know about it.

Former Member
0 Kudos

You mentioned that they didn't get this error when they tried, I would really like to know how they managed to do it...

From my experience adsjdbc >= 11.10.x doesn't support DBF/CDX with OEM data, because it fails every time on different platforms...

HakanHaslaman
Product and Topic Expert
Product and Topic Expert
0 Kudos

Could you please give us:


1) adscollate table with ADM file

2) Your OS version

3) Your default language in ADS server and your machine

Former Member
0 Kudos

Hey,

1.: http://carry.de/downloads/ads/adscollate.zip

2.:

OS Name:                   Microsoft Windows 10 Pro

OS Version:                10.0.10586 N/A Build 10586

OS Manufacturer:           Microsoft Corporation

OS Configuration:          Standalone Workstation

OS Build Type:             Multiprocessor Free

Had the same problem with win 7...

3:  Systemlanguage is german

     ANSI AND OEM Character Set are both german

HakanHaslaman
Product and Topic Expert
Product and Topic Expert
0 Kudos

Mark, after changing the OEM_CHAR_SET to German, we was able to re-create this issue. Th engineering will will investigate on this issue. If I get any news, I will let you asap know about it.

Former Member
0 Kudos

Any news on this bug? Version 12 is also affected...

Mark

HakanHaslaman
Product and Topic Expert
Product and Topic Expert
0 Kudos

Will request an update from the engineering and come asap back to you.

HakanHaslaman
Product and Topic Expert
Product and Topic Expert
0 Kudos

Engineering is still working on this. If I get any news, I will let you asap know about it.