943,724 Members | Top Members by Rank

Web Development > JSP > JSP database connectivity
Ad:
  • JSP Discussion Thread
  • Unsolved
  • Views: 2425
  • JSP RSS
You are currently viewing page 1 of this multi-page discussion thread
Permalink
Sep 9th, 2009
0

JSP database connectivity

Expand Post »
Hello.
I was studying the database connectivity tutorial .
I set it up with the database in MySQL.

However I tried to set it up using Netbeans6.7.1. just to see if I could get it to run. it's not working out.

Can this be setup in netbeans? I have attached the program.
at:
http://cid-b5cb457363230793.skydrive...olTutorial.zip
I also plan to try to recreate it step by step with netbeans if possible.

any feed back on what is wrong with the example setup with netbeans would be appreciated.
-ceyesumma
Similar Threads
Reputation Points: 7
Solved Threads: 2
Posting Pro
ceyesuma is offline Offline
524 posts
since Aug 2007
Permalink
Sep 9th, 2009
0

Re: JSP database connectivity

@ceyesuma : Can this be setup in netbeans?
-- YES or NO - It may be.

But I have a suggestion for you. Read & act this tutorial throughly - JDBC(TM) Database Access
Moderator
Reputation Points: 2136
Solved Threads: 1228
Posting Genius
adatapost is offline Offline
6,527 posts
since Oct 2008
Permalink
Sep 9th, 2009
-1

Re: JSP database connectivity

@ceyesuma: Your question is confusing, if you have problems to link MySQL with NetBeans have look at this tutorial else please provide better explanation
Moderator
Featured Poster
Reputation Points: 2786
Solved Threads: 871
Code tags enforcer
peter_budo is offline Offline
6,656 posts
since Dec 2004
Permalink
Sep 9th, 2009
0

Re: JSP database connectivity

Thanks
Those links will be helpful.
I have not started the tutorial supplied on the JSP page.

I have the database connection in netbeans and I need to learn how to access it.

I was just starting the tutorial and I set up the whole project in netbeans and the package was a little different . It all seemed to compile but I get the error that it will not deploy.

I was trying to quickly get the example to run in the netbeans.

I plan on tearing the tutorial apart to understand how it is using the MVC Model 2

I guess I will start by creating a java web app using JSF1.2. Will this be a good start?
Reputation Points: 7
Solved Threads: 2
Posting Pro
ceyesuma is offline Offline
524 posts
since Aug 2007
Permalink
Sep 9th, 2009
-1

Re: JSP database connectivity

Leave JSF till you get good understanding of JSP and servlets

When you getting errors please post them toether with any code they reference to...
Last edited by peter_budo; Sep 9th, 2009 at 11:27 am.
Moderator
Featured Poster
Reputation Points: 2786
Solved Threads: 871
Code tags enforcer
peter_budo is offline Offline
6,656 posts
since Dec 2004
Permalink
Sep 10th, 2009
0

Re: JSP database connectivity

As I am re-writing the jsp database connectivity tutorial I noticed there is a lot of good stuff in it.

it is setting up nice in netbeans so far.

I'll have to decide which code to use for the LoginServlet.
Thanks
Reputation Points: 7
Solved Threads: 2
Posting Pro
ceyesuma is offline Offline
524 posts
since Aug 2007
Permalink
Sep 16th, 2009
0

Re: JSP database connectivity

Topic
The topic of this question is: db_Connect does not connect.
Hello and Thank you in advance for any assistance.


System info:netbeans project,database attached or provided at:
http://cid-b5cb457363230793.skydrive...lic/school.zip



The purpose of this post is: Try to get a sql statement to work



The functionality of this code is:
JSP Syntax (Toggle Plain Text)
  1. ·  	"SELECT u.uid, firstName, lastName, address1, address2, city, postCode, email, phone, ug.groupName as userGroup "
  2. ·  	+"FROM user u, usergroup ug WHERE uid='"+userName+"' AND password='"+password+"' AND groupName IN"
  3. ·  	+" (SELECT groupName FROM usergroup WHERE groupid =(SELECT groupid FROM usergroup_mapping WHERE uid=u.uid))";



My question concerning this code is: What is wrong with the sql statement provided in tutorial. Or a description of its function .



The errors related to this code are:
JSP Syntax (Toggle Plain Text)
  1. Initializing Sun's JavaServer Faces implementation (1.2_04-b22-p05) for context '/school'
  2. Initialize <------------>jdbcDriver<------------>
  3. 12345678<------------>12345678
  4. SQLException:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'user u,usergroup ug WHERE uid='12345678' AND password='12345678' AND groupName I' at line 1
  5. Error on DB return
  6. java.lang.NullPointerException
  7.         at servlets.LoginServlet.doPost(LoginServlet.java:82)
  8.  



Code description:

JSP Syntax (Toggle Plain Text)
  1.  


Thanks again.
-ceyesuma


[u]

Note:

________________________________________________________________________

Code description:

JSP Syntax (Toggle Plain Text)
  1.  
Reputation Points: 7
Solved Threads: 2
Posting Pro
ceyesuma is offline Offline
524 posts
since Aug 2007
Permalink
Sep 16th, 2009
0

Re: JSP database connectivity

I think you are missing brackets in the sql statement, when using the in clause, somthing like this :
JSP Syntax (Toggle Plain Text)
  1. where groupId in (1,2,3)
Reputation Points: 36
Solved Threads: 57
Posting Whiz
Thirusha is offline Offline
355 posts
since Mar 2008
Permalink
Sep 16th, 2009
0

Re: JSP database connectivity

I was told to add table qualifiers to the WHERE statement.


The whole thing is confusing. I'm not sure what
"add table qualifiers to the where statement"

means exactly.

Is it possible for someone to breakdown what it says(laymens terms) so I can start understanding how to change it?
-ceyesumma
Reputation Points: 7
Solved Threads: 2
Posting Pro
ceyesuma is offline Offline
524 posts
since Aug 2007
Permalink
Sep 17th, 2009
0

Re: JSP database connectivity

Topic
The topic of this question is:
Hello and Thank you in advance for any assistance.


System info:

Noted in previous post.


The purpose of this post is:

Display supplied stmt from above mentioned tutorial. Stmt throws an error as noted in previous post.

Display my new stmt.


Code description:supplied stmt

JSP Syntax (Toggle Plain Text)
  1. "SELECT u.uid, firstName, lastName, address1, address2, city, postCode, email, phone, ug.groupName as userGroup "
  2. +"FROM user u, usergroup ug WHERE uid='"+userName+"' AND password='"+password+"' AND groupName IN"
  3. +" (SELECT groupName FROM usergroup WHERE groupid =(SELECT groupid FROM usergroup_mapping WHERE uid=u.uid)
  4.  

Code description: my new statement

JSP Syntax (Toggle Plain Text)
  1. String strQuery = "SELECT u.uid, u.password,ug.groupName FROM user AS u,usergroup AS ug,usergroup_mapping AS ugm WHERE u.uid='userName' AND u.password='password' AND u.uid=ugm.uid AND ugm.groupid=ug.groupid";



My question concerning this code is:

If my new stmt produces the required field when I run it on the databases. Why doesn’t the login except username=10101010 password =StealthProject which is in the data base?


The errors related to this code are:

JSP Syntax (Toggle Plain Text)
  1. Initializing Sun's JavaServer Faces implementation (1.2_04-b22-p05) for context '/school'
  2. Initialize <------------>jdbcDriver<------------>
  3. 10101010<------------>StealthProject
  4. Error on DB return
  5. java.lang.NullPointerException
  6.         at servlets.LoginServlet.doPost(LoginServlet.java:82)
  7.  



Thanks again.
-ceyesuma
Reputation Points: 7
Solved Threads: 2
Posting Pro
ceyesuma is offline Offline
524 posts
since Aug 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in JSP Forum Timeline: printed in server instead of client
Next Thread in JSP Forum Timeline: data retrieval trouble





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC