Re: [JBoss-user] Oracle install probs

Guy Rouillier Fri, 15 Jun 2001 09:46:09 -0700

Title: Oracle install probs

Don't know if this is the issue you are seeing or not, but for JBoss 2.2.1 under JDK 1.3 on Windows 2K, that statement will hang for almost a full minute on a Pentium III 500 MHz, and then startup will resume. Did you wait a couple minutes to see if things continued? Somebody here described the source of the problem, but I must humbly admit that I did not commit it to memory since we weren't using Hypersonic so I just commented it out of jboss.jcml.

----- Original Message -----

From: Stephen White (EHPT)

To: 'jboss'

Sent: Friday, June 15, 2001 5:41 AM

Subject: [JBoss-user] Oracle install probs

Hi,
Iv just been trying to get an Oracle doirver working in Jboss.
Iv placed my classes12.zip file in the lib/ext file and edited the jboss.cml file so :-

<mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider">
    <attribute name="Drivers">org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver</attribute> -->
     <attribute name="Drivers">oracle.jdbc.driver.OracleDriver</attribute>
</mbean>

<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=OracleDB">
<attribute name="PoolName">OracleDB</attribute>
<attribute name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="URL">jdbc:oracle:thin:@kspc953:1521:ehswhit</attribute>
<attribute name="JDBCUser">ehswhit</attribute>
<attribute name="Password">orange</attribute>
</mbean>

<mbean code="org.jboss.jdbc.HypersonicDatabase" name="DefaultDomain:service=Hypersonic">
    <attribute name="Port">1476</attribute>
    <attribute name="Silent">true</attribute>
    <attribute name="Database">default</attribute>
    <attribute name="Trace">false</attribute>
</mbean>

<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=InstantDB">
    <attribute name="PoolName">InstantDB</attribute>
    <attribute name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
    <attribute name="Properties"></attribute>
    <attribute name="URL">jdbc:idb:../conf/default/instantdb.properties</attribute>
    <attribute name="GCMinIdleTime">1200000</attribute>
    <attribute name="JDBCUser" />
    <attribute name="MaxSize">10</attribute>
    <attribute name="Password" />
    <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>

<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</attribute>
    <attribute name="Properties"></attribute>
    <attribute name="URL">jdbc:HypersonicSQL:hsql://localhost:1476</attribute>
    <attribute name="GCMinIdleTime">1200000</attribute>
    <attribute name="JDBCUser">sa</attribute>
    <attribute name="MaxSize">10</attribute>
    <attribute name="Password" />
    <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>

So this should load two data sources the hypersonic and the oracel one (also added jboss.xa.xidclass=oracle.jdbc.xa.OracleXid to the oracel property file).

When I start up Jboss everyhting loads fine but the script stops at in the cmd window
[Hypersonic] Server 1.4 is running
[Hypersonic] Press [Ctrl]+[c] to abort

By taking out the oracle driver evveryhting works fine and the server starts.
Iv tried taking out the hypersonic stuff from the jboss.cml file but still get the same stopage...
Can some one help??
Stephen.

** ** ** ** ** ** ** ** ** ** ** ** **
Stephen White - Designer
Direct : 00 46 31 74 62191
Mobile : 0706 89 33 43
Epost : [EMAIL PROTECTED]

EHPT Sweden AB, 405 34 G�teborg
** ** ** ** ** ** ** ** ** ** ** ** **

Re: [JBoss-user] Oracle install probs

Reply via email to