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 anymore. Thanks, Kieran The value type also specifies which JDBC methods are used to send and retrieve the data to and from the database. These value types affect which method the java.sql.PreparedStatement object uses to transfer text data between the database and the JDBC adaptor. For attributes with a value class of String, the following value types are defined: —uses setString if the text is less than the database’s advertised maximum varchar length and setCharacterStream if it is too large. If the database fails to advertise a maximum length, the default is 256 characters. S—uses setString regardless of the text’s length. C—uses setCharacterString regardless of the text’s length. E—converts the text into raw UTF-8 bytes and then uses setBinaryStream to save them in a binary-typed column in the database. c—tells the adaptor to generate SQL using RTRIM to strip off all trailing spaces. On Apr 13, 2007, at 8:16 PM, Peter Vandoros wrote: 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 documentation), then WO won't try to write/read the data as binary and convert it to a UTF8 String but instead it will write/read the data as a UTF8 String directly. This should solve your issue. Keep in mind that you need to make sure that your JDBC URL is set to use that charset and unicode. See WebObjects wiki for more details on using MySQL with WO. Regards Peter On 14/04/2007, at 4:58 AM, Kieran Kelleher wrote: 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'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. Xavier 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 expect?? ... UPPER(T3.textobject) LIKE UPPER(_utf8'%argentina%') ... I am using MySQL. My connection string is: jdbc:mysql://localhost/omega? useUnicode=true&characterEncoding=UTF-8 and the table is defined as: CREATE TABLE `textblob` ( `oid` int(11) NOT NULL, `textobject` text, PRIMARY KEY (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; Am I correct in thinking I should not be getting _binary before the search term? -Kieran ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/webobjects% 40anazys.com This email sent to [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/peter% 40etechgroup.com.au This email sent to [EMAIL PROTECTED] -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/kieran_lists% 40mac.com This email sent to [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
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 documentation), then WO won't try to write/read the data as binary and convert it to a UTF8 String but instead it will write/read the data as a UTF8 String directly. This should solve your issue. Keep in mind that you need to make sure that your JDBC URL is set to use that charset and unicode. See WebObjects wiki for more details on using MySQL with WO. Regards Peter On 14/04/2007, at 4:58 AM, Kieran Kelleher wrote: 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'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. Xavier 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 expect?? ... UPPER(T3.textobject) LIKE UPPER(_utf8'%argentina%') ... I am using MySQL. My connection string is: jdbc:mysql://localhost/omega?useUnicode=true&characterEncoding=UTF-8 and the table is defined as: CREATE TABLE `textblob` ( `oid` int(11) NOT NULL, `textobject` text, PRIMARY KEY (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; Am I correct in thinking I should not be getting _binary before the search term? -Kieran ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/webobjects% 40anazys.com This email sent to [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/peter% 40etechgroup.com.au This email sent to [EMAIL PROTECTED] -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
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 Apr 13, 2007, at 4:45 PM, Fabrice Pipart wrote: 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 Apple docs : http://developer.apple.com/documentation/WebObjects/Web_Services/ Web_Services/chapter_4_section_3.html I am not trying to consume that web service from a Cocoa app (that part works) but from Web Objects. And unfortunately WO itself cannot consume a web service it provides itself :-( But the tips might be useful to improve the Cocoa part ;-) Le 13 avr. 07 à 22:00, Robert Walker a écrit : 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 frameworks. Number will not. Make sure that whatever value you are sending for height is one of the known "simple" types like xsd:int or xsd:float. 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 Fabrice ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/robertwalker1% 40mac.com This email sent to [EMAIL PROTECTED] -- Robert Walker [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
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 Apple docs : http://developer.apple.com/documentation/WebObjects/Web_Services/ Web_Services/chapter_4_section_3.html I am not trying to consume that web service from a Cocoa app (that part works) but from Web Objects. And unfortunately WO itself cannot consume a web service it provides itself :-( But the tips might be useful to improve the Cocoa part ;-) Le 13 avr. 07 à 22:00, Robert Walker a écrit : 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 frameworks. Number will not. Make sure that whatever value you are sending for height is one of the known "simple" types like xsd:int or xsd:float. 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 Fabrice ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
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 11:24 AM, Fabrice Pipart wrote: 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 QName("http://client.easyshadow.com";, "MyClass"); WOWebServiceRegistrar.registerFactoriesForClassWithQName(new BeanSerializerFactory(com.easyshadow.client. MyClass.class, qname), new BeanDeserializerFactory(com.easyshadow.client. MyClass.class, qname), com.easyshadow.client. MyClass.class, qname); ... Regards Fabrice Pipart -- Robert Walker [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
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 frameworks. Number will not. Make sure that whatever value you are sending for height is one of the known "simple" types like xsd:int or xsd:float. On Apr 13, 2007, at 11:24 AM, Fabrice Pipart wrote: 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 QName("http://client.easyshadow.com";, "MyClass"); WOWebServiceRegistrar.registerFactoriesForClassWithQName(new BeanSerializerFactory(com.easyshadow.client. MyClass.class, qname), new BeanDeserializerFactory(com.easyshadow.client. MyClass.class, qname), com.easyshadow.client. MyClass.class, qname); 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 Apple docs : http://developer.apple.com/documentation/WebObjects/Web_Services/ Web_Services/chapter_4_section_3.html No luck. Yes I can list all the methods that can be called. But as soon as I try to invoke one, I get this : javax.xml.rpc.ServiceException: Error processing WSDL document: java.io.IOException: Type Number is referenced but not defined. Here is the header of my generated wsdl file : http://192.168.41.102/cgi-bin/ WebObjects/EasyMediaOnline.woa/-2007/ws/.AssistantResponder" xmlns="http://schemas.xmlsoap.org/wsdl/"; xmlns:apachesoap="http://xml.apache.org/xml-soap"; xmlns:impl="http://192.168.41.102/cgi-bin/WebObjects/ EasyMediaOnline.woa/-2007/ws/.AssistantResponder" xmlns:intf="http://192.168.41.102/cgi-bin/WebObjects/ EasyMediaOnline.woa/-2007/ws/.AssistantResponder" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"; xmlns:tns2="http://client.easyshadow.com"; xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/"; xmlns:wsdlsoap="http://schemas.xmlsoap.org/wsdl/soap/"; xmlns:xsd="http://www.w3.org/2001/XMLSchema";> ... ... Note that tns3 is referenced but never "defined"... Is this a WO bug when generating the wsdl? I am not a WebService expert, so I may have misunderstood something... Regards Fabrice Pipart www.easyshadow.com International Corporate Consulting Palais de la Scala 1 avenue Henri Dunant Suite 1155 MC - 98000 Monaco Skype: fabrice.pipart Tel. +377 97 98 21 04 (direct) Fax. +377 97 70 88 07 ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/robertwalker1% 40mac.com This email sent to [EMAIL PROTECTED] -- Robert Walker [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
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'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. Xavier 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 expect?? ... UPPER(T3.textobject) LIKE UPPER(_utf8'%argentina%') ... I am using MySQL. My connection string is: jdbc:mysql://localhost/omega?useUnicode=true&characterEncoding=UTF-8 and the table is defined as: CREATE TABLE `textblob` ( `oid` int(11) NOT NULL, `textobject` text, PRIMARY KEY (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; Am I correct in thinking I should not be getting _binary before the search term? -Kieran ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/webobjects% 40anazys.com This email sent to [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
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 QName("http://client.easyshadow.com";, "MyClass"); WOWebServiceRegistrar.registerFactoriesForClassWithQName(new BeanSerializerFactory(com.easyshadow.client. MyClass.class, qname), new BeanDeserializerFactory(com.easyshadow.client. MyClass.class, qname), com.easyshadow.client. MyClass.class, qname); 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 Apple docs : http://developer.apple.com/documentation/WebObjects/Web_Services/ Web_Services/chapter_4_section_3.html No luck. Yes I can list all the methods that can be called. But as soon as I try to invoke one, I get this : javax.xml.rpc.ServiceException: Error processing WSDL document: java.io.IOException: Type Number is referenced but not defined. Here is the header of my generated wsdl file : http://192.168.41.102/cgi-bin/ WebObjects/EasyMediaOnline.woa/-2007/ws/.AssistantResponder" xmlns="http://schemas.xmlsoap.org/wsdl/"; xmlns:apachesoap="http://xml.apache.org/xml-soap"; xmlns:impl="http://192.168.41.102/cgi-bin/WebObjects/ EasyMediaOnline.woa/-2007/ws/.AssistantResponder" xmlns:intf="http://192.168.41.102/cgi-bin/WebObjects/ EasyMediaOnline.woa/-2007/ws/.AssistantResponder" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"; xmlns:tns2="http://client.easyshadow.com"; xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/"; xmlns:wsdlsoap="http://schemas.xmlsoap.org/wsdl/soap/"; xmlns:xsd="http://www.w3.org/2001/XMLSchema";> ... ... Note that tns3 is referenced but never "defined"... Is this a WO bug when generating the wsdl? I am not a WebService expert, so I may have misunderstood something... Regards Fabrice Pipart www.easyshadow.com International Corporate Consulting Palais de la Scala 1 avenue Henri Dunant Suite 1155 MC - 98000 Monaco Skype: fabrice.pipart Tel. +377 97 98 21 04 (direct) Fax. +377 97 70 88 07 smime.p7s Description: S/MIME cryptographic signature ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
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 has failed to provide new primary key for an entity. The entity involved is not always the same, and this error seems to popup randomly. I use the jDTS JDBC driver connected to a Microsoft SQL Server 2000 database using a custom JDBC adaptor plugin that inherits the default MicrosoftPlugIn one. This plugin is stable since a long time. This is the typical stack trace: java.lang.IllegalStateException: Adaptor [EMAIL PROTECTED] failed to provide new primary keys for entity 'Adresse' at com.webobjects.eoaccess.EODatabaseContext.prepareForSaveWithCoordinator (EODatabaseContext.java:5885) at com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext (EOObjectStoreCoordinator.java:409) at com.webobjects.eocontrol.EOEditingContext.saveChanges( EOEditingContext.java:3226) ... Did somebody already have this kind of error? I would like to track down and fix this behavior, but I can't figure what's the cause. Did somebody have an explanation? I had the exactly same error in a scenario: I usually create tables by EOModeler, I generate the EOModel File and select Syncronize schema! and in my tables I put the primary key not modeled by the eomodel file. It happens to me, that I need to use the primary key as a field of a search (for example of the Order Number), and I've this error. I realize that the problem was that EOModeler don't create primary keys on the tables, but only set UNIQUE (selecting provide primary key generation) while syncronizing the DB. So, when I don't model the primary key (ad default EOModeler set) there's no problem, because the adaptor set it automatically, but when modeling the field it doesn't provide the primary key and throw this exception. I've fixed the problem by setting the primary key autogeneration on the db tables, so I don't need to thouch them. I hope this could help, check the EOModel file, and the tables on your db. Fixing them everything should be fine! Kind regards, -- *Francis Labrie* Saint-Bruno-de-Montarville, Québec, Canada ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/ildenae%40gmail.com This email sent to [EMAIL PROTECTED] -- Daniele Corti AIM: S0CR4TE5 Messenger: [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
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 an entity. The entity involved is not always the same, and this error seems to popup randomly. I use the jDTS JDBC driver connected to a Microsoft SQL Server 2000 database using a custom JDBC adaptor plugin that inherits the default MicrosoftPlugIn one. This plugin is stable since a long time. This is the typical stack trace: java.lang.IllegalStateException: Adaptor [EMAIL PROTECTED] failed to provide new primary keys for entity 'Adresse' at com.webobjects.eoaccess.EODatabaseContext.prepareForSaveWithCoordinator( EODatabaseContext.java:5885) at com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingCo ntext(EOObjectStoreCoordinator.java:409) at com.webobjects.eocontrol.EOEditingContext.saveChanges (EOEditingContext.java:3226) ... Did somebody already have this kind of error? I would like to track down and fix this behavior, but I can't figure what's the cause. Did somebody have an explanation? Kind regards, -- Francis Labrie Saint-Bruno-de-Montarville, Québec, Canada ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
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. Xavier 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 expect?? ... UPPER(T3.textobject) LIKE UPPER(_utf8'%argentina%') ... I am using MySQL. My connection string is: jdbc:mysql://localhost/omega?useUnicode=true&characterEncoding=UTF-8 and the table is defined as: CREATE TABLE `textblob` ( `oid` int(11) NOT NULL, `textobject` text, PRIMARY KEY (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; Am I correct in thinking I should not be getting _binary before the search term? -Kieran ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/webobjects% 40anazys.com This email sent to [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
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 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=SessionID make this changing directActionName for every direct action you whish to call, and (in java) when you call this.session() you will have the session with the SessionID you've passed! The pop up has a javascript onchange method: "location.href=this.form.documents.options [this.form.documents.selectedIndex].value" And I need to call a page within the current session. Any help greatly appreciated. Thanks in advance Gino - Gino L. Pacitti Base Enterprise UK email: [EMAIL PROTECTED] phone: sales: 01342 325372 support: 08700 664075 fax: 01342 325 372 mob: 07980 851 953 aol: kris121 msn: [EMAIL PROTECTED] mac.com: [EMAIL PROTECTED] http://www.base-enterprise.co.uk mail: Base Enterprise PO BOX 674 East Grinstead West Sussex RH19 3ZG Web Design, coding and information architect Web Objects and Database Developer HTML, XML, Javascript and WAP technologies. - This email and any attachments is confidential and may be legally privileged and protected from disclosure. It is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient of this e-mail of any parts of it please telephone +44 1342 325372 immediately upon receipt or contact [EMAIL PROTECTED] No other person is authorized to copy, forward or disclose, distribute or retain this e-mail in any form. ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/ildenae% 40gmail.com This email sent to [EMAIL PROTECTED] hope this help -- Daniele Corti AIM: S0CR4TE5 Messenger: [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
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 the text the stream point to, but the type of the field is binary (and so WO sees it as a binary, and treats it thereby) 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 expect?? ... UPPER(T3.textobject) LIKE UPPER(_utf8'%argentina%') ... I am using MySQL. My connection string is: jdbc:mysql://localhost/omega?useUnicode=true&characterEncoding=UTF-8 and the table is defined as: CREATE TABLE `textblob` ( `oid` int(11) NOT NULL, `textobject` text, PRIMARY KEY (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; Am I correct in thinking I should not be getting _binary before the search term? -Kieran ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/ildenae%40gmail.com This email sent to [EMAIL PROTECTED] -- Daniele Corti AIM: S0CR4TE5 Messenger: [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
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=SessionID make this changing directActionName for every direct action you whish to call, and (in java) when you call this.session() you will have the session with the SessionID you've passed! The pop up has a javascript onchange method: "location.href=this.form.documents.options [this.form.documents.selectedIndex].value" And I need to call a page within the current session. Any help greatly appreciated. Thanks in advance Gino - Gino L. Pacitti Base Enterprise UK email: [EMAIL PROTECTED] phone: sales: 01342 325372 support: 08700 664075 fax: 01342 325 372 mob: 07980 851 953 aol: kris121 msn: [EMAIL PROTECTED] mac.com: [EMAIL PROTECTED] http://www.base-enterprise.co.uk mail: Base Enterprise PO BOX 674 East Grinstead West Sussex RH19 3ZG Web Design, coding and information architect Web Objects and Database Developer HTML, XML, Javascript and WAP technologies. - This email and any attachments is confidential and may be legally privileged and protected from disclosure. It is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient of this e-mail of any parts of it please telephone +44 1342 325372 immediately upon receipt or contact [EMAIL PROTECTED] No other person is authorized to copy, forward or disclose, distribute or retain this e-mail in any form. ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/ildenae%40gmail.com This email sent to [EMAIL PROTECTED] hope this help -- Daniele Corti AIM: S0CR4TE5 Messenger: [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
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 expect?? ... UPPER(T3.textobject) LIKE UPPER(_utf8'%argentina%') ... I am using MySQL. My connection string is: jdbc:mysql://localhost/omega?useUnicode=true&characterEncoding=UTF-8 and the table is defined as: CREATE TABLE `textblob` ( `oid` int(11) NOT NULL, `textobject` text, PRIMARY KEY (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; Am I correct in thinking I should not be getting _binary before the search term? -Kieran ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
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 call a page within the current session. Any help greatly appreciated. Thanks in advance Gino - Gino L. Pacitti Base Enterprise UK email: [EMAIL PROTECTED] phone: sales: 01342 325372 support: 08700 664075 fax: 01342 325 372 mob: 07980 851 953 aol: kris121 msn: [EMAIL PROTECTED] mac.com: [EMAIL PROTECTED] http://www.base-enterprise.co.uk mail: Base Enterprise PO BOX 674 East Grinstead West Sussex RH19 3ZG Web Design, coding and information architect Web Objects and Database Developer HTML, XML, Javascript and WAP technologies. - This email and any attachments is confidential and may be legally privileged and protected from disclosure. It is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient of this e-mail of any parts of it please telephone +44 1342 325372 immediately upon receipt or contact [EMAIL PROTECTED] No other person is authorized to copy, forward or disclose, distribute or retain this e-mail in any form. ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([EMAIL PROTECTED]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]