Hello,
I am facing problem with a query in postgresql having following condition
in where clause
bullyear=(acadyear-year+1)
where acadyear, bullyear and year are columns of table. The existing
sqlgrammar.jj file has a problem parsing the 'year' token occurence after the
'-' sign. It
Dhananjay Muli wrote:
Hello,
I am facing problem with a query in postgresql having following
condition in where clause
bullyear=(acadyear-year+1)
where acadyear, bullyear and year are columns of table. The existing
sqlgrammar.jj file has a problem parsing the 'year' token occurence
David Leader wrote:
Um, not quite sure what a Jira issue is - sounds as if it might be
something to do with middle-east politics :-) I'd be grateful if you
could handle it for me.
Well, luckily it has nothing to do with middle-east politics :) Jira is
the bug (and improvement) tracking
Run my sample program i receive the error: Invalid cursor state - no
current row.
If comment the line;
ResultSet rsOpzioni =
con.createStatement(ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_READ_ONLY).executeQuery(sql);
while (rsOpzioni.next()) {
Exact: I have put setAutoCommit(false) and all it works correctly!!! :-
Thanks
PS: an other question: but in AutoCommit true the every instruction sql
is executed in one isolated transaction. And therefore why it gave error
to me? In theory it would have to give it with AutoCommit false.