I am using JCR JNDI API to achieve this, but there is no Lucene search available in JCR and I do not know about XPATH and SQL Search in JCR, I looked at the forums, but they are very abstract and could not follow.
If you can provide the XPATH search statements for the above, it would be great.