I'm running JBoss 3.2.3(200311301445) on Debian Woody with J2SDK 1.4.1_02-b06
I have strange problem with DynamicQL. It looks like non-English characters in queries get somehow changed.
This is my ejbHome method calling the dynamic "ejbSelectGeneric" :
public Collection ejbHomeSearchCompanies (CompanyCriteriasGroup companyCriteriasGroup) throws FinderException {
NDC.push("ejbHomeFindCompanies");
log.debug ("called");
Collection result = null;
if (companyCriteriasGroup != null) {
StringBuffer jbossQl = new StringBuffer();
jbossQl.append("SELECT OBJECT(c) ");
jbossQl.append("FROM Company c ");
jbossQl.append("WHERE ");
jbossQl.append(companyCriteriasGroup.toSQL());
Object[] args = {}; // no arguments
log.debug("**************************************************");
log.debug(jbossQl.toString());
log.debug("**************************************************");
result = ejbSelectGeneric(jbossQl.toString(), args); // call dynamic-ql query
log.debug("**************************************************");
log.debug(result);
log.debug("**************************************************");
}
log.debug ("end");
NDC.pop();
return result;
}
Now this is what I have in my log file:
. . .
2004-01-20 09:21:44,507 DEBUG [CompanyBean] (ejbHomeFindCompanies) called
2004-01-20 09:21:44,507 DEBUG [CompanyBean] (ejbHomeFindCompanies) **************************************************
2004-01-20 09:21:44,507 DEBUG [CompanyBean] (ejbHomeFindCompanies) SELECT OBJECT(c) FROM Company c WHERE ((c.name LIKE '%ąężźćśłóń%'))
2004-01-20 09:21:44,507 DEBUG [CompanyBean] (ejbHomeFindCompanies) **************************************************
2004-01-20 09:21:44,507 DEBUG [plugins.cmp.jdbc.JDBCDynamicQLQuery.Company#ejbSelectGeneric] (ejbHomeFindCompanies) DYNAMIC-QL: SELECT OBJECT(c) FROM Company c WHERE ((c.name LIKE '%ąężźćśłóń%'))
2004-01-20 09:21:44,510 DEBUG [plugins.cmp.jdbc.JDBCDynamicQLQuery.Company#ejbSelectGeneric] (ejbHomeFindCompanies) SQL: SELECT t0_c.symbol_ FROM COMPANY_ t0_c WHERE (((t0_c.name_ LIKE '%|z[BóD%')))
2004-01-20 09:21:44,510 DEBUG [plugins.cmp.jdbc.JDBCDynamicQLQuery.Company#ejbSelectGeneric] (ejbHomeFindCompanies) Executing SQL: SELECT t0_c.symbol_ FROM COMPANY_ t0_c WHERE (((t0_c.name_ LIKE '%|z[BóD%')))
2004-01-20 09:21:44,530 DEBUG [CompanyBean] (TP-Processor2:findCompanies findCompanies ejbHomeFindCompanies) **************************************************
2004-01-20 09:21:44,530 DEBUG [CompanyBean] (TP-Processor2:findCompanies findCompanies ejbHomeFindCompanies) []
2004-01-20 09:21:44,530 DEBUG [CompanyBean] (TP-Processor2:findCompanies findCompanies ejbHomeFindCompanies) **************************************************
2004-01-20 09:21:44,532 DEBUG [CompanyBean] (TP-Processor2:findCompanies findCompanies ejbHomeFindCompanies) end
. . .
Here I'm using polish characters for test, and as you can see "ąężźćśłóń" changes to "|z[BóD"!
The same thing happens with Cyrillic characters.
Can someone help me fix that?
Thanks Milen Dyankov
------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
