Hi
Just managed to get it working recently.
1) Download their latest version (2.05 fix)
2) Leave the attribute URL blank
3) Use the attribute properites instead
eg.
<attribute name="Properties">host=localhost; database=EJB</attribute>
Regards
Chiah Tong Kiat
PS: there is a updated document at www.inetsoftware.de. Just search using
jboss
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Kevin Meldorf
(NBK)
Sent: Thursday, March 08, 2001 11:12 PM
To: '[EMAIL PROTECTED]'
Subject: [jBoss-User] Inet Opta2000 driver for MS SQL Server not working
in Jboss2.1bet a
We are trying to get the Opta2000 driver to work in jboss2.1, but
we keep getting the following error when jboss2.1 boots up:
[Opta2000AgentPool] Starting
[Opta2000AgentPool] Stopped
[Opta2000AgentPool] java.lang.NoSuchMethodException
[Opta2000AgentPool] at java.lang.Class.getMethod0(Native Method)
[Opta2000AgentPool] at java.lang.Class.getMethod(Unknown Source)
[Opta2000AgentPool] at
org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:277)
[Opta2000AgentPool] at
org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:93)
[Opta2000AgentPool] at java.lang.reflect.Method.invoke(Native Method)
[Opta2000AgentPool] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Opta2000AgentPool] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Opta2000AgentPool] at
org.jboss.util.ServiceControl.start(ServiceControl.java:97)
[Opta2000AgentPool] at java.lang.reflect.Method.invoke(Native Method)
[Opta2000AgentPool] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Opta2000AgentPool] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Opta2000AgentPool] at org.jboss.Main.<init>(Main.java:190)
[Opta2000AgentPool] at org.jboss.Main$1.run(Main.java:94)
[Opta2000AgentPool] at
java.security.AccessController.doPrivileged(Native Method)
[Opta2000AgentPool] at org.jboss.Main.main(Main.java:90)
[Service Control] Could not start
DefaultDomain:service=XADataSource,name=Opta2000AgentPool
[Service Control] java.lang.NoSuchMethodException
[Service Control] at java.lang.Class.getMethod0(Native Method)
[Service Control] at java.lang.Class.getMethod(Unknown Source)
[Service Control] at
org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:277)
[Service Control] at
org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:93)
[Service Control] at java.lang.reflect.Method.invoke(Native Method)
[Service Control] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Service Control] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Service Control] at
org.jboss.util.ServiceControl.start(ServiceControl.java:97)
[Service Control] at java.lang.reflect.Method.invoke(Native Method)
[Service Control] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Service Control] at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Service Control] at org.jboss.Main.<init>(Main.java:190)
[Service Control] at org.jboss.Main$1.run(Main.java:94)
[Service Control] at
java.security.AccessController.doPrivileged(Native Method)
[Service Control] at org.jboss.Main.main(Main.java:90)
We have taken into the account the deprecation and changes made to some of
the configuration files, but still no luck. I am enclosing the references
that we make to the driver in our reference files (well actually it looks
like
we only refer to the driver in jboss.jcml now...) and we would greatly
appreciate any help -- we are so close! Are we missing something? We tried
to make a reference to the driver in jboss.conf (like we did in earlier
versions)
with the MLET tag, but this caused an additional more heinous error.
Once we have this figured out we will post the fix to the list.
Here are the refs in jboss.jcml
<!-- JDBC added ref to opta2000 driver KTM 02/26/01-->
<mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
<attribute name="Drivers"
org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,com.inet.tds.TdsDri
ver,com.inet.tds.XDataSource</attribute>
</mbean>
<!-- added ktm 03/01/01 this ref follows the defaultDB ref-->
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=Opta2000AgentPool">
<attribute name="PoolName">Opta2000AgentPool</attribute>
<attribute
name="DataSourceClass">com.inet.tds.XDataSource</attribute>
<attribute name="Properties"></attribute>
<attribute name="URL">jdbc:inetdae:localhost:1433</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">frank</attribute>
<attribute name="MaxSize">0</attribute>
<attribute name="Password">frank</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>
------------------------------------
Kevin Meldorf
Systems Analyst
WorldTravel BTI
400 Skokie Blvd
Northbrook, IL 60062
Phone: (847) 480-8340
Fax: (810) 314-7594
[EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
