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.
sorting your imports, you find something like that:
and a lot more...
And look at 'getArPane ()'. Which exception do you want to catch? 'Throwable'. Every exception. But which exception may occour? Nearly no one! Perhaps an OutOfMemoryException. And what will happen then? Tell me! And tell me, which other exception you want to catch! (edited for typo) [ April 03, 2004: Message edited by: Stefan Wagner ]
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com