[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - EJB QL table name with underscores?

[wojtekb82]

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.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4060713#4060713

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4060713