Return substitution symbol for bad data instead of SQLException for Oracle JDBC

  • Thread starter Thread starter bwright
  • Start date Start date
Status
Not open for further replies.
B

bwright

Guest
IFSWorld end-user gets an SQLException with all the Connect for JDBC drivers when fetching invalid code points (for most character sets). [xxxx][xxxx JDBC Driver]Transliteration failed, reason: invalid xxx data Some applications simply stop copying data from database to database when encountering an SQLException and there is no workaround/toggle in the application to avoid this application behavior. Customer would like us to implement a CfJDBC driver connection option so that it would be possible to always return a substitution character '?' rather than throwing an SQLException.

Continue reading...
 
Status
Not open for further replies.
Back
Top