|
did you see yr DB driver being
loaded....
from the code...
i only see the default frivers being
loaded....
also , you should have one instant of the follwoing
mbean, the JdbcProvider mbean.
from your code , you have this in yr
jboss.jcml
----------------
<mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
<attribute
name="Drivers">COM.ibm.db2.jdbc.app.DB2Driver</attribute>
</mbean>
------------------------
according to the above code, the 2 default Driver
should not have been loaded...
please check, you might have added the above mbean
and not remove the exsiting one.
they are the same mbean and cannot
co-exisit.
if you still want the default dirver include yr
driver to be loaded..
just add yr driver to the exisiting "jdbcProvider"
mbean... remmber, onlye one "JdbcProvider" mbean can be there. the
"drivers" attribute within the mbean is a comma delimited list of jdbc
drivers
check yr DB driver name too... are you shure it
starts with uppercase "COM"..
---------------------------
<mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
<attribute
name="Drivers">org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,COM.ibm.db2.jdbc.app.DB2Driver</attribute>
</mbean>
------------------------------
john
----- Original Message -----
Sent: Tuesday, September 18, 2001 4:42
PM
Subject: Re: [JBoss-user] DB2 Connecting
problem remotely
Yes John,
you
are absolutely correct. I found the following lines, but not for
DB2Driver,
[JdbcProvider] Initializing
[JdbcProvider] Loaded JDBC-driver:org.hsql.jdbcDriver
[JdbcProvider] Loaded
JDBC-driver:org.enhydra.instantdb.jdbc.idbDriver
[JdbcProvider] Initialized
....
....
[JdbcProvider] Starting
[JdbcProvider] Started
[HypersonicDatabase] Starting
[HypersonicDatabase] Database started
[HypersonicDatabase] Started
....
....
[XADataSourceLoader] Starting
[DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS
[Default] Server 1.4 is running
[Default] Press [Ctrl]+[C] to abort
[XADataSourceLoader] Started
.....
Can
any one tell me, What could be the reason?
The
code for jdbc in jboss.jcml is,
<!--
====================================================================
-->
<!-- JDBC
-->
<!-- ====================================================================
-->
<mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
<attribute
name="Drivers">COM.ibm.db2.jdbc.app.DB2Driver</attribute>
</mbean>
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=DB2DS">
<attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute
name="PoolName">DB2DS</attribute>
<attribute
name="URL">jdbc:db2://websphere:8080/demomall</attribute>
<attribute
name="JDBCUser">wcs</attribute>
<attribute
name="Password">wcs</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.jboss.pool.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.jboss.pool.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>
Help me out
pls,
--Krishna
*********************************************************
Disclaimer
This
message (including any attachments) contains
confidential information
intended for a specific
individual and purpose, and is protected by law.
If you are not the intended recipient, you should
delete this message
and are hereby notified that
any disclosure, copying, or distribution of
this
message, or the taking of any action based on it,
is strictly
prohibited.
*********************************************************
Visit
us at http://www.mahindrabt.com
| 