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