I modified an example from  [url]http://publib.boulder.ibm.com/infocenter/wasinfo/v6r0/
index.jsp?topic=/com.ibm.websphere.express.doc/info/exp/ae/rdat_scriptool.html[/ur
l] 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\jdb
cdriver\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} {implemen
tationClassName oracle.jdbc.xa.client.OracleXADataSource} {name "JDBC D
river"} {description "Oracle JDBC Provider"}}]
set provider1 [$AdminConfig create JDBCProvider $serv $attrs1]

#Create the first data source

set attrs2 [subst {{name RegSho2} {description "DataSourc
e"}}]
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.St
ring} {value $databaseName1}}]
$AdminConfig create J2EEResourceProperty $propSet1 $attrs3
puts "Creating attrs10 $ds1"
set attrs10 [subst {{jndiName jdbc/RegSho} {statementCach
eSize 10}
{datasourceHelperClassname com.ibm.websphere.rsadapter.OracleDataStoreH
elper}
{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"; exceptio
n in
formation: java.lang.IllegalArgumentException: java.lang.IllegalArgumentExce
ptio
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#J2CResourceAda
pter
_1164208432539)"
"WebSphere Relational Resource Adapter(cells/DA77133Node01Cell/nodes/DA77133
Node
01/servers/server1|resources.xml#builtin_rra)"}}
{authMechanismPreference "BASIC_PASSWORD"}
{authDataAlias  RegShoDatabaseUser5}
^
 ****************************************
*****

Would you please help me resolve this problem?
Thanks,

[ Post a follow-up to this message ]

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\ojd
bc14.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} {implem
entationClassName
> 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 "DataSou
rce"}}]
> 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} {statementCa
cheSize 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#J2CResourceA
dapter
> _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,
>

[ Post a follow-up to this message ]

Thank you very much for your help, Tom.

I did not get any error after doing what you suggested. But the created data
source is not displayed on the admin web console.  Any suggestion?

Again thanks,
Hong

[ Post a follow-up to this message ]

Hi, Did you save the configuration?

$AdminConfig save

You will then have to have the user logged onto the console to log off and t
hen re-enter the console.

Brian

[ Post a follow-up to this message ]

Hi, Brain,

I did use $AdminConfig save in the end of jacl file. Any suggestions?

Thank you very much for your help.
Hong

[ Post a follow-up to this message ]

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 chang
ed to any level and XA can
be enabled.  Other options, like adding CMP to the datasource.

Brian

[ Post a follow-up to this message ]

Hi Brain,

Thank you so much for your help.

After using your sample to create the DB2 datasource successfully, I modifie
d it to create the oracle datasource. But I had one problem: the url is miss
ing. How do I include URL parameter?

Again thanks.

[ Post a follow-up to this message ]