Hi all..

I am having a table named "login" in MS access..
I am connecting it to a java application with th help of the following code..

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("Driver loaded");
// Establish a connection
connection = DriverManager.getConnection("jdbc:odbc:ESMDB");
System.out.println ("Database connected");
String result="";
st = connection.createStatement();
rs = st.executeQuery("SELECT * FROM Login");


while(rs.next())
{


String user= rs.getString(1);
String pw=rs.getString(2);
System.out.println(username+password);

I am getting null value when i try to execute select * from Login..
what could be the reason..?Someone help in this regard as early as possible.

Regards,
Balagurunathan S

what "null value"?
It's highly unlikely the ResultSet will be null, though with that bad driver you're using it could maybe happen (as it was never intended to be more than a technology demonstrator, and possibly poorly written).
The database could contain NULL values for you to retrieve, if so you will indeed get them back.
It's your responsibility to handle those in some way appropriate to the data you're retrieving (maybe you get NULL for a password if it's not been set for example).

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.