Creating a DataSource in WebLogic Using WLST

By -
Creating JDBC DataSources in WebLogic Server using WLST (WebLogic Scripting Tool),including authentication, connection pool configuration, and deployment targets.

Prerequisites:

WebLogic Server installed
JDBC driver JAR available (e.g., ojdbc8.jar for Oracle)
Admin credentials and server URL

Basic WLST DataSource Creation Script:

Save as create_datasource.py:

# Connect to Admin Server
connect('weblogic', 'welcome1', 't3://localhost:7001
edit()
startEdit()

# Create JDBC DataSource
cd('/')
cmo.createJDBCSystemResource('MyDS')
cd('/JDBCSystemResources/MyDS/JDBCResource/MyDS')
cmo.setName('MyDS')

# JDBC DataSource Parameters
cd('/JDBCSystemResources/MyDS/JDBCResource/MyDS/JDBCDataSourceParams/MyDS')
cmo.setJNDINames(['jdbc/MyDS'])  # JNDI Name
cmo.setGlobalTransactionsProtocol('TwoPhaseCommit')  # For XA transactions

#JDBC Driver Properties
cd('/JDBCSystemResources/MyDS/JDBCResource/MyDS/JDBCDriverParams/MyDS')
cmo.setUrl('jdbc:oracle:thin:@//localhost:1521/ORCLPDB1')
cmo.setDriverName('oracle.jdbc.OracleDriver')
cmo.setPassword('db_password')

cd('/JDBCSystemResources/MyDS/JDBCResource/MyDS/JDBCDriverParams/MyDS/Properties/MyDS')
cmo.createProperty('user')
cd('/JDBCSystemResources/MyDS/JDBCResource/MyDS/JDBCDriverParams/MyDS/Properties/MyDS/Properties/user')
cmo.setValue('db_user')

# Connection Pool Settings

cd('/JDBCSystemResources/MyDS/JDBCResource/MyDS/JDBCConnectionPoolParams/MyDS')cmo.setInitialCapacity(5)       # Initial connections
cmo.setMaxCapacity(20)          # Max connections
cmo.setMinCapacity(5)           # Min connections
cmo.setStatementCacheSize(100)  # Cached statements

# Deploy to Target Server(s
cd('/JDBCSystemResources/MyDS')
targets = ObjectName('com.bea:Name=AdminServer,Type=Server')
set('Targets',jarray.array([targets], ObjectName))

save()
activate()
disconnect()
exit()

Running the Script

Execute via WLST:

$WL_HOME/common/bin/wlst.sh create_datasource.py

Advanced Configurations

Adding Connection Testing

cd('/JDBCSystemResources/MyDS/JDBCResource/MyDS/JDBCConnectionPoolParams/MyDS')

cmo.setTestConnectionsOnReserve(true)

cmo.setTestTableName('SQL SELECT 1 FROM DUAL')  # Oracle test query


Comments

Post a Comment

Popular posts from this blog

Interview question for File and FTP Adapter

By -
1)  Why File Adapter is used in SOA Suite tool ?.  File adapter is used to read and write file from and to local system. 2)  Why FTP Adapter is used in SOA Suite tool ?. FTP adapter is similar to File adapter with one difference that this adapter is used to read/write the file from/to remote system. 3)  What all differences we have between File and FTP adapters.  Following are the major differences between File and FTP adapter. File Adapter 1. It is used to deal with local systems only. 2. Do not require any configuration to make this adapter work. FTP Adapter 1. It is used to deal with remote systems. 2. Outbound Connection Pool needs to be configured with FTP details to make this adapter work. 4)  File & FTP adapters are known and Transactional or Non-Transactional adapters?.  These adapters are known as non-transactional adapters as these adapters does not support transactions. 5)  Can we read flat files using these adapter...
Read more

What is boot.properties file and how to create

By -
Boot.properties is a file, it containing  weblogic server username and password . If your server is in production mode then only you have to create manually this boot.properties file. If your server is in Development then you no need to create this file because server it self create this file while creating Domain. A boot identity file contains the user credentials for starting and stopping an instance of WebLogic Server. An administration server or managed server can refer to this file for user credentials instead of prompting at the command line to provide them. To Create boot.properties: Go to below location Win :   C:\Oracle\Middleware\user_projects\domains\test_domain\servers\AdminServer\ Linux : Oracle\Middleware\user_projects\domains\test_domain\servers\AdminServer\ 1.First you have to create security folder under AdminServer 2.Create boot.properties file under security folder. 3.Open notepad and write the below two lines username=********** password=*****...
Read more

SSL Exceptions in Admin Server and Node Manager.

By -
javax.net.ssl.SSLKeyException: [Security:090482]BAD_CERTIFICATE alert was received from oracle.test.com – xx.xxx.xx.xx. Check the peer to determine why it rejected the certificate chain (trusted CA configuration, hostname verification). SSL debug tracing may be required to determine the exact reason the certificate was rejected. <WARNING> <Uncaught exception in server handlerjavax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake>javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake at com.sun.net.ssl.internal.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:849) at com.sun.net.ssl.internal.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1170) The above exceptions are  the most common exceptions encountered during the setup of Weblogic Server in an environment. The stack does suggest what could be the reasons but the diagnostics are not mentioned. To debug this issue, first we need...
Read more