Hibernate sqlexception "Invalid parameter 1: Parameter is not set nor registered" on EAP6

Solution Verified - Updated -

Issue

We are migrating an existing application, from Jboss 4.2.3-GA community edition to JBoss EAP 6.2.0 version(not a community version). In these efforts we were trying to upgrade to hibernate 4. But when we do that and try to login we get the follow exception trying to read from the database with our jpa object:

14:47:25,748 DEBUG [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-/127.0.0.1:8080-2) could not extract ResultSet [n/a]: com.ibm.db2.jcc.a.io: [jcc][10143][10845][4.3.111] Invalid parameter 1: Parameter is not set nor registered. ERRORCODE=-4461, SQLSTATE=42815

With the rest of the error in the log file attached.

I have tried printing out the parameters and it looks like they are there but for some reason we don't have something configured correctly so that the jpa object can see them.

Environment

  • Red Hat JBoss Enterprise Application Platform (EAP)
    • 6.x

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content