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.
>
>