Re: Using QueryBySQL to retrieve sequence value

[Jakob Braeuchi]

hi antonio,

your QueryBySql will look for a class Integer in the repository ! and it 
will fail. use a ReportQuery to obtain rows from the database.

hth
jakob
Antonio Gallardo wrote:

Hi:

I need to take a value from a sequence in PostgreSQL. The first idea is to
run something like:
QueryBySQL q = new QueryBySQL(Integer.class, "SELECT
nextval('mySequence');");
Integer seq = (Integer)broker.getObjectByQuery(q);
Is this correct?
Exists another approach to do this?
Best Regards,

Antonio Gallardo

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]