StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>We are doing exactly that with the "original" Java Hibernate3. You just map a byte array property of your persistable class to an column of Type "image".</p> <pre><code>package com.hibernate.pdf.sample; public class TPDFDocument implements java.io.Serializable { private Integer pdfDocumentId; private byte[] document; public Integer getPdfDocumentId() { return this.pdfDocumentId; } public void setPdfDocumentId(Integer pdfDocumentId) { this.pdfDocumentId = pdfDocumentId; } public byte[] getDocument() { return this.document; } public void setDocument(byte[] document) { this.document = document; } } </code></pre> <p>Hibernate Mapping:</p> <pre><code><hibernate-mapping> <class name="com.hibernate.pdf.sample.TPDFDocument" table="T_PDFDocument"> <id name="pdfDocumentId" type="integer"> <column name="pdfDocumentId" /> <generator class="identity" /> </id> <property name="document" type="binary"> <column name="document" not-null="true" /> </property> </class> </hibernate-mapping> </code></pre> <p>Table creation:</p> <pre><code>CREATE TABLE [dbo].[T_PDFDocument]( [pdfDocumentId] [int] IDENTITY(1,1) NOT NULL, [document] [image] NOT NULL, CONSTRAINT [PK_PDFDocument] PRIMARY KEY CLUSTERED ( [pdfDocumentId] ASC ) </code></pre> <p>All you have to do is to read the documents raw bytes into the array and persist it. In our situation the documents will get hardly larger than 1MB , so putting the whole thing into the byte-array won't cause performance issues. Maybe this solution isn't feasable for very large documents.</p> <p>I guess with NHibernate implementation and C# the solution will look very similar.</p>

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