Hibernate version: 3.0.5
Mapping documents: IndexNavigareXX.hbm.xml
Code between sessionFactory.openSession() and session.close():
Code:
try {
sessionFactory = new Configuration()
.configure("hibernate.cfg.xml")
.buildSessionFactory();
session = sessionFactory.openSession();
IndexNavigareXX nav = new IndexNavigareXX(new Long(10));
session.save(nav);
} catch (Exception e) {
e.printStackTrace();
} finally {
session.close();
sessionFactory.close();
}
Full stack trace of any exception that occurs:
15:55:31,125 INFO Environment:464 - Hibernate 3.0.5
15:55:31,125 INFO Environment:477 - hibernate.properties not found
15:55:31,125 INFO Environment:510 - using CGLIB reflection optimizer
15:55:31,140 INFO Environment:540 - using JDK 1.4 java.sql.Timestamp handling
15:55:31,265 INFO Configuration:1110 - configuring from resource: hibernate.cfg.xml
15:55:31,265 INFO Configuration:1081 - Configuration resource: hibernate.cfg.xml
15:55:31,796 INFO Configuration:444 - Mapping resource: data/IndexNavigareXX.hbm.xml
15:55:32,093 INFO HbmBinder:260 - Mapping class: data.IndexNavigareXX -> IndexNavigareXX
15:55:32,140 INFO Configuration:1222 - Configured SessionFactory: null
15:55:32,140 INFO Configuration:875 - processing extends queue
15:55:32,140 INFO Configuration:879 - processing collection mappings
15:55:32,140 INFO Configuration:888 - processing association property references
15:55:32,140 INFO Configuration:917 - processing foreign key constraints
15:55:32,265 INFO C3P0ConnectionProvider:50 - C3P0 using driver: org.postgresql.Driver at URL: jdbc:postgresql://86.104.240.62:5432/sibi_test
15:55:32,265 INFO C3P0ConnectionProvider:51 - Connection properties: {user=postgres, password=****}
15:55:32,281 INFO C3P0ConnectionProvider:54 - autocommit mode: false
Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@17471e0 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@1507fb2 [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, idleConnectionTestPeriod -> 0, initialPoolSize -> 10, maxIdleTime -> 18000, maxPoolSize -> 100, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 10, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@13f3045 [ description -> null, driverClass -> null, factoryClassLocation -> null, jdbcUrl -> jdbc:postgresql://86.104.240.62:5432/sibi_test, properties -> {user=******, password=******} ] , preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ] , factoryClassLocation -> null, numHelperThreads -> 3, poolOwnerIdentityToken -> 17471e0 ]
15:55:36,296 INFO SettingsFactory:77 - RDBMS: PostgreSQL, version: 8.1.0
15:55:36,296 INFO SettingsFactory:78 - JDBC driver: PostgreSQL Native Driver, version: PostgreSQL 8.1 JDBC3 with SSL (build 404)
15:55:36,343 INFO Dialect:92 - Using dialect: org.hibernate.dialect.PostgreSQLDialect
15:55:36,359 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions)
15:55:36,359 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
15:55:36,375 INFO SettingsFactory:125 - Automatic flush during beforeCompletion(): disabled
15:55:36,375 INFO SettingsFactory:129 - Automatic session close at end of transaction: disabled
15:55:36,375 INFO SettingsFactory:136 - JDBC batch size: 30
15:55:36,375 INFO SettingsFactory:139 - JDBC batch updates for versioned data: disabled
15:55:36,375 INFO SettingsFactory:144 - Scrollable result sets: enabled
15:55:36,375 INFO SettingsFactory:152 - JDBC3 getGeneratedKeys(): disabled
15:55:36,375 INFO SettingsFactory:160 - Connection release mode: null
15:55:36,375 INFO SettingsFactory:187 - Default batch fetch size: 1
15:55:36,375 INFO SettingsFactory:191 - Generate SQL with comments: disabled
15:55:36,390 INFO SettingsFactory:195 - Order SQL updates by primary key: disabled
15:55:36,390 INFO SettingsFactory:334 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
15:55:36,390 INFO ASTQueryTranslatorFactory:21 - Using ASTQueryTranslatorFactory
15:55:36,390 INFO SettingsFactory:203 - Query language substitutions: {}
15:55:36,390 INFO SettingsFactory:209 - Second-level cache: disabled
15:55:36,390 INFO SettingsFactory:213 - Query cache: disabled
15:55:36,406 INFO SettingsFactory:228 - Optimize cache for minimal puts: disabled
15:55:36,406 INFO SettingsFactory:237 - Structured second-level cache entries: disabled
15:55:36,406 INFO SettingsFactory:261 - Statistics: disabled
15:55:36,406 INFO SettingsFactory:265 - Deleted entity synthetic identifier rollback: disabled
15:55:36,421 INFO SettingsFactory:279 - Default entity-mode: pojo
15:55:36,609 INFO SessionFactoryImpl:152 - building session factory
15:55:37,156 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
15:55:37,156 INFO SessionFactoryImpl:379 - Checking 0 named queries
com.mchange.v2.c3p0.impl.NewPooledConnection@763f5d invalidated by Exception: org.postgresql.util.PSQLException: ERROR: relation "indexnavigarexx" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:250)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:75)
at org.hibernate.id.IncrementGenerator.getNext(IncrementGenerator.java:89)
at org.hibernate.id.IncrementGenerator.generate(IncrementGenerator.java:45)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:85)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:481)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:476)
at ime.sibi.mrcimport.Import.doTestPgSQL(Import.java:28)
at ime.sibi.mrcimport.Import.main(Import.java:42)
CONNECTION ERROR OCCURRED!
org.hibernate.exception.SQLGrammarException: could not fetch initial value
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:59)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.id.IncrementGenerator.getNext(IncrementGenerator.java:107)
at org.hibernate.id.IncrementGenerator.generate(IncrementGenerator.java:45)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:85)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:481)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:476)
at ime.sibi.mrcimport.Import.doTestPgSQL(Import.java:28)
at ime.sibi.mrcimport.Import.main(Import.java:42)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "indexnavigarexx" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:250)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:75)
at org.hibernate.id.IncrementGenerator.getNext(IncrementGenerator.java:89)
... 11 more
15:55:37,281 WARN JDBCExceptionReporter:71 - SQL Error: 0, SQLState: 42P01
15:55:37,281 ERROR JDBCExceptionReporter:72 - ERROR: relation "indexnavigarexx" does not exist
15:55:37,296 INFO SessionFactoryImpl:776 - closing
Name and version of the database you are using:
PostgreSQL 8.1
Hi
I have a problem. I wanted to create a class which does act as a table without having it in database (al manipulations made thru sql or stored procedures better).
I'm getting this error,
relation "indexnavigarexx" does not exist. How i can make such that hibernate won't search any relations in DB?
Thanks in advice
Login
FAQ
Search
