Creating the JDBC data source using WLST

  1. Log in as a wls user to shell and start WLST:
    [wls@prod01]$ $WL_HOME/common/bin/wlst.sh
  2. Connect to the Administration Server using wlsadmin as the user, <pwd> as the password, and t3://adminhost.domain.local:7001 as the server URL:
    wls:/offline> connect("wlsadmin","<pwd>","t3://adminhost.domain.local:7001")
  3. Run the following WLST commands to create the data source:
    edit()
    startEdit()

    cd('/')
    cmo.createJDBCSystemResource('ds-nonXA')
    cd('/JDBCSystemResources/ds-nonXA/JDBCResource/ds-nonXA')
    cmo.setName('ds-nonXA')
    cd('/JDBCSystemResources/ds-nonXA/JDBCResource/ds-nonXA/JDBCDataSourceParams/ds-nonXA')
    set('JNDINames',jarray.array([String('jdbc/ds-nonXA')], String))
    cd('/JDBCSystemResources/ds-nonXA/JDBCResource/ds-nonXA/JDBCDriverParams/ds-nonXA')
    cmo.setUrl('jdbc:oracle:thin:@dbhost:1521/dbservice')
    cmo.setDriverName('oracle.jdbc.OracleDriver')
    cmo.setPassword('dbpwd')
    cd('/JDBCSystemResources/ds-nonXA/JDBCResource/ds-nonXA/JDBCConnectionPoolParams/ds-nonXA')
    cmo.setTestTableName('SQL SELECT 1 FROM DUAL\r\n')
    cd('/JDBCSystemResources/ds-nonXA/JDBCResource/ds-nonXA/JDBCDriverParams/ds-nonXA/Properties/ds-nonXA')
    cmo.createProperty('user')
    cd('/JDBCSystemResources/ds-nonXA/JDBCResource/ds-nonXA/JDBCDriverParams/ds-nonXA/Properties/ds-nonXA/Properties/user')
    cmo.setValue('dbuser')
    cd('/JDBCSystemResources/ds-nonXA/JDBCResource/ds-nonXA/JDBCDataSourceParams/ds-nonXA')
    cmo.setGlobalTransactionsProtocol('OnePhaseCommit')
    cd('/JDBCSystemResources/ds-nonXA')
    set('Targets',jarray.array([ObjectName('com.bea:Name=PROD_Cluster,Type=Cluster')], ObjectName))activate()
    exit()

0 Comments