HOME > > How to change the datasource type (e.g., from Generic to GridLink or XA) using the WLST (WebLogic Scripting Tool)

How to change the datasource type (e.g., from Generic to GridLink or XA) using the WLST (WebLogic Scripting Tool)

Anup - Thursday, February 20, 2025

In WebLogic, we can change the datasource type (e.g., from Generic to GridLink or XA) using the WLST (WebLogic Scripting Tool)

Step 1: Set the environment

export ORACLE_BASE=/Middleware/oracle

export DOMAIN_NAME=uatdomain

export DOMAIN_HOME=$ORACLE_BASE/config/domains/$DOMAIN_NAME
export WL_HOME=/Middleware/oracle/product/fmw/wlserver 

cd $WL_HOME/common/bin 


$ $WL_HOME/common/bin/wlst.sh


connect('weblogic', 'password', 't3://IP:PORP')

Step 2: Update the DataSource

Note: Change Yello highlighted Data Source Name as per your environment

edit()

startEdit()

cd ('/JDBCSystemResources/LocalSvcTblDataSource/JDBCResource/LocalSvcTblDataSource')

set('DatasourceType', 'AGL')

save()

activate()

exit()


3. Restart WebLogic (If Needed)



Contact me

Get in Touch

Need to get touch with me? Please fill out the form with your enquiry.

Name
Anup Srivastav
Address
Lucknow - Utter Pradesh
Email
myindiandba@gmail.com
Message me