org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed

Developer Programs Writing Device Types
21

I do wish you would have update your status page and informed support. I’ve spent the whole day trying to convince them its wasn’t a custom DH issue. All I got back was “we don’t support custom device handlers”

1 Like
22

Dont like how they basically told me to take a hike and they had no control over the problem.

1 Like
23

The issue popped up again. I’m getting the same error message while trying to parse the images from the camera in a parse() method as explained here

I belive this is the reason why the camera images in the carousel tile are not updated. I keep on getting the same image displayed, even though the new images from the camera are properly taken and their S3 key and name are passed as parameters to storeTemporaryImage() function

24

Hi Brad,

I have this error when trying to remove a smartapp.

Screenshot 2019-12-13 at 18.58.19
Screenshot 2019-12-13 at 18.58.191600×186 8.05 KB

I spend hours trying to remove this smartapp without success. Please advise.

Americo

25

Hi @Brad_ST,

I too am now seeing this issue - I have a Device Handler that won’t remove and also the associated SmartApp.

If I try and uninstall from IDE (Locations Screen) I get:

There was an error uninstalling your SmartApp.

If I try and remove the Device using the DTH I get this error:

Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed

Are you able to help please, the details are:

Device Network ID: LGWD01
SmartApp: MQTT Bridge

Many thanks,
Guy

26

I’ve also raised ticket number #946265 relating to this.

1 Like
27

Not sure if ST Support removed the faulty device, or @Brad_ST did but its now remove and I’ve been able to successfully remove the dodgy SmartApp too. Thanks to either :smiley:

Now I need to watch more videos on how to integrate MQTT with ST before trying again.

Edit - 03/05/2020

OK - I’ve messed it up again, looks like there is something very wrong with the MQTT Bridge SmartApp.

Think I might have to give up trying to get MQTT working with ST :frowning:

Further Edit - 03/05/2020

It looks like waiting a couple of hours and then removing the device and SmartApp seems to work :slight_smile:

1 Like
28

was there ever any solution to this? i am trying to remove a few virtual devices that i am no longer using and i am getting this error and cannot remove them in IDE:

Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed

29

Did you ever find a resolution to this? I’m having the same issue trying to remove simple virtual devices in not using any longer.