hibernate 连接mysql问题

[wuenming]

hibernate配置文件中如下：
hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.connection.url=jdbc:mysql:///vms?useUnicode=true&characterEncoding=UTF8
hibernate.connection.username=root
hibernate.connection.password=
hibernate.connection.pool_size=1
#hibernate.show_sql=true
#hibernate.dbcp.maxActive=10
#hibernate.dbcp.whenExhaustedAction=1
#hibernate.dbcp.maxWait=120000
#hibernate.dbcp.maxIdle=5
#hibernate.dbcp.ps.maxActive=100
#hibernate.dbcp.ps.whenExhaustedAction=1
#hibernate.dbcp.ps.maxWait=120000
#hibernate.dbcp.ps.maxIdle=5
#hibernate.dbcp.validationQuery=select 1 from dual
#hibernate.dbcp.testOnBorrow=true
#hibernate.dbcp.testOnReturn=false
错误信息如下：
Caused by: net.sf.hibernate.JDBCException: Cannot open connection
at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:260)
at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3157)
at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3140)
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:61)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:703)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:184)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:132)
at net.sf.hibernate.loader.Loader.doList(Loader.java:949)
at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:109)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3440)
at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:177)
at com.intrint.vms.security.data.PartnerPeer.login(PartnerPeer.java:28)
... 42 more
Caused by: java.sql.SQLException: Communication link failure: Bad handshake
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:659)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1562)
at com.mysql.jdbc.Connection.<init>(Connection.java:491)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:95)
at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:257)
... 53 more



运行正常但是登陆时访问数据库的地方就会出错，怀疑是没有联上mysql可能是驱动问题，望高手关注，谢谢！另外寻找hibernate志同道合者。[e-mail]

[alexlex]

vms?useUnicode=true&characterEncoding=UTF8

--->vms?useUnicode=true&characterEncoding=UTF8

[niyboy]

hibernate.connection.url=jdbc:mysql:///vms?

这句错了；


改为：

hibernate.connection.url=jdbc:mysql://localhost:vms?

[ymm]

hibernate.connection.url=jdbc:mysql://localhost:vms?
楼上的说出答案了

[wuenming]

虽然你们说的我早试过了，不过仍然感谢你们的关注！
有其他的建议吗？我怀疑是驱动问题，环境变量中不知有哪些需要设置阿