Hi All,
There is a scheduled batch job in my application which reads a text file and inserts/updates the processed data into some database tables. The batch job code is first invoked from a shell script which then calls a Jar which then does further job of calling database code to populate some tables.
This job was working fine till yesterday. However, it failed with an error 'Invalid character encountered' today. I observed that there is a special character ú in the text file. I then tried to replicate the issue on my machine. I have the
java code setup for the job in Eclipse Helios. So for my local code setup, I just copied the text file to my machine then updated properties file to read the text file from my machine and executed the job. But the job did not throw any exception.
I also executed an update statement on my Toad to update a column with a
string containing ú and it worked.
Please help me to find out why it failed as a scheduled batch job. Thanks in Advance