NetBeans Forums
| View previous topic :: View next topic |
| Author |
Message |
humpy125
Joined: 18 Nov 2010
Posts: 4
Location: Hobart
|
 Posted: Thu Dec 23, 2010 5:18 am Post subject: JSF - Modifying the CRUD 1.2 application and Oracle DB |
 |
|
I have been working through the "Modifying JSP Pages in the Generated JSF 1.2 CRUD Application" tutorial and have struck a problem with the login page.
I have been trying to adapt this for the JSF 2.0 CRUD application that connects to an Oracle 11g database but when I try to login I get an invalid login message.
It seems to fall over when it calls the | Code: | | findConsultantEntities(boolean all, int maxResults, int firstResult, String query, Map<String, Object> parameters) |
in the ConsultantJpaController class. The problem occurs when it calls q.getResultList()
I think the problem is the query:
| Code: | | select object(o) from Consultant o where o.email = :email and o.password = :password |
Oracle does not seem to support the object(o) syntax.
This query does not run in sqldeveloper. does anyone know how it should be modified to run on Oracle? |
|
| Back to top |
|
 |
julsorio
Joined: 05 Jun 2009
Posts: 168
Location: Bogota, Colombia, South America
|
| Posted: Mon Dec 27, 2010 10:03 pm Post subject: Re: JSF - Modifying the CRUD 1.2 application and Oracle DB |
|
|
On 23 December 2010 00:18, humpy125 <address-removed> wrote:
| Quote: | I have been working through the "Modifying JSP Pages in the Generated JSF 1.2 CRUD Application" tutorial and have struck a problem with the login page.
I have been trying to adapt this for the JSF 2.0 CRUD application that connects to an Oracle 11g database but when I try to login I get an invalid login message.
It seems to fall over when it calls the
Code:
findConsultantEntities(boolean all, int maxResults, int firstResult, String query, Map<String, Object> parameters)
in the ConsultantJpaController class. The problem occurs when it calls q.getResultList()
I think the problem is the query:
Code:
select object(o) from Consultant o where o.email = :email and o.password = :password
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum
|
|
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
