Search:

Thanks prinSpring.

Solved the problem using spring StoredProcedure passing the JdbcTamplate during object creation.
.
Lesson learned: Do not mix stored-procedure through vanilla JDBC in Spring...

I have a similar problem with transaction and stored proc.

@transactional are declared for dao methods as well as service. Autocommit for datasource is set to true. There is no requres new.
...