How to flag a row of a mysql table which is read through a Java Program? (mySQL+JAVA)
Posted on 2004-10-20
I have a problem with flagging the rows of table(mysql) which were read and which aren't.I will explain my problem.
I am uploading a file by means of a JSP(text file which contains job requirements) to mySQL database table.And i have to read the file from databse by means of another JAVA program and submit that file to PBS (Job management and execution software).I am able to read the file from database and could submit it to the database.
My problem is i have to read the table row (which contains the file) only once because i have to submit the file to PBS only once.How can i flag the file which one is read (i mean which row of table is read or not).
Suppose 3 different persons submitted files(different file with job requirements) to the database.Let us think previouly there are 5 rows that(files) were submitted to the database.I have to read the last 3 rows which were not submitted to the PBS previously.How can i flag the first 5 rows as they were read and submitted to the databse.
Please reply if somebody have some idea.
Thanks for your time and patience,