Hi If you could give me any feedback about the following issue I would be very gratefull... I managed to get Interbase up and running with Orion. When I deploy, Orion creates my tables in the way I expected. However, when I start creating EJBs I get a javax.ejb.CreateException from InterClient. I create my EJBs from a JSP page which has worked fine on Hypersoniq. The exception on Interbase is this: javax.ejb.CreateException: Error creating EntityBean: [interclient] Invalid data conversion: Parameter instance Archive is out of range for requested conversion. See API reference for exception interbase.interclient.ParameterConversionException Now, such a conversion exception has to do with JDBC's conversions from Java objects to database data types. The instance I am trying to store is a simple bean containing only three properties: 1. a String as a primary key 2. another String 3. an int The only way I can imagine one of these values being out of range is if one of the strings were too long or the bytesize of the int could not fit into database type I have declared - I am using the database schema shown below which is based partially on Falk Langhammers post. If you have any ideas or suggestions I would be very happy to hear from you. Yours R. <?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="" primary-key="primary key" max-table-name-length="31"> <type-mapping type="java.lang.String" name="VARCHAR(252)" /> <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.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" /> <disallowed-field name="value" /> <disallowed-field name="role" /> </database-schema> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Falk Langhammer Sent: 25. februar 2001 13:51 To: Orion-Interest Subject: Re: Win2k Pro. is mess... choosing the right database product 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
