permaculture playing cards
The moose likes JDBC and Relational Databases and the fly likes Problem in getting data from MSAccess Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Problem in getting data from MSAccess" Watch "Problem in getting data from MSAccess" New topic

Problem in getting data from MSAccess

Srinivasa Raghavan
Ranch Hand

Joined: Sep 28, 2004
Posts: 1228
I have a column in a MSAccess table. That column had alphanumeric data.
For example : it can have datas like: abc, some value, 1,2,3, xyz

The problem here is when I use rs.getString("columnName") , for all String values, I get the exact data from DB but if the value is 1 or 2, i'm getting an empty string.
Can anyone guide me.

Thanks & regards, Srini
MCP, SCJP-1.4, NCFM (Financial Markets), Oracle 9i - SQL ( 1Z0-007 ), ITIL Certified
Shankar Narayana
Ranch Hand

Joined: Jan 08, 2003
Posts: 134

What is the datatype for that column in the database, basically it shoudn't be a problem, try to refer to the column value where you are getting empty string, might be that column hasn't got any data in it.


"Failure is not when you fall down; its only when you fail to get up again."
I agree. Here's the link:
subject: Problem in getting data from MSAccess
It's not a secret anymore!