#3 Oracle RAW Data Format Support Question

[Michael]

When I run an SQL over an Oracle DB from the DB2/400 DB, which has a RAW column in it, the data comes out misaligned.

[Michael]

Sorry I hit post too soon.

If I had to guess, not being a java developer, I'd say ARXD0100Handler.java needs to have an "else if" for ct == Types.BINARY as I assume RAW is the same as that. Here are a few links I found that are related

http://docs.oracle.com/cd/F49540_01/DOC/java.815/a64685/oraext3.htm
https://google-developers.appspot.com/cloud-sql/docs/datatypes

Regardless, thanks for the project, it is very cool!

[Dieter Bender]

ArdGate is focussed on Standard SQL and RAW isn't a standard SQL Type. The Solution for this is to cast from and to a supported ANSI SQL Type. Maybe support for such extensions will be added in one of the next Release, or with needed Bug Fixes.

Dieter

[Michael]

Thank you. So far my work around is just that, RAWTOCHAR function allows me to cast the data to character.

Regardless, thank you for the great product.
Michael

[cid:image003.png@01CFB21A.5816B250]

Michael Mayer-Oakes
Project Lead
500 Crocker Drive. Vacaville, CA. 95688
Phone: 707-452-2868 | www.mariani.comhttp://www.mariani.com/

[cid:image002.jpg@01CEEF5F.DB0F07D0]

Celebrating over 100 years of being your Global Supplier of Dried Fruits and Snacks.

Please consider the environment before printing this email.

From: Dieter Bender [mailto:benderd@users.sf.net]
Sent: Thursday, August 07, 2014 8:32 AM
To: [appserver4rpg:bugs]
Subject: [appserver4rpg:bugs] #3 Oracle RAW Data Format Support Question

ArdGate is focussed on Standard SQL and RAW isn't a standard SQL Type. The Solution for this is to cast from and to a supported ANSI SQL Type. Maybe support for such extensions will be added in one of the next Release, or with needed Bug Fixes.

Dieter

---

[bugs:#3]http://sourceforge.net/p/appserver4rpg/bugs/3 Oracle RAW Data Format Support Question

Status: open
Group: v1.0 (example)
Created: Thu Jul 31, 2014 05:52 PM UTC by Michael
Last Updated: Thu Jul 31, 2014 05:56 PM UTC
Owner: nobody

When I run an SQL over an Oracle DB from the DB2/400 DB, which has a RAW column in it, the data comes out misaligned.

---

Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/appserver4rpg/bugs/3/https://sourceforge.net/p/appserver4rpg/bugs/3

To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/https://sourceforge.net/auth/subscriptions