java.sql.SQLException: ORA-01858: a non-numeric character was found where a numeric was expected

hi,
I executed such jsp as follows,but it throws error in this sentence:int i = stmt.executeUpdate(sql1);
the details of the error:
java.sql.SQLException: ORA-01858: a non-numeric character was found where a numeric was expected

please give me help! Thanks!

<body>
<%
	String codeStr = request.getParameter("src_code");
	String src_type = request.getParameter("src_type");
	String src_name = request.getParameter("src_name");
	String db_ver = request.getParameter("db_ver");
	String creator = request.getParameter("creator");
	String create_date = request.getParameter("create_date");
	try {
		Long.parseLong(codeStr);
		src_type = new String(src_type.getBytes("ISO-8859-1"));
		src_name = new String(src_name.getBytes("ISO-8859-1"));
		db_ver = new String(db_ver.getBytes("ISO-8859-1"));
		creator = new String(creator.getBytes("ISO-8859-1"));
		create_date = new String(create_date.getBytes("ISO-8859-1"));
	} catch (Exception e) {
		response.sendRedirect("updateTest1.jsp");
	}
	String sql1 = "update extract.tb_data_source set src_type='"
			+ src_type + "',src_name='" + src_name + "',db_ver='"
			+ db_ver + "',creator='" + creator + "',create_date='"
			+ create_date + "'" + " where src_code=" + codeStr ;
	String sql2 = "select * from extract.tb_data_source";

Class.forName("oracle.jdbc.driver.OracleDriver");
	Connection conn = DriverManager.getConnection(
			"jdbc:oracle:thin:@172.28.82.30:1521:orcl", "123",
			"123");
	Statement stmt = conn.createStatement();
	int i = stmt.executeUpdate(sql1);

ResultSet rs = stmt.executeQuery(sql2);
%>
<table>
	<tr>
		<td colspan="7" align="center">更新后的数据源表中的数据</td>
	</tr>
	<tr>
		<td>数据源编号</td>
		<td>数据源类型</td>
		<td>数据源名称</td>
		<td>数据库类型</td>
		<td>创建者</td>
		<td>创建时间</td>
		<td>更新？</td>
	</tr>
	<%
		while (rs.next()) {
	%>
	<tr>
		<td><%=rs.getString("src_code")%></td>
		<td><%=rs.getString("src_type")%></td>
		<td><%=rs.getString("src_name")%></td>
		<td><%=rs.getString("db_ver")%></td>
		<td><%=rs.getString("creator")%></td>
		<td><%=rs.getString("create_date")%></td>
	</tr>
	<%
		}
	%>
</table>
</body>

Hi wu daly,
Welcome to JavaRanch

You must be having numeric fields in the table but you are using all String variables to pass data in the update statement ?
And please use code tags when posting code, unformatted code is difficult to read.

And you should avoid using JDBC code in JSPs. Move them to Java class(es).

thanks,Vijitha Kumara.
According to the error provided by tomcat server,executeQuery() returns a int value,but now it returns a String value.I've checked this jsp for times,but i still cannot find where the mistake is.
by the way ,how to use code tags when posting code?i come to this forum for the first time.

wu daly wrote:how to use code tags when posting code?i come to this forum for the first time.

when you post your query ,just check for the "Code" button on top of the text Area(where you are typing the letters)

to seetharaman venkatasamy: i got it,thank you!

wu daly wrote:According to the error provided by tomcat server,executeQuery() returns a int value,but now it returns a String value.

No I mean in your update SQL statement, check with the table (extract.tb_data_source) whether you have any numeric fields in there or post the datatypes used for the fields of that table. BTW executeUpdate returns an int.

Please help！Thanks！

And now you are seems to having a different error in the JSP. Were you able to resolve the previous error ? What changes you did to the page ? We should see the source then.

The main body of the jsp is on top of the page.Just now,i ran it on server,it still failed.
i have copy the mistake given by tomcat server to the page.
Please help me solve the problem.Thank you very much.

your are using only one stmt for both DDL and DML queries

when i define two Statement,it seems there is the same exception.

wu daly wrote:The main body of the jsp is on top of the page.Just now,i ran it on server,it still failed.
i have copy the mistake given by tomcat server to the page. Please help me solve the problem.Thank you very much.

You have few problems in the page. You are not handling the checked exceptions of JDBC code. You need try catch blocks around that code. I suggest you go through JDBC Tutorial to get those correct.

Thanks!

Ever heard of SQL injection attacks? If not, please read up on it, or your data will be destroyed. If so, I can't fathom why you're building the query like this.