ojb-user  

Antwort: Re: Antwort: SQL Input from user

Mario Curcija
Mon, 28 Apr 2008 08:01:37 -0700

Hi Hans, 

You are right about that second one. It does not suit your needs. 

On the other hand, the first one was actually what you've needed. Please 
check it again: 

"Can I directly obtain a java.sql.Connection within OJB?"
http://db.apache.org/ojb/docu/guides/connection.html#Can+I+directly+obtain+a

After getting a connection you should be able to create statement, execute 
it and get a result set from it.

Further reading: http://java.sun.com/docs/books/tutorial/jdbc/TOC.html.

"Retrieving Values from Result Sets" 
http://java.sun.com/docs/books/tutorial/jdbc/basics/retrieving.html


Best regards,
Mario Curcija


Hans Novak <[EMAIL PROTECTED]> schrieb am 28.04.2008 16:24:07:

> Mario Curcija schrieb:
> > 4.22. Is it possible to perform my own sql-queries in OJB?
> > http://db.apache.org/ojb/docu/faq.html#performSQL
> > 
> Hi,
> 
> ok, that is a beginning ;)
> But in the doc is described
> 
>    Query q2 = QueryFactory.newQuery(Article.class, sql);
> 
> 
> how can i use this, if i dont know, what classes are needed for the 
> SQL string ?
> 
> Hans
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>