Joined: Wed Feb 23, 2005 11:57 am
Posts: 15
|
Hibernate is using rowid and it looks like my postgres 8.0 with the 8.0-310 JDBC 3 driver, does not like it.
Hibernate version: 3.0
Mapping documents: Code: On request Code between sessionFactory.openSession() and session.close():
Code: User user = (User)sess.createCriteria(User.class).add( Restrictions.eq("userId", getUserid())).uniqueResult();
Full stack trace of any exception that occurs:
Code: com.mchange.v2.c3p0.impl.NewPooledConnection@15d8d75 invalidated by Exception: java.sql.SQLException: ERROR: column this_.rowid does not exi
st
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:329)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:239)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:359)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:107)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1183)
at org.hibernate.loader.Loader.doQuery(Loader.java:363)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:203)
at org.hibernate.loader.Loader.doList(Loader.java:1499)
at org.hibernate.loader.Loader.list(Loader.java:1482)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:111)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1246)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:299)
at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:432)
at com.eko.app.tapestry.page.Login.attemptLogin(Login.java:114)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.tapestry.listener.ListenerMap.invokeTargetMethod(ListenerMap.java:202)
at org.apache.tapestry.listener.SyntheticListener.invoke(SyntheticListener.java:45)
at org.apache.tapestry.listener.SyntheticListener.actionTriggered(SyntheticListener.java:50)
at org.apache.tapestry.form.Form.renderComponent(Form.java:411)
at org.apache.tapestry.AbstractComponent.render(AbstractComponent.java:606)
at org.apache.tapestry.form.Form.rewind(Form.java:551)
at org.apache.tapestry.engine.RequestCycle.rewindForm(RequestCycle.java:412)
at org.apache.tapestry.form.Form.trigger(Form.java:564)
at org.apache.tapestry.engine.DirectService.service(DirectService.java:136)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.eko.app.tapestry.services.ProxySecurityInvocationHandler.invoke(ProxySecurityInvocationHandler.java:138)
at $Proxy0.service(Unknown Source)
at org.apache.tapestry.engine.AbstractEngine.service(AbstractEngine.java:358)
at org.apache.tapestry.services.impl.InvokeEngineTerminator.service(InvokeEngineTerminator.java:57)
at $RequestServicer_102c76ff04f.service($RequestServicer_102c76ff04f.java)
at org.apache.tapestry.services.impl.RequestGlobalsInitializer.service(RequestGlobalsInitializer.java:52)
at $RequestServicerFilter_102c76ff051.service($RequestServicerFilter_102c76ff051.java)
at $RequestServicer_102c76ff053.service($RequestServicer_102c76ff053.java)
at $RequestServicer_102c76ff049.service($RequestServicer_102c76ff049.java)
at org.apache.tapestry.ApplicationServlet.doService(ApplicationServlet.java:128)
at org.apache.tapestry.ApplicationServlet.doPost(ApplicationServlet.java:173)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:822)
at org.apache.tapestry.RedirectFilter.doFilter(RedirectFilter.java:103)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:813)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:494)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:624)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1434)
at org.mortbay.http.HttpServer.service(HttpServer.java:896)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
Name and version of the database you are using: Postgresql 8.0The generated SQL (show_sql=true):
Code: Hibernate: select this_.provider_id as provider1_1_, this_.chg_ts as chg2_3_1_, this_.chg_user_id as chg3_3_1_, this_.user_id as user4_3_1_,
this_.pwd_txt as pwd5_3_1_, this_.pwd_expire_dtm as pwd6_3_1_, this_.deleted_bln as deleted7_3_1_, this_.rowid as rowid_1_, provider2_.prov
ider_id as provider1_0_, provider2_.chg_ts as chg2_1_0_, provider2_.chg_user_id as chg3_1_0_, provider2_.provider_nm as provider4_1_0_, prov
ider2_.last_nm as last5_1_0_, provider2_.first_nm as first6_1_0_, provider2_.mi_txt as mi7_1_0_, provider2_.suffix_txt as suffix8_1_0_, prov
ider2_.initials_txt as initials9_1_0_, provider2_.ssn_txt as ssn10_1_0_, provider2_.internal_id as internal11_1_0_, provider2_.external_id a
s external12_1_0_, provider2_.phone_txt as phone13_1_0_, provider2_.email_txt as email14_1_0_, provider2_.deleted_bln as deleted15_1_0_, pro
vider2_.type_id as type16_1_0_, provider2_.rowid as rowid_0_ from Users this_ inner join Providers provider2_ on this_.provider_id=provider2
_.provider_id where this_.user_id=?
Debug level Hibernate log excerpt:
Code: 2005-03-21 18:26:44,796 [P1-9] INFO org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.PostgreSQLDialect
2005-03-21 18:26:44,828 [P1-9] INFO org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
2005-03-21 18:26:44,828 [P1-9] INFO org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
2005-03-21 18:26:44,828 [P1-9] INFO org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
2005-03-21 18:26:44,828 [P1-9] INFO org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
2005-03-21 18:26:44,843 [P1-9] INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
2005-03-21 18:26:44,843 [P1-9] INFO org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
2005-03-21 18:26:44,859 [P1-9] INFO org.hibernate.connection.C3P0ConnectionProvider - C3P0 using driver: org.postgresql.Driver at URL: jdbc
:postgresql://localhost/testdb
2005-03-21 18:26:44,859 [P1-9] INFO org.hibernate.connection.C3P0ConnectionProvider - Connection properties: {user=test, password=****}
2005-03-21 18:26:44,859 [P1-9] INFO org.hibernate.connection.C3P0ConnectionProvider - autocommit mode: false
Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@15e0c2b [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnecti
onPoolDataSource@142c778 [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automat
icTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultC
onnectionTester, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, idleConnectionTestPeriod -> 0, initialPoolSize ->
1, maxIdleTime -> 1800, maxPoolSize -> 3, maxStatements -> 20, maxStatementsPerConnection -> 0, minPoolSize -> 1, nestedDataSource -> com.m
change.v2.c3p0.DriverManagerDataSource@8a1977 [ description -> null, driverClass -> null, factoryClassLocation -> null, jdbcUrl -> jdbc:post
gresql://localhost/testdb, properties -> {user=******, password=******} ] , preferredTestQuery -> null, propertyCycle -> 300, testConnection
OnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ] , factoryClassLocation -> null, numHelper
Threads -> 3, poolOwnerIdentityToken -> 15e0c2b ]
2005-03-21 18:26:46,234 [P1-9] INFO org.hibernate.cfg.SettingsFactory - JDBC batch size: 30
2005-03-21 18:26:46,250 [P1-9] INFO org.hibernate.cfg.SettingsFactory - JDBC batch updates for versioned data: disabled
2005-03-21 18:26:46,250 [P1-9] INFO org.hibernate.cfg.SettingsFactory - Scrollable result sets: enabled
2005-03-21 18:26:46,250 [P1-9] INFO org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): disabled
2005-03-21 18:26:46,250 [P1-9] INFO org.hibernate.transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC t
ransactions)
2005-03-21 18:26:46,265 [P1-9] INFO org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in
JTA environment, use of read-write or transactional second-level cache is not recommended)
2005-03-21 18:26:46,265 [P1-9] INFO org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
2005-03-21 18:26:46,265 [P1-9] INFO org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
2005-03-21 18:26:46,265 [P1-9] INFO org.hibernate.cfg.SettingsFactory - Cache provider: org.hibernate.cache.EhCacheProvider
2005-03-21 18:26:46,281 [P1-9] INFO org.hibernate.cfg.SettingsFactory - Second-level cache: disabled
2005-03-21 18:26:46,281 [P1-9] INFO org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
2005-03-21 18:26:46,281 [P1-9] INFO org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
2005-03-21 18:26:46,281 [P1-9] INFO org.hibernate.cfg.SettingsFactory - Query cache: disabled
2005-03-21 18:26:46,281 [P1-9] INFO org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout
2005-03-21 18:26:46,281 [P1-9] INFO org.hibernate.cfg.SettingsFactory - Statistics: disabled
2005-03-21 18:26:46,281 [P1-9] INFO org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
2005-03-21 18:26:46,281 [P1-9] INFO org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
2005-03-21 18:26:46,765 [P1-9] INFO org.hibernate.impl.SessionFactoryImpl - building session factory
2005-03-21 18:26:46,796 [P1-9] WARN net.sf.ehcache.config.Configurator - No configuration found. Configuring ehcache from ehcache-failsafe.
xml found in the classpath: jar:file:/C:/jetty-5.1.2/ext/ehcache-1.1.jar!/ehcache-failsafe.xml
2005-03-21 18:26:48,406 [P1-9] INFO org.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured
2005-03-21 18:26:48,406 [P1-9] INFO org.hibernate.impl.SessionFactoryImpl - Checking 0 named queries
|
|
Login
FAQ
Search