it works fine. Just copy interclient.jar to /orion/lib
I use the following schema-xml:
<?xml version="1.0"?>
<!DOCTYPE database-schema PUBLIC "-//Evermind//- Database schema"
"http://www.orionserver.com/dtds/database-schema.dtd">
<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="number(20,0)" />
<type-mapping type="long" name="number(20,0)" />
<type-mapping type="float" name="number(20,5)" />
<type-mapping type="double" name="number(30,0)" />
<type-mapping type="byte" name="number(10,0)" />
<type-mapping type="char" name="char(1)" />
<type-mapping type="short" name="number(10,0)" />
<type-mapping type="boolean" name="number(1,0)" />
<type-mapping type="java.util.Date" name="date" />
<type-mapping type="java.io.Serializable" name="blob" />
<disallowed-field name="password" />
<disallowed-field name="date" />
</database-schema>
which seems to work. Any improvements are welcome ;)
Jeroen T Wenting
[EMAIL PROTECTED]
ICQ UIN #9191966
It's the end of the world as we know it and I feel fine (Michael Stipe)
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of A. Gregory
> Rabil
> Sent: 28 August 2000 15:35
> To: Orion-Interest
> Subject: Orion and InterBase
>
>
> Has anyone experienced connecting Orion to InterBase 6.0. I've been
> successful hooking Orion up to several RDBMS via the
> JDBC-ODBC bridge. With
> InterBase, the InterClient package provides the connectivity
> and the JDBC
> driver. My data-sources.xml file looks something like the following:
>
> <data-source name="Default data-source"
> class="com.evermind.sql.ConnectionDataSource"
> location="jdbc/DefaultDS"
> pooled-location="jdbc/DefaultPooledDS"
> xa-location="jdbc/xa/DefaultXADS"
> ejb-location="jdbc/DefaultEJBDS"
> url="jdbc:interbase://localhost/E:/Inprise/InterBase/data/mydb.gdb"
> connection-driver="interbase.interclient.Driver" username="user"
> password="password" />
> </data-sources>
>
> The interclient.jar file is in my classpath, but I get an
> error when I start
> Orion that it cannot locate the DriverManager
> "interbase.interclient.Driver".
>
> Any ideas?
>
> Thanks,
> Greg
>
>
>
