Bear Bibeault: It's really a jdbc/sql question (and
you should probably fit to the naming conventions here ... har, har, har).
Note: You may not learn sql entirely from asking in a forum.
Get a tutorial, a book, a teacher.
And:
shouting! don't catch Exceptions with silent ignore!
Don't!
Who silently catches Exceptions will be silently get cought by Exceptions.
And a minor question: From how many examples did you patchwork the code?
I would say: 5
And a last question:
Where did you find that 'ParanoidGetUntilItWorksButOnlyOnce_SmellPattern':
I would suggest: Get rid of it!
The best termin for that is: Today.