Advanced Search

Postgres: How to insert oid value using JDBC API

/ Published in: Java
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. conn.setAutoCommit(false);
  2.  
  3. // Get the Large Object Manager to perform operations with
  4. LargeObjectManager lobj = ((org.postgresql.PGConnection)conn).getLargeObjectAPI();
  5.  
  6. // Create a new large object
  7. int oid = lobj.create(LargeObjectManager.READ | LargeObjectManager.WRITE);
  8.  
  9. // Open the large object for writing
  10. LargeObject obj = lobj.open(oid, LargeObjectManager.WRITE);
  11.  
  12. // Now open the file
  13. File file = new File("myimage.gif");
  14. FileInputStream fis = new FileInputStream(file);
  15.  
  16. // Copy the data from the file to the large object
  17. byte buf[] = new byte[2048];
  18. int s, tl = 0;
  19. while ((s = fis.read(buf, 0, 2048)) > 0) {
  20.     obj.write(buf, 0, s);
  21.     tl += s;
  22. }
  23.  
  24. // Close the large object
  25. obj.close();
  26.  
  27.  
  28. //later
  29. ps.setInt(<index>, oid);
  30.  
  31.  
  32.  
  33. conn.commit();
  34. conn.close();

URL: http://www.postgresql.org/docs/7.4/static/jdbc-binary-data.html

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.