Hi J�ns,
I tried with the WebLogic JDBC type 4 driver for MS SQL Svr 7, with jBoss
Final 2.0, without Tomcat or Jetty. I didn't not run the CMP example you
mentioned, but our own, without any real problem. I'll try to run your CMP
example with an SQL Svr as the DB store, to see if it's running properly.
I'll keep you informed.
I'm also trying to setup a pool with another driver, Opta2000, from i-Net
Software (you can download an evaluation version, limited to 2 connections,
there : http://www.inetsoftware.de/English/).
Why ? Just have a look at the pricing table, and compare it the the WebLogic
one... ;o) And it also support distributed transaction (XA) (that's what I'm
currently fighting with to get it work). I'll keep you all informed about
it.
Here are my configuration values for WebLogic :
+++++++++[jBoss Home]/conf/default/jboss.properties++++++
Modified the 'jdbc.drivers' property :
jdbc.drivers=org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,weblog
ic.jdbc.mssqlserver4.Driver
---------[jBoss Home]/conf/default/jboss.properties------
+++++++++[jBoss Home]/conf/jboss.conf++++++
Copied [jBoss Home]/conf/default/jboss.conf to [jBoss Home]/conf/jboss.conf,
replaced any '../../lib/ext/' by '../lib/ext/' and added the following node
:
<MLET CODE="org.jboss.jdbc.XADataSourceLoader"
ARCHIVE="jboss.jar,weblogicdriver.jar" CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="SqlSvrConnectionPool">
<ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
</MLET>
---------[jBoss Home]/conf/jboss.conf------
+++++++++[jBoss Home]/conf/jboss.jcml++++++
Added the following node :
<mbean
name="DefaultDomain:service=XADataSource,name=SqlSvrConnectionPool">
<attribute
name="URL">jdbc:weblogic:mssqldriver4:j2eedb@mymachine:1433</attribute>
<attribute name="Password">test</attribute>
<attribute name="JDBCUser">test</attribute>
<attribute name="LoggingEnabled">true</attribute>
</mbean>
---------[jBoss Home]/conf/jboss.jcml------
The attribute "LogginEnabled" allows to get a bit more info on what's going
on about the connection pool.
At startup, you should get something like this :
+++++++++Startup trace++++++
Using configuration "default"
[Console logging] Initialized
[Classpath extension] Initializing
[Classpath extension] Initialized
[File logging] Initializing
[File logging] Initialized
[Classpath extension] Initializing
[Classpath extension] Initialized
[Classpath extension] Initializing
[Classpath extension] Initialized
[Info] Java version: 1.3.0,Sun Microsystems Inc.
[Info] Java VM: Java HotSpot(TM) Client VM 1.3.0-C,Sun Microsystems Inc.
[Info] System: Windows NT 4.0,x86
[Classpath extension] Initializing
[Classpath extension] Initialized
[JDBC] Loaded JDBC-driver:org.hsql.jdbcDriver
[JDBC] Loaded JDBC-driver:org.enhydra.instantdb.jdbc.idbDriver
[JDBC] Loaded JDBC-driver:com.inet.tds.TdsDriver
[JDBC] Loaded JDBC-driver:weblogic.jdbc.mssqlserver4.Driver
[Webserver] Initializing
[Webserver] Initialized
[Hypersonic] Initializing
[Hypersonic] Initialized
[Naming] Initializing
[Naming] Naming started on port 1099
[Naming] Initialized
[Transaction manager] Initializing
[Transaction manager] Initialized
[JAAS Security Manager] Initializing
[JAAS Security Manager] Initialized
[Simple Realm Mapping] Initializing
[Simple Realm Mapping] Initialized
[Security manager] Initializing
[Security manager] Initialized
[InstantDB] Initializing
[InstantDB] Initialized
[DefaultDS] Initializing
[DefaultDS] Initialized
[Container factory] Initializing
[Container factory] Initialized
[Auto deploy] Watching C:\dev\jBoss-2.0_FINAL\deploy
[Auto deploy] Initializing
[Auto deploy] Initialized
[JMX RMI Adaptor] Initializing
[JMX RMI Adaptor] Initialized
[JMX RMI Connector] Initializing
[JMX RMI Connector] Initialized
[Configuration] Initializing
[Configuration] Initialized
[J2EE Deployer] Initializing
[J2EE Deployer] Initialized
[SpyderMQ] Initializing
[SpyderMQ] Initialized
[SqlSvrConnectionPool] Initializing
[SqlSvrConnectionPool] Initialized
[Simple Realm Mapping] Starting
[Simple Realm Mapping] Started
[Webserver] Starting
[Webserver] Codebase set to http://mymachine:8083/
[Webserver] Started webserver on port 8083
[Webserver] Started
[Transaction manager] Starting
[Transaction manager] Started
[Hypersonic] Starting
[Hypersonic] Server 1.4 is running
[Hypersonic] Database started
[Hypersonic] Started
[Naming] Starting
[Naming] Started
[SqlSvrConnectionPool] Starting
[SqlSvrConnectionPool] XA Connection pool SqlSvrConnectionPool bound to
java:/SqlSvrConnectionPool
[Hypersonic] Press [Ctrl]+[C] to abort
[SqlSvrConnectionPool] org.jboss.minerva.xa.XADataSourceImpl created new
Connection (weblogic.jdbc.mssqlserver4.MicrosoftConnection) with XAResource
org.jboss.minerva.xa.XAResourceImpl and XAConnection
org.jboss.minerva.xa.XAConnectionImpl.
[SqlSvrConnectionPool] No transaction right now.
[SqlSvrConnectionPool] Pool SqlSvrConnectionPool [0/0/Unlimited] gave out
new object: org.jboss.minerva.xa.XAConnectionImpl@c62c8
[SqlSvrConnectionPool] Pool SqlSvrConnectionPool [0/1/Unlimited] returned
object org.jboss.minerva.xa.XAConnectionImpl@c62c8 to the pool.
[SqlSvrConnectionPool] Started
[InstantDB] Starting
[InstantDB] XA Connection pool InstantDB bound to java:/InstantDB
Enhydra InstantDB - Version 3.21
[InstantDB] The Initial Developer of the Original Code is Lutris
Technologies Inc.
Portions created by Lutris are Copyright (C) 1997-2000 Lutris Technologies,
Inc.
All Rights Reserved.
[InstantDB] Started
[DefaultDS] Starting
[DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS
[DefaultDS] org.jboss.minerva.xa.XADataSourceImpl created new Connection
(org.hsql.jdbcConnection) with XAResource
org.jboss.minerva.xa.XAResourceImpl and XAConnection
org.jboss.minerva.xa.XAConnectionImpl.
[DefaultDS] No transaction right now.
[DefaultDS] Pool DefaultDS [0/0/10] gave out new object:
org.jboss.minerva.xa.XAConnectionImpl@b3364
[DefaultDS] Pool DefaultDS [0/1/10] returned object
org.jboss.minerva.xa.XAConnectionImpl@b3364 to the pool.
[DefaultDS] Started
[JAAS Security Manager] Starting
[JAAS Security Manager] Started
[Container factory] Starting
[Container factory] Started
[J2EE Deployer] Starting
[J2EE Deployer] No web container found - only EJB deployment available...
[J2EE Deployer] Cleaning up deployment directory
file:/C:/dev/jBoss-2.0_FINAL/bin/../tmp/deploy/
[J2EE Deployer] Started
[Security manager] Starting
[Security manager] Started
[Auto deploy] Starting
[Auto deploy] Started
[SpyderMQ] Starting
[SpyderMQ] Testing if SpyderMQ is present....
[SpyderMQ] OK
[SpyderMQ] Starting SpyderMQ...
[SpyderMQ] Started
[JMX RMI Adaptor] Starting
[JMX RMI Adaptor] Started
[JMX RMI Connector] Starting
[JMX RMI Connector] Started
[Default] 23 services and 4 other MBeans started.
[Default] Shutdown hook added
[Default] jBoss 2.0 FINAL Started
---------Startup trace------
And that's it : my beans are running properly...
Are you sure that your driver does not require additional parameters or
properties ?
Hope it could help,
Pascal Davoust.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Monday, November 27, 2000 1:20 PM
To: [EMAIL PROTECTED]
Subject: [jBoss-User] MSSQL and Jboss
Hi,
I'm trying to get SQLServer7 to work with Jboss and I have done as it's done
in the manual(http://www.jboss.org/manual/adv_config.html#datasources) as
far as I can see. I still end up with errors when running run_with_tomcat
though. With the out-of-the-box jboss and Tomcat I get the CMP-example
(http://www.jboss.org/documentation/jboss_cmp_trail_index.html) running, so
it doesn't seem to be some kind of general problem with my installation
connecting to db:s...
I use the SQLDriver aveConnect 2.3 (aveConnect23.JAR) from Atinav which is a
Type 4 Driver for MS SQL Server 6.5/7.0.
You guys (Pascal Davoust...) out there who have made it work, what driver
did you use?
Changes in conf/tomcat/jboss.conf:
<MLET CODE="org.jboss.jdbc.XADataSourceLoader"
ARCHIVE="jboss.jar,aveConnect23.jar" CODEBASE="../../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="MSSQLPool">
<ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
</MLET>
Changes in conf/tomcat/jboss.jcml:
<mbean name="DefaultDomain:service=XADataSource,name=MSSQLPool">
<attribute name="Properties"></attribute>
<attribute
name="URL">jdbc:AvenirDriver://localhost:1433/j2eedb</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">j2ee</attribute>
<attribute name="MaxSize">0</attribute>
<attribute name="Password">j2ee</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>
log:
...
[Classpath extension] Initialized
[JDBC] Loaded JDBC-driver:org.hsql.jdbcDriver
[JDBC] Loaded JDBC-driver:org.enhydra.instantdb.jdbc.idbDriver
[JDBC] Loaded JDBC-driver:net.avenir.jdbc2.Driver
...
[MSSQLPool] Initializing
[MSSQLPool] Initialized
...
[Configuration] Detected JMX Bug: Server reports attribute 'JDBCUser' is not
writeable for MBean 'DefaultDomain:name=InstantDB,service=XADataSource'
[Configuration] Detected JMX Bug: Server reports attribute 'TimestampUsed'
is not writeable for MBean
'DefaultDomain:name=InstantDB,service=XADataSource'
[Configuration] Detected JMX Bug: Server reports attribute 'JDBCUser' is not
writeable for MBean 'DefaultDomain:name=DefaultDS,service=XADataSource'
[Configuration] Detected JMX Bug: Server reports attribute 'TimestampUsed'
is not writeable for MBean
'DefaultDomain:name=DefaultDS,service=XADataSource'
[Configuration] Detected JMX Bug: Server reports attribute 'JDBCUser' is not
writeable for MBean 'DefaultDomain:name=MSSQLPool,service=XADataSource'
[Configuration] Detected JMX Bug: Server reports attribute 'TimestampUsed'
is not writeable for MBean
'DefaultDomain:name=MSSQLPool,service=XADataSource'
...
[Hypersonic] Starting
[Hypersonic] Server 1.4 is running
[Hypersonic] Database started
[Hypersonic] Started
[InstantDB] Starting
[InstantDB] XA Connection pool InstantDB bound to java:/InstantDB
[Hypersonic] Press [Ctrl]+[C] to abort
[InstantDB] The Initial Developer of the Original Code is Lutris
Technologies Inc.
Portions created by Lutris are Copyright (C) 1997-2000 Lutris Technologies,
Inc.
All Rights Reserved.
[InstantDB] Started
[MSSQLPool] Starting
[MSSQLPool] XA Connection pool MSSQLPool bound to java:/MSSQLPool
[Default] Error starting service
'DefaultDomain:name=MSSQLPool,service=XADataSource':
javax.management.RuntimeErrorException: Error thrown in operation start
Regards
/J�ns
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
