2008-05-15

Jboss4.0.5下配置oracle出现的问题,待解决

关键字: jboss4.0.5
Oracle-ds.xml中是如下配置:
<datasources>
<local-tx-datasource>
<jndi-name>jdbc/mydatasource </jndi-name>
<connection-url>jdbc:oracle:thin:@192.168.18.7:1521:hrgl </connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver </driver-class>
<user-name>test </user-name>
<password>test </password>
<metadata>
<type-mapping>Oracle9i </type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
启动时报:
10:11:32,828 INFO [STDOUT] Can not get DataBase connection from DB!!!com.lbs.sieaf.exception.NoConnectionException
10:11:32,828 INFO [STDOUT] trans init finish
10:11:32,859 INFO [STDOUT] catch NamingException when trying to lookup DataSource name
javax.naming.NameNotFoundException: jdbc not bound
10:11:32,859 ERROR [STDERR] com.lbs.sieaf.exception.NoConnectionException
在控制台中,可以看到两个:
jboss.jdbc
datasource=DefaultDS,service=metadata
datasource=jdbc/mydatasource,service=metadata
service=SQLExceptionProcessor
service=metadata

第一个是默认的java数据源
第二个是我要用的oracle的数据源

在网上搜索到jboss配置的文章,按照上面介绍的方法:
在login-config.xml里面配置:
<application-policy name = "OracleDbRealm">
<authentication>
<login-module code =
"org.jboss.resource.security.ConfiguredIdentityLoginModule"
flag = "required">
<module-option name = "principal">sa </module-option>
<module-option name = "userName">sa </module-option>
<module-option name = "password"> </module-option>
<module-option name ="managedConnectionFactoryName">
jboss.jca:service=LocalTxCM,name=jdbc/mydatasource
</module-option>
</login-module>
</authentication>
</application-policy>

在standardjaws.xml里面配置:
<jaws>
<datasource>jdbc/mydatasource </datasource>
<type-mapping>Oracle9i </type-mapping>
</jaws>

在standardjbosscmp-jdbc.xml里面配置:
<jbosscmp-jdbc>
<defaults>
<datasource>jdbc/mydatasource </datasource>
<datasource-mapping>Oracle9i </datasource-mapping>
</defaults>
</jbosscmp-jdbc>

结果测试还是不行,在pl/sql里面有看到连接过去,但是调用启动时候都会出现如下错误:
10:11:32,828 INFO [STDOUT] Can not get DataBase connection from DB!!!com.lbs.sieaf.exception.NoConnectionException
10:11:32,828 INFO [STDOUT] trans init finish
10:11:32,859 INFO [STDOUT] catch NamingException when trying to lookup DataSource name
javax.naming.NameNotFoundException: jdbc not bound
10:11:32,859 ERROR [STDERR] com.lbs.sieaf.exception.NoConnectionException
评论
发表评论

提醒: 该博客已发表在公共论坛,博客所有留言会成为论坛回贴,留言请注意遵守论坛发贴规则

您还没有登录,请登录后发表评论

deepass
搜索本博客
博客分类
最近加入圈子
存档
最新评论