*** ERROR: <AST>:0:0: unexpected AST node

leebase · **Joined:** Tue Nov 02, 2004 1:34 pm **Posts:** 45

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.05

I'm getting: *** ERROR: <AST>:0:0: unexpected AST node

I'm writing my own sql as I'm using the Oracle Text to search xml documents.

Code:

SELECT distinct new com.sbc.netrics.struts.database.NddMetric( NddMetric.metricId, NddMetric.metricNumber,NddMetric.metricName,NddMetric.metricDescription,NddMetric.dataSteward)  FROM  com.sbc.netrics.struts.database.NddMetric NddMetric  WHERE CONTAINS(xml_doc, 'searchText);

I'm assuming it's similar to my last problem in that I'm using "contains" which is not an ansi standard sql statement.

I get the following error messages:

Code:

ERROR - [ErrorCounter.reportError] *** ERROR: <AST>:0:0: unexpected AST node: ( 
ERROR - [MetricCRUDAction.prepareBrowse] metricList failed: org.hibernate.hql.ast.QuerySyntaxError: unexpected AST node: ( [SELECT distinct new com.sbc.netrics.struts.database.NddMetric( NddMetric.metricId, NddMetric.metricNumber,NddMetric.metricName,NddMetric.metricDescription,NddMetric.dataSteward)  FROM  com.sbc.netrics.struts.database.NddMetric NddMetric  WHERE CONTAINS(xml_doc, 'shobha')  order by metric_name ASC] 

Is there a way I can just sent straight jdbc query and bypass hibernate's parsing? Yes...I can by doing a straight jdbc code and not using hibernate at all -- I know. Is there another way to attack this problem?

Lee

pksiv · **Posted:** Thu Oct 06, 2005 3:32 pm

leebase wrote:

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.05

I'm getting: *** ERROR: <AST>:0:0: unexpected AST node

I'm writing my own sql as I'm using the Oracle Text to search xml documents.

Code:

SELECT distinct new com.sbc.netrics.struts.database.NddMetric( NddMetric.metricId, NddMetric.metricNumber,NddMetric.metricName,NddMetric.metricDescription,NddMetric.dataSteward)  FROM  com.sbc.netrics.struts.database.NddMetric NddMetric  WHERE CONTAINS(xml_doc, 'searchText);

I'm assuming it's similar to my last problem in that I'm using "contains" which is not an ansi standard sql statement.

I get the following error messages:

Code:

ERROR - [ErrorCounter.reportError] *** ERROR: <AST>:0:0: unexpected AST node: ( 
ERROR - [MetricCRUDAction.prepareBrowse] metricList failed: org.hibernate.hql.ast.QuerySyntaxError: unexpected AST node: ( [SELECT distinct new com.sbc.netrics.struts.database.NddMetric( NddMetric.metricId, NddMetric.metricNumber,NddMetric.metricName,NddMetric.metricDescription,NddMetric.dataSteward)  FROM  com.sbc.netrics.struts.database.NddMetric NddMetric  WHERE CONTAINS(xml_doc, 'shobha')  order by metric_name ASC] 

Is there a way I can just sent straight jdbc query and bypass hibernate's parsing? Yes...I can by doing a straight jdbc code and not using hibernate at all -- I know. Is there another way to attack this problem?

Lee

Try sesssion.createSQLQuery("sql-query-goes-here").

leebase · **Joined:** Tue Nov 02, 2004 1:34 pm **Posts:** 45

That helped. I had already coded a staight JDBC method to handle this situation....which certainly reminded me why it's so nice to work with hibernate.

I ran into other issues with the SqlQuery...but will use my straight jdbc method for now...I may revisit this later.

Thanks again,

Lee