Hi I'm building a system with hibernate and an existing database in Informix. Informix sql syntax supports the notation <database>:<table-name> for selecting from tables in another database than the one currently connected to. Since hibernate uses the : character to prefix named parameters the colon doesn't get passed to the database. Any ideas how to solve this ? I'm new to hibernate but I guess there must be a way of escaping the colon to indicate to hibernate that it should remain in the query ?

Thankfull for any help on this

Regards
Steinar Dahl

Nope, the colon is non-escapable

Can't that be considered a bug or a missing feature ? It should not be that hard to add logic to the interpreter to understand an escape character, should it ?

the problem with issues like this is always "ok, then what is the escape character?". It's harder to do then to say ;)

Besides any real database that allows this behavior also allows local namespacing of the linked-to database (database-links in Oracle, linked-servers in SQLServer/Sybase).

Personally I would escape it with itself for that particular case only.

On the other hand, you're most probably right about DB namespacing features. I was just asking for the sake of completeness. :-)

Thanks for the information. Will probably put the query in a database view to work around this issue.

Maybe there should be a section in the manual describing what the limitations are with native sql ?

patches are welcome.

ok, I've got a patch. We're do I submit it ?

A new JIRA bug is the best place I would say. Just attach your patch to the bug.