Solved

DB Connection problem in java

Posted on 2009-07-07
4
161 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

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

Suggested Solutions

After being asked a question last year, I went into one of my moods where I did some research and code just for the fun and learning of it all.  Subsequently, from this journey, I put together this article on "Range Searching Using Visual Basic.NET …
Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
The viewer will learn how to implement Singleton Design Pattern in Java.
Suggested Courses

738 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