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