Pervasive SQL 9.5 dynamic parameters in SELECT problem.

genius2003 · #1 (**permalink**) 03-03-08, 13:58

Hello.

I have to use dynamic parameters in my SELECT statement as follows

Code:

SELECT person0_.Id as Id0_0_, person0_.First_Name as First2_0_0_
  FROM Person person0_
  WHERE person0_.Id=?p0; p0 = '104101361'

Unfortunately, this leads to

Code:

[LNA][Pervasive][ODBC Engine Interface]Syntax Error:
SELECT person0_.Id as Id0_0_, person0_.First_Name as First2_0_0_
  FROM Person person0_
  WHERE person0_.Id=?p<< ??? >>0

If anyone has an idea of how it could be overcome, please let me know.

P.S. Select statement looks cryptic, because it is generated by one tool (NHibernate, in particular).

Thanks in advance.

mirtheil · #2 (**permalink**) 03-03-08, 16:31

Pervasive does support parameters in queries but the syntax is different. For example:
SELECT * FROM CLASS WHERE ID = ?
It seems that NHibernate is generating a query that isn't supported by PSQL. You'll probably need to create your own dialect for NHibernate. A quick search shows that PSQL isn't supported natively.

genius2003 · #3 (**permalink**) 03-03-08, 18:44

Thank you.

Internet Services

Web Development

Digital Marketing

Consumer Tech