Error Received when Connection to the SQL DB

You need to add the driver jar to JBoss

the jdbc driver is not available
where have you put the jars?

Place the driver for - com.microsoft.sqlserver.jdbc.SQLServerDriver in the server/lib directory of jboss

think the jdbc drivers need to be in put in /server/default/lib of your jboss installation

Hi

Check the folder jboss-5.1.0.GA\server\default\lib it is empty.

Question does the download of jboss not come with the *'jars that it needs?

Where can I download the *.jar

That's not part of JBoss. Your db should probably have the jdbc driver you need

no;

http://support.microsoft.com/kb/313100 shows the sort of jars you should be looking for

check this ;

http://blogs.msdn.com/b/jdbcteam/archive/2007/06/15/java-lang-classnotfoundexception-com-microsoft-jdbc-sqlserver-sqlserverdriver.aspx

> Question does the download of jboss not come with the *'jars that it needs?

it does comes with the jars it needs

the jdbc driver is required by your application, not jboss

you can download the driver from MS

Hi

Download the sqljdbc_3.0.1301.101_enu.exe followed in instructions in enu\help\default.htm documents.

Please noted I extracted the *.exe in
 
Program Files\Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu

and updated my environment variables

After this I run a test class and received this Error


java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver://server      est:1433;databaseName=MMTicket;selectMethod=cursor;Error Trace in getConnection() : No suitable driver found for jdbc:microsoft:sqlserver://server1      est:1433;databaseName=DBNAME;selectMethod=cursor;

      at java.sql.DriverManager.getConnection(DriverManager.java:602)
      at java.sql.DriverManager.getConnection(DriverManager.java:185)
      at connectionTest.Connect.getConnection(Connect.java:26)
      at connectionTest.Connect.displayDbProperties(Connect.java:43)
      at connectionTest.Connect.main(Connect.java:79)
Error: No active Connection

package connectionTest;

public class Connect{
    private java.sql.Connection  con = null;
    private final String url = "jdbc:microsoft:sqlserver://";
    private final String serverName= "server\server";
    private final String portNumber = "port";
    private final String databaseName= "DBNAME";
    private final String userName = "USERNAME";
    private final String password = "password";
    // Informs the driver to use server a side-cursor, 
    // which permits more than one active statement 
    // on a connection.
    private final String selectMethod = "cursor"; 
    
    // Constructor
    public Connect(){}
    
    private String getConnectionUrl(){
         return url+serverName+":"+portNumber+";databaseName="+databaseName+";selectMethod="+selectMethod+";";
    }
    
    private java.sql.Connection getConnection(){
         try{
              Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); 
              con = java.sql.DriverManager.getConnection(getConnectionUrl(),userName,password);
              if(con!=null) System.out.println("Connection Successful!");
         }catch(Exception e){
              e.printStackTrace();
              System.out.println("Error Trace in getConnection() : " + e.getMessage());
        }
         return con;
     }

    /*
         Display the driver properties, database details 
    */ 

    public void displayDbProperties(){
         java.sql.DatabaseMetaData dm = null;
         java.sql.ResultSet rs = null;
         try{
              con= this.getConnection();
              if(con!=null){
                   dm = con.getMetaData();
                   System.out.println("Driver Information");
                   System.out.println("\tDriver Name: "+ dm.getDriverName());
                   System.out.println("\tDriver Version: "+ dm.getDriverVersion ());
                   System.out.println("\nDatabase Information ");
                   System.out.println("\tDatabase Name: "+ dm.getDatabaseProductName());
                   System.out.println("\tDatabase Version: "+ dm.getDatabaseProductVersion());
                   System.out.println("Avalilable Catalogs ");
                   rs = dm.getCatalogs();
                   while(rs.next()){
                        System.out.println("\tcatalog: "+ rs.getString(1));
                   } 
                   rs.close();
                   rs = null;
                   closeConnection();
              }else System.out.println("Error: No active Connection");
         }catch(Exception e){
              e.printStackTrace();
         }
         dm=null;
    }     
    
    private void closeConnection(){
         try{
              if(con!=null)
                   con.close();
              con=null;
         }catch(Exception e){
              e.printStackTrace();
         }
    }
    public static void main(String[] args) throws Exception
      {
         Connect myDbTest = new Connect();
         myDbTest.displayDbProperties();
      }
}

Select allOpen in new window

Did you put the necessary jars in JBOss?

sounds like a problem in your connection string.
make sure its pointing at the correct server and database

> jdbc:microsoft:sqlserver:

don't think microsoft should be in there

I placed the sqljdbc4.jar and sqljdbc.jar in the \server\default\lib directory.

I then change

from
jdbc:microsoft:sqlserver://"
to
"jdbc:sqlserver://";

but received Error


02 Aug 2010 11:47:35 AM com.microsoft.sqlserver.jdbc.SQLServerConnection <init>
SEVERE: Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:238)
      at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:841)
      at java.sql.DriverManager.getConnection(DriverManager.java:582)
      at java.sql.DriverManager.getConnection(DriverManager.java:185)
      at connectionTest.Connect.getConnection(Connect.java:26)
      at connectionTest.Connect.displayDbProperties(Connect.java:43)
      at connectionTest.Connect.main(Connect.java:79)
Error Trace in getConnection() : Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
Error: No active Connection

java version from cmd

java version "1.5.0_20"

> I placed the sqljdbc4.jar and sqljdbc.jar in the \server\default\lib directory.

you don't need to for testing. It was already loading the driver

But you're problem is you have includes both jars, you only want one
If you're using java 5 then use sqljdbc.jar

use sqljdbc4.jar

> use sqljdbc4.jar

only use that if you're running java 6, which you mentioned above that you weren't

when I tried using the sqljdbc.jar I get this error

02 Aug 2010 1:09:40 PM com.microsoft.sqlserver.jdbc.SQLServerConnection <init>
SEVERE: Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:238)
      at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:841)
      at java.sql.DriverManager.getConnection(DriverManager.java:582)
      at java.sql.DriverManager.getConnection(DriverManager.java:185)
      at connectionTest.Connect.getConnection(Connect.java:27)
      at connectionTest.Connect.displayDbProperties(Connect.java:44)
      at connectionTest.Connect.main(Connect.java:80)
Error Trace in getConnection() : Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
Error: No active Connection

>>Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.

As i said, use sqljdbc4.jar

that suggests you are not using 1.5, but are actually running with java 6
In that case use sqljdbc4.jar as I explained earlier

Seems to be getting a other Error now.

I consulted with the SQL DBA and I test a ODBC and it works fine. The port is 5001


com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host SERVERNAME      est, port 1433 has failed. Error: "null. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1033)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)
      at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
      at java.sql.DriverManager.getConnection(DriverManager.java:582)
      at java.sql.DriverManager.getConnection(DriverManager.java:185)
      at connectionTest.Connect.getConnection(Connect.java:27)
      at connectionTest.Connect.displayDbProperties(Connect.java:44)
      at connectionTest.Connect.main(Connect.java:80)
Error Trace in getConnection() : The TCP/IP connection to the host SERVERNAME      est, port 1433 has failed. Error: "null. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
Error: No active Connection

Have you taken all the action suggested in the error message? If so, what were the results?

It cannot access the database where you have specified. check the database is up and running and listening on that port

When I test this from my application

Here is the full Error from the console


13:54:34,886 ERROR [STDERR] Debug: Search Query = select * from TicketArchive where UPPER(user_name) like UPPER('%yn%') order by ticket_date desc, deal_id desc
13:54:38,433 WARN  [ClassLoaderManager] Unexpected error during load of:com.microsoft.sqlserver.jdbc.SQLServerDriver
java.lang.UnsupportedClassVersionError: Bad version number in .class file
      at java.lang.ClassLoader.defineClass1(Native Method)
      at java.lang.ClassLoader.defineClass(Unknown Source)
      at org.jboss.classloader.spi.base.BaseClassLoader.access$200(BaseClassLoader.java:63)
      at org.jboss.classloader.spi.base.BaseClassLoader$2.run(BaseClassLoader.java:572)
      at org.jboss.classloader.spi.base.BaseClassLoader$2.run(BaseClassLoader.java:532)
      at java.security.AccessController.doPrivileged(Native Method)
      at org.jboss.classloader.spi.base.BaseClassLoader.loadClassLocally(BaseClassLoader.java:530)
      at org.jboss.classloader.spi.base.BaseClassLoader.loadClassLocally(BaseClassLoader.java:507)
      at org.jboss.classloader.spi.base.BaseDelegateLoader.loadClass(BaseDelegateLoader.java:134)
      at org.jboss.classloader.spi.filter.FilteredDelegateLoader.loadClass(FilteredDelegateLoader.java:131)
      at org.jboss.classloader.spi.base.ClassLoadingTask$ThreadTask.run(ClassLoadingTask.java:452)
      at org.jboss.classloader.spi.base.ClassLoaderManager.nextTask(ClassLoaderManager.java:251)
      at org.jboss.classloader.spi.base.ClassLoaderManager.process(ClassLoaderManager.java:150)
      at org.jboss.classloader.spi.base.BaseClassLoaderDomain.loadClass(BaseClassLoaderDomain.java:265)
      at org.jboss.classloader.spi.base.BaseClassLoaderDomain.loadClass(BaseClassLoaderDomain.java:1119)
      at org.jboss.classloader.spi.base.BaseClassLoader.loadClassFromDomain(BaseClassLoader.java:798)
      at org.jboss.classloader.spi.base.BaseClassLoader.loadClass(BaseClassLoader.java:441)
      at java.lang.ClassLoader.loadClass(Unknown Source)
      at java.lang.ClassLoader.loadClassInternal(Unknown Source)
      at java.lang.Class.forName0(Native Method)
      at java.lang.Class.forName(Unknown Source)
      at org.jboss.classloader.plugins.loader.ClassLoaderToLoaderAdapter.loadClass(ClassLoaderToLoaderAdapter.java:172)
      at org.jboss.classloader.spi.ClassLoaderDomain.loadClassFromParent(ClassLoaderDomain.java:352)
      at org.jboss.classloader.spi.ClassLoaderDomain.loadClassAfter(ClassLoaderDomain.java:323)
      at org.jboss.classloader.spi.base.BaseClassLoaderDomain.loadClass(BaseClassLoaderDomain.java:275)
      at org.jboss.classloader.spi.base.BaseClassLoaderDomain.loadClass(BaseClassLoaderDomain.java:1119)
      at org.jboss.classloader.spi.base.BaseClassLoader.loadClassFromDomain(BaseClassLoader.java:798)
      at org.jboss.classloader.spi.base.BaseClassLoader.loadClass(BaseClassLoader.java:441)
      at java.lang.ClassLoader.loadClass(Unknown Source)
      at java.lang.ClassLoader.loadClass(Unknown Source)
      at java.lang.ClassLoader.loadClassInternal(Unknown Source)
      at java.lang.Class.forName0(Native Method)
      at java.lang.Class.forName(Unknown Source)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getDriver(LocalManagedConnectionFactory.java:474)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:206)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:195)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:633)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:267)
      at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:622)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
      at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
      at web.FindDeal.getSearchDeals(FindDeal.java:170)
      at web.FindDeal.doGet(FindDeal.java:72)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
      at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
      at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
      at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
      at java.lang.Thread.run(Unknown Source)
13:54:38,464 WARN  [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: com.microsoft.sqlserver.jdbc.SQLServerDriver; - nested throwable: (java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver))
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:225)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:195)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:633)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:267)
      at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:622)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
      at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
      at web.FindDeal.getSearchDeals(FindDeal.java:170)
      at web.FindDeal.doGet(FindDeal.java:72)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
      at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
      at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
      at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
      at java.lang.Thread.run(Unknown Source)
Caused by: org.jboss.resource.JBossResourceException: Failed to register driver for: com.microsoft.sqlserver.jdbc.SQLServerDriver; - nested throwable: (java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getDriver(LocalManagedConnectionFactory.java:489)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:206)
      ... 34 more
Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
      at java.net.URLClassLoader$1.run(Unknown Source)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.net.URLClassLoader.findClass(Unknown Source)
      at java.lang.ClassLoader.loadClass(Unknown Source)
      at java.lang.ClassLoader.loadClass(Unknown Source)
      at java.lang.ClassLoader.loadClassInternal(Unknown Source)
      at java.lang.Class.forName0(Native Method)
      at java.lang.Class.forName(Unknown Source)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getDriver(LocalManagedConnectionFactory.java:474)
      ... 35 more
13:54:40,308 ERROR [STDERR] org.jboss.util.NestedSQLException: Unable to get managed connection for SqlServerDS; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for SqlServerDS)
13:54:40,308 ERROR [STDERR]       at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
13:54:40,308 ERROR [STDERR]       at web.FindDeal.getSearchDeals(FindDeal.java:170)
13:54:40,308 ERROR [STDERR]       at web.FindDeal.doGet(FindDeal.java:72)
13:54:40,308 ERROR [STDERR]       at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
13:54:40,308 ERROR [STDERR]       at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
13:54:40,308 ERROR [STDERR]       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
13:54:40,308 ERROR [STDERR]       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
13:54:40,308 ERROR [STDERR]       at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
13:54:40,308 ERROR [STDERR]       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
13:54:40,308 ERROR [STDERR]       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
13:54:40,308 ERROR [STDERR]       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
13:54:40,308 ERROR [STDERR]       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
13:54:40,308 ERROR [STDERR]       at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
13:54:40,308 ERROR [STDERR]       at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
13:54:40,308 ERROR [STDERR]       at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
13:54:40,308 ERROR [STDERR]       at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
13:54:40,308 ERROR [STDERR]       at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
13:54:40,339 ERROR [STDERR]       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
13:54:40,339 ERROR [STDERR]       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
13:54:40,339 ERROR [STDERR]       at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
13:54:40,339 ERROR [STDERR]       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
13:54:40,339 ERROR [STDERR]       at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
13:54:40,339 ERROR [STDERR]       at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
13:54:40,339 ERROR [STDERR]       at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
13:54:40,339 ERROR [STDERR]       at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
13:54:40,339 ERROR [STDERR]       at java.lang.Thread.run(Unknown Source)
13:54:40,339 ERROR [STDERR] Caused by: javax.resource.ResourceException: Unable to get managed connection for SqlServerDS
13:54:40,339 ERROR [STDERR]       at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:441)
13:54:40,339 ERROR [STDERR]       at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)
13:54:40,339 ERROR [STDERR]       at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
13:54:40,339 ERROR [STDERR]       at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
13:54:40,339 ERROR [STDERR]       at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
13:54:40,339 ERROR [STDERR]       ... 25 more
13:54:40,339 ERROR [STDERR] Caused by: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: com.microsoft.sqlserver.jdbc.SQLServerDriver; - nested throwable: (java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver))
13:54:40,339 ERROR [STDERR]       at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:225)
13:54:40,339 ERROR [STDERR]       at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:195)
13:54:40,339 ERROR [STDERR]       at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:633)
13:54:40,339 ERROR [STDERR]       at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:267)
13:54:40,339 ERROR [STDERR]       at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:622)
13:54:40,339 ERROR [STDERR]       at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
13:54:40,339 ERROR [STDERR]       ... 29 more
13:54:40,339 ERROR [STDERR] Caused by: org.jboss.resource.JBossResourceException: Failed to register driver for: com.microsoft.sqlserver.jdbc.SQLServerDriver; - nested throwable: (java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver)
13:54:40,339 ERROR [STDERR]       at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getDriver(LocalManagedConnectionFactory.java:489)
13:54:40,339 ERROR [STDERR]       at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:206)
13:54:40,339 ERROR [STDERR]       ... 34 more
13:54:40,339 ERROR [STDERR] Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
13:54:40,339 ERROR [STDERR]       at java.net.URLClassLoader$1.run(Unknown Source)
13:54:40,339 ERROR [STDERR]       at java.security.AccessController.doPrivileged(Native Method)
13:54:40,339 ERROR [STDERR]       at java.net.URLClassLoader.findClass(Unknown Source)
13:54:40,339 ERROR [STDERR]       at java.lang.ClassLoader.loadClass(Unknown Source)
13:54:40,339 ERROR [STDERR]       at java.lang.ClassLoader.loadClass(Unknown Source)
13:54:40,339 ERROR [STDERR]       at java.lang.ClassLoader.loadClassInternal(Unknown Source)
13:54:40,339 ERROR [STDERR]       at java.lang.Class.forName0(Native Method)
13:54:40,339 ERROR [STDERR]       at java.lang.Class.forName(Unknown Source)
13:54:40,339 ERROR [STDERR]       at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getDriver(LocalManagedConnectionFactory.java:474)
13:54:40,339 ERROR [STDERR]       ... 35 more
13:54:40,339 ERROR [STDERR] Debug: Got an exception! org.jboss.util.NestedSQLException: Unable to get managed connection for SqlServerDS; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for SqlServerDS)
13:54:40,652 ERROR [STDERR] Debug: result.jsp :: dealresult=null
13:54:40,652 ERROR [STDERR] java.lang.NullPointerException
13:54:40,652 ERROR [STDERR]       at web.FindDeal.doGet(FindDeal.java:102)
13:54:40,652 ERROR [STDERR]       at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
13:54:40,652 ERROR [STDERR]       at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
13:54:40,652 ERROR [STDERR]       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
13:54:40,652 ERROR [STDERR]       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
13:54:40,652 ERROR [STDERR]       at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
13:54:40,652 ERROR [STDERR]       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
13:54:40,652 ERROR [STDERR]       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
13:54:40,652 ERROR [STDERR]       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
13:54:40,652 ERROR [STDERR]       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
13:54:40,652 ERROR [STDERR]       at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
13:54:40,652 ERROR [STDERR]       at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
13:54:40,652 ERROR [STDERR]       at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
13:54:40,652 ERROR [STDERR]       at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
13:54:40,652 ERROR [STDERR]       at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
13:54:40,652 ERROR [STDERR]       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
13:54:40,652 ERROR [STDERR]       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
13:54:40,652 ERROR [STDERR]       at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
13:54:40,652 ERROR [STDERR]       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
13:54:40,652 ERROR [STDERR]       at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
13:54:40,652 ERROR [STDERR]       at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
13:54:40,652 ERROR [STDERR]       at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
13:54:40,652 ERROR [STDERR]       at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
13:54:40,652 ERROR [STDERR]       at java.lang.Thread.run(Unknown Source)
13:54:40,652 ERROR [STDERR] Debug: Cannot forward after response has been committedjava.lang.IllegalStateException: Cannot forward after response has been committed

Make sure you're using the correct driver version *for JBoss*

you're using the wrong jar.
see my earlier comments about which jar to use with which version of java

I am using sqljdbc4.jar?

yes, thats for java 6. you're using java 5

Hi

Checked everything and found my Connection Successful log in from the test class. Question now why does the application side not work

jdbc:sqlserver://servername\name:5001;databaseName=DBNAME;selectMethod=cursor;
Connection Successful!
Driver Information
      Driver Name: Microsoft SQL Server JDBC Driver 3.0
      Driver Version: 3.0.1301.101

Database Information
      Database Name: Microsoft SQL Server
      Database Version: 9.00.4053

because you're using the wrong jar :)

ok

I have 2 jars in C:\Program Files\Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu

sqljdbc4.jar
sqljdbc.jar

I am using sqljdbc4.jar

I have also placed that jar in C:\jboss-5.1.0.GA\server\default\lib


What am I missing

Please advise
THanks
Anthonio

you need to remove sqljdbc4.jar, and replace it with sqljdbc.jar

Do i need to place that jar in the C:\jboss-5.1.0.GA\server\default\lib folder or the C:\Program Files\Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu

Thanks
Anthonio

Thank you very much fro the assistance it working 100 %

Excellent !!!!!!!!!!!!!1

:-)