aspose file tools*
The moose likes JDBC 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
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