Enterprise Maps Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

DQL Error using naitive query

SOLVED
Go to Solution
Highlighted
Occasional Advisor

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
Advisor

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-

Occasional Advisor

Re: DQL Error using naitive query

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

Thanks!