Hi I have to move the date to one DB to another by live, so i wrote a Java program which will read the data from Sourse DB, and make the data as a Strings which nothing but insert statements with data. I simply add these as a batch and fire them to destination. Everything is fine, if simple data is present. But the problem is if i have any Single Quotes or Back Slashes(\) in the data the insert statement fails.
any ideas to run this smooth though there are Sinle Qoutes and Back Slashes in the data. Thank You. Regards, Bala Raju M.
