Custom SQL type for Spanner JSON data type. This type (or the vendor type number) must be used
when setting a JSON parameter using PreparedStatement#setObject(int, Object, SQLType).
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-16 UTC."],[],[],null,["# Class JsonType (2.32.1)\n\nVersion latestkeyboard_arrow_down\n\n- [2.32.1 (latest)](/java/docs/reference/google-cloud-spanner-jdbc/latest/com.google.cloud.spanner.jdbc.JsonType)\n- [2.32.0](/java/docs/reference/google-cloud-spanner-jdbc/2.32.0/com.google.cloud.spanner.jdbc.JsonType)\n- [2.31.2](/java/docs/reference/google-cloud-spanner-jdbc/2.31.2/com.google.cloud.spanner.jdbc.JsonType)\n- [2.30.4](/java/docs/reference/google-cloud-spanner-jdbc/2.30.4/com.google.cloud.spanner.jdbc.JsonType)\n- [2.28.0](/java/docs/reference/google-cloud-spanner-jdbc/2.28.0/com.google.cloud.spanner.jdbc.JsonType)\n- [2.27.1](/java/docs/reference/google-cloud-spanner-jdbc/2.27.1/com.google.cloud.spanner.jdbc.JsonType)\n- [2.26.1](/java/docs/reference/google-cloud-spanner-jdbc/2.26.1/com.google.cloud.spanner.jdbc.JsonType)\n- [2.25.1](/java/docs/reference/google-cloud-spanner-jdbc/2.25.1/com.google.cloud.spanner.jdbc.JsonType)\n- [2.24.1](/java/docs/reference/google-cloud-spanner-jdbc/2.24.1/com.google.cloud.spanner.jdbc.JsonType)\n- [2.23.0](/java/docs/reference/google-cloud-spanner-jdbc/2.23.0/com.google.cloud.spanner.jdbc.JsonType)\n- [2.22.1](/java/docs/reference/google-cloud-spanner-jdbc/2.22.1/com.google.cloud.spanner.jdbc.JsonType)\n- [2.21.0](/java/docs/reference/google-cloud-spanner-jdbc/2.21.0/com.google.cloud.spanner.jdbc.JsonType)\n- [2.20.2](/java/docs/reference/google-cloud-spanner-jdbc/2.20.2/com.google.cloud.spanner.jdbc.JsonType)\n- [2.19.3](/java/docs/reference/google-cloud-spanner-jdbc/2.19.3/com.google.cloud.spanner.jdbc.JsonType)\n- [2.18.1](/java/docs/reference/google-cloud-spanner-jdbc/2.18.1/com.google.cloud.spanner.jdbc.JsonType)\n- [2.17.0](/java/docs/reference/google-cloud-spanner-jdbc/2.17.0/com.google.cloud.spanner.jdbc.JsonType)\n- [2.16.1](/java/docs/reference/google-cloud-spanner-jdbc/2.16.1/com.google.cloud.spanner.jdbc.JsonType)\n- [2.15.5](/java/docs/reference/google-cloud-spanner-jdbc/2.15.5/com.google.cloud.spanner.jdbc.JsonType)\n- [2.14.6](/java/docs/reference/google-cloud-spanner-jdbc/2.14.6/com.google.cloud.spanner.jdbc.JsonType)\n- [2.13.4](/java/docs/reference/google-cloud-spanner-jdbc/2.13.4/com.google.cloud.spanner.jdbc.JsonType)\n- [2.11.4](/java/docs/reference/google-cloud-spanner-jdbc/2.11.4/com.google.cloud.spanner.jdbc.JsonType)\n- [2.10.0](/java/docs/reference/google-cloud-spanner-jdbc/2.10.0/com.google.cloud.spanner.jdbc.JsonType)\n- [2.9.16](/java/docs/reference/google-cloud-spanner-jdbc/2.9.16/com.google.cloud.spanner.jdbc.JsonType)\n- [2.8.0](/java/docs/reference/google-cloud-spanner-jdbc/2.8.0/com.google.cloud.spanner.jdbc.JsonType)\n- [2.7.12](/java/docs/reference/google-cloud-spanner-jdbc/2.7.12/com.google.cloud.spanner.jdbc.JsonType)\n- [2.6.4](/java/docs/reference/google-cloud-spanner-jdbc/2.6.4/com.google.cloud.spanner.jdbc.JsonType)\n- [2.5.11](/java/docs/reference/google-cloud-spanner-jdbc/2.5.11/com.google.cloud.spanner.jdbc.JsonType) \n\n public class JsonType implements SQLType\n\nCustom SQL type for Spanner JSON data type. This type (or the vendor type number) must be used\nwhen setting a JSON parameter using PreparedStatement#setObject(int, Object, SQLType). \n\nInheritance\n-----------\n\n[java.lang.Object](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html) \\\u003e JsonType \n\nImplements\n----------\n\n[SQLType](https://docs.oracle.com/javase/8/docs/api/java/sql/SQLType.html) \n\nInherited Members\n-----------------\n\n[Object.clone()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#clone--) \n[Object.equals(Object)](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#equals-java.lang.Object-) \n[Object.finalize()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#finalize--) \n[Object.getClass()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#getClass--) \n[Object.hashCode()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#hashCode--) \n[Object.notify()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#notify--) \n[Object.notifyAll()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#notifyAll--) \n[Object.toString()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#toString--) \n[Object.wait()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#wait--) \n[Object.wait(long)](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#wait-long-) \n[Object.wait(long,int)](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#wait-long-int-)\n\nStatic Fields\n-------------\n\n### INSTANCE\n\n public static final JsonType INSTANCE\n\n### SHORT_VENDOR_TYPE_NUMBER\n\n public static final short SHORT_VENDOR_TYPE_NUMBER\n\nDefine a short type number as well, as this is what is expected to be returned in DatabaseMetaData#getTypeInfo().\n\n### VENDOR_TYPE_NUMBER\n\n public static final int VENDOR_TYPE_NUMBER\n\nSpanner does not have any type numbers, but the code values are unique. Add 100,000 to avoid\nconflicts with the type numbers in java.sql.Types.\n\nMethods\n-------\n\n### getName()\n\n public String getName()\n\n### getVendor()\n\n public String getVendor()\n\n### getVendorTypeNumber()\n\n public Integer getVendorTypeNumber()\n\n### toString()\n\n public String toString()\n\n**Overrides** \n[Object.toString()](https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html#toString--)"]]
