datasource Archives - Middleware Wonders

6 April 2017 weblogicwonders

Issue while creating datasource on Weblogic Server

In Weblogic Sometimes when you try add datasource to cluster group it fails with following error, which might be due

24 December 2013 weblogicwonders

WLST Script to start and stop Datasource

Script to start Datasource connect('weblogic','weblogic123','t3://localhost:7001') domainRuntime() cd('ServerRuntimes/AdminServer/JDBCServiceRuntime/AdminServer/JDBCDataSourceRuntimeMBeans/PegaRULES') objArray = jarray.array([], java.lang.Object) strArray = jarray.array([], java.lang.String) invoke('start', objArray, strArray) exit()

23 December 2010 weblogicwonders

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 1rnrn’) cd(‘/JDBCSystemResources/PegaRULES/JDBCResource/PegaRULES/JDBCDriverParams/PegaRULES/Properties/PegaRULES’) cmo.createProperty(‘user’)