|
| Hi,<br />
<br />
To create an J2EE Auth. Alias, I'm using this script:<br />
<br />
cellname = AdminControl.getCell()<br />
sec = AdminConfig.getid ('/Cell:'+ cellname + '/Security:/')<br />
usr_alias = '<YOURALIAS>'<br />
usr_id = '<YOURUSERID>'<br />
usr_desc = '<YOURUSERDESCRIPTION>'<br />
usr_pswd = '<YOURPASSWORD>'<br />
usr_attrs = [<a href="http://www-128.ibm.com/developerworks/forums/">'alias',usr_alias</a>,<a href="http://www-128.ibm.com/developerworks/forums/">'description',usr_desc</a>,<a href="http://www-128.ibm.com/developerworks/forums/">'userId',usr_id</a>,<a hr
ef="http://www-128.ibm.com/developerworks/forums/">'password',usr_pswd]</a><br />
contauthdata = AdminConfig.create ('JAASAuthData', sec, usr_attrs)<br />
<br />
After this, I use the "contauthdata" variable in the script (datasource) above.<br />
<br />
To change custom properties for the new datasource created, I'm using this (for oracle only):<br />
<br />
<ol>
<li>SETTINGS CONNEXION POOL</li>
</ol>
cxattr = [<a href="http://www-128.ibm.com/developerworks/forums/">'connectionTimeout', 180</a> , <a href="http://www-128.ibm.com/developerworks/forums/">'maxConnections', 60</a> , <a href="http://www-128.ibm.com/developerworks/forums/">'minConnections', 0
</a> , <a href="http://www-128.ibm.com/developerworks/forums/">'reapTime', 180</a> , <a href="http://www-128.ibm.com/developerworks/forums/">'unusedTimeout', 1800</a> , <a href="http://www-128.ibm.com/developerworks/forums/">'agedTimeout', 0</a> , <a href
="http://www-128.ibm.com/developerworks/forums/">'purgePolicy', 'EntirePool']</a><br />
AdminConfig.create ('ConnectionPool', newds, cxattr)<br />
<p />
<ol>
<li>CUSTOMS PROPERTIES DEFINITION FOR ORACLE</li>
</ol>
newpropset = AdminConfig.create('J2EEResourcePropertySet',newds,[])<br />
<br />
newattr = [<a href="http://www-128.ibm.com/developerworks/forums/">'name','URL'</a>,<a class="jive-link-external" href="http://'type','java.lang.String'">http://'type','java.lang.String'</a>,<a href="http://www-128.ibm.com/developerworks/forums/">'value',
'<YOUR_DS_URL_ORACLE>']</a><br />
AdminConfig.create('J2EEResourceProperty', newpropset, newattr)<br />
newattr = [<a href="http://www-128.ibm.com/developerworks/forums/">'name','oracleLogFileSizeLimit'</a>,<a class="jive-link-external" href="http://'type','java.lang.Integer'">http://'type','java.lang.Integer'</a>,<a href="http://www-128.ibm.com/developerwo
rks/forums/">'value','0']</a><br />
AdminConfig.create('J2EEResourceProperty', newpropset, newattr)<br />
newattr = [<a href="http://www-128.ibm.com/developerworks/forums/">'name','oracleLogFileCount'</a>,<a class="jive-link-external" href="http://'type','java.lang.Integer'">http://'type','java.lang.Integer'</a>,<a href="http://www-128.ibm.com/developerworks/
forums/">'value','1']</a><br />
AdminConfig.create('J2EEResourceProperty', newpropset, newattr)<br />
newattr = [<a href="http://www-128.ibm.com/developerworks/forums/">'name','oracleLogTraceLevel'</a>,<a class="jive-link-external" href="http://'type','java.lang.String'">http://'type','java.lang.String'</a>,<a href="http://www-128.ibm.com/developerworks/f
orums/">'value','INFO']</a><br />
AdminConfig.create('J2EEResourceProperty', newpropset, newattr)<br />
newattr = [<a href="http://www-128.ibm.com/developerworks/forums/">'name','oracle9iLogTraceLevel'</a>,<a class="jive-link-external" href="http://'type','java.lang.String'">http://'type','java.lang.String'</a>,<a href="http://www-128.ibm.com/developerworks
/forums/">'value','2']</a><br />
AdminConfig.create('J2EEResourceProperty', newpropset, newattr)<br />
newattr = [<a href="http://www-128.ibm.com/developerworks/forums/">'name','oracleLogFormat'</a>,<a class="jive-link-external" href="http://'type','java.lang.String'">http://'type','java.lang.String'</a>,<a href="http://www-128.ibm.com/developerworks/forum
s/">'value','SimpleFormat']</a><br />
AdminConfig.create('J2EEResourceProperty', newpropset, newattr)<br />
newattr = [<a href="http://www-128.ibm.com/developerworks/forums/">'name','oracleLogPackageName'</a>,<a class="jive-link-external" href="http://'type','java.lang.String'">http://'type','java.lang.String'</a>,<a class="jive-link-external" href="http://'val
ue','oracle.jdbc.driver']">http://'value','oracle.jdbc.driver']</a><br />
AdminConfig.create('J2EEResourceProperty', newpropset, newattr)<br />
newattr = [<a href="http://www-128.ibm.com/developerworks/forums/">'name','portNumber'</a>,<a class="jive-link-external" href="http://'type','java.lang.Integer'">http://'type','java.lang.Integer'</a>,<a href="http://www-128.ibm.com/developerworks/forums/"
>'value','1521']</a><br />
AdminConfig.create('J2EEResourceProperty', newpropset, newattr)<br />
newattr = [<a href="http://www-128.ibm.com/developerworks/forums/"> 'name','enableMultithreadedAccessDetecti
on'</a>,<a class="jive-link-external" href="http://'type','java.lang.Boolean'">http://'type','java.lang.Boolean'</a>,<a href="http://www-128.ibm.com
/developerworks/forums/">'value','false']</a><br />
AdminConfig.create('J2EEResourceProperty', newpropset, newattr)<br />
newattr = [<a href="http://www-128.ibm.com/developerworks/forums/">'name','reauthentication'</a>,<a class="jive-link-external" href="http://'type','java.lang.Boolean'">http://'type','java.lang.Boolean'</a>,<a href="http://www-128.ibm.com/developerworks/fo
rums/">'value','false']</a><br />
AdminConfig.create('J2EEResourceProperty', newpropset, newattr)<br />
newattr = [<a href="http://www-128.ibm.com/developerworks/forums/">'name','jmsOnePhaseOptimization'</a>,<a class="jive-link-external" href="http://'type','java.lang.Boolean'">http://'type','java.lang.Boolean'</a>,<a href="http://www-128.ibm.com/developerw
orks/forums/">'value','false']</a><br />
AdminConfig.create('J2EEResourceProperty', newpropset, newattr)<br />
newattr = [<a href="http://www-128.ibm.com/developerworks/forums/">'name','preTestSQLString'</a>,<a class="jive-link-external" href="http://'type','java.lang.String'">http://'type','java.lang.String'</a>,<a href="http://www-128.ibm.com/developerworks/foru
ms/">'value','SELECT 1 FROM DUAL']</a><br />
AdminConfig.create('J2EEResourceProperty', newpropset, newattr)<br />
newattr = [<a href="http://www-128.ibm.com/developerworks/forums/">'name','dbFailOverEnabled'</a>,<a class="jive-link-external" href="http://'type','java.lang.Boolean'">http://'type','java.lang.Boolean'</a>,<a href="http://www-128.ibm.com/developerworks/f
orums/">'value','false']</a><br />
AdminConfig.create('J2EEResourceProperty', newpropset, newattr)<br />
newattr = [<a href="http://www-128.ibm.com/developerworks/forums/">'name','connRetriesDuringDBFailover'</a>,<a class="jive-link-external" href="http://'type','java.lang.Integer'">http://'type','java.lang.Integer'</a>,<a href="http://www-128.ibm.com/develo
perworks/forums/">'value','100']</a><br />
AdminConfig.create('J2EEResourceProperty', newpropset, newattr)<br />
newattr = [<a href="http://www-128.ibm.com/developerworks/forums/"> 'name','connRetryIntervalDuringDBFailove
r'</a>,<a class="jive-link-external" href="http://'type','java.lang.Long'">http://'type','java.lang.Long'</a>,<a href="http://www-128.ibm.com/develo
perworks/forums/">'value','3000']</a><br />
AdminConfig.create('J2EEResourceProperty', newpropset, newattr)<br />
<br />
print '-> Done!'<br />
<br />
###########################<br />
<br />
To make this script, I created one with the graphic console and I open the file ressources.xml (<WASROOT>/config/cells/<YOURCELLNAME>/). You can see all properties needed for your config and you can change the script according to it. My Script
is available for a JDBC Driver Oracle Only!<br />
<br />
Regards.<br />
Nikola.
|
|