I have a postgreSQL database. In one table, i store photos in a OID field type. When i extract it in a resultset from my Java program, how can i show it in a new ImageIcon?? I am trying something like this: ResultSet oid=sentencia.executeQuery("SELECT photo FROM tablePhotos where id ='anyID';"); oid.next();
It works, but if i execute my program in another computer (not in the database server), i cannot use this because lo_import works locally in the server filesystem...
I need how to extract the photo from the OID directly, from my resultset to the ImageIcon...