来项目内用的是普通数据源.考虑没有分布式的数据访问.就使用了apache-commons-dbcp.但是后来项目内要加一个第三方的报表制作工具.该工具强制要求使用JNDI来获得连接(该死的)没办法.只有加了.显将配置步骤和一个错误做笔记如下:
1. 环境: windowsXp系统.使用的是JBossGA-4.2.2 sqlserver2000.
项目架构是 Spring+ibatis+struts.
2. 配置步骤1 . 由于JBoss会自动查找server/default/deploy目录下的 **-ds.xml文件.并读取其中内容.来得到相应的DataSource,我的文件具体内容如下:
jdbc/DataSource jdbc:jtds:sqlserver://localhost:1433/fnx net.sourceforge.jtds.jdbc.Driver sa 1234 MS SQLSERVER2000
配置步骤2 . (有部分内容来自网上) 由于使用spring来获取jndi.所以实现了FacToryBean, InitializingBean
get/set方法没加
public class DataSourceFacToryBean implements FacToryBean, InitializingBean {/** 缓存数据源对象 */private DataSource dataSource;/** 是否jndi数据源 */private boolean jndi;/** 数据源的名字(如果是jndi数据源) */private String jndiName;/** jdbc驱动类(非jndi的情况) */private String driverClassName;/** 数据库的url(非jndi的情况) */private String url;/** 用户名(非jndi的情况) */private String username;/** 密码(非jndi的情况) */private String password;public void afterPropertiesSet() throws Exception { if (this.isJndi()) { if (!org.springframework.util.StringUtils.hasText(this.jndiName)) { throw new IllegalArgumentException("jndiName is required"); } } else { if (!org.springframework.util.StringUtils .hasText(this.driverClassName)) { throw new IllegalArgumentException( "driverClassName is required"); } if (!org.springframework.util.StringUtils.hasText(this.url)) { throw new IllegalArgumentException("url is required"); } if (!org.springframework.util.StringUtils.hasText(this.username)) { throw new IllegalArgumentException("username is required"); } if (!org.springframework.util.StringUtils.hasText(this.password)) { throw new IllegalArgumentException("password is required"); } } // 在初始化时就创建数据源 this.createDataSource();}public Object getObject() throws Exception { DataSource ds = this.createDataSource(); return ds;}public Class getObjectType() { return javax.sql.DataSource.class;}public boolean isSingleton() { return true;}protected DataSource createDataSource() { DataSource ds = this.dataSource; if (ds == null) { try { if (this.isJndi()) { ds = new JndiDataSourceSupport() .lookupDataSource(this.jndiName); } else { ds = new DriverManagerDataSource(driverClassName, url, username, password); } } catch (Throwable err) { throw new RuntimeException(err); } } this.dataSource = ds; return ds;}private class JndiDataSourceSupport extends JndiLocaTorSupport { public DataSource lookupDataSource(String jndiName) throws NamingException { return (DataSource) super.lookup(jndiName,getObjectType()); }}}
配置步骤3. spring的配置文件片段
class="org.springframework.beans.facTory.config.PropertyPlaceholderConfigurer"> classpath:config/jdbc.properties
设置步骤4 . jdbc.properties
#false 为开发时候使用的传统datasource 。为true为使用jndi得到datasource。建议开发时候使用前者
jdbc.IS_JNDI=truejdbc.jndiName=java:jdbc/DataSource#sqljdbc.driverClassName=net.sourceforge.jtds.jdbc.Driverjdbc.url=jdbc:jtds:sqlserver://localhost:1433/fnxjdbc.username=sajdbc.password=1234
设置步骤5 一些说明.上面绿色部分要相同.jndi的datasource采用的而是jdts.开始的时候总是有错.第一次无法的到连接.
刷新后就可以得到连接.百思不得其解.经过查找发现自己大意了.没有吧jdts的jar放在JBoss4.2.2GA/server/default/lib下面.解决和异常如下:
JBoss jndi jtds sqlserver2000 第一次错误得不到连接.然后刷新页面就ok的问题.
问题搞定.
就是jar没加对.
jdni属于容器的应该加在容器内.我们加载在项目内.当然第一次会出错.
然后第二次项目内的jar就会加载到容器你.所以就可用了.
应该在JBoss4.2.2GA/server/default/lib加数据库jar就可以了.
错误异常如下:
Throwable while attempting to get a new connection: null
org.JBoss.resource.JBossResourceException: Could not create connection; – nested throwable: (org.JBoss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: net.sourceforge.jtds.jdbc.Driver, url: jdbc:jtds:sqlserver://localhost:1433/fnx)
at org.JBoss.resource.adapter.jdbc.local.LocalManagedConnectionFacTory.createManagedConnection(LocalManagedConnectionFacTory.java:179)
at org.JBoss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:577)
at org.JBoss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:262)
at org.JBoss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:500)
at org.JBoss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341)
at org.JBoss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:315)
at org.JBoss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396)
at org.JBoss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
at org.JBoss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:182)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:322)
at org.springframework.transaction.intercepTor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:255)
at org.springframework.transaction.intercepTor.TransactionIntercepTor.invoke(TransactionIntercepTor.java:102)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
at $Proxy56.getUserByPassword(Unknown Source)
at com.thams.user.action.LoginAction.gotoLogin(LoginAction.java:43)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.thams.framework.action.BaseAction.dispatchMethod(BaseAction.java:205)
at com.thams.framework.action.BaseAction.execute(BaseAction.java:129)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.thams.framework.filter.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:58)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.JBoss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.JBoss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
at org.apache.catalina.authenticaTor.AuthenticaTorBase.invoke(AuthenticaTorBase.java:432)
at org.JBoss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.JBoss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connecTor.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.JBoss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: net.sourceforge.jtds.jdbc.Driver, url: jdbc:jtds:sqlserver://localhost:1433/fnx
at org.JBoss.resource.adapter.jdbc.local.LocalManagedConnectionFacTory.getDriver(LocalManagedConnectionFacTory.java:290)
at org.JBoss.resource.adapter.jdbc.local.LocalManagedConnectionFacTory.createManagedConnection(LocalManagedConnectionFacTory.java:170)
… 50 more
你不怕困难,困难就怕你。