Hi Vimal, I got Interbase working and there *are* some traps. Therefore let me share my solution with this list: (1) Get Interclient 2.0 from http://inprise-svca.www.conxion.com/win_sources.zip (a link from http://www.inprise.com/interbase/downloads/) (2) Install (3) Get a recompiled interclient.jar from http://www.kpi.com.au/interbase/files/interclient.jar (the original will cause JavaVerify errors) (4) Overwrite interclient.jar (the test applet will cease to work because some applet-specific classes were omitted in new .jar - ignore) (5) Get Firebird 0.9.4 from http://sourceforge.net/project/showfiles.php?group_id=9028&release_id=19364 (ie. http://download.sourceforge.net/firebird/fbinst_0_9-4_prod_2000_12_29-1.exe for Win2k) (6) Install (Firebird is Interbase 6.0 with OSS support - The version from Borland's site seems unsupported by both Borland and the OSS community now) Firebird is ~2 months old were Interbase6 is ~8 months old. This installs Firebird as a Win2k-service. (7) Using Interclient configurator, configure Interclient (ie., Interserver) as a Win2k-service. Start the service now. (8) Copy interclient.jar (the new one) to <OrionInstall>/lib. (9) Copy firebird.xml (cf. my attachment #1) to <OrionInstall>/config/database-schemas (I have seen many Interbase schemas - most of them had a bug. Mine follows the Borland Application Server 4.5 Spec for Interbase 5.0 plus 6.0 additional datatypes. Reserved words are incomplete!) (10) Modify <OrionInstall>/config/data-sources.xml to include the datasource (cf. my attachment #2 as an example - MODIFY!!) (11) Restart Orion and deploy your application. Hope this gets YOu up and running and saves YOu this weekend ;-) Falk Langhammer ----- Original Message ----- From: Vimal Patel To: Orion-Interest Sent: Thursday, August 03, 2000 10:44 PM Subject: Re: Win2k Pro. is mess... choosing the right database product Can you tell me what data-source settings you have to get interbase working with orion and the driver version. I can not get it to work with orion. Also if you could mail the database-schemas for interbase I would really appreciate it. Thanks, Vimal
<?xml version="1.0"?> <!DOCTYPE data-sources PUBLIC "Orion data-sources" "http://www.orionserver.com/dtds/data-sources.dtd"> <data-sources> <!-- An example/default DataSource that uses an ordinary JDBC-driver (in this case hsql) to create the connections. This tag creates all the needed kinds of data-sources, transactional, pooled and EJB-aware sources. The source generally used in application code is the "EJB" one - it provides transactional safety and connection pooling. <data-source class="com.evermind.sql.DriverManagerDataSource" name="Hypersonic" location="jdbc/HypersonicCoreDS" xa-location="jdbc/xa/HypersonicXADS" ejb-location="jdbc/HypersonicDS" connection-driver="org.hsql.jdbcDriver" username="sa" password="" url="jdbc:HypersonicSQL:./database/defaultdb" inactivity-timeout="30" /> --> <data-source class="com.evermind.sql.DriverManagerDataSource" name="LivingTalksDB" schema="database-schemas/firebird.xml" location="jdbc/LivingTalksCore" xa-location="jdbc/xa/LivingTalksXA" ejb-location="jdbc/LivingTalks" connection-driver="interbase.interclient.Driver" username="SYSDBA" password="masterkey" url="jdbc:interbase://localhost/C:/Programme/JavaSoft/j2sdkee1.2/interbase/livingtalks.gdb" inactivity-timeout="30" /> </data-sources>
<?xml version="1.0"?> <!DOCTYPE database-schema PUBLIC "-//Evermind//- Database schema" "http://www.orionserver.com/dtds/database-schemas.dtd"> <database-schema name="Firebird" not-null="not null" null="" primary-key="primary key" max-table-name-lenght="30"> <type-mapping type="boolean" name="SMALLINT" /> <type-mapping type="java.lang.Boolean" name="SMALLINT" /> <type-mapping type="byte" name="SMALLINT" /> <type-mapping type="java.lang.Byte" name="SMALLINT" /> <type-mapping type="char" name="CHAR(1)" /> <type-mapping type="java.lang.Character" name="CHAR(1)" /> <type-mapping type="double" name="DOUBLE PRECISION" /> <type-mapping type="java.lang.Double" name="DOUBLE PRECISION" /> <type-mapping type="float" name="FLOAT" /> <type-mapping type="java.lang.Float" name="FLOAT" /> <type-mapping type="int" name="INTEGER" /> <type-mapping type="java.lang.Integer" name="INTEGER" /> <type-mapping type="long" name="NUMBER(15,0)" /> <type-mapping type="java.lang.Long" name="NUMBER(15,0)" /> <type-mapping type="short" name="SMALLINT" /> <type-mapping type="java.lang.Short" name="SMALLINT" /> <type-mapping type="java.lang.String" name="VARCHAR(252)" /> <type-mapping type="java.math.BigDecimal" name="NUMBER(15,15)" /> <type-mapping type="byte[]" name="BLOB" /> <type-mapping type="java.sql.Date" name="DATE" /> <type-mapping type="java.sql.Time" name="TIME" /> <type-mapping type="java.sql.Timestamp" name="TIMESTAMP" /> <type-mapping type="java.util.Date" name="TIMESTAMP" /> <type-mapping type="java.io.Serializable" name="BLOB" /> <disallowed-field name="key" /> <disallowed-field name="date" /> <disallowed-field name="timestamp" /> <disallowed-field name="time" /> <disallowed-field name="username" /> <disallowed-field name="password" /> <disallowed-field name="select" /> <disallowed-field name="where" /> <disallowed-field name="order" /> <disallowed-field name="from" /> <disallowed-field name="by" /> <disallowed-field name="table" /> <disallowed-field name="type" /> <disallowed-field name="page" /> </database-schema>