Dave Tolls wrote:Your method is structured like this:
Now, If an exception other than a SQLException is thrown then you will never know, because you have put a return in the finally clause. That exception will be lost entirely.
Move the return statement outside the finally block and then you'll see the exception that is happening, and that you are hiding at the moment.
thank you so much, now i got a NullPointerException in the same line however my query works as it should in SQLDeveloper as shown in attachments can you help me please?
Claude Moore wrote:And welcome to the ranch !
thanks