Hi ! I am trying to use Jboss 2.1 for a new project I have at work using J2EE. Everything was wonderful, indeed I was impressed with the hot deploy technology that I didn't found in other servers. The problem came when I tried to get a connection pooling to MS SQL Server 7.0. I followed exactly the tutorial that I found at http://www.jboss.org/documentation/mssql.htm, but didn't work. I tried using i-net Opti JDBC as described in the documentation. As described I added the following lines to jboss.jcml: <mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider"> <attribute name="Drivers">org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,com. inet.tds.TdsDriver</attribute> </mbean> <mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=SQLServerPool"> <attribute name="DataSourceClass">com.inet.tds.XDataSource</attribute> <attribute name="PoolName">SQLServerPool</attribute> <attribute name="Properties">host=CV; database=Gestion</attribute> <attribute name="JDBCUser">sa</attribute> <attribute name="Password"></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> The driver is loading correctly because I get the following at the command prompt: [JDBC provider] Loaded JDBC-driver:com.inet.tds.TdsDriver But then I get the following exception: [SQLServerPool] Starting [SQLServerPool] Stopped [SQLServerPool] java.lang.NoSuchMethodException [SQLServerPool] at java.lang.Class.getMethod0(Native Method) [SQLServerPool] at java.lang.Class.getMethod(Class.java:888) [SQLServerPool] at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:277) [SQLServerPool] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:93) [SQLServerPool] at java.lang.reflect.Method.invoke(Native Method) [SQLServerPool] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628) [SQLServerPool] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523) [SQLServerPool] at org.jboss.util.ServiceControl.start(ServiceControl.java:97) [SQLServerPool] at java.lang.reflect.Method.invoke(Native Method) [SQLServerPool] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628) [SQLServerPool] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523) [SQLServerPool] at org.jboss.Main.<init>(Main.java:203) [SQLServerPool] at org.jboss.Main$1.run(Main.java:107) [SQLServerPool] at java.security.AccessController.doPrivileged(Native Method) If I change the line <attribute name="DataSourceClass">com.inet.tds.XDataSource</attribute> for <attribute name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp l</attribute> JBoss hangs while starting the connection pool at [SQLServerPool] Starting [SQLServerPool] XA Connection pool SQLServerPool bound to java:/SQLServerPool The same situation happened when I tried the JDBC:ODBC driver and JSQLConnect driver. The MS SQL Server database is running and I can access without problem through JDBC with the parameters posted above. I am missing something ? I am doing something wrong ? Could anyone connect to MS SQL Server 7.0 through Jboss ? Please note that if I can't connect to MS SQL Server 7.0 (our corporate database)through JBoss I would have to choose other server. Thanks in advance, Claudio. _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user
