Return-Path: 
 <users-return-19774-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org>
X-Original-To: apmail-jackrabbit-users-archive@minotaur.apache.org
Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 9607E10BE9
	for <apmail-jackrabbit-users-archive@minotaur.apache.org>;
 Thu, 20 Jun 2013 10:10:20 +0000 (UTC)
Received: (qmail 12221 invoked by uid 500); 20 Jun 2013 10:10:13 -0000
Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org
Received: (qmail 11984 invoked by uid 500); 20 Jun 2013 10:10:08 -0000
Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@jackrabbit.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@jackrabbit.apache.org>
List-Post: <mailto:users@jackrabbit.apache.org>
List-Id: <users.jackrabbit.apache.org>
Reply-To: users@jackrabbit.apache.org
Delivered-To: mailing list users@jackrabbit.apache.org
Received: (qmail 11973 invoked by uid 99); 20 Jun 2013 10:10:07 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Jun 2013 10:10:07 +0000
X-ASF-Spam-Status: No, hits=2.0 required=5.0
	tests=SPF_NEUTRAL,URI_HEX
X-Spam-Check-By: apache.org
Received-SPF: error (athena.apache.org: encountered temporary error during SPF
 processing of domain of snowstormuser@gmail.com)
Received: from [216.139.250.139] (HELO joe.nabble.com) (216.139.250.139)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Jun 2013 10:10:01 +0000
Received: from [192.168.236.139] (helo=joe.nabble.com)
	by joe.nabble.com with esmtp (Exim 4.72)
	(envelope-from <snowstormuser@gmail.com>)
	id 1UpbnT-0007SN-EG
	for users@jackrabbit.apache.org; Thu, 20 Jun 2013 03:08:55 -0700
Date: Thu, 20 Jun 2013 03:08:40 -0700 (PDT)
From: shahid iqbal <snowstormuser@gmail.com>
To: users@jackrabbit.apache.org
Message-ID: <1371722920384-4658909.post@n4.nabble.com>
Subject: Error in sql2 while firing a select query.
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

I'm trying to fire a select query in sql2 and facing problem.

The query is as follows:
*select tag.*,fileinfo.* from [Invioce] as tag,[fileInfo] as fileinfo where
fileinfo.[size]=561276 *

The Error message that i'm getting while executing the query is as follows:
*javax.jcr.query.InvalidQueryException: Query:
select tag.*,fileinfo.* from [Invioce] as tag,(*)[fileInfo] as fileinfo
where fileinfo.[size]=561276; expected: <end>*

Is it possible to execute such type of query in sql2. or the query have some
bugs if so pls help me.

Thanks



--
View this message in context: http://jackrabbit.510166.n4.nabble.com/Error-in-sql2-while-firing-a-select-query-tp4658909.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.