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
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
