for Query in DB2 via jdbc not working

Question

I have a query in Maximo which when run via DB visualizer runs fine. but the same query when I run in java via jdbc it throws sql exception. The query is a bit different than usual and is shown below.

It gives the next sequence number for the next entry.

select nextval for mytabledseq from sysibm.sysdummy1

Remove the line of code that says `throw new SQLException();`. — shmosel, Feb 23 '16 at 05:44

score 0 · Answer 1 · answered Feb 23 '16 at 18:53

0

I have found the issue. I had to add the schema name before mytableseq. e.g. MAXIMO.mytableseq now it works fine

answered Feb 23 '16 at 18:53

AhmedRana

486
9
22

for Query in DB2 via jdbc not working

1 Answers1