| Author |
Help needed for creating a datasource using admin
|
|
|
| I modified an example from http://publib.boulder.ibm.com/infoc..._scriptool.html to create a datasource on WebSphere 6.0 windows version, but it failed on
$AdminConfig modify $ds1 $attrs10 :
Here is the script:
***************************
set server "server1"
set fvtbase "c:/wssb/fvtbase"
set driverClassPath "C:\oracle\jdbcdriver\oracle\classes12.zip;C:\oracle\jdbcdriver\oracle\ojdbc14.jar.zip"
###
### Users and passwords..
###
set defaultUser1 "user1"
set defaultPassword1 "user1"
set aliasName DatabaseUser5"
set databaseName1 "jdbc:oracle:thin:@fbct:1521:FBCT"
puts "Add an alias alias1"
set cell [$AdminControl getCell]
set sec [$AdminConfig getid /Cell:$cell/Security:/]
#---------------------------------------------------------
# Create a JAASAuthData object for component-managed authentication
#---------------------------------------------------------
puts "create JAASAuthData object for alias1"
set alias_attr [list alias $aliasName]
set desc_attr [list description "Alias 1"]
set userid_attr [list userId $defaultUser1]
set password_attr [list password $defaultPassword1]
set attrs [list $alias_attr $desc_attr $userid_attr $password_attr]
set authdata [$AdminConfig create JAASAuthData $sec $attrs]
puts "Installing RegSho Oracle datasource for XA"
#Get the server name...
puts "Finding the server $server"
set servlist [$AdminConfig list Server]
set servsize [llength $servlist]
foreach srvr $servlist {
set sname [lindex [lindex [$AdminConfig show $srvr {name}] 0] 1]
if {($sname == $server)} {
puts "Found server $srvr"
set serv $srvr
}
}
puts "Finding the Resource Adapter"
set rsadapter [$AdminConfig list J2CResourceAdapter $serv]
#Now create a JDBC Provider for the 5.0 data sources
puts "Creating the provider for oracle"
set attrs1 [subst {{classpath $driverClassPath} {implementationClassName oracle.jdbc.xa.client.OracleXADataSource} {name "JDBC Driver"} {description "Oracle JDBC Provider"}}]
set provider1 [$AdminConfig create JDBCProvider $serv $attrs1]
#Create the first data source
set attrs2 [subst {{name RegSho2} {description "DataSource"}}]
set ds1 [$AdminConfig create DataSource $provider1 $attrs2]
#Set the properties for the data source.
set propSet1 [$AdminConfig create J2EEResourcePropertySet $ds1 {}]
puts "Creating attrs3"
set attrs3 [subst {{name databaseName} {type java.lang.String} {value $databaseName1}}]
$AdminConfig create J2EEResourceProperty $propSet1 $attrs3
puts "Creating attrs10 $ds1"
set attrs10 [subst {{jndiName jdbc/RegSho} {statementCacheSize 10}
{datasourceHelperClassname com.ibm.websphere.rsadapter.OracleDataStoreHelper}
{relationalResourceAdapter {$rsadapter}}
{authMechanismPreference "BASIC_PASSWORD"}
{authDataAlias $aliasName}}]
puts "Creating attrs11 $attrs10"
$AdminConfig modify $ds1 $attrs10
******************************
Here is the error:
*************************
WASX7017E: Exception received while running file "RegShoJDCB.jacl"; exception in
formation: java.lang.IllegalArgumentException: java.lang.IllegalArgumentExceptio
n: WASX7121E: "
" found instead of expected {.
{jndiName jdbc/RegSho} {statementCacheSize 10}
{datasourceHelperClassname com.ibm.websphere.rsadapter.OracleDataS
toreHelper}
{relationalResourceAdapter {"SIB JMS Resource Adapter(cells/DA7713
3Node01Cell/nodes/DA77133Node01/servers/server1|resources.xml#J2CResourceAdapter
_1164208432539)"
"WebSphere Relational Resource Adapter(cells/DA77133Node01Cell/nodes/DA77133Node
01/servers/server1|resources.xml#builtin_rra)"}}
{authMechanismPreference "BASIC_PASSWORD"}
{authDataAlias RegShoDatabaseUser5}
^
****************************************
*****
Would you please help me resolve this problem?
Thanks,
| |
| Tom Weissinger 2007-08-01, 1:23 pm |
| Looks to me like the error is suggesting that it was looking for a "{" but
it got a carriage return. Try putting everything in "attrs10" all on one
line.
<hong.zhuang@fmr.com> wrote in message
news:1219291612.1185980774804.JavaMail.wassrvr@ltsgwas009.sby.ibm.com...
>I modified an example from
>http://publib.boulder.ibm.com/infoc..._scriptool.html
>to create a datasource on WebSphere 6.0 windows version, but it failed on
> $AdminConfig modify $ds1 $attrs10 :
>
> Here is the script:
> ***************************
> set server "server1"
> set fvtbase "c:/wssb/fvtbase"
> set driverClassPath
> "C:\oracle\jdbcdriver\oracle\classes12.zip;C:\oracle\jdbcdriver\oracle\ojdbc14.jar.zip"
> ###
> ### Users and passwords..
> ###
>
> set defaultUser1 "user1"
> set defaultPassword1 "user1"
> set aliasName DatabaseUser5"
>
> set databaseName1 "jdbc:oracle:thin:@fbct:1521:FBCT"
>
>
>
> puts "Add an alias alias1"
> set cell [$AdminControl getCell]
> set sec [$AdminConfig getid /Cell:$cell/Security:/]
>
> #---------------------------------------------------------
> # Create a JAASAuthData object for component-managed authentication
> #---------------------------------------------------------
> puts "create JAASAuthData object for alias1"
>
> set alias_attr [list alias $aliasName]
> set desc_attr [list description "Alias 1"]
> set userid_attr [list userId $defaultUser1]
> set password_attr [list password $defaultPassword1]
> set attrs [list $alias_attr $desc_attr $userid_attr $password_attr]
>
> set authdata [$AdminConfig create JAASAuthData $sec $attrs]
>
>
> puts "Installing RegSho Oracle datasource for XA"
>
>
>
> #Get the server name...
> puts "Finding the server $server"
> set servlist [$AdminConfig list Server]
> set servsize [llength $servlist]
> foreach srvr $servlist {
> set sname [lindex [lindex [$AdminConfig show $srvr {name}] 0] 1]
> if {($sname == $server)} {
> puts "Found server $srvr"
> set serv $srvr
> }
> }
>
> puts "Finding the Resource Adapter"
> set rsadapter [$AdminConfig list J2CResourceAdapter $serv]
>
> #Now create a JDBC Provider for the 5.0 data sources
> puts "Creating the provider for oracle"
> set attrs1 [subst {{classpath $driverClassPath} {implementationClassName
> oracle.jdbc.xa.client.OracleXADataSource} {name "JDBC Driver"}
> {description "Oracle JDBC Provider"}}]
> set provider1 [$AdminConfig create JDBCProvider $serv $attrs1]
>
> #Create the first data source
>
> set attrs2 [subst {{name RegSho2} {description "DataSource"}}]
> set ds1 [$AdminConfig create DataSource $provider1 $attrs2]
>
> #Set the properties for the data source.
> set propSet1 [$AdminConfig create J2EEResourcePropertySet $ds1 {}]
> puts "Creating attrs3"
> set attrs3 [subst {{name databaseName} {type java.lang.String} {value
> $databaseName1}}]
> $AdminConfig create J2EEResourceProperty $propSet1 $attrs3
> puts "Creating attrs10 $ds1"
> set attrs10 [subst {{jndiName jdbc/RegSho} {statementCacheSize 10}
> {datasourceHelperClassname
> com.ibm.websphere.rsadapter.OracleDataStoreHelper}
> {relationalResourceAdapter {$rsadapter}}
> {authMechanismPreference "BASIC_PASSWORD"}
> {authDataAlias $aliasName}}]
>
> puts "Creating attrs11 $attrs10"
> $AdminConfig modify $ds1 $attrs10
> ******************************
>
> Here is the error:
> *************************
> WASX7017E: Exception received while running file "RegShoJDCB.jacl";
> exception in
> formation: java.lang.IllegalArgumentException:
> java.lang.IllegalArgumentExceptio
> n: WASX7121E: "
> " found instead of expected {.
> {jndiName jdbc/RegSho} {statementCacheSize 10}
> {datasourceHelperClassname
> com.ibm.websphere.rsadapter.OracleDataS
> toreHelper}
> {relationalResourceAdapter {"SIB JMS Resource
> Adapter(cells/DA7713
> 3Node01Cell/nodes/DA77133Node01/servers/server1|resources.xml#J2CResourceAdapter
> _1164208432539)"
> "WebSphere Relational Resource
> Adapter(cells/DA77133Node01Cell/nodes/DA77133Node
> 01/servers/server1|resources.xml#builtin_rra)"}}
> {authMechanismPreference "BASIC_PASSWORD"}
> {authDataAlias RegShoDatabaseUser5}
> ^
> ****************************************
*****
>
> Would you please help me resolve this problem?
> Thanks,
>
| |
|
| Thank you very much for your help, Tom.
I did not get any error after doing what you suggested. But the created datasource is not displayed on the admin web console. Any suggestion?
Again thanks,
Hong
| |
| Brian S Paskin 2007-08-02, 7:19 pm |
| Hi, Did you save the configuration?
$AdminConfig save
You will then have to have the user logged onto the console to log off and then re-enter the console.
Brian
| |
|
| Hi, Brain,
I did use $AdminConfig save in the end of jacl file. Any suggestions?
Thank you very much for your help.
Hong
| |
| Brian S Paskin 2007-08-07, 1:18 pm |
| Hi, I am posting a JACL script to DeveloperWorks forum that creates the J2C Auth, JDBC Provider, and Datasource. The default values must be changed for your system. This creates the Provider at the node level, but can be changed to any level and XA can
be enabled. Other options, like adding CMP to the datasource.
Brian
| |
|
| Hi Brain,
Thank you so much for your help.
After using your sample to create the DB2 datasource successfully, I modified it to create the oracle datasource. But I had one problem: the url is missing. How do I include URL parameter?
Again thanks.
|
|
|
|