Changes

Jump to: navigation, search

Attachment SQL

1,106 bytes added, 17:33, 9 July 2014
Created page with "Sorry, we have decided to only have SELECT SQLs at these pages so this you have to check with Navicat and update the name if necessary in Table design manually. I created thi..."
Sorry, we have decided to only have SELECT SQLs at these pages so this you have to check with Navicat and update the name if necessary in Table design manually.

I created this page so all points on the checklist has a SQL page so this point is not missed.

If the column name is not correct this error message below will be trigged when the user opens any Summary window:
com.fgm.imsma.model.exception.ModelException: org.hibernate.PropertyAccessException: Exception occurred inside setter of com.fgm.imsma.pojo.Fieldreport.attachments

at java.awt.EventDispatchThread.run(Unknown Source) Caused by: org.hibernate.PropertyAccessException: Exception occurred inside setter of com.fgm.imsma.pojo.Fieldreport.attachments

Caused by: org.hibernate.exception.SQLGrammarException: could not initialize a collection: [com.fgm.imsma.pojo.Fieldreport.attachments#0aac-90b2-132a55d88aa-33985c11-8c-e68]

Caused by: org.postgresql.util.PSQLException: ERROR: '''column attachment0_.Filedescription does not exist'''

(short version of error message)

[[Category:SQL Queries]]

[[Category:NoPublic]]
[[Category:NAA]]
6,632
edits

Navigation menu