Hi,
I am using Hibernate 3.1.3 with Spring.
We are using "AnnotationSessionFactoryBean" for hibernate bean configuration.
Also we are using Spring 2.0.2.

I have a DAO class: ActionHistoryDAOImpl with a method:

class ActionHistoryDAOImpl extends HibernateDAOSupport implements ActionHistoryDAO {
@Override
public void addActionHistory(ActionHistory actionHistory) {
getHibernateTemplate().saveOrUpdate(actionHistory);
}
}

Bean declaration in spring's xml is as follows:
<bean id="actionHistoryDAO" class="com.ndc.statistics.plugin.dao.impl.ActionHistoryDAOImpl">
<property name="sessionFactory">
<ref local="sessionFactory" />
</property>
</bean>

<bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
<property name="annotatedClasses">...</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">${hibernate.dialect}</prop>
<prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
<prop key="hibernate.connection.datasource">${hibernate.connection.datasource}</prop>
<!-- This datasource is set from a properties file which gives the JNDI path to a datasource configured in my tomcat 6.0 -->
<prop key="hibernate.generate_statistics">true</prop>
<prop key="hibernate.cache.use_second_level_cache">true</prop>
<prop key="hibernate.cache.use_query_cache">true</prop>
<prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop>
</props>
</property>

The parameter ActionHistory has a concrete implementation class:
class ActionHistoryImpl implements ActionHistory {
@Column
public Long getArticleId() {
return articleId;
}

@Column
public String getArticleType() {
return articleType;
}

@Column
public Long getAuthorId() {
return authorId;
}

@Column
public Date getDateTime() {
return dateTime;
}

@Id
@Column(name = "actionHistoryId")
@GeneratedValue(strategy = GenerationType.IDENTITY)
public Long getId() {
return id;
}
// rest of the stuff
}

Now my problem is that I get this in my error log with hibernate logging set to debug:
log4j.category.org.hibernate=DEBUG

=================================================================
2009-04-02 13:02:44,048 DEBUG [http-8080-3] (org.hibernate.impl.SessionImpl) opened session at timestamp: 5073592991936512
2009-04-02 13:02:44,084 DEBUG [http-8080-3] (org.hibernate.cache.UpdateTimestampsCache) Pre-invalidating space [GCE_ActionHistory]
2009-04-02 13:02:44,085 DEBUG [http-8080-3] (org.hibernate.jdbc.AbstractBatcher) about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2009-04-02 13:02:44,085 DEBUG [http-8080-3] (org.hibernate.jdbc.ConnectionManager) opening JDBC connection
2009-04-02 13:02:44,085 DEBUG [http-8080-3] (org.hibernate.SQL) insert into GCE_ActionHistory (publicationId, userId, sectionId, articleType, articleId, authorId, actionTypeId, dateTime, historyType) values (?, ?, ?, ?, ?, ?, ?, ?, 'GENERIC')
2009-04-02 13:02:44,195 DEBUG [http-8080-3] (org.hibernate.jdbc.AbstractBatcher) about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2009-04-02 13:02:44,198 DEBUG [http-8080-3] (org.hibernate.util.JDBCExceptionReporter) could not insert: [com.ndc.statistics.plugin.domain.impl.ActionHistoryImpl] [insert into GCE_ActionHistory (publicationId, userId, sectionId, articleType, articleId, authorId, actionTypeId, dateTime, historyType) values (?, ?, ?, ?, ?, ?, ?, ?, 'GENERIC')]
java.sql.SQLException: Protocol violation
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:764)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1968)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2405)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:37)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:269)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:167)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:98)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:502)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:494)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:490)
at org.springframework.orm.hibernate3.HibernateTemplate$16.doInHibernate(HibernateTemplate.java:684)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367)
at org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:681)
at com.ndc.statistics.plugin.dao.impl.ActionHistoryDAOImpl.addActionHistory(ActionHistoryDAOImpl.java:677)
at com.ndc.statistics.plugin.StatisticsPluginImpl.registerViewAction(StatisticsPluginImpl.java:311)
at com.ndc.statistics.struts.actions.RecordViewStatistics.recordViewAction(RecordViewStatistics.java:78)
at com.ndc.statistics.struts.actions.RecordViewStatistics.execute(RecordViewStatistics.java:44)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.ndc.auth.filter.SecurityFilter.doHttpFilter(SecurityFilter.java:211)
at com.ndc.servlet.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:73)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.escenic.presentation.servlet.LooseFilterChain$Chain.doFilter(LooseFilterChain.java:147)
at com.escenic.presentation.servlet.ProcessorFilter.doFilterImpl(ProcessorFilter.java:72)
at com.twelvemonkeys.servlet.GenericFilter.doFilter(GenericFilter.java:209)
at com.escenic.presentation.servlet.LooseFilterChain$Chain.doFilter(LooseFilterChain.java:144)
at com.escenic.presentation.servlet.ProcessorFilter.doFilterImpl(ProcessorFilter.java:72)
at com.twelvemonkeys.servlet.GenericFilter.doFilter(GenericFilter.java:209)
at com.escenic.presentation.servlet.LooseFilterChain$Chain.doFilter(LooseFilterChain.java:144)
at com.escenic.presentation.servlet.ProcessorFilter.doFilterImpl(ProcessorFilter.java:72)
at com.twelvemonkeys.servlet.GenericFilter.doFilter(GenericFilter.java:209)
at com.escenic.presentation.servlet.LooseFilterChain$Chain.doFilter(LooseFilterChain.java:144)
at com.escenic.presentation.servlet.ProcessorFilter.doFilterImpl(ProcessorFilter.java:72)
at com.twelvemonkeys.servlet.GenericFilter.doFilter(GenericFilter.java:209)
at com.escenic.presentation.servlet.LooseFilterChain$Chain.doFilter(LooseFilterChain.java:144)
at com.escenic.presentation.servlet.ProcessorFilter.doFilterImpl(ProcessorFilter.java:72)
at com.twelvemonkeys.servlet.GenericFilter.doFilter(GenericFilter.java:209)
at com.escenic.presentation.servlet.LooseFilterChain$Chain.doFilter(LooseFilterChain.java:144)
at com.escenic.presentation.servlet.ProcessorFilter.doFilterImpl(ProcessorFilter.java:72)
at com.twelvemonkeys.servlet.GenericFilter.doFilter(GenericFilter.java:209)
at com.escenic.presentation.servlet.LooseFilterChain$Chain.doFilter(LooseFilterChain.java:144)
at com.escenic.presentation.servlet.ProcessorFilter.doFilterImpl(ProcessorFilter.java:72)
at com.twelvemonkeys.servlet.GenericFilter.doFilter(GenericFilter.java:209)
at com.escenic.presentation.servlet.LooseFilterChain$Chain.doFilter(LooseFilterChain.java:144)
at com.escenic.presentation.servlet.ProcessorFilter.doFilterImpl(ProcessorFilter.java:72)
at com.twelvemonkeys.servlet.GenericFilter.doFilter(GenericFilter.java:209)
at com.escenic.presentation.servlet.LooseFilterChain$Chain.doFilter(LooseFilterChain.java:144)
at com.escenic.presentation.servlet.LooseFilterChain.filter(LooseFilterChain.java:64)
at com.escenic.presentation.servlet.CompositeFilter.doFilterImpl(CompositeFilter.java:40)
at com.twelvemonkeys.servlet.GenericFilter.doFilter(GenericFilter.java:209)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.escenic.presentation.servlet.BootstrapFilter.doFilterImpl(BootstrapFilter.java:73)
at com.twelvemonkeys.servlet.GenericFilter.doFilter(GenericFilter.java:209)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.ndc.usercontent.filter.UserCookieFilter.doHttpFilter(UserCookieFilter.java:69)
at com.ndc.servlet.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:73)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
2009-04-02 13:02:44,201 WARN [http-8080-3] (org.hibernate.util.JDBCExceptionReporter) SQL Error: 17401, SQLState: null
2009-04-02 13:02:44,201 ERROR [http-8080-3] (org.hibernate.util.JDBCExceptionReporter) Protocol violation
2009-04-02 13:02:44,202 DEBUG [http-8080-3] (org.hibernate.jdbc.ConnectionManager) releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2009-04-02 13:02:44,202 DEBUG [http-8080-3] (org.hibernate.jdbc.ConnectionManager) transaction completed on session with on_close connection release mode; be sure to close the session to release JDBC resources!
2009-04-02 13:02:44,202 DEBUG [http-8080-3] (org.hibernate.cache.UpdateTimestampsCache) Invalidating space [GCE_ActionHistory], timestamp: 5073592992571392
2009-04-02 13:02:44,205 ERROR [http-8080-3] (com.ndc.statistics.struts.actions.RecordViewStatistics) Unable to record view action for statistics!
org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.GenericJDBCException: could not insert: [com.ndc.statistics.plugin.domain.impl.ActionHistoryImpl]
Caused by: org.hibernate.exception.GenericJDBCException: could not insert: [com.ndc.statistics.plugin.domain.impl.ActionHistoryImpl]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1986)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2405)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:37)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:269)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:167)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:98)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:502)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:494)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:490)
at org.springframework.orm.hibernate3.HibernateTemplate$16.doInHibernate(HibernateTemplate.java:684)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367)
at org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:681)
at com.ndc.statistics.plugin.dao.impl.ActionHistoryDAOImpl.addActionHistory(ActionHistoryDAOImpl.java:677)
at com.ndc.statistics.plugin.StatisticsPluginImpl.registerViewAction(StatisticsPluginImpl.java:311)
at com.ndc.statistics.struts.actions.RecordViewStatistics.recordViewAction(RecordViewStatistics.java:78)
at com.ndc.statistics.struts.actions.RecordViewStatistics.execute(RecordViewStatistics.java:44)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.ndc.auth.filter.SecurityFilter.doHttpFilter(SecurityFilter.java:211)
at com.ndc.servlet.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:73)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.escenic.presentation.servlet.LooseFilterChain$Chain.doFilter(LooseFilterChain.java:147)
at com.escenic.presentation.servlet.ProcessorFilter.doFilterImpl(ProcessorFilter.java:72)
at com.twelvemonkeys.servlet.GenericFilter.doFilter(GenericFilter.java:209)
at com.escenic.presentation.servlet.LooseFilterChain$Chain.doFilter(LooseFilterChain.java:144)
at com.escenic.presentation.servlet.ProcessorFilter.doFilterImpl(ProcessorFilter.java:72)
at com.twelvemonkeys.servlet.GenericFilter.doFilter(GenericFilter.java:209)
at com.escenic.presentation.servlet.LooseFilterChain$Chain.doFilter(LooseFilterChain.java:144)
at com.escenic.presentation.servlet.ProcessorFilter.doFilterImpl(ProcessorFilter.java:72)
at com.twelvemonkeys.servlet.GenericFilter.doFilter(GenericFilter.java:209)
at com.escenic.presentation.servlet.LooseFilterChain$Chain.doFilter(LooseFilterChain.java:144)
at com.escenic.presentation.servlet.ProcessorFilter.doFilterImpl(ProcessorFilter.java:72)
at com.twelvemonkeys.servlet.GenericFilter.doFilter(GenericFilter.java:209)
at com.escenic.presentation.servlet.LooseFilterChain$Chain.doFilter(LooseFilterChain.java:144)
at com.escenic.presentation.servlet.ProcessorFilter.doFilterImpl(ProcessorFilter.java:72)
at com.twelvemonkeys.servlet.GenericFilter.doFilter(GenericFilter.java:209)
at com.escenic.presentation.servlet.LooseFilterChain$Chain.doFilter(LooseFilterChain.java:144)
at com.escenic.presentation.servlet.ProcessorFilter.doFilterImpl(ProcessorFilter.java:72)
at com.twelvemonkeys.servlet.GenericFilter.doFilter(GenericFilter.java:209)
at com.escenic.presentation.servlet.LooseFilterChain$Chain.doFilter(LooseFilterChain.java:144)
at com.escenic.presentation.servlet.ProcessorFilter.doFilterImpl(ProcessorFilter.java:72)
at com.twelvemonkeys.servlet.GenericFilter.doFilter(GenericFilter.java:209)
at com.escenic.presentation.servlet.LooseFilterChain$Chain.doFilter(LooseFilterChain.java:144)
at com.escenic.presentation.servlet.ProcessorFilter.doFilterImpl(ProcessorFilter.java:72)
at com.twelvemonkeys.servlet.GenericFilter.doFilter(GenericFilter.java:209)
at com.escenic.presentation.servlet.LooseFilterChain$Chain.doFilter(LooseFilterChain.java:144)
at com.escenic.presentation.servlet.LooseFilterChain.filter(LooseFilterChain.java:64)
at com.escenic.presentation.servlet.CompositeFilter.doFilterImpl(CompositeFilter.java:40)
at com.twelvemonkeys.servlet.GenericFilter.doFilter(GenericFilter.java:209)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.escenic.presentation.servlet.BootstrapFilter.doFilterImpl(BootstrapFilter.java:73)
at com.twelvemonkeys.servlet.GenericFilter.doFilter(GenericFilter.java:209)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.ndc.usercontent.filter.UserCookieFilter.doHttpFilter(UserCookieFilter.java:69)
at com.ndc.servlet.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:73)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: Protocol violation
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:764)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1968)
... 80 more
=================================================================

Interesting enough that this only occurs in one of the Oracle 10.2.0.1 databases, the same
code works fine in another Oracle 10 XE and MySQL 5.0.
I have tried almost all jdbc drivers available from oracle.com.
Also I get this in my log on various operations:

=================================================================
2009-04-02 13:02:36,722 DEBUG [http-8080-1] (org.hibernate.jdbc.ConnectionManager) transaction completed on session with on_close connection release mode; be sure to close the session to release JDBC resources!
=================================================================

After looking for a solution for quite a long time, I am being really frustrated.
Can anyone shed some light on the situation?