RE: Websphere compatibility

I'm having a devil of a time getting the most currt MS JDBC driver configured
in a working WebSphere data source. The JDBC URL that normally connects is

jdbc:sqlserver://localhost:2005;databaseName=abtest;user=sa;password=***

I am runngin SQL Server 2005 as a named instance with a static port, 2005.

No matter what I try, I get

[3/27/08 14:14:06:813 PDT] 00000021 DataSourceCon E DSRA8040I: Failed to
connect to the DataSource. Encountered "": java.sql.SQLException: The TCP/IP
connection to the host has failed. java.net.ConnectException: Connection
refused: connectDSRA0010E: SQL State = 08S01, Error Code = 0

It worries me a bit that this page,
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/topic/com.ibm.websphere.base.doc/info/aes/ae/rdat_minreq.html,
doesn't show the MS driver. It finally does get mentioned on
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/topic/com.ibm.websphere.base.doc/info/aes/ae/rdat_minreqmssql.html, but on that page it says

The JDBC provider requires the following DataStoreHelper class:
com.ibm.websphere.rsadapter.MicrosoftSQLServerDataStoreHelper

which I tried specifying, but it couldn't find, so I am using instead
com.ibm.websphere.rsadapter.GenericDataStoreHelper.

I am using om.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource as
the JDBC Provider Implementation class name. I have tried various
combinations of connection pool custom properties, including databaseName,
portNumber, and serverName. I have also tried setting a custom poroperty of
URL set to dbc:sqlserver://tonava:2005, or leaving the port off.

Here's the stack trace:

[3/27/08 14:34:51:516 PDT] 0000002a ResourceMgrIm I WSVR0049I: Binding
ab405sql as jdbc/tonavasqlserver
[3/27/08 14:34:51:516 PDT] 0000002a DSConfigurati W DSRA0174W: Warning:
GenericDataStoreHelper is being used.
[3/27/08 14:34:52:547 PDT] 0000002a DSConfigurati W DSRA8201W: DataSource
Configuration: DSRA8040I: Failed to connect to the DataSource. Encountered
java.sql.SQLException: The TCP/IP connection to the host has failed.
java.net.ConnectException: Connection refused: connectDSRA0010E: SQL State =
08S01, Error Code = 0.
java.sql.SQLException: The TCP/IP connection to the host has failed.
java.net.ConnectException: Connection refused: connectDSRA0010E: SQL State =
08S01, Error Code = 0
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerDataSource.getConnectionInternal(Unknown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPooledConnection.createNewConnection(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPooledConnection.<init>(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource.getPooledConnection(Unknown Source)
at
com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.java:1161)


Maybe I need to go find the MicrosoftSQLServerDataStoreHelper class, and get
it in the classpath.
.

Relevant Pages

  • Re: looking for opinons regarding best practices (jdbc, resultsets, and servlet design)
    ... (switching from JDBC to JNDI or a Web service, ... of data entity value objects around without keeping a connection open. ... back non-Cached RowSets or ResultSets requires an active connection. ... In real life one would likely want to log this exception. ...
    (comp.lang.java.programmer)
  • [Info-Ingres] jdbc connection problem
    ... I'm struggeling with a JDBC connection string and could use some ... The java client is running on the same host as a JDBC server. ...
    (comp.databases.ingres)
  • Re: Unblocking items in firewall - Symantec AntiVirus Corporate Edition
    ... > I sell a server based software product. ... > Symantec AntiVirus Corporate Edition product but one of my customers ... It will not block connection attempts. ... Is my JDBC connection code incorrect? ...
    (comp.security.firewalls)
  • SPWDCSM and JDBC clients
    ... Jerry K. mentioned the Data studio download a week or so ago. ... IBM Data Studio v1.1, IDS 11.1FC1, Informix JDBC driver (one with data ... I did try a .rhost entry for the client host on the server host. ... Removing the csm entry allows the connection to work. ...
    (comp.databases.informix)
  • RE: Connection.TRANSACTION_SERIALIZABLE
    ... I'm not seeing a JDBC section on here. ... Using non Microsoft JDBC connectiong ... > | Connection.TRANSACTION_SERIALIZABLE to our SQL Server. ... > | connection setting interact with the code it touches? ...
    (microsoft.public.sqlserver.odbc)
Loading