hibernate4中HHH000273的错误
来源:互联网 发布:it认证培训课程 编辑:程序博客网 时间:2024/06/05 01:04
今天配置hibernate4,发现报
17:55:06,815 INFO AbstractPoolBackedDataSource:522 - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge16q9a8u2d4lyv35wl|5a6efc31, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge16q9a8u2d4lyv35wl|5a6efc31, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:oracle:thin:@192.168.1.229:1521:WDRPT, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 5, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 20, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 2, numHelperThreads -> 3, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ] 17:55:07,741 WARN TypeInfo:126 - HHH000273: Error accessing type info result set : java.sql.SQLException: 数字溢出
数字溢出,搜了一下,都说映射文件错误了,我把所有配置的映射文件都去掉,还是报错,跟代码一下,是c3p0的获取meta的问题
public static LinkedHashSet<TypeInfo> extractTypeInfo(DatabaseMetaData metaData) {final LinkedHashSet<TypeInfo> typeInfoSet = new LinkedHashSet<TypeInfo>();try {final ResultSet resultSet = metaData.getTypeInfo();try {while ( resultSet.next() ) {typeInfoSet.add(new TypeInfo(resultSet.getString( "TYPE_NAME" ),resultSet.getInt( "DATA_TYPE" ),interpretCreateParams( resultSet.getString( "CREATE_PARAMS" ) ),resultSet.getBoolean( "UNSIGNED_ATTRIBUTE" ),resultSet.getInt( "PRECISION" ),//commend by danielinbiti,blob字段时,这个数字超出了int的范围,用long是能够获取的resultSet.getShort( "MINIMUM_SCALE" ),resultSet.getShort( "MAXIMUM_SCALE" ),resultSet.getBoolean( "FIXED_PREC_SCALE" ),resultSet.getString( "LITERAL_PREFIX" ),resultSet.getString( "LITERAL_SUFFIX" ),resultSet.getBoolean( "CASE_SENSITIVE" ),TypeSearchability.interpret( resultSet.getShort( "SEARCHABLE" ) ),TypeNullability.interpret( resultSet.getShort( "NULLABLE" ) )));}}catch ( SQLException e ) {LOG.unableToAccessTypeInfoResultSet( resultSet.getString( "TYPE_NAME" )+","+resultSet.getInt( "DATA_TYPE" ) );LOG.unableToAccessTypeInfoResultSet( e.toString() );}finally {try {resultSet.close();}catch ( SQLException e ) {LOG.unableToReleaseTypeInfoResultSet();}}}catch ( SQLException e ) {LOG.unableToRetrieveTypeInfoResultSet( e.toString() );}return typeInfoSet;}于是,修改了一下该类
public static LinkedHashSet<TypeInfo> extractTypeInfo(DatabaseMetaData metaData) {final LinkedHashSet<TypeInfo> typeInfoSet = new LinkedHashSet<TypeInfo>();try {final ResultSet resultSet = metaData.getTypeInfo();try {while ( resultSet.next() ) {long precision = resultSet.getLong( "PRECISION" );//add by danielinbitiint int_p = precision>Integer.MAX_VALUE?Integer.MAX_VALUE:(int)precision;//add by danielinbiti,这么修改反正基于目前该方法的逻辑是没问题的。typeInfoSet.add(new TypeInfo(resultSet.getString( "TYPE_NAME" ),resultSet.getInt( "DATA_TYPE" ),interpretCreateParams( resultSet.getString( "CREATE_PARAMS" ) ),resultSet.getBoolean( "UNSIGNED_ATTRIBUTE" ),int_p,resultSet.getShort( "MINIMUM_SCALE" ),resultSet.getShort( "MAXIMUM_SCALE" ),resultSet.getBoolean( "FIXED_PREC_SCALE" ),resultSet.getString( "LITERAL_PREFIX" ),resultSet.getString( "LITERAL_SUFFIX" ),resultSet.getBoolean( "CASE_SENSITIVE" ),TypeSearchability.interpret( resultSet.getShort( "SEARCHABLE" ) ),TypeNullability.interpret( resultSet.getShort( "NULLABLE" ) )));}}catch ( SQLException e ) {LOG.unableToAccessTypeInfoResultSet( e.toString() );}finally {try {resultSet.close();}catch ( SQLException e ) {LOG.unableToReleaseTypeInfoResultSet();}}}catch ( SQLException e ) {LOG.unableToRetrieveTypeInfoResultSet( e.toString() );}return typeInfoSet;}
0 0
- hibernate4中HHH000273的错误
- Spring3和Hibernate4整合的错误
- hibernate4.0中SessionFactory的创建
- Hibernate4中获取SessionFactory的方法
- hibernate4中对象的四种状态
- hibernate4.0中SessionFactory的创建
- Hibernate4中生成session的变化
- hibernate4.3中SessionFactory的创建
- hibernateUtil中hibernate3和hibernate4的区别
- hibernate4中取得connection的方法
- spirng3+hibernate4+blazeds4错误
- hibernate4.3.5 Annotation错误
- 今天学习hibernate4与spring4 的整合的错误解决
- Hibernate4.3 常见错误整理
- hibernate4.0 中buildSessionFactory()
- Hibernate4中获取SessionFactory
- 初次整合Hibernate4和Spring4中出现的细节问题
- SpringMVC4、Hibernate4整合过程中出现的问题
- PHP防止页面刷新重复提交数据
- js 分享qq空间,新浪微博,qq
- 关于Android的语言适配
- 验证码识别实践1:自己动手C#实现
- jni 移植 JNI环境变量char, jstring 的相互转化
- hibernate4中HHH000273的错误
- android HH不能格式化时间的问题
- WebService学习笔记5——AXIS2基础
- 评分插件 jQuery raty的使用
- Linux——文件查找
- 怎么将Eclipse 项目切换到Android Studio
- 一致性 hash 算法( consistent hashing )
- 广播服务
- 验证码识别实践2:自己动手C#实现,对CSDN资源上传验证码识别率100%,久游网登陆90%