Attachment SQL - Revision history

Alnaucler at 09:23, 12 July 2014

2014-07-12T09:23:56Z

← Older revision		Revision as of 11:23, 12 July 2014
Line 1:		Line 1:
	{{~~note~~\|		{{Warning\| This page contains table '''design''' change syntax}}
	* 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.~~		Check the table design with Navicat and if necessary update the name of the column to leading capital F:
	}}		* manually in Table design '''OR'''
			* run this query
			<pre>
			ALTER TABLE attachment RENAME COLUMN "filedescription" TO "Filedescription";
			</pre>
	[[Image:Attachment error.png\|500px]]<br/>		[[Image:Attachment error.png\|500px]]<br/>
	If the column name is not correct this error message below will be triggered when the user opens any Summary window:		If the column name is not correct this error message below will be triggered when the user opens any Summary window:
Line 16:		Line 20:
	</code>		</code>

	{{note\|~~short~~ version of error message}}		{{note \| Short version of error message}}

	{{NavBox Upgrade}}		{{NavBox Upgrade}}

Alnaucler at 15:58, 9 July 2014

2014-07-09T15:58:13Z

← Older revision		Revision as of 17:58, 9 July 2014
Line 3:		Line 3:
	* I created this page so all points on the checklist has a SQL page so this point is not missed.		* I created this page so all points on the checklist has a SQL page so this point is not missed.
	}}		}}
			[[Image:Attachment error.png\|500px]]<br/>
	If the column name is not correct this error message below will be triggered when the user opens any Summary window:		If the column name is not correct this error message below will be triggered when the user opens any Summary window:

Dionysia at 15:53, 9 July 2014

2014-07-09T15:53:37Z

← Older revision		Revision as of 17:53, 9 July 2014
Line 16:		Line 16:
	</code>		</code>

	(short version of error message)		{{note\|short version of error message}}
	{{NavBox Upgrade}}
			{{NavBox Upgrade}}
	[[Category:SQL Queries]]		[[Category:SQL Queries]]

	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:NAA]]		[[Category:NAA]]

Dionysia: add code tag

2014-07-09T15:51:42Z

add code tag

← Older revision		Revision as of 17:51, 9 July 2014
Line 4:		Line 4:
	}}		}}

	If the column name is not correct this error message below will be triggered when the user opens any Summary window:<~~br/~~>		If the column name is not correct this error message below will be triggered 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
			<code>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		at java.awt.EventDispatchThread.run(Unknown Source) Caused by: org.hibernate.PropertyAccessException: Exception occurred inside setter of com.fgm.imsma.pojo.Fieldreport.attachments
Line 12:		Line 13:

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

			</code>

	(short version of error message)		(short version of error message)

Dionysia at 15:50, 9 July 2014

2014-07-09T15:50:17Z

← Older revision		Revision as of 17:50, 9 July 2014
Line 4:		Line 4:
	}}		}}

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

Dionysia: add note to make it visible

2014-07-09T15:49:34Z

add note to make it visible

← Older revision		Revision as of 17:49, 9 July 2014
Line 1:		Line 1:
	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.		{{note\|
	~~<br/><br/>~~		* 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.		* I created this page so all points on the checklist has a SQL page so this point is not missed.
	~~<br/><br/>~~		}}

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

Alnaucler at 15:36, 9 July 2014

2014-07-09T15:36:36Z

← Older revision		Revision as of 17:36, 9 July 2014
Line 13:		Line 13:

	(short version of error message)		(short version of error message)
			{{NavBox Upgrade}}
	[[Category:SQL Queries]]		[[Category:SQL Queries]]

	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 15:35, 9 July 2014

2014-07-09T15:35:49Z

← Older revision		Revision as of 17:35, 9 July 2014
Line 1:		Line 1:
	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.		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.
	<br/>		<br/><br/>
	I created this page so all points on the checklist has a SQL page so this point is not missed.		I created this page so all points on the checklist has a SQL page so this point is not missed.
	<br/>		<br/><br/>
	If the column name is not correct this error message below will be trigged when the user opens any Summary window:		If the column name is not correct this error message below will be trigged when the user opens any Summary window:<br/>
	com.fgm.imsma.model.exception.ModelException: org.hibernate.PropertyAccessException: Exception occurred inside setter of com.fgm.imsma.pojo.Fieldreport.attachments		com.fgm.imsma.model.exception.ModelException: org.hibernate.PropertyAccessException: Exception occurred inside setter of com.fgm.imsma.pojo.Fieldreport.attachments

Alnaucler at 15:34, 9 July 2014

2014-07-09T15:34:45Z

← Older revision		Revision as of 17:34, 9 July 2014
Line 1:		Line 1:
	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.		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.
			<br/>
	I created this page so all points on the checklist has a SQL page so this point is not missed.		I created this page so all points on the checklist has a SQL page so this point is not missed.
			<br/>
	If the column name is not correct this error message below will be trigged when the user opens any Summary window:		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		com.fgm.imsma.model.exception.ModelException: org.hibernate.PropertyAccessException: Exception occurred inside setter of com.fgm.imsma.pojo.Fieldreport.attachments

Alnaucler: 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..."

2014-07-09T15:33:59Z

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..."

New page

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]]