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(); }
}
}
----- Here is my Postgres log -----
/usr/local/bin/postmaster: BackendStartup: pid 54277 user dfisher db dfisher socket 8
FindExec: found "/usr/local/bin/postgres" using argv[0]
2001-07-27 11:51:35 [54277] DEBUG: connection: host=127.0.0.1 user=dfisher
database=dfisher
2001-07-27 11:51:35 [54277] DEBUG: StartTransactionCommand
2001-07-27 11:51:35 [54277] DEBUG: query: set datestyle to 'ISO'; select
getdatabaseencoding()
2001-07-27 11:51:35 [54277] DEBUG: ProcessUtility: set datestyle to 'ISO'; select
getdatabaseencoding()
2001-07-27 11:51:35 [54277] DEBUG: CommitTransactionCommand
2001-07-27 11:51:35 [54277] DEBUG: StartTransactionCommand
2001-07-27 11:51:35 [54277] DEBUG: query: begin
2001-07-27 11:51:35 [54277] DEBUG: ProcessUtility: begin
2001-07-27 11:51:35 [54277] DEBUG: CommitTransactionCommand
2001-07-27 11:51:35 [54277] DEBUG: StartTransactionCommand
2001-07-27 11:51:35 [54277] DEBUG: query: SET TRANSACTION ISOLATION LEVEL READ
COMMITTED
2001-07-27 11:51:35 [54277] DEBUG: ProcessUtility: SET TRANSACTION ISOLATION LEVEL
READ COMMITTED
2001-07-27 11:51:35 [54277] DEBUG: CommitTransactionCommand
2001-07-27 11:51:35 [54277] DEBUG: StartTransactionCommand
2001-07-27 11:51:35 [54277] DEBUG: query: select proname, oid from pg_proc where
proname = 'lo_open' or proname = 'lo_close' or proname = 'lo_creat' or
proname = 'lo_unlink' or proname = 'lo_lseek' or proname = 'lo_tell' or
proname = 'loread'
or proname = 'lowrite'
2001-07-27 11:51:35 [54277] DEBUG: CommitTransactionCommand
2001-07-27 11:51:35 [54277] DEBUG: StartTransactionCommand
2001-07-27 11:51:35 [54277] DEBUG: CommitTransactionCommand
2001-07-27 11:51:35 [54277] DEBUG: StartTransactionCommand
2001-07-27 11:51:35 [54277] DEBUG: CommitTransactionCommand
2001-07-27 11:51:35 [54277] DEBUG: StartTransactionCommand
2001-07-27 11:51:35 [54277] DEBUG: CommitTransactionCommand
2001-07-27 11:51:35 [54277] DEBUG: StartTransactionCommand
2001-07-27 11:51:35 [54277] DEBUG: CommitTransactionCommand
2001-07-27 11:51:35 [54277] DEBUG: StartTransactionCommand
2001-07-27 11:51:35 [54277] DEBUG: query: INSERT INTO dfisher (image) VALUES (19291)
2001-07-27 11:51:35 [54277] DEBUG: CommitTransactionCommand
/usr/local/bin/postmaster: reaping dead processes...
/usr/local/bin/postmaster: CleanupProc: pid 54277 exited with status 0
----- Here is my JServ log -----
DriverManager.getConnection("jdbc:postgresql://localhost:5432/dfisher?user=dfisher&password=dfisher")
trying driver[className=org.postgresql.Driver,org.postgresql.Driver@e08d1172]
getConnection returning
driver[className=org.postgresql.Driver,org.postgresql.Driver@e08d1172]
Large Object initialised
--
Daniel Fisher
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
