Unanswered: newline character problem with db2 jdbc type - 4 driver (db2jcc.jar)
i am on windows 2000 professional edition, db2 v8.1 server.
we are migrating from 7.2 to 8.1. some of our java code has
newline characters in its sql statements. like
select * from
instead of select * from emp.
this used to work fine with db2 v7.2, type - 2 driver. but is throwing
sqlexception with type-4 driver (db2jcc.jar) , it is chopping the line
at select * from and gives a incomplete statement error.
i have tried the same code with type-2 driver (db2java.zip) . it works
fine. could you let me know if it a known issue before i change my
code to remove the newlines. or if there is anything i am missing
in my server or driver cconfiguration setup. your help is greatly