Perhaps check out DynamicImageResource?
On Sat, Jul 2, 2011 at 7:39 AM, Miroslav F. <[email protected]> wrote:
> Hi folks,
>
> I have images in database as BLOBs and retrieving it with JDBC (not good
> code, just test at the moment)
> with this (just snip of the code):
>
> conn = Utils.makeConnection();//make connection with JDBC
> try
> {
> conn.setAutoCommit(false);
> st = conn.createStatement();
> rs = st.executeQuery("SELECT * FROM testdatabase.images");
> LargeObjectManager lobj = ((org.postgresql.PGConnection)
> conn).getLargeObjectAPI();
> while(rs.next())
> {
> Long oid = rs.getLong(7);
> LargeObject obj = lobj.open(oid, LargeObjectManager.READ);
> byte buf[] = new byte[obj.size()];
> obj.read(buf, 0, obj.size());
> //-->now I have image data in buf[], how can I put them into
> html?
> obj.close();
> }
> rs.close();
> st.close();
> conn.commit();
> }
> catch(SQLException e)
> {
> e.printStackTrace();
> }
>
> How can I put this image data into html page? Save it as file onto file
> system and then
> insert in src atribute of img tag? Or something else? Example is welcome.
>
> Thanks in advance,
>
> Miro
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>
