Printable View
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
why is this happening.. ??Quote:
[Microsoft][ODBC Text Driver] Updating data in a linked table is not supported by this ISAM.
and how to solved this problem... i am a newbie with setting up .txt file as database for java application..
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?Quote:
i am trying to connect my java application with .txt file using jdbc
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.
Quote:
Originally Posted by copeg
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??