*Hi all!

I think I found a bug in firebird-jca-jdbc-driver.

Here is a description of it:

I am using:

-> Database: INTERBASE 6.01 under Linux
-> JDBC driver firebird-jca-jdbc-driver 1.0.1
(downloaded from sourceforge under the name of
FirebirdSQL-1.0.1.zip)
-> J2SDKSE 1.4.2_03 (tried with 1.4.1_01 also. Same
BUG) under windows

When I try to extract primary key information from a
table with DatabaseMetadata interface I have a
java.sql.DataTrucation exception when table name is 31
characters long (I think this is Interbase's maximum
limit for a table name).

You can certainly test this is true with this small
test case:

-------------------

import java.sql.*;

public class JaybirdErrorTestCase {
public static void main(String[] args) {
try {


Class.forName("org.firebirdsql.jdbc.FBDriver");

Connection conn =
DriverManager.getConnection(

"jdbc:firebirdsql://192.168.16.5//opt/interbase/data/tape-central.gdb?sql_role_name=ROSHKA",
"sysdba",
"asdf"
);
conn.setAutoCommit(false);
// This will throw an
java.sql.DataTruncation exception!!!
// Only happens with 31 character length
table names!!! ResultSet rs =
conn.getMetaData().getPrimaryKeys(null, null,
"PLANILLAS_PREVISION_MANTENIMIEN");
} catch (Exception e) {
e.printStackTrace();
}

}
}

-------------------

Anybody in this list is from driver's development team
that can give an answer?

I certainly don't want to change table names because I
have a Delphi front end already deployed in a
production environment with this tables related.

Anybody can help?

Thank you all in advance...*

--
----
Pablo Javier Santa Cruz Cosp
Roshka - "La vanguardia es así"

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com