Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2004
    Posts
    1

    Unanswered: newline character problem with db2 jdbc type - 4 driver (db2jcc.jar)

    hi,
    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
    emp
    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
    appreciated.


    thanks
    nivask
    Last edited by nivask; 01-24-04 at 00:39.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •