IamWeblogicAdmin/Naveen: WLST - Datasource using wlst and property file

1: Create a Directory somewhere in your file system like: “C:WLST_DS_Creation” and place a properties file like below in this directory with name “details.properties”

domain.name=7001_Domain

admin.url=t3://localhost:7001

admin.userName=weblogic

admin.password=weblogic

datasource.name=DS_One

datasource.database.name=demo

datasource.target=AdminServer

datasource.filename=DS_One.xml

datasource.jndiname=DS_One_JNDI

datasource.driver.class=com.pointbase.jdbc.jdbcUniversalDriver

datasource.url=jdbc:pointbase:server://localhost:9092/demo

datasource.username=PBPUBLIC

datasource.password=PBPUBLIC

datasource.test.query=SQL SELECT * FROM DUAL

2: Now in the same directory write the following WLST Script “createDataSource.py” like following:

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

`from` `java.io` `import` `FileInputStream`

`propInputStream` `=` `FileInputStream("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()`

3: Now Open a Command/Shell Prompt and then run the “setWLSEnv.sh” script to set the CLASSPATH and PATH environment variables. Run the “. ./setWLSEnv.sh” by adding two DOTs separated by a single space …..before the actual script like following : (use ‘cd’ command to move inside the <BEA_HOME>/wlserver_10.3/server/bin) then run the following command….

. ./setWLSEnv.sh

Note: Here The first DOT represents that set the Environment in the current Shell, AND the second ./ represents execute the script from the current directory.

IamWeblogicAdmin/Naveen

Tuesday, 20 December 2016

WLST - Datasource using wlst and property file

1: Create a Directory somewhere in your file system like: “C:WLST_DS_Creation” and place a properties file like below in this directory with name “details.properties”

. ./setWLSEnv.sh

Note: Here The first DOT represents that set the Environment in the current Shell, AND the second ./ represents execute the script from the current directory.

4: Run the Above WLST Script like following:

java weblogic.WLST createDataSource.py

Make sure that the Database is running while you are creating the DataSource.

source : middlewaremagic.com

1 comment: