Specific (national) characters & UTF-8 Hex| JBoss.org Content Archive (Read Only)

15. Re: Specific (national) characters & UTF-8 Hex

izgur Feb 15, 2011 10:57 AM (in response to mbaluch)

LINUX - /etc/sysconfig/i18n : LANG="en_US.UTF-8"

I thought that that's not the issue, because I see all my č-s in the log file ...

And probably the linux version can't be important... i have centos5.2.

SERVER - I have the jboss5.1, jbossesb4.9 and riftsaw2.2.0. Do you have the same ?

What in the world could be the difference then ?

č,ć,đ always result in a question character...

I'm trying now to get more TRACE on the bpel:assign ...

16. Specific (national) characters & UTF-8 Hex

izgur Feb 15, 2011 11:12 AM (in response to izgur)

Detailed log:

2011-02-15 16:51:45,734 TRACE [org.jboss.ws.core.jaxws.handler.HandlerChainExecutor] (http-172.17.3.15-9000-2) BEFORE handleRequest - Recording Handler

<soapenv:Envelope xmlns:cod='http://kkissiskratel/codes' xmlns:soapenv='http://schemas.xmlsoap.org/soap/envelope/'>

<soapenv:Header/>

<soapenv:Body>

<cod:codesRequest>

<cod:input>testiram čžš ČŽŠ prvič</cod:input>

</cod:codesRequest>

</soapenv:Body>

</soapenv:Envelope>

2011-02-15 16:51:45,735 TRACE [org.jboss.ws.core.CommonMessageContext] (http-172.17.3.15-9000-2) put: APPLICATION:org.jboss.ws.allow.expand.dom=true

2011-02-15 16:51:45,735 TRACE [org.jboss.ws.core.CommonMessageContext] (http-172.17.3.15-9000-2) get(javax.xml.ws.handler.message.outbound): APPLICATION:javax.xml.ws.handler.message.outbound=false

2011-02-15 16:51:45,735 TRACE [org.jboss.ws.core.soap.SOAPContentElement] (http-172.17.3.15-9000-2) getChildNodes

2011-02-15 16:51:45,736 TRACE [org.jboss.ws.core.soap.SOAPContentElement] (http-172.17.3.15-9000-2) getChildNodes

2011-02-15 16:51:45,736 TRACE [org.jboss.ws.core.jaxws.handler.HandlerChainExecutor] (http-172.17.3.15-9000-2) AFTER handleRequest - Recording Handler: unchanged

2011-02-15 16:51:45,736 DEBUG [org.jboss.ws.core.jaxws.handler.HandlerChainExecutor] (http-172.17.3.15-9000-2) Exit: handleIn BoundMessage with status: true

2011-02-15 16:51:45,736 TRACE [org.jboss.ws.core.CommonMessageContext] (http-172.17.3.15-9000-2) put: APPLICATION:org.jboss.ws.allow.expand.dom=true

2011-02-15 16:51:45,742 TRACE [org.jboss.ws.core.CommonMessageContext] (http-172.17.3.15-9000-2) get(javax.xml.ws.servlet.request): APPLICATION:javax.xml.ws.servlet.request=org.apache.catalina.connector.RequestFacade@1584d9

2011-02-15 16:51:45,745 TRACE [org.jboss.ws.core.CommonMessageContext] (http-172.17.3.15-9000-2) get(javax.xml.ws.servlet.request): APPLICATION:javax.xml.ws.servlet.request=org.apache.catalina.connector.RequestFacade@1584d9

2011-02-15 16:51:45,756 DEBUG [org.jboss.wsf.common.invocation.InvocationHandlerJAXWS] (http-172.17.3.15-9000-2) Injecting resources on JAXWS JSE endpoint: org.jboss.soa.bpel.runtime.ws.generated.BPELWebServiceEndpoint_f41ec59c-9e84-42e6-ac0f-4a30f8398191@d57435

2011-02-15 16:51:45,761 DEBUG [org.jboss.wsf.common.invocation.InvocationHandlerJAXWS] (http-172.17.3.15-9000-2) Calling postConstruct method on JAXWS JSE endpoint: org.jboss.soa.bpel.runtime.ws.generated.BPELWebServiceEndpoint_f41ec59c-9e84-42e6-ac0f-4a30f8398191@d57435

2011-02-15 16:51:45,762 DEBUG [org.jboss.ws.core.EndpointInvocation] (http-172.17.3.15-9000-2) getRequestPayload

2011-02-15 16:51:45,763 DEBUG [org.jboss.ws.core.EndpointInvocation] (http-172.17.3.15-9000-2) getRequestParamValue: genericParam

2011-02-15 16:51:45,763 DEBUG [org.jboss.ws.core.EndpointInvocation] (http-172.17.3.15-9000-2) transformPayloadValue: org.jboss.ws.core.soap.SOAPMessageImpl -> org.jboss.ws.core.soap.SOAPMessageImpl

2011-02-15 16:51:45,763 DEBUG [org.jboss.ws.core.EndpointInvocation] (http-172.17.3.15-9000-2) syncEndpointInputParam: org.jboss.ws.core.soap.SOAPMessageImpl -> org.jboss.ws.core.soap.SOAPMessageImpl(0)

2011-02-15 16:51:45,764 DEBUG [org.jboss.soa.bpel.runtime.ws.generated.BPELWebServiceEndpoint_f41ec59c-9e84-42e6-ac0f-4a30f8398191] (http-172.17.3.15-9000-2) Invoking endpoint f41ec59c-9e84-42e6-ac0f-4a30f8398191

2011-02-15 16:51:45,797 TRACE [org.jboss.ws.core.soap.SOAPContentElement] (http-172.17.3.15-9000-2) getChildNodes

2011-02-15 16:51:45,797 DEBUG [org.jboss.soa.bpel.runtime.ws.generated.BPELWebServiceEndpoint_f41ec59c-9e84-42e6-ac0f-4a30f8398191] (http-172.17.3.15-9000-2) ODE inbound message:

<soapenv:Envelope xmlns:cod='http://kkissiskratel/codes' xmlns:soapenv='http://schemas.xmlsoap.org/soap/envelope/'>

<soapenv:Header/>

<soapenv:Body>

<cod:codesRequest>

<cod:input>testiram čžš ČŽŠ prvič</cod:input>

</cod:codesRequest>

</soapenv:Body>

</soapenv:Envelope>

2011-02-15 16:51:45,801 DEBUG [org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl] (http-172.17.3.15-9000-2) Starting transaction.

2011-02-15 16:51:45,830 DEBUG [org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl] (http-172.17.3.15-9000-2) ODE routed to operation Operation: name=process

style=REQUEST_RESPONSE,1

Input: name=null

Message: name={http://kkissiskratel/codes}codesRequestMessage

Part: name=payload

elementName={http://kkissiskratel/codes}codesRequest

Output: name=null

Message: name={http://kkissiskratel/codes}codesResponseMessage

Part: name=payload

elementName={http://kkissiskratel/codes}codesResponse from service {http://kkissiskratel/codes}codes

2011-02-15 16:51:45,830 DEBUG [org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl] (http-172.17.3.15-9000-2) Is two way operation? true

2011-02-15 16:51:45,836 TRACE [org.jboss.ws.core.soap.SOAPContentElement] (http-172.17.3.15-9000-2) getFirstChild

2011-02-15 16:51:45,837 DEBUG [org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl] (http-172.17.3.15-9000-2) Invoking ODE using MEX {MyRoleMex#hqejbhcnphr61qs87wantx [Client hqejbhcnphr61qs87wantw] calling {http://kkissiskratel/codes}codes.process(...)}

2011-02-15 16:51:45,838 DEBUG [org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl] (http-172.17.3.15-9000-2) Message content: <?xml version="1.0" encoding="UTF-8"?>

<cod:input>testiram čžš ČŽŠ prvič</cod:input>

</cod:codesRequest></payload></message>

2011-02-15 16:51:45,883 DEBUG [org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl] (http-172.17.3.15-9000-2) Commiting ODE MEX {MyRoleMex#hqejbhcnphr61qs87wantx [Client hqejbhcnphr61qs87wantw] calling {http://kkissiskratel/codes}codes.process(...)}

2011-02-15 16:51:45,884 DEBUG [org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl] (http-172.17.3.15-9000-2) Commiting transaction.

2011-02-15 16:51:46,626 DEBUG [org.apache.ode.bpel.runtime.ScopeFrame] (ODEServer-1) Initialize variable: name={Variable __PROCESS_SCOPE:codes.input:OMessageVarType#6({http://kkissiskratel/codes}codesRequestMessage)} value=<?xml version="1.0" encoding="UTF-8"?>

<cod:input>testiram ?žš ?ŽŠ prvi?</cod:input>

</cod:codesRequest></payload></message>

2011-02-15 16:51:46,681 DEBUG [org.apache.ode.bpel.runtime.EMPTY] (ODEServer-1) <empty name=OEmpty#33>

2011-02-15 16:51:46,758 DEBUG [org.apache.ode.bpel.runtime.ASSIGN] (ODEServer-1) Assign.copy({OCopy {VarRef {Variable __PROCESS_SCOPE:codes.output:OMessageVarType#10({http://kkissiskratel/codes}codesResponseMessage)}.payload}={Literal <?xml version="1.0" encoding="UTF-8"?>

<bpel:literal xmlns:bpel="http://docs.oasis-open.org/wsbpel/2.0/process/executable"><tns:codesResponse xmlns:tns="http://kkissiskratel/codes" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<tns:result/>

</tns:codesResponse>

</bpel:literal>}})

2011-02-15 16:51:46,759 DEBUG [org.apache.ode.bpel.runtime.ASSIGN] (ODEServer-1) Evaluating FROM expression "{Literal <?xml version="1.0" encoding="UTF-8"?>

<bpel:literal xmlns:bpel="http://docs.oasis-open.org/wsbpel/2.0/process/executable"><tns:codesResponse xmlns:tns="http://kkissiskratel/codes" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<tns:result/>

</tns:codesResponse>

</bpel:literal>}".

2011-02-15 16:51:46,760 DEBUG [org.apache.ode.bpel.runtime.ASSIGN] (ODEServer-1) lvalue after eval [message: null]

2011-02-15 16:51:46,761 DEBUG [org.apache.ode.bpel.runtime.ASSIGN] (ODEServer-1) content <?xml version="1.0" encoding="UTF-8"?>

2011-02-15 16:51:46,769 DEBUG [org.apache.ode.bpel.runtime.ASSIGN] (ODEServer-1) ASSIGN Writing variable 'output' value '<?xml version="1.0" encoding="UTF-8"?>

<tns:result xmlns:tns="http://kkissiskratel/codes"/>

</codesResponse></payload></message>'

2011-02-15 16:51:46,769 DEBUG [org.apache.ode.bpel.runtime.ScopeFrame] (ODEServer-1) Write variable: name={Variable __PROCESS_SCOPE:codes.output:OMessageVarType#10({http://kkissiskratel/codes}codesResponseMessage)} value=<?xml version="1.0" encoding="UTF-8"?>

<tns:result xmlns:tns="http://kkissiskratel/codes"/>

</codesResponse></payload></message>

2011-02-15 16:51:46,777 DEBUG [org.apache.ode.bpel.runtime.ASSIGN] (ODEServer-1) Assign.copy({OCopy {VarRef {Variable __PROCESS_SCOPE:codes.ConsoleLinkResponse1:OMessageVarType#22({http://ws.apache.org/axis2}showMessageResponse)}.parameters}={Literal <?xml version="1.0" encoding="UTF-8"?>

<bpel:literal xmlns:bpel="http://docs.oasis-open.org/wsbpel/2.0/process/executable"><ns:showMessageResponse xmlns:ns="http://ws.apache.org/axis2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<ns:return/>

</ns:showMessageResponse>

</bpel:literal>}})

2011-02-15 16:51:46,777 DEBUG [org.apache.ode.bpel.runtime.ASSIGN] (ODEServer-1) Evaluating FROM expression "{Literal <?xml version="1.0" encoding="UTF-8"?>

<bpel:literal xmlns:bpel="http://docs.oasis-open.org/wsbpel/2.0/process/executable"><ns:showMessageResponse xmlns:ns="http://ws.apache.org/axis2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<ns:return/>

</ns:showMessageResponse>

</bpel:literal>}".

2011-02-15 16:51:46,778 DEBUG [org.apache.ode.bpel.runtime.ASSIGN] (ODEServer-1) lvalue after eval [message: null]

2011-02-15 16:51:46,778 DEBUG [org.apache.ode.bpel.runtime.ASSIGN] (ODEServer-1) content <?xml version="1.0" encoding="UTF-8"?>

2011-02-15 16:51:46,779 DEBUG [org.apache.ode.bpel.runtime.ASSIGN] (ODEServer-1) ASSIGN Writing variable 'ConsoleLinkResponse1' value '<?xml version="1.0" encoding="UTF-8"?>

<ns:return xmlns:ns="http://ws.apache.org/axis2"/>

</showMessageResponse></parameters></message>'

2011-02-15 16:51:46,779 DEBUG [org.apache.ode.bpel.runtime.ScopeFrame] (ODEServer-1) Write variable: name={Variable __PROCESS_SCOPE:codes.ConsoleLinkResponse1:OMessageVarType#22({http://ws.apache.org/axis2}showMessageResponse)} value=<?xml version="1.0" encoding="UTF-8"?>

<ns:return xmlns:ns="http://ws.apache.org/axis2"/>

</showMessageResponse></parameters></message>

2011-02-15 16:51:46,787 DEBUG [org.apache.ode.bpel.runtime.ASSIGN] (ODEServer-1) Assign.copy({OCopy {VarRef {Variable __PROCESS_SCOPE:codes.ConsoleLinkRequest1:OMessageVarType#26({http://ws.apache.org/axis2}showMessageRequest)}.parameters}={Literal <?xml version="1.0" encoding="UTF-8"?>

<bpel:literal xmlns:bpel="http://docs.oasis-open.org/wsbpel/2.0/process/executable"><ns:showMessage xmlns:ns="http://ws.apache.org/axis2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<ns:args0/>

</ns:showMessage>

</bpel:literal>}})

2011-02-15 16:51:46,787 DEBUG [org.apache.ode.bpel.runtime.ASSIGN] (ODEServer-1) Evaluating FROM expression "{Literal <?xml version="1.0" encoding="UTF-8"?>

<bpel:literal xmlns:bpel="http://docs.oasis-open.org/wsbpel/2.0/process/executable"><ns:showMessage xmlns:ns="http://ws.apache.org/axis2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<ns:args0/>

</ns:showMessage>

</bpel:literal>}".

2011-02-15 16:51:46,788 DEBUG [org.apache.ode.bpel.runtime.ASSIGN] (ODEServer-1) lvalue after eval [message: null]

2011-02-15 16:51:46,788 DEBUG [org.apache.ode.bpel.runtime.ASSIGN] (ODEServer-1) content <?xml version="1.0" encoding="UTF-8"?>

2011-02-15 16:51:46,788 DEBUG [org.apache.ode.bpel.runtime.ASSIGN] (ODEServer-1) ASSIGN Writing variable 'ConsoleLinkRequest1' value '<?xml version="1.0" encoding="UTF-8"?>

<ns:args0 xmlns:ns="http://ws.apache.org/axis2"/>

</showMessage></parameters></message>'

2011-02-15 16:51:46,789 DEBUG [org.apache.ode.bpel.runtime.ScopeFrame] (ODEServer-1) Write variable: name={Variable __PROCESS_SCOPE:codes.ConsoleLinkRequest1:OMessageVarType#26({http://ws.apache.org/axis2}showMessageRequest)} value=<?xml version="1.0" encoding="UTF-8"?>

<ns:args0 xmlns:ns="http://ws.apache.org/axis2"/>

</showMessage></parameters></message>

2011-02-15 16:51:46,797 DEBUG [org.apache.ode.bpel.runtime.ASSIGN] (ODEServer-1) Assign.copy({OCopy {VarRef {Variable __PROCESS_SCOPE:codes.ConsoleLinkRequest1:OMessageVarType#26({http://ws.apache.org/axis2}showMessageRequest)}.parameters{OXPath10Expression nsconsole:args0}}={VarRef {Variable __PROCESS_SCOPE:codes.input:OMessageVarType#6({http://kkissiskratel/codes}codesRequestMessage)}.payload{OXPath10Expression tns:input}}})

2011-02-15 16:51:46,797 DEBUG [org.apache.ode.bpel.runtime.ASSIGN] (ODEServer-1) Evaluating FROM expression "{VarRef {Variable __PROCESS_SCOPE:codes.input:OMessageVarType#6({http://kkissiskratel/codes}codesRequestMessage)}.payload{OXPath10Expression tns:input}}".

2011-02-15 16:51:47,054 DEBUG [org.apache.ode.bpel.runtime.ASSIGN] (ODEServer-1) lvalue after eval [message: null]

2011-02-15 16:51:47,055 DEBUG [org.apache.ode.bpel.runtime.ASSIGN] (ODEServer-1) content <?xml version="1.0" encoding="UTF-8"?>

<ns:args0 xmlns:ns="http://ws.apache.org/axis2"/>

</showMessage></parameters></message>

2011-02-15 16:51:47,056 DEBUG [org.apache.ode.bpel.runtime.ASSIGN] (ODEServer-1) ASSIGN Writing variable 'ConsoleLinkRequest1' value '<?xml version="1.0" encoding="UTF-8"?>

<ns:args0 xmlns:ns="http://ws.apache.org/axis2">testiram ?žš ?ŽŠ prvi?</ns:args0>

</showMessage></parameters></message>'

2011-02-15 16:51:47,056 DEBUG [org.apache.ode.bpel.runtime.ScopeFrame] (ODEServer-1) Write variable: name={Variable __PROCESS_SCOPE:codes.ConsoleLinkRequest1:OMessageVarType#26({http://ws.apache.org/axis2}showMessageRequest)} value=<?xml version="1.0" encoding="UTF-8"?>

<ns:args0 xmlns:ns="http://ws.apache.org/axis2">testiram ?žš ?ŽŠ prvi?</ns:args0>

</showMessage></parameters></message>

2011-02-15 16:51:47,188 DEBUG [org.jboss.soa.bpel.runtime.engine.ode.EndpointReferenceContextImpl] (ODEServer-1) Map access not implemented

2011-02-15 16:51:47,190 DEBUG [org.jboss.soa.bpel.runtime.engine.ode.MessageExchangeContextImpl] (ODEServer-1) Invoking a partner operation: showMessage

2011-02-15 16:51:47,191 DEBUG [org.jboss.soa.bpel.runtime.engine.ode.MessageExchangeContextImpl] (ODEServer-1) Invoking a partner operation: showMessage

2011-02-15 16:51:47,231 DEBUG [org.jboss.soa.bpel.uddi.UDDIRegistrationImpl] (ODEServer-1) Using jbossesb.sar/esb.uddi.client.xml

2011-02-15 16:51:47,231 DEBUG [org.jboss.soa.bpel.uddi.UDDIRegistrationImpl] (ODEServer-1) ClerkManagerName is esb-registry

2011-02-15 16:51:47,340 INFO [org.jboss.soa.bpel.uddi.UDDIRegistrationImpl] (ODEServer-1) No Service by the name ConsoleWriterService was found in the registry.

2011-02-15 16:51:47,340 INFO [org.jboss.soa.bpel.uddi.UDDIRegistrationImpl] (ODEServer-1) No WSDL could be obtained using the UDDI Registry Lookup.

2011-02-15 16:51:47,376 DEBUG [org.jboss.soa.bpel.runtime.ws.WSDLHelper] (ODEServer-1) Matching {http://kkissiskratel/codes}codes-0 to WSDL file /home/jboss-5.1.0.GA/server/default/tmp/3j001-a6wzxr-gk6zla9j-1-gk6zofwp-bt/codes.jar/ConsoleWriterService.wsdl

2011-02-15 16:51:47,376 DEBUG [org.jboss.soa.bpel.runtime.ws.WebServiceClient] (ODEServer-1) Invoking dispatcher 70a85bc1-0141-415d-8d08-aaa65ce0eeed

2011-02-15 16:51:47,608 TRACE [org.jboss.wsf.common.DOMUtils] (ODEServer-2) createElement {http://schemas.xmlsoap.org/soap/envelope/}env:Envelope

2011-02-15 16:51:47,617 TRACE [org.jboss.wsf.common.DOMUtils] (ODEServer-2) createElement {http://schemas.xmlsoap.org/soap/envelope/}env:Header

2011-02-15 16:51:47,617 TRACE [org.jboss.wsf.common.DOMUtils] (ODEServer-2) createElement {http://schemas.xmlsoap.org/soap/envelope/}env:Body

2011-02-15 16:51:47,636 DEBUG [org.jboss.soa.bpel.runtime.ws.WebServiceClient] (ODEServer-2) ODE outbound message:

<ns:args0 xmlns:ns='http://ws.apache.org/axis2'>testiram ?žš ?ŽŠ prvi?</ns:args0>

</showMessage>

</parameters>

</message>

17. Specific (national) characters & UTF-8 Hex

mbaluch Feb 15, 2011 4:13 PM (in response to izgur)

Hi Igor

Success - I managed to reproduce your issue. Here's the JIRA: https://issues.jboss.org/browse/RIFTSAW-347. I used an older version of Riftsaw when I was doing the testing.

Thanks again.

Regards

Marek.

18. Specific (national) characters & UTF-8 Hex

izgur Feb 15, 2011 5:04 PM (in response to mbaluch)

You say it works on older versions of Riftsaw ? I have to use the 2.2.0.FINAL, because it's the first version that supports .NET web service invocation.

Could i upgrade/downgrade a riftsaw component which has the issue ?

Is there any workaround possible ?

Please response if anybody has an idea...

I was worrying that my SMS doesn't contain these characters, now even my firstname/lastname isn't spelled correct

Thanks for all help!

BR, Igor!

19. Specific (national) characters & UTF-8 Hex

jeff.yuchang Feb 16, 2011 2:57 AM (in response to izgur)

Hi Igor,

I am looking into this issue now, hopefully will find a simple fix or work around soon.

Regards

Jeff

20. Specific (national) characters & UTF-8 Hex

izgur Feb 16, 2011 3:05 AM (in response to jeff.yuchang)

Hey!

What about the database ???

Riftsaw uses a database, i use mysql. And data in my mysql is latin1_swedish_ci (probably default)...

SO... it made a new table with a string parameter and the latin1_swedish_ci.

I tired to insert šđčćž, it inserts š???ž -> EXACTLY LIKE RIFTSAW...

But.. Is riftsaw using the database at this moment? While initializing the input ???

21. Specific (national) characters & UTF-8 Hex

jeff.yuchang Feb 16, 2011 3:11 AM (in response to izgur)

Yes, RiftSaw did use database, but I don't think this is related to the database's encoding. But if you can try to set your mysql database to the encoding that supports your character, and then see if it has any difference?

22. Specific (national) characters & UTF-8 Hex

jeff.yuchang Feb 16, 2011 8:54 AM (in response to izgur)

After a set of debugging, I found that when ODE engine gets the soap request message from the database, the encoding problem starts. As Tammo said in the ode user maillist, so you may need to update the Mysql database to support your encoding.

23. Specific (national) characters & UTF-8 Hex

izgur Feb 16, 2011 12:08 PM (in response to jeff.yuchang)

So it is a database problem

I really hope this will solve my problem ... I'll post tomorrow how it worked. Thank you very much!

btw I was trying to install jboss5.1, jbossesb4.9 & riftsaw 2.2.0 on windows to test these database on my pc and not on the server...

JBoss and esb was without any problems. And I'm pretty sure I change all riftsaw files well, but I was unable to succsfully complete the riftsaw deploy to jboss with ant deploy -Ddatabase=mysql -Dws.stack=native - Dws.version=3.2.2.GA. It always failed on not finding jboss-client.jar.

But the was not a problem, i think the path to the this files were incorrect..

Riftsaw even made a new folder like $jboss.as.home (the variable to set in the install/deployment.properties) in the Riftsaw folder, so the paths are really messed up.Riftsaw is looking for sth like d:\riftsaw\install\$jboss_home\server\default\ ..

Under jboss.as.home i used d:\mywork\jboss-5.1.0.GA.

I know i had the same problems on my first installation, but somehow managed it.

ALthough in my build.xml for deploying my project i had to write my as_home as d\:mypathmysecondpath, messed up...

What am i missing ?

24. Specific (national) characters & UTF-8 Hex

jeff.yuchang Feb 16, 2011 9:34 PM (in response to izgur)

Igor JStarter wrote:

So it is a database problem
I really hope this will solve my problem ... I'll post tomorrow how it worked. Thank you very much!

Just for the record, I've also verified it, here is the steps that I did to support the UTF-8 Encoding.

1) First, make your database (like mysql) supporting UTF-8 encoding.

2) In the bpel.properties, add below two properties to make it support UTF-8.

hibernate.connection.useUnicode=true

hibernate.connection.characterEncoding=UTF-8

Regards

Jeff

25. Re: Specific (national) characters & UTF-8 Hex

jeff.yuchang Feb 16, 2011 10:28 PM (in response to izgur)

Igor JStarter wrote:

But the was not a problem, i think the path to the this files were incorrect..
Riftsaw even made a new folder like $jboss.as.home (the variable to set in the install/deployment.properties) in the Riftsaw folder, so the paths are really messed up.Riftsaw is looking for sth like d:\riftsaw\install\$jboss_home\server\default\ ..
Under jboss.as.home i used d:\mywork\jboss-5.1.0.GA.
I know i had the same problems on my first installation, but somehow managed it.
ALthough in my build.xml for deploying my project i had to write my as_home as d\:mypathmysecondpath, messed up...

What am i missing ?

We used the org_jboss_as_home (instead of jboss.as.home) in the install/deployment.properties in the 2.2.0 release.

The error that you saw is the exact reson that why we changed the dot to underscore in the property name.

26. Specific (national) characters & UTF-8 Hex

izgur Feb 17, 2011 4:14 AM (in response to jeff.yuchang)

HM... I thought I just need to change the collation of my riftsaw db tables... but that doesn't work...

I used a php script to change all collations and it set it to utf8_general_ci..

<?php
$db = mysql_connect('localhost','myuser_mydbuser','mypassword');
if(!$db) echo "Cannot connect to the database - incorrect details";
mysql_select_db('myuser_mydbname'); $result=mysql_query('show tables');
while($tables = mysql_fetch_array($result)) {
foreach ($tables as $key => $value) {
mysql_query("ALTER TABLE $value COLLATE utf8_general_ci");
}}
echo "The collation of your database has been successfully changed!";
?>

I still can't put a čćđ into my mysql db.

You said i need to upgrade mysql to support utf8. But it should. I'm using xampp 1.7.3.a with Mysql 5.1.41.

Thank you for your answer about the windows install. I'll try it today...

27. Specific (national) characters & UTF-8 Hex

izgur Feb 17, 2011 4:59 AM (in response to izgur)

OK.

On my PC i found out that:

alter table 'mytable' convert to character set utf8

makes the right changes on the mytable->data,

so i can insert my čćđ.

Can i now stop the server, make the sql changes in the living db and start the server...

I'm a little scared... will the server start without any problems?

I read that on lamp you should then use the 'set NAMES' option to work ...

28. Re: Specific (national) characters & UTF-8 Hex

jeff.yuchang Feb 17, 2011 5:08 AM (in response to izgur)

Hi Igor,

I didn't use that way to make mysql using utf-8 by default.

what I used approach is: (note, I am using mysql on Mac OS X),

copy the /opt/local/share/mysql5/mysql/my-small.cnf into /opt/local/etc/mysql5/my.cnf, and then adding "default-character-set=utf8":

like:

[client]

#password = your_password

port = 3306

socket = /opt/local/var/run/mysql5/mysqld.sock

default-character-set = utf8

[mysqld]

port = 3306

socket = /opt/local/var/run/mysql5/mysqld.sock

skip-locking

key_buffer_size = 16K

max_allowed_packet = 1M

table_open_cache = 4

sort_buffer_size = 64K

read_buffer_size = 256K

read_rnd_buffer_size = 256K

net_buffer_length = 2K

thread_stack = 128K

default-character-set = utf8

note the utf8 line above.

So I am not sure your case, better to test it on your pc firstly, and then apply it to the living db.

29. Specific (national) characters & UTF-8 Hex

izgur Feb 17, 2011 7:23 AM (in response to jeff.yuchang)

I did change everyting to utf8. If I insert a new string through the phpmyadmin/sql, it shows čćđ well.

Now I expand my mysql.log and I see that Riftsaw is the one, who makes the sql insert request with ? instead if č,ć,đ.

So mysql isn't changing it ..

Log: (my input string: testiram: ?š??ž )

110217 13:17:07 30 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED

30 Query insert into BPEL_MESSAGE_EXCHANGE (CALLEE, CHANNEL, CORRELATION_ID, CORRELATION_KEYS, CORRELATION_STATUS, CORR_ID, CREATE_TIME, DIRECTION, EPR, FAULT, FAULT_EXPLANATION, OPERATION, PARTNER_LINK_ID, PARTNER_LINK_MODEL_ID, PATTERN, PIPED_ID, PORT_TYPE, PROCESS_ID, PROCESS_INSTANCE_ID, PROPAGATE_TRANS, REQUEST_MESSAGE_ID, RESPONSE_MESSAGE_ID, STATUS, SUBSCRIBER_COUNT, MESSAGE_EXCHANGE_ID) values (null, null, null, null, null, null, null, 'M', null, null, null, null, null, 0, null, null, null, null, null, 0, null, null, null, 0, 'hqejbhcnphr61wmknms3p9')

30 Query insert into BPEL_MESSAGE (DATA, HEADER, MESSAGE_EXCHANGE_ID, TYPE) values ('<?xml version="1.0" encoding="UTF-8"?>\n<message><payload><cod:codesRequest xmlns:cod="http://kkissiskratel/codes">\n <cod:input>testiram: ?š??ž</cod:input>\n </cod:codesRequest></payload></message>', null, 'hqejbhcnphr61wmknms3p9', '{http://kkissiskratel/codes}codesRequestMessage')

30 Query insert into BPEL_MEX_PROP (MEX_ID, PROP_KEY, PROP_VALUE) values ('hqejbhcnphr61wmknms3p9', 'isTwoWay', 'true')

30 Query update BPEL_MESSAGE_EXCHANGE set CALLEE='{http://kkissiskratel/codes}codes', CHANNEL=null, CORRELATION_ID='hqejbhcnphr61wmknms3p8', CORRELATION_KEYS=null, CORRELATION_STATUS='UKNOWN_ENDPOINT', CORR_ID=null, CREATE_TIME=null, DIRECTION='M', EPR=null, FAULT=null, FAULT_EXPLANATION=null, OPERATION='process', PARTNER_LINK_ID=null, PARTNER_LINK_MODEL_ID=0, PATTERN='UNKNOWN', PIPED_ID=null, PORT_TYPE=null, PROCESS_ID=null, PROCESS_INSTANCE_ID=null, PROPAGATE_TRANS=0, REQUEST_MESSAGE_ID=41, RESPONSE_MESSAGE_ID=null, STATUS='ASYNC', SUBSCRIBER_COUNT=0 where MESSAGE_EXCHANGE_ID='hqejbhcnphr61wmknms3p9'

30 Query insert into ODE_JOB (channel, correlationKeySet, correlatorId, detailsExt, inMem, instanceId, mexId, nodeid, processId, retryCount, scheduled, ts, transacted, type, jobid) values (null, '@2', null, null, 0, 0, 'hqejbhcnphr61wmknms3p9', 'hqejbhcnphr61wmknms3p4', '{http://kkissiskratel/codes}codes-0', 0, 1, 1297945027255, 1, 'INVOKE_INTERNAL', 'hqejbhcnphr61wmknms3pa')

30 Query commit