Subject Re: [Firebird-Java] Re: How to enable logging in JayBird
Author Nikolay Ivanchev
Post date 2003-03-05T13:53:49Z
Thanks for the information. Actually... my column is varchar(1200) so
I havn't made a stupid error. column definition is what I checked first
I will dig into the problem, and If I find that this is jaybird related I will post
test case
 
Thanks again
Niki_iv
----- Original Message -----
Sent: Wednesday, March 05, 2003 2:30 PM
Subject: [Firebird-Java] Re: How to enable logging in JayBird

Hi,

> I want to enable logging via log4j
> what parameters I must pass to jaybird driver to enable this feature

Use -DFBLog4j=true option when starting JVM. Also be sure to have the
logging enabled in log4j configuration.


> Actually I am tracing a problem with borlands db components
> every update or insert containing table columnt varchar which length
> is more than 255 characters fail complaining about truncating

If your column is defined as VARCHAR(255) and you are
inserting/updating more than 255 characters, that's exactly the
message you will get.

VARCHAR(255) defines a character column that can contain strings,
length of which is not more than 255 characters, but can be less.

CHAR(255) defines a character column that contains strings, length of
which is exactly 255 characters, shorter strings are padded with
spaces to get specified length.

If you need a string that can grow, use BLOB SUB_TYPE 1, this is
equivalent to MEMO type.

Best regards,
Roman Rokytskyy



 

To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.