Solved

DB Connection problem in java

Posted on 2009-07-07
4
162 Views
Last Modified: 2013-11-23
Hi ,

i am using below code when i run java envi its says ORA-00911: invalid character
that same query is runing and insert the values in back end !!
can u tell me the problem
String url = "jdbc:oracle:thin:@localhost:1521";
		  try {
				try {
				 Class.forName("oracle.jdbc.driver.OracleDriver");
					// System.out.println("Failed to load isqlPlus driver.");
					//DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
				}
 
				catch (Exception ae) {
					ae.printStackTrace();
				}
 
				try {
 
					String url1 = System.getProperty("JDBC_URL");
					if (url1 != null)
						url = url1;
					Connection con = DriverManager.getConnection(url,
							"system", "tspl");
					PreparedStatement psmnt=null;
					String query="insert into gen_info(EMP_NAME,EMP_ID,TECH) "+ "values(?,?,?);";
					//Statement st=con.createStatement();
					
					psmnt = con.prepareStatement(query);
					psmnt.setString(1,"Sathish");
					psmnt.setString(2,"E11007");
					psmnt.setString(3,"Java");
					
				boolean s = psmnt.execute();
					if (s)
					{
						System.out.println("Succesfully inserted");
					}
					else 
					{
						System.out.println("Cant Insert");
					}
						//st.execute(query);
					con.close();
				} catch (Exception e) {
					e.printStackTrace();
				}
			} catch (Exception e) {
				e.printStackTrace();
			}

Open in new window

0
Comment
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 92

Expert Comment

by:objects
ID: 24792896
try getting rid of the ;
0
 
LVL 20

Author Comment

by:Sathish David Kumar N
ID: 24792903
what i didnt get u ??
0
 
LVL 92

Accepted Solution

by:
objects earned 500 total points
ID: 24792911
the ; at the end of your sql
0
 
LVL 15

Expert Comment

by:fsze88
ID: 24792944
in line 21 , will it cause by missed space in sql statement?
String query="insert into gen_info (EMP_NAME, EMP_ID, TECH) "+ " values(?,?,?) ";
also, you can try System.out.println(query) to see is there any invalid characters ?
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Viewers learn how to read error messages and identify possible mistakes that could cause hours of frustration. Coding is as much about debugging your code as it is about writing it. Define Error Message: Line Numbers: Type of Error: Break Down…
This video teaches viewers about errors in exception handling.

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question