|
|
Re: EclipseLink Test suite and Ingres [message #381674 is a reply to message #381672] |
Wed, 01 October 2008 00:44 |
Usha Rajsekar Messages: 8 Registered: July 2009 |
Junior Member |
|
|
Thanks James. I think I got this working... But I hit another syntax issue
with reference to Ingres: "For Update NOWAIT" in "select" queries.
Ingres Syntax:
==============
* help sql select\g
Executing . . .
The syntax of a SELECT statement is:
subselect { UNION [ALL] (subselect) }
[ ORDER BY column [ASC|DESC] {, column [ASC|DESC] } ]
where a subselect has the syntax:
SELECT [ALL|DISTINCT] expression [AS column] {,expression [AS
column]}
FROM from_clause
[ WHERE search_condition]
[ GROUP BY column {, column} ]
[ HAVING search_condition ]
and a from_clause has either the syntax:
tablename [corr_name] {, tablename [corr_name] }
or the syntax:
tablename [corr_name] {[INNER | LEFT | RIGHT | FULL] JOIN
tablename [corr_name] ON search_condition}
Note: UNION [ALL] is not supported by Open SQL.
Examples:
select pno, sno from sp;
select x.pno, y.sno from p x, s y
where x.color='red';
select sum(qty), pno
from sp
where sno != 's1'
group by pno;
continue
*
Query recieved by the Ingres JDBC driver from Eclipselink:
===========================================================
Prep[7418]: 'SELECT ADDRESS_ID, CITY, COUNTRY, P_CODE, PROVINCE, STREET
FROM ADDRESS WHERE (ADDRESS_ID = ?) FOR UPDATE OF ADDRESS_ID NOWAIT'
DrvPrep[7420]: preparing statement 'SELECT ADDRESS_ID, CITY, COUNTRY,
P_CODE, PROVINCE, STREET FROM ADDRESS WHERE (ADDRESS_ID = ?) FOR UPDATE OF
ADDRESS_ID NOWAIT'
Msg[0]: begin message QUERY
Msg[0]: sending message QUERY length 151 EOD EOG
Msg[0]: check TL data
Msg[0]: received message ERROR length 122 EOD
DrvPrep[7420]: Received error '42000' 0xa11 -- line 1, Syntax error on
'NOWAIT'.
Ingres-PreparedStatement[7418]: error preparing statement
Exception: 42000, 0xa11
Message: line 1, Syntax error on 'NOWAIT'.
Any pointers on eliminating "NOWAIT", and "FOR UPDATE OF" in "SELECT" for
Ingres is greatly appreciated.
Regards,
Usha
|
|
|
|
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.04408 seconds