Hi,
I am trying to start using jboss with interbase using linux.
I have downloaded file interclient.jar from
http://www.kpi.com.au/interbase/index.jsp installed and tried to deploy the
cd.jar tutorial only changing DefaultDS to point to Interbase, and changed the
name of the old DefaultDS to xDefaultDS.
I have already tested this cd.jar using Hypersonic SQL, and works fine.
interclient installation works with ijsql, I can query a table with ijsql.
//------------------------------------------------
<!-- JDBC -->
<mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
<attribute
name="Drivers">interbase.interclient.Driver,org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver</attribute>
</mbean>
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=DefaultDS">
<attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="PoolName">DefaultDS</attribute>
<attribute
name="URL">jdbc:interbase://10.9.0.24//usr/interbase/db/DBMARKETSERVERUCASE.gdb</attribute>
<attribute name="JDBCUser">sysdba</attribute>
<attribute name="Password">masterkey</attribute>
</mbean>
//------------------------------------------------
And changed standardjaws to use interbase type mapping
//------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<jaws>
<datasource>java:/DefaultDS</datasource>
<type-mapping>InterBase</type-mapping>
<debug>true</debug>
...
//------------------------------------------------
but when jboss is started, I get the following:
//------------------------------------------------
...
[Container factory] JRMP 1.3 CI initialized
[Container factory] JRMP 1.3 CI initialized
[JAWS] Initializing JAWS plugin for CDBean
[JAWS] Loading standardjaws.xml :
file:/usr/JBoss-2.2.2/conf/default/standardjaws.xml
[JAWS]
jar:file:/usr/JBoss-2.2.2/tmp/deploy/Default/cd.jar/ejb1001.jar!/META-INF/jaws.xml
found. Overriding defaults
[JAWS] Init SQL: CREATE TABLE CDBean (artist VARCHAR(255),notes
VARCHAR(255),xtype VARCHAR(255),title VARCHAR(255),id VARCHAR(255))
[JAWS] Destroy SQL: DROP TABLE CDBean
[JAWS] Exists SQL: SELECT COUNT(*) FROM CDBean WHERE id=?
[Container factory] Finder:type
[JAWS] findByType SQL: SELECT id FROM CDBean WHERE xtype=?
[JAWS] FindAll SQL: SELECT id FROM CDBean
[JAWS] Create SQL: INSERT INTO CDBean (artist,notes,xtype,title,id) VALUES
(?,?,?,?,?)
[JAWS] Remove SQL: DELETE FROM CDBean WHERE id=?
[JAWS] Load SQL: SELECT artist,notes,xtype,title,id FROM CDBean WHERE id=?
[JAWS] Store SQL: UPDATE CDBean SET artist=?,notes=?,xtype=?,title=?,id=?
WHERE id=?
[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
interbase.interclient.JDBCNet.receiveMessage(interbase/interclient/JDBCNet.java:203)
[Container factory] at
interbase.interclient.JDBCNet.sendAndReceiveMessage(interbase/interclient/JDBCNet.java:329)
[Container factory] at
interbase.interclient.DatabaseMetaData.remoteCatalogQuery(interbase/interclient/DatabaseMetaData.java:2635)
[Container factory] at
interbase.interclient.DatabaseMetaData.getTables(interbase/interclient/DatabaseMetaData.java:3175)
[Container factory] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCInitCommand.execute(JDBCInitCommand.java:96)
[Container factory] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.init(JAWSPersistenceManager.java:97)
[Container factory] at
org.jboss.ejb.plugins.CMPPersistenceManager.init(CMPPersistenceManager.java:105)
[Container factory] at
org.jboss.ejb.EntityContainer.init(EntityContainer.java:198)
[Container factory] at org.jboss.ejb.Application.init(Application.java:183)
[Container factory] at
org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:337)
[Container factory] at
org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:275)
[Container factory] at java.lang.reflect.Method.invoke(Native Method)
[Container factory] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Container factory] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Container factory] at
org.jboss.deployment.J2eeDeployer.startApplication(J2eeDeployer.java:415)
[Container factory] at
org.jboss.deployment.J2eeDeployer.deploy(J2eeDeployer.java:178)
[Container factory] at java.lang.reflect.Method.invoke(Native Method)
[Container factory] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Container factory] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Container factory] at
org.jboss.ejb.AutoDeployer.deploy(AutoDeployer.java:358)
[Container factory] at org.jboss.ejb.AutoDeployer.run(AutoDeployer.java:221)
[Container factory] at
org.jboss.ejb.AutoDeployer.startService(AutoDeployer.java:332)
[Container factory] at
org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:93)
[Container factory] at java.lang.reflect.Method.invoke(Native Method)
[Container factory] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Container factory] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Container factory] at
org.jboss.util.ServiceControl.start(ServiceControl.java:97)
[Container factory] at java.lang.reflect.Method.invoke(Native Method)
[Container factory] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Container factory] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Container factory] at org.jboss.Main.<init>(Main.java:217)
[Container factory] at org.jboss.Main$1.run(Main.java:121)
[Container factory] at java.security.AccessController.doPrivileged(Native
Method)
[Container factory] at org.jboss.Main.main(Main.java:117)
[J2EE Deployer Default] Starting cd.jar failed!
...
//------------------------------------------------
I tried several changes but always get this RemoteProtocolException.
Help.
Ricardo Temporal.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Message: 3
From: "Torsten Terp" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: [JBoss-user] Help! Jboss 2.2.2 / Interbase 6.01 / Interclient
2.0 /
Jdk1.3
Date: Tue, 19 Jun 2001 20:10:44 +0200
Reply-To: [EMAIL PROTECTED]
Hi,
If you are the lazy type, a jdk1.3 recompiled version of interclient
can be found here:
http://www.kpi.com.au/interbase/index.jsp
^terp
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of David Jencks
> Sent: Tuesday, June 19, 2001 7:39 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [JBoss-user] Help! Jboss 2.2.2 / Interbase 6.01 /
> Interclient 2.0 / Jdk1.3
>
>
> Hi,
> I think you need to recompile interclient with jdk 1.3.
>
> If you are feeling adventurous, firebird.sourceforge.net's ic2 version
has
> an ant script (in firebird dir) and several modifications such as
working
> database metadata (lets jaws create your tables) and (just added ) sql
> logging. (there is a 50% chance you will get a compilation error in
> NetTCP.cpp, you may need to change an int to uint. No doubt it's simple,
> but we haven't figured out the ifdefs to make this compile on all
> platforms.)
>
> If you are not feeling adventurous, I think just recompiling interclient
> will work.
>
> david jencks
>
> On 2001.06.19 08:45:14 -0400 [EMAIL PROTECTED] wrote:
> > Hi,
> >
> > I'm new to JBoss and I'm trying to get Jboss to work with Interbase
6.01.
> >
> > Here is my configuration:
> >
> > Jboss 2.2.2 with Tomcat 3.2.2
> > Interbase 6.01 (Solaris)
> > Interclient 2.0
> > Jdk1.3 (sun)
> >
> > jboss.jcml
> > -----------
> > <!-- JDBC -->
> > <mbean code="org.jboss.jdbc.JdbcProvider"
> > name="DefaultDomain:service=JdbcProvider">
> > <attribute name="Drivers">interbase.interclient.Driver</attribute>
> > </mbean>
> >
> > <mbean code="org.jboss.jdbc.XADataSourceLoader"
> > name="DefaultDomain:service=XADataSource,name=DefaultDS">
> > <attribute name="PoolName">DefaultDS</attribute>
> > <attribute
> >
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</a
> > ttribute>
> > <attribute name="Properties"></attribute>
> > <attribute
> >
name="URL">jdbc:interbase://DBSVR/usr/interbase/db/database.gdb</attribute>
> > <attribute name="GCMinIdleTime">1200000</attribute>
> > <attribute name="JDBCUser">sysdba</attribute>
> > <attribute name="MaxSize">10</attribute>
> > <attribute name="Password">masterkey</attribute>
> > <attribute name="GCEnabled">false</attribute>
> > <attribute name="InvalidateOnError">false</attribute>
> > <attribute name="TimestampUsed">false</attribute>
> > <attribute name="Blocking">true</attribute>
> > <attribute name="GCInterval">120000</attribute>
> > <attribute name="IdleTimeout">1800000</attribute>
> > <attribute name="IdleTimeoutEnabled">false</attribute>
> > <attribute name="LoggingEnabled">false</attribute>
> > <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
> > <attribute name="MinSize">0</attribute>
> > </mbean>
> >
> > standardjaws.xml
> > ------------------
> > <datasource>java:/DefaultDS</datasource>
> > <type-mapping>InterBase</type-mapping>
> > <debug>false</debug>
> > :
> > <type-mapping>
> > <name>InterBase</name>
> > <mapping>
> > <java-type>java.lang.Boolean</java-type>
> > <jdbc-type>BIT</jdbc-type>
> > <sql-type>SMALLINT</sql-type>
> > </mapping>
> > <mapping>
> > <java-type>java.lang.Byte</java-type>
> > <jdbc-type>TINYINT</jdbc-type>
> > <sql-type>SMALLINT</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(18,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>VARCHAR(2000)</sql-type>
> > </mapping>
> > </type-mapping>
> >
> > I'm trying to deploy the cd.jar demo application found in the Jboss
> > documentation. Here is the error that I get:
> >
> > JBOSS_CLASSPATH=;/lib/tools.jar;run.jar;../lib/crimson.jar
> > jboss.home = C:\JBoss\JBoss-2.2.2_Tomcat-3.2.2\jboss
> > Using JAAS LoginConfig:
file:/C:/JBoss/JBoss-2.2.2_Tomcat-3.2.2/jboss/conf/tomca
> > t/auth.conf
> > Using configuration "tomcat"
> > [Info] Java version: 1.3.1,Sun Microsystems Inc.
> > [Info] Java VM: Java HotSpot(TM) Client VM 1.3.1-b24,Sun Microsystems
> > Inc.
> > [Info] System: Windows 2000 5.0,x86
> > :
> > [JDBC provider] Initializing
> > [JDBC provider] Loaded JDBC-driver:interbase.interclient.Driver
> > [JDBC provider] Initialized
> > [DefaultDS] Initializing
> > [DefaultDS] Initialized
> > :
> > [JDBC provider] Starting
> > [JDBC provider] Started
> > [DefaultDS] Starting
> > [DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS
> > [DefaultDS] Started
> > :
> > [Container factory] Deploying CDBean
> > [Container factory] Deploying CDCollectionBean
> > [J2EE Deployer Default] Starting cd.jar failed!
> > [Auto deploy] java.lang.VerifyError: (class:
> > interbase/interclient/ErrorKey, met
> > hod: _$372 signature: (Ljava/lang/String;Ljava/lang/String;I)V)
Expecting
> > to fin
> > d unitialized object on stack
> > [Auto deploy] at
interbase.interclient.JDBCNet._$125530(JDBCNet.java:203)
> > [Auto deploy] at
interbase.interclient.JDBCNet.sendAndReceiveMessage(JDBCNet.j
> > ava:329)
> > [Auto deploy] at
interbase.interclient.DatabaseMetaData._$139195(DatabaseMetaD
> > ata.java:2635)
> > [Auto deploy] at
interbase.interclient.DatabaseMetaData.getTables(DatabaseMeta
> > Data.java:3175)
> > [Auto deploy] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCInitCommand.execute(JDBCI
> > nitCommand.java:96)
> > [Auto deploy] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.init(JAWSPe
> > rsistenceManager.java:97)
> > [Auto deploy] at
org.jboss.ejb.plugins.CMPPersistenceManager.init(CMPPersisten
> > ceManager.java:105)
> > [Auto deploy] at
org.jboss.ejb.EntityContainer.init(EntityContainer.java:198)
> > [Auto deploy] at org.jboss.ejb.Application.init(Application.java:183)
> > [Auto deploy] at
org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:3
> > 37)
> > [Auto deploy] at
org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:2
> > 75)
> > [Auto deploy] at java.lang.reflect.Method.invoke(Native Method)
> > [Auto deploy] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
> > .java:1628)
> > [Auto deploy] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
> > .java:1523)
> > [Auto deploy] at
org.jboss.deployment.J2eeDeployer.startApplication(J2eeDeploy
> > er.java:415)
> > [Auto deploy] at
org.jboss.deployment.J2eeDeployer.deploy(J2eeDeployer.java:17
> > 8)
> > [Auto deploy] at java.lang.reflect.Method.invoke(Native Method)
> > [Auto deploy] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
> > .java:1628)
> > [Auto deploy] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
> > .java:1523)
> > [Auto deploy] at
org.jboss.ejb.AutoDeployer.deploy(AutoDeployer.java:358)
> > [Auto deploy] at org.jboss.ejb.AutoDeployer.run(AutoDeployer.java:221)
> > [Auto deploy] at
org.jboss.ejb.AutoDeployer.startService(AutoDeployer.java:332
> > )
> > [Auto deploy] at
org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.
> > java:93)
> > [Auto deploy] at java.lang.reflect.Method.invoke(Native Method)
> > [Auto deploy] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
> > .java:1628)
> > [Auto deploy] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
> > .java:1523)
> > [Auto deploy] at
org.jboss.util.ServiceControl.start(ServiceControl.java:97)
> > [Auto deploy] at java.lang.reflect.Method.invoke(Native Method)
> > [Auto deploy] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
> > .java:1628)
> > [Auto deploy] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
> > .java:1523)
> > [Auto deploy] at org.jboss.Main.<init>(Main.java:217)
> > [Auto deploy] at org.jboss.Main$1.run(Main.java:121)
> > [Auto deploy] at java.security.AccessController.doPrivileged(Native
> > Method)
> > [Auto deploy] at org.jboss.Main.main(Main.java:117)
> > [J2EE Deployer Default] Module cd.jar is not running
> > [J2EE Deployer Default] Destroying application cd.jar
> > :
> > [Service Control] Started 26 services
> > [Default] JBoss 2.2.2 Started in 0m:12s
> >
> > I read that the Interclient 2.0 is incompatible wint jdk 1.3, where can
I
> >
> > download the right version?
> >
> > Am I missing something else?
> >
> > Thanks in advance,
> > Marcelo
> > Mathias
> >
____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
