天天看點

服務啟動報錯

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