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
Author

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
Hi,

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.


Regards
Shankar.


"Failure is not when you fall down; its only when you fail to get up again."
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem in getting data from MSAccess