Filtering string columns with MySql DB
I'm using MySql V5.1 as my DB and running JDeveloper 11.1.1.3. When I create a table and enable filtering on the columns, I find that I get no data back whenever I try to filter on a string-valued column, regardless of the string I enter (inlcuding a valid string value contained in the column).
I have already determined that I am using SQL92 as my SQL flavour and that Java is the type setting for the DB connection. If I try to filter on columns with other data types the filter works as expected. If anybody has seen this problem and knows how to fix it, then I'd be very grateful for a pointer in the right direction. The only clue I have, although it may be a red herring is that I get the message below on the weblogic console when I run the page.
<TransientMBeanAssociationInfo><doCreateAndRegisterMBean> MBean "oracle.bc4j.mbean.config:name=model.common.bc4j.xcfg,type=oracle.bc4j.mbean.config,Application=Pages" cannot be registered.
Many thanks,
George Nelson
As an update to this, I have created an example page that does either a quick query or advanced query and in both cases any attempt to query on a String based field returns no rows regardless of the query value entered. I expected this would be the case but wanted to verify this.
Edited by: George Nelson on 01-Oct-2010 17:52