Re: Enhydra: Interbase 64 bit Problem

[Brooke Hedrick <brooke_hedrick@xxxxxxxxxxxxxx>]

I am using Interbase 6 server on Windows2k with the Interclient 1.6 for jdk 
1.2.  on Red Hat Linux 6.2.  You can download this via 
ftp://ftp.interbase.com/pub/products/InterClient/IC160001LinuxJRE12.tar.gz 
.  So far, I have had no problems retrieving the TIMESTAMP fields in my 
tables.  At this point, I have not set the date fields yet, but I would be 
surprised if the setters didn't work for this and the getters did.

It appears that the 1.6 version of Interclient supports at least some of 
the dialect 3 features.  I cannot find anything that explicitly states the 
support of dialect 3, but empirically, it does seem to provide the needed 
support.

At 11:46 AM 9/29/00 -0700, Bill Karwin wrote:
> Marc Spitzer wrote:
> >
> > Interbase 6 has 2 dialects for production use, 1 & 3.   dialect 1 is for
> > backward compatibility and does have the new v6 features, 64 bit ints for
> > example.  Check to see if your database is created a dialect 1 database, if
> > it is you do not have 64 bit ints, or it could be your jdbc driver is
> > dialect 1(is that possible???).  If you want the new features of v6 create
> > the db as dialect 3.
>
> InterBase's JDBC driver _only_ supports dialect 1.  They haven't updated
> it to support the new datatypes in InterBase 6.  There's no word on when
> (or if) they will do this.
>
> You can access a dialect 3 database with a dialect 1 client as long as
> your queries don't reference any of the specific columns that use
> dialect 3 dependant datatypes.
>
> InterBase's dialect 3 features are:
> - the 64-bit exact NUMERIC datatype
> - SQL-compliant TIMESTAMP, DATE, and TIME datatypes
> - delimited identifiers
>   (e.g. SELECT "Key" FROM "My Table").
>
> --
> Bill Karwin (bill@xxxxxxxxxx)
> Application Architect - Lutris Technologies Inc.
> -----------------------------------------------------------------------------
> To unsubscribe from this mailing list, send email to majordomo@xxxxxxxxxxx
> with the text "unsubscribe enhydra" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-enhydra@xxxxxxxxxxxx


Brooke Hedrick
MillaMilla Enterprises
brooke_hedrick@xxxxxxxxxxxxxx
http://www.millamilla.com

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@xxxxxxxxxxx
with the text "unsubscribe enhydra" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-enhydra@xxxxxxxxxxxx