Hi Paul! Hmm... Looks a lot like what happens here, but for us it works. Which version of slide are you using? You do get the messages with the SQL statements, so the factory is working fine, and so are the expressions... Did you try to put some log statements into RDBMSComparableResourcesPool.retrieveObjects()? It would be my first try to find out if your database returns any results at all. Also, you could log a new Throwable to see the stacktrace at that point and figure out where in the call-tree you are.
Another point to put in extra debug stuff might be the SearchMethod.WebdavResult.init(). Thats where the response document is generated, which seems to be null in your case. Sorry I can't help more from here, I'm not so much into the RDBMS stuff myself.. Bye! max > -----Original Message----- > From: Paul Hussein [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 08, 2005 10:23 > To: Slide Users Mailing List; Slide Developers Mailing List > Subject: 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:fro > m><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:searc > hrequest> > 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.MySql41RDBMSA > dapter</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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
