I have recently migrated over from hibernate version 2 to version 3. I've now in the position where I have completed all of the changes needed for the migration and I am ready to test my application to see if there are any issues arising from the migration (things I have missed).

I have found that on start up I get this exception It only happens the once and I can still connect to my database, add, update and delete. So far, it doesn't seem to affect anything (I'm not through the whole application yet). I think it might be related to the database driver but I could be wrong.

I was wondering what causing this exception and has anyone came across this before. I have searched (maybe not the right keywords) but have not found anything related.

If I can provide any more info, please tell me.

For now, thanks.

Hibernate version:

3.1.2

Name and version of the database you are using:

Oracle 9i
Driver: Oracle 9i 9.2.0.5

hibernate.cfg.xml

!-- Query Language -->
<property name="query.substitutions">"true 1, false 0, yes 'Y', no 'N'"</property>
<!-- Platforms - Oracle -->
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="connection.url">jdbc:oracle:thin:@marge:1521:DPDB</property>
<property name="connection.username">gold</property>
<property name="connection.password">OysterwareAdmin99</property>
<property name="connection.schema">GOLD</property>
<!-- C3P0 Connection Pool -->
<property name="c3p0.acquire_increment">1</property>
<property name="c3p0.idle_test_period">100</property>
<property name="hibernate.c3p0.max_size">25</property>
<property name="hibernate.c3p0.min_size">5</property>
<property name="hibernate.c3p0.timeout">5000</property>
<property name="hibernate.c3p0.max_statements">0</property>
<!-- Transaction API -->
<property name="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
<!-- Miscellaneous Settings -->
<property name="show_sql">false</property>
<property name="jdbc.batch_size">0</property>
<property name="hibernate.jdbc.use_streams_for_binary">true</property>
<property name="use_outer_join">true</property>
<property name="cglib.use_reflection_optimizer">true</property>

Full stack trace of any exception that occurs:

INFO - MLog clients using log4j logging.
DEBUG - awaitAvailable(): [unknown]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@cd927d [managed: 0, unused: 0, excluded: 0]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@cd927d [managed: 1, unused: 1, excluded: 0]
DEBUG - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@e72f0c ---> age: 0 max: 5000000 [com.mchange.v2.resourcepool.BasicResourcePool@cd927d]
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@cd927d [managed: 1, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@e72f0c)
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@cd927d [managed: 2, unused: 1, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@e72f0c)
DEBUG - Attempted to convert SQLException to SQLException. Leaving it alone. [SQLState: null; errorCode: 17023]
java.sql.SQLException: Unsupported feature
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.dbaccess.DBError.throwUnsupportedFeatureSqlException(DBError.java:690)
at oracle.jdbc.OracleDatabaseMetaData.getDatabaseMajorVersion(OracleDatabaseMetaData.java:4028)
at com.mchange.v2.c3p0.impl.NewProxyDatabaseMetaData.getDatabaseMajorVersion(NewProxyDatabaseMetaData.java:3678)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.hibernate.cfg.SettingsFactory.getDatabaseMajorVersion(SettingsFactory.java:293)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:76)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1881)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1174)
at com.oysterware.akoya.service.filters.SecurityFilter.init(SecurityFilter.java:66)
at com.caucho.server.dispatch.FilterManager.createFilter(FilterManager.java:127)
at com.caucho.server.dispatch.FilterMapper.buildDispatchChain(FilterMapper.java:169)
at com.caucho.server.webapp.Application.buildInvocation(Application.java:1722)
at com.caucho.server.webapp.ApplicationContainer.buildInvocation(ApplicationContainer.java:666)
at com.caucho.server.host.Host.buildInvocation(Host.java:421)
at com.caucho.server.host.HostContainer.buildInvocation(HostContainer.java:322)
at com.caucho.server.resin.ServletServer.buildInvocation(ServletServer.java:641)
at com.caucho.server.dispatch.DispatchServer.buildInvocation(DispatchServer.java:198)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:254)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:363)
at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:490)
at com.caucho.util.ThreadPool.run(ThreadPool.java:423)
at java.lang.Thread.run(Thread.java:534)
DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@cd927d [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@e72f0c)
DEBUG - Attempted to convert SQLException to SQLException. Leaving it alone. [SQLState: null; errorCode: 17023]
java.sql.SQLException: Unsupported feature
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.dbaccess.DBError.throwUnsupportedFeatureSqlException(DBError.java:690)
at oracle.jdbc.OracleDatabaseMetaData.supportsGetGeneratedKeys(OracleDatabaseMetaData.java:3766)
at com.mchange.v2.c3p0.impl.NewProxyDatabaseMetaData.supportsGetGeneratedKeys(NewProxyDatabaseMetaData.java:3578)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:85)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1881)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1174)
at com.oysterware.akoya.service.filters.SecurityFilter.init(SecurityFilter.java:66)
at com.caucho.server.dispatch.FilterManager.createFilter(FilterManager.java:127)
at com.caucho.server.dispatch.FilterMapper.buildDispatchChain(FilterMapper.java:169)
at com.caucho.server.webapp.Application.buildInvocation(Application.java:1722)
at com.caucho.server.webapp.ApplicationContainer.buildInvocation(ApplicationContainer.java:666)
at com.caucho.server.host.Host.buildInvocation(Host.java:421)
at com.caucho.server.host.HostContainer.buildInvocation(HostContainer.java:322)
at com.caucho.server.resin.ServletServer.buildInvocation(ServletServer.java:641)
at com.caucho.server.dispatch.DispatchServer.buildInvocation(DispatchServer.java:198)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:254)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:363)
at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:490)
at com.caucho.util.ThreadPool.run(ThreadPool.java:423)
at java.lang.Thread.run(Thread.java:534)

Hi,

I am having a similar issue. here are the versions I am using:

Hibernate 3.2.1
Oracle 10g
ojdbc14
connection pool: c3p0-0.9

stack trace:
15:57:36,975 INFO C3P0ConnectionProvider:54 - autocommit mode: false
15:57:37,287 INFO MLog:80 - MLog clients using log4j logging.
15:57:37,553 INFO C3P0Registry:77 - Initializing c3p0-0.9.0 [built 11-July-2005 00:43:29 -0400; debug? true; trace: 10]
15:57:37,834 INFO PoolBackedDataSource:257 - Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@19c7798 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@105062c [ 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, identityToken -> 105062c, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, maxIdleTime -> 1800, maxPoolSize -> 5, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@bbc946 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> bbc946, jdbcUrl -> jdbc:oracle:thin:@***:1521:***, properties -> {user=******, password=******, autocommit=false} ], preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ], factoryClassLocation -> null, identityToken -> 19c7798, numHelperThreads -> 3 ]
15:57:37,865 DEBUG BasicResourcePool:942 - awaitAvailable(): [unknown]
15:57:37,865 DEBUG BasicResourcePool:1159 - trace com.mchange.v2.resourcepool.BasicResourcePool@16fcbc0 [managed: 0, unused: 0, excluded: 0]
15:57:38,975 DEBUG BasicResourcePool:1159 - trace com.mchange.v2.resourcepool.BasicResourcePool@16fcbc0 [managed: 1, unused: 1, excluded: 0]
15:57:38,975 DEBUG BasicResourcePool:1081 - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@e15c54 ---> age: 0 max: 1800000 [com.mchange.v2.resourcepool.BasicResourcePool@16fcbc0]
15:57:38,975 DEBUG BasicResourcePool:1159 - trace com.mchange.v2.resourcepool.BasicResourcePool@16fcbc0 [managed: 1, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@e15c54)
15:57:39,068 DEBUG NewPooledConnection:304 - com.mchange.v2.c3p0.impl.NewPooledConnection@e15c54 handling a throwable.
java.sql.SQLException: Unsupported feature
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.dbaccess.DBError.throwUnsupportedFeatureSqlException(DBError.java:689)
at oracle.jdbc.OracleDatabaseMetaData.getDatabaseMajorVersion(OracleDatabaseMetaData.java:4442)
at com.mchange.v2.c3p0.impl.NewProxyDatabaseMetaData.getDatabaseMajorVersion(NewProxyDatabaseMetaData.java:3678)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.hibernate.cfg.SettingsFactory.getDatabaseMajorVersion(SettingsFactory.java:324)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:80)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2006)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1289)
at com.****.util.HibernateUtil.buildSessionFactory(HibernateUtil.java:22)
at com.****.util.HibernateUtil.<clinit>(HibernateUtil.java:15)
at com.****.dao.BBNDao.accessBaseData(BBNDao.java:20)
at com.****.dao.BBNDao.accessData(BBNDao.java:78)
at com.****.dto.BBNDto.getData(BBNDto.java:33)
at com.****.server.DataServiceImpl.getDataFromDB(DataServiceImpl.java:40)
at com.****.server.DataServiceImpl.greetServer(DataServiceImpl.java:27)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:527)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:166)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:86)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:362)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:729)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.handler.RequestLogHandler.handle(RequestLogHandler.java:49)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:843)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:647)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:205)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:488)
15:57:39,068 DEBUG SqlUtils:83 - Attempted to convert SQLException to SQLException. Leaving it alone. [SQLState: null; errorCode: 17023]


Could you please help me resolve this.

Thanks,
Raja Chandra Rangineni

I have the same issue. I tried to play with the property hibernate.jdbc.use_get_generated_keys in my hibernate setting but it didn't work.
Do you have an idea?