RE: [JBoss-user] Configuring JBoss 2.4 with MS SQL Server?

[Anthony Servito]

Title: Configuring JBoss 2.4 with MS SQL Server?

Oh correction,   <mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider">      <attribute name="Drivers">com.inet.tds.TdsDriver</attribute>   </mbean>     <mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=db_source_name">     <attribute name="PoolName">db_source_name</attribute>     <attribute name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute>     <attribute name="URL">jdbc:inetdae7:localhost:1433:?database=database_name_here</attribute>     <attribute name="JDBCUser">username_here</attribute>     <attribute name="Password">password_here</attribute>     <attribute name="Properties"></attribute>     <attribute name="GCMinIdleTime">1200000</attribute>     <attribute name="MaxSize">10</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> -----Original Message----- From: Anthony Servito Sent: Thursday, March 14, 2002 6:35 PM To: Dmitri Colebatch; Michael Schulz; JD Brennan; JBoss Users (E-mail) Subject: RE: [JBoss-user] Configuring JBoss 2.4 with MS SQL Server? Try this Jboss 2.4 with Tomcat   Note :  I am using Sprint  driver here.   Place these line on jboss.jcml.   Cheers   AntS   <mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider">      <attribute name="Drivers">com.inet.tds.TdsDriver</attribute>   </mbean>     <mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=db_source_name">     <attribute name="PoolName">EstoreDB</attribute>     <attribute name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute>     <attribute name="URL">jdbc:inetdae7:localhost:1433:?database=database_name_here</attribute>     <attribute name="JDBCUser">username_here</attribute>     <attribute name="Password">password_here</attribute>     <attribute name="Properties"></attribute>     <attribute name="GCMinIdleTime">1200000</attribute>     <attribute name="MaxSize">10</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> -----Original Message----- From: Dmitri Colebatch [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 4:43 PM To: Michael Schulz; JD Brennan; JBoss Users (E-mail) Subject: Re: [JBoss-user] Configuring JBoss 2.4 with MS SQL Server? I've had it working (not with JBoss) with SQL server 6.5 and 7 as well.   cheers dim ----- Original Message ----- From: Michael Schulz To: JD Brennan ; JBoss Users (E-mail) Sent: Friday, March 15, 2002 5:05 AM Subject: RE: [JBoss-user] Configuring JBoss 2.4 with MS SQL Server? You should check on the Microsoft web site, but I'm pretty sure that the Microsoft JDBC Driver only supports SQL Server 2000.   -Mike -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JD Brennan Sent: Wednesday, March 13, 2002 7:06 PM To: JBoss Users (E-mail) Subject: [JBoss-user] Configuring JBoss 2.4 with MS SQL Server? I'm trying to set up MS SQL Server 7.0 with JBoss 2.4.4   <mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider">      <attribute name="Drivers">org.hsqldb.jdbcDriver,com.microsoft.jdbc.sqlserver.SQLServerDriver</attribute>   </mbean>   <mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=SQLServerPool">     <attribute name="DataSourceClass">com.microsoft.jdbcx.sqlserver.SQLServerDataSource</attribute>     <attribute name="PoolName">SQLServerPool</attribute>     <attribute name="URL">jdbc:microsoft:sqlserver://sqltest1:1433</attribute>     <attribute name="Properties">DatabaseName=testlog</attribute>     <attribute name="JDBCUser">rn_user</attribute>     <attribute name="Password">rn_user</attribute>   </mbean> Error: [ERROR,ConfigurationService] Unexpected error java.lang.NoClassDefFoundError: javax/sql/DataSource Full error stack trace is below.  This javax.sql.DataSource is in the jboss/lib/jboss-jdbc_ext.jar file.  I tried putting that in JBOSS_CLASSPATH before starting jboss and copying it the the jboss/lib/ext directory, but that didn't make any difference. A search of the mail archive turned up a similar problem with InstantDB where a null URL would cause this problem, but I don't have a null URL. Any ideas? Thanks! JD Full error stack trace: [ERROR,ConfigurationService] Unexpected error java.lang.NoClassDefFoundError: javax/sql/DataSource         at java.lang.ClassLoader.defineClass0(Native Method)         at java.lang.ClassLoader.defineClass(ClassLoader.java:486)         at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:111)         at java.net.URLClassLoader.defineClass(URLClassLoader.java:248)         at java.net.URLClassLoader.access$100(URLClassLoader.java:56)         at java.net.URLClassLoader$1.run(URLClassLoader.java:195)         at java.security.AccessController.doPrivileged(Native Method)         at java.net.URLClassLoader.findClass(URLClassLoader.java:188)         at java.lang.ClassLoader.loadClass(ClassLoader.java:297)         at java.lang.ClassLoader.loadClass(ClassLoader.java:253)         at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313)         at java.lang.ClassLoader.defineClass0(Native Method)         at java.lang.ClassLoader.defineClass(ClassLoader.java:486)         at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:111)         at java.net.URLClassLoader.defineClass(URLClassLoader.java:248)         at java.net.URLClassLoader.access$100(URLClassLoader.java:56)         at java.net.URLClassLoader$1.run(URLClassLoader.java:195)         at java.security.AccessController.doPrivileged(Native Method)         at java.net.URLClassLoader.findClass(URLClassLoader.java:188)         at java.lang.ClassLoader.loadClass(ClassLoader.java:297)         at java.lang.ClassLoader.loadClass(ClassLoader.java:290)         at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:286)         at java.lang.ClassLoader.loadClass(ClassLoader.java:290)         at java.lang.ClassLoader.loadClass(ClassLoader.java:253)         at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313)         at java.lang.Class.forName0(Native Method)         at java.lang.Class.forName(Class.java:120)         at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:348)         at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103)         at java.lang.reflect.Method.invoke(Native Method)         at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)         at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)         at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:967)         at $Proxy0.start(Unknown Source)         at org.jboss.util.ServiceControl.start(ServiceControl.java:79)         at java.lang.reflect.Method.invoke(Native Method)         at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)         at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)         at org.jboss.Main.<init>(Main.java:208)         at org.jboss.Main$1.run(Main.java:110)         at java.security.AccessController.doPrivileged(Native Method)         at org.jboss.Main.main(Main.java:106) --