Title:
JRE 1.8 breaks the codepage setting of ODBC services - Only for Japanese Windows
| View in TrackerStatus/Resolution/Reason: Closed/Withdrawn/Duplicate
Reporter/Name(from Bugbase): / ext-user (Rahul Upadhyay)
Created: 03/18/2015
Versions: 11.0
Failure Type:
Found In Build/Fixed In Build: 11,0,03,292866 /
Priority/Frequency: Normal / Few users will encounter
Locale/System: Japanese / Win 2008 Enterprise Svr 64-bit,Win 2012 Server x64
Vote Count: 0
Duplicate ID: CF-4157031
Problem:
JRE 1.8 breaks the codepage setting of ODBC services - Only for Japanese Windows
Microsoft Access driver needs a codepage setting to handle Japanese characters on Japanese Windows.
The commands to set the code page are;
cd C:\ColdFusion11\cfusion\db\slserver54\admin
swcla -l sar 'ColdFusion 11 ODBC Server' ServiceCodePage OS
When used with JRE 1.8, the command breaks ODBC.
Method:
[Steps to reproduce]
1. Install CF 11 with the latest installer or set CF 11 to use JRE 1.8 on Japanese Windows.
NOTE: Japanese Windows is required to reproduce the issue. English Windows has no issue.
2. Set up a datasource to use MS ACCESS.
3. Veryfy the datasource works as expected, except handling Japanese charaters.
3. Change the codepage to OS by the commands below; cd C:\ColdFusion11\cfusion\db\slserver54\admin
swcla -l sar 'ColdFusion 11 ODBC Server' ServiceCodePage OS 4. Excpetion occurs when using the datarource via cfquery or editing the datasource.
"Error","http-bio-8502-exec-9","02/12/15","17:25:44","cfadmin","sun/io/MalformedInputException The specific sequence of files included or processed is: C:\ColdFusion11\cfusion\wwwroot\CFIDE\administrator\datasources\msaccess.cfm, line: 656 "
java.lang.NoClassDefFoundError: sun/io/MalformedInputException
Result:
Exception occurs and the datasource cannot be used.
Expected:
The datasource should work without errors.
Workaround:
Using JRE 1.7
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3955400
External Customer Info:
External Company:
External Customer Name:
External Customer Email:Attachments:
Comments: