By Date: <-- -->
By Thread: <-- -->

Storing document page by page in DB

Hi,

If you just want to make fun of me, please do go elsewhere.
Bruno

well I just want to express that did i done something amazing ..........but You got so angry for that I m sorry...

well I want to share my experience working with the blob object and the bytes array

I found that if the size of a file is less then the size of that blob object buffer then it will not store any data

I am trying to find out why this is happen and if any body knows then please share his/her knowledge with me cause I want to know why it happens that if the byte array size is less then the blob size then y it not store any data in database.

well I also share my experience of storing pages sepratly I didn't tried it yet and share it soon

Thanx for the help

Waq

I execute this code. its fine for now.

public void strorePage(Connection conn, long sequanceNo,ByteArrayOutputStream pdfOutputStream) throws SQLException, IOException {

       boolean success = false;
       BLOB dbObject = null;
       Statement stmt = conn.createStatement();
	conn.setAutoCommit(false);

String sql = "INSERT INTO TablePage(PAGEID, PAGEDATA) VALUES (" + sequanceNo + ",empty_blob())";
stmt.execute(sql);
sql = "SELECT PAGEDATA FROM TablePage WHERE PAGEID = " + sequanceNo;
ResultSet rs = stmt.executeQuery(sql);
if (rs.next()) {
dbObject = ((OracleResultSet) rs).getBLOB("PAGEDATA");
}
if (dbObject != null) {

           try {
               byte[] bytes = pdfOutputStream.toByteArray();
               OutputStream outStream = dbObject.getBinaryOutputStream();
               int fileSize = dbObject.getBufferSize();

               outStream.write(bytes, 0, bytes.length);

// here i m trying to fill the empty space in the byte array if the file size is less then the size of the blob
byte[] empty = new byte[fileSize - bytes.length];
java.util.Arrays.fill(empty, (byte)0);
outStream.write(empty);
outStream.close();
pdfOutputStream.close();
} catch (IOException ex) {
}
}

Waq

From: bruno <bruno (at) lowagie.com>
To: Waq lala <waqarqayyum911 (at) hotmail.com>
CC: itext-questions (at) lists.sourceforge.net
Subject: Re: [iText-questions] Storing document page by page in DB
Date: Mon, 15 May 2006 16:12:18 +0200

Waq lala wrote:


hahaha 

I am not amused.

yes i execute it and as i told u that i m able to store this Blob Object. 

I must have missed that. Your mail was hard to understand.

now i m still there where i was....... 

I have no idea where that is.

I want to store the document object in database as i explain prevoisly plz help me out from this 

You say you can store the document in the database.
I quote: " told u that i m able to store this Blob Object".

If by "i explain prevoisly" you mean you want to store
separate pages, then I can only repeat what I have said before.
"Use the class com.lowagie.tools.plugins.Burst as inspiration
to split the file in the ByteArrayOutputStream into separate pages.
Write each page to another ByteArrayOutputStream. Save the
byte[] obtained from the ByteArrayOutputStream to your database
as a BLOB."
If you mean something else, then I have no idea what you are
talking about.
If you just want to make fun of me, please do go elsewhere.
br,
Bruno

_________________________________________________________________
Don't just search. Find. Check out the new MSN Search! http://search.msn.com/



-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
iText-questions mailing list
iText-questions (at) lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/itext-questions