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]
