[Bill Oliver]

Consider the following table, created in Firebird:

create table biTest (bi bigint); 

I notice that when I use the DB Explorer through to Firebird with the Jaybird JDBC driver, the data type for the table is BIGINT and the size is 0.

If I try to “Generate Table Script”, this will generate

create table "BITEST"(
"BI" BIGINT(0))

Since Firebird doesn’t support having a size for bigints, this will fail. I believe there should be a check for BIGINT’s, if the size is 0, then don’t add the (size) info.

This was with Jaybird 2.0.1, and Firebird 2 Beta 2 (although this should also be the same in Firebird 1.5).

-bill oliver

[Haris Peco]

Bill,

This is problem in ‘generate table script’ – jdbc driver return 0 (except null) for this field.
We will fix this problems in futures release

Thanks

[Bill Oliver]

I see this same behavior with INTEGER type in Firebird/Jaybird, too.

It’s a little different in this case – the table preview shows Data Type INTEGER, size 10, decimal digits 0.

Thanks.

[Haris Peco]

Bill,

It is values which jdcb driver return.Please, be patient, we will try resolve this.

Best

[Author]

Posts