In most databases I've used, 'count' is a reserved keyword. Could
that be your problem?
Chris
----- Original Message -----
From: "Jan Peter Hecking" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 20, 2001 9:09 PM
Subject: [jBoss-User] [JAWS] SQLException: Unexpected token
> Hello,
>
> first of all let me say that I'm new to jBoss and EJBs in general.
> I'm using the jboss_tomcat 2.0-FINAL distribution without further
> configuration - so I'm using InstantDB/Hypersonic.
>
> To get started I wrote a very simple entity bean with CMP and a
> corresponding simple client. I don't know whether it's appropriate
> to mail this to this list (the sources are about 3kb), so I put it
> on
http://www.informatik.uni-rostock.de/~jhecking/ejb/counter-sources.j
ar
> in case you want to take a look at the sources.
>
> After the first deployment everything works as expected.
> But after a hot redeployment or after restarting the jboss server
I
> get the following exception whenever I try to access the entity
> bean:
>
> ------------------------------
snip --------------------------------
> [JAWS] java.sql.SQLException: Unexpected token: FROM in statement
[SELECT name,count FROM Counter WHERE name='test']
>
> ...
>
> ------------------------------
snip --------------------------------
>
> "SELECT name,count FROM Counter WHERE name='test'"
>
> To me this looks like a perfectly valid SQL statement so what's
> going on here?
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
