View Single Post
Old 08-30-09, 04:29 PM   #3
Mahna Mahna
jcrox's Avatar
Join Date: Jul 2006
Location: Madison, Wi
Posts: 6,135
Default Re: JDBC / MS ACCESS Problem

I don't really use MS Access but with MySQL the first thing I usually do is open up SQL Browser, copy and paste the SQL statement into it and run it to make sure that I'm getting back the data that I'm expecting as well as check the column names to make sure that I haven't screwed anything up there.

If I don't find my error there I'll usually add the following to my catch statement: System.out.println(e.printStackTrace);
and figure out which column it is that is not being found and investigate from there.


MSI MPower Z87 | 4770k | CNPS9900MAX-B | 8GB G.Skill 1866 | EVGA GTX760 |ThermalTake 850w | X-Fi Titanium | HAF | Asus PA248Q | Lycosa | Death Adder | Win8 Pro 64


MSI GD65 | 2500k | H50 | 8GB G.skill | GTX570 | Ubuntu 13.10


17" Inspiron | i5 | 4GB DDR3 | 500GB HDD | Win7 Pro 64

jcrox is offline   Reply With Quote