2 comments
1. If you are running embedded tomcat version of jboss there is a different
configuration directory I believe with its own copy of jboss.jcml. Perhaps
you are modifying the wrong one. If there is no indication of jboss trying
to load your XADataSourceLoader this is likely the case.
2. Instead of following the (written for 2.2) documentation, follow the
(working) hypersonic example and use
<attribute
name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute>
not
<attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
david jencks
On 2001.09.18 07:32:27 -0400 Krishna Prasad wrote:
> John,
> I'm very happy for giving immediate reply.
> I tried the following way also.
>
> <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>
>
> Eventhough no DB2 driver loaded.
> Yeah, i'm sure that my DB driver name is
> "COM.ibm.db2.jdbc.app.DB2Driver".
> I attached my jboss.jcml file. Could you please suggest me what
> code i have to add.
>
> --Krishna
>
>
>
> ----- Original Message -----
> From: John LYC
> To: [EMAIL PROTECTED]
> Sent: Tuesday, September 18, 2001 3:12 PM
> Subject: Re: [JBoss-user] DB2 Connecting problem remotely
>
>
> 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 -----
> From: Krishna Prasad
> To: [EMAIL PROTECTED]
> 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
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
> <META content="MSHTML 5.00.2014.210" name=GENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=#ffffff>
> <DIV><FONT size=2>John,</FONT></DIV>
> <DIV><FONT size=2>
> I'm
> very happy for giving immediate reply.</FONT></DIV>
> <DIV><FONT
>
>size=2> </FONT><FONT
>
> size=2>I tried the following way also. </FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT size=2><mbean code="org.jboss.jdbc.JdbcProvider"
> name="DefaultDomain:service=JdbcProvider"><BR>
>
> <attribute
>
>name="Drivers">org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,COM.ibm.db2.jdbc.app.DB2Driver</attribute><BR>
>
> </mbean></FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT
> size=2> Eventhough no
> DB2
> driver loaded. </FONT></DIV>
> <DIV><FONT size=2> Yeah, i'm sure
> that my
> DB driver name is "COM.ibm.db2.jdbc.app.DB2Driver".</FONT></DIV>
> <DIV><FONT size=2> I attached
> my
> jboss.jcml file. Could you please suggest me what code i
> have to
> add. </FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT size=2>--Krishna</FONT></DIV>
> <DIV><FONT size=2> </FONT></DIV>
> <DIV><FONT size=2>
>
> </FONT></DIV>
> <DIV> </DIV>
> <BLOCKQUOTE
> style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT:
> 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
> <DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
> <DIV
> style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color:
> black"><B>From:</B>
> <A href="mailto:[EMAIL PROTECTED]"; [EMAIL PROTECTED]>John
> LYC</A>
> </DIV>
> <DIV style="FONT: 10pt arial"><B>To:</B> <A
> href="mailto:[EMAIL PROTECTED]";
> [EMAIL PROTECTED]>[EMAIL PROTECTED]</A>
>
> </DIV>
> <DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, September 18, 2001
> 3:12
> PM</DIV>
> <DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [JBoss-user] DB2
> Connecting
> problem remotely</DIV>
> <DIV><BR></DIV>
> <DIV><FONT face=Arial size=2>did you see yr DB driver being
> loaded....</FONT></DIV>
> <DIV><FONT face=Arial size=2>from the code...</FONT></DIV>
> <DIV><FONT face=Arial size=2>i only see the default frivers being
> loaded....</FONT></DIV>
> <DIV><FONT face=Arial size=2></FONT> </DIV>
> <DIV><FONT face=Arial size=2>also , you should have one instant of the
> follwoing mbean, the JdbcProvider mbean.</FONT></DIV>
> <DIV><FONT face=Arial size=2>from your code , you have this in yr
> jboss.jcml</FONT></DIV>
> <DIV><FONT face=Arial size=2></FONT> </DIV>
> <DIV><FONT face=Arial size=2>----------------</FONT></DIV>
> <DIV><FONT size=2><mbean code="org.jboss.jdbc.JdbcProvider"
> name="DefaultDomain:service=JdbcProvider"><BR>
>
> <attribute
> name="Drivers">COM.ibm.db2.jdbc.app.DB2Driver</attribute><BR>
>
> </mbean></FONT></DIV>
> <DIV><FONT face=Arial size=2>------------------------</FONT></DIV>
> <DIV><FONT face=Arial size=2>according to the above code, the 2 default
> Driver
> should not have been loaded...</FONT></DIV>
> <DIV><FONT face=Arial size=2>please check, you might have added the
> above
> mbean and not remove the exsiting one.</FONT></DIV>
> <DIV><FONT face=Arial size=2>they are the same mbean and cannot
> co-exisit.</FONT></DIV>
> <DIV><FONT face=Arial size=2></FONT> </DIV>
> <DIV><FONT face=Arial size=2>if you still want the default dirver
> include yr
> driver to be loaded..</FONT></DIV>
> <DIV><FONT face=Arial size=2>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</FONT></DIV>
> <DIV><FONT face=Arial size=2>check yr DB driver name too... are you
> shure it
> starts with uppercase "COM"..</FONT></DIV>
> <DIV><FONT face=Arial size=2></FONT> </DIV>
> <DIV><FONT face=Arial size=2>---------------------------</FONT></DIV>
> <DIV><FONT face=Arial size=2></FONT> </DIV>
> <DIV><FONT size=2><mbean code="org.jboss.jdbc.JdbcProvider"
> name="DefaultDomain:service=JdbcProvider"><BR>
>
> <attribute
>
>name="Drivers">org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,COM.ibm.db2.jdbc.app.DB2Driver</attribute><BR>
>
> </mbean></FONT></DIV>
> <DIV><FONT size=2></FONT> </DIV>
> <DIV><FONT size=2>------------------------------</FONT></DIV>
> <DIV><FONT size=2></FONT> </DIV>
> <DIV><FONT size=2>john</FONT></DIV>
> <DIV><FONT face=Arial size=2></FONT> </DIV>
> <BLOCKQUOTE
> style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT:
> 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
> <DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
> <DIV
> style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color:
> black"><B>From:</B>
> <A href="mailto:[EMAIL PROTECTED]";
> [EMAIL PROTECTED]>Krishna
> Prasad</A> </DIV>
> <DIV style="FONT: 10pt arial"><B>To:</B> <A
> href="mailto:[EMAIL PROTECTED]";
> [EMAIL PROTECTED]>[EMAIL PROTECTED]</A>
>
> </DIV>
> <DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, September 18,
> 2001 4:42
> PM</DIV>
> <DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [JBoss-user] DB2
> Connecting problem remotely</DIV>
> <DIV><FONT face=Arial size=2></FONT><FONT face=Arial
> size=2></FONT><FONT
> face=Arial size=2></FONT><FONT face=Arial size=2></FONT><FONT
> face=Arial
> size=2></FONT><FONT face=Arial size=2></FONT><FONT face=Arial
> size=2></FONT><FONT face=Arial size=2></FONT><BR></DIV>
> <DIV><FONT size=2>Yes John,</FONT></DIV>
> <DIV><FONT face=Arial size=2></FONT> </DIV>
> <DIV><FONT size=2>
>
> you are absolutely correct. I found the following lines, but
> not for
> DB2Driver,</FONT></DIV>
> <DIV><FONT face=Arial size=2></FONT> </DIV>
> <DIV><FONT
> size=2>
>
> [JdbcProvider] Initializing</FONT></DIV>
> <DIV><FONT
> size=2>
>
> [JdbcProvider] Loaded JDBC-driver:org.hsql.jdbcDriver</FONT></DIV>
> <DIV><FONT
> size=2>
>
> [JdbcProvider] Loaded
> JDBC-driver:org.enhydra.instantdb.jdbc.idbDriver</FONT></DIV>
> <DIV><FONT
> size=2>
>
> [JdbcProvider] Initialized</FONT></DIV>
> <DIV><FONT size=2>
> ....</FONT></DIV>
> <DIV><FONT size=2>
>
> ....</FONT></DIV>
> <DIV><FONT face=Arial size=2></FONT> </DIV>
> <DIV><FONT
> size=2>
>
> [JdbcProvider] Starting</FONT></DIV>
> <DIV><FONT
> size=2>
>
> [JdbcProvider] Started</FONT></DIV>
> <DIV><FONT
> size=2>
>
> [HypersonicDatabase] Starting</FONT></DIV>
> <DIV><FONT
> size=2>
>
> [HypersonicDatabase] Database started</FONT></DIV>
> <DIV><FONT
> size=2>
>
> [HypersonicDatabase] Started</FONT></DIV>
> <DIV><FONT size=2>
>
> ....</FONT></DIV>
> <DIV><FONT size=2>
>
> ....</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT
> size=2>
>
> [XADataSourceLoader] Starting</FONT></DIV>
> <DIV><FONT
> size=2>
>
> [DefaultDS] XA Connection pool DefaultDS bound to
> java:/DefaultDS</FONT></DIV>
> <DIV><FONT
> size=2>
>
> [Default] Server 1.4 is running</FONT></DIV>
> <DIV><FONT
> size=2>
>
> [Default] Press [Ctrl]+[C] to abort</FONT></DIV>
> <DIV><FONT
> size=2>
>
> [XADataSourceLoader] Started</FONT></DIV>
> <DIV><FONT size=2>
>
> .....</FONT></DIV>
> <DIV><FONT size=2>
>
> </FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT
> size=2>
>
> Can any one tell me, What could be the reason?</FONT></DIV>
> <DIV><FONT
> size=2>
>
> The code for jdbc in jboss.jcml is,</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT size=2> <!--
> ====================================================================
> --><BR> <!-- JDBC
>
> --><BR> <!--
> ====================================================================
> --></FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT size=2> <mbean code="org.jboss.jdbc.JdbcProvider"
>
> name="DefaultDomain:service=JdbcProvider"><BR>
>
> <attribute
> name="Drivers">COM.ibm.db2.jdbc.app.DB2Driver</attribute><BR>
>
> </mbean><BR><mbean code="org.jboss.jdbc.XADataSourceLoader"
> name="DefaultDomain:service=XADataSource,name=DB2DS"><BR> <attribute
>
>
>name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
>
> <BR> <attribute
> name="PoolName">DB2DS</attribute><BR> <attribute
>
>name="URL">jdbc:db2://websphere:8080/demomall</attribute><BR> <attribute
>
> name="JDBCUser">wcs</attribute><BR> <attribute
> name="Password">wcs</attribute><BR></mbean></FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT size=2> <mbean
> code="org.jboss.jdbc.HypersonicDatabase"
> name="DefaultDomain:service=Hypersonic"><BR>
> <attribute name="Port">1476</attribute><BR>
>
> <attribute name="Silent">true</attribute><BR>
>
> <attribute
> name="Database">default</attribute><BR>
> <attribute name="Trace">false</attribute><BR>
> </mbean></FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT size=2> <mbean
> code="org.jboss.jdbc.XADataSourceLoader"
>
>name="DefaultDomain:service=XADataSource,name=InstantDB"><BR>
>
> <attribute
> name="PoolName">InstantDB</attribute><BR>
> <attribute
>
>name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute><BR>
>
> <attribute name="Properties"></attribute><BR>
>
> <attribute
>
>name="URL">jdbc:idb:../conf/default/instantdb.properties</attribute><BR>
>
> <attribute
> name="GCMinIdleTime">1200000</attribute><BR>
>
> <attribute name="JDBCUser" /><BR>
> <attribute
> name="MaxSize">10</attribute><BR>
> <attribute
> name="Password" /><BR> <attribute
> name="GCEnabled">false</attribute><BR>
> <attribute
> name="InvalidateOnError">false</attribute><BR>
>
> <attribute
> name="TimestampUsed">false</attribute><BR>
>
> <attribute
> name="Blocking">true</attribute><BR>
> <attribute
> name="GCInterval">120000</attribute><BR>
> <attribute
> name="IdleTimeout">1800000</attribute><BR>
>
> <attribute
> name="IdleTimeoutEnabled">false</attribute><BR>
>
> <attribute
> name="LoggingEnabled">false</attribute><BR>
>
> <attribute
> name="MaxIdleTimeoutPercent">1.0</attribute><BR>
>
> <attribute name="MinSize">0</attribute><BR>
> </mbean></FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT size=2> <mbean
> code="org.jboss.jdbc.XADataSourceLoader"
>
>name="DefaultDomain:service=XADataSource,name=DefaultDS"><BR>
>
> <attribute
> name="PoolName">DefaultDS</attribute><BR>
> <attribute
>
>name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute><BR>
>
> <attribute name="Properties"></attribute><BR>
>
> <attribute
>
>name="URL">jdbc:HypersonicSQL:hsql://localhost:1476</attribute><BR>
>
> <attribute
> name="GCMinIdleTime">1200000</attribute><BR>
>
> <attribute name="JDBCUser">sa</attribute><BR>
>
> <attribute name="MaxSize">10</attribute><BR>
>
> <attribute name="Password" /><BR>
> <attribute
> name="GCEnabled">false</attribute><BR>
> <attribute
> name="InvalidateOnError">false</attribute><BR>
>
> <attribute
> name="TimestampUsed">false</attribute><BR>
>
> <attribute
> name="Blocking">true</attribute><BR>
> <attribute
> name="GCInterval">120000</attribute><BR>
> <attribute
> name="IdleTimeout">1800000</attribute><BR>
>
> <attribute
> name="IdleTimeoutEnabled">false</attribute><BR>
>
> <attribute
> name="LoggingEnabled">false</attribute><BR>
>
> <attribute
> name="MaxIdleTimeoutPercent">1.0</attribute><BR>
>
> <attribute name="MinSize">0</attribute><BR>
> </mbean></FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT size=2> </FONT></DIV>
> <DIV><FONT size=2> Help me out
> pls,</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT size=2>--Krishna</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
>
> <html>
> <br>
> *********************************************************<br>
> Disclaimer<br>
> <br>
> This message (including any attachments) contains <br>
> confidential information intended for a specific <br>
> individual and purpose, and is protected by law. <br>
> If you are not the intended recipient, you should <br>
> delete this message and are hereby notified that <br>
> any disclosure, copying, or distribution of this<br>
> message, or the taking of any action based on it, <br>
> is strictly prohibited.<br>
> <br>
> *********************************************************<br>
> Visit us at http://www.mahindrabt.com<br>
> <br>
> </html>
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
