Hi,
IB6 does support all this dialect 3 stuff, only the JDBC drive from the
InterClient Package does not support it, yet.
The scheme seems reasonable, only thing i don't know, is if the JDBC driver
mapping from java.Boolean to database boolean works (seems a must, but i got
very doubtul on these things without trying them ;-). I don't know if there
are other reserved words (see the IB6 docs).
I don't know how to set up a datasource.xml, never did it...
Regards,
Jens Stutte
> -----Urspr�ngliche Nachricht-----
> Von: Duffey, Kevin [mailto:[EMAIL PROTECTED]]
> Gesendet am: Mittwoch, 25. Oktober 2000 20:11
> An: Orion-Interest
> Betreff: RE: Interbase datasource??
>
> Question for you..when I create a database there is something
> that has a
> drop-down that says Dialect..and its always selected on 3.
> Doesn't that mean
> it supports it? I recall reading that IB6 supports D3 now, so
> I thought that
> it did.
I have build 308, but I know there is a newer
> build..maybe that one
> supports it?
>
> Anyways, so it seems like the datasource should look like so:
>
>
> <?xml version="1.0"?>
> <!DOCTYPE database-schema PUBLIC "-//Evermind//- Database schema"
> "http://www.orionserver.com/dtds/database-schemas.dtd">
>
> <database-schema name="Interbase" not-null="not null" null=""
> primary-key="primary key">
> <type-mapping type="java.lang.String" name="varchar (255)" />
> <type-mapping type="int" name="int" />
> <type-mapping type="long" name="int" />
> <type-mapping type="float" name="float" />
> <type-mapping type="double" name="double" />
> <type-mapping type="byte" name="byte" />
> <type-mapping type="char" name="char" />
> <type-mapping type="short" name="short" />
> <type-mapping type="boolean" name="boolean" />
> <type-mapping type="java.util.Date" name="timestamp" />
>
> <disallowed-field name="password" />
> <disallowed-field name="username" />
> <disallowed-field name="date" />
> </database-schema>
>
> Does that seem like it would work? I am not sure about the
> int, long, float,
> double, byte, char, short and boolean. I thought someone
> posted a schema
> before that they were using, and I can't seem to find it
> anywhere in my
> archives of emails. Its pissing me off because I can't even
> mess around with
> entity beans because of this.
>
> Incidentally, do you know how I would get Orion to use this
> schema? I see
> some datasources.xml file in the /config dir. Can each
> web-app be mapped to
> a different datasource if need be?
>
> Thanks again.
>
>
>
> > -----Original Message-----
> > From: Jens Stutte [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, October 25, 2000 9:01 AM
> > To: Orion-Interest
> > Subject: AW: Interbase datasource??
> >
> >
> > Hi,
> >
> > i have no datasource for interbase, since i am using only
> bean managed
> > persistence, but i can tell you some things. The current JDBC
> > driver for
> > Interbase (Interclient) does not support Interbases "dialect
> > 3". This means:
> > you can connect to "dialect 3" databases, but some features
> > will not be
> > availiable. The most important are:
> >
> > LONG INTEGER (64 Bit) database fields does not work. The
> > mapping of a java
> > long to a 32Bit INTEGER or a DOUBLE PRECISION or even a
> > textfield works.
> > For date/time values you should use a TIMESTAMP field in
> > Interbase, which
> > maps perfectly to a java timestamp with the "old" JDBC
> > driver. The other
> > date/time types do not work.
> >
> > All the rest seems to work fine (blobs, etc.) and the
> > performance seems very
> > good (though i did not test really huge databases by now). In the
> > documentation of IB6 (the PDF files, dont remember where is
> > the link) there
> > is a "Getting Started", which describes these migration
> > issues from IB4/5 to
> > 6.
> >
> > Regards,
> >
> > Jens Stutte
> >
> >
> > -----Ursprungliche Nachricht-----
> > Von: Duffey, Kevin [mailto:[EMAIL PROTECTED]]
> > Gesendet am: Montag, 23. Oktober 2000 21:41
> > An: Orion-Interest
> > Betreff: Interbase datasource??
> >
> >
> > Does anyone happen to have an Interbase 6 datasource that I
> > can get ahold
> > of? The old manuals I have for IB4 don't have anything about
> > the types and
> > what they map to in Java. I want to start playing around with
> > entity beans,
> > but until I get a mapping I don't think I can do this.
> >
> > Thanks.
> >
> >
>
