[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2962) ResultCheckStyle.PARAM does not work with PostgreSQL
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2962?page=c...
]
Julius Stroffek commented on HHH-2962:
--------------------------------------
Hi Gail,
thanks for the suggestion, I'll create a test. I had a look at those tests and it
seems to me that the issue can not be tested in CustomStoredProcTestSupport since the bug
is not in a Hibernate support for stored procedures but in ResultCheckStyle.PARAM code.
The test would be more suitable to be present in ResultCheckStyleTest. I was wondering
while this issue was not caught by the test since it already contains a bunch of tests.
But the tests present there are testing only the negative response of ResultCheckStyle for
the queries and also no check whether the exception thrown is the one expected. Positive
response is not handled by any of these tests.
ResultCheckStyle.PARAM does not work with PostgreSQL
----------------------------------------------------
Key: HHH-2962
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2962
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.5, 3.2.6, 3.3, 3.4
Environment: Hibernate 3.2.5, PostgreSQL 8.2 & 8.3beta
Reporter: Julius Stroffek
Attachments: hibernate.diff
Original Estimate: 5 minutes
Remaining Estimate: 5 minutes
I have created a simple test application which uses a stored procedure
to insert a record into a database using hibernate. I used hibernate
annotations and have overridden insert statement by
@SQLInsert(callable=true, sql="{? = call insert_party(?, ?, ?, ?)}",
check=ResultCheckStyle.PARAM)
However, hibernate throws the exception
...
Caused by: org.hibernate.exception.GenericJDBCException: could not extract row counts
from CallableStatement
at
org.hibernate.jdbc.Expectations$BasicParamExpectation.determineRowCount(Expectations.java:123)
at
org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:41)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2251)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2661)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at
org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:516)
... 50 more
Caused by: org.postgresql.util.PSQLException: Parameter of type java.sql.Types=2 was
registered, but call to getInt (sqltype=java.sql.Types=4) was made.
at
org.postgresql.jdbc2.AbstractJdbc2Statement.checkIndex(AbstractJdbc2Statement.java:2387)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.getInt(AbstractJdbc2Statement.java:1920)
at
org.hibernate.jdbc.Expectations$BasicParamExpectation.determineRowCount(Expectations.java:119)
... 62 more
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira