Automation of Datasource creation using WLST is working in DIT environment .




Please find the steps below …

1. Create a folder wlst_ds
2. Create a py file ...createDataSource.py
3.vi createDataSource.py
from java.io import FileInputStream


propInputStream = FileInputStream("/home/soadev03/wlst_tocreate_DS/details.properties")

configProps = Properties()

configProps.load(propInputStream)



domainName=configProps.get("domain.name")

adminURL=configProps.get("admin.url")

adminUserName=configProps.get("admin.userName")

adminPassword=configProps.get("admin.password")



dsName=configProps.get("datasource.name")

dsFileName=configProps.get("datasource.filename")

dsDatabaseName=configProps.get("datasource.database.name")

datasourceTarget=configProps.get("datasource.target")

dsJNDIName=configProps.get("datasource.jndiname")

dsDriverName=configProps.get("datasource.driver.class")

dsURL=configProps.get("datasource.url")

dsUserName=configProps.get("datasource.username")

dsPassword=configProps.get("datasource.password")

dsTestQuery=configProps.get("datasource.test.query")



connect(adminUserName, adminPassword, adminURL)

edit()

startEdit()

cd('/')

cmo.createJDBCSystemResource(dsName)

cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName)

cmo.setName(dsName)



cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDataSourceParams/' + dsName )

set('JNDINames',jarray.array([String('jdbc/' + dsName )], String))



cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDriverParams/' + dsName )

cmo.setUrl(dsURL)

cmo.setDriverName( dsDriverName )

cmo.setPassword(dsPassword)



cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCConnectionPoolParams/' + dsName )

cmo.setTestTableName(dsTestQuery)

cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDriverParams/' + dsName + '/Properties/' + dsName )

cmo.createProperty('user')



cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDriverParams/' + dsName + '/Properties/' + dsName + '/Properties/user')

cmo.setValue(dsUserName)



cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDriverParams/' + dsName + '/Properties/' + dsName )

cmo.createProperty('databaseName')



cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDriverParams/' + dsName + '/Properties/' + dsName + '/Properties/databaseName')

cmo.setValue(dsDatabaseName)



cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDataSourceParams/' + dsName )

cmo.setGlobalTransactionsProtocol('OnePhaseCommit')



cd('/SystemResources/' + dsName )

set('Targets',jarray.array([ObjectName('com.bea:Name=' + datasourceTarget + ',Type=Server')], ObjectName))



save()

activate()

4. create the propoery file
domain.name=soa_dev03_Domain


admin.url=t3s://lx550:25905

admin.userName=weblogic

admin.password=Trulsr0k

datasource.name=DS_One

datasource.database.name=

datasource.target=AdminServer

datasource.filename=

datasource.jndiname=

datasource.driver.class=

datasource.url=

datasource.username=

datasource.password=



datasource.test.query=SQL SELECT * FROM DUAL

5 .

[soast01@ngmlx476 bin]$ export CLASSPATH=/var/domain/soa_st01/WEBLOGIC_HOME/server/lib/weblogic.jar

6.
[soast01@lx476 bin]$ java -Dweblogic.security.SSL.ignoreHostnameVerification=true -Dweblogic.security.TrustKeyStore=CustomTrust -Dweblogic.security.CustomTrustKeyStoreFileName=/var/domain/soa_st01/keystore/WebLogicTrustKeyStore.jks -Dweblogic.security.CustomTrustKeyStorePassPhrase=wpd -Dweblogic.security.CustomTrustKeyStoreType=JKS -Dweblogic.security.SSL.allowSmallRSAExponent=true weblogic.WLST /home/soast01/wlst_tocreate_DS/createDataSource.py



Initializing WebLogic Scripting Tool (WLST) ...



Welcome to WebLogic Server Administration Scripting Shell



Type help() for help on available commands



Connecting to t3s://x476:25909 with userid weblogic ...

<15-mar-2013 15:55:05="" clock="" gmt="" o="">

<15-mar-2013 15:55:05="" clock="" gmt="" o="">

Successfully connected to Admin Server 'soa_st01_AdminServer01' that belongs to domain 'soa_st01_Domain'.



Location changed to edit tree. This is a writable tree with

DomainMBean as the root. To make changes you will need to start

an edit session via startEdit().



For more help, use help(edit)



Starting an edit session ...

Started edit session, please be sure to save and activate your

changes once you are done.

Saving all your changes ...

Saved all your changes successfully.

Activating all your changes, this may take a while ...

The edit lock associated with this edit session is released

once the activation is completed.

Activation completed


7. check the data source from the console ..