I attach the standardjaws for any doubt; I saw it and I found this query
prepared by jaws:
SELECT SENDER,BODY_N,DATE_N,TITLE_N,ID_NEWS FROM NEWS WHERE ID_NEWS=?
I don't understand why JAWS add the costruct "WHERE" in prepared statement;
I thought that a findall finder 'd prepare a query like: SELECT * FROM NEWS;
maybe is it a no standard construct? Or is it an error?
any suggestion?
-----Messaggio originale-----
Da: Dovan Nguyen [mailto:[EMAIL PROTECTED]]
Inviato: Tuesday, May 22, 2001 10:24 PM
A: [EMAIL PROTECTED]
Oggetto: Re: [JBoss-user] problem with finder find all
hi Chris,
I did this and i still don't see the trace. could you please send us a
sample
of standardjaws.xml. i am interested in seeing what jaws is doing,
especially
what SQL statement (if possible) jaws is sending.
thanks
dovan
"DeGreef, Chris J. (AIT)" wrote:
> Turn the Debug flag on in the standardjaws.xml file. <debug>true</debug>
> Rerun the scenario and look into the server.log file. You will at least
see
> what JAWS was doing just before the error. I usually find that an
> unexpected NULL was involved at some point.
>
> -----Original Message-----
> From: Belli Andrea [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 22, 2001 12:44 PM
> To: Jboss-User (E-mail)
> Subject: [JBoss-user] problem with finder find all
>
> I have a jsp which call a session bean, which does a query on a db by an
> entity bean: the problem is when I try to view the rows on db.
> The jsp invoke the following method myfindAll():
>
> public NewsRemote[] myfindAll() throws RemoteException,FinderException
> {
> NewsHome home = (NewsHome) getHome("mail.News", NewsHome.class);
> Collection all = home.findAll();
> return (NewsRemote[]) all.toArray(new NewsRemote[0]);
> }
>
> The session bean (DbMail) invokes a method of the entity bean News,
> findAll(), which is made by the container, because News is CMP.
> During execution, I have this error:
>
> [mail.News] TRANSACTION ROLLBACK EXCEPTION:Load failed; nested exception
is:
> java.sql.SQLException: Unable to create PreparedStatement!; nested
> exception is:
> java.rmi.ServerException: Load failed; nested exception is:
> java.sql.SQLException: Unable to create PreparedStatement!
>
> have you any suggestion? Andrea
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
