| # |
| # Copyright (c) 2018, 2020 Oracle and/or its affiliates. All rights reserved. |
| # |
| # This program and the accompanying materials are made available under the |
| # terms of the Eclipse Public License v. 2.0 which is available at |
| # http://www.eclipse.org/legal/epl-2.0, |
| # or the Eclipse Distribution License v. 1.0 which is available at |
| # http://www.eclipse.org/org/documents/edl-v10.php. |
| # |
| # SPDX-License-Identifier: EPL-2.0 OR BSD-3-Clause |
| # |
| |
| |
| ############################################################################ |
| # Generic script applicable on any Operating Environments (Unix, Windows) |
| # ScriptName : wls_derby_setup.py - only for Derby DB when using Network Server |
| # not for Enbedded Server |
| # Properties : weblogic.properties test.properties |
| # Author : Kevin Yuan |
| ############################################################################ |
| |
| #=========================================================================== |
| # Connect to wls server |
| #=========================================================================== |
| |
| connect('@WL_USR@','@WL_PWD@','t3://@WL_HOST@:@WL_PORT@') |
| |
| #=========================================================================== |
| # Create and configure JTA Data Source and target it to the server. |
| #=========================================================================== |
| edit() |
| startEdit() |
| |
| cd('/') |
| cmo.createJDBCSystemResource('EclipseLinkDS') |
| |
| cd('/JDBCSystemResources/EclipseLinkDS/JDBCResource/EclipseLinkDS') |
| cmo.setName('EclipseLinkDS') |
| |
| cd('/JDBCSystemResources/EclipseLinkDS/JDBCResource/EclipseLinkDS/JDBCDataSourceParams/EclipseLinkDS') |
| set('JNDINames',jarray.array([String('jdbc/EclipseLinkDS')], String)) |
| |
| cd('/JDBCSystemResources/EclipseLinkDS/JDBCResource/EclipseLinkDS/JDBCDriverParams/EclipseLinkDS') |
| cmo.setUrl('jdbc:derby://localhost:1527/ECLIPSELINK;create=true;ServerName=localhost;databaseName=ECLIPSELINK') |
| cmo.setDriverName('org.apache.derby.jdbc.ClientXADataSource') |
| set('PasswordEncrypted','@DBPWD@') |
| |
| cd('/JDBCSystemResources/EclipseLinkDS/JDBCResource/EclipseLinkDS/JDBCConnectionPoolParams/EclipseLinkDS') |
| cmo.setTestTableName('SQL SELECT 1 FROM SYS.SYSTABLES\r\n\r\n') |
| |
| cd('/JDBCSystemResources/EclipseLinkDS/JDBCResource/EclipseLinkDS/JDBCDriverParams/EclipseLinkDS/Properties/EclipseLinkDS') |
| cmo.createProperty('user') |
| |
| cd('/JDBCSystemResources/EclipseLinkDS/JDBCResource/EclipseLinkDS/JDBCDriverParams/EclipseLinkDS/Properties/EclipseLinkDS/Properties/user') |
| cmo.setValue('@DBUSR@') |
| |
| cd('/JDBCSystemResources/EclipseLinkDS/JDBCResource/EclipseLinkDS/JDBCDriverParams/EclipseLinkDS/Properties/EclipseLinkDS') |
| cmo.createProperty('portNumber') |
| |
| cd('/JDBCSystemResources/EclipseLinkDS/JDBCResource/EclipseLinkDS/JDBCDriverParams/EclipseLinkDS/Properties/EclipseLinkDS/Properties/portNumber') |
| cmo.setValue('1527') |
| |
| cd('/JDBCSystemResources/EclipseLinkDS/JDBCResource/EclipseLinkDS/JDBCDriverParams/EclipseLinkDS/Properties/EclipseLinkDS') |
| cmo.createProperty('databaseName') |
| |
| cd('/JDBCSystemResources/EclipseLinkDS/JDBCResource/EclipseLinkDS/JDBCDriverParams/EclipseLinkDS/Properties/EclipseLinkDS/Properties/databaseName') |
| cmo.setValue('ECLIPSELINK;create=true') |
| |
| cd('/JDBCSystemResources/EclipseLinkDS/JDBCResource/EclipseLinkDS/JDBCDriverParams/EclipseLinkDS/Properties/EclipseLinkDS') |
| cmo.createProperty('serverName') |
| |
| cd('/JDBCSystemResources/EclipseLinkDS/JDBCResource/EclipseLinkDS/JDBCDriverParams/EclipseLinkDS/Properties/EclipseLinkDS/Properties/serverName') |
| cmo.setValue('localhost') |
| |
| cd('/JDBCSystemResources/EclipseLinkDS/JDBCResource/EclipseLinkDS/JDBCDataSourceParams/EclipseLinkDS') |
| cmo.setGlobalTransactionsProtocol('TwoPhaseCommit') |
| |
| cd('/SystemResources/EclipseLinkDS') |
| set('Targets',jarray.array([ObjectName('com.bea:Name=@TARGET_SERVER@,Type=Server')], ObjectName)) |
| |
| save() |
| activate() |
| |
| #=========================================================================== |
| # Create and configure Non-JTA Data Source and target it to the server. |
| #=========================================================================== |
| |
| edit() |
| startEdit() |
| |
| cd('/') |
| cmo.createJDBCSystemResource('ELNonJTADS') |
| |
| cd('/JDBCSystemResources/ELNonJTADS/JDBCResource/ELNonJTADS') |
| cmo.setName('ELNonJTADS') |
| |
| cd('/JDBCSystemResources/ELNonJTADS/JDBCResource/ELNonJTADS/JDBCDataSourceParams/ELNonJTADS') |
| set('JNDINames',jarray.array([String('jdbc/ELNonJTADS')], String)) |
| |
| cd('/JDBCSystemResources/ELNonJTADS/JDBCResource/ELNonJTADS/JDBCDriverParams/ELNonJTADS') |
| cmo.setUrl('jdbc:derby://localhost:1527/ECLIPSELINK;create=true;ServerName=localhost;databaseName=ECLIPSELINK') |
| cmo.setDriverName('org.apache.derby.jdbc.ClientDataSource') |
| set('PasswordEncrypted','@DBPWD@') |
| |
| cd('/JDBCSystemResources/ELNonJTADS/JDBCResource/ELNonJTADS/JDBCConnectionPoolParams/ELNonJTADS') |
| cmo.setTestTableName('SQL SELECT 1 FROM SYS.SYSTABLES\r\n\r\n') |
| |
| cd('/JDBCSystemResources/ELNonJTADS/JDBCResource/ELNonJTADS/JDBCDriverParams/ELNonJTADS/Properties/ELNonJTADS') |
| cmo.createProperty('user') |
| |
| cd('/JDBCSystemResources/ELNonJTADS/JDBCResource/ELNonJTADS/JDBCDriverParams/ELNonJTADS/Properties/ELNonJTADS/Properties/user') |
| cmo.setValue('@DBUSR@') |
| |
| cd('/JDBCSystemResources/ELNonJTADS/JDBCResource/ELNonJTADS/JDBCDriverParams/ELNonJTADS/Properties/ELNonJTADS') |
| cmo.createProperty('portNumber') |
| |
| cd('/JDBCSystemResources/ELNonJTADS/JDBCResource/ELNonJTADS/JDBCDriverParams/ELNonJTADS/Properties/ELNonJTADS/Properties/portNumber') |
| cmo.setValue('1527') |
| |
| cd('/JDBCSystemResources/ELNonJTADS/JDBCResource/ELNonJTADS/JDBCDriverParams/ELNonJTADS/Properties/ELNonJTADS') |
| cmo.createProperty('databaseName') |
| |
| cd('/JDBCSystemResources/ELNonJTADS/JDBCResource/ELNonJTADS/JDBCDriverParams/ELNonJTADS/Properties/ELNonJTADS/Properties/databaseName') |
| cmo.setValue('ECLIPSELINK;create=true') |
| |
| cd('/JDBCSystemResources/ELNonJTADS/JDBCResource/ELNonJTADS/JDBCDriverParams/ELNonJTADS/Properties/ELNonJTADS') |
| cmo.createProperty('serverName') |
| |
| cd('/JDBCSystemResources/ELNonJTADS/JDBCResource/ELNonJTADS/JDBCDriverParams/ELNonJTADS/Properties/ELNonJTADS/Properties/serverName') |
| cmo.setValue('localhost') |
| |
| cd('/JDBCSystemResources/ELNonJTADS/JDBCResource/ELNonJTADS/JDBCDataSourceParams/ELNonJTADS') |
| cmo.setGlobalTransactionsProtocol('None') |
| |
| cd('/SystemResources/ELNonJTADS') |
| set('Targets',jarray.array([ObjectName('com.bea:Name=@TARGET_SERVER@,Type=Server')], ObjectName)) |
| |
| save() |
| activate() |
| |
| #=========================================================================== |
| # Exit WLST. |
| #=========================================================================== |
| |
| exit() |