java.sql.SQLException Error Code: 0 SQL State: 2C000

• mselva1587

  SSC Veteran

  Points: 244

  More actions

  August 12, 2013 at 7:43 am

  #276141

  While i am trying to connect with sql server 2012 with collation "Chinese_Hong_Kong_Stroke_90_CI_AS" through java code.I am getting error message like this

  Error message:

  =============

  An error occurred while establishing the connection:

  Type: java.sql.SQLException Error Code: 0 SQL State: 2C000

  Message:

  Could not find a Java charset equivalent to collation 040CD01000.

  Configuration details:

  =====================

  Os:windows 2008

  sql server version:2012

  driver name:jtds

  i need to fix this issue in java code.please suggest me if is there any fix.awaiting for your reply.thanks in advance.

  with regards

  M.Selvakumar

• starflyer

  SSC Eights!

  Points: 981

  More actions

  August 21, 2013 at 9:26 am

  #1643510

  Did you try using the Microsoft JDBC driver (if possible in your situation) for connecting to SQL 2012?