Previous Topic Next topic Print topic


Sample DataSource Object Files

These sample DataSource object files represent connection properties for three typical data source connections:

DB2 with DB2-Express
File name: DB2.properties
    type=javax.sql.DataSource
    driver=com.ibm.db2.jcc.DB2Driver
    url=jdbc:db2://localhost:50000/sample:retrieveMessagesFromServerOnGetMessage=true;
    user=userName
    password=password
MSSQL with SQL Server Express
File name: MSSQL.properties

For Windows environments with Windows authentication using NTLM:

    type=javax.sql.DataSource
    driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
    url=jdbc:sqlserver://localhost\SQLEXPRESS;database=Northwind;integratedSecurity=true;
    user=
    password=

For all platforms using SQL Server authentication:

    type=javax.sql.DataSource
    driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
    url=jdbc:sqlserver://remotehost\SQLEXPRESS;database=Northwind;integratedSecurity=true;
    user=userName
    password=password
Oracle
File name: ORA.properties
    type=javax.sql.DataSource
    driver=oracle.jdbc.driver.OracleDriver
    url=jdbc:oracle:thin:@localhost:1521/ORCL
    user=userName
    password=password
Previous Topic Next topic Print topic