I'm driving Weblogic 8.1.3 on WinTel.
DB2 8.1.4 on Sun64.
I'm using Weblogic DB2's Type 2 driver, which has been very
reliable - so far.
I have a PreparedStateme nt that updates perfectly when
the table is define so that one particular column has
datatype VARCHAR(2000) .
The table was recently modified so that the data type for
the column is now VARCHAR(4000).
SQL statements continue to work perfectly when inserting data
consisting of 2000 or fewer characters.
Upon updating a column with 3990 characters the following
error occurs :
COM.ibm.db2.jdb c.DB2Exception : [IBM][CLI Driver] CLI0109E String data
right truncation. SQLSTATE=22001
I haven't a clue as to the source of the problem and that's
where your suggestions would be very helpful.
The DB2 Message Reference for CLI0190E suggests to use
SQLSetParam or SQLBindParamete r, but that doesn't sound like
advice relavant for a JDBC application.
A few google posts suggest that this is a database configuration
issue and that a change in a database configuration file
might fix things. If this is the case more information on
that would be very useful.
In some Google posts developers fathomed that this was an
issue which could be resolved with a different database
driver. Does the type 2 driver "not support" varchar 4000?
Thanks.
Nov 12 '05
18 5991 gi************* ******@yahoo.co m wrote: Thanks for the tips everyone.
Strange. I have a javascript alert that tells me that the length of the string coming from the textbox is 3999. But somehow, by the time the data attempts to get saved the length of the String is 4157.
I did try out the WebLogic Type 4 driver for DB2. The message was :
[BEA][DB2 JDBC Driver][DB2]Character data, right tuncation occured; for example, an update or insert value is a string that is too long forthe column, or a datetimevalue cannot be assigned to a host variable, because it is too small.
It looks like validating the length of the data on the server side will solve my problems.
...
BTW, Attempting to save with 27000 characters and the Type 2 driver killed the server and crashed the JVM.
Yes. We heartily recommend sticking to a type-4 driver, which
won't be able to kill the Application Server.
Joe Weinstein at BEA From hs_err_pid2224. log :
An unexpected exception has been detected in native code outside the VM. Unexpected Signal : EXCEPTION_GUARD _PAGE (0x80000001) occurred at PC=0x6C121EDB Function=SQLPro cedureColumns+0 x54993 Library=C:\PROG RA~1\IBM\SQLLIB \BIN\DB2CLI.dll
Current Java thread: at COM.ibm.db2.jdb c.app.DB2Prepar edStatement.SQL Execute(Native Method) at COM.ibm.db2.jdb c.app.DB2Prepar edStatement.exe cute2(Unknown Source)
One thing that's not so great about the type-4 driver is that the
SQL statement :
"VALUES NEXTVAL FOR SCHEMA_NAME.SEQ UENCE_NAME"
results in :
[BEA][DB2 JDBC Driver][DB2]UNACCEPTABLE SQL STATEMENT" gi************* ******@yahoo.co m wrote: One thing that's not so great about the type-4 driver is that the SQL statement :
"VALUES NEXTVAL FOR SCHEMA_NAME.SEQ UENCE_NAME" results in :
[BEA][DB2 JDBC Driver][DB2]UNACCEPTABLE SQL STATEMENT"
Hi. Show me the few lines of JDBC that try to use
this SQL and I'll see about getting it fixed for you.
Joe Weinstein at BEA
If you like, followups can go to the online BEA JDBC newsgroup.
Following up to weblogic.develo per.interest.jd bc
See topic "DB2 sequences and type-4 driver"
Not in this case since the text consisted of 3999 'a' characters.
I fathom that it's an IE/textarea/wrap issue. gi************* ******@yahoo.co m wrote: Not in this case since the text consisted of 3999 'a' characters. I fathom that it's an IE/textarea/wrap issue.
Needs further examination on the output. Just do a System.out.prin t(...)
on the String you receive from the webform to see if there are any \n or
\r in it.
Bernd
--
"Ja, alles meine Herren" sprach Fürst Lichnowsky. "Ooch det roochen?"
"Ja, auch das Rauchen." "Ooch im Tiergarten?" "Ja, auch im Tiergarten
darf geraucht werden, meine Herren." Und so endeten die Barrikadenkämpf e
des 18. März in Berlin gi************* ******@yahoo.co m wrote: Following up to weblogic.develo per.interest.jd bc
See topic "DB2 sequences and type-4 driver"
Hi. I didn't see any post yet. You can also email me at
j
o
e
AT
b
e
a
DOT
c
o
m
"Larry Menard" <ro**@GoSpamYou rself.com> wrote in message
news:P9******** *************** *******@rogers. com... It was 4K.
How do you expect to store a column larger than 4K in 4K page (and 4K
bufferpool)? Long varchar is OK because the data is not stored in the row
(like LOB's) and it does not make use of bufferpools (data is read and
written directly to disk).
I know that. I wasn't asking a question, I was just sharing an experience.
--
--------------------
Larry Menard
"Defender of Geese and of All Things Natural"
"Mark A" <no****@nowhere .com> wrote in message
news:2t******** *************** *******@comcast .com... "Larry Menard" <ro**@GoSpamYou rself.com> wrote in message news:P9******** *************** *******@rogers. com... It was 4K. How do you expect to store a column larger than 4K in 4K page (and 4K bufferpool)? Long varchar is OK because the data is not stored in the row (like LOB's) and it does not make use of bufferpools (data is read and written directly to disk). This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Vani Kancherlapalli |
last post by:
Hi
The maximum length of a nvarchar could be 4000 characters while that of
varchar could be 8000.
We are trying to use unicode which would require that the datatype for
one our fields be converted from varchar to nvarchar. But looks like
this would result in loss of existing data.
Is there a way to do this without loss of data?
|
by: Dan Williams |
last post by:
I'm trying to do a simple alteration to the table design of one of our
SQL 2k tables, simply changing an identity row so that its not 'not
for replication', and its taking absolutely ages to do so, and stops
the sql server from working.
Whilst it's attempting the update, no one can access the database, the
sqlservr.exe memory usage shoots up and enterprise manager reports a
not responding status. Eventually after about 10 minutes, it...
|
by: herman |
last post by:
Hello,
I am experiencing some performance issues with the dbo.sysindexkeys.
I wonder if anyone can help me create an index on it?
Thanx!
SQL script:
|
by: Mahesh |
last post by:
Hi,
I am writing a SP in MSSQL. One of the parameted is VARCHAR type
which have comma seperated INT vlaues. I want to use this varible in
WHERE clause against INT type coloum. how do I achive this.
eg. DECLARE @CompanyTypeIDs VARCHAR(200)
SET @CompanyTypeIDs = '1,3,2'
Currently I am using it as
SELECT CompanyTypeID FROM Company WHERE CompanyTypeID IN (1,2,3)
|
by: gimme_this_gimme_that |
last post by:
after altering a table to use varchar(4000) instead of varchar(2000) is
a DB2 database restart required?
Thanks.
| |
by: Tzanko |
last post by:
As we all know, there is a 8060 bytes size limit on SQL Server rows. I
have a table which requires a number of text fields (5 or 6). Each of
these text fields should support a max of 4000 characters. We currently
store the data in varchar columns, which worked fine untill our
appetite for text fields increased to the current requirement of 5, 6
fields of 4000 characters size. I am given to review a design, which
esentially suggests moving...
|
by: Chris Moore |
last post by:
Hello,
I am attempting to write a stored procedure that builds and executes a
dynamic SQL statement which can be up to 8000 characters long.
Therefore, I have declared a variable of type varchar(8000) which,
according to the documentation, is the maximum acceptable length of
such a variable. Unfortunately, however, SQL Server seems allow
varchars to only be half this size: the resulting string keepings
getting truncated to 4000...
|
by: Okonita |
last post by:
Hi everyone,
I have been building a set of tables for a new database and having
problem with tables having columns defined as Long Varchar. Can
someone look this over and tell me what I am doing wrong with the
create statement shown below:
Error Msg:
DB21034E The command was processed as an SQL statement because it was
|
by: guest1 |
last post by:
seems to be a problem in my first case stmt here i need to convert this and i dont know how, hope somebody can help me out
select distinct top 10
tplan.plan_long_nm,
asset.ast_cntr_pol_num,
'As of Date' = convert(varchar(12),val.pcov_vlu_asof_dt,101),
'Cash Surrender Value' = val.pcov_cash_sur_amt,
'MVA Index Value / Account Value' = case when grp.prem_pmt_typ_cd in ('FPDA', 'NA') then 'needs mapping' else null end,--These values...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |