This discussion is archived
0 Replies Latest reply: May 3, 2011 5:54 AM by 842214 RSS

java.sql.SQLSyntaxErrorException: Lexical error  (JDBC Resource Pool?)

842214 Newbie
Currently Being Moderated
I'm thinking that this problem is related to the Glassfish pool resource connection, hence my posting under this forum:

Netbeans Web Application Servlet, internal EJB->Glassfish 3.1->Ingres II

the table name is t#userprof2, the EJB class is named TUserprof2

works with same tables mirrored in SQLServer but NOT with Ingres

No problems creating EJB with Ingres driver

I can ping the Ingres RDB from Glassfish JNDI/Pool resources

Browser Message:

Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.2.0.v20110202-r8913): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: Lexical error at line 1, column 38. Encountered: "#" (35), after : "".
Error Code: -1
Call: SELECT username, default_store FROM t#userprof2 WHERE (email = ?)
bind => [1 parameter bound]
Query: ReportQuery(name="TUserprof2.scfind" referenceClass=TUserprof2 sql="SELECT username, default_store FROM t#userprof2 WHERE (email = ?)")

Edited by: shawnc on May 3, 2011 8:53 AM


  • Correct Answers - 10 points
  • Helpful Answers - 5 points