473,320 Members | 1,926 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

DB2 v 8.1 universal JDBC Driver Weird behavior in WSAD 5.1.x and WAS 5.0.2

Hi,

I am configuring the same DB2 v8.1 JDBC universal driver (db2jcc.jar
and db2jcc_license_cisuz.jar) from DB2 SP5 fix pack under WSAD 5.1.x
environment and WebSphere application Server 5.0.2 on Windows 2000
machines. I configured a connection pool data source using type 4 for
a local test environment in WSAD 5.1.x, and a connection pool data
source on the WebSphere Server too. Both data sources are accessing
the same database.

The weird behaviour I have noticed:

In the WSAD 5.1.x environment, the log shows the JDBC driver version
is 1.9.23 as below:

.... WSRdbDataSour u Database version is
SQL08013
.... b509899 WSRdbDataSour u JDBC Driver version is
1.9.23

But on the WebSphere app server, the JDBC driver version is 1.3.71 as
below:

.... WSRdbDataSour u Database version is
SQL08010
.... b509899 WSRdbDataSour u JDBC Driver version is
1.3.71

I had configured both data source's JDBC providers to use the same
JDBC driver files I have list above. But somehow the data source on
the WebSphere server still thinks it's using an old version of the
univresal JDBC driver. The net result is that the .getString() method
on a CLOB column fails with the following error:

com.ibm.db2.jcc.b.SqlException: The length method on locator-based,
mixed character set Clob objects is not supported.

Any idea on what it means? because the db is not UTF-8?

But the same code works happily in the WSAB 5.1.x test environment.

The version 1.3.71 JDBC universal driver comes from DB2 V81. SP1, it
works fine except it does not work on the LOBs with those
get/setString on CLOBs and set/GetBytes on BLOBs. That problem is
consistent with WSAD 5.1.x, i.e. the LOBs do not work under the 1.3.71
version of universal JDBC driver. But it does work after I upgraded it
to 1.9.23 driver.

Any advice why I can not make the WebSphere app server to recognize
the newer version of the JDBC universal driver? What is the possible
cuase of the above error meesgae (i.e. com.ibm.db2.jcc.b.SqlException:
The length method on locator-based, mixed character set Clob objects
is not supported. )
Your help would be greatly appreciated.
Thanks.
Nov 12 '05 #1
0 2019

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Priya | last post by:
Hi, I am having some problem with DB2 Universal JDBC driver. 1. The method getColumnType(columnNumber)of ResultSetMetaData always returns zero. 2. The method getColumnDisplaySize(ColumnNum)...
4
by: Dani | last post by:
Hi everyone Description of the problem: Using a PreparedStatement to write down an integer (int) plus a timestamp for testing purposes. When read out again the integer looks very different. We...
0
by: Bing | last post by:
Hi, I am configuring the same DB2 v8.1 JDBC universal driver (db2jcc.jar and db2jcc_license_cisuz.jar) from DB2 SP5 fix pack under WSAD 5.1.x environment and WebSphere application Server 5.0.2...
2
by: Raquel | last post by:
Read this about the Universal JDBC Driver.... "In a Type 2 mode, the Universal JDBC driver provides local application performance gains (because it avoids using TCP/IP protocol to communicate to...
0
by: aj | last post by:
DB2 v8 FP5 Red Hat AS/EL 2.1 I am specifying properties for a DB2 Universal JDBC Driver connection in my Java/JDBC app by creating a java.util.Properties object and passing it along in my...
2
by: charl | last post by:
Hi, My apologies in advance if my terminology is slightly confused, I am new to all this. We have previously been running some SQL on DB2 (v7) utilising a type 3 driver, and have made the...
1
by: sbanil | last post by:
We have a JAVA application which uses following Database product name : DB2 Database product version : DSN07012 JDBC driver name : IBM DB2 JDBC Universal Driver Architecture JDBC driver version ...
1
by: tom.eeraerts | last post by:
Hello, I have a problem migrating an application from v5r2 to v5r3. The problem is with the prepared statements. To see what the problem is, i extracted a small piece of code and debugged the...
1
by: dunleav1 | last post by:
Does anyone know the link of IBM's web site for the Universal JDBC driver for DB2? I just can't find it. Thanks, JD
0
by: dunleav1 | last post by:
How can I be sure that DB2_LINUXAIO is working properly in DB 9 FP3? The parameter db2_linuxaio was depreciated from the base version to FP3 and my performance tests have shown a decrease in...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.