Results 1 to 8 of 8

Thread: JPA + Oracle Connection Issue

  1. Sep 28th, 2010, 04:41 PM #1
    zamubal
    zamubal is offline Junior Member
    Join Date
    Sep 2010
    Posts
    4

    Default JPA + Oracle Connection Issue

    I am trying to run a web app using Spring and JPA with an Oracle database. Project files are attached except for the required libraries.

    Everything appears to be working correctly except for the database connection. When I try to access the URL http://localhost:8095/InquiryForms/eventform.html I get the error below. If I remove the ReferenceData and onSubmit methods from the InquiryFormController the form works correctly and submits. The database connection is properly set up and is working.

    Can anyone help?

    Code:
    java.lang.NullPointerException
	at inquiryforms.web.InquiryFormController.referenceData(InquiryFormController.java:30)
	at org.springframework.web.servlet.mvc.SimpleFormController.referenceData(SimpleFormController.java:214)
	at org.springframework.web.servlet.mvc.AbstractFormController.showForm(AbstractFormController.java:574)
	at org.springframework.web.servlet.mvc.SimpleFormController.showForm(SimpleFormController.java:198)
	at org.springframework.web.servlet.mvc.SimpleFormController.showForm(SimpleFormController.java:175)
	at org.springframework.web.servlet.mvc.AbstractFormController.showNewForm(AbstractFormController.java:338)
	at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:278)
	at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
	at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
	at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
	at java.lang.Thread.run(Thread.java:595)
    Attached Files Attached Files
    Last edited by zamubal; Sep 29th, 2010 at 09:53 AM. Reason: Adding [Code] tag to stacktrace
    Reply With Quote Reply With Quote
  2. Sep 29th, 2010, 01:06 AM #2
    Marten Deinum
    Marten Deinum is offline Senior Member
    Join Date
    Jun 2006
    Location
    The Netherlands
    Posts
    13,624

    Default

    Please use [ code][/code ] tags when posting code/xml/stracktraces.

    Why is this an oracle/jpa error. It is a configuration mistake on your behave... You nowhere in your configuration inject the 'inquiryFormService' into your controller, hence it is null...
    Marten Deinum
    Java Consultant / Pragmatist / Open Source Enthousiast / Author

    Pro Spring MVC: With Web Flow
    Conspect

    Have you read the reference guide.
    Use the [ code ] tags, young padawan
    Reply With Quote Reply With Quote
  3. Sep 29th, 2010, 09:41 AM #3
    zamubal
    zamubal is offline Junior Member
    Join Date
    Sep 2010
    Posts
    4

    Default

    Sorry about that I am a total newbie.

    I added
    Code:
    <property name="inquiryFormService" ref="inquiryFormService"/>
    to the inquiryforms-servlet.xml file in my controller bean declaration. I also added the following method to my InquiryFormController but I still get the same error.

    Code:
    public void setInquiryFormService (InquiryFormService inquiryFormService) {
		this.inquiryFormService = inquiryFormService;
	}
    Reply With Quote Reply With Quote
  4. Sep 29th, 2010, 09:48 AM #4
    Marten Deinum
    Marten Deinum is offline Senior Member
    Join Date
    Jun 2006
    Location
    The Netherlands
    Posts
    13,624

    Default

    You already had that method, so not sure why you added it again...

    Post the new stacktrace.... and please use [ code][/code ] tags this time.
    Marten Deinum
    Java Consultant / Pragmatist / Open Source Enthousiast / Author

    Pro Spring MVC: With Web Flow
    Conspect

    Have you read the reference guide.
    Use the [ code ] tags, young padawan
    Reply With Quote Reply With Quote
  5. Sep 29th, 2010, 09:52 AM #5
    zamubal
    zamubal is offline Junior Member
    Join Date
    Sep 2010
    Posts
    4

    Default

    Here is the stacktrace.

    Code:
    500 Internal Server Error

java.lang.NullPointerException
	at inquiryforms.web.InquiryFormController.referenceData(InquiryFormController.java:30)
	at org.springframework.web.servlet.mvc.SimpleFormController.referenceData(SimpleFormController.java:214)
	at org.springframework.web.servlet.mvc.AbstractFormController.showForm(AbstractFormController.java:574)
	at org.springframework.web.servlet.mvc.SimpleFormController.showForm(SimpleFormController.java:198)
	at org.springframework.web.servlet.mvc.SimpleFormController.showForm(SimpleFormController.java:175)
	at org.springframework.web.servlet.mvc.AbstractFormController.showNewForm(AbstractFormController.java:338)
	at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:278)
	at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
	at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
	at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
	at java.lang.Thread.run(Thread.java:595)
    Reply With Quote Reply With Quote
  6. Sep 29th, 2010, 10:01 AM #6
    Marten Deinum
    Marten Deinum is offline Senior Member
    Join Date
    Jun 2006
    Location
    The Netherlands
    Posts
    13,624

    Default

    Fix your code... You never initialize the logger...
    Marten Deinum
    Java Consultant / Pragmatist / Open Source Enthousiast / Author

    Pro Spring MVC: With Web Flow
    Conspect

    Have you read the reference guide.
    Use the [ code ] tags, young padawan
    Reply With Quote Reply With Quote
  7. Sep 29th, 2010, 10:49 AM #7
    zamubal
    zamubal is offline Junior Member
    Join Date
    Sep 2010
    Posts
    4

    Default

    Done. Same error but now I see the log output.

    Stacktrace:

    Code:
    500 Internal Server Error

java.lang.NullPointerException
	at inquiryforms.repository.InquiryFormDAO.getStateList(InquiryFormDAO.java:32)
	at inquiryforms.web.InquiryFormController.referenceData(InquiryFormController.java:33)
	at org.springframework.web.servlet.mvc.SimpleFormController.referenceData(SimpleFormController.java:214)
	at org.springframework.web.servlet.mvc.AbstractFormController.showForm(AbstractFormController.java:574)
	at org.springframework.web.servlet.mvc.SimpleFormController.showForm(SimpleFormController.java:198)
	at org.springframework.web.servlet.mvc.SimpleFormController.showForm(SimpleFormController.java:175)
	at org.springframework.web.servlet.mvc.AbstractFormController.showNewForm(AbstractFormController.java:338)
	at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:278)
	at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
	at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
	at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
	at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)
	at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)
	at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
	at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
	at java.lang.Thread.run(Thread.java:595)
    Reply With Quote Reply With Quote
  8. Sep 29th, 2010, 10:53 AM #8
    Marten Deinum
    Marten Deinum is offline Senior Member
    Join Date
    Jun 2006
    Location
    The Netherlands
    Posts
    13,624

    Default

    No it is NOT the same error...

    inital
    Code:
    java.lang.NullPointerException
	at inquiryforms.web.InquiryFormController.referenceData(InquiryFormController.java:30)
    now

    Code:
    java.lang.NullPointerException
	at inquiryforms.repository.InquiryFormDAO.getStateList(InquiryFormDAO.java:32)
	at inquiryforms.web.InquiryFormController.referenceData(InquiryFormController.java:33)
    Again I suggest checking your code, (I'm not going to do all your work for you !) and see if all the dependencies tget injected and make sure all the loggers get properly initialized.
    Last edited by Marten Deinum; Sep 29th, 2010 at 10:56 AM. Reason: Added code
    Marten Deinum
    Java Consultant / Pragmatist / Open Source Enthousiast / Author

    Pro Spring MVC: With Web Flow
    Conspect

    Have you read the reference guide.
    Use the [ code ] tags, young padawan
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules