-
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.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 TRACE [org.jboss.ws.core.soap.SOAPContentElement] (http-172.17.3.15-9000-2) getChildNodes
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"?>
<message><payload><cod:codesRequest xmlns:cod="http://kkissiskratel/codes">
<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"?>
<message><payload><cod:codesRequest xmlns:cod="http://kkissiskratel/codes">
<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"?>
<message><payload><codesResponse xmlns="http://kkissiskratel/codes"/></payload></message>
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"?>
<message><payload><codesResponse xmlns="http://kkissiskratel/codes">
<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"?>
<message><payload><codesResponse xmlns="http://kkissiskratel/codes">
<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"?>
<message><parameters><showMessageResponse xmlns="http://ws.apache.org/axis2"/></parameters></message>
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"?>
<message><parameters><showMessageResponse xmlns="http://ws.apache.org/axis2">
<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"?>
<message><parameters><showMessageResponse xmlns="http://ws.apache.org/axis2">
<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"?>
<message><parameters><showMessage xmlns="http://ws.apache.org/axis2"/></parameters></message>
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"?>
<message><parameters><showMessage xmlns="http://ws.apache.org/axis2">
<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"?>
<message><parameters><showMessage xmlns="http://ws.apache.org/axis2">
<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"?>
<message><parameters><showMessage xmlns="http://ws.apache.org/axis2">
<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"?>
<message><parameters><showMessage xmlns="http://ws.apache.org/axis2">
<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"?>
<message><parameters><showMessage xmlns="http://ws.apache.org/axis2">
<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:
<message>
<parameters>
<showMessage xmlns='http://ws.apache.org/axis2'>
<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