How to get value from resultset column name in java?

Question

I'm reading value from Excel using jdbc-odbc in java ? One of the column name start with . how to read the from that column ? Im getting error unknown column while reading..

//String filesend = resultset.getString(".file send");

Please help me..

I think you are using the alias column name.. Paste your query, which is execute? — Sashi Kant, Dec 10 '12 at 06:05

score 2 · Accepted Answer · answered Dec 10 '12 at 05:58

2

Did you try escaping the . ?
A good idea would be to see the name of the column using ResultSetMetaData.getColumnName(index) method.

answered Dec 10 '12 at 05:58

Aditya Jain

1,077
1
12
25

yeah. once you debug to see what's the column name that resultset hold you will be able to use it in above getString() method. – Aditya Jain Dec 10 '12 at 06:16

score 0 · Answer 2 · answered Dec 10 '12 at 06:10

May be you should use Apache POI to get connection

Here is the code:

FileInputStream myInput = new FileInputStream(inputFile);
XSSFWorkbook wb = new XSSFWorkbook(myInput);

XSSFSheet sheet = wb.getSheetAt(0);
XSSFRow row = sheet.getRow(0); 
XSSFCell cell = row.getCell(1);
cell.setCellValue(123);

How to get value from resultset column name in java?

2 Answers2