Win a copy of JDBC Workbook this week in the JDBC and Relational Databases forum
or A Day in Code in the A Day in Code forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Frits Walraven
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • salvin francis
  • fred rosenberger

Trying to query an sql statement from a java program.

 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am trying to execute a query statement from my java program, but whenever I run it I get a nullpointerexeption on the Statement stmt = DBConnect.con.createStatement();. Does anyone know how to fix this?

 
Saloon Keeper
Posts: 11989
257
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well, I don't know what DBConnect is, but either it, or DBConnect.con is null. I can't really tell you more unless you say what DBConnect is.
 
rand Kirby
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is DBConnect

[/code]
 
Stephan van Hulst
Saloon Keeper
Posts: 11989
257
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well there you go. You initialize con to null, and never set it to anything else. Remember that only one main() method is run when you start your application.

This is not a good design though. You shouldn't have one static connection that is accessible by the entire application. Instead, classes that need to interact with a database should have a constructor that takes a DataSource. The class can then open a new or pooled connection at the moment they need it:

Note also that you probably shouldn't get passwords hashes out of your database until you're going to authenticate a specific user.
 
Story like this gets better after being told a few times. Or maybe it's just a tiny ad:
Devious Experiments for a Truly Passive Greenhouse!
https://www.kickstarter.com/projects/paulwheaton/greenhouse-1
    Bookmark Topic Watch Topic
  • New Topic