How to change to an older JDBC driver

[yongsing]

I have a Windows 2000 Server machine that runs DB2 UDB v7 fixpak 11. I
also have a Java program that uses JDBC to insert data into the
database.

Sometimes, the program encounters SQL0302N error ("The value of a host
variable in the EXECUTE or OPEN statement is too large for its
corresponding use", SQLSTATE=22001) when it tries to insert a
particular data into a table.

On my notebook, if I run the same program with the same data (and same
Java Runtime Environment 1.4.2), the program can insert the data
successfully into the database on the Windows 2000 Server machine. The
only difference is that my notebook's DB2 v7 is using a lower fixpak
than fixpak 11.

Therefore, I am suspecting that the new JDBC driver that comes with
fixpak 11 is causing the SQL error when the program runs on the
server.

I would like to try using the same JDBC driver on the server as on my
notebook. I know that I need to change db2java.zip file to the same
version as the one my notebook. What other file do I need to change? I
seem to remember that there's a particular DLL file that I need to
change as well.

Thanks in advance.

Yong Sing

[Fan Ruo Xin]

I thought it is db2jdbc.dll.

"yongsing" <oh********@yahoo.com.sg> wrote in message
news:59**************************@posting.google.c om...

I have a Windows 2000 Server machine that runs DB2 UDB v7 fixpak 11. I
also have a Java program that uses JDBC to insert data into the
database.

Sometimes, the program encounters SQL0302N error ("The value of a host
variable in the EXECUTE or OPEN statement is too large for its
corresponding use", SQLSTATE=22001) when it tries to insert a
particular data into a table.

On my notebook, if I run the same program with the same data (and same
Java Runtime Environment 1.4.2), the program can insert the data
successfully into the database on the Windows 2000 Server machine. The
only difference is that my notebook's DB2 v7 is using a lower fixpak
than fixpak 11.

Therefore, I am suspecting that the new JDBC driver that comes with
fixpak 11 is causing the SQL error when the program runs on the
server.

I would like to try using the same JDBC driver on the server as on my
notebook. I know that I need to change db2java.zip file to the same
version as the one my notebook. What other file do I need to change? I
seem to remember that there's a particular DLL file that I need to
change as well.

Thanks in advance.

Yong Sing