Hi,
it looks to me as if you are expecting jaws to create tables for you. The
documentation used to mention that interclient databasemetadata was broken
and so jaws couldn't. As far as I know, the only version of interclient 2
in which this is fixed is the one on firebird.sourceforge.net. This
involves changes to both interclient and interserver. However, you have to
compile it yourself, the ant script appears to work on solaris. You may
have to change an int to uint in NetTCP.cpp to compile successfully. You
will probably also want to apply the jboss patch I submitted concerning not
null constraints and jaws. If you pursue this and get stuck feel free to
ask.
david jencks
On 2001.06.19 21:01:03 -0400 Ricardo Temporal wrote:
> 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
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
