Postgres and/or MySQL-Connection with UTF-8

[Joerg Hoertz]

Hi,

I've configured a MetaUI-JPA-Application as described and get the
following Exception on both databases:

org.hibernate.QueryException:
could not resolve property: characterEncoding of:
myfr_model.Myfreights [SELECT e0 FROM myfr_model.Myfreights e0 order
by e0.characterEncoding asc]
Exception during MetaInclude with context: ariba.ui.meta.core.UIMeta
$UIContext@10599cc
Meta Context: Context: (12 entries)
class : myfr_model.Myfreights X
class_trait : ( Searchable ) ^ X
displayGroup : true
module : myfr_model.Myfreights
module_trait : ( ModuleClassPage ) ^
layout : SearchPage X
layout : Search X
layout : Table
dataSourceType :
ariba.ui.meta.persistence.ObjectContextDataSource
operation : list
class_trait : ( tableZones, Searchable ) ^
class : myfr_model.Myfreights
PropertyActivation...
scopeKey : class !
editing : false
trait : ( tableZones, Searchable )
component : MetaTable
Props:
class_trait:[tableZones, Searchable];
module_trait:[ModuleClassPage];
displayKey:toString;
bindings:{title:$properties.label;
submitOnSelectionChange:null; enableScrolling:null;
singleSelect:null;
showSelectionColumn:null; showHeadingArea:null; displayGroup:
$displayGroup};
class:myfr_model.Myfreights;
searchOperation:keywordSearch;
zones:[zMain, zLeft, zRight, zTop, zBottom, zDetail];
component:MetaTable;
trait:[tableZones, Searchable];
Exception during MetaInclude with context: ariba.ui.meta.core.UIMeta
$UIContext@10599cc
Exception during MetaInclude with context: ariba.ui.meta.core.UIMeta
$UIContext@10599cc
ariba.ui.table.AWTDataTable@312e88
AWTDataTable(/C:/aribaweb-5.0GA/src/metaui/ariba/ui/meta/
layouts/MetaTable.awl:2)
m:IncludeComponent(/C:/aribaweb-5.0GA/src/metaui/ariba/ui/
meta/
layouts/MetaSearch.awl:4)
m:IncludeComponent(/C:/aribaweb-5.0GA/src/metaui/ariba/ui/
meta/
layouts/MetaDashboardLayout.awl:47)
AWIncludeBlock(/C:/aribaweb-5.0GA/src/metaui/ariba/ui/meta/
layouts/MetaDashboardLayout.awl:21)
AWIncludeBlock(/C:/aribaweb-5.0GA/src/metaui/ariba/ui/meta/
layouts/MetaContentPage.awl:2)
at org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:101)
at org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:80)

I've set all properties in my postgres/mysql-database and my build.xml
to
"UTF-8"/"utf8" (I've tried all possibilities)...

If I switch from the exception to the aribaweb-generated Site, the
DataSource shows fields like:
Character Enconding, Client Time Zone, This, Template Parser... and so
on.

Have you any idea what's wrong?
Thanks and best regards,
Joerg

[Kingsley]

Hi Joerg,

Is your domain class Myfreights extending AWComponent?

Thanks,
Kingsley

[Joerg Hoertz]

Hi Kingsley,

yes, my domain class extends AWComponent.

Without I get no error messages, but if I extend AWComponent I
get this error on postgres, MySQL and HSQLDB (not mem).

I've changed some settings in server.xml from tomcat but it didn't
solve the problem...

For me it's curious what table is "connected" on that the app tries
to make the select.

Best,

Joerg

[Kingsley Ngan]

You should not extend AWComponent.  It is only used for creating UI components, and not for backing objects.

-Kingsley

Joerg

--
You received this message because you are subscribed to the Google Groups "AribaWeb (aribaweb.org)" group.
To post to this group, send email to arib...@googlegroups.com.
To unsubscribe from this group, send email to aribaweb+u...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/aribaweb?hl=en.

[Joerg Hoertz]

Hi Kingsley,

now I'm worried again...

When I not extend AWComponent, how can I customize the UI
to my needs?

Thanks, Joerg

[Joerg Hoertz]

Hi Kingsley,

I'm a step further. The error occurs at the login, but I can't find
out what's wrong and where I should set the characterEncoding var...


13:54:15,117 DEBUG SQL:111 - select user0_.id as id4_0_, user0_.name
as name4_0_, user0_.email as email4_0_, user0_.password as
password4_0_, user0_.userName as userName4_0_ from Principal user0_
where user0_.id=? and user0_.DTYPE='User'
13:54:15,132 DEBUG SQL:111 - select permission0_.id as id2_,
permission0_.name as name2_ from Permission permission0_ where
permission0_.name=?
13:54:15,132 DEBUG SQL:111 - select permission0_.id as id2_,
permission0_.name as name2_ from Permission permission0_ where
permission0_.name=?
13:54:15,179 DEBUG SQL:111 - select user0_.id as id4_0_, user0_.name
as name4_0_, user0_.email as email4_0_, user0_.password as
password4_0_, user0_.userName as userName4_0_ from Principal user0_
where user0_.id=? and user0_.DTYPE='User'
13:54:15,195 DEBUG SQL:111 - select memberof0_.Principal_id as
Principal1_1_, memberof0_.memberOf_id as memberOf2_1_, group1_.id as
id4_0_, group1_.name as name4_0_ from Principal_Principal memberof0_
left outer join Principal group1_ on memberof0_.memberOf_id=group1_.id
where memberof0_.Principal_id=?
13:54:15,195 DEBUG SQL:111 - select memberof0_.Principal_id as
Principal1_1_, memberof0_.memberOf_id as memberOf2_1_, group1_.id as
id4_0_, group1_.name as name4_0_ from Principal_Principal memberof0_
left outer join Principal group1_ on memberof0_.memberOf_id=group1_.id
where memberof0_.Principal_id=?
13:54:15,289 DEBUG SQL:111 - select permission0_.Principal_id as
Principal1_1_, permission0_.permissions_id as permissi2_1_,
permission1_.id as id2_0_, permission1_.name as name2_0_ from
Principal_Permission permission0_ left outer join Permission
permission1_ on permission0_.permissions_id=permission1_.id where
permission0_.Principal_id=?
13:54:15,289 DEBUG SQL:111 - select permission0_.Principal_id as
Principal1_1_, permission0_.permissions_id as permissi2_1_,
permission1_.id as id2_0_, permission1_.name as name2_0_ from
Principal_Permission permission0_ left outer join Permission
permission1_ on permission0_.permissions_id=permission1_.id where
permission0_.Principal_id=?
13:54:15,382 DEBUG SQL:111 - select permission0_.id as id2_,
permission0_.name as name2_ from Permission permission0_ where
permission0_.name=?
13:54:15,398 DEBUG SQL:111 - select permission0_.id as id2_,
permission0_.name as name2_ from Permission permission0_ where
permission0_.name=?
13:54:15,445 DEBUG SQL:111 - select user0_.id as id4_0_, user0_.name
as name4_0_, user0_.email as email4_0_, user0_.password as
password4_0_, user0_.userName as userName4_0_ from Principal user0_
where user0_.id=? and user0_.DTYPE='User'
13:54:20,601 DEBUG SQL:111 - select user0_.id as id4_, user0_.name as
name4_, user0_.email as email4_, user0_.password as password4_,
user0_.userName as userName4_ from Principal user0_ where
user0_.DTYPE='User' and user0_.name=?
13:54:35,960 DEBUG SQL:111 - select user0_.id as id4_, user0_.name as
name4_, user0_.email as email4_, user0_.password as password4_,
user0_.userName as userName4_ from Principal user0_ where
user0_.DTYPE='User' and user0_.name=?
13:54:46,132 DEBUG SQL:111 - select user0_.id as id4_, user0_.name as
name4_, user0_.email as email4_, user0_.password as password4_,
user0_.userName as userName4_ from Principal user0_ where
user0_.DTYPE='User' and user0_.name=?
13:54:54,460 DEBUG SQL:111 - select user0_.id as id4_, user0_.name as
name4_, user0_.email as email4_, user0_.password as password4_,
user0_.userName as userName4_ from Principal user0_ where
user0_.DTYPE='User' and user0_.name=?
14:57:18,476 DEBUG SQL:111 - select user0_.id as id4_0_, user0_.name
as name4_0_, user0_.email as email4_0_, user0_.password as
password4_0_, user0_.userName as userName4_0_ from Principal user0_
where user0_.id=? and user0_.DTYPE='User'
ariba.ui.aribaweb.util.AWGenericException:
java.lang.IllegalArgumentException: org.hibernate.QueryException:
could not resolve property: characterEncoding of: myfr_model.sendungen
[SELECT e0 FROM myfr_model.sendungen e0 order by e0.characterEncoding

asc]
Exception during MetaInclude with context: ariba.ui.meta.core.UIMeta

$UIContext@1908d7a

Thanks and regards,

Joerg

[Kuji Sun]

were you ever able to resolve that error ?, I am trying to use groovy+awl and I get same error