Here it goes:
database-schema, FILE: interbase.xml
<database-schema name="Interbase" not-null="not null" null="default null"
primary-key="primary key" max-table-name-lenght="30">
<type-mapping type="java.lang.String" name="VARCHAR(255)" />
<type-mapping type="int" name="INTEGER" />
<type-mapping type="long" name="NUMERIC(20,0)" />
<type-mapping type="float" name="FLOAT" />
<type-mapping type="double" name="DOUBLE PRECISION" />
<type-mapping type="byte" name="NUMERIC(10,0)" />
<type-mapping type="char" name="CHAR(1)" />
<type-mapping type="short" name="SMALLINT" />
<type-mapping type="boolean" name="NUMERIC(1,0)" />
<type-mapping type="java.util.Date" name="DATE" />
<type-mapping type="java.util.Time" name="TIME" />
<type-mapping type="java.util.TimeStamp" name="TIMESTAMP" />
<type-mapping type="java.io.InputStrem" name="BLOB" />
<disallowed-field name="password" />
<disallowed-field name="date" />
</database-schema>
Note: It appears to be working fine. If somebody finds any problems with it,
please let me know.
database-sources, FILE: data-sources.xml (Interbase entry)
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="InterBase"
location="jdbc/InterBaseCoreDS"
xa-location="jdbc/xa/InterBaseXADS"
ejb-location="jdbc/InterBaseDS"
connection-driver="interbase.interclient.Driver"
username="sysdba"
password="masterkey"
url="jdbc:interbase://localhost/d:/database/yourDatabase.gdb"
inactivity-timeout="30"
/>
More notes:
To locate the actual database, you will have to poke around a bit. You
should
be able to find it at www.borland.com/interbase, but there are nicer
distributions
out there (no need to fill out any questionnaires and get spammed by
Borland).
Unfortunately, I don't remember the links... (somebody may want to post
these).
A very helpful starting point is:
http://www.ibphoenix.com/ibp_contrib_download.html
just make sure you don't download any PRE-6.x stuff.
Make sure you copy the InterClient JARs to orion\lib (these are
interclient.jar,
interclient-core.jar, interclient-res.jar, interclient-utils.jar and I
believe
RmiJdbc.jar). After looking into other JDBC drivers and problems that people
were
experiencing, I stuck with Borland's JDBC driver. They work fine.
As a side note, you should be aware that Interbase uses triggers, so things
like
AutoNumbers need to be created (you can create you own types!). If you don't
want
to mess with that, you can use MS Access to design tables, and then use a
utility
like SQLtoGDB, to transfer the database schema. It is a bit rough, but it
can save
some time. Also, stick with UPPERCASE table and column names. IB6 can use
mixed
case, but then you'll have to enclose field names in quotes which severely
limits
your code portability and makes for some strange looking SQL strings.
Hope this gets you started.
-arno
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Stanislav
Maximov
Sent: Wednesday, January 31, 2001 5:27 AM
To: Orion-Interest
Subject: RE: orion and mysql?
If somebody using Interbase successfully, please send your database schema
and data-sources.xml part to this list. TIA
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Randahl
> Fink Isaksen
> Sent: Wednesday, January 31, 2001 10:05 AM
> To: Orion-Interest
> Subject: RE: orion and mysql?
>
>
> Well then, is there a simple how-to for setting up Interbase with Orion? -
> Have you got a database schema which works?
>
>
> R.
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Arno Grbac
> Sent: 30. januar 2001 19:08
> To: Orion-Interest
> Subject: RE: orion and mysql?
>
>
> This doesn't answer your question, but take a serious look at InterBase 6
> (IT IS FREE AND OPEN SOURCE!!!!!!!!!!!).
> mySQL doesn't have a good locking mechanism yet, ..as well as some missing
> data types (last time I checked).
> Good luck,
> -arno
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Marc Linke
> Sent: Tuesday, January 30, 2001 11:21 AM
> To: Orion-Interest
> Subject: orion and mysql?
>
>
> Hi,
>
> is there any simple how-to for setting up mysql with
> orion available? Or can someone explain me how to do it?
>
> thanks
>
>
>
>
>
>
>
>
