Unfortunately, it is illegible because of incorrect indentation. Please post it again with correct indentation.
Bob Matthews wrote:the following code appears further down..................
Proper code style helps you find some types of bugs quickly. It also says to us "please put some effort into helping me, I'm at least willing to put the effort in to properly indent my code". Take pride in your code. I'm afraid to say your attempt at formatting was haphazard. If you don't want to format by hand then invest the time into learning an IDE, or, look at the rudimentary indenter written in Java in the link in my signature. This was run through an Eclipse formatter.
Bob Matthews wrote:apologies.......................
From this excerpt it's unclear if printSQLException is ever called - is it? Does it print information somewhere where you will see it?
Bob Matthews wrote:Line 10 coding was in error - requires string concatination
Bob Matthews wrote:I have just spent some time with Netbeans and reformmated my whole program
Tim Moores wrote: If it appears so then there may have been an exception that was swallowed by some catch statement that ignores it (needless to say, not a good catch statement).