issue while using use-rdbms-expression-factory and slide2.1 with MYSQL and DASL

["pah@terma.it" <pa...@terma.it>]

Hi,

wonder if anyone can help me with my performance issues with DASL.

I have seen posts about use-rdbms-expression-factory, and I have placed this option inside my Domain.xml, but I then get no results from any search. Other people seem to be getting results, so maybe its something weird with my config.

Has anyone else seen this result  ?

Here is my Domain.xml and DASL query and am running on 
mysql-4.1.10a-2.RHEL4.1
mysql-server-4.1.10a-2.RHEL4.1
jakarta-slide 2.1
slide>
    <namespace name="slide">
<definition>
<store name="MySqlStore" classname="org.apache.slide.store.BindingStore" >
  <nodestore classname="org.apache.slide.store.impl.rdbms.JDBCStore">
    <parameter name="adapter">org.apache.slide.store.impl.rdbms.MySql41RDBMSAdapter</parameter>
    <parameter name="driver">com.mysql.jdbc.Driver</parameter>
    <parameter name="url">jdbc:mysql://localhost/slide</parameter>
    <parameter name="user">slide</parameter>
    <parameter name="password">valeria</parameter>
    <parameter name="dbcpPooling">true</parameter>
    <parameter name="maxPooledConnections">10</parameter>
    <parameter name="isolation">SERIALIZABLE</parameter>
    <parameter name="compress">false</parameter>
    <!--
    <parameter name="use-rdbms-expression-factory">true</parameter>
    -->
  </nodestore>
  <contentstore>
    <reference store="nodestore" />
  </contentstore>
  <securitystore>
    <reference store="nodestore" />
  </securitystore>
  <lockstore>
    <reference store="nodestore" />
  </lockstore>
  <revisiondescriptorsstore>
    <reference store="nodestore" />
  </revisiondescriptorsstore>
  <revisiondescriptorstore>
    <reference store="nodestore" />
  </revisiondescriptorstore>
 </store>
 <scope match="/" store="MySqlStore"/>


Utils.search : daslXML : <D:searchrequest xmlns:D ="DAV:"><D:basicsearch><D:select><D:allprop/></D:select><D:from><D:scope><D:href></D:href><D:depth>1</D:depth></D:scope></D:from><D:orderby><D:order><D:prop><D:resourcetype/></D:prop><D:ascending/></D:order><D:order><D:prop><D:displayname/></D:prop><D:ascending/></D:order></D:orderby></D:basicsearch></D:searchrequest>
22 Jul 2005 09:18:40 - org.apache.slide.store.impl.rdbms.AbstractRDBMSStore - INFO - executing: select u.URI_STRING, o.CLASS_NAME from ((OBJECT o inner join URI u on u.URI_ID = o.URI_ID) inner join VERSION_HISTORY vh on vh.URI_ID = u.URI_ID)  where  (u.URI_STRING = '/files' OR (u.URI_STRING LIKE '/files/%' AND u.URI_STRING NOT LIKE '/files/%/%'))
http-8080-Processor22, 22-Jul-2005 09:18:40, liferay.com.1, SEARCH, 207 "Multi-Status", 15 ms, /files/
State: 207
 Body : [#document: null]
Pragma: No-cache

Cache-Control: no-cache

Expires: Thu, 01 Jan 1970 00:00:00 GMT

Set-Cookie: JSESSIONID=5F37ABE160750B0EF2242F7A6824F37E; Path=/slide

Content-Type: text/xml;charset=UTF-8

Transfer-Encoding: chunked

Date: Fri, 22 Jul 2005 09:18:40 GMT

Server: Apache-Coyote/1.1

Utils.search : exit


Thanks in advance.

Paul.




---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org