IBM Support

Can't connect to external pool with JTDS driver and an SQL Server 2005 named instance.

Troubleshooting


Problem

Can't connect to external pool with JTDS driver and an SQL Server 2005 named instance.

Symptom

GIS 4.2 - Windows
SQL Server 2005 external pool

Installed JTDS driver and is located in classpath correctly.

The connection URL for a jtds driver is of the form:

jdbc:jtds:<server_type>://<server>[:<port>][/<database>][;<property>=<value>[ ;...]]

using instance as a property. So in the jdbc_customer.properties, we have:

MYPOOL.url=jdbc:jtds:sqlserver://MYPOOL:1433/MyData;instance=SQL2005.c ompany.com

This fails.

Error Message

This url does not connect successfully and returns an error in the system.log:

[2008-03-05 09:04:28.262] ERROR 000310160001 UTIL.FRAME_POOL.ERR_Pool [Pool] Could not create the initial objects for the pool {0.EN}
com.sterlingcommerce.woodstock.util.frame.pool.CreateException: The driver manager could not obtain a database connection.

[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

TRB2468

Document Information

More support for:
IBM Sterling B2B Integrator

Software version:
All

Document number:
192913

Modified date:
16 June 2018

UID

swg21561196

Manage My Notification Subscriptions

Page Feedback