Just learning Oracle, there is a wrong question, hope to solve the following

I is the implementation of the paging query, SQL used in the StringBuffer statement select id splicing,area,proportion,price,suit,hourse,num from (select id,area,proportion,price,suit,floor,hourse,releaseDate,rownum as num from (select id,area,proportion,price,suit,floor,hourse,releaseDate from my_home where area =? order by releaseDate desc)) where num >? and num <=?
stmt.setString(1, area);
stmt.setInt(2, start);
stmt.setInt(3, end);
The first question is String the first two or three numbers, I debug execution to rs=stmt.executeQuery();
Newspaper ORA-01460: unimplemented or unreasonable conversion requested error,
The SQL statement I on Oracle implementation can query results

Started by Elsa at November 15, 2016 - 12:39 PM

Probably the version of the problem Oracle JDBC driver.

Posted by Vito at November 26, 2016 - 1:06 PM

I was going to cry, do not add the where area program to carry out, a condition, is wrong

Posted by Elsa at December 01, 2016 - 1:32 PM

Try for a long time without such as area query query result, but as long as a substitution of area=? The condition has been reported java.sql.SQLException: ORA-01460: unimplemented is or unreasonable conversion requested
So tangled

Posted by Elsa at December 08, 2016 - 2:17 PM

I am here
String area = new String(request.getParameter("area").getBytes("iso-8859-1"), "utf-8");
Change the code, when submitted to the method, can display Chinese true evil

Posted by Marcus at December 19, 2016 - 2:35 PM

But the implementation to rs=stmt.executeQuery (); this step off

Posted by Elsa at December 29, 2016 - 3:13 PM