Hibernate Community • View topic - SchemaUpdate uses like '%' which wont work with hsqldb

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

SchemaUpdate uses like '%' which wont work with hsqldb

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

imario

Post subject: SchemaUpdate uses like '%' which wont work with hsqldb

Posted: Mon Jan 26, 2004 6:04 pm

Regular

Joined: Thu Dec 11, 2003 4:14 pm
Posts: 86
Location: Hibernate 3 + annotations, Oracle 9i, PostgreSQL 8.0, Java 1.5.0

Hello !

In Hsqldb the tables do have schema null, now the SchemaUpdate uses a query like
select * from system_tables where table_schem like '%'
which do not return a row.

Now i am searching where to place the error:
1) should "table_schem like '%'" match to rows with null or
2) should the query changed to something like this
select * from system_tables where (table_schem like '%' or table_schem is null)

I prefer 2, SchemaUpdate should pass "null" if the schema is not required to be filtered.

Thanks!

Top

imario

Post subject:

Posted: Tue Jan 27, 2004 3:59 am