File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes can anyone solve this Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "can anyone solve this" Watch "can anyone solve this" New topic

can anyone solve this

jyotsana dang
Ranch Hand

Joined: Sep 26, 2003
Posts: 135
what is the solution for the following problem..
created a form with textfields as title_of_project, names_of_students and supervisors.
whenever i try adding in any values to the title box..
the tomcat window shows an error.
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]The name '
mechanical' is not permitted in this context. Only constants, expressions, or va
riables allowed here. Column names are not permitted.
Ernest Friedman-Hill
author and iconoclast

Joined: Jul 08, 2003
Posts: 24199

Well, looks like you're sending a bad SQL query. I don't think we can help figure out your problem without seeing your database code.
[ December 19, 2003: Message edited by: Ernest Friedman-Hill ]

[Jess in Action][AskingGoodQuestions]
Varun Khanna
Ranch Hand

Joined: May 30, 2002
Posts: 1400
Your SQL query is probably not correct.
You must have entered "mechanical" value for any of the text field title_of_project or names_of_students or supervisors and while making a database operation it is not going in quotes probably !!! try to print your query and operate it using any dB client.
[ December 19, 2003: Message edited by: Varun Khanna ]

- Varun
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63868

Moving to the JDBC forum awaiting the SQL code for analysis.

[Asking smart questions] [About Bear] [Books by Bear]
jyotsana dang
Ranch Hand

Joined: Sep 26, 2003
Posts: 135
following is the code i wrote for inserting values into the database:
<%@ page language="java" import="java.sql.*,*" %>
Connection con=null;
java.sql.Statement stmt=null;
String level="";
String project_title="";
String student_names="";
String co_supervisor="";
int year=0;
String xy=(String)session.getAttribute("y");



System.out.println("the value of level is:"+level);
System.out.println("the value of project_title is:"+project_title);
System.out.println("the value of student_names is:"+student_names);
System.out.println("the value of co_supervisor is:"+co_supervisor);
System.out.println("the value of year is:"+year);

con=DriverManager.getConnection("jdbc dbc:mech_iit");
out.println("insert into project_supervised(user_login,level,project_title,student_names,co_supervisor,year) values('"+xy+"','"+level+"','"+project_title+"',"+student_names+",'"+co_supervisor+"',"+year+")");

int i=stmt.executeUpdate("insert into projects_supervised(user_login,level,project_title,student_names,co_supervisor,year) values('"+xy+"','"+level+"',"+project_title+",'"+student_names+"',"+co_supervisor+","+year+")");
System.out.println("the value of:" +i);
System.out.println("the value of:" +i);

catch(Exception e)



can anyone tell me where does the problem lie
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33130

You are missing the single quote before the student_names variable. You may want to consider using prepared statements to avoid this problem. Then you don't have to deal with the quotes.
[ December 20, 2003: Message edited by: Jeanne Boyarsky ]

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: can anyone solve this
It's not a secret anymore!