DB configuration details

[Former Member]

Based on the below thread I am working on a JDBC Scenario.

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

The database I am using is a freeware. Now what are all the configuration details needed to fill my JDBC adapter, how to get that from my DB

Thanks.

[Former Member]

Hi Jenin,

The below is the exmaple of MS-Sql similarly u can configure with ur freeware database <go to their site>

Must see

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

After you install the driver you use the Sender or Reciver JDBC adapter to connect to the database.

The parameters in the JDBC adapter,

If you have already deployed the drivers (msbase.jar, mssqlserver.jar, msutil.jar).

Driver:

com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection for MS SQL Server:

jdbc:microsoft:sqlserver://<server>:1433;databaseName=<dbname>

If you are using the new SQL Server 2005 jdbc driver (sqljdbc.jar). Setup is basically the same, except the driver is now:

com.microsoft.sqlserver.jdbc.SQLServerDriver

And the URL is slightly different as well:

jdbc:sqlserver://host:1433;DatabaseName=name

<b>

***reward points if helpful

</b><a href="/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30:///people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Message was edited by:

Ajay Kumar

[Former Member]

You can get the JDBC driver and the connection URL from the DB manufacturer site. For example if you have MS-SQL DB you can get the drivers from microsoft official website.

Reagards,

Jai Shankar