jboss怎么连接Oracle数据库,配置JBOSS的oracle数据连接。

1.oracle-ds.xml

OracleDS

jdbc:oracle:thin:@192.168.1.2:1521:orcl

oracle.jdbc.driver.OracleDriver

fwsys

fwsys

org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter

Oracle10g

2.standardjbosscmp-jdbc.xml

java:/OracleDS

Oracle10g

...........

3. standardjaws.xml

java:/OracleDS

Oracle10g

false

4.login-config.xml

/p>

"-//JBoss//DTD JBOSS Security Config 3.0//EN"

"http://www.jboss.org/j2ee/dtd/security_config.dtd">

flag = "required">

true

flag = "required">

guest

java:/DefaultDS

SELECT PASSWD FROM JMS_USERS WHERE USERID=?

SELECT ROLEID, 'Roles' FROM JMS_ROLES WHERE USERID=?

flag = "required">

sa

sa

jboss.jca:service=LocalTxCM,name=DefaultDS

flag = "required">

guest

guest

guest

jboss.jca:service=TxCM,name=JmsXA

flag = "required">

props/jmx-console-users.properties

props/jmx-console-roles.properties

flag = "required">

web-console-users.properties

web-console-roles.properties

flag="required">

props/jbossws-users.properties

props/jbossws-roles.properties

anonymous

flag = "required">

fwsys

fwsys

jboss.jca:service=LocalTxCM,name=OrcaleDS

flag = "required" />

PS:jboss 里面配置Orcale数据库不能用sys这个用户。

posted on 2007-03-02 16:40 zhangyuanlu 阅读(1444) 评论(0)  编辑  收藏