When I am trying to fetch data from access database ucanaccess driver is throwing this exception
net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.0.4 data type cast needed
for parameter or null literal
here is the screen of my application output
Thanks
Asked
Active
Viewed 113 times
-1
![](../../users/profiles/5792244.webp)
Dave2e
- 15,736
- 17
- 32
- 37
1 Answers
0
Select ... WHERE ? = ?
Parameter placeholders cannot be used to specify column names. You'll need to use dynamic SQL (string formatting) to specify the column name and then use a parameter placeholder for the column value.
![](../../users/profiles/2144390.webp)
Gord Thompson
- 98,607
- 26
- 164
- 342
-
Thanks Gord Thompson – Danial Ghani Attari Qadri Jun 07 '18 at 15:50