Connecting Tech Pros Worldwide Forums | Help | Site Map

Problems with DB2 type 4 driver

Tom Davies
Guest
 
Posts: n/a
#1: Nov 12 '05
I'm trying to change from the old db2java.zip JDBC driver to the new
universal driver.

I now get errors like the one below on SQL which worked before.

[sql] Failed to execute: RENAME TABLE ACF009 TO
ACF009GLDissection;--FOR SYSTEM NAME ACF009

[sql] com.ibm.db2.jcc.b.SQLException: An unexpected token ""
was found following "". Expected tokens may include: "O
ACF009GLDissection".

This is using 8.1.5 on Windows XP, JDK 1.4.2, running a script from
the ant sql task.

Has anyone else seen this?

Thanks,
Tom

Tom Davies
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Problems with DB2 type 4 driver


Tom Davies wrote:[color=blue]
> I'm trying to change from the old db2java.zip JDBC driver to the new
> universal driver.
>
> I now get errors like the one below on SQL which worked before.
>
> [sql] Failed to execute: RENAME TABLE ACF009 TO
> ACF009GLDissection;--FOR SYSTEM NAME ACF009
>
> [sql] com.ibm.db2.jcc.b.SQLException: An unexpected token ""
> was found following "". Expected tokens may include: "O
> ACF009GLDissection".
>
> This is using 8.1.5 on Windows XP, JDK 1.4.2, running a script from
> the ant sql task.
>
> Has anyone else seen this?[/color]

My fault -- I was actually still using the original driver, not the
fixpak 5 version. The new one doesn't fix this particular problem, with
the comment after the semicolon, but it does fix many similar problems,
it seems.

Tom
Closed Thread