Thread: Cannot update data in .txt/.csv file

hello there.. i need some help right here..

i am trying to connect my java application with .txt file using jdbc

for the connection and query that's successful

but when it come to updating data in my txt file this problem occured

[Microsoft][ODBC Text Driver] Updating data in a linked table is not supported by this ISAM.

why is this happening.. ??

and how to solved this problem... i am a newbie with setting up .txt file as database for java application..

i am trying to connect my java application with .txt file using jdbc

jdbc connects to a database, not a text file. So you may need to clarify. Are you saying you wish to read a text file and update a database with that information?

The error you are receiving may be database dependent, and my first guess is that you are connecting to a database as a user without UPDATE privileges.

Originally Posted by copeg

jdbc connects to a database, not a text file. So you may need to clarify. Are you saying you wish to read a text file and update a database with that information?

The error you are receiving may be database dependent, and my first guess is that you are connecting to a database as a user without UPDATE privileges.

first of all.. i do not want to read a file and update database with the information in the file.. i am making a text file as my application database.. connecting using jdbcodbc driver .. connecting the the file and running an query is successful

but i tried to update data in my text file using SQL UPDATE statement and unfortunately it didn't work out..
and the error occur as i have mentioned in my first post. So i thought there must be any way using any of file manipulation Class that can do something like this

[highlight=JAVA]

1. get the field first value
2. update the second value which is the second column based on the value of the first column

[highlight]

but i don't have any idea how to do that.. or can UPDATE statement can be used to update the data in my text file??