typical scenario: Man I got Spring up in eclipse with every other framework loaded under the sun (no pun intended) and I just don't know where that .class file is? weeeeelllll you don't say. IBM to the rescue. http://alphaworks.ibm.com/tech/jarclassfinder/download Neat little utility. I know thars a millions of these but this is within eclipse. I tried software update and not workie. I just had to put the com.ibm.hursley.jarclassfinder_2.1.0.jar in my plugins directory and restart. Version: 3.4.2
Build id: M20090211-1700 _____ From: [email protected] [mailto:[email protected]] On Behalf Of srinivas dumpala Sent: Tuesday, June 23, 2009 1:04 PM To: [email protected] Cc: [email protected] Subject: [java programming] Re: Search like in oracle Try with this statement to execute % % strSQL = "select * from table where fullname like"+" '%"+?+"%' " ; Thanks srini On Tue, Jun 23, 2009 at 6:26 AM, JV fis <[email protected]> wrote: Hello everybody ! Please help me error i'm new in oracle In code java I write : PreparedStatement stmt = null; strSQL = "Select * from table where (FullName like '% ?%') "; stmt = Connection.prepareStatement(strSQL); stmt.setString(1,"stringtoSearch") but when Execute error java.sql.SQLException: Invalid column index at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:207) at oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedS tatement.java:5264) at oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement ..java:5256) if I replace '% ?%' with ? not error --~--~---------~--~----~------------~-------~--~----~ To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/javaprogrammingwithpassion?hl=en -~----------~----~----~----~------~----~------~--~---
