大家帮我看个错误，用spring+hibernate连数据源的

[dcbeyond]

信息: Jk running ID=0 time=0/47 config=null
2009-11-19 12:46:02 org.apache.catalina.startup.Catalina start
信息: Server startup in 16207 ms
zrk 12345
2009-11-19 12:46:20 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet ManageServlet threw exception
org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
at org.hibernate.loader.Loader.doQuery(Loader.java:673)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at com.company.DButil.getInfo(DButil.java:31)
at com.company.ManageServlet.doPost(ManageServlet.java:46)
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 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
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.createDataSource(BasicDataSource.java:1150)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:82)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
... 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.createDataSource(BasicDataSource.java:1143)
... 32 more

server.xml
web.xml
还有applicationContext.xml中都配过了
在进入登陆页面连数据库时出错

[夏日旋风里的小原子]

很明显，是你的链接打不开，有可能是connect URL没有设置

[zl3450341]

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' 

url写错了？
看看你的url怎么写的

[la_77]

必须按照JDBC的方式写!

String driverNameString="com.mysql.jdbc.Driver";  //mysql 驱动
			Class.forName(driverNameString);  
			String url="jdbc:mysql://localhost:3306/test";  //mysql url
			String username="root";  
			String pwd="";
			con=DriverManager.getConnection(url,username,pwd);

[wifewifewife]

这个问题分很多种.
1.你是什么数据库?sql2000打了sp2没有?
2.数据库名对了没有?
3.jdbc驱动正确没有?最好自己写一个数据库连接测试.
4.tomcat是哪个版本的.如果是tomcat6的话,<context></context>里面设置是否正确.
比如下面这些:

<Resource name="jdbc/planetprod" auth="Container"	
		type="javax.sql.DataSource" username="postgres"
		password="dummypwd" driverClassName="org.postgresql.Driver"
		url="jdbc:postgresql:hk_mars" maxActive="18" maxIdle="14" />

这个有的不用设置的.
5.如果4要设置的话.这个对了没有?

url="jdbc:postgresql:hk_mars"//这是数据库名.

6.你这个问题说得不清不楚,不知道怎么回答.
只能帮你回答到这里吧.

[wifewifewife]

[Quote=引用 2 楼 zl3450341 的回复:]
Java codeorg.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver ofclass''for connect URL'null'

url写错了？
看看你的url怎么写的
[/Quote]
就凭这一句,还不能断定是url写错了呢.

[wifewifewife]

[Quote=引用 3 楼 la_77 的回复:]
必须按照JDBC的方式写!
[/Quote]
你怎么知道他是用mysql的?

[海A天空]

应该是URL的问题...

[daihui05]

把你的jdbc驱动放在%Tomcat—HOME%\common\lib下

[sl514]

驱动语句 数据库连接语句 等等没配置或没找到

[shadow55]

null URL

[dcbeyond]

我估计原因是这样的。我用的是myeclipse带的tomcat，但是配置文件是在tomcat下配的，所以即便配好了配置文件，也没有起到作用

[sangshusen_1988]

最好别用MyEclipse自带的tomcat，去下个压缩版的tomcat，集成进来也挺方便的