服务器-jboss7.1.1 as final与mysql5.7.16的配置
服务器mysqljava eejboss
由于学年论文设计的缘由，现在开始零基础学java ee。在最近的一段时间内，我搭建了java ee的开发环境，我用的jdk和eclipse环境分别是jdk-7u79-windows-i586 、eclipse-jee-kepler-sr2-win32，jboss的环境是jboss-as-7.1.1.final，配置好环境后，jboss可以正常启动，然后，我安装了mysql,环境是mysql-5.7.16-win32.zip，通过命令行配置后mysql可以正常启动。最后是jboss与mysql的配置启动，其中jboss中的standalone.xml文件如下：
在d:\jboss7.1.1\modules\com\mysql\main中，文件配置如下：
鉴于我是初学者，不懂配置，求大神指导，以解决问题。
回复内容：http://blog.csdn.net/u012705000/article/details/51408007
初次使用jboss7.1.1.final部署项目，遇到了很多困难，最终通过查看官方文档和网上资料得以解决，特此记录一下。
error information
2016-05-12 12:53:20 jrebel: 2016-05-12 12:53:20 jrebel: ############################################################# 2016-05-12 12:53:20 jrebel: 2016-05-12 12:53:20 jrebel: jrebel legacy agent 6.4.2a (201604061405) 2016-05-12 12:53:20 jrebel: (c) copyright zeroturnaround as, estonia, tartu. 2016-05-12 12:53:20 jrebel: 2016-05-12 12:53:20 jrebel: over the last 5 days jrebel prevented 2016-05-12 12:53:20 jrebel: at least 386 redeploys/restarts saving you about 15.7 hours. 2016-05-12 12:53:20 jrebel: 2016-05-12 12:53:20 jrebel: licensed to lei zhang (sinosoft) 2016-05-12 12:53:20 jrebel: 2016-05-12 12:53:20 jrebel: license type: evaluation 2016-05-12 12:53:20 jrebel: valid from: april 26, 2016 2016-05-12 12:53:20 jrebel: valid until: may 10, 2016 2016-05-12 12:53:20 jrebel: 2016-05-12 12:53:20 jrebel: trial license expired. 2016-05-12 12:53:20 jrebel: 2016-05-12 12:53:20 jrebel: to extend your evaluation or purchase a license, 2016-05-12 12:53:20 jrebel: contact sales@zeroturnaround.com. 2016-05-12 12:53:20 jrebel: 2016-05-12 12:53:20 jrebel: if you think this is an error, contact support@zeroturnaround.com. 2016-05-12 12:53:20 jrebel: 2016-05-12 12:53:20 jrebel: 2016-05-12 12:53:20 jrebel: ############################################################# 2016-05-12 12:53:20 jrebel: 2016-05-12 12:53:20 jrebel: 2016-05-12 12:53:20 jrebel: a newer version '6.4.3' is available for download 2016-05-12 12:53:20 jrebel: from http://zeroturnaround.com/software/jrebel/download/ 2016-05-12 12:53:20 jrebel: warning: -logmodule is deprecated. please use the system property 'java.util.logging.manager'or the ' java.util.logging.logmanager' service loader. 12:53:22,705 信息 [org.jboss.modules] jboss modules version 1.1.1.ga 12:53:22,941 info [org.jboss.msc] jboss msc version 1.0.2.ga 12:53:23,032 info [org.jboss.as] jbas015899: jboss as 7.1.1.final "brontes" starting 12:53:29,465 info [org.jboss.as.server] jbas015888: creating http management service using socket-binding (management-http) 12:53:29,514 info [org.jboss.as.logging] jbas011502: removing bootstrap log handlers 12:53:29,531 info [org.jboss.as.clustering.infinispan] (serverservice thread pool -- 52) jbas010280: activating infinispan subsystem. 12:53:29,561 info [org.jboss.as.configadmin] (serverservice thread pool -- 47) jbas016200: activating configadmin subsystem 12:53:29,563 info [org.jboss.as.security] (serverservice thread pool -- 65) jbas013101: activating security subsystem 12:53:29,591 info [org.jboss.as.naming] (serverservice thread pool -- 59) jbas011800: activating naming subsystem 12:53:29,593 info [org.jboss.as.webservices] (serverservice thread pool -- 69) jbas015537: activating webservices extension 12:53:29,611 info [org.jboss.as.osgi] (serverservice thread pool -- 60) jbas011940: activating osgi subsystem 12:53:29,613 info [org.jboss.as.naming] (msc service thread 1-1) jbas011802: starting naming service 12:53:29,624 info [org.jboss.as.security] (msc service thread 1-7) jbas013100: current picketbox version=4.0.7.final 12:53:29,770 info [org.jboss.as.mail.extension] (msc service thread 1-2) jbas015400: bound mail session [java:jboss/mail/default] 12:53:29,945 info [org.jboss.ws.common.management.abstractserverconfig] (msc service thread 1-1) jboss web services - stack cxf server 4.0.2.ga 12:53:43,605 info [org.xnio] (msc service thread 1-3) xnio version 3.0.3.ga 12:53:43,612 info [org.xnio.nio] (msc service thread 1-6) xnio nio implementation version 3.0.3.ga 12:53:43,623 info [org.jboss.remoting] (msc service thread 1-3) jboss remoting version 3.2.3.ga 12:53:50,679 info [org.jboss.as.connector] (msc service thread 1-2) jbas010408: starting jca subsystem (jboss ironjacamar 1.0.9.final) 12:53:50,912 warn [org.jboss.as.server.deployment.scanner] (msc service thread 1-3) jbas015005: reliable deployment behaviour is not possible when auto-deployment of exploded content is enabled (i.e. deployment without use of ".dodeploy"' marker files). configuration of auto-deployment of exploded content is not recommended in any situation where reliability is desired. configuring the deployment scanner's auto-deploy-exploded setting to "false" is recommended. 12:53:50,916 info [org.jboss.as.server.deployment.scanner] (msc service thread 1-3) jbas015012: started filesystemdeploymentservice for directory e:\server\jboss-as-7.1.1.final\standalone\deployments 12:53:50,925 info [org.jboss.as.server.deployment.scanner] (deploymentscanner-threads - 1) jbas015014: re-attempting failed deployment ctpro.war 12:53:50,938 info [org.jboss.as.remoting] (msc service thread 1-4) jbas017100: listening on /127.0.0.1:4447 12:53:50,938 info [org.jboss.as.remoting] (msc service thread 1-7) jbas017100: listening on /127.0.0.1:9999 12:53:51,410 info [org.apache.coyote.http11.http11protocol] (msc service thread 1-3) starting coyote http/1.1 on http--127.0.0.1-9090 12:53:59,503 info [org.jboss.as.controller] (controller boot thread) jbas014774: service status report jbas014775: new missing/unsatisfied dependencies: service jboss.jdbc-driver.com_oracle (missing) dependents: [service jboss.data-source.java:jboss/datasources/sinosoftdatasource] 12:53:59,515 error [org.jboss.as.controller.management-operation] (deploymentscanner-threads - 2) operation ("add") failed - address: ([("deployment" => "ctpro.war")]) - failure description: "jbas014803: duplicate resource [(\"deployment\" => \"ctpro.war\")]" 12:53:59,517 error [org.jboss.as.server.deployment.scanner] (deploymentscanner-threads - 1) jbas014654: composite operation was rolled back 12:53:59,519 error [org.jboss.as.server.deployment.scanner] (deploymentscanner-threads - 1) {"jbas014653: composite operation failed and was rolled back. steps that failed:" => {"operation step-1" => "jbas014803: duplicate resource [(\"deployment\" => \"ctpro.war\")]"}} 12:53:59,588 info [org.jboss.as] (controller boot thread) jbas015951: admin console listening on http://127.0.0.1:10990 12:53:59,589 error [org.jboss.as] (controller boot thread) jbas015875: jboss as 7.1.1.final "brontes" started (with errors) in 37474ms - started 129 of 206 services (2 services failed or missing dependencies, 74 services are passive or on-demand)
此时我的配置文件如下：
module.xml
<module xmlns="urn:jboss:module:1.1" name="com.oracle"> <resources> <resource-root path="ojdbc6.jar"/> </resources> <dependencies> <module name="javax.api"/> <module name="javax.transaction.api"/> <module name="javax.servlet.api" optional="true"/> </dependencies> </module>
standalone.xml
<subsystem xmlns="urn:jboss:domain:datasources:1.0"> <datasources> <datasource jta="true" jndi-name="java:jboss/datasources/sinosoftdatasource" pool-name="sinosoftdatasource" enabled="true" use-java-context="true"> <connection-url>jdbc:oracle:thin:@10.129.2.106:1521:devdb</connection-url> <driver>oracle</driver> <pool> <prefill>false</prefill> <use-strict-min>false</use-strict-min> <flush-strategy>failingconnectiononly</flush-strategy> </pool> <security> <user-name>newcore</user-name> <password>newcore</password> </security> </datasource> <drivers> <driver name="oracle" module="com.oracle"> <driver-class>oracle.jdbc.oracledriver</driver-class> <xa-datasource-class>oracle.jdbc.xa.client.oraclexadatasource</xa-datasource-class> </driver> </drivers> </datasources> </subsystem>
step1: 更改standalone.xml <driver-class>oracle.jdbc.driver.oracledriver</driver-class>
17:33:35,590 信息 [org.jboss.modules] jboss modules version 1.1.1.ga 17:33:36,594 info [org.jboss.msc] jboss msc version 1.0.2.ga 17:33:36,716 info [org.jboss.as] jbas015899: jboss as 7.1.1.final "brontes" starting 17:33:40,571 info [org.jboss.as.server] jbas015888: creating http management service using socket-binding (management-http) 17:33:40,581 info [org.xnio] xnio version 3.0.3.ga 17:33:40,601 info [org.xnio.nio] xnio nio implementation version 3.0.3.ga 17:33:40,611 info [org.jboss.remoting] jboss remoting version 3.2.3.ga 17:33:40,669 info [org.jboss.as.logging] jbas011502: removing bootstrap log handlers 17:33:40,712 info [org.jboss.as.osgi] (serverservice thread pool -- 39) jbas011940: activating osgi subsystem 17:33:40,714 info [org.jboss.as.configadmin] (serverservice thread pool -- 26) jbas016200: activating configadmin subsystem 17:33:40,723 info [org.jboss.as.security] (serverservice thread pool -- 44) jbas013101: activating security subsystem 17:33:40,951 info [org.jboss.as.clustering.infinispan] (serverservice thread pool -- 31) jbas010280: activating infinispan subsystem. 17:33:40,955 info [org.jboss.as.naming] (serverservice thread pool -- 38) jbas011800: activating naming subsystem 17:33:40,956 info [org.jboss.as.security] (msc service thread 1-8) jbas013100: current picketbox version=4.0.7.final 17:33:41,128 info [org.jboss.as.webservices] (serverservice thread pool -- 48) jbas015537: activating webservices extension 17:33:41,455 info [org.jboss.as.naming] (msc service thread 1-6) jbas011802: starting naming service 17:33:41,465 info [org.jboss.as.mail.extension] (msc service thread 1-4) jbas015400: bound mail session [java:jboss/mail/default] 17:33:41,465 info [org.jboss.as.connector] (msc service thread 1-7) jbas010408: starting jca subsystem (jboss ironjacamar 1.0.9.final) 17:33:42,594 info [org.jboss.as.connector.subsystems.datasources] (serverservice thread pool -- 27) jbas010403: deploying jdbc-compliant driver class oracle.jdbc.driver.oracledriver (version 11.2) 17:33:42,859 info [org.apache.coyote.http11.http11protocol] (msc service thread 1-3) starting coyote http/1.1 on http--127.0.0.1-9090 17:33:44,122 info [org.jboss.ws.common.management.abstractserverconfig] (msc service thread 1-6) jboss web services - stack cxf server 4.0.2.ga 17:33:44,708 warn [org.jboss.as.server.deployment.scanner] (msc service thread 1-7) jbas015005: reliable deployment behaviour is not possible when auto-deployment of exploded content is enabled (i.e. deployment without use of ".dodeploy"' marker files). configuration of auto-deployment of exploded content is not recommended in any situation where reliability is desired. configuring the deployment scanner's auto-deploy-exploded setting to "false" is recommended. 17:33:44,711 info [org.jboss.as.server.deployment.scanner] (msc service thread 1-7) jbas015012: started filesystemdeploymentservice for directory e:\server\jboss-as-7.1.1.final\standalone\deployments 17:33:44,730 info [org.jboss.as.remoting] (msc service thread 1-4) jbas017100: listening on /127.0.0.1:4447 17:33:44,730 info [org.jboss.as.remoting] (msc service thread 1-8) jbas017100: listening on /127.0.0.1:9999 17:33:44,745 info [org.jboss.as.server.deployment.scanner] (deploymentscanner-threads - 1) jbas015014: re-attempting failed deployment ctpro.war 17:33:45,107 info [org.jboss.as.controller] (controller boot thread) jbas014774: service status report jbas014775: new missing/unsatisfied dependencies: service jboss.jdbc-driver.oracle (missing) dependents: [service jboss.data-source.java:jboss/datasources/sinosoftdatasource] 17:33:45,128 error [org.jboss.as.controller.management-operation] (deploymentscanner-threads - 2) operation ("add") failed - address: ([("deployment" => "ctpro.war")]) - failure description: "jbas014803: duplicate resource [(\"deployment\" => \"ctpro.war\")]" 17:33:45,130 error [org.jboss.as.server.deployment.scanner] (deploymentscanner-threads - 1) jbas014654: composite operation was rolled back 17:33:45,132 error [org.jboss.as.server.deployment.scanner] (deploymentscanner-threads - 1) {"jbas014653: composite operation failed and was rolled back. steps that failed:" => {"operation step-1" => "jbas014803: duplicate resource [(\"deployment\" => \"ctpro.war\")]"}} 17:33:45,226 info [org.jboss.as] (controller boot thread) jbas015951: admin console listening on http://127.0.0.1:10990 17:33:45,227 error [org.jboss.as] (controller boot thread) jbas015875: jboss as 7.1.1.final "brontes" started (with errors) in 10514ms - started 130 of 207 services (2 services failed or missing dependencies, 74 services are passive or on-demand)
step 2 ;
改web.xml
context-param> <param-name>log4jconfiglocation</param-name> <param-value>/web-inf//log4j.xml</param-value> </context-param>
to:
context-param> <param-name>log4jconfiglocation</param-name> <param-value>/web-inf/classes/log4j.xml</param-value> </context-param>
19:02:28,784 error [org.springframework.web.context.contextloader] (msc service thread 1-5) context initialization failed:org.springframework.beans.factory.beancreationexception: error creating bean with name 'datasource' defined in servletcontext resource [/web-inf/app-config-context.xml]: invocation of init method failed; nested exception isjavax.naming.namenotfoundexception: sinosoftdatasource -- service jboss.naming.context.java.sinosoftdatasource at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.initializebean(abstractautowirecapablebeanfactory.java:1455) [org.springframework.beans-3.1.1.release.jar:3.1.1.release] at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.docreatebean(abstractautowirecapablebeanfactory.java:519) [org.springframework.beans-3.1.1.release.jar:3.1.1.release] at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.createbean(abstractautowirecapablebeanfactory.java:456) [org.springframework.beans-3.1.1.release.jar:3.1.1.release] at org.springframework.beans.factory.support.abstractbeanfactory$1.getobject(abstractbeanfactory.java:294) [org.springframework.beans-3.1.1.release.jar:3.1.1.release] at org.springframework.beans.factory.support.defaultsingletonbeanregistry.getsingleton(defaultsingletonbeanregistry.java:225) [org.springframework.beans-3.1.1.release.jar:3.1.1.release] at org.springframework.beans.factory.support.abstractbeanfactory.dogetbean(abstractbeanfactory.java:291) [org.springframework.beans-3.1.1.release.jar:3.1.1.release] at org.springframework.beans.factory.support.abstractbeanfactory.getbean(abstractbeanfactory.java:193) [org.springframework.beans-3.1.1.release.jar:3.1.1.release] at org.springframework.beans.factory.support.defaultlistablebeanfactory.preinstantiatesingletons(defaultlistablebeanfactory.java:567) [org.springframework.beans-3.1.1.release.jar:3.1.1.release] at org.springframework.context.support.abstractapplicationcontext.finishbeanfactoryinitialization(abstractapplicationcontext.java:913) [org.springframework.context-3.1.1.release.jar:3.1.1.release] at org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:464) [org.springframework.context-3.1.1.release.jar:3.1.1.release] at org.springframework.web.context.contextloader.configureandrefreshwebapplicationcontext(contextloader.java:385) [org.springframework.web-3.1.1.release.jar:3.1.1.release] at org.springframework.web.context.contextloader.initwebapplicationcontext(contextloader.java:284) [org.springframework.web-3.1.1.release.jar:3.1.1.release] at org.springframework.web.context.contextloaderlistener.contextinitialized(contextloaderlistener.java:111) [org.springframework.web-3.1.1.release.jar:3.1.1.release] at org.apache.catalina.core.standardcontext.contextlistenerstart(standardcontext.java:3392) [jbossweb-7.0.13.final.jar:] at org.apache.catalina.core.standardcontext.start(standardcontext.java:3850) [jbossweb-7.0.13.final.jar:] at org.jboss.as.web.deployment.webdeploymentservice.start(webdeploymentservice.java:90) [jboss-as-web-7.1.1.final.jar:7.1.1.final] at org.jboss.msc.service.servicecontrollerimpl$starttask.startservice(servicecontrollerimpl.java:1811) at org.jboss.msc.service.servicecontrollerimpl$starttask.run(servicecontrollerimpl.java:1746) at java.util.concurrent.threadpoolexecutor$worker.runtask(threadpoolexecutor.java:895) [rt.jar:1.6.0_45] at java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor.java:918) [rt.jar:1.6.0_45] at java.lang.thread.run(thread.java:662) [rt.jar:1.6.0_45] caused by:javax.naming.namenotfoundexception: sinosoftdatasource -- service jboss.naming.context.java.sinosoftdatasource at org.jboss.as.naming.servicebasednamingstore.lookup(servicebasednamingstore.java:97) at org.jboss.as.naming.namingcontext.lookup(namingcontext.java:178) at org.jboss.as.naming.initialcontext.lookup(initialcontext.java:113) at org.jboss.as.naming.namingcontext.lookup(namingcontext.java:214) at javax.naming.initialcontext.lookup(initialcontext.java:392) [rt.jar:1.6.0_45] at org.springframework.jndi.jnditemplate$1.doincontext(jnditemplate.java:154) [org.springframework.context-3.1.1.release.jar:3.1.1.release] at org.springframework.jndi.jnditemplate.execute(jnditemplate.java:87) [org.springframework.context-3.1.1.release.jar:3.1.1.release] at org.springframework.jndi.jnditemplate.lookup(jnditemplate.java:152) [org.springframework.context-3.1.1.release.jar:3.1.1.release] at org.springframework.jndi.jnditemplate.lookup(jnditemplate.java:178) [org.springframework.context-3.1.1.release.jar:3.1.1.release] at org.springframework.jndi.jndilocatorsupport.lookup(jndilocatorsupport.java:95) [org.springframework.context-3.1.1.release.jar:3.1.1.release] at org.springframework.jndi.jndiobjectlocator.lookup(jndiobjectlocator.java:105) [org.springframework.context-3.1.1.release.jar:3.1.1.release] at org.springframework.jndi.jndiobjectfactorybean.lookupwithfallback(jndiobjectfactorybean.java:201) [org.springframework.context-3.1.1.release.jar:3.1.1.release] at org.springframework.jndi.jndiobjectfactorybean.afterpropertiesset(jndiobjectfactorybean.java:187) [org.springframework.context-3.1.1.release.jar:3.1.1.release] at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.invokeinitmethods(abstractautowirecapablebeanfactory.java:1514) [org.springframework.beans-3.1.1.release.jar:3.1.1.release] at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.initializebean(abstractautowirecapablebeanfactory.java:1452) [org.springframework.beans-3.1.1.release.jar:3.1.1.release] ... 20 more 19:02:28,807 error [org.apache.catalina.core.containerbase.[jboss.web].[default-host].[/]] (msc service thread 1-5) exception sending context initialized event to listener instance of class org.springframework.web.context.contextloaderlistener:org.springframework.beans.factory.beancreationexception: error creating bean with name 'datasource' defined in servletcontext resource [/web-inf/app-config-context.xml]: invocation of init method failed; nested exception isjavax.naming.namenotfoundexception: sinosoftdatasource -- service jboss.naming.context.java.sinosoftdatasource at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.initializebean(abstractautowirecapablebeanfactory.java:1455) [org.springframework.beans-3.1.1.release.jar:3.1.1.release] at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.docreatebean(abstractautowirecapablebeanfactory.java:519) [org.springframework.beans-3.1.1.release.jar:3.1.1.release] at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.createbean(abstractautowirecapablebeanfactory.java:456) [org.springframework.beans-3.1.1.release.jar:3.1.1.release] at org.springframework.beans.factory.support.abstractbeanfactory$1.getobject(abstractbeanfactory.java:294) [org.springframework.beans-3.1.1.release.jar:3.1.1.release] at org.springframework.beans.factory.support.defaultsingletonbeanregistry.getsingleton(defaultsingletonbeanregistry.java:225) [org.springframework.beans-3.1.1.release.jar:3.1.1.release] at org.springframework.beans.factory.support.abstractbeanfactory.dogetbean(abstractbeanfactory.java:291) [org.springframework.beans-3.1.1.release.jar:3.1.1.release] at org.springframework.beans.factory.support.abstractbeanfactory.getbean(abstractbeanfactory.java:193) [org.springframework.beans-3.1.1.release.jar:3.1.1.release] at org.springframework.beans.factory.support.defaultlistablebeanfactory.preinstantiatesingletons(defaultlistablebeanfactory.java:567) [org.springframework.beans-3.1.1.release.jar:3.1.1.release] at org.springframework.context.support.abstractapplicationcontext.finishbeanfactoryinitialization(abstractapplicationcontext.java:913) [org.springframework.context-3.1.1.release.jar:3.1.1.release] at org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:464) [org.springframework.context-3.1.1.release.jar:3.1.1.release] at org.springframework.web.context.contextloader.configureandrefreshwebapplicationcontext(contextloader.java:385) [org.springframework.web-3.1.1.release.jar:3.1.1.release] at org.springframework.web.context.contextloader.initwebapplicationcontext(contextloader.java:284) [org.springframework.web-3.1.1.release.jar:3.1.1.release] at org.springframework.web.context.contextloaderlistener.contextinitialized(contextloaderlistener.java:111) [org.springframework.web-3.1.1.release.jar:3.1.1.release] at org.apache.catalina.core.standardcontext.contextlistenerstart(standardcontext.java:3392) [jbossweb-7.0.13.final.jar:] at org.apache.catalina.core.standardcontext.start(standardcontext.java:3850) [jbossweb-7.0.13.final.jar:] at org.jboss.as.web.deployment.webdeploymentservice.start(webdeploymentservice.java:90) [jboss-as-web-7.1.1.final.jar:7.1.1.final] at org.jboss.msc.service.servicecontrollerimpl$starttask.startservice(servicecontrollerimpl.java:1811) at org.jboss.msc.service.servicecontrollerimpl$starttask.run(servicecontrollerimpl.java:1746) at java.util.concurrent.threadpoolexecutor$worker.runtask(threadpoolexecutor.java:895) [rt.jar:1.6.0_45] at java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor.java:918) [rt.jar:1.6.0_45] at java.lang.thread.run(thread.java:662) [rt.jar:1.6.0_45] caused by:javax.naming.namenotfoundexception: sinosoftdatasource -- service jboss.naming.context.java.sinosoftdatasource at org.jboss.as.naming.servicebasednamingstore.lookup(servicebasednamingstore.java:97) at org.jboss.as.naming.namingcontext.lookup(namingcontext.java:178) at org.jboss.as.naming.initialcontext.lookup(initialcontext.java:113) at org.jboss.as.naming.namingcontext.lookup(namingcontext.java:214) at javax.naming.initialcontext.lookup(initialcontext.java:392) [rt.jar:1.6.0_45] at org.springframework.jndi.jnditemplate$1.doincontext(jnditemplate.java:154) [org.springframework.context-3.1.1.release.jar:3.1.1.release] at org.springframework.jndi.jnditemplate.execute(jnditemplate.java:87) [org.springframework.context-3.1.1.release.jar:3.1.1.release] at org.springframework.jndi.jnditemplate.lookup(jnditemplate.java:152) [org.springframework.context-3.1.1.release.jar:3.1.1.release] at org.springframework.jndi.jnditemplate.lookup(jnditemplate.java:178) [org.springframework.context-3.1.1.release.jar:3.1.1.release] at org.springframework.jndi.jndilocatorsupport.lookup(jndilocatorsupport.java:95) [org.springframework.context-3.1.1.release.jar:3.1.1.release] at org.springframework.jndi.jndiobjectlocator.lookup(jndiobjectlocator.java:105) [org.springframework.context-3.1.1.release.jar:3.1.1.release] at org.springframework.jndi.jndiobjectfactorybean.lookupwithfallback(jndiobjectfactorybean.java:201) [org.springframework.context-3.1.1.release.jar:3.1.1.release] at org.springframework.jndi.jndiobjectfactorybean.afterpropertiesset(jndiobjectfactorybean.java:187) [org.springframework.context-3.1.1.release.jar:3.1.1.release] at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.invokeinitmethods(abstractautowirecapablebeanfactory.java:1514) [org.springframework.beans-3.1.1.release.jar:3.1.1.release] at org.springframework.beans.factory.support.abstractautowirecapablebeanfactory.initializebean(abstractautowirecapablebeanfactory.java:1452) [org.springframework.beans-3.1.1.release.jar:3.1.1.release] ... 20 more
step:3
几番周折最终部署成功 最终的配置文件
1）applicationcontext.xml
<beanid="datasource"class="org.springframework.jndi.jndiobjectfactorybean"> <propertyname="jndiname"> <value>java:jboss/datasources/test</value> </property> </bean>
2)module.xml
<module xmlns="urn:jboss:module:1.0" name="com.oracle.jdbc"> <resources> <resource-root path="ojdbc6.jar"/> </resources> <dependencies> <module name="javax.api"/> <module name="javax.transaction.api"/> <module name="javax.servlet.api" optional="true"/> </dependencies> </module>
3)standalone.xml
<datasources> <datasource jta="true" jndi-name="java:jboss/datasources/test" pool-name="test" enabled="true" use-java-context="false"> <connection-url>jdbc:oracle:thin:@localhost:1521:orcl</connection-url> <driver>oracle</driver> <pool> <min-pool-size>3</min-pool-size> <max-pool-size>10</max-pool-size> </pool> <security> <user-name>scott</user-name> <password>tiger</password> </security> </datasource> <drivers> <!-- <driver name="mysql" module="com.mysql"> <driver-class>com.mysql.jdbc.driver</driver-class> <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.mysqlxadatasource </xa-datasource-class> </driver>--> <driver name="oracle" module="com.oracle.jdbc"> <driver-class>oracle.jdbc.driver.oracledriver</driver-class> <xa-datasource-class>oracle.jdbc.xa.client.oraclexadatasource</xa-datasource-class> </driver> </drivers> </datasources>
4)web.xml
<resource-ref> <res-ref-name>test</res-ref-name> <res-type>javax.sql.datasource</res-type> <res-auth>container</res-auth> <lookup-name>java:jboss/datasources/test</lookup-name> </resource-ref> <context-param> <param-name>contextconfiglocation</param-name> <param-value>/web-inf/applicationcontext.xml</param-value> </context-param>
以上就是服务器-jboss7.1.1 as final与mysql5.7.16的配置的内容。