JDBC and AS400

[baijubr]

Hi,
I am using com.ibm.as400.a ccess.as400Jdbc DataSource(Jt40 0.jar) to read data from DB2 on AS400 V5R3. But here binary is not getting translated. when tried on V5R1 it works. ie binary is getting translated.
I tried even setting the property translateBinary = true, but no luck.
Is there any specific settings required for AS400V5R3.Any Idea?

Thanks in advance
-BR

[UniDyne]

Assuming you are working in a Windows environment, it might be a better idea to use a different approach. Instead of connecting to the DB2 database directly with IBMs JDBC driver, try using a Windows ODBC driver for DB2 to create an ODBC data source in Windows. Then use the JDBC/ODBC bridge to connect to the ODBC source. Generally, I have found that the more advanced features are better supported in the ODBC drivers than in the JDBC drivers in most packages. (The exception is Progress where the ODBC driver is crap and the JDBC driver is the only thing that works!)