Skip to Content
avatar image
Former Member

SQLEr.ResourceException

I have deployed [MS-SQL jdbc 2.0|http://www.google.co.in/url?sa=t&source=web&ct=res&cd=1&url=http%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Fdata%2Faa937724.aspx&ei=tvFSStj7NpPq6AOslOXJBw&usg=AFQjCNHRgg02jfuW0RdXraaQlMZAESLlUw&sig2=0xgTb5ZPGL_wpVxNdwAZuQ] driver.

But the data source up on the same driver shows an exception on a simple select query.

SQLEr.ResourceException occurred in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection: com.microsoft.sqlserver.jdbc.SQLServerException: The server version is not supported. The target server must be SQL Server 2000 or later

Environment:

NetWeaver: NW 7.1 SR 5

SQL Server: MS-SQL 2008

Driver: JDBC 2.0 (supports SQL 2003, SQL 2005, SQL 2008)

JEE: 1.5

Please help me to resolve this issue.

Nikhil

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 07, 2009 at 11:20 AM

    Hi,

    Check the below thread

    sql-server-version-is-not-supported

    Regards,

    Saleem

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 07, 2009 at 10:53 AM

    Hi,

    Check this below thread and the correct driver you are using.

    connect-to-sql-server-2005-in-web-dynpro-java

    Regards,

    Charan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 07, 2009 at 02:49 PM

    Now I am getting another exception!!!!!

    SQLEr.ResourceException occurred in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection timed out

    Max. Time to wait for Connection: 6000 sec

    Connection Lifetime: 6000 sec.

    Clean up Interval: 5000 sec.

    I have network delay to reach JEE server of 400 msec

    Any idea?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 16, 2009 at 10:15 AM

    Deployed sqljdbc.jar file ; dont deploy sqljdbc4.jar

    Add comment
    10|10000 characters needed characters exceeded