Re: Troubleshooting utf8 text SQL generation

Ah yes, thanks for the pointer Peter. It is String C C = setCharacterStream for java.sql.PreparedStatement. It just seems obvious at the time to pick the entry having UTF8 character stream in the description. And the query is actually faster now and does not hit the slow query log any

Re: Troubleshooting utf8 text SQL generation

Hi Kieran, If you are using TEXT and specified the charset to utf8, then you don't need to specify the valueType of E. Value type E is for databases that don't support UTF8 natively. If you change the valueType to something like S of c (not sure if this one is correct, check the documenta

Re: Type Number in WO WebServices

Humm, Is there any possibility to register that complex type like I did for "MyClass" ? I guess it would be easier to change my numbers to ints but that app is versioned and I would prefer leaving it like this That is interesting Sorry I don't have an immediate answer for that. On

Re: Type Number in WO WebServices

Thanks for the answers ! Though I think you missed something : On Apr 13, 2007, at 11:24 AM, Fabrice Pipart wrote: I can access the WebService without problem from a Cocoa app. I thought it would be even easier to access the same Web Service from another WO app. I tried to base my code on Ap

Re: Type Number in WO WebServices

Fabrice, And now for my real response... Make your life many times happier and forget SOAP and use REST instead. Unless you have a very strong, and compelling, need to use SOAP web services. Life is sweet when running on REST, and is so much cleaner than SOAP. :) On Apr 13, 2007, at

Re: Type Number in WO WebServices

Fabrice, If you look here you can see the your are referring to a Java "Number" class which is also a complex class and Cocoa is not going to understand. Here is a simple type from one of my WSDL files: xsd:int will be understood fine by the core services framew

Re: Troubleshooting utf8 text SQL generation

Hi guys, thanks for replies. The field is a type TEXT, so it does support encoding by chance I noticed the SQL was casting my search terms to _binary and that seems wrong. On Apr 13, 2007, at 7:44 AM, Dev WO wrote: Hello Kieran, Someone will probably come up with an alternative, but I'

Type Number in WO WebServices

Hi list ! I beg for some help because I think I will get crazy about this issue. I have a class registered as a WebService : WOWebServiceRegistrar.registerWebService(AssistantResponder.class, true); I have a complex type registered with Bean Serializer and deserializer : QName qname = new QNa

Re: Microsoft SQL Server and random JDBCAdaptor "failed to provide new primary keys for entity" error

2007/4/13, Francis Labrie <[EMAIL PROTECTED]>: Hi, I have several WebObjects 5.3.3 / Java 1.5 applications in production since a long time. These applications are very stable, but sometimes (i.e. 0 to 10 times per week) I get IllegalStateException from the JDBCAdaptor adaptor claiming that is

Microsoft SQL Server and random JDBCAdaptor "failed to provide new primary keys for entity" error

Hi, I have several WebObjects 5.3.3 / Java 1.5 applications in production since a long time. These applications are very stable, but sometimes (i.e. 0 to 10 times per week) I get IllegalStateException from the JDBCAdaptor adaptor claiming that is has failed to provide new primary key for

Re: Troubleshooting utf8 text SQL generation

Hello Kieran, Someone will probably come up with an alternative, but I've never been to be able to make blob work the way I wanted with UTF-8. I had to convert my blob to mediumtext. As far as I know (but I'm not a db expert;)) blob can't have an encoding like a mediumtext for example. Xa

Re: popup help with session ID in URL

Thanks Daniele cant see the woods for the trees... :) Thanks I just created an array of NSDictionaries with the session IDS attached to each direct action name... Gino On 13 Apr 2007, at 11:56, Daniele Corti wrote: 2007/4/13, Gino Pacitti <[EMAIL PROTECTED]>: Hi All I need to add a sel

Re: Troubleshooting utf8 text SQL generation

2007/4/13, Kieran Kelleher <[EMAIL PROTECTED]>: I have a text blob attribute defined as External Type : TEXT Data Type : UTF Character Stream - String E Maybe I'm wrong, because I'm not a DB expert, but an UTF Character Stream is not text, but binary, while reading you'll get

Re: popup help with session ID in URL

2007/4/13, Gino Pacitti <[EMAIL PROTECTED]>: Hi All I need to add a selection of direct action urls to a pop up menu including the current session id Any ideas how I would do this? just create an URL like: http://yourdomain/cgi-bin/WebObjects/yourapp.woa/wa/directActionName?wosid=Sessio

Troubleshooting utf8 text SQL generation

I have a text blob attribute defined as External Type : TEXT Data Type : UTF Character Stream - String E EOF is treating it as binary in the SQL generation, so I get this: ... UPPER(T3.textobject) LIKE UPPER(_binary'%argentina%') ... instead of this which is what I should

popup help with session ID in URL

Hi All I need to add a selection of direct action urls to a pop up menu including the current session id Any ideas how I would do this? The pop up has a javascript onchange method: "location.href=this.form.documents.options [this.form.documents.selectedIndex].value" And I need to cal