Hi, i've successfully configured oracle 9 as the default datasource for jboss.   The 
following lists the changes i had to make

default/deploy/oracle-ds.xml
  |     <jndi-name>DefaultDS</jndi-name>
  |     <connection-url>jdbc:oracle:thin:@hostname:1521:db</connection-url>
  |     <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
  |     <user-name>username</user-name>
  |     <password>pass</password>
  | 
  | default/conf/standardjaws.xml
  |   <datasource>java:/DefaultDS</datasource>
  |   <type-mapping>Oracle9i</type-mapping>
  |   <debug>false</debug>
  | 
  | default/conf/standardjbosscmp-jdbc.xml
  |   <datasource>java:/DefaultDS</datasource>
  |   <datasource-mapping>Oracle9i</datasource-mapping>
  | 
  | default/conf/login-config.xml
  |    <application-policy name = "OracleDbRealm"> 
  |        <authentication> 
  |               <login-module code =  
  |       "org.jboss.resource.security.ConfiguredIdentityLoginModule" 
  |                                                             flag = "required"> 
  |                      <module-option name = "principal">db</module-option> 
  |                      <module-option name = "userName">username</module-option> 
  |                      <module-option name = "password">pass</module-option> 
  |                      <module-option name ="managedConnectionFactoryName">
  |                              jboss.jca:service=LocalTxCM,name=DefaultDS
  |                      </module-option> 
  |               </login-module> 
  |        </authentication> 
  |    </application-policy>
  | 
  | 
  | default/deploy/jms/oracle-jdbc2-service.xml
  |    <depends optional-attribute-name="ConnectionManager">
  |       jboss.jca:service=LocalTxCM,name=DefaultDS
  |    </depends>
  | 

Regards,
Sunil.

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3835798#3835798

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3835798



-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g. 
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to