how to use toupper_column_name

[Nobody/Anonymous]

Hi,

I just switched to use ALPHA_Q version for hsql. Using version ALHA_M, my application was working fine. Using the new alpha, I get the following exception:
Exception in thread "main" java.sql.SQLException: Column not found: id
        at org.hsqldb.jdbcDriver.sqlException(Unknown Source)
        at org.hsqldb.jdbcDriver.sqlException(Unknown Source)
        at org.hsqldb.jdbcResultSet.findColumn(Unknown Source)
        at org.hsqldb.jdbcResultSet.getString(Unknown Source)
        at net.sf.hibernate.type.StringType.get(StringType.java:14)
....

I compared the ALPHA_Q code with the ALPHA_M code, and I think I will be able to solve my problem by setting the toupper_column_name property. Can someone tell me where I can set this property?

regards,

Kenneth

[Nobody/Anonymous]

Allright, found where to set this property. This join is returning a wrong result however:

select mediumco0_.id as id,
    casewhen(mediumco0__1.id is not null, 1,
    casewhen(mediumco0__2.id is not null, 2,
    casewhen(mediumco0_.id is not null, 0, -1))) as clazz_,
    mediumco0_.title as title0_
from
    MEDIUM_CONTAINER mediumco0_
    left outer join SLEEVE mediumco0__1 on mediumco0_.id=mediumco0__1.id
    left outer join CAZE mediumco0__2 on mediumco0_.id=mediumco0__2.id

All stuff from table SLEEVE is not being returned.

[Fred Toussi]

The results of OUTER joins can be different as the code has been modified to avoid certain issues which existed in ALPHA_M.

Please submit a test case with some data that demonstrates the problem to the Bug Tracker.

[kenneth westelinck]

Hi again,

I submitted the bug, it has ID 819755. If you need more details, don't hesitate to ask.

regards,

Kenneth

[Nobody/Anonymous]

Still no one answer how to set toupper_column_name?

[Nobody/Anonymous]

This is no longer necessary with ALPHA_T. It treats ResultSet columns as case-insensitive.