Hi: I am actually using the java app directly with postgres and it is working fine. The only thing that i am considering is that, we are using postgres driver build 400 before, while with sequoia we are using build 407. Can we use 400 with sequoia?
Thanks for your feedback. Mylein Blanca Uy Condensed Matter Physics Laboratory National Institute of Physics University of the Philippines, Diliman Quezon City, 1101, Philippines ----- Original Message ---- From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, 25 October, 2007 12:00:06 AM Subject: Sequoia Digest, Vol 26, Issue 36 Send Sequoia mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit https://forge.continuent.org/mailman/listinfo/sequoia or, via email, send a message with subject or body 'help' to [EMAIL PROTECTED] You can reach the person managing the list at [EMAIL PROTECTED] When replying, please edit your Subject line so it is more specific than "Re: Contents of Sequoia digest..." Today's Topics: 1. Re: alter table alter column doesn't work anymore (Emmanuel Cecchet) 2. Re: Re: Error with Write Request: (ERROR: could not determin data type of parameter $5) (Mylein) (Mylein) 3. Re: Re: Re: Error with Write Request: (ERROR: could not determin data type of parameter $5) (Mylein) (Emmanuel Cecchet) ---------------------------------------------------------------------- Hi: thank you for your reply. The 5th parameter in the SQL statement is java.sql.Timestamp. > Does the code work directly against the PostgreSQL driver? Yes. > Could you post the Java code that executes this query? This is a condensed form of the actual code: String vSQL = "UPDATE tbl_users SET lastupdated = ?, lastlogondate = ? WHERE id = ? AND ( ( lastupdated = ? ) OR ( ? IS NULL AND lastupdated IS NULL ))"; java.sql.PreparedStatement oPrepStatement = oJDBCConnection.prepareStatement(vSQL); ... java.sql.Timestamp oLastUpdated = oTool.convertToTimestamp("2007-10-11 11:32:49.559"); oPrepStatement.setTimestamp(5, oLastUpdated); oPrepStatement.executeUpdate(); ------------------------------------------------------------------------------- Our log shows the following Information: SQL: UPDATE tbl_users SET lastupdated = ?, lastlogondate = ? WHERE id = ? AND ( ( lastupdated = ? ) OR ( ? IS NULL AND lastupdated IS NULL )) sql_param: <!%T|2007-10-23 11:37:04.589|!%> <!%T|2007-10-23 11:37:04.588|!%> <!%1|49|!%> <!%T|2007-10-11 11:32:49.559|!%> <!%T|2007-10-11 11:32:49.559|!%> ---------------------- Thank you very much. Mylein Blanca Uy Condensed Matter Physics Laboratory National Institute of Physics University of the Philippines, Diliman Quezon City, 1101, Philippines - ------------------------------ Message: 2 Date: Tue, 23 Oct 2007 10:39:49 +0200 From: Emmanuel Cecchet <[EMAIL PROTECTED]> Subject: Re: [Sequoia] Error with Write Request: (ERROR: could not determine data type of parameter $5) To: Sequoia general mailing list <[email protected]> Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Hi, > I tried to use sequoia cluster with my java app. When my java app > tries to make an update on one of the tables of the database backend, > both sequoia controllers display this error: > -------------------------------------------------------------------------------------- > ERROR controller.loadbalancer.RAIDb1 write request 9 failed: > Backend System_DB - BackendWorkerThread for backend 'System_DB1' with > RAIDb level:1 failed (ERROR: could not determine data type of parameter > $5) This is an error returned by the PostgreSQL driver. What is the type of your 5th parameter in your PreparedStatement? Does the code work directly against the PostgreSQL driver? Could you post the Java code that executes this query? Thanks for your feedback, Emmanuel Sick of deleting your inbox? Yahoo!7 Mail has free unlimited storage. http://au.docs.yahoo.com/mail/unlimitedstorage.html -------------- next part -------------- An HTML attachment was scrubbed... URL: http://forge.continuent.org/pipermail/sequoia/attachments/20071023/5efb0394/attachment.html Sick of deleting your inbox? Yahoo!7 Mail has free unlimited storage. http://au.docs.yahoo.com/mail/unlimitedstorage.html
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
