Re: Large Objects

On Friday 27 July 2001 16:59, Daniel Fisher wrote:
> I'm am attempting to make one of my Java servlets work with both MySQL &
> Postgres. I'm having some trouble inserting a large object into the
> database. I'm fairly certain that the problem is in my java code because I
> wrote some quick PHP code and it worked fine. The main problem is I'm not
> getting any errors, so I'm kinda stumped. The code appears to run fine, but
> nothing is being inserted into the database. Any help would be appreciated.
>
> ----- Here is my Java source -----
>
>     // getConnection gives me a database connection
>     // image is a byte[] passed to this function
>
>     Connection conn = null;
>     PreparedStatement pstmt = null;
>
>     try {
>
>       conn = getConnection();
>       conn.setAutoCommit(false);
>       pstmt = conn.prepareStatement("INSERT INTO dfisher (image) VALUES
> (?)"); pstmt.setBytes(1, image);
>       pstmt.executeUpdate();
>
>     } catch (Exception e) {
>       e.printStackTrace();
>     }
>     finally {
>       try { if (pstmt != null) pstmt.close(); } catch (Exception e) {
> e.printStackTrace(); } try { if (conn != null) conn.close(); } catch
> (Exception e) { e.printStackTrace(); } }
>   }
if you want to insert Large Objects, you need to use one of the setXXXStream
of the statement, not setBytes.