5:19 a.m.
Boolean substitution in informix
--------------------------------
Key: HHH-3551
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3551
Project: Hibernate Core
Issue Type: Bug
Components: query-sql
Affects Versions: 3.3.1
Environment: Hibernate 3.2
Informix 9.40
Reporter: Rouvignac
HQL Query :
select order from Order order where order.printed = ?
Parameter :
true, false, Boolean.TRUE or Boolean.FALSE
When the request is executed we get the following error :
SQLSTATE: IX000
SQL CODE: -674
674: Routine (equal) can not be resolved.
If as parameter we use "t" ot "f" everything works fine but it will
not work with other DB.
As a workaround we can use :
property name="hibernate.query.substitutions">true t, false
f</property>
I investigated in Dialects :
Dialect.java
public String toBooleanValueString(boolean bool) {
return bool ? "1" : "0";
}
PostgreSQLDialect.java
public String toBooleanValueString(boolean bool) {
return bool ? "true" : "false";
}
InformixDialect.java uses Dialect.java toBooleanValueString method.
In my mind toBooleanValueString should be added to InformixDialect.java as follow :
public String toBooleanValueString(boolean bool) {
return bool ? "t" : "f";
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:29 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3551) Boolean substitution in informix
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3551?page=c...
]
Rouvignac commented on HHH-3551:
--------------------------------
Nevermind, my issue was due to a bad JDBC driver version.
Please close this issue as I don't know how to do.
Boolean substitution in informix
--------------------------------
Key: HHH-3551
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3551
Project: Hibernate Core
Issue Type: Bug
Components: query-sql
Affects Versions: 3.3.1
Environment: Hibernate 3.2
Informix 9.40
Reporter: Rouvignac
Original Estimate: 2 hours
Remaining Estimate: 2 hours
HQL Query :
select order from Order order where order.printed = ?
Parameter :
true, false, Boolean.TRUE or Boolean.FALSE
When the request is executed we get the following error :
SQLSTATE: IX000
SQL CODE: -674
674: Routine (equal) can not be resolved.
If as parameter we use "t" ot "f" everything works fine but it will
not work with other DB.
As a workaround we can use :
property name="hibernate.query.substitutions">true t, false
f</property>
I investigated in Dialects :
Dialect.java
public String toBooleanValueString(boolean bool) {
return bool ? "1" : "0";
}
PostgreSQLDialect.java
public String toBooleanValueString(boolean bool) {
return bool ? "true" : "false";
}
InformixDialect.java uses Dialect.java toBooleanValueString method.
In my mind toBooleanValueString should be added to InformixDialect.java as follow :
public String toBooleanValueString(boolean bool) {
return bool ? "t" : "f";
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:57 a.m.
New subject: [Hibernate-JIRA] Closed: (HHH-3551) Boolean substitution in informix
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3551?page=c...
]
Chris Bredesen closed HHH-3551.
-------------------------------
Resolution: Rejected
Boolean substitution in informix
--------------------------------
Key: HHH-3551
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3551
Project: Hibernate Core
Issue Type: Bug
Components: query-sql
Affects Versions: 3.3.1
Environment: Hibernate 3.2
Informix 9.40
Reporter: Rouvignac
Original Estimate: 2 hours
Remaining Estimate: 2 hours
HQL Query :
select order from Order order where order.printed = ?
Parameter :
true, false, Boolean.TRUE or Boolean.FALSE
When the request is executed we get the following error :
SQLSTATE: IX000
SQL CODE: -674
674: Routine (equal) can not be resolved.
If as parameter we use "t" ot "f" everything works fine but it will
not work with other DB.
As a workaround we can use :
property name="hibernate.query.substitutions">true t, false
f</property>
I investigated in Dialects :
Dialect.java
public String toBooleanValueString(boolean bool) {
return bool ? "1" : "0";
}
PostgreSQLDialect.java
public String toBooleanValueString(boolean bool) {
return bool ? "true" : "false";
}
InformixDialect.java uses Dialect.java toBooleanValueString method.
In my mind toBooleanValueString should be added to InformixDialect.java as follow :
public String toBooleanValueString(boolean bool) {
return bool ? "t" : "f";
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:52 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3551) Boolean substitution in informix
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3551?page=c...
]
Laird Nelson commented on HHH-3551:
-----------------------------------
The analysis of the issue given by the original poster appears to be valid to me, and we
seem to be running into this issue with the latest Informix driver (3.70.JC1). I
don't see how the driver upgrade would have solved this issue. Can we reopen this
bug, if only to re-confirm?
Boolean substitution in informix
--------------------------------
Key: HHH-3551
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3551
Project: Hibernate Core
Issue Type: Bug
Components: query-sql
Affects Versions: 3.3.1
Environment: Hibernate 3.2
Informix 9.40
Reporter: Rouvignac
Original Estimate: 2h
Remaining Estimate: 2h
HQL Query :
select order from Order order where order.printed = ?
Parameter :
true, false, Boolean.TRUE or Boolean.FALSE
When the request is executed we get the following error :
SQLSTATE: IX000
SQL CODE: -674
674: Routine (equal) can not be resolved.
If as parameter we use "t" ot "f" everything works fine but it will
not work with other DB.
As a workaround we can use :
property name="hibernate.query.substitutions">true t, false
f</property>
I investigated in Dialects :
Dialect.java
public String toBooleanValueString(boolean bool) {
return bool ? "1" : "0";
}
PostgreSQLDialect.java
public String toBooleanValueString(boolean bool) {
return bool ? "true" : "false";
}
InformixDialect.java uses Dialect.java toBooleanValueString method.
In my mind toBooleanValueString should be added to InformixDialect.java as follow :
public String toBooleanValueString(boolean bool) {
return bool ? "t" : "f";
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:32 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3551) Boolean substitution in informix
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3551?page=c...
]
Laird Nelson commented on HHH-3551:
-----------------------------------
I have sent a pull request from github (my first time using git, github and
gradle...yikes) that contains a patch that fixes this bug. To Rouvignac's credit, it
is simply his patch as already detailed in the bug report here. Please let me know what
else I have to do to get this bug fixed. Thanks!
Boolean substitution in informix
--------------------------------
Key: HHH-3551
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3551
Project: Hibernate Core
Issue Type: Bug
Components: query-sql
Affects Versions: 3.3.1
Environment: Hibernate 3.2
Informix 9.40
Reporter: Rouvignac
Original Estimate: 2h
Remaining Estimate: 2h
HQL Query :
select order from Order order where order.printed = ?
Parameter :
true, false, Boolean.TRUE or Boolean.FALSE
When the request is executed we get the following error :
SQLSTATE: IX000
SQL CODE: -674
674: Routine (equal) can not be resolved.
If as parameter we use "t" ot "f" everything works fine but it will
not work with other DB.
As a workaround we can use :
property name="hibernate.query.substitutions">true t, false
f</property>
I investigated in Dialects :
Dialect.java
public String toBooleanValueString(boolean bool) {
return bool ? "1" : "0";
}
PostgreSQLDialect.java
public String toBooleanValueString(boolean bool) {
return bool ? "true" : "false";
}
InformixDialect.java uses Dialect.java toBooleanValueString method.
In my mind toBooleanValueString should be added to InformixDialect.java as follow :
public String toBooleanValueString(boolean bool) {
return bool ? "t" : "f";
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:40 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3551) Boolean substitution in informix
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3551?page=c...
]
Laird Nelson commented on HHH-3551:
-----------------------------------
The pull request is here: https://github.com/hibernate/hibernate-core/pull/27
Boolean substitution in informix
--------------------------------
Key: HHH-3551
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3551
Project: Hibernate Core
Issue Type: Bug
Components: query-sql
Affects Versions: 3.3.1
Environment: Hibernate 3.2
Informix 9.40
Reporter: Rouvignac
Original Estimate: 2h
Remaining Estimate: 2h
HQL Query :
select order from Order order where order.printed = ?
Parameter :
true, false, Boolean.TRUE or Boolean.FALSE
When the request is executed we get the following error :
SQLSTATE: IX000
SQL CODE: -674
674: Routine (equal) can not be resolved.
If as parameter we use "t" ot "f" everything works fine but it will
not work with other DB.
As a workaround we can use :
property name="hibernate.query.substitutions">true t, false
f</property>
I investigated in Dialects :
Dialect.java
public String toBooleanValueString(boolean bool) {
return bool ? "1" : "0";
}
PostgreSQLDialect.java
public String toBooleanValueString(boolean bool) {
return bool ? "true" : "false";
}
InformixDialect.java uses Dialect.java toBooleanValueString method.
In my mind toBooleanValueString should be added to InformixDialect.java as follow :
public String toBooleanValueString(boolean bool) {
return bool ? "t" : "f";
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:33 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3551) Boolean substitution in informix
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3551?page=c...
]
Rouvignac commented on HHH-3551:
--------------------------------
Maybe I mistaken with the update in the driver.
As i remember our problems disappeared with the use of 3.50.JC5 driver.
We still use that one with Informix 11.50.
In order to give some more help, here is the latest custom dialect we use :
import java.sql.Types;
import org.hibernate.Hibernate;
import org.hibernate.dialect.function.NoArgSQLFunction;
import org.hibernate.dialect.function.NvlFunction;
import org.hibernate.dialect.function.SQLFunctionTemplate;
public class InformixDialect extends org.hibernate.dialect.InformixDialect {
private static final int CLOB_MAXIMUM_LENGTH = 32739;
public InformixDialect() {
super();
this.registerColumnType(Types.CLOB, InformixDialect.CLOB_MAXIMUM_LENGTH,
"lvarchar($l)");
this.registerFunction("current_date", new
NoArgSQLFunction("today", Hibernate.DATE, false));
this.registerFunction("coalesce", new NvlFunction());
this.registerFunction("year", new SQLFunctionTemplate(Hibernate.INTEGER,
"year(?1)"));
this.registerFunction("month", new
SQLFunctionTemplate(Hibernate.INTEGER, "month(?1)"));
this.registerFunction("day", new SQLFunctionTemplate(Hibernate.INTEGER,
"day(?1)"));
this.registerFunction("extract", new
SQLFunctionTemplate(Hibernate.INTEGER, "?1(?3)"));
}
@Override
public String toBooleanValueString(boolean bool) {
return bool ? "t" : "f";
}
@Override
public boolean supportsTemporaryTables() {
return true;
}
}
In the persistence.xml we defined :
<property name="hibernate.query.substitutions"
value="'true'='t', 'false'='f'" />
This is for queries which tests: "something='true'".
In source code we use "something=?" but we have a query builder for our
customers were they write "something='true'" in queries.
Boolean substitution in informix
--------------------------------
Key: HHH-3551
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3551
Project: Hibernate Core
Issue Type: Bug
Components: query-sql
Affects Versions: 3.3.1
Environment: Hibernate 3.2
Informix 9.40
Reporter: Rouvignac
Original Estimate: 2h
Remaining Estimate: 2h
HQL Query :
select order from Order order where order.printed = ?
Parameter :
true, false, Boolean.TRUE or Boolean.FALSE
When the request is executed we get the following error :
SQLSTATE: IX000
SQL CODE: -674
674: Routine (equal) can not be resolved.
If as parameter we use "t" ot "f" everything works fine but it will
not work with other DB.
As a workaround we can use :
property name="hibernate.query.substitutions">true t, false
f</property>
I investigated in Dialects :
Dialect.java
public String toBooleanValueString(boolean bool) {
return bool ? "1" : "0";
}
PostgreSQLDialect.java
public String toBooleanValueString(boolean bool) {
return bool ? "true" : "false";
}
InformixDialect.java uses Dialect.java toBooleanValueString method.
In my mind toBooleanValueString should be added to InformixDialect.java as follow :
public String toBooleanValueString(boolean bool) {
return bool ? "t" : "f";
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:59 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3551) Boolean substitution in informix
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3551?page=c...
]
Hardy Ferentschik commented on HHH-3551:
----------------------------------------
@Rouvignac in your custom dialect you still override _toBooleanValueString_ which would
indicate that it is in fact needed in _InformixDialect_.
Boolean substitution in informix
--------------------------------
Key: HHH-3551
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3551
Project: Hibernate Core
Issue Type: Bug
Components: query-sql
Affects Versions: 3.3.1
Environment: Hibernate 3.2
Informix 9.40
Reporter: Rouvignac
Original Estimate: 2h
Remaining Estimate: 2h
HQL Query :
select order from Order order where order.printed = ?
Parameter :
true, false, Boolean.TRUE or Boolean.FALSE
When the request is executed we get the following error :
SQLSTATE: IX000
SQL CODE: -674
674: Routine (equal) can not be resolved.
If as parameter we use "t" ot "f" everything works fine but it will
not work with other DB.
As a workaround we can use :
property name="hibernate.query.substitutions">true t, false
f</property>
I investigated in Dialects :
Dialect.java
public String toBooleanValueString(boolean bool) {
return bool ? "1" : "0";
}
PostgreSQLDialect.java
public String toBooleanValueString(boolean bool) {
return bool ? "true" : "false";
}
InformixDialect.java uses Dialect.java toBooleanValueString method.
In my mind toBooleanValueString should be added to InformixDialect.java as follow :
public String toBooleanValueString(boolean bool) {
return bool ? "t" : "f";
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:58 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3551) Boolean substitution in informix
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3551?page=c...
]
Rouvignac commented on HHH-3551:
--------------------------------
Well, as i remember, while testing i put a breakpoint in my custom dialect
toBooleanValueString method but the execution never suspended threre.
I keeped toBooleanValueString because org.hibernate.dialect.InformixDialect is incorrect
in Hibernate 3.2.7 version we use.
As i am sure i didn't test all dialect use case, i prefered to keep
toBooleanValueString.
As i can see Laird Nelson added "'" around return values in
toBooleanValueString : public String toBooleanValueString(boolean bool) { return bool ?
"'t'" : "'f'"; }
This seems to indicate a bug in my dialect.
I think he uses a latest version than hibernate 3.2.7 in which toBooleanValueString is
more usefull. That should be why my breakpoint never suspended execution.
Boolean substitution in informix
--------------------------------
Key: HHH-3551
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3551
Project: Hibernate Core
Issue Type: Bug
Components: query-sql
Affects Versions: 3.3.1
Environment: Hibernate 3.2
Informix 9.40
Reporter: Rouvignac
Original Estimate: 2h
Remaining Estimate: 2h
HQL Query :
select order from Order order where order.printed = ?
Parameter :
true, false, Boolean.TRUE or Boolean.FALSE
When the request is executed we get the following error :
SQLSTATE: IX000
SQL CODE: -674
674: Routine (equal) can not be resolved.
If as parameter we use "t" ot "f" everything works fine but it will
not work with other DB.
As a workaround we can use :
property name="hibernate.query.substitutions">true t, false
f</property>
I investigated in Dialects :
Dialect.java
public String toBooleanValueString(boolean bool) {
return bool ? "1" : "0";
}
PostgreSQLDialect.java
public String toBooleanValueString(boolean bool) {
return bool ? "true" : "false";
}
InformixDialect.java uses Dialect.java toBooleanValueString method.
In my mind toBooleanValueString should be added to InformixDialect.java as follow :
public String toBooleanValueString(boolean bool) {
return bool ? "t" : "f";
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5095
days inactive
5899
days old
hibernate-issues@lists.jboss.org
8 comments
4 participants
participants (4)
-
Chris Bredesen (JIRA) -
Hardy Ferentschik (JIRA)
-
Laird Nelson (JIRA)
-
Rouvignac (JIRA)