Resolution:
Description:
============
While the BusinessConnect (BC) server is starting up, it is unable to get a db connection to the URL . For example, the following error is displayed:

" java.sql.SQLException: Cannot get db connection for url: jdbc:sqlserver://APPVS104\APPIN104:2141;databaseName=TibcoBusinessConnect"

Environment:
==========
Applicable to all environments.

Symptoms:
=========
BC fails to get the db connection and throws the following: "cannot get db connection for the url".  

Cause:
=====
This issue is caused by the parameters in the URL not being valid.

Resolution:
=========
Please check the db paramenters such as the hostname , db username , password and  service name.  In some specific cases, the host name can not be resolved. Make sure that the full qualified name of the host is mentioned in the db URL or use the IP address.

For example, this DB URL:

jdbc:oracle:thin:@localhost:1521:orcl . In the URL, the host name is localhost when it should be the fully qualified domain name (FQDN) or the database server, such as a.b.c.com.

This JDBC URL should be set in two places in the Administrator:

1). Business Connect - > Manage installation.
2). Business connect -> System Settings -> JDBC configuration.

BusinessConnect cannot get a database connection for a given URL.