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