期望大神帮忙解决数据库连接问题，谢谢

[kevinzha]

请求到的instance实例类为：com.sunyard.csr.action.LoginOutAction@16891f0
----------signType________--------------------------signin
[INFO ] 2014-05-29 00:15:45 method: org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:315)
Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
[INFO ] 2014-05-29 00:15:45 method: org.springframework.jdbc.support.SQLErrorCodesFactory.<init>(SQLErrorCodesFactory.java:126)
SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
[WARN ] 2014-05-29 00:15:45 method: org.springframework.jdbc.support.SQLErrorCodesFactory.getErrorCodes(SQLErrorCodesFactory.java:227)
Error while extracting database product name - falling back to empty error codes
org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:296)
at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:320)
at org.springframework.jdbc.support.SQLErrorCodesFactory.getErrorCodes(SQLErrorCodesFactory.java:214)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.setDataSource(SQLErrorCodeSQLExceptionTranslator.java:140)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.<init>(SQLErrorCodeSQLExceptionTranslator.java:103)
at org.springframework.jdbc.support.JdbcAccessor.getExceptionTranslator(JdbcAccessor.java:99)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:206)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:296)
at com.sunyard.csr.dao.SqlExecuteDao.queryListSqlInfo(SqlExecuteDao.java:83)
at com.sunyard.csr.service.CSRBusinessService.queryListSqlInfo(CSRBusinessService.java:88)
at com.sunyard.csr.iface.SecuSignOnImpl.getUserInfoByUserIdPswd(SecuSignOnImpl.java:59)
at com.sunyard.csr.action.LoginOutAction.signInAgent(LoginOutAction.java:54)
at com.sunyard.csr.action.LoginOutAction.execute(LoginOutAction.java:30)
at com.sunyard.struts.RequestProcessor.process(RequestProcessor.java:80)
at com.sunyard.struts.ActionServlet.process(ActionServlet.java:76)
at com.sunyard.struts.ActionServlet.doPost(ActionServlet.java:86)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1452)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:224)
at $Proxy4.getMetaData(Unknown Source)
at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:285)
... 29 more
Caused by: java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)
at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:476)
at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)
at java.sql.DriverManager.getDriver(DriverManager.java:253)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1437)
... 35 more
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
--- The error occurred in com/sunyard/csr/dao/xml/tb_sso_oper.xml.
--- The error occurred while executing query.
--- Check the select * from tb_sso_oper where 1 = 1 and logincode = ? .
--- Check the SQL Statement (preparation failed).

[kevinzha]

在D:\Tomcat 6.0\conf\Catalina\localhost目录下建一个文件webagent.xml；配置如下： <?xml version='1.0' encoding='utf-8'?> <Context displayName="webagent" docBase="E:\sunyardwork\csrcbank\csrSystem\WebRoot" path="/webagent" reloadable="true"> <Resource name="jdbc/newAgent" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/newAgent"> <parameter> <name>url</name> <value>jdbc:oracle:thin:@127.0.0.1:1521:agentdb</value> </parameter> <parameter> <name>username</name> <value>agent</value> </parameter> <parameter> <name>password</name> <value>agent</value> </parameter> <parameter> <name>maxActive</name> <value>20</value> </parameter> <parameter> <name>maxWait</name> <value>5000</value> </parameter> <parameter> <name>driverClassName</name> <value>oracle.jdbc.driver.OracleDriver</value> </parameter> <parameter> <name>maxIdle</name> <value>10</value> </parameter> </ResourceParams> <Manager className="org.apache.catalina.session.PersistentManager" saveOnRestart="false"> <Store className="org.apache.catalina.session.FileStore" /> </Manager> </Context> ==========================================================================

[kevinzha]

applicationContext.xml配置如下 <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"> <beans> <bean id="dataSource1" class="org.springframework.jndi.JndiObjectFactoryBean"> <property name="jndiName"> <value>java:comp/env/jdbc/newAgent</value> </property> </bean> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource1" /> </bean> <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"> <property name="dataSource" ref="dataSource1" /> <property name="configLocation" value="WEB-INF/sql-map-config.xml" /> </bean> <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"> <constructor-arg> <ref bean="dataSource1" /> </constructor-arg> </bean> <bean id="sqlExecuteDao" class="com.sunyard.csr.dao.SqlExecuteDao"> <property name="sqlMapClient" ref="sqlMapClient" /> </bean> <bean id="secuSignOn" class="com.sunyard.csr.iface.SecuSignOnImpl"> <property name="csrBusinessService" ref="csrBusinessService" /> </bean> <bean id="tradeSpec" class="com.sunyard.tl.business.EtpSpecialTradeBusiness"> </bean> <bean id="ctievent" class="com.sunyard.tl.business.CtiEventBusiness"> </bean> <bean id="csrBusinessService" class="com.sunyard.csr.service.CSRBusinessService"> <property name="sqlExecuteDao" ref="sqlExecuteDao" /> <property name="secuSignOn" ref="secuSignOn" /> <property name="ctievent" ref="ctievent" /> </bean> <!-- <bean id="baseAction" class="com.sunyard.csr.action.BaseAction"> <property name="csrBusinessService" ref="csrBusinessService" /> </bean> --> </beans>

[kevinzha]

web.xml配置如下： <?xml version="1.0" encoding="UTF-8"?> <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"> <context-param> <param-name>contextConfigLocation</param-name> <param-value>/WEB-INF/applicationContext.xml</param-value> </context-param> <context-param> <param-name>webAppRootKey</param-name> <param-value>newAgent.root</param-value> </context-param> <context-param> <param-name>log4jConfigLocation</param-name> <param-value>/WEB-INF/log4j.properties</param-value> </context-param> <context-param> <param-name>DATASOURCE_URL</param-name> <param-value>java:comp/env/jdbc/newAgent</param-value> </context-param> <filter> <filter-name>encodingFilter</filter-name> <filter-class> org.springframework.web.filter.CharacterEncodingFilter </filter-class> <init-param> <param-name>encoding</param-name> <param-value>UTF-8</param-value> </init-param> </filter> <listener> <listener-class> org.springframework.web.context.ContextLoaderListener </listener-class> </listener> <!-- Spring 刷新Introspector防止内存泄露 --> <listener> <listener-class> org.springframework.web.util.IntrospectorCleanupListener </listener-class> </listener> <listener> <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class> </listener> <!--sunyard Action controller--> <servlet> <servlet-name>action</servlet-name> <servlet-class>com.sunyard.struts.ActionServlet</servlet-class> <load-on-startup>1</load-on-startup> </servlet> <servlet> <description>系统初始化类库</description> <servlet-name>appInit</servlet-name> <servlet-class> com.sunyard.csr.common.AppInitServlet </servlet-class> <load-on-startup>2</load-on-startup> </servlet> <servlet> <servlet-name>secuSignOnService</servlet-name> <servlet-class>com.sunyard.csr.service.SecuSignOnService</servlet-class> </servlet> <session-config> <session-timeout>540</session-timeout> </session-config> <servlet-mapping> <servlet-name>action</servlet-name> <url-pattern>*.do</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>secuSignOnService</servlet-name> <url-pattern>/secuSignOnService</url-pattern> </servlet-mapping> <!--dwr config start--> <servlet> <servlet-name>dwr-invoker</servlet-name> <servlet-class> org.directwebremoting.servlet.DwrServlet </servlet-class> <init-param> <param-name>crossDomainSessionSecurity</param-name> <param-value>false</param-value> </init-param> <init-param> <param-name>allowScriptTagRemoting</param-name> <param-value>true</param-value> </init-param> <init-param> <param-name>classes</param-name> <param-value>java.lang.Object</param-value> </init-param> <init-param> <param-name>activeReverseAjaxEnabled</param-name> <param-value>true</param-value> </init-param> <init-param> <param-name>initApplicationScopeCreatorsAtStartup</param-name> <param-value>true</param-value> </init-param> <init-param> <param-name>maxWaitAfterWrite</param-name> <param-value>-1</param-value> </init-param> <init-param> <param-name>org.directwebremoting.extend.ServerLoadMonitor</param-name> <param-value>org.directwebremoting.impl.PollingServerLoadMonitor</param-value> </init-param> <init-param> <param-name>disconnectedTime</param-name> <param-value>30000</param-value> </init-param> <init-param> <param-name>debug</param-name> <param-value>true</param-value> </init-param> <init-param> <param-name>logLevel</param-name> <param-value>WARN</param-value> </init-param> </servlet> <servlet-mapping> <servlet-name>dwr-invoker</servlet-name> <url-pattern>/dwr/*</url-pattern> </servlet-mapping> <!-- dwr config end--> <welcome-file-list> <welcome-file>login.jsp</welcome-file> </welcome-file-list> <error-page> <error-code>403</error-code> <location>/error.html</location> </error-page> <login-config> <auth-method>BASIC</auth-method> </login-config> <resource-ref> <description>DB Connection</description> <res-ref-name>jdbc/newAgent</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> <!-- 质检系统角色类型定义 --> <!-- 普通座席 --> <context-param> <param-name>zx_role</param-name> <param-value>qcstaff</param-value> </context-param> <!-- 质检员 --> <context-param> <param-name>monitorRole</param-name> <param-value>operator</param-value> </context-param> <!-- 质检主管 --> <context-param> <param-name>zjMonitorRole</param-name> <param-value>governor</param-value> </context-param> </web-app>

[feiandsha]

文件配置贴出来来看看。

[feiandsha1]

2014-05-29 00:31:27的妹子，你不累阿。

[kevinzha]

请大神帮忙，这是什么问题啊

[BUG胡汉三]

第一个错误就已经告诉，获取数据库连接信息错误了，获取到空值： Error while extracting database product name - falling back to empty error codes 获取数据库连接的时候为null： Cannot create JDBC driver of class '' for connect URL 'null' 请参考jndi的数据源配置： http://wenku.baidu.com/link?url=crnzBPwmbr4fcYg8Fd4ScsP-cHdaNBxnfNqjDqdYXpigvAsNedITjXaugnEz2NeYKZA5Xtvk1B5vDGzvjlSwlWE__t-wHEa-R0wrthriacq