I am working in similar environment and never faced problem like that. All I can say is that we are working with custom JTOpen JDBC driver http://www-03.ibm.com/systems/i/software/toolbox/ (jt400.jar is all you need)
JDBC URL: jdbc:as400://<server_ip_address>;libraries=<list_of_libraries>;date format=iso;time format=iso;naming=system;transaction isolation=none;errors=full;cursor hold=false;extended dynamic=true;secure=false;trace=false;data compression=true Driver class: com.ibm.as400.access.AS400JDBCDriver We are working on DB2 V5R4 i5/OS @ AS/400 Hope this helps Best Regards, Marko Simic >I know it's usually pretty pointless to post my DB2 issues to cf-talk >but it's always worth a shot. > >I have an issue (64 bit coldfusion 8.0.1 multi-server on Win2k8) >where, if I do a simple query to our DB2 mainframe database, the >exclamation mark character in any string fields is returned as a right >closing bracket instead. I believe this is because the driver or >wrapper is improperly translating the exclamation mark from the EBCDIC >character set into ASCII - supposed to be ascii 33 but is coming >through as ascii 93 instead. > >I think this might be specific to coldfusion's JDBC wrapper, because >it occurs when I use the built in JDBC driver (from Data Direct, I >think), as well as a third party JDBC driver that we purchased >(StarSQL DB2). > >I suspect I need to call Adobe on this, but thought I'd hit the list first. > >Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335020 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
