Skip to content

Creating Datasource using WLST

connect(‘weblogic’,'weblogic’,'t3://localhost:7001′)
edit()
startEdit()
cd(‘/’)
cmo.createJDBCSystemResource(‘PegaRULES’)
cd(‘/JDBCSystemResources/PegaRULES/JDBCResource/PegaRULES’)
cmo.setName(‘PegaRULES’)
cd(‘/JDBCSystemResources/PegaRULES/JDBCResource/PegaRULES/JDBCDataSourceParams/PegaRULES’)
set(‘JNDINames’,jarray.array([String('jdbc/PegaRULES')], String))
cd(‘/JDBCSystemResources/PegaRULES/JDBCResource/PegaRULES/JDBCDriverParams/PegaRULES’)
cmo.setUrl(‘jdbc:sqlserver://localhost:1433′)
cmo.setDriverName(‘com.microsoft.sqlserver.jdbc.SQLServerDriver’)
cmo.setPassword(‘pega612′)
cd(‘/JDBCSystemResources/PegaRULES/JDBCResource/PegaRULES/JDBCConnectionPoolParams/PegaRULES’)
cmo.setTestTableName(‘SQL SELECT 1\r\n\r\n’)
cd(‘/JDBCSystemResources/PegaRULES/JDBCResource/PegaRULES/JDBCDriverParams/PegaRULES/Properties/PegaRULES’)
cmo.createProperty(‘user’)
cd(‘/JDBCSystemResources/PegaRULES/JDBCResource/PegaRULES/JDBCDriverParams/PegaRULES/Properties/PegaRULES/Properties/user’)
cmo.setValue(‘pega612′)
cd(‘/JDBCSystemResources/PegaRULES/JDBCResource/PegaRULES/JDBCDriverParams/PegaRULES/Properties/PegaRULES’)
cmo.createProperty(‘databaseName’)
cd(‘/JDBCSystemResources/PegaRULES/JDBCResource/PegaRULES/JDBCDriverParams/PegaRULES/Properties/PegaRULES/Properties/databaseName’)
cmo.setValue(‘prpc612′)
cd(‘/JDBCSystemResources/PegaRULES/JDBCResource/PegaRULES/JDBCDataSourceParams/PegaRULES’)
cmo.setGlobalTransactionsProtocol(‘OnePhaseCommit’)
cd(‘/SystemResources/PegaRULES’)
set(‘Targets’,jarray.array([ObjectName('com.bea:Name=AdminServer,Type=Server')], ObjectName))
activate()
dumpStack()
exit()

3 Comments

  1. Administrator

    This post is in response to the query asked in Oracle Forums

    http://forums.oracle.com/forums/thread.jspa?threadID=2149148&tstart=0

    Posted on 23-Dec-10 at 1:30 am | Permalink
  2. Senthil Kumar

    Hi,

    I am new to OBIEE and trying to create JDBC DS using wlst but none of my efforts are succeed. Can you please provide step by step comments so i can alter your code with my settings.

    thanks in advance, looking for your update.

    Posted on 01-Oct-12 at 7:34 am | Permalink
  3. Administrator

    Hi Senthu,

    The same steps should work.
    I am not aware of OBIEE.

    Thanks,
    Faisal

    Posted on 04-Nov-12 at 1:40 pm | Permalink

Post a Comment

Your email is never published nor shared.