0 Replies Latest reply on Sep 6, 2002 11:01 AM by Siva

    JBOSS Unable to find the SQL Server Database

    Siva Newbie

      To members,

      I am working with JBoss-2.4.4 and Jetty-3.1.7-1. I am trying to use
      MS SQL Server as my database server. I am having a data base named
      'NewDB' and my data source name is 'SQLDataSource' and I am having the
      following entries in jboss.jcml under the
      %JBOSS_HOME%\jboss\conf\jetty directory.

      I Start the JBOSS by run_with_jetty.bat. When I hit my page which
      access the data base, it unable to find the tables, Stored procedures
      in the database, ie, I belive it unable to find the database itself.
      When I see the SQLServer log it shows some activity from the JBOSS
      server which proves my port number and server host name are correct.

      Can any one help me out what am I missing.

      My JBOSS.jcml entries.


      org.hsqldb.jdbcDriver,com.microsoft.jdbc.sqlserver.SQLServerDriver



      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
      SQLDataSource
      jdbc:sqlserver://pc800:1433;database=NewDB;SelectMethod=cursor
      NewDB
      host=pc800;
      database=NewDB
      sa
      sa
      true
      1200000
      10
      false
      false
      false
      true
      120000
      1800000
      false
      false
      1.0
      0


      Siva