Configuration Guide › Relational Database Management › How To Create a JDBC Data Source › Create a JDBC Data Source for WebLogic

Create a JDBC Data Source for WebLogic

You create a data source in the WebLogic Administration Console.

Note: See the Oracle WebLogic 11 Documentation for complete information about Weblogic Connection Pools.

Follow these steps:

1. Create a JDBC Data Source with the following parameters in the WebLogic Administration Console:

   Name: User Store Data Source

   JNDI Name: userstore

2. Create the connection pool for the data source with the following information:
   • For SQL Server 2005 databases, use the following values:

     URL: jdbc:sqlserver://db_systemName:1433

     Driver Class Name: com.microsoft.sqlserver.jdbc.SQLServerDriver

     Properties: user=username

                       databaseName=user store name

                       selectMethod=cursor

     Password: password

   • For Oracle databases, use the following values:

     URL: jdbc:oracle:thin:@tp_db_systemname:1521:oracle_SID

     Driver Class Name: oracle.jdbc.driver.OracleDriver

     Properties: user=username

     Password: password

3. After configuration, set the target for the pool to the server instance wl_server_name.

   After you deploy the pool, check the console to see if any errors occurred.

   Note: You may see an error that says the data source cannot be created with a non-existent pool. To resolve this error, restart WebLogic.