Skip to Content

HANA nJDBC issue in JPA application

Hi,

We are in HANA version SP09 1.00.094.00.1427101515 and migrating our DB2 DB to HANA DB where we have few JPA and JDBC based application , in JPA application when we try to perform Insert statement its ends with strange error as given here :

Caused by: com.sap.db.jdbc.exceptions.jdbc40.SQLTransactionRollbackException: [129]: transaction rolled back by an internal error: cannot change this transaction's access mode from read-only to update directly: please use "SET TRANSACTION READ WRITE" statement first

Do we have any annotation in JPA where we can instruct container to handles the above transaction behaviour ?


Also does njdbc have versions w.r.t. specific HANA DB ?


Please help.

Best Regards,

Satish Kumar

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Oct 21, 2015 at 10:06 AM

    Hi,

    Adding Datasource property as readonly=false is working.

    Thanks,

    Satish Kumar

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 09, 2015 at 07:26 AM

    Could it be that the user account you're using for the JDBC access is a restricted user?

    - Lars

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.