Incorrect charset JasperServer

0

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
    
asked by Quique Olaso 22.05.2018 в 13:01
source

0 answers