Registeration - Database connection

11:00

Servlet example from the Tomcat 4.1

http://csvictor.no-ip.org:8080/examples/servlets/index.html

16:00

I can do the registrations with correct responses now.

And i am working on connecting to the database, for nearly 4 hours.

I can find something interesting in the tutorial 10, week 10, mentioned that I need to download the jar from the Microsoft site, tree files named as, msbase.jar, mssqlserver.jar and msutil.jar, into the folder under Tomcat\common\lib

I am facing the 505 error

and i find the various site from the Google.

Apache Tomcat/4.0.4 - HTTP Status 500 - Internal Server Error

---

type Exception report

message Internal Server Error

description The server encountered an internal error (Internal Server Error) that prevented it from fulfilling this request.

exception

java.lang.NullPointerException
       at RegForm.inputRecord(RegForm.java:50)
       at RegForm.doGet(RegForm.java:105)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
       at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
       at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
       at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
       at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
       at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
       at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
       at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
       at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
       at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
       at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
       at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
       at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
       at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
       at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
       at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
       at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
       at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
       at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
       at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
       at java.lang.Thread.run(Thread.java:534)

---

http://www.experts-exchange.com/Web/Web_Languages/JSP/Q_20822723.html

18.00

I think the errors related to the function under the function

public static void inputRecord(String ...) throw Exception{}

27/03/05 02:50

exception @wn try catch or throw oh

AYA function [Oy

public void function() throws java.lang.Exception

Exception handling should be handle with care;

03:55

After certain correction, bug fixed and some successful output show

Your registration is successful.
Hope you enjoy our services.
Thank You.
Visit our web now.

Name: Victor Again
HKID: z123456(1)
User Name:
leungkac
Password: 123456
Email: victor@gmail.com
Tel Phone(Home): 65451234
Tel Phone(Mobile): 13213213
Address: Rm504A

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1: Incorrect syntax near 'Rm504A'.

04.25

ResultSet Object proof problem occurred.

So i decide to ignore/comment it.

Result: positive

04.35

Cathy suggest me use stmt.executeQuenry instead of stmt.execute OR stmt.executeUpdate

i choose executeUpdate instaed at the beginning as i found JSP example use it

use executeQuenry instead