Problem with Hibernate/Spring/Postgres configuraiton

From: Gerald Rosenberg <gerald(at)certiv(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Problem with Hibernate/Spring/Postgres configuraiton
Date: 2008-10-05 17:14:29
Message-ID: 200810051714.m95HEP1b016972@zinc.newtechlaw.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


Converting an existing Hibernate/Spring/Oracle application over to
using Postgres. Changed the JDBC driver and data source, but now
hitting an error that does not appear reported in any of the
hibernate or postgres forums.

In trying to do a simple insert, I am getting:

ERROR org.hibernate.util.JDBCExceptionReporter - Method
org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int) is
not yet implemented.

The relevant configuration is:

<!-- DataSource Setup -->
<bean id="pgDataSource"
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="org.postgresql.Driver"/>
<property name="url" value="jdbc:postgresql://localhost:5432/postgres" />
<property name="username" value="postgres" />
<property name="password" value="postgres" />
</bean>

Don't see any way to tell Dbcp or Hibernate not to use query timeouts
-- seems to be part of the standard. Would appreciate your pointing
me to the source of the problem.

Thanks...

(full error trace/ERROR near the bottom)

2008-10-04 14:40:02,781 [http-8080-1]
INFO org.hibernate.connection.DriverManagerConnectionProvider -
Using Hibernate built-in connection pool (not for production use!)
2008-10-04 14:40:02,781 [http-8080-1]
INFO org.hibernate.connection.DriverManagerConnectionProvider -
Hibernate connection pool size: 20
2008-10-04 14:40:02,781 [http-8080-1]
INFO org.hibernate.connection.DriverManagerConnectionProvider -
autocommit mode: false
2008-10-04 14:40:02,781 [http-8080-1]
INFO org.hibernate.connection.DriverManagerConnectionProvider -
using driver: org.postgresql.Driver at URL:
jdbc:postgresql://localhost:5432/postgres
2008-10-04 14:40:02,781 [http-8080-1]
INFO org.hibernate.connection.DriverManagerConnectionProvider -
connection properties: {user=postgres, password=****}
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - RDBMS: PostgreSQL, version: 8.3.4
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - JDBC driver: PostgreSQL
Native Driver, version: PostgreSQL 8.3 JDBC4 with SSL (build 603)
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.dialect.Dialect - Using dialect:
org.hibernate.dialect.PostgreSQLDialect
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.transaction.TransactionFactoryFactory -
Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.transaction.TransactionManagerLookupFactory - No
TransactionManagerLookup configured (in JTA environment, use of
read-write or transactional second-level cache is not recommended)
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - Automatic flush during
beforeCompletion(): disabled
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - Automatic session close at
end of transaction: disabled
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - JDBC batch size: 15
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - JDBC batch updates for
versioned data: disabled
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - Scrollable result sets: enabled
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): disabled
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - Connection release mode: auto
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - Default schema: certiv
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - Order SQL updates by
primary key: disabled
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - Order SQL inserts for
batching: disabled
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - Query translator:
org.hibernate.hql.ast.ASTQueryTranslatorFactory
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using
ASTQueryTranslatorFactory
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - JPA-QL strict compliance: disabled
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - Query cache: disabled
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - Cache provider:
org.hibernate.cache.NoCacheProvider
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - Optimize cache for minimal
puts: disabled
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - Structured second-level
cache entries: disabled
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - Statistics: disabled
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - Deleted entity synthetic
identifier rollback: disabled
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
2008-10-04 14:40:02,859 [http-8080-1]
INFO org.hibernate.cfg.SettingsFactory - Named query checking : enabled
2008-10-04 14:40:02,875 [http-8080-1]
INFO org.hibernate.impl.SessionFactoryImpl - building session factory
2008-10-04 14:40:03,406 [http-8080-1]
INFO org.hibernate.impl.SessionFactoryObjectFactory - Not binding
factory to JNDI, no JNDI name configured
2008-10-04 14:40:03,421 [http-8080-1]
INFO org.hibernate.tool.hbm2ddl.SchemaUpdate - Running hbm2ddl schema update
2008-10-04 14:40:03,421 [http-8080-1]
INFO org.hibernate.tool.hbm2ddl.SchemaUpdate - fetching database metadata
2008-10-04 14:40:03,906 [http-8080-1]
INFO org.hibernate.tool.hbm2ddl.SchemaUpdate - updating schema
2008-10-04 14:40:04,703 [http-8080-1]
INFO org.hibernate.tool.hbm2ddl.TableMetadata - table found: certiv.assertion
2008-10-04 14:40:04,718 [http-8080-1]
INFO org.hibernate.tool.hbm2ddl.TableMetadata - foreign keys:
[fkf47026e2575b43d7, fkf47026e24268da7d]
2008-10-04 14:40:04,718 [http-8080-1]
INFO org.hibernate.tool.hbm2ddl.TableMetadata - indexes: [assertion_pkey]
2008-10-04 14:40:04,812 [http-8080-1]
INFO org.hibernate.tool.hbm2ddl.TableMetadata - table found: certiv.authority
2008-10-04 14:40:04,812 [http-8080-1]
INFO org.hibernate.tool.hbm2ddl.TableMetadata - foreign keys:
[fkfe0c1723575b43d7, fkfe0c1723ff114e1d, fkfe0c1723b3816057]
2008-10-04 14:40:06,640 [http-8080-1]
INFO org.hibernate.tool.hbm2ddl.SchemaUpdate - schema update complete
2008-10-04 14:40:06,781 [http-8080-1]
WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 0A000
2008-10-04 14:40:06,781 [http-8080-1] ERROR
org.hibernate.util.JDBCExceptionReporter - Method
org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int) is
not yet implemented.
2008-10-04 14:40:06,781 [http-8080-1] ERROR
net.certiv.analytics.db.dao.service.RepositoryServiceDao - Save error
2008-10-04 14:40:06,812 [http-8080-1]
INFO
org.springframework.remoting.support.RemoteInvocationTraceInterceptor
- Processing of HttpInvokerServiceExporter remote call resulted in
exception: net.certiv.analytics.db.dao.service.AbstractService.save
net.certiv.nav.events.PersistException: Save failure.
at
net.certiv.analytics.db.dao.service.RepositoryServiceDao.save(RepositoryServiceDao.java:75)

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Daniel Migowski 2008-10-06 07:45:44 Re: Malformed URLs
Previous Message Wm.A.Stafford 2008-10-03 21:18:51 When limit is greater than 813,500 activity seems to slow way down or stop