Quote:
> Caused by: java.lang.IllegalStateException: You cannot call executeUpdate() on this query. It is the incorrect query type.
I guess EclipseLink has its own PreparedStatement/Function methods. But how do you invoke that using injected container-managed EntityManager? I know how to do stuff using EclipseLink Session construct, but inside this EJB context I just cannot get Session... clues, help? I am just stuck on this at every corner. Well, I can still get the connection direcly, but would like to avoid that if possible since I have managed to fetch data using JPA.
Is it worth trying at all?]]>Neikius Mising name2011-11-08T14:53:56-00:00Re: Calling preparedStatement/Function the JPA way
https://www.eclipse.org/forums/index.php/mv/msg/261737/755523/#msg_755523
I'm not sure why you would be getting the exception from this code, can you post the full exception stack trace and the EclipseLink version you are using?
Best Regards,
Chris]]>Chris Delahunt2011-11-08T17:09:36-00:00Re: Calling preparedStatement/Function the JPA way
https://www.eclipse.org/forums/index.php/mv/msg/261737/755524/#msg_755524
I'm not sure why you would be getting the exception from this code, can you post the full exception stack trace and the EclipseLink version you are using?
Best Regards,
Chris]]>Chris Delahunt2011-11-08T17:09:36-00:00Re: Calling preparedStatement/Function the JPA way
https://www.eclipse.org/forums/index.php/mv/msg/261737/757571/#msg_757571
I have user BIRT3.7 version. I want create data set with stored procedure with cursor.data not retrieve but error is:
A BIRT exception occurred.
Plug-in Provider:Eclipse BIRT Project
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:3.7.1.v20110905
Error Code:odaconsumer.CannotExecuteStatement
Error Message:Cannot execute the statement.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:Protocol violation
;
java.sql.SQLException: Protocol violation
please help me
Thanks
Om]]>Om Patel2011-11-19T15:45:57-00:00Re: Calling preparedStatement/Function the JPA way
https://www.eclipse.org/forums/index.php/mv/msg/261737/758005/#msg_758005
I have user BIRT3.7 version. I want create data set with stored procedure with cursor. but error is:
A BIRT exception occurred.
Plug-in Provider:Eclipse BIRT Project
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:3.7.1.v20110905
Error Code:odaconsumer.CannotExecuteStatement
Error Message:Cannot execute the statement.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:Protocol violation
;
java.sql.SQLException: Protocol violation