Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › Application Programming › Java error message when linking to database.
New Posts  All Forums:Forum Nav:

Java error message when linking to database. - Page 2

post #11 of 34
3/8/11 at 8:15am
Thread Starter 
Yes it is... Maybe I created the database incorrectly :S hmmmmm
Dark Star
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6600 - Currently Overclocking ;) Gigabyte GA-EP45-UD3P HD 6950 OCZ Blade LC DDR2 PC29200 4GB (GOT) 
Hard DriveOSMonitorKeyboard
640GB for Storage and OCZ Vertex 2e 60GB Windows 7 Ultimate-Signature Edition 3 x 22" -BenQ G2222HDL Logitech G15 
PowerCaseMouse
Corsair TX850 HAF 932 Logitech G500 
View all
  hide details  
Reply
Dark Star
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6600 - Currently Overclocking ;) Gigabyte GA-EP45-UD3P HD 6950 OCZ Blade LC DDR2 PC29200 4GB (GOT) 
Hard DriveOSMonitorKeyboard
640GB for Storage and OCZ Vertex 2e 60GB Windows 7 Ultimate-Signature Edition 3 x 22" -BenQ G2222HDL Logitech G15 
PowerCaseMouse
Corsair TX850 HAF 932 Logitech G500 
View all
  hide details  
Reply
post #12 of 34
3/8/11 at 8:17am
Another stupid question, not meant to insult your intelligence at all but... the database is correctly named

Messages.mdb

?

Just trying to rule out something stupid, Plex said the code looks correct and as long as the working directory contains your class and the database, likely the problem is something stupid. However the fact that the direct path to the DB C:\\.... yielded the same results is odd to say the least.
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
I5 760 GA-H55N GTX 470 PNY Optima 8GB 
Hard DriveMonitorPowerCase
Spinpoint F4 LG227WTG sg07 PSU Sugo sg07 
Mouse
CM Sentinel 
View all
  hide details  
Reply
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
I5 760 GA-H55N GTX 470 PNY Optima 8GB 
Hard DriveMonitorPowerCase
Spinpoint F4 LG227WTG sg07 PSU Sugo sg07 
Mouse
CM Sentinel 
View all
  hide details  
Reply
post #13 of 34
3/8/11 at 8:23am
Thread Starter 
As far as I can tell it is. I wasn't sure whether I should actually name it "Messages.mdb" including the mdb. Because sometimes when I created the file Access would view it as "Messages.mdb.mdb" but I messed around with a few things... And nothing. I even changed the default settings of Access so it'd create a 2002-2003 file and not a 2007....
Dark Star
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6600 - Currently Overclocking ;) Gigabyte GA-EP45-UD3P HD 6950 OCZ Blade LC DDR2 PC29200 4GB (GOT) 
Hard DriveOSMonitorKeyboard
640GB for Storage and OCZ Vertex 2e 60GB Windows 7 Ultimate-Signature Edition 3 x 22" -BenQ G2222HDL Logitech G15 
PowerCaseMouse
Corsair TX850 HAF 932 Logitech G500 
View all
  hide details  
Reply
Dark Star
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6600 - Currently Overclocking ;) Gigabyte GA-EP45-UD3P HD 6950 OCZ Blade LC DDR2 PC29200 4GB (GOT) 
Hard DriveOSMonitorKeyboard
640GB for Storage and OCZ Vertex 2e 60GB Windows 7 Ultimate-Signature Edition 3 x 22" -BenQ G2222HDL Logitech G15 
PowerCaseMouse
Corsair TX850 HAF 932 Logitech G500 
View all
  hide details  
Reply
post #14 of 34
3/8/11 at 8:23am
Code:
String sourceURL = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=Messages.mdb;";


try removing the ; after mdb ^^

String sourceURL = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=Messages.mdb";
Edit: Yes you just name it Messages, the program you created it in (in this case access so .mdb) automatically appends the .mdb extension to the file.
Edited by mykah89 - 3/8/11 at 8:27am
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
I5 760 GA-H55N GTX 470 PNY Optima 8GB 
Hard DriveMonitorPowerCase
Spinpoint F4 LG227WTG sg07 PSU Sugo sg07 
Mouse
CM Sentinel 
View all
  hide details  
Reply
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
I5 760 GA-H55N GTX 470 PNY Optima 8GB 
Hard DriveMonitorPowerCase
Spinpoint F4 LG227WTG sg07 PSU Sugo sg07 
Mouse
CM Sentinel 
View all
  hide details  
Reply
post #15 of 34
3/8/11 at 8:39am
Thread Starter 
No luck :S BTW it also says "java.lang.NullPointerException" right after the message before... That mean anything??
Dark Star
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6600 - Currently Overclocking ;) Gigabyte GA-EP45-UD3P HD 6950 OCZ Blade LC DDR2 PC29200 4GB (GOT) 
Hard DriveOSMonitorKeyboard
640GB for Storage and OCZ Vertex 2e 60GB Windows 7 Ultimate-Signature Edition 3 x 22" -BenQ G2222HDL Logitech G15 
PowerCaseMouse
Corsair TX850 HAF 932 Logitech G500 
View all
  hide details  
Reply
Dark Star
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6600 - Currently Overclocking ;) Gigabyte GA-EP45-UD3P HD 6950 OCZ Blade LC DDR2 PC29200 4GB (GOT) 
Hard DriveOSMonitorKeyboard
640GB for Storage and OCZ Vertex 2e 60GB Windows 7 Ultimate-Signature Edition 3 x 22" -BenQ G2222HDL Logitech G15 
PowerCaseMouse
Corsair TX850 HAF 932 Logitech G500 
View all
  hide details  
Reply
post #16 of 34
3/8/11 at 8:54am
Most likely it just means that it tried to open a file that it couldnt find/wasnt there, in this case your Messages.mdb.

Got me scratching my head, based on what you have here it should work.

http://www.codeproject.com/KB/database/jdbcodbc.aspx

Referencing the first part of that page your code is spot on.. hmm..
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
I5 760 GA-H55N GTX 470 PNY Optima 8GB 
Hard DriveMonitorPowerCase
Spinpoint F4 LG227WTG sg07 PSU Sugo sg07 
Mouse
CM Sentinel 
View all
  hide details  
Reply
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
I5 760 GA-H55N GTX 470 PNY Optima 8GB 
Hard DriveMonitorPowerCase
Spinpoint F4 LG227WTG sg07 PSU Sugo sg07 
Mouse
CM Sentinel 
View all
  hide details  
Reply
post #17 of 34
3/8/11 at 9:03am
Thread Starter 
Do you think it could have anything to do with the actually code and how it's using the database. Like I'm calling up fields that aren't there?
Dark Star
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6600 - Currently Overclocking ;) Gigabyte GA-EP45-UD3P HD 6950 OCZ Blade LC DDR2 PC29200 4GB (GOT) 
Hard DriveOSMonitorKeyboard
640GB for Storage and OCZ Vertex 2e 60GB Windows 7 Ultimate-Signature Edition 3 x 22" -BenQ G2222HDL Logitech G15 
PowerCaseMouse
Corsair TX850 HAF 932 Logitech G500 
View all
  hide details  
Reply
Dark Star
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6600 - Currently Overclocking ;) Gigabyte GA-EP45-UD3P HD 6950 OCZ Blade LC DDR2 PC29200 4GB (GOT) 
Hard DriveOSMonitorKeyboard
640GB for Storage and OCZ Vertex 2e 60GB Windows 7 Ultimate-Signature Edition 3 x 22" -BenQ G2222HDL Logitech G15 
PowerCaseMouse
Corsair TX850 HAF 932 Logitech G500 
View all
  hide details  
Reply
post #18 of 34
3/8/11 at 9:17am
Thread Starter 
I just tried creating the file again from scratch. And nothing... Maybe it's the DNS settings that were mentioned earlier???
Dark Star
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6600 - Currently Overclocking ;) Gigabyte GA-EP45-UD3P HD 6950 OCZ Blade LC DDR2 PC29200 4GB (GOT) 
Hard DriveOSMonitorKeyboard
640GB for Storage and OCZ Vertex 2e 60GB Windows 7 Ultimate-Signature Edition 3 x 22" -BenQ G2222HDL Logitech G15 
PowerCaseMouse
Corsair TX850 HAF 932 Logitech G500 
View all
  hide details  
Reply
Dark Star
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6600 - Currently Overclocking ;) Gigabyte GA-EP45-UD3P HD 6950 OCZ Blade LC DDR2 PC29200 4GB (GOT) 
Hard DriveOSMonitorKeyboard
640GB for Storage and OCZ Vertex 2e 60GB Windows 7 Ultimate-Signature Edition 3 x 22" -BenQ G2222HDL Logitech G15 
PowerCaseMouse
Corsair TX850 HAF 932 Logitech G500 
View all
  hide details  
Reply
post #19 of 34
3/8/11 at 9:33am
Pretty sure its not a problem with the actual file,
some googling brought this back to me

http://in.answers.yahoo.com/question...3223312AAyVXqA

See if that helps you any.
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
I5 760 GA-H55N GTX 470 PNY Optima 8GB 
Hard DriveMonitorPowerCase
Spinpoint F4 LG227WTG sg07 PSU Sugo sg07 
Mouse
CM Sentinel 
View all
  hide details  
Reply
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
I5 760 GA-H55N GTX 470 PNY Optima 8GB 
Hard DriveMonitorPowerCase
Spinpoint F4 LG227WTG sg07 PSU Sugo sg07 
Mouse
CM Sentinel 
View all
  hide details  
Reply
post #20 of 34
3/8/11 at 9:41am
Thread Starter 
That looks like it might actually. Only when I get through to choosing drivers there isn't a "Microsoft Access Driver" only a SQL Server one... where would I get this Access driver from??
Dark Star
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6600 - Currently Overclocking ;) Gigabyte GA-EP45-UD3P HD 6950 OCZ Blade LC DDR2 PC29200 4GB (GOT) 
Hard DriveOSMonitorKeyboard
640GB for Storage and OCZ Vertex 2e 60GB Windows 7 Ultimate-Signature Edition 3 x 22" -BenQ G2222HDL Logitech G15 
PowerCaseMouse
Corsair TX850 HAF 932 Logitech G500 
View all
  hide details  
Reply
Dark Star
(13 items)
  		  
CPUMotherboardGraphicsRAM
Q6600 - Currently Overclocking ;) Gigabyte GA-EP45-UD3P HD 6950 OCZ Blade LC DDR2 PC29200 4GB (GOT) 
Hard DriveOSMonitorKeyboard
640GB for Storage and OCZ Vertex 2e 60GB Windows 7 Ultimate-Signature Edition 3 x 22" -BenQ G2222HDL Logitech G15 
PowerCaseMouse
Corsair TX850 HAF 932 Logitech G500 
View all
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Application Programming
Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › Application Programming › Java error message when linking to database.