Database Project keeps throwing Exceptions.

[Loop]

Hi, I'm working on a Database project in NetBeans and I'm encountering several
problems with my application. I use Vectors in one class to store several
variables which is sent to my JTable in another form. I keep getting several
exceptions.

java.sql.SQLException Cannot find driver for jdbc:odbc
and also a lot of :
NullPointerExceptions

Please help, I'm really lost, please request if I need to post code.

[r035198x]

Post the first 5 lines of the exception stack traces. They will contain exact line numbers of where the problem was found in your code. They also give you hints on how to solve those problems.

[Loop]

Hey, I was able to fix the problem by redesigning my DatabaseAccess class and at least I'm able to connect with my Database and extract some data now. Only, not all of the things I do actually work.

Can't seem to be able to a specific something, namely to display all the players that won their games.
SQL code I used

String sql = "SELECT ID, Name, Surname, AmountWins, Win/Lose/Draw From TBTournament WHERE Win/Lose/Draw LIKE '0'";

[r035198x]

I doubt if there is any database that will accept the SQL statement you posted above. It may be better to go through the tutorial that came with your DB installation to learn the syntax.

[Loop]

Hey, I finally fixed the problem, not only that, when I was able to fix the problem above, I implemented the same idea towards some other sql statements that also moaned. Now everything's working fine! Thanks, I have to admit, after getting the 'too few parameters 1 Expected' exception at least a 100 times, I began to blame it on NetBeans etc... Turns out it was my own human error in my SQL code specifying a Column that did not exist, anyway thanks!