I had a similiar problem when using a session bean and jdbc.
I fixed it by making sure that I was doing a "select as" --
maybe this will help with the custom finder?
SELECT MAX(PK_ID) as pk_id FROM PKTABLE.
Kevin Meldorf
Systems Analyst
WorldTravel BTI
400 Skokie Blvd
Northbrook, IL 60062
Phone
ECTED]
Objet : [JBoss-user] Problem with SQL MAX() function in jaws.xml finder
I cannot get the MAX() function to work within a finder.
Environment: NT 4.0, jBoss 2.1-beta with tomcat
Here's my jaws.xml file:
CustomerBean
findNewest
(key = (SELECT MAX(key) FROM Cu
I cannot get the MAX() function to work within a finder.
Environment: NT 4.0, jBoss 2.1-beta with tomcat
Here's my jaws.xml file:
CustomerBean
findNewest
(key = (SELECT MAX(key) FROM CustomerBean))
Here's the result:
[JAWS] java.sql.SQLException: Column not
