Databases
StackOverflow2013
Postsdbo
POseam file upload to postgres bytea column " column is bytea but expression is of type bigint"
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POseam file upload to postgres bytea column " column is bytea but expression is of type bigint"
    text
    copied!<p>Closely following <a href="http://seamframework.org/Documentation/HowToUploadAndDownloadFilesInSeam" rel="nofollow">this example</a>, I'm uploading a small file and trying to store into postgresql bytea column. </p> <p>Here is error (first two outputs are logging statements outputting attributes of bean before the INSERT is attempted:</p> <blockquote> <p>SAGE 1 -- action.registration.LetterTemplateHome - content type: text/xml</p> <p>SAGE 1 -- action.registration.LetterTemplateHome - letterTemplateText: [B@48c7aaef</p> <p>SAGE 1 -- action.registration.LetterTemplateHome - contents as String: xml version="1.0" encoding="UTF-8" standalone="yes" .... etc</p> <p>SAGE 1 -- org.hibernate.util.JDBCExceptionReporter - Batch entry 0 insert into letter_template (content_type, file_name_template, fileSize, letter_template_name, letter_template_text, letter_template_id) values ('text/xml', 'letterDate.xml', '0', 'yu', '37078', '202') was aborted. Call getNextException to see the cause.</p> <p>SAGE 1 -- org.hibernate.util.JDBCExceptionReporter - ERROR: column "letter_template_text" is of type bytea but expression is of type bigint Hint: You will need to rewrite or cast the expression. Position: 162</p> </blockquote> <p>here is how the field is defined in the bean:</p> <pre><code> private byte[] letterTemplateText; @Lob @Column(name = "letter_template_text") @Basic(fetch = FetchType.LAZY) public byte[] getLetterTemplateText() { return this.letterTemplateText; } public void setLetterTemplateText(byte[] letterTemplateText) { this.letterTemplateText = letterTemplateText; } </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload