0 Replies Latest reply on May 3, 2011 12:54 PM by 842214

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

      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