1 Reply Latest reply on Jul 9, 2007 3:50 PM by Frank Langelage

    EJB QL table name with underscores?

    Wojciech Burak Newbie

      Hi, I get the following error:

      2007-07-05 11:03:51,377 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] Incomplete Deployment listing:
      
      --- MBeans waiting for other MBeans ---
      ObjectName: jboss.j2ee:jndiName=xxxxxx/ejb/XXXXXXXX,service=EJB
       State: FAILED
       Reason: org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT OBJECT(partner) FROM TABLE_NAME_WITH_UNDERSCORES partner'; - nested
       throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "TABLE_" at line 1, column 29.
      Was expecting one of:
       "IN" ...
       <ABSTRACT_SCHEMA> ...
       )
      
      --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
      ObjectName: jboss.j2ee:jndiName=xxxxxx/ejb/XXXXXXXX,service=EJB
       State: FAILED
       Reason: org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT OBJECT(partner) FROM TABLE_NAME_WITH_UNDERSCORES partner'; - nested
       throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "TABLE_" at line 1, column 29.
      Was expecting one of:
       "IN" ...
       <ABSTRACT_SCHEMA> ...
       )
      
      


      I am using jboss-3.2.8.SP1 and j2sdk1.4.2_14

      Thanks in advance for replies.