get the List to oracle database in index values [closed]

by

Probably you need to study a bit more about Prepare Statement. You have problem with below code:

pstmt.setString(5, address);

While you query has just one wildcard (?) – you are trying to set string to the 5th one (which doesn’t exists). Change it to:

pstmt.setString(1, address);

More Related Contents:

  1. Does an Array’s specified capacity include 0?
  2. What is the point of the diamond operator () in Java?
  3. How to use Jackson to deserialise an array of objects
  4. @RequestBody and @ResponseBody annotations in Spring
  5. Java split() method strips empty strings at the end? [duplicate]
  6. How to change webservice url endpoint?
  7. Compile-time constants and variables
  8. Return a value from AsyncTask in Android [duplicate]
  9. How can we print line numbers to the log in java
  10. Does the sequence of the values matter in a JSON object?
  11. JDBC connection to MSSQL server in windows authentication mode
  12. How to convert a 1d array to 2d array?
  13. What is the “default” implementation of method defined in an Interface?
  14. boolean expression parser in java
  15. Why are strings immutable in many programming languages? [duplicate]
  16. What is the difference between cascade & inverse in hibernate, what are they used for?
  17. Java how to instantiate a class from string [duplicate]
  18. Best way to concatenate List of String objects? [duplicate]
  19. Preloading java classes/libraries at jar startup?
  20. Parsing nested JSON data using GSON
  21. Java – Loading dlls by a relative path and hide them inside a jar
  22. Calling Java from MATLAB?
  23. Why is comparing floats inconsistent in Java?
  24. How to create a X509 certificate using Java?
  25. Advanced PDF parser for Java
  26. How to get shutdown hook to execute on a process launched from Eclipse
  27. Simplest way to correctly load html from web page into a string in Java
  28. How to escape colon `:` within a native SQL query in Hibernate?
  29. Android java.lang.NoClassDefFoundError: org.jsoup.Jsoup
  30. Java generics and array initialization

Leave a Comment