1 Reply Latest reply on Jan 9, 2002 2:54 PM by garymarsh

    JSQLConnect Driver for SQL Server

    bhaskar

      Hi ,

      I'm new to JBoss and i'm working on a sample application that can insert a user record into the SQL database thru' stored procedure.
      I have problem in getting a DB connection pool using the JSQLConnect driver (we have been using this earlier on a RMI environment and found this driver to be good).
      Modified the Jboss.jcml file to have an MBean clause similar to DefaultDS, only change that i did was changed the driver class to com.jnetdirect.jsql.JSQLDriver -- that is my JSQLConnect driver's class file.
      Now when i startup the JBoss it does not start at all.. it just says on console as starting and just holds on their --- and help would be great.. check below for my .jcml MBean clause.


      DefaultDS2
      com.jnetdirect.jsql.JSQLDriver
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

      jdbc:JSQLConnect://coredata/database=hsx_new
      1200000
      hsx
      10
      foru
      false
      false
      false
      true
      120000
      1800000
      false
      false
      1.0
      0





      --bhaskar