MySQL RSS MySQL RSS

stmt from db_connect tutorial isn't working

Reply

•
•
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

stmt from db_connect tutorial isn't working

 
0
  #1
Sep 16th, 2009
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:
MySQL 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:
MySQL 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.  



Note:
I was told to add table qualifiers to the where clause.
What does this mean. Maybe if someone could break down what the statement is saying (laymens terms) I could fix it.



Thanks again.
-ceyesuma
Reply With Quote Quick reply to this message  
•
•
Join Date: Sep 2009
Posts: 1
Reputation: ceyezumma is an unknown quantity at this point 
Solved Threads: 0
ceyezumma ceyezumma is offline Offline
Newbie Poster

Re: stmt from db_connect tutorial isn't working

 
0
  #2
Sep 17th, 2009
Topic
The topic of this question is: db_connect+my stmt
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

MySQL 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

MySQL 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:
my new stmt:

MySQL 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
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: stmt from db_connect tutorial isn't working

 
0
  #3
Sep 17th, 2009
logged.#23334
Reply With Quote Quick reply to this message  
Reply

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



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



agplv3 alfresco amazon api artisticlicense aws bizspark breathalyzer camparingtocolumns cmg communityjournalism contentmanagement contractors copyright count court crm database design developer development distinct drupal dui ec2 email enterprise eudora facebook form foss gartner gnu government gpl greenit groklaw hiring hyperic images innerjoins insert ip joebrockmeier join journalism keyword keywords kickfire law legal license licensing linux maintenance managing mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple music mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource oracle penelope php priceupdating query referencedesign reorderingcolumns resultset saas select sharepoint simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency virtualization
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC