I am trying to connect to the companies SQL server using merant drivers. I
have followed the detailed instruction given in the jboss documentation.
However I still cannot link to the database. I think the problem is that
jboss cannot find the drivers which I have copied into the ...jboss/lib/ext
directory (base.jar, sqlserver.jar and util.jar).
I have changed the Jdbc.Providerentry in the jboss.jcml to
<mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
<attribute name="Drivers">
org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,
com.merant.datadirect.jdbc.sqlserver.SQLServerDriver
</attribute>
</mbean>
and added a XADataSourceLoader entry..
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=SQLServerPool">
<attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
l</attribute>
<attribute name="PoolName">SQLServerPool</attribute>
<attribute name="URL">jdbc:sqlserver://server:1433</attribute>
<attribute name="Properties">DatabaseName=GP1</attribute>
<attribute name="JDBCUser">XXX</attribute>
<attribute name="Password">XXX</attribute>
<attribute name="MinSize">0</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
</mbean>
Output does not show the merant driver...
[JDBC provider] Initializing
[JDBC provider] Loaded JDBC-driver:org.hsql.jdbcDriver
[JDBC provider] Loaded JDBC-driver:org.enhydra.instantdb.jdbc.idbDriver
[JDBC provider] Initialized
[Hypersonic] Initializing
[Hypersonic] Initialized
[InstantDB] Initializing
[InstantDB] Initialized
[DefaultDS] Initializing
[DefaultDS] Initialized
...
[JDBC provider] Starting
[JDBC provider] Started
[Hypersonic] Starting
[Hypersonic] Database started
[Hypersonic] Started
[InstantDB] Starting
[InstantDB] XA Connection pool InstantDB bound to java:/InstantDB
[Hypersonic] Server 1.4 is running
[Hypersonic] Press [Ctrl]+[C] to abort
Enhydra InstantDB - Version 3.26
[InstantDB] The Initial Developer of the Original Code is Lutris
Technologies In
c.
Portions created by Lutris are Copyright (C) 1997-2001 Lutris Technologies,
Inc.
All Rights Reserved.
[InstantDB] Started
[DefaultDS] Starting
[DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS
[DefaultDS] Started
If I am right any ideas..
Thanx
Alan
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
