Hi,
I never had this problem, but I notice that you are expecting JAWS to
create your tables. The interclient driver from borland won't do this,
there are problems with the databaseMetData.getTables call. Possibly this
is causing the problem you have-- in my experience it killed interserver
immediately. You may have snipped the part of the trace indicating if this
is your problem.
If you are on Linux, especially rh 7, you could try the latest firebird
interclient 20, in which I have fixed these problems. You have to compile
it yourself at this point, but there is a ant script for this in the
interclient...../firebird directory.
If you are on windows, I would certainly appreciate you trying to compile
this from source and seeing if it works. I don't have a windows compiler,
and I've been waiting for someone to test this out on windows before
publicizing it too much.
Thanks
David Jencks
firebird is at sourceforge.net/projects/firebird
On 2001.02.26 05:59:47 -0500 Dirk Ohst wrote:
> Hi,
>
> I am new to jboss and have got a problem using interbase 6 and
> interclient 2.0 (self compiled java side). When deploying the CD archive
> example interclient throws the following exception. I think that the
> JDBC driver is OK because a pure java client with direct interbase
> access works fine:
>
> [Container factory] Finder:type
> [Container factory] interbase.interclient.RemoteProtocolException:
> [interclient] Client/Server protocol error: Unrecognized network message
> received from InterServer.
> [Container factory] See API reference for exception
> interbase.interclient.RemoteProtocolException
> [Container factory] at java.lang.Throwable.<init>(Throwable.java:96)
> [Container factory] at java.lang.Exception.<init>(Exception.java:44)
> [Container factory] at
> java.sql.SQLException.<init>(SQLException.java:45)
> [Container factory] at
> interbase.interclient.SQLException.<init>(Unknown Source)
> [Container factory] at
> interbase.interclient.RemoteProtocolException.<init>(Unknown Source)
> [Container factory] at
> interbase.interclient.JDBCNet.receiveMessage(Unknown Source)
> [Container factory] at
> interbase.interclient.JDBCNet.sendAndReceiveMessage(Unknown Source)
> ...
> [Container factory] at
> org.jboss.dependencies.DependencyManager.startMBean(DependencyManager.java:284)
> [Container factory] at
> org.jboss.dependencies.DependencyManager.loadService(DependencyManager.java:261)
> [Container factory] at
> org.jboss.dependencies.DependencyManager.processService(DependencyManager.java:243)
> [Container factory] at
> org.jboss.dependencies.DependencyManager.startMBeans(DependencyManager.java:117)
> [Container factory] at org.jboss.Main.<init>(Main.java:162)
> [Container factory] at org.jboss.Main$1.run(Main.java:87)
> [Container factory] at
> java.security.AccessController.doPrivileged(Native Method)
> [Container factory] at org.jboss.Main.main(Main.java:83)
> [J2EE Deployer] Starting cd.jar failed!
> [J2EE Deployer] Module cd.jar is not running
> [J2EE Deployer] Destroying application cd.jar
> [J2EE Deployer] deployment.cfg file deleted.
> [J2EE Deployer] File tree
> file:/usr/local/app_server/jBoss-2.0_FINAL/tmp/deploy/cd.jar deleted.
> [Auto deploy] Deployment
> failed:file:/usr/local/app_server/jBoss-2.0_FINAL/deploy/cd.jar
> [Auto deploy] org.jboss.deployment.J2eeDeploymentException: Error while
> starting cd.jar: Could not deploy
> file:/usr/local/app_server/jBoss-2.0_FINAL/tmp/deploy/cd.jar/ejb1002.jar
> [Auto deploy] at java.lang.Throwable.<init>(Throwable.java:96)
> [Auto deploy] at java.lang.Exception.<init>(Exception.java:44)
> ...
> [Auto deploy] at org.jboss.Main.<init>(Main.java:162)
> [Auto deploy] at org.jboss.Main$1.run(Main.java:87)
> [Auto deploy] at java.security.AccessController.doPrivileged(Native
> Method)
> [Auto deploy] at org.jboss.Main.main(Main.java:83)
> [Auto deploy] Started
>
>
> It looks like that the driver is initialised correctly:
>
> server.log:
>
> [JDBC] Loaded JDBC-driver:interbase.interclient.Driver
> ...
> [InterBaseDB] Initializing
> [InterBaseDB] Initialized
> ...
> [InterBaseDB] Starting
> [InterBaseDB] XA Connection pool InterBaseDB bound to java:/InterBaseDB
> [InterBaseDB] Started
>
>
> My configuration is as follows:
>
>
> jboss.conf:
>
> <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
> CODEBASE="../lib/ext/">
> <ARG TYPE="java.lang.String" VALUE="InterBaseDB">
> <ARG TYPE="java.lang.String"
> VALUE="org.jboss.minerva.xa.XADataSourceImpl">
> </MLET>
>
>
>
> jboss.jcml:
>
> <mbean name="DefaultDomain:service=XADataSource,name=InterBaseDB">
> <attribute name="TimestampUsed">true</attribute>
> <attribute name="Password">masterkey</attribute>
> <attribute name="MaxSize">0</attribute>
> <attribute name="InvalidateOnError">false</attribute>
> <attribute name="IdleTimeout">1800000</attribute>
> <attribute name="GCInterval">120000</attribute>
> <attribute name="Blocking">true</attribute>
> <attribute name="LoggingEnabled">true</attribute>
> <attribute name="IdleTimeoutEnabled">false</attribute>
> <attribute name="GCEnabled">false</attribute>
> <attribute
> name="URL">jdbc:interbase://localhost/var/ibase/db/address.gdb</attribute>
> <attribute name="Properties"></attribute>
> <attribute name="MinSize">0</attribute>
> <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
> <attribute name="JDBCUser">sysdba</attribute>
> <attribute name="GCMinIdleTime">1200000</attribute>
> </mbean>
>
> jboss.properties:
>
>
>jdbc.drivers=interbase.interclient.Driver,org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver
>
>
>
> standardjaws.xml:
>
> <jaws>
>
> <datasource>java:/InterBaseDB</datasource>
> <type-mapping>InterBase</type-mapping>
>
> <default-entity>
> <create-table>true</create-table>
> <remove-table>false</remove-table>
> <tuned-updates>false</tuned-updates>
> <read-only>false</read-only>
> <time-out>300</time-out>
> </default-entity>
>
> <type-mappings>
> <type-mapping>
> <name>InterBase</name>
> <mapping>
> <java-type>java.lang.Boolean</java-type>
> <jdbc-type>BIT</jdbc-type>
> <sql-type>NUMERIC(1,0)</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Byte</java-type>
> <jdbc-type>TINYINT</jdbc-type>
> <sql-type>NUMERIC(10,0)</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Short</java-type>
> <jdbc-type>SMALLINT</jdbc-type>
> <sql-type>SMALLINT</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Integer</java-type>
> <jdbc-type>INTEGER</jdbc-type>
> <sql-type>INTEGER</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Long</java-type>
> <jdbc-type>BIGINT</jdbc-type>
> <sql-type>NUMERIC(20,0)</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Float</java-type>
> <jdbc-type>REAL</jdbc-type>
> <sql-type>FLOAT</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Double</java-type>
> <jdbc-type>DOUBLE</jdbc-type>
> <sql-type>DOUBLE PRECISION</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Character</java-type>
> <jdbc-type>CHAR</jdbc-type>
> <sql-type>CHAR</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.String</java-type>
> <jdbc-type>VARCHAR</jdbc-type>
> <sql-type>VARCHAR(255)</sql-type>
> </mapping>
> <mapping>
> <java-type>java.sql.Date</java-type>
> <jdbc-type>DATE</jdbc-type>
> <sql-type>DATE</sql-type>
> </mapping>
> <mapping>
> <java-type>java.sql.Time</java-type>
> <jdbc-type>TIME</jdbc-type>
> <sql-type>TIME</sql-type>
> </mapping>
> <mapping>
> <java-type>java.sql.Timestamp</java-type>
> <jdbc-type>TIMESTAMP</jdbc-type>
> <sql-type>TIMESTAMP</sql-type>
> </mapping>
> <mapping>
> <java-type>java.lang.Object</java-type>
> <jdbc-type>JAVA_OBJECT</jdbc-type>
> <sql-type>BLOB</sql-type>
> </mapping>
> </type-mapping>
>
>
> Have anybody an idea what the problem could be? Many thanks in advance.
>
>
> Dirk.
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> List Help?: [EMAIL PROTECTED]
>
>
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
