Hi!
I want to thanks dods team for the change they made to QueryBuilder
addUpdateColumn(RDBColumn column, Object value) that fix the problem i
reported.
But i'm curious: why do you have decided to keep the possibility to use
the column.getFullColumnName() for some databases?
It was for compatibility reasons? Do you know a db that need it?
Best regards and thanks again.
João Paulo Ribeiro
João Paulo Ribeiro wrote:
Hi.
I' m using dods 6.5.1 and im having an error when using the
QueryBuilder
addUpdateColumn(RDBColumn column, Object value) method.
What is happening is that i'm working with a postgresql (7.4) and the
db
give me an error (org.postgresql.util.PSQLException: ERROR: syntax
error
at or near ".") when executing an update query with FullColumnName
(table_name.column_name) in the SET part of the query.
For exemple:
UPDATE message SET message.text="hello world"
the correct sentence should be
UPDATE message SET text="hello world"
The last one work fine and the first one give me the
org.postgresql.util.PSQLException.
Im not sure but i think its not SQL92 compatible. I dont know if it
work
with other RDBMs but it doesn't with Postgresql.
What i propose is to do a little change to the method
addUpdateColumn(RDBColumn column, Object value) to use the method
getColumnName() instead of the method getFullColumnName().
The method addUpdateColumn(RDBColumn column, Object value) will be
changed from
public void addUpdateColumn(RDBColumn column, Object value) {
_addUpdateColumn(column.getFullColumnName(), value);
}
to
public void addUpdateColumn(RDBColumn column, Object value) {
_addUpdateColumn(column.getColumnName(), value);
}
For the moment im using the deprecated method addUpdateColumn(String
column, Object value) as workaround but i will be happy if this change
could be made.
Best regards.
João Paulo Ribeiro
--
You receive this message as a subscriber of the enhydra@xxxxxxxxxxxxx mailing list.
To unsubscribe: mailto:enhydra-unsubscribe@xxxxxxxxxxxxx
For general help: mailto:sympa@xxxxxxxxxxxxx?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
--
João Paulo Ribeiro | Senior Software Engineer
jp@xxxxxxxxxxxx
PHONE: + 351 253 305 250
FAX : + 351 253 305 250
www.mobicomp.com
________________________________________________________________
About Solutions | Wireless World
CONFIDENTIALITY NOTICE: This message, as well as existing attached files, is confidential and intended exclusively for the individual(s) named as addressees. If you are not the intended recipient, you are kindly requested not to make any use whatsoever of its contents and to proceed to the destruction of the message, thereby notifying the sender.
DISCLAIMER: The sender of this message can not ensure the security of its electronic transmission and consequently does not accept liability for any fact which may interfere with the integrity of its content.
|
