hibernate 连接 db2 报错 但是jdbc却没有问题。

12:19:32 (Dialect.java:82) - Using dialect: net.sf.hibernate.dialect.GenericDialect
12:19:32 (SettingsFactory.java:62) - Use outer join fetching: false
12:19:32 (DBCPConnectionProvider.java:56) - DBCP using driver: null at URL: null
12:19:32 (DBCPConnectionProvider.java:57) - Connection properties: {}
12:19:32 (DBCPConnectionProvider.java:60) - No JDBC Driver class was specified by property hibernate.connection.driver_class
12:19:32 (DBCPConnectionProvider.java:89) - DBCP prepared statement pooling disabled
12:19:32 (TransactionManagerLookupFactory.java:33) - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
12:19:32 (SettingsFactory.java:95) - Could not obtain connection metadata
java.sql.SQLException: The url cannot be null
at java.sql.DriverManager.getConnection(DriverManager.java:489)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:51)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
at net.sf.hibernate.connection.DBCPConnectionProvider.getConnection(DBCPConnectionProvider.java:41)
at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1132)
at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:766)
at com.sinovatech.common.util.DBUtil.init(DBUtil.java:82)
at com.sinovatech.common.util.DBUtil.getSession(DBUtil.java:45)
at com.sinovatech.cms.model.bpo.CmsChannelBPO.findByID(CmsChannelBPO.java:289)
at com.sinovatech.cms.model.bpo.CmsChannelBPO.getClNoByClId(CmsChannelBPO.java:1033)
at com.sinovatech.bms.model.bpo.BmsDeptBPO.main(BmsDeptBPO.java:378)
12:19:32 (SettingsFactory.java:102) - Use scrollable result sets: false
12:19:32 (SettingsFactory.java:105) - Use JDBC3 getGeneratedKeys(): false
12:19:32 (SettingsFactory.java:108) - Optimize cache for minimal puts: false
12:19:32 (SettingsFactory.java:114) - echoing all SQL to stdout

7 个解决方案

#1

jdbc连接却没有问题，能够直接把数据库的数据显示出来。
hibernate 配置文件
        <!-- ibm db2 -->
<property name="dialect">org.hibernate.dialect.DB2Dialect</property>
<property name="dscp.driverClassName">com.ibm.db2.jcc.DB2Driver</property>
        <property name="dscp.url">jdbc:db2://192.168.2.127:50000/gxyd</property>    
        <property name="dscp.username">db2admin</property>
        <property name="dscp.password">db2admin</property>

#2

	<property name="dialect">org.hibernate.dialect.DB2Dialect</property>
	<property name="connection.url">jdbc:db2://192.168.2.127:50000/gxyd</property>
	<property name="connection.username">db2admin</property>
	<property name="connection.password">db2admin</property>
	<property name="connection.driver_class">com.ibm.db2.jcc.DB2Driver</property>

#3

试过了还是不行。

#4

支持的类包有没有导入

#5

谢谢，解决了。是我把调用name写错了。

#6

支持搂主，收藏

#7

以后需再关注，现在先帮你顶一下

#8

• spring和hibernate指定DB2数据库schema的方法