ERROR [com.deppon.foss.framework.server.components.jobgrid.GridJobStoreTX] (ServerService Thread Pool -- 48) ClusterManager: Error managing cluster: Failed to obtain DB connection from data source 'myDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/fossds' java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/jdbc/fossds: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/fossds' java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/jdbc/fossds [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/fossds' java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/jdbc/fossds]
满满的都是数据源的报错,找来找去,原来是把数据库的用户的密码给改了,导致数据源配置文件里的用户名密码和真正的密码不相符,修改一下密码就可以了。。。数据源的报错一般都来看一下这个文件,想一下是不是你自己做了什么操作
/opt/jboss6/jboss-eap-6.2/standalone/configuration/standalone.xml 文件中
<datasources>
<datasource jndi-name="java:/jdbc/fossds" pool-name="foosDS" enabled="true" use-java-context="true">
<connection-url>jdbc:oracle:thin:@192.168.20.115:1521:hrdb</connection-url>
<driver>hr-oracle</driver>
<pool>
<min-pool-size>50</min-pool-size>
<max-pool-size>200</max-pool-size>
</pool>
<security>
<user-name>ehreos</user-name>
<password>dbhr115hr</password>
</security>
<validation>
<background-validation>true</background-validation>
<background-validation-millis>5000</background-validation-millis>
<exception-sorter class-name="org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter"/>
</validation>
<timeout>
<blocking-timeout-millis>30000</blocking-timeout-millis>
<idle-timeout-minutes>30</idle-timeout-minutes>
</timeout>
</datasource>
就这两个红字的地方,一定要注意
本文转自aaa超超aaa 51CTO博客,原文链接:http://blog.51cto.com/10983441/1732618