You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-user@jakarta.apache.org by Paul Hussein <pa...@terma.191.it> on 2005/09/08 10:22:48 UTC

DASL not working with expression factory for mysql 4.1 binding store

I am trying to turn on the expression factory for my store. However when 
I turn the expression factory on, none of my DASL queries return any 
results.

When i switch off the expression factory, all is well again.

I am using the mysql 4.1 store with binding.

Can someone help or give me some hints on how to solve this issue ?

I have included my DASL and the debug and my Domain.xml store config :

Utils.search : enter
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>
08 Sep 2005 08:15:19 - 
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-Processor21, 08-Sep-2005 08:15:19, liferay.com.1, SEARCH, 207 
"Multi-Status", 29 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=581CBFE1360D74D5F47F2B3DDC9EF951; Path=/slide

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

Transfer-Encoding: chunked

Date: Thu, 08 Sep 2005 08:15:19 GMT

Server: Apache-Coyote/1.1

Utils.search : exit


Domain.xml
---------------
<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>
    <!-- database metadata search -->
    <parameter name="use-rdbms-expression-factory">true</parameter>
   <!--
   <propertiesindexer 
classname="org.apache.slide.index.lucene.LucenePropertiesIndexer">
       <parameter name="indexpath">store/index/metadata</parameter>
  </propertiesindexer>
  -->
  </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>




Cheers

Paul.



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