You can try this, it works for me with an Oracle9i database and last versions
of JBoss AS and JBoss portal (not the bundled pack)...i'm not an expert so i'm
not sure it's the best solution but now i have a great install of the portal
with no errors.
I have modified these files:
- standardjaws.xml:
java:/OracleDS
<type-mapping>Oracle8</type-mapping>
- standardjboss-cmp-jdbc.xml:
<jbosscmp-jdbc>
java:/OracleDS
<datasource-mapping>Oracle8</datasource-mapping>
</jbosscmp-jdbc>
- oracle-ds.xml:
you can find an example in jboss-portal-home\docs\examples\jca and you just
need to put your connection parameter.
- portal-oracle-ds.xml:
you can find an example in jboss-portal-home\docs\portal\setup and you just
need to put your connection parameter.
- login-config.xml:
<application-policy name = "OracleDbRealm">
<login-module code =
"org.jboss.resource.security.ConfiguredIdentityLoginModule"
flag = "required">
<module-option name = "principal">xxx</module-option>
<module-option name = "userName">xxx</module-option>
<module-option name = "password">yyy</module-option>
<module-option name ="managedConnectionFactoryName">
jboss.jca:service=LocalTxCM,name=OracleDS
</module-option>
</login-module>
</application-policy>
...
<!-- Security domains for testing new jca framework -->
<application-policy name = "OracleDbRealm">
<login-module code =
"org.jboss.resource.security.ConfiguredIdentityLoginModule"
flag = "required">
<module-option name = "principal">xxx</module-option>
<module-option name = "userName">xxx</module-option>
<module-option name = "password">yyy</module-option>
<module-option name =
"managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=OracleDS</module-option>
</login-module>
</application-policy>
- oracle-jdbc-state-service.xml:
( i have renamed the hsqldb file and modify the value DefaultDS in OracleDS)
<depends
optional-attribute-name="ConnectionManager">jboss.jca:service=DataSourceBinding,name=OracleDS
- oracle-jdbc3-service.xml
you can find an example in jboss-portal-home/docs/examples/jms
- ejb-deployer.xml:
<depends
optional-attribute-name="DataSource">jboss.jca:service=DataSourceBinding,name=OracleDS
After that, you need to delete hsqldb.jar, and these files:
hsqldb-ds.xml, portal-hsqldb-ds.xml, and hsql-jdbc-service.xml
i think it's the same for you with MySQL parameter...
i wish it'll help... and tell me if it works for you too :)
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3883840#3883840
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3883840
-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
