in Oracle 11g, when executing the query
SELECT * FROM nls_database_parameters;
I get (*)
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET AL32UTF8
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 11.2.0.3.0
while the query
SELECT * FROM v$nls_parameters ORDER BY PARAMETER;
return me
NLS_CALENDAR GREGORIAN
NLS_CHARACTERSET AL32UTF8
NLS_COMP BINARY
NLS_CURRENCY €
NLS_DATE_FORMAT DD/MM/RRRR HH24:MI:SS
NLS_DATE_LANGUAGE SPANISH
NLS_DUAL_CURRENCY €
NLS_ISO_CURRENCY SPAIN
NLS_LANGUAGE SPANISH
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_NCHAR_CONV_EXCP FALSE
NLS_NUMERIC_CHARACTERS ,.
NLS_SORT SPANISH
NLS_TERRITORY SPAIN
NLS_TIME_FORMAT HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT DD/MM/RR HH24:MI:SSXFF
NLS_TIMESTAMP_TZ_FORMAT DD/MM/RR HH24:MI:SSXFF TZR
NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR
When invoking REST services such that
http://localhost:63004/jasperserver/rest_v2/resources?showHiddenItems=true&folderUri=/path/to/app&recursive=false&q=ig
I get the following error
Hibernate operation: could not execute query; uncategorized SQLException for SQL [select this_.id as id0_1_, this_.name as name0_1_, this_.parent_folder as parent3_0_1_, this_.version as version0_1_, this_.label as label0_1_, this_.description as descript6_0_1_, this_.creation_date as creation7_0_1_, this_.update_date as update8_0_1_, this_.resourceType as resource1_1_1_, this_.hidden as hidden2_1_, this_.uri as uri2_1_, this_.clazz_ as clazz_1_, p1_.id as id5_0_, p1_.version as version5_0_, p1_.uri as uri5_0_, p1_.hidden as hidden5_0_, p1_.name as name5_0_, p1_.label as label5_0_, p1_.description as descript7_5_0_, p1_.parent_folder as parent8_5_0_, p1_.creation_date as creation9_5_0_, p1_.update_date as update10_5_0_ from (select creation_date, id, to_number (null) as hidden, description, name, update_date, resourceType, label, parent_folder, to_char (null) as uri, version, 1 as clazz_ from FakeJIResource union all select creation_date, id, hidden, description, name, update_date, to_char (null) as resourceType, label, parent_folder, uri, version, 2 as clazz_ from FakeJIResourceFolder) this_, JIResourceFolder p1_ where this_.parent_folder = p1_.id and p1_.uri =? and ((lower (this_.label) like? escape '!' or lower (this_.description) like? escape '!')) order by this_.label asc, this_.id asc]; SQL state [72000]; error code [12704]; ORA-12704: the game of characters; nested exception is java.sql.SQLException: ORA-12704: no the character set matches
I have tried to configure the file hibernate.properties so that
hibernate.connection.useUnicode=true
hibernate.connection.charSet=utf-8
hibernate.connection.characterEncoding=utf-8
as well as
hibernate.connection.useUnicode=true
hibernate.connection.charSet=utf-16
hibernate.connection.characterEncoding=utf-16
without success.
Any suggestions? Thanks in advance.
(*) With the following query I can see the differences between the parameters configured at the session level and permanent
select
coalesce( perm.parameter, sess.parameter ) parameter,
perm.value permanent_value,
sess.value session_value
from
nls_database_parameters perm
full outer join
v$nls_parameters sess
on
perm.parameter=sess.parameter