Moin Micha,
Michael Strobel wrote:
Hi Ocke,
Your patch work's fine with the test programs, but I'm still unable to
read and write long varchar columns in OO Base. I guess OO Base may be
mislead by our JDBC driver, which unfortunately returns always 0 for the
length and precision of long varchar columns.
Methods that return always 0 for the length and precision of long
varchar columns:
- XConnection.getMetaData().getTypeInfo() in PRECISION (column 3)
- XConnection.getMetaData().getColumns(...) in COLUMN_SIZE (column 7)
- XResultSetMetaData.getPrecision(...)
It's possible to switch our JDBC driver in two different modes.
First mode disables use of clobs, long varchar columnss are described as
type -1 in ResultSetMetaData. This mode causes OO Base to freeze, when
it tries to read long varchar column using getString().
Second mode enables use of clobs, long varchar columnss are described as
type 2005 in ResultSetMetaData. In this mode Base displays the long
varchar columns always empty, values may be entered, but disappear as
you leave the input field with the cursor and don't go to the database.
Could the length and precision values cause such a behavior in Base?
No, the length and precision are only used when you try to change the
table layout or to create a new table.
The problem here seems to be that the data could not be read. The method
getString should always return something.
So may be calling getString for a long var char column doesn't work for
your jdbc driver.
Best regards,
Ocke
Best regards,
Micha
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Nagelsweg 55 mailto:[EMAIL PROTECTED]
D-20097 Hamburg http://www.sun.com/staroffice
Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1,
D-85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Thomas Schroeder Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
