Informix requires colon between catalog and table name

Description

I have two databases in an Informix server:

  • payment

  • security

Payment database has the following tables:
+ employee
+ income

Security database has the following tables:
+ user
+ role

If I connect to the payment database, I can select security database with the syntax below:

select * from security:user where username='john.connor'

But hibernate cannot generate such statement. I find the method

org.hibernate.mapping.Table.qualify(String catalog, String schema, String table)

which necessarily append dot (".") between catalog/schema and table name.

I suggest delegate such concatenation to the Dialect.

Environment

Hibernate 3.3.1.GA, IBM Informix Dynamic Server Version 10.00.UC5

Duplicate

Assignee

Unassigned

Reporter

RanieriR

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major