Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of eevans@acunu.com designates
 209.85.210.44 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAK4eHaozwPDeZoy4JtsMCxLXE9WMTrv84YQ2EOGCstHzKQg31g@mail.gmail.com>
References: 
 <CAK4eHaozwPDeZoy4JtsMCxLXE9WMTrv84YQ2EOGCstHzKQg31g@mail.gmail.com>
Date: Thu, 8 Dec 2011 09:29:23 -0600
Message-ID: 
 <CAL35Oi1U2wzrfK5BU3Z3qF1fX+7j5wSJW_hXHN+VpnFCs6Q7Bw@mail.gmail.com>
Subject: Re: Cassandra jdbc-driver: no viable alternative at character '?'
From: Eric Evans <eevans@acunu.com>
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Thu, Dec 8, 2011 at 4:20 AM, Dinusha Dilrukshi
<sdddilrukshi@gmail.com> wrote:
> I am using cassandra-jdbc driver and following is my code snip written fo=
r
> delete a entry from column family.

Where did you get this driver?  Is it a release, is it from git (and
if so, when/which ID?).  What version of Cassandra are you testing
against?

> String query1 =3D "delete from USER where key=3D?";
> PreparedStatement stmt =3D con.prepareStatement(query1);
> stmt.setString(1, "dinusha");
> stmt.execute();
>
> But I am getting following exception when it executes.
>
> java.sql.SQLSyntaxErrorException: line 1:27 no viable alternative at
> character '?'
> at
> org.apache.cassandra.cql.jdbc.CassandraStatement.doExecute(CassandraState=
ment.java:173)
> at
> org.apache.cassandra.cql.jdbc.CassandraStatement.executeUpdate(CassandraS=
tatement.java:230)
> at
> org.apache.cassandra.cql.jdbc.CassandraPreparedStatement.executeUpdate(Ca=
ssandraPreparedStatement.java:273)
>
> This is not only with delete statement, I have experience this with UPDAT=
E
> statement as well.
>
> Greatly appreciate if anyone can advice to overcome this problem?
>
> Regards,
> ~Dinusha~
>


--=20
Eric Evans
Acunu |=A0http://www.acunu.com=A0| @acunu