| from java.io import FileInputStream |
| |
| propInputStream = FileInputStream("config.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") |
| 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('/') |
| |
| ### Checking for the server |
| try: |
| cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName) |
| print '===> /JDBCSystemResources/' +dsName+'/JDBCResource/ already exists' |
| print '===> No action was performed' |
| cancelEdit('y') |
| exit() |
| except: |
| pass |
| |
| cd('/') |
| cmo.createJDBCSystemResource(dsName) |
| cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName) |
| cmo.setName(dsName) |
| |
| cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDataSourceParams/' + dsName ) |
| set('JNDINames',jarray.array([String( dsJNDIName )], 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() |