Re: Using QueryBySQL to retrieve sequence value

[Jakob Braeuchi]

hi antonio,

the queries provided by ojb require a class to be defined in the 
repository. you can use any class defined in the repository in the 
SQL-Query:

QueryBySQL q = QueryFactory.newQuery(AnyClass.class,"select 
mySequence.nextval from dual");
Iterator iter = broker.getReportQueryIteratorByQuery(q);

hth
jakob
Antonio Gallardo wrote:

Jakob Braeuchi dijo:

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
Hi Jakob:

Thanks for the answer. The problem here is I am just quering a "nextval()"
from a sequence.
I will try the ReportQuery as you sugested, but I will be very glad if you
confim me how is the best way to get the required value.
Best Regards,

Antonio Gallardo


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]