Enterprise Maps Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

DQL Error using naitive query

SOLVED
Go to solution
Highlighted
tobiasbrecht
Occasional Contributor

DQL Error using naitive query

Hi All,

I want to execute a native SQL query within a DQL query, based on the documentation I've built an easy example to understand the naitive clause.
But I am always getting an error while executing the query.

Here is the DQL query:

select s.name from (naitive (name) {select name_val as name from ryga_nodeArtifacts where discriminator = 'server'}) s

Here is the error:

Error: Error processing the DQL statement [dql=select s.name from (naitive (name) {select name_val as name from ryga_nodeArtifacts where discriminator = 'server'}) s]; nested exception is com.hp.systinet.dql.impl.parser.DqlParseExceptionImpl: DQL Parsing error: no viable alternative at input 'naitive' in phase PARSER at line 1, column 20 for query: "select s.name from (naitive (name) {select name_val as name from ryga_nodeArtifacts where discriminator = 'server'}) s".
SQLState:  null
ErrorCode: 0

 

Does any one have an idea how to fix this?

Thanks,
Tobi

 

 

2 REPLIES
pz1
Super Collector
Solution

Re: DQL Error using naitive query

Hi Tobi,

There is a typo in the query.

select s.name from ( naitive native (name) {select name_val as name from ryga_nodeArtifacts where discriminator = 'server'})s

Best Regards

 -pavel-

tobiasbrecht
Occasional Contributor

Re: DQL Error using naitive query

Ops... sorry I ddint saw that...

Thanks!

//Add this to "OnDomLoad" event