JSP RSS JSP RSS

JSP database connectivity

Reply
1 2

•
•
Join Date: Mar 2008
Posts: 315
Reputation: Thirusha is an unknown quantity at this point 
Solved Threads: 50
Thirusha's Avatar
Thirusha Thirusha is offline Offline
Posting Whiz

Re: JSP database connectivity

 
0
  #11
Sep 17th, 2009
cause u would need quotation marks. when comparing values from a table where the column is not of type numeric, u have to use quotation marks like this:
JSP Syntax (Toggle Plain Text) 
  1. username=10101010 and password = 'StealthProject'

if username is an alphanumeric column type then that too will need quotation marks as well.

I suggest googling some basic select statements to see how to write sql statements.
Life... Is a Moment
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2007
Posts: 238
Reputation: ceyesuma is an unknown quantity at this point 
Solved Threads: 0
ceyesuma ceyesuma is offline Offline
Posting Whiz in Training

Re: JSP database connectivity

 
0
  #12
Sep 18th, 2009
Topic
The topic of this question is: jsp database connectivity ServletWrapper
Hello and Thank you in advance for any assistance.

System info:

Netbeans6.7.1,jsf1.2,MySQL(Web app).Model view Controller(MVC )Model 2.

The purpose of this post is:

As it turns out the supplied stmt is good after all but something is wrong with how the servlet is being handled I think . So I need to understand the error produced after logging in to database and all param’s are good(See note to see System.out.println code life cycle.

The functionality of this code is:

tutorial description found at:
http://www.daniweb.com/forums/thread141776.html
My netbeans project school can be found at:
http://cid-b5cb457363230793.skydrive...lic/school.zip

My question concerning this code is:

1.What is the purpose of the “+” in the sql stmt. Is this basic SQL? Or is it for the Java?
2.Could someone describe what I should be looking at concerning fixing the error?

The errors related to this code are:


Error description: http browser page:Error

JSP Syntax (Toggle Plain Text) 
  1. HTTP Status 500 -
  2.  
  3. type Exception report
  4.  
  5. message
  6.  
  7. descriptionThe server encountered an internal error () that prevented it from fulfilling this request.
  8.  
  9. exception
  10.  
  11. java.lang.UnsupportedOperationException: Not yet implemented
  12.  
  13. note The full stack traces of the exception and its root causes are available in the Sun GlassFish Enterprise Server v2.1 logs.
  14. Sun GlassFish Enterprise Server v2.1

Note: Please find code below of program life cycle and where it blew out.



Error description: System.out.println code life cycle. And where it died!

JSP Syntax (Toggle Plain Text) 
  1. Initializing Sun's JavaServer Faces implementation (1.2_04-b22-p05) for context '/school'
  2. LoginServlet Init()<------------>Class.forName(config.getInitParameter('jdbcDriver')).toString<------------>Initialized the connector String
  3. LoginServlet Init()<------------>created a new UserBean object<------------>
  4. UserBean()<------------>in userbean constructor<------------>constructor
  5. %in getUserData()-------------->10101010<--------------userName%
  6. %in getUserData()-------------->StealthProject<--------------passwored %
  7. UserBean()<------------>in userbean constructor<------------>constructor
  8. connected to db--------->%com.mysql.jdbc.JDBC4Connection@1138a28%<----------------connection
  9. UserBean getUserData()-------------->%SELECT u.uid, firstName, lastName, address1, address2, city, postCode, email,phone, ug.groupName as userGroup FROM user u, usergroup ug WHERE uid='10101010' AND password='StealthProject' AND groupName IN (SELECT groupName FROM usergroup WHERE groupid =(SELECT groupid FROM usergroup_mapping WHERE uid=u.uid))%<--------------my new strQuery (I created
  10. %-------------->com.mysql.jdbc.StatementImpl@1d36fa0<--------------stmt%
  11. %-------------->com.mysql.jdbc.JDBC4ResultSet@1506a1e<--------------rs%
  12. UserBean()<------------>10101010<------------>uid from setter
  13. UserBean()<------------>Patrick<------------>FirstName from setter
  14. UserBean()<------------>Naughton<------------> Last Name from setter
  15. UserBean()<------------>Cromwell Road<------------>Address1 from setter
  16. UserBean()<------------>null<------------>address2 from setter
  17. UserBean()<------------>London<------------>City from setter
  18. UserBean()<------------>C19 90J<------------>post Code from setter
  19. UserBean()<------------>p.naughton@dwtutorial.com<------------>Email from setter
  20. UserBean()<------------>19770814<------------>Phone from setter
  21. UserBean()<------------>admin<------------> UserGroup from setter
  22. dataManager.getUserData()-------------->%10101010%<--------------getParameter(userName)
  23. dataManager.getUserData()-------------->%StealthProject%<--------------getParameter(passsword)
  24. doPost()-------------->%true%<--------------dbOk
  25. StandardWrapperValve[LoginServlet]: PWC1406: Servlet.service() for servlet LoginServlet threw exception
  26. java.lang.UnsupportedOperationException: Not yet implemented
  27.         at model.DataManager.getUsersList(DataManager.java:123)
  28.         at servlets.LoginServlet.doPost(LoginServlet.java:129)
  29.  

Thanks again.
-ceyesuma
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2004
Posts: 4,189
Reputation: peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of 
Solved Threads: 483
Moderator
Featured Poster
peter_budo's Avatar
peter_budo peter_budo is offline Offline
Code tags enforcer

Re: JSP database connectivity

 
0
  #13
Sep 18th, 2009
The plus in query uid='"+userName+"' is part of Java as you are building SQL query from simple string. The value provided between single and double quotes and plus is a value that you either retrieved from user or received by previous computation. Consider it as small plus point on the list why to use PreparedStatement instead of basic query

As for second problem I have no idea as you neither provided log file as suggested to look into by error message, neither you provided relevant code with pointing which section is working and where you getting error
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2007
Posts: 238
Reputation: ceyesuma is an unknown quantity at this point 
Solved Threads: 0
ceyesuma ceyesuma is offline Offline
Posting Whiz in Training

Re: JSP database connectivity

 
0
  #14
Sep 18th, 2009
Topic
The topic of this question is: reply_servlet_wrapper
Hello and Thank you in advance for any assistance.

The purpose of this post is:

Thanks peter_budo for the reply and the tutorial I might add.

I an not farmiliar with the log you mentioned. I did trace program output where it shows the program makes it to the doPost() of the LoginServlet.java.
Program at school.zip:
http://cid-b5cb457363230793.skydrive...lic/school.zip

The errors related to this code are:



Error description:trace program progress and error (Note: doPost() dbOK=true)

JSP Syntax (Toggle Plain Text) 
  1. Initializing Sun's JavaServer Faces implementation (1.2_04-b22-p05) for context '/school'
  2. LoginServlet Init()<------------>Class.forName(config.getInitParameter('jdbcDriver')).toString<------------>Initialized the connector String
  3. LoginServlet Init()<------------>created a new UserBean object<------------>
  4. UserBean()<------------>in userbean constructor<------------>constructor
  5. %in getUserData()-------------->10101010<--------------userName%
  6. %in getUserData()-------------->StealthProject<--------------passwored %
  7. UserBean()<------------>in userbean constructor<------------>constructor
  8. connected to db--------->%com.mysql.jdbc.JDBC4Connection@1401ab6%<----------------connection
  9. UserBean getUserData()-------------->%SELECT u.uid, firstName, lastName, address1, address2, city, postCode, email,phone, ug.groupName as userGroup FROM user u, usergroup ug WHERE uid='10101010' AND password='StealthProject' AND groupName IN (SELECT groupName FROM usergroup WHERE groupid =(SELECT groupid FROM usergroup_mapping WHERE uid=u.uid))%<--------------my new strQuery (I created
  10. %-------------->com.mysql.jdbc.StatementImpl@199c538<--------------stmt%
  11. %-------------->com.mysql.jdbc.JDBC4ResultSet@14b1500<--------------rs%
  12. UserBean()<------------>10101010<------------>uid from setter
  13. UserBean()<------------>Patrick<------------>FirstName from setter
  14. UserBean()<------------>Naughton<------------> Last Name from setter
  15. UserBean()<------------>Cromwell Road<------------>Address1 from setter
  16. UserBean()<------------>null<------------>address2 from setter
  17. UserBean()<------------>London<------------>City from setter
  18. UserBean()<------------>C19 90J<------------>post Code from setter
  19. UserBean()<------------>p.naughton@dwtutorial.com<------------>Email from setter
  20. UserBean()<------------>19770814<------------>Phone from setter
  21. UserBean()<------------>admin<------------> UserGroup from setter
  22. dataManager.getUserData()-------------->%10101010%<--------------getParameter(userName)
  23. dataManager.getUserData()-------------->%StealthProject%<--------------getParameter(passsword)
  24. doPost()-------------->%true%<--------------dbOk
  25. StandardWrapperValve[LoginServlet]: PWC1406: Servlet.service() for servlet LoginServlet threw exception
  26. java.lang.UnsupportedOperationException: Not yet implemented
  27.         at model.DataManager.getUsersList(DataManager.java:123)
  28.         at servlets.LoginServlet.doPost(LoginServlet.java:129)
  29.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
  30.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
  31.         at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:427)
  32.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:315)
  33.         at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:287)
  34.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:218)
  35.         at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648)
  36.         at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593)
  37.         at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94)
  38.         at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:98)
  39.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:222)
  40.         at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648)
  41.         at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593)
  42.         at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:587)
  43.         at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1096)
  44.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:166)
  45.         at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648)
  46.         at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593)
  47.         at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:587)
  48.         at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1096)
  49.         at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:288)
  50.         at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:647)
  51.         at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:579)
  52.         at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:831)
  53.         at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:341)
  54.         at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263)
  55.         at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214)
  56.         at com.sun.enterprise.web.portunif.PortUnificationPipeline$PUTask.doTask(PortUnificationPipeline.java:380)
  57.         at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265)
  58.         at com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:106)
  59.  

Code description:LoginServlet.java (Note doPost() dbOk=true)

JSP Syntax (Toggle Plain Text) 
  1. package servlets;
  2. import java.io.IOException;
  3. import java.sql.SQLException;
  4. import java.util.ArrayList;
  5. import java.util.logging.Level;
  6. import java.util.logging.Logger;
  7. import javax.servlet.RequestDispatcher;
  8. import javax.servlet.ServletConfig;
  9. import javax.servlet.ServletException;
  10. import javax.servlet.http.HttpServletRequest;
  11. import javax.servlet.http.HttpServletResponse;
  12. import javax.servlet.http.HttpSession;
  13. import javax.servlet.http.HttpServlet;
  14.  
  15. import beans.UserBean;
  16. import model.DataManager;
  17. import model.Validation;
  18.  
  19.  
  20. public class LoginServlet extends HttpServlet
  21. {
  22.  
  23. 	private String dbResult = null;
  24. 	private String myException = null;
  25. 	private String strError = null;
  26. 	private boolean dbOK = false;
  27.  
  28. 	// Connection string data
  29. 	private String dbURL;
  30. 	private String dbusername;
  31. 	private String dbpassword;
  32.  
  33. 	//Instance of beans
  34. 	private UserBean userBean;
  35. 	private ArrayList<UserBean> students;
  36. 	private ArrayList<UserBean> teachers;
  37. 	private DataManager dataManager;
  38. 	private Validation val = new Validation();
  39.  
  40.         public void LoginServlet(){
  41.             System.out.println("in loginServlet");
  42.         }
  43. 	public void init(ServletConfig config) throws ServletException
  44. 	{
  45. 		super.init(config);
  46.  
  47. 		dataManager = new DataManager();
  48. 	    dataManager.setDbURL(config.getInitParameter("dbURL"));
  49. 	    dataManager.setDbUserName(config.getInitParameter("dbUserName"));
  50. 	    dataManager.setDbPassword(config.getInitParameter("dbPassword"));
  51. 		try
  52. 		{
  53. 			Class.forName(config.getInitParameter("jdbcDriver"));
  54.                         System.out.println("LoginServlet Init()<------------>Class.forName(config.getInitParameter('jdbcDriver')).toString<------------>Initialized the connector String");
  55. 		}
  56. 		catch (Exception ex)
  57. 		{
  58. 			System.out.println("Initialize connector string");
  59. 			ex.printStackTrace();
  60. 		}
  61. 	}
  62.  
  63. 	public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
  64. 	{
  65. 		/*
  66. 		 * Get user data from submited form
  67. 		 */
  68. 		String userName = request.getParameter("userName");
  69. 		String password = request.getParameter("password");
  70.  
  71. 		if(val.validate(userName, password))
  72. 		{
  73.                     System.out.println("LoginServlet Init()<------------>created a new UserBean object<------------>");
  74. 			userBean = new UserBean();
  75.             try {
  76.                 userBean = dataManager.getUserData(userName, password);
  77.                 System.out.println("dataManager.getUserData()-------------->%"+userName+"%<--------------getParameter(userName)");
  78.                     System.out.println("dataManager.getUserData()-------------->%"+password+"%<--------------getParameter(passsword)");
  79.             } catch (SQLException ex) {
  80.                 Logger.getLogger(LoginServlet.class.getName()).log(Level.SEVERE, null, ex);
  81.             }
  82.  
  83. 			try
  84. 			{
  85. 				if(!userBean.getUid().equals(null))
  86. 					dbOK = true;
  87.                                 System.out.println("doPost()-------------->%"+dbOK+"%<--------------dbOk");
  88.  
  89. 			}
  90. 			catch(NullPointerException npe)
  91. 			{
  92.                             System.out.println("doPost()-------------->%%<--------------blows up here");
  93.  
  94. 				System.out.println("Error on DB return");
  95. 				npe.printStackTrace();
  96. 				strError = "Invalid username or password.";
  97. 				dbOK = false;
  98. 			}
  99.  
  100. 		}
  101. 		else
  102. 		{
  103. 			strError = "Invalid username or password.";
  104. 			dbOK = false;
  105. 		}
  106.  
  107. 		HttpSession session = request.getSession(true);
  108.  
  109. 		if(dbOK)
  110. 		{
  111. 			//redirect to student/teacher/admin pages
  112. 			if(userBean.getUserGroup().equals("student"))
  113. 			{
  114. 				session.setAttribute( "userBean", userBean);
  115. 				RequestDispatcher dispatcher = request.getRequestDispatcher("/student.jsp");
  116. 				dispatcher.forward( request, response);
  117. 			}
  118. 			else if(userBean.getUserGroup().equals("teacher"))
  119. 			{
  120. 				session.setAttribute( "userBean", userBean);
  121. 				students = new ArrayList<UserBean>(dataManager.getUsersList("student"));
  122. 				session.setAttribute("students", students);
  123. 				RequestDispatcher dispatcher = request.getRequestDispatcher("/teacher.jsp");
  124. 				dispatcher.forward( request, response);
  125. 			}
  126. 			else if(userBean.getUserGroup().equals("admin"))
  127. 			{
  128. 				session.setAttribute( "userBean", userBean);
  129. 				students = new ArrayList<UserBean>(dataManager.getUsersList("student"));
  130. 				session.setAttribute("students", students);
  131. 				teachers = new ArrayList<UserBean>(dataManager.getUsersList("teacher"));
  132. 				session.setAttribute("teachers", teachers);
  133. 				RequestDispatcher dispatcher = request.getRequestDispatcher("/admin.jsp");
  134. 				dispatcher.forward( request, response);
  135. 			}
  136. 		}
  137. 		else
  138. 		{
  139. 			//Error after DB login checkout, redirect back to index.jsp
  140. 			session.setAttribute( "error", strError);
  141. 			RequestDispatcher dispatcher = request.getRequestDispatcher("/index.jsp");
  142. 			dispatcher.forward( request, response);
  143. 		}
  144. 	}
  145. }



Thanks again.
-ceyesuma


Note:

I plan on re-write in order to try prepared stmt and tag library.
so this error may or may not repeat itself.
Last edited by ceyesuma; Sep 18th, 2009 at 11:24 am. Reason: additional note
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2007
Posts: 238
Reputation: ceyesuma is an unknown quantity at this point 
Solved Threads: 0
ceyesuma ceyesuma is offline Offline
Posting Whiz in Training

Re: JSP database connectivity

 
0
  #15
Sep 18th, 2009
Hello again.
I have re-written all the previous posted code using the preparedStatement().
good stuff.

Now, When I started I chose to use JSF1.2. I think my error at described above is because there are no navigation rules (go figure lol you think that is the cause for the error?)

So, my questionsare:
1. can I leave the web.xml along now? (that is where my connecting param's are)
2. can I create the navigation rules in the face-config.xml?
3.finally, Is it possible to rewrite the pages supplied using JSF JSP jsp pages?
Thanks again
ceyesuma
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2004
Posts: 4,189
Reputation: peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of 
Solved Threads: 483
Moderator
Featured Poster
peter_budo's Avatar
peter_budo peter_budo is offline Offline
Code tags enforcer

Re: JSP database connectivity

 
0
  #16
Sep 19th, 2009
You will always need web.xml for few things. If face-config.xml support navigation rules you may try to rewrite it, but unfortunately I cannot be of any assistance because I did not use JSF as yet.
If you succeed please post it on forum for others to see it.
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2007
Posts: 238
Reputation: ceyesuma is an unknown quantity at this point 
Solved Threads: 0
ceyesuma ceyesuma is offline Offline
Posting Whiz in Training

Re: JSP database connectivity

 
0
  #17
Sep 19th, 2009
Hello.
I worked all night on a couple other projects but I believe the Netbeans project is still at:
http://cid-b5cb457363230793.skydrive...lic/school.zip
I think that one is still not using preparedStatements though.

I will work on it soon. However if some one where to open it in netbeans I believe it would just be a matter of adding a dataManagerController.java that the jsf jsp page talks to and the controler talks to the model DataManager.java dataManager.isStudent()which has the method that would return the string "student","admin" etc to the
faces-conf.xml which has the case and navigation for the pages.



a good simple calulator example is at
http://www.ibm.com/developerworks/li...j-jsf1/#N100D3

I cant upload a worksheet.xls (excel) I have a summary of that tutorial named simpljsf.zip at:
http://cid-b5cb457363230793.skydrive.../simplejsf.zip


thanks
-ceyesumma
Reply With Quote Quick reply to this message  
Reply
1 2

Quick Reply to Thread
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the JSP Forum
Thread Tools Search this Thread



apache backbutton combobox connection database development directorystructure dynamicpagetitles eclipse frames glassfish ie8 imagetodatabse imageupload integer internet java javaee javascript jsf jsp jsppagetitles levels mvc2 mvcmodel2 network parameters passing ping printinserverinsteadofclient redirect request.getparameter response servlet servletdopost()readxml sessions software ssl state_saving_method stocks sun tomcat tutorial update video web
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC