"use strict"; const {Fragment: _Fragment, jsx: _jsx, jsxs: _jsxs} = arguments[0]; const {useMDXComponents: _provideComponents} = arguments[0]; const WideTableWrapper = ({children}) => { const _components = { div: "div", ..._provideComponents() }; const containerStyle = { overflow: "auto", maxWidth: "100%" }; return _jsx(_components.div, { style: containerStyle, children: children }); }; function _createMdxContent(props) { const _components = { a: "a", code: "code", li: "li", ol: "ol", p: "p", pre: "pre", span: "span", strong: "strong", tbody: "tbody", td: "td", th: "th", thead: "thead", tr: "tr", ul: "ul", ..._provideComponents(), ...props.components }, {CodeBlock, Heading, Info, Note, Tab, Table, Tabs, View} = _components; if (!CodeBlock) _missingMdxReference("CodeBlock", true); if (!Heading) _missingMdxReference("Heading", true); if (!Info) _missingMdxReference("Info", true); if (!Note) _missingMdxReference("Note", true); if (!Tab) _missingMdxReference("Tab", true); if (!Table) _missingMdxReference("Table", true); if (!Tabs) _missingMdxReference("Tabs", true); if (!View) _missingMdxReference("View", true); return _jsxs(_Fragment, { children: [_jsxs(View, { title: "v0.8+", id: "v0-8", children: [_jsx(Note, { children: _jsxs(_components.p, { children: [_jsx(_components.code, { children: "clickhouse-jdbc" }), " implementa la interfaz estándar de JDBC con el cliente de Java más reciente.\nRecomendamos usar directamente el cliente de Java más reciente si el rendimiento o el acceso directo son críticos."] }) }), _jsx(Heading, { level: "2", id: "requisitos-del-entorno", children: "Requisitos del entorno" }), _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: [_jsx(_components.a, { href: "https://openjdk.java.net", children: "OpenJDK" }), " versión >= 8"] }), "\n"] }), _jsx(Heading, { level: "3", id: "setup", children: "Setup" }), _jsxs(Tabs, { children: [_jsx(Tab, { title: "Maven", id: "maven", children: _jsx(CodeBlock, { filename: "", numberOfLines: "7", language: "xml", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "xml", children: _jsxs(_components.code, { language: "xml", numberOfLines: "7", children: [_jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "{/* https://mvnrepository.com/artifact/com.clickhouse/clickhouse-jdbc */}" }) }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#808080" }, children: "<" }), _jsx(_components.span, { style: { color: "#116329", "--shiki-dark": "#569CD6" }, children: "dependency" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#808080" }, children: ">" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#808080" }, children: " <" }), _jsx(_components.span, { style: { color: "#116329", "--shiki-dark": "#569CD6" }, children: "groupId" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#808080" }, children: ">" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "com.clickhouse" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#808080" }, children: "" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#808080" }, children: " <" }), _jsx(_components.span, { style: { color: "#116329", "--shiki-dark": "#569CD6" }, children: "artifactId" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#808080" }, children: ">" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "clickhouse-jdbc" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#808080" }, children: "" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#808080" }, children: " <" }), _jsx(_components.span, { style: { color: "#116329", "--shiki-dark": "#569CD6" }, children: "version" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#808080" }, children: ">" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "0.9.8" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#808080" }, children: "" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#808080" }, children: " <" }), _jsx(_components.span, { style: { color: "#116329", "--shiki-dark": "#569CD6" }, children: "classifier" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#808080" }, children: ">" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "all" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#808080" }, children: "" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#808080" }, children: "" })] }), "\n"] }) }) }) }), _jsx(Tab, { title: "Gradle (Kotlin)", id: "gradle-kotlin", children: _jsx(CodeBlock, { filename: "", numberOfLines: "2", language: "kotlin", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "kotlin", children: _jsxs(_components.code, { language: "kotlin", numberOfLines: "2", children: [_jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: "// https://mvnrepository.com/artifact/com.clickhouse/clickhouse-jdbc" }) }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "implementation" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"com.clickhouse:clickhouse-jdbc:0.9.8:all\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ")" })] }), "\n"] }) }) }) }), _jsx(Tab, { title: "Gradle", id: "gradle", children: _jsx(CodeBlock, { filename: "", numberOfLines: "2", language: "groovy", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "groovy", children: _jsxs(_components.code, { language: "groovy", numberOfLines: "2", children: [_jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: "// https://mvnrepository.com/artifact/com.clickhouse/clickhouse-jdbc" }) }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "implementation " }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "'com.clickhouse:clickhouse-jdbc:0.9.8:all'" })] }), "\n"] }) }) }) })] }), _jsx(_components.p, { children: "Si utiliza el JDBC driver en una aplicación que requiere añadir el jar al classpath, debe descargar el jar desde:" }), _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: [_jsx(_components.a, { href: "https://mvnrepository.com/artifact/com.clickhouse/clickhouse-jdbc", children: "Maven Central" }), " y agrégalo al classpath", "\n", _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: ["a partir de la versión ", _jsx(_components.code, { children: "0.9.4" }), ", está disponible el artefacto ", _jsx(_components.a, { href: "https://mvnrepository.com/artifact/com.clickhouse/clickhouse-jdbc-all", children: "https://mvnrepository.com/artifact/com.clickhouse/clickhouse-jdbc-all" })] }), "\n", _jsxs(_components.li, { children: ["use el calificador ", _jsx(_components.code, { children: "all" }), " para obtener el JAR con todas las dependencias empaquetadas incluidas."] }), "\n"] }), "\n"] }), "\n", _jsxs(_components.li, { children: ["o desde el repositorio oficial ", _jsx(_components.a, { href: "https://github.com/ClickHouse/clickhouse-java/releases", children: "aquí" })] }), "\n"] }), _jsx(Heading, { level: "2", id: "configuraci%C3%B3n", children: "Configuración" }), _jsxs(_components.p, { children: [_jsx(_components.strong, { children: "Clase del driver" }), ": ", _jsx(_components.code, { children: "com.clickhouse.jdbc.ClickHouseDriver" })] }), _jsxs(Note, { children: [_jsxs(_components.p, { children: [_jsx(_components.code, { children: "com.clickhouse.jdbc.ClickHouseDriver" }), " es una clase de fachada para las implementaciones JDBC nueva y antigua. Usa la implementación JDBC nueva de forma predeterminada.\nPuede usar la implementación JDBC antigua estableciendo en ", _jsx(_components.code, { children: "true" }), " la propiedad ", _jsx(_components.strong, { children: "del sistema" }), " ", _jsx(_components.code, { children: "clickhouse.jdbc.v1" }), ". Esta propiedad debe establecerse antes de invocar la\nclase Driver."] }), _jsx(_components.p, { children: "Una forma alternativa de cambiar entre versiones es usar directamente las clases Driver de cada versión:" }), _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "com.clickhouse.jdbc.Driver" }), " es la implementación JDBC nueva (V2)."] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "com.clickhouse.jdbc.DriverV1" }), " es la implementación JDBC antigua (V1)."] }), "\n"] })] }), _jsxs(_components.p, { children: [_jsx(_components.strong, { children: "Sintaxis de URL" }), ": ", _jsx(_components.code, { children: "jdbc:(ch|clickhouse)[:]://endpoint[:port][/][?param1=value1¶m2=value2][#tag1,tag2,...]" }), ", por ejemplo:"] }), _jsxs(_components.ul, { children: ["\n", _jsx(_components.li, { children: _jsx(_components.code, { children: "jdbc:clickhouse:http://localhost:8123" }) }), "\n", _jsx(_components.li, { children: _jsx(_components.code, { children: "jdbc:clickhouse:https://localhost:8443?ssl=true" }) }), "\n"] }), _jsx(_components.p, { children: "Hay algunos aspectos que conviene tener en cuenta sobre la sintaxis de la URL:" }), _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: [_jsx(_components.strong, { children: "solo" }), " se permite un único endpoint en la URL"] }), "\n", _jsx(_components.li, { children: "se debe especificar el protocolo cuando no sea el predeterminado - ‘HTTP’" }), "\n", _jsx(_components.li, { children: "se debe especificar el puerto cuando no sea el predeterminado ‘8123’" }), "\n", _jsx(_components.li, { children: "el driver no infiere el protocolo a partir del puerto, debe especificarlo explícitamente" }), "\n", _jsxs(_components.li, { children: ["El parámetro ", _jsx(_components.code, { children: "ssl" }), " no se requiere cuando se especifica el protocolo."] }), "\n"] }), _jsx(Heading, { level: "3", id: "propiedades-de-conexi%C3%B3n", children: "Propiedades de conexión" }), _jsxs(_components.p, { children: ["Los principales parámetros de configuración se definen en el ", _jsx(_components.a, { href: "/es/integrations/language-clients/java/client#client-configuration", children: "cliente de Java" }), ". Deben pasarse tal cual al driver. El driver tiene algunas propiedades propias que no forman parte de la configuración del cliente; estas se enumeran a continuación."] }), _jsxs(_components.p, { children: [_jsx(_components.strong, { children: "Propiedades del driver" }), ":"] }), _jsxs(Table, { children: [_jsx(_components.thead, { children: _jsxs(_components.tr, { children: [_jsx(_components.th, { children: "Propiedad" }), _jsx(_components.th, { children: "Predeterminado" }), _jsx(_components.th, { children: "Descripción" })] }) }), _jsxs(_components.tbody, { children: [_jsxs(_components.tr, { children: [_jsx(_components.td, { children: _jsx(_components.code, { children: "disable_frameworks_detection" }) }), _jsx(_components.td, { children: _jsx(_components.code, { children: "true" }) }), _jsx(_components.td, { children: "Desactiva la detección de frameworks del User-Agent" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: _jsx(_components.code, { children: "jdbc_ignore_unsupported_values" }) }), _jsx(_components.td, { children: _jsx(_components.code, { children: "false" }) }), _jsxs(_components.td, { children: ["Suprime ", _jsx(_components.code, { children: "SQLFeatureNotSupportedException" }), " cuando no afecta al funcionamiento del driver"] })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: _jsx(_components.code, { children: "clickhouse.jdbc.v1" }) }), _jsx(_components.td, { children: _jsx(_components.code, { children: "false" }) }), _jsx(_components.td, { children: "Usa la implementación anterior de JDBC en lugar de la nueva" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: _jsx(_components.code, { children: "default_query_settings" }) }), _jsx(_components.td, { children: _jsx(_components.code, { children: "null" }) }), _jsx(_components.td, { children: "Permite pasar ajustes de consulta predeterminados en las operaciones de consulta" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: _jsx(_components.code, { children: "jdbc_resultset_auto_close" }) }), _jsx(_components.td, { children: _jsx(_components.code, { children: "true" }) }), _jsxs(_components.td, { children: ["Cierra automáticamente ", _jsx(_components.code, { children: "ResultSet" }), " cuando se cierra el ", _jsx(_components.code, { children: "Statement" })] })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: _jsx(_components.code, { children: "beta.row_binary_for_simple_insert" }) }), _jsx(_components.td, { children: _jsx(_components.code, { children: "false" }) }), _jsxs(_components.td, { children: ["Utiliza la implementación de ", _jsx(_components.code, { children: "PreparedStatement" }), " basada en el generador ", _jsx(_components.code, { children: "RowBinary" }), ". Solo funciona con consultas ", _jsx(_components.code, { children: "INSERT INTO ... VALUES" }), "."] })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: _jsx(_components.code, { children: "jdbc_resultset_auto_close" }) }), _jsx(_components.td, { children: _jsx(_components.code, { children: "true" }) }), _jsxs(_components.td, { children: ["Cierra automáticamente ", _jsx(_components.code, { children: "ResultSet" }), " al cerrar ", _jsx(_components.code, { children: "Statement" })] })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: _jsx(_components.code, { children: "jdbc_use_max_result_rows" }) }), _jsx(_components.td, { children: _jsx(_components.code, { children: "false" }) }), _jsxs(_components.td, { children: ["Permite usar la propiedad del servidor ", _jsx(_components.code, { children: "max_result_rows" }), " para limitar la cantidad de filas que devuelve la consulta. Cuando está habilitado, anula el modo de desbordamiento configurado por el usuario. Consulte JavaDoc para obtener más información."] })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: _jsx(_components.code, { children: "jdbc_sql_parser" }) }), _jsx(_components.td, { children: _jsx(_components.code, { children: "JAVACC" }) }), _jsxs(_components.td, { children: ["Configura qué parser de SQL usar. Opciones: ", _jsx(_components.code, { children: "ANTLR4" }), ", ", _jsx(_components.code, { children: "ANTLR4_PARAMS_PARSER" }), ", ", _jsx(_components.code, { children: "JAVACC" }), "."] })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: _jsx(_components.code, { children: "remember_last_set_roles" }) }), _jsx(_components.td, { children: _jsx(_components.code, { children: "true" }) }), _jsx(_components.td, { children: "Recuerda los últimos roles establecidos para la conexión." })] })] })] }), _jsxs(Info, { children: [_jsx(_components.p, { children: _jsx(_components.strong, { children: "Configuración del servidor" }) }), _jsxs(_components.p, { children: ["Toda la configuración del servidor debe llevar el prefijo ", _jsx(_components.code, { children: "clickhouse_setting_" }), " (igual que en la ", _jsx(_components.a, { href: "/es/integrations/language-clients/java/client#server-settings", children: "configuración" }), " del cliente)."] }), _jsx(CodeBlock, { filename: "", numberOfLines: "8", language: "java", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "java", children: _jsxs(_components.code, { language: "java", numberOfLines: "8", children: [_jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Properties" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " config" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " new" }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: " Properties" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "();" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "config" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setProperty" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"user\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"default\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ");" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "config" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setProperty" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"password\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "getPassword" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "());" })] }), "\n", _jsx(_components.span, { className: "line" }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: "// establecer la configuración del servidor" }) }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "config" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "put" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "ClientConfigProperties" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "serverSetting" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"allow_experimental_time_time64_type\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "), " }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"1\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ");" })] }), "\n", _jsx(_components.span, { className: "line" }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Connection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " Driver" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "connect" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"jdbc:ch:http://localhost:8123/\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", config);" })] }), "\n"] }) }) })] }), _jsxs(_components.p, { children: [_jsx(_components.strong, { children: "Ejemplo de configuración" }), ":"] }), _jsx(CodeBlock, { filename: "", numberOfLines: "6", language: "java", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "java", children: _jsxs(_components.code, { language: "java", numberOfLines: "6", children: [_jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Properties" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " properties" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " new" }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: " Properties" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "();" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "properties" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setProperty" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"user\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"default\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ");" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "properties" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setProperty" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"password\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "getPassword" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "());" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "properties" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setProperty" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"client_name\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"my-app-01\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "); " }), _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: "// cuando se usa el protocolo HTTP, será `http_user_agent` en el log de consultas y no `client_name`." })] }), "\n", _jsx(_components.span, { className: "line" }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Connection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " Driver" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "connect" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"jdbc:ch:http://localhost:8123/\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", properties);" })] }), "\n"] }) }) }), _jsx(_components.p, { children: "lo que será equivalente a la siguiente URL JDBC:" }), _jsx(CodeBlock, { filename: "", numberOfLines: "2", language: "sql", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "sql", children: _jsxs(_components.code, { language: "sql", numberOfLines: "2", children: [_jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "jdbc:ch:" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#569CD6" }, children: "http" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ":" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: "//" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "localhost:" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "8123" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: "/" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "?user" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: "=" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#569CD6" }, children: "default" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "&" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#569CD6" }, children: "password" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: "=" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#569CD6" }, children: "password" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "&client_name" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: "=" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "my" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: "-" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "app" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: "-" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "01" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " " })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: "//" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " las credenciales deben pasarse en " }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "`Properties`" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ". Aquí es solo a modo de ejemplo." })] }), "\n"] }) }) }), _jsx(_components.p, { children: "Nota: no es necesario codificar en URL la URL JDBC ni las propiedades; se codificarán automáticamente." }), _jsx(Heading, { level: "3", id: "identificaci%C3%B3n-del-cliente", children: "Identificación del cliente" }), _jsxs(_components.p, { children: ["Existen dos formas de identificar la aplicación que originó una solicitud: establecer ", _jsx(_components.code, { children: "com.clickhouse.client.api.ClientConfigProperties#CLIENT_NAME" }), " mediante\nlas propiedades de conexión o utilizar el método ", _jsx(_components.code, { children: "java.sql.Connection#setClientInfo(String name, String value)" }), "."] }), _jsx(CodeBlock, { filename: "showLineNumbers", numberOfLines: "3", language: "java", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "java", children: _jsxs(_components.code, { language: "java", numberOfLines: "3", children: [_jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Properties" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " properties" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " new" }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: " Properties" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "();" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "properties" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setProperty" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "ClientConfigProperties" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "CLIENT_NAME" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "getKey" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(), " }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"my-app-01\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ");" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Connection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " Driver" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "connect" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"jdbc:ch:http://localhost:8123/\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", properties);" })] }), "\n"] }) }) }), _jsx(CodeBlock, { filename: "showLineNumbers", numberOfLines: "1", language: "java", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "java", children: _jsxs(_components.code, { language: "java", numberOfLines: "1", children: [_jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "conn" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setClientInfo" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "com" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "clickhouse" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "jdbc" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "ClientInfoProperties" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "APPLICATION_NAME" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "getKey" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(), " }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"my-app-01\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ");" })] }), "\n"] }) }) }), _jsxs(_components.p, { children: ["Ambas formas producirán el siguiente valor de ", _jsx(_components.code, { children: "http_user_agent" }), " en el registro de consultas:"] }), _jsx(CodeBlock, { numberOfLines: "2", language: "text", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "text", children: _jsxs(_components.code, { language: "text", numberOfLines: "2", children: [_jsx(_components.span, { className: "line", children: _jsx(_components.span, { children: "my-app-01/1.0 jdbc-v2/0.9.7 clickhouse-java-v2/0.9.6 (Linux; jvm:17.0.17) Apache-HttpClient/5.4.4" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, {}) })] }) }) }), _jsxs(_components.p, { children: [_jsx(_components.strong, { children: "Nota:" }), " Recomendamos usar el formato ", _jsx(_components.code, { children: "app_name/version" }), " para la propiedad ", _jsx(_components.code, { children: "client_name" }), ", ya que facilita la identificación de la aplicación en el registro de consultas."] }), _jsx(Heading, { level: "3", id: "identificaci%C3%B3n-de-operaciones", children: "Identificación de operaciones" }), _jsxs(_components.p, { children: ["El controlador JDBC genera un ", _jsx(_components.code, { children: "query_id" }), " para cada operación (actualmente se incluye en las excepciones del servidor)."] }), _jsxs(_components.p, { children: ["Para establecer ", _jsx(_components.code, { children: "log_comment" }), " en una operación, utilice el método ", _jsx(_components.code, { children: "com.clickhouse.jdbc.StatementImpl#getLocalSettings" }), ". Para ello, es necesario hacer un cast de ", _jsx(_components.code, { children: "Statement" }), " o ", _jsx(_components.code, { children: "PreparedStatement" }), " a ", _jsx(_components.code, { children: "com.clickhouse.jdbc.StatementImpl" }), " primero."] }), _jsx(CodeBlock, { filename: "showLineNumbers", numberOfLines: "2", language: "java", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "java", children: _jsxs(_components.code, { language: "java", numberOfLines: "2", children: [_jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "StatementImpl" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " stmt" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (StatementImpl) " }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "conn" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "createStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "();" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "stmt" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "getLocalSettings" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "()." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "logComment" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"some-comment\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ");" })] }), "\n"] }) }) }), _jsxs(_components.p, { children: [_jsx(_components.strong, { children: "Nota:" }), " este enfoque funciona para usos de sentencias en un solo hilo porque ", _jsx(_components.code, { children: "localSettings" }), " se comparte entre hilos."] }), _jsx(Heading, { level: "2", id: "tipos-de-datos-compatibles", children: "Tipos de datos compatibles" }), _jsxs(_components.p, { children: ["El JDBC driver admite los mismos formatos de datos que el ", _jsx(_components.a, { href: "/es/integrations/language-clients/java#supported-data-types", children: "java client" }), " subyacente."] }), _jsx(Heading, { level: "3", id: "correspondencia-de-tipos-jdbc", children: "Correspondencia de tipos JDBC" }), _jsx(_components.p, { children: "La siguiente correspondencia se aplica a:" }), _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "ResultSet#getObject(columnIndex)" }), " - el método devuelve un objeto de la clase Java correspondiente. (", _jsx(_components.code, { children: "Int8" }), " -> ", _jsx(_components.code, { children: "java.lang.Byte" }), ", ", _jsx(_components.code, { children: "Int16" }), " -> ", _jsx(_components.code, { children: "java.lang.Short" }), ", etc.)"] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "ResultSetMetaData#getColumnType(columnIndex)" }), " - el método devuelve el tipo JDBC correspondiente. (", _jsx(_components.code, { children: "Int8" }), " -> ", _jsx(_components.code, { children: "java.lang.Byte" }), ", ", _jsx(_components.code, { children: "Int16" }), " -> ", _jsx(_components.code, { children: "java.lang.Short" }), ", etc.)"] }), "\n"] }), _jsx(_components.p, { children: "Hay varias formas de cambiar la correspondencia:" }), _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "ResultSet#getObject(columnIndex, class)" }), " - el método intentará convertir el valor al tipo ", _jsx(_components.code, { children: "class" }), ". Hay algunas limitaciones de conversión. Consulta cada sección para ver más detalles."] }), "\n"] }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Tipos numéricos" }) }), _jsxs(Table, { children: [_jsx(_components.thead, { children: _jsxs(_components.tr, { children: [_jsx(_components.th, { children: "Tipo de ClickHouse" }), _jsx(_components.th, { children: "Tipo JDBC" }), _jsx(_components.th, { children: "Clase Java" })] }) }), _jsxs(_components.tbody, { children: [_jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Int8" }), _jsx(_components.td, { children: "TINYINT" }), _jsx(_components.td, { children: "java.lang.Byte" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Int16" }), _jsx(_components.td, { children: "SMALLINT" }), _jsx(_components.td, { children: "java.lang.Short" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Int32" }), _jsx(_components.td, { children: "INTEGER" }), _jsx(_components.td, { children: "java.lang.Integer" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Int64" }), _jsx(_components.td, { children: "BIGINT" }), _jsx(_components.td, { children: "java.lang.Long" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Int128" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.math.BigInteger" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Int256" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.math.BigInteger" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "UInt8" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.lang.Short" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "UInt16" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.lang.Integer" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "UInt32" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.lang.Long" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "UInt64" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.math.BigInteger" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "UInt128" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.math.BigInteger" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "UInt256" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.math.BigInteger" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Float32" }), _jsx(_components.td, { children: "REAL" }), _jsx(_components.td, { children: "java.lang.Float" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Float64" }), _jsx(_components.td, { children: "DOUBLE" }), _jsx(_components.td, { children: "java.lang.Double" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Decimal32" }), _jsx(_components.td, { children: "DECIMAL" }), _jsx(_components.td, { children: "java.math.BigDecimal" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Decimal64" }), _jsx(_components.td, { children: "DECIMAL" }), _jsx(_components.td, { children: "java.math.BigDecimal" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Decimal128" }), _jsx(_components.td, { children: "DECIMAL" }), _jsx(_components.td, { children: "java.math.BigDecimal" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Decimal256" }), _jsx(_components.td, { children: "DECIMAL" }), _jsx(_components.td, { children: "java.math.BigDecimal" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Bool" }), _jsx(_components.td, { children: "BOOLEAN" }), _jsx(_components.td, { children: "java.lang.Boolean" })] })] })] }), _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: ["los tipos numéricos son convertibles entre sí. Así, ", _jsx(_components.code, { children: "Int8" }), " se puede obtener como ", _jsx(_components.code, { children: "Float64" }), " y viceversa.:", "\n", _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "rs.getObject(1, Float64.class)" }), " devolverá un valor ", _jsx(_components.code, { children: "Float64" }), " de la columna ", _jsx(_components.code, { children: "Int8" }), "."] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "rs.getLong(1)" }), " devolverá un valor ", _jsx(_components.code, { children: "Long" }), " de la columna ", _jsx(_components.code, { children: "Int8" }), "."] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "rs.getByte(1)" }), " puede devolver un valor ", _jsx(_components.code, { children: "Byte" }), " de la columna ", _jsx(_components.code, { children: "Int16" }), " si cabe en ", _jsx(_components.code, { children: "Byte" }), "."] }), "\n"] }), "\n"] }), "\n", _jsx(_components.li, { children: "no se recomienda la conversión de un tipo de mayor capacidad a uno de menor capacidad debido al riesgo de corrupción de datos." }), "\n", _jsxs(_components.li, { children: ["El tipo ", _jsx(_components.code, { children: "Bool" }), " también funciona como número."] }), "\n", _jsxs(_components.li, { children: ["Todos los tipos numéricos pueden leerse como ", _jsx(_components.code, { children: "java.lang.String" }), "."] }), "\n", _jsxs(_components.li, { children: ["Almacenar ", _jsx(_components.code, { children: "Float.MAX_VALUE" }), " de Java como ", _jsx(_components.code, { children: "Float" }), " presenta un problema (", _jsx(_components.a, { href: "https://github.com/ClickHouse/clickhouse-java/issues/809", children: "https://github.com/ClickHouse/clickhouse-java/issues/809" }), "). Guardar ese mismo valor como ", _jsx(_components.code, { children: "Double" }), " lo resuelve."] }), "\n"] }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Tipos de cadena" }) }), _jsxs(Table, { children: [_jsx(_components.thead, { children: _jsxs(_components.tr, { children: [_jsx(_components.th, { children: "Tipo de ClickHouse" }), _jsx(_components.th, { children: "Tipo JDBC" }), _jsx(_components.th, { children: "Clase Java" })] }) }), _jsxs(_components.tbody, { children: [_jsxs(_components.tr, { children: [_jsx(_components.td, { children: "String" }), _jsx(_components.td, { children: "VARCHAR" }), _jsx(_components.td, { children: "java.lang.String" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "FixedString" }), _jsx(_components.td, { children: "VARCHAR" }), _jsx(_components.td, { children: "java.lang.String" })] })] })] }), _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "String" }), " solo se puede leer como ", _jsx(_components.code, { children: "java.lang.String" }), " o ", _jsx(_components.code, { children: "byte[]" }), "."] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "FixedString" }), " se lee tal cual y se rellena con ceros hasta alcanzar la longitud de la columna. (Por ejemplo, ", _jsx(_components.code, { children: "FixedString(10)" }), " para ", _jsx(_components.code, { children: "'John'" }), " se leerá como ", _jsx(_components.code, { children: "'John\\0\\0\\0\\0\\0\\0\\0\\0\\0'" }), ".)"] }), "\n"] }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Tipos enum" }) }), _jsxs(Table, { children: [_jsx(_components.thead, { children: _jsxs(_components.tr, { children: [_jsx(_components.th, { children: "Tipo de ClickHouse" }), _jsx(_components.th, { children: "Tipo JDBC" }), _jsx(_components.th, { children: "Clase Java" })] }) }), _jsxs(_components.tbody, { children: [_jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Enum8" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.lang.String" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Enum16" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.lang.String" })] })] })] }), _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "Enum8" }), " y ", _jsx(_components.code, { children: "Enum16" }), " se asignan a ", _jsx(_components.code, { children: "java.lang.String" }), " de manera predeterminada."] }), "\n", _jsxs(_components.li, { children: ["Los valores ", _jsx(_components.code, { children: "enum" }), " pueden leerse como valores numéricos mediante el método getter correspondiente o el método ", _jsx(_components.code, { children: "getObject(columnIndex, Integer.class)" }), "."] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "Enum16" }), " se mapea internamente a short y ", _jsx(_components.code, { children: "Enum8" }), " se mapea a byte. Debe evitarse leer ", _jsx(_components.code, { children: "Enum16" }), " como byte debido al riesgo de corrupción de datos."] }), "\n", _jsxs(_components.li, { children: ["Los valores de ", _jsx(_components.code, { children: "enum" }), " pueden establecerse como una cadena o un valor numérico en ", _jsx(_components.code, { children: "PreparedStatement" }), "."] }), "\n"] }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Tipos de fecha/hora" }) }), _jsxs(Table, { children: [_jsx(_components.thead, { children: _jsxs(_components.tr, { children: [_jsx(_components.th, { children: "Tipo de ClickHouse" }), _jsx(_components.th, { children: "Tipo JDBC" }), _jsx(_components.th, { children: "Clase Java" })] }) }), _jsxs(_components.tbody, { children: [_jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Date" }), _jsx(_components.td, { children: "DATE" }), _jsx(_components.td, { children: "java.sql.Date" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Date32" }), _jsx(_components.td, { children: "DATE" }), _jsx(_components.td, { children: "java.sql.Date" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "DateTime" }), _jsx(_components.td, { children: "TIMESTAMP" }), _jsx(_components.td, { children: "java.sql.Timestamp" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "DateTime64" }), _jsx(_components.td, { children: "TIMESTAMP" }), _jsx(_components.td, { children: "java.sql.Timestamp" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Time" }), _jsx(_components.td, { children: "TIME" }), _jsx(_components.td, { children: "java.sql.Time" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Time64" }), _jsx(_components.td, { children: "TIME" }), _jsx(_components.td, { children: "java.sql.Time" })] })] })] }), _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: ["Los tipos Date / Time se asignan a tipos ", _jsx(_components.code, { children: "java.sql" }), " para lograr una mejor compatibilidad con JDBC. Sin embargo, es posible obtener ", _jsx(_components.code, { children: "java.time.LocalDate" }), ", ", _jsx(_components.code, { children: "java.time.LocalDateTime" }), " y ", _jsx(_components.code, { children: "java.time.LocalTime" }), " mediante ", _jsx(_components.code, { children: "ResultSet#getObject(columnIndex, Class)" }), ", usando la clase correspondiente como segundo argumento.", "\n", _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "rs.getObject(1, java.time.LocalDate.class)" }), " devolverá un valor ", _jsx(_components.code, { children: "java.time.LocalDate" }), " de la columna ", _jsx(_components.code, { children: "Date" }), "."] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "rs.getObject(1, java.time.LocalDateTime.class)" }), " devolverá un valor ", _jsx(_components.code, { children: "java.time.LocalDateTime" }), " de la columna ", _jsx(_components.code, { children: "DateTime" }), "."] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "rs.getObject(1, java.time.LocalTime.class)" }), " devolverá un valor ", _jsx(_components.code, { children: "java.time.LocalTime" }), " de la columna ", _jsx(_components.code, { children: "Time" }), "."] }), "\n"] }), "\n"] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "Date" }), ", ", _jsx(_components.code, { children: "Date32" }), ", ", _jsx(_components.code, { children: "Time" }), ", ", _jsx(_components.code, { children: "Time64" }), " no se ven afectados por la zona horaria del servidor."] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "DateTime" }), " y ", _jsx(_components.code, { children: "DateTime64" }), " se ven afectados por la zona horaria del servidor o de la sesión."] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "DateTime" }), " y ", _jsx(_components.code, { children: "DateTime64" }), " se pueden recuperar como ", _jsx(_components.code, { children: "ZonedDateTime" }), " mediante ", _jsx(_components.code, { children: "getObject(colIndex, ZonedDateTime.class)" }), "."] }), "\n"] }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Tipos anidados" }) }), _jsxs(Table, { children: [_jsx(_components.thead, { children: _jsxs(_components.tr, { children: [_jsx(_components.th, { children: "Tipo de ClickHouse" }), _jsx(_components.th, { children: "Tipo JDBC" }), _jsx(_components.th, { children: "Clase Java" })] }) }), _jsxs(_components.tbody, { children: [_jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Array" }), _jsx(_components.td, { children: "ARRAY" }), _jsx(_components.td, { children: "java.sql.Array" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Tuple" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "com.clickhouse.data.Tuple" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Map" }), _jsx(_components.td, { children: "JAVA_OBJECT" }), _jsx(_components.td, { children: "java.util.Map" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Nested" }), _jsx(_components.td, { children: "ARRAY" }), _jsx(_components.td, { children: "java.sql.Array" })] })] })] }), _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "Array" }), " se asigna a ", _jsx(_components.code, { children: "java.sql.Array" }), " de forma predeterminada para mantener la compatibilidad con JDBC. Esto también se hace para proporcionar más información sobre el valor de array devuelto. Resulta útil para la inferencia de tipos."] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "Array" }), " implementa el método ", _jsx(_components.code, { children: "getResultSet()" }), " para devolver un ", _jsx(_components.code, { children: "java.sql.ResultSet" }), " con el mismo contenido que el array original."] }), "\n", _jsxs(_components.li, { children: ["Los tipos de colección no deberían interpretarse como ", _jsx(_components.code, { children: "java.lang.String" }), ", ya que no es una forma válida de representar los datos (p. ej., en un array no se usan comillas para los valores de cadena)."] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "Map" }), " se asigna a ", _jsx(_components.code, { children: "JAVA_OBJECT" }), " porque el valor solo puede leerse con el método ", _jsx(_components.code, { children: "getObject(columnIndex, Class)" }), ".", "\n", _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "Map" }), " no es un ", _jsx(_components.code, { children: "java.sql.Struct" }), " porque no tiene columnas con nombres."] }), "\n"] }), "\n"] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "Tuple" }), " se mapea a ", _jsx(_components.code, { children: "Object[]" }), " porque puede contener distintos tipos y no es válido usar ", _jsx(_components.code, { children: "List" }), "."] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "Tuple" }), " puede leerse como ", _jsx(_components.code, { children: "Array" }), " mediante el método ", _jsx(_components.code, { children: "getObject(columnIndex, Array.class)" }), ". En este caso, ", _jsx(_components.code, { children: "Array#baseTypeName" }), " devolverá la definición de la columna ", _jsx(_components.code, { children: "Tuple" }), "."] }), "\n"] }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Escritura de Arrays" }) }), _jsxs(_components.p, { children: ["Use ", _jsx(_components.code, { children: "java.sql.Connection#createArrayOf" }), " para instanciar el objeto ", _jsx(_components.code, { children: "java.sql.Array" }), ". Este objeto está diseñado para unificar el manejo de arrays en distintas bases de datos.\nSe necesita una conexión para pasar la configuración al método de fábrica de Array."] }), _jsx(_components.p, { children: "El método acepta dos argumentos:" }), _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "typeName" }), " - nombre del tipo de los elementos del array. Por ejemplo, ", _jsx(_components.code, { children: "Array(Int32)" }), " -> ", _jsx(_components.code, { children: "\"Int32\"" }), "."] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "elements" }), " - los elementos reales del array. Por ejemplo ", _jsx(_components.code, { children: "[[1, 2, 3], [4, 5, 6]]" }), " -> ", _jsx(_components.code, { children: "new Integer[][] {{1, 2, 3}, {4, 5, 6}}" }), "."] }), "\n"] }), _jsxs(_components.p, { children: ["Tuple puede representarse como ", _jsx(_components.code, { children: "Object[]" }), " o como ", _jsx(_components.code, { children: "java.sql.Struct" }), " (consulte cómo escribir tuples más adelante)."] }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Ejemplo" }) }), _jsx(CodeBlock, { filename: "", numberOfLines: "7", language: "java", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "java", children: _jsxs(_components.code, { language: "java", numberOfLines: "7", children: [_jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Connection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " ...) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: " Array" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " array" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "createArrayOf" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"Int32\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "new" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#4EC9B0" }, children: " Integer" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "[][] {{" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "1" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "2" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "3" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "}, {" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "4" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "5" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "6" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "}});" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "PreparedStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "prepareStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"INSERT INTO mytable (arr) VALUES (?)\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ")) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setArray" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "1" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", array);" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "executeUpdate" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "();" })] }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " }" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "}" }) }), "\n"] }) }) }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Lectura de Arrays" }) }), _jsxs(_components.p, { children: ["Use ", _jsx(_components.code, { children: "ResultSet#getArray(columnIndex)" }), " para leer un objeto ", _jsx(_components.code, { children: "Array" }), ". El objeto puede utilizarse para acceder a arrays de cualquier profundidad de anidamiento.\nEl método ", _jsx(_components.code, { children: "Array#getResultSet()" }), " puede emplearse para leer los elementos del array de forma más uniforme como ", _jsx(_components.code, { children: "java.sql.ResultSet" }), ". Resulta útil\ncuando se desconoce el tipo exacto de los elementos del array."] }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Ejemplo" }) }), _jsx(CodeBlock, { filename: "", numberOfLines: "19", language: "java", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "java", children: _jsxs(_components.code, { language: "java", numberOfLines: "19", children: [_jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Connection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " ...) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "PreparedStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "prepareStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"SELECT ?::Array(Int32)\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ")) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setArray" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "1" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", array);" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "ResultSet" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " rs" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "executeQuery" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "()) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " while" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "rs" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "next" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "()) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: " Array" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " array" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " rs" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "getArray" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "1" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ");" })] }), "\n", _jsx(_components.span, { className: "line" }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#4EC9B0" }, children: " Object" }), _jsx(_components.span, { style: { color: "#953800", "--shiki-dark": "#D4D4D4" }, children: "[] " }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "arr" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#4EC9B0" }, children: "Object" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "[]) array;" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " Arrays" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "stream" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(arr)." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "forEach" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#569CD6" }, children: "this" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "::" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "handleArrayElement);" })] }), "\n", _jsx(_components.span, { className: "line" }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: " // o mediante `ResultSet`" }) }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: " ResultSet" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " resultSet" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " array" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "getResultSet" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "();" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " while" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "resultSet" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "next" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "()) {" })] }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: " // ..." }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " }" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " }" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " }" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " } " }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "}" }) }), "\n"] }) }) }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Escritura de Tuples" }) }), _jsxs(_components.p, { children: ["Los Tuples se mapean al objeto ", _jsx(_components.code, { children: "com.clickhouse.data.Tuple" }), " y deben escribirse como dicho objeto mediante una llamada al método ", _jsx(_components.code, { children: "setObject(columnIndex, tuple)" }), ".\nEs posible usar el objeto ", _jsx(_components.code, { children: "java.sql.Struct" }), " para escribir tuples con mayor portabilidad."] }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Ejemplo" }) }), _jsx(CodeBlock, { filename: "", numberOfLines: "15", language: "java", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "java", children: _jsxs(_components.code, { language: "java", numberOfLines: "15", children: [_jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Connection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " ...) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: " Tuple" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " tuple" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " new" }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: " Tuple" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "1" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"test\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "LocalDate" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "parse" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"2026-03-02\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "));" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "PreparedStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "prepareStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"INSERT INTO mytable (tuple) VALUES (?)\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ")) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setObject" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "1" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", tuple);" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "executeUpdate" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "();" })] }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " }" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "}" }) }), "\n", _jsx(_components.span, { className: "line" }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Connection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " ...) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: " Struct" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " struct" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "createStruct" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"Tuple(Int32, String, Date)\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "new" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#4EC9B0" }, children: " Object" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "[] {" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "1" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"test\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "LocalDate" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "parse" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"2026-03-02\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ")});" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "PreparedStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "prepareStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"INSERT INTO mytable (tuple) VALUES (?)\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ")) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setStruct" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "1" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", struct);" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "executeUpdate" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "();" })] }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " }" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "}" }) }), "\n"] }) }) }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Lectura de Tuples" }) }), _jsxs(_components.p, { children: ["El método ", _jsx(_components.code, { children: "getObject(columnIndex)" }), " devolverá ", _jsx(_components.code, { children: "Object[]" }), ". Los Tuples pueden leerse como ", _jsx(_components.code, { children: "java.sql.Array" }), " mediante el método ", _jsx(_components.code, { children: "getObject(columnIndex, Array.class)" }), "."] }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Ejemplo" }) }), _jsx(CodeBlock, { filename: "", numberOfLines: "13", language: "java", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "java", children: _jsxs(_components.code, { language: "java", numberOfLines: "13", children: [_jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Connection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " ...) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "PreparedStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " stmt" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "prepareStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"SELECT ?::Tuple(String, Int32, Date)\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ")) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: " Array" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " tuple" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "createArrayOf" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"Tuple(String, Int32, Date)\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "new" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#4EC9B0" }, children: " Object" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "[]{" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"test\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "123" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "LocalDate" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "parse" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"2026-03-02\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ")});" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " stmt" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setObject" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "1" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", tuple);" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "ResultSet" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " rs" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " stmt" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "executeQuery" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "()) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " rs" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "next" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "();" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: " Array" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " dbTuple" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " rs" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "getArray" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "1" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ");" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " Assert" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "assertEquals" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(dbTuple, tuple);" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: " Object" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " arr" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " rs" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "getObject" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "1" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ");" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " Assert" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "assertEquals" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(arr, " }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "tuple" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "getArray" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "());" })] }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " }" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " }" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "}" }) }), "\n"] }) }) }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Escritura de Maps" }) }), _jsxs(_components.p, { children: ["Map solo puede escribirse como un objeto ", _jsx(_components.code, { children: "java.collections.Map" }), " porque este tipo requiere pares clave-valor (", _jsx(_components.code, { children: "java.sql.Struct" }), " no admite pares clave-valor)."] }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Ejemplo" }) }), _jsx(CodeBlock, { filename: "", numberOfLines: "9", language: "java", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "java", children: _jsxs(_components.code, { language: "java", numberOfLines: "9", children: [_jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Connection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " ...) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: " Map" }), _jsx(_components.span, { style: { color: "#953800", "--shiki-dark": "#D4D4D4" }, children: "<" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#4EC9B0" }, children: "String" }), _jsx(_components.span, { style: { color: "#953800", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#4EC9B0" }, children: "Integer" }), _jsx(_components.span, { style: { color: "#953800", "--shiki-dark": "#D4D4D4" }, children: "> " }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "map" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " new" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: " HashMap" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "<>();" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " map" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "put" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"key1\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "1" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ");" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " map" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "put" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"key2\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "2" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ");" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "PreparedStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "prepareStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"INSERT INTO mytable (map) VALUES (?)\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ")) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setObject" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "1" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", map);" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "executeUpdate" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "();" })] }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " }" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "}" }) }), "\n"] }) }) }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Lectura de mapas" }) }), _jsxs(_components.p, { children: ["Map puede leerse como un objeto ", _jsx(_components.code, { children: "java.collections.Map" }), " utilizando el método ", _jsx(_components.code, { children: "getObject(columnIndex, Map.class)" }), "."] }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Ejemplo" }) }), _jsx(CodeBlock, { filename: "", numberOfLines: "11", language: "java", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "java", children: _jsxs(_components.code, { language: "java", numberOfLines: "11", children: [_jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Connection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " ...) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "PreparedStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "prepareStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"SELECT ?::Map(String, Int32)\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ")) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setStruct" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "1" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", struct);" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "ResultSet" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " rs" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "executeQuery" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "()) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " while" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "rs" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "next" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "()) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: " Map" }), _jsx(_components.span, { style: { color: "#953800", "--shiki-dark": "#D4D4D4" }, children: "<" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#4EC9B0" }, children: "String" }), _jsx(_components.span, { style: { color: "#953800", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#4EC9B0" }, children: "Integer" }), _jsx(_components.span, { style: { color: "#953800", "--shiki-dark": "#D4D4D4" }, children: "> " }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "map" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " rs" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "getObject" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "1" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "Map" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "class" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ");" })] }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: " // ..." }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " }" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " }" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " }" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "}" }) }), "\n"] }) }) }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Escritura anidada" }) }), _jsxs(_components.p, { children: ["Utilice ", _jsx(_components.code, { children: "java.sql.Connection#createStruct" }), " para instanciar el objeto ", _jsx(_components.code, { children: "java.sql.Struct" }), ". Este objeto está diseñado para unificar el manejo de estructuras anidadas en distintas bases de datos.\nSe necesita una conexión para pasar la configuración al método de fábrica de Struct."] }), _jsx(_components.p, { children: "El método acepta dos argumentos:" }), _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "typeName" }), " - nombre del tipo de los elementos anidados. Por ejemplo, ", _jsx(_components.code, { children: "Nested(Tuple(Int32, String))" }), " -> ", _jsx(_components.code, { children: "\"Nested(Tuple(Int32, String))\"" }), "."] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "elements" }), " - los elementos anidados propiamente dichos. Por ejemplo ", _jsx(_components.code, { children: "[1, 'test']" }), " -> ", _jsx(_components.code, { children: "new Object[] {1, 'test'}" }), "."] }), "\n"] }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Ejemplo" }) }), _jsx(CodeBlock, { filename: "", numberOfLines: "7", language: "java", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "java", children: _jsxs(_components.code, { language: "java", numberOfLines: "7", children: [_jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Connection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " ...) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: " Struct" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " struct" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "createStruct" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"Nested(Tuple(Int32, String))\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "new" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#4EC9B0" }, children: " Object" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "[] {" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "1" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "'test'" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "});" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "PreparedStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "prepareStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"INSERT INTO mytable (nested) VALUES (?)\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ")) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setStruct" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "1" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", struct);" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "executeUpdate" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "();" })] }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " }" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "}" }) }), "\n"] }) }) }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Lectura anidada" }) }), _jsxs(_components.p, { children: ["Use ", _jsx(_components.code, { children: "ResultSet#getStruct(columnIndex, StructDescriptor)" }), " para leer el objeto ", _jsx(_components.code, { children: "Nested" }), ". El objeto puede utilizarse para acceder a elementos anidados de cualquier nivel de profundidad.\nEl método ", _jsx(_components.code, { children: "Struct#getResultSet()" }), " puede emplearse para leer elementos anidados de forma más uniforme, como ", _jsx(_components.code, { children: "java.sql.ResultSet" }), ". Resulta útil\ncuando el tipo exacto de los elementos anidados es desconocido."] }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Ejemplo" }) }), _jsx(CodeBlock, { filename: "", numberOfLines: "18", language: "java", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "java", children: _jsxs(_components.code, { language: "java", numberOfLines: "18", children: [_jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Connection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " ...) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "PreparedStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "prepareStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"SELECT ?::Nested(Tuple(Int32, String))\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ")) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setStruct" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "1" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", struct);" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "ResultSet" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " rs" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "executeQuery" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "()) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " while" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "rs" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "next" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "()) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: " Struct" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " struct" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " rs" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "getStruct" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "1" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ");" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#4EC9B0" }, children: " Object" }), _jsx(_components.span, { style: { color: "#953800", "--shiki-dark": "#D4D4D4" }, children: "[] " }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "tuple" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#4EC9B0" }, children: "Object" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "[]) struct;" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " Arrays" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "stream" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(tuple)." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "forEach" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#569CD6" }, children: "this" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "::" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "handleTupleElement);" })] }), "\n", _jsx(_components.span, { className: "line" }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: " // o mediante `ResultSet`" }) }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: " ResultSet" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " resultSet" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " struct" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "getResultSet" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "();" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " while" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "resultSet" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "next" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "()) {" })] }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: " // ..." }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " }" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " }" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " }" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " }" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "}" }) }), "\n"] }) }) }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Geo Types" }) }), _jsxs(Table, { children: [_jsx(_components.thead, { children: _jsxs(_components.tr, { children: [_jsx(_components.th, { children: "Tipo de ClickHouse" }), _jsx(_components.th, { children: "Tipo JDBC" }), _jsx(_components.th, { children: "Clase Java" })] }) }), _jsxs(_components.tbody, { children: [_jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Point" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "double[]" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Ring" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "double[][]" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Polygon" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "double[][][]" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "MultiPolygon" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "double[][][][]" })] })] })] }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Tipos Nullable y LowCardinality" }) }), _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "Nullable" }), " y ", _jsx(_components.code, { children: "LowCardinality" }), " son tipos especiales que envuelven otros tipos."] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "Nullable" }), " afecta a la forma en que se devuelven los nombres de tipo en ", _jsx(_components.code, { children: "ResultSetMetaData" })] }), "\n"] }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Tipos especiales" }) }), _jsxs(Table, { children: [_jsx(_components.thead, { children: _jsxs(_components.tr, { children: [_jsx(_components.th, { children: "Tipo de ClickHouse" }), _jsx(_components.th, { children: "Tipo JDBC" }), _jsx(_components.th, { children: "Clase Java" })] }) }), _jsxs(_components.tbody, { children: [_jsxs(_components.tr, { children: [_jsx(_components.td, { children: "UUID" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.util.UUID" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "IPv4" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.net.Inet4Address" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "IPv6" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.net.Inet6Address" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "JSON" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.lang.String" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "AggregateFunction" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "(representación binaria)" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "SimpleAggregateFunction" }), _jsx(_components.td, { children: "(tipo encapsulado)" }), _jsx(_components.td, { children: "(clase encapsulada)" })] })] })] }), _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "UUID" }), " no es un tipo estándar de JDBC. Sin embargo, forma parte del JDK. De forma predeterminada, el método ", _jsx(_components.code, { children: "getObject()" }), " devuelve ", _jsx(_components.code, { children: "java.util.UUID" }), "."] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "UUID" }), " puede leerse y escribirse como ", _jsx(_components.code, { children: "String" }), " mediante el método ", _jsx(_components.code, { children: "getObject(columnIndex, String.class)" }), "."] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "IPv4" }), " e ", _jsx(_components.code, { children: "IPv6" }), " no son tipos estándar de JDBC. Sin embargo, forman parte del JDK. De forma predeterminada, el método ", _jsx(_components.code, { children: "getObject()" }), " devuelve ", _jsx(_components.code, { children: "java.net.Inet4Address" }), " y ", _jsx(_components.code, { children: "java.net.Inet6Address" }), "."] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "IPv4" }), " y ", _jsx(_components.code, { children: "IPv6" }), " se pueden leer y escribir como ", _jsx(_components.code, { children: "String" }), " mediante el método ", _jsx(_components.code, { children: "getObject(columnIndex, String.class)" }), "."] }), "\n"] }), _jsx(Heading, { level: "3", id: "manejo-de-fechas%2C-horas-y-zonas-horarias", children: "Manejo de fechas, horas y zonas horarias" }), _jsxs(_components.p, { children: ["Lea la ", _jsx(_components.a, { href: "/es/integrations/language-clients/java/date-time-guide", children: "Guía de Date/Time" }), ", que explica los errores más comunes\ny la lógica del driver al gestionar valores de Date/Time y timestamps."] }), _jsx(Heading, { level: "2", id: "creaci%C3%B3n-de-conexi%C3%B3n", children: "Creación de conexión" }), _jsx(CodeBlock, { filename: "", numberOfLines: "6", language: "java", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "java", children: _jsxs(_components.code, { language: "java", numberOfLines: "6", children: [_jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "String" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " url" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: " \"jdbc:ch://my-server:8123/system\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ";" })] }), "\n", _jsx(_components.span, { className: "line" }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Properties" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " properties" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " new" }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: " Properties" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "();" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "DataSource" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " dataSource" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " new" }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: " DataSource" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(url, properties);" }), _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: "//DataSource o DriverManager son los puntos de entrada principales" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Connection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " dataSource" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "getConnection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "()) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "... " }), _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: "// hacer algo con la conexión" })] }), "\n"] }) }) }), _jsx(Heading, { level: "2", id: "suministro-de-credenciales-y-configuraci%C3%B3n", children: "Suministro de credenciales y configuración" }), _jsx(CodeBlock, { filename: "showLineNumbers", numberOfLines: "17", language: "java", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "java", children: _jsxs(_components.code, { language: "java", numberOfLines: "17", children: [_jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "String" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " url" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: " \"jdbc:ch://localhost:8123?jdbc_ignore_unsupported_values=true&socket_timeout=10\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ";" })] }), "\n", _jsx(_components.span, { className: "line" }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Properties" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " info" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " new" }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: " Properties" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "();" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "info" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "put" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"user\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"default\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ");" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "info" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "put" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"password\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"password\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ");" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "info" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "put" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"database\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"some_db\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ");" })] }), "\n", _jsx(_components.span, { className: "line" }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: "//Creando una conexión con DataSource" }) }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "DataSource" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " dataSource" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " new" }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: " DataSource" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(url, info);" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Connection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " dataSource" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "getConnection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "()) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "... " }), _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: "// do something with the connection" })] }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "}" }) }), "\n", _jsx(_components.span, { className: "line" }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: "//Enfoque alternativo con DriverManager" }) }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Connection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " DriverManager" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "getConnection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(url, info)) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "... " }), _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: "// do something with the connection" })] }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "}" }) }), "\n"] }) }) }), _jsx(Heading, { level: "2", id: "instrucci%C3%B3n-simple", children: "Instrucción simple" }), _jsx(CodeBlock, { filename: "showLineNumbers", numberOfLines: "7", language: "java", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "java", children: _jsxs(_components.code, { language: "java", numberOfLines: "7", children: [_jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Connection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " dataSource" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "getConnection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(...);" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: " Statement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " stmt" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "createStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "()) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: " ResultSet" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " rs" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " stmt" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "executeQuery" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"select * from numbers(50000)\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ");" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " while" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "rs" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "next" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "()) {" })] }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: " // ..." }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " }" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "}" }) }), "\n"] }) }) }), _jsx(Heading, { level: "2", id: "insert", children: "Insert" }), _jsx(CodeBlock, { filename: "showLineNumbers", numberOfLines: "7", language: "java", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "java", children: _jsxs(_components.code, { language: "java", numberOfLines: "7", children: [_jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "PreparedStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "prepareStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"INSERT INTO mytable VALUES (?, ?)\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ")) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setString" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "1" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"test\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "); " }), _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: "// id" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setObject" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "2" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "LocalDateTime" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "now" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "()); " }), _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: "// marca de tiempo" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "addBatch" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "();" })] }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " ..." }) }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ps" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "executeBatch" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(); " }), _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: "// enviar todo lo disponible a ClickHouse" })] }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "}" }) }), "\n"] }) }) }), _jsx(Heading, { level: "2", id: "hikaricp", children: _jsx(_components.code, { children: "HikariCP" }) }), _jsx(CodeBlock, { filename: "showLineNumbers", numberOfLines: "18", language: "java", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "java", children: _jsxs(_components.code, { language: "java", numberOfLines: "18", children: [_jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: "// el connection pooling no ayudará mucho en términos de rendimiento," }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: "// porque la implementación subyacente tiene su propio pool." }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: "// por ejemplo: HttpURLConnection tiene un pool para sockets" }) }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "HikariConfig" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " poolConfig" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " new" }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: " HikariConfig" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "();" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "poolConfig" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setConnectionTimeout" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "5000L" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ");" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "poolConfig" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setMaximumPoolSize" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "20" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ");" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "poolConfig" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setMaxLifetime" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "300_000L" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ");" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "poolConfig" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setDataSource" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "new" }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: " ClickHouseDataSource" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(url, properties));" })] }), "\n", _jsx(_components.span, { className: "line" }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "HikariDataSource" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ds" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " new" }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: " HikariDataSource" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(poolConfig);" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: " Connection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " ds" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "getConnection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "();" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: " Statement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " s" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "createStatement" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "();" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: " ResultSet" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " rs" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " s" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "executeQuery" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"SELECT * FROM system.numbers LIMIT 3\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ")) {" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " while" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "rs" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "next" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "()) {" })] }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: " // procesar fila" }) }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " log" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "info" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"Integer: {}, String: {}\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "rs" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "getInt" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "1" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "), " }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "rs" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "getString" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#B5CEA8" }, children: "1" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "));" }), _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: "//Misma columna pero diferentes tipos" })] }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " }" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "}" }) }), "\n"] }) }) }), _jsx(Heading, { level: "2", id: "m%C3%A1s-informaci%C3%B3n", children: "Más información" }), _jsxs(_components.p, { children: ["Para más información, consulte nuestro ", _jsx(_components.a, { href: "https://github.com/ClickHouse/clickhouse-java", children: "repositorio de GitHub" }), " y la ", _jsx(_components.a, { href: "/es/integrations/language-clients/java/client", children: "documentación del cliente de Java" }), "."] }), _jsx(Heading, { level: "2", id: "soluci%C3%B3n-de-problemas", children: "Solución de problemas" }), _jsx(Heading, { level: "3", id: "registro", children: "Registro" }), _jsxs(_components.p, { children: ["El driver utiliza ", _jsx(_components.a, { href: "https://www.slf4j.org/", children: "slf4j" }), " para el logging y usará la primera implementación disponible en el ", _jsx(_components.code, { children: "classpath" }), "."] }), _jsx(Heading, { level: "3", id: "resoluci%C3%B3n-de-timeout-de-jdbc-en-inserts-de-gran-volumen", children: "Resolución de timeout de JDBC en inserts de gran volumen" }), _jsx(_components.p, { children: "Al realizar inserciones grandes en ClickHouse con tiempos de ejecución prolongados, es posible que encuentre errores de timeout de JDBC como los siguientes:" }), _jsx(CodeBlock, { filename: "", numberOfLines: "2", language: "text", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "text", children: _jsxs(_components.code, { language: "text", numberOfLines: "2", children: [_jsx(_components.span, { className: "line", children: _jsx(_components.span, { children: "Caused by: java.sql.SQLException: Read timed out, server myHostname [uri=https://hostname.aws.clickhouse.cloud:8443]" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, {}) })] }) }) }), _jsx(_components.p, { children: "Estos errores pueden interrumpir el proceso de inserción de datos y afectar la estabilidad del sistema. Para resolver este problema, es posible que necesite ajustar algunas configuraciones de timeout en el sistema operativo del cliente." }), _jsx(Heading, { level: "4", id: "mac-os", children: "Mac OS" }), _jsx(_components.p, { children: "En Mac OS, se pueden ajustar los siguientes parámetros para resolver el problema:" }), _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "net.inet.tcp.keepidle" }), ": 60000"] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "net.inet.tcp.keepintvl" }), ": 45000"] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "net.inet.tcp.keepinit" }), ": 45000"] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "net.inet.tcp.keepcnt" }), ": 8"] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "net.inet.tcp.always_keepalive" }), ": 1"] }), "\n"] }), _jsx(Heading, { level: "4", id: "linux", children: "Linux" }), _jsx(_components.p, { children: "En Linux, la configuración equivalente por sí sola puede no resolver el problema. Se requieren pasos adicionales debido a las diferencias en la forma en que Linux gestiona la configuración de keep-alive de los sockets. Siga estos pasos:" }), _jsxs(_components.ol, { children: ["\n", _jsxs(_components.li, { children: ["Ajuste los siguientes parámetros del kernel de Linux en ", _jsx(_components.code, { children: "/etc/sysctl.conf" }), " o en un archivo de configuración relacionado:"] }), "\n"] }), _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "net.inet.tcp.keepidle" }), ": 60000"] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "net.inet.tcp.keepintvl" }), ": 45000"] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "net.inet.tcp.keepinit" }), ": 45000"] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "net.inet.tcp.keepcnt" }), ": 8"] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "net.inet.tcp.always_keepalive" }), ": 1"] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "net.ipv4.tcp_keepalive_intvl" }), ": 75"] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "net.ipv4.tcp_keepalive_probes" }), ": 9"] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "net.ipv4.tcp_keepalive_time" }), ": 60 (Puede considerar reducir este valor desde el valor predeterminado de 300 segundos)"] }), "\n"] }), _jsxs(_components.ol, { start: "2", children: ["\n", _jsx(_components.li, { children: "Después de modificar los parámetros del kernel, aplique los cambios ejecutando el siguiente comando:" }), "\n"] }), _jsx(CodeBlock, { filename: "", numberOfLines: "1", language: "shellscript", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "shellscript", children: _jsxs(_components.code, { language: "shellscript", numberOfLines: "1", children: [_jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#953800", "--shiki-dark": "#DCDCAA" }, children: "sudo" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: " sysctl" }), _jsx(_components.span, { style: { color: "#0550AE", "--shiki-dark": "#569CD6" }, children: " -p" })] }), "\n"] }) }) }), _jsx(_components.p, { children: "Tras configurar estos parámetros, debe asegurarse de que su cliente tenga habilitada la opción Keep Alive en el socket:" }), _jsx(CodeBlock, { filename: "", numberOfLines: "1", language: "java", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "java", children: _jsxs(_components.code, { language: "java", numberOfLines: "1", children: [_jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "properties" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setProperty" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"socket_keepalive\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"true\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ");" })] }), "\n"] }) }) }), _jsx(Heading, { level: "2", id: "gu%C3%ADa-de-migraci%C3%B3n", children: "Guía de migración" }), _jsx(Heading, { level: "3", id: "cambios-principales", children: "Cambios principales" }), _jsxs(Table, { children: [_jsx(_components.thead, { children: _jsxs(_components.tr, { children: [_jsx(_components.th, { children: "Función" }), _jsx(_components.th, { children: "V1 (anterior)" }), _jsx(_components.th, { children: "V2 (nueva)" })] }) }), _jsxs(_components.tbody, { children: [_jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Compatibilidad con transacciones" }), _jsx(_components.td, { children: "Compatibilidad parcial" }), _jsx(_components.td, { children: "No compatible" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Cambio de nombre de columnas en la respuesta" }), _jsx(_components.td, { children: "Compatibilidad parcial" }), _jsx(_components.td, { children: "No compatible" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "SQL con múltiples sentencias" }), _jsx(_components.td, { children: "No compatible" }), _jsx(_components.td, { children: "No permitido" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Parámetros con nombre" }), _jsx(_components.td, { children: "Compatible" }), _jsx(_components.td, { children: "No compatible (no forma parte de la especificación JDBC)" })] }), _jsxs(_components.tr, { children: [_jsxs(_components.td, { children: ["Transmisión de datos con ", _jsx(_components.code, { children: "PreparedStatement" })] }), _jsx(_components.td, { children: "Compatible" }), _jsx(_components.td, { children: "No compatible" })] })] })] }), _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: ["JDBC V2 se ha implementado para que sea más ligero y se han eliminado algunas funcionalidades.", "\n", _jsxs(_components.ul, { children: ["\n", _jsx(_components.li, { children: "El streaming de datos no es compatible con JDBC V2 porque no forma parte de la especificación de JDBC ni de Java." }), "\n"] }), "\n"] }), "\n", _jsxs(_components.li, { children: ["JDBC V2 requiere una configuración explícita. No hay valores predeterminados para failover.", "\n", _jsxs(_components.ul, { children: ["\n", _jsx(_components.li, { children: "El protocolo debe especificarse en la URL. No se detecta implícitamente a partir de los números de puerto." }), "\n"] }), "\n"] }), "\n"] }), _jsx(Heading, { level: "3", id: "cambios-de-configuraci%C3%B3n", children: "Cambios de configuración" }), _jsx(_components.p, { children: "Solo hay dos enums:" }), _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "com.clickhouse.jdbc.DriverProperties" }), " - las propiedades de configuración del propio driver."] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "com.clickhouse.client.api.ClientConfigProperties" }), " - las propiedades de configuración del cliente. Los cambios en la configuración del cliente\nse describen en la ", _jsx(_components.a, { href: "/es/integrations/language-clients/java/client#migration_from_v1_config", children: "documentación del cliente Java" }), "."] }), "\n"] }), _jsx(_components.p, { children: "Las propiedades de conexión se procesan de la siguiente manera:" }), _jsxs(_components.ul, { children: ["\n", _jsx(_components.li, { children: "La URL se procesa primero para extraer las propiedades. Estas prevalecen sobre todas las demás propiedades." }), "\n", _jsx(_components.li, { children: "Las propiedades del driver no se pasan al cliente." }), "\n", _jsx(_components.li, { children: "Los endpoints (host, port, protocol) se extraen de la URL." }), "\n"] }), _jsx(_components.p, { children: "Ejemplo:" }), _jsx(CodeBlock, { filename: "", numberOfLines: "11", language: "java", children: _jsx(_components.pre, { className: "shiki shiki-themes github-light-default dark-plus", style: { backgroundColor: "#ffffff", "--shiki-dark-bg": "#0B0C0E", color: "#1f2328", "--shiki-dark": "#D4D4D4" }, language: "java", children: _jsxs(_components.code, { language: "java", numberOfLines: "11", children: [_jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "String" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " url" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: " \"jdbc:ch://my-server:8443/default?\"" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " +" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: " \"jdbc_ignore_unsupported_values=true&\"" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " +" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: " \"socket_rcvbuf=800000\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ";" })] }), "\n", _jsx(_components.span, { className: "line" }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Properties" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " properties" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: " new" }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: " Properties" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "();" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: "properties" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "setProperty" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(" }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"socket_rcvbuf\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ", " }), _jsx(_components.span, { style: { color: "#0A3069", "--shiki-dark": "#CE9178" }, children: "\"900000\"" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: ");" })] }), "\n", _jsxs(_components.span, { className: "line", children: [_jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#C586C0" }, children: "try" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: " (" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#4EC9B0" }, children: "Connection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " conn" }), _jsx(_components.span, { style: { color: "#CF222E", "--shiki-dark": "#D4D4D4" }, children: " =" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#9CDCFE" }, children: " DriverManager" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "." }), _jsx(_components.span, { style: { color: "#8250DF", "--shiki-dark": "#DCDCAA" }, children: "getConnection" }), _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "(url, properties)) {" })] }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: " // La conexión usará socket_rcvbuf=800000 y jdbc_ignore_unsupported_values=true" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: " // Endpoints: my-server:8443 protocol: http (no seguro)" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#6E7781", "--shiki-dark": "#6A9955" }, children: " // Base de datos: default" }) }), "\n", _jsx(_components.span, { className: "line", children: _jsx(_components.span, { style: { color: "#1F2328", "--shiki-dark": "#D4D4D4" }, children: "}" }) }), "\n"] }) }) }), _jsx(Heading, { level: "3", id: "cambios-en-los-tipos-de-datos", children: "Cambios en los tipos de datos" }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Tipos numéricos" }) }), _jsxs(Table, { children: [_jsx(_components.thead, { children: _jsxs(_components.tr, { children: [_jsx(_components.th, { children: "Tipo de ClickHouse" }), _jsx(_components.th, { children: "Compatible con V1" }), _jsx(_components.th, { children: "Tipo JDBC (V2)" }), _jsx(_components.th, { children: "Clase Java (V2)" }), _jsx(_components.th, { children: "Tipo JDBC (V1)" }), _jsx(_components.th, { children: "Clase Java (V1)" })] }) }), _jsxs(_components.tbody, { children: [_jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Int8" }), _jsx(_components.td, { children: "✅" }), _jsx(_components.td, { children: "TINYINT" }), _jsx(_components.td, { children: "java.lang.Byte" }), _jsx(_components.td, { children: "TINYINT" }), _jsx(_components.td, { children: "java.lang.Byte" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Int16" }), _jsx(_components.td, { children: "✅" }), _jsx(_components.td, { children: "SMALLINT" }), _jsx(_components.td, { children: "java.lang.Short" }), _jsx(_components.td, { children: "SMALLINT" }), _jsx(_components.td, { children: "java.lang.Short" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Int32" }), _jsx(_components.td, { children: "✅" }), _jsx(_components.td, { children: "INTEGER" }), _jsx(_components.td, { children: "java.lang.Integer" }), _jsx(_components.td, { children: "INTEGER" }), _jsx(_components.td, { children: "java.lang.Integer" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Int64" }), _jsx(_components.td, { children: "✅" }), _jsx(_components.td, { children: "BIGINT" }), _jsx(_components.td, { children: "java.lang.Long" }), _jsx(_components.td, { children: "BIGINT" }), _jsx(_components.td, { children: "java.lang.Long" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Int128" }), _jsx(_components.td, { children: "✅" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.math.BigInteger" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.math.BigInteger" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Int256" }), _jsx(_components.td, { children: "✅" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.math.BigInteger" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.math.BigInteger" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "UInt8" }), _jsx(_components.td, { children: "❌" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.lang.Short" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "com.clickhouse.data.value.UnsignedByte" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "UInt16" }), _jsx(_components.td, { children: "❌" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.lang.Integer" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "com.clickhouse.data.value.UnsignedShort" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "UInt32" }), _jsx(_components.td, { children: "❌" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.lang.Long" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "com.clickhouse.data.value.UnsignedInteger" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "UInt64" }), _jsx(_components.td, { children: "❌" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.math.BigInteger" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "com.clickhouse.data.value.UnsignedLong" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "UInt128" }), _jsx(_components.td, { children: "✅" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.math.BigInteger" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.math.BigInteger" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "UInt256" }), _jsx(_components.td, { children: "✅" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.math.BigInteger" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.math.BigInteger" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Float32" }), _jsx(_components.td, { children: "✅" }), _jsx(_components.td, { children: "REAL" }), _jsx(_components.td, { children: "java.lang.Float" }), _jsx(_components.td, { children: "REAL" }), _jsx(_components.td, { children: "java.lang.Float" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Float64" }), _jsx(_components.td, { children: "✅" }), _jsx(_components.td, { children: "DOUBLE" }), _jsx(_components.td, { children: "java.lang.Double" }), _jsx(_components.td, { children: "DOUBLE" }), _jsx(_components.td, { children: "java.lang.Double" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Decimal32" }), _jsx(_components.td, { children: "✅" }), _jsx(_components.td, { children: "DECIMAL" }), _jsx(_components.td, { children: "java.math.BigDecimal" }), _jsx(_components.td, { children: "DECIMAL" }), _jsx(_components.td, { children: "java.math.BigDecimal" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Decimal64" }), _jsx(_components.td, { children: "✅" }), _jsx(_components.td, { children: "DECIMAL" }), _jsx(_components.td, { children: "java.math.BigDecimal" }), _jsx(_components.td, { children: "DECIMAL" }), _jsx(_components.td, { children: "java.math.BigDecimal" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Decimal128" }), _jsx(_components.td, { children: "✅" }), _jsx(_components.td, { children: "DECIMAL" }), _jsx(_components.td, { children: "java.math.BigDecimal" }), _jsx(_components.td, { children: "DECIMAL" }), _jsx(_components.td, { children: "java.math.BigDecimal" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Decimal256" }), _jsx(_components.td, { children: "✅" }), _jsx(_components.td, { children: "DECIMAL" }), _jsx(_components.td, { children: "java.math.BigDecimal" }), _jsx(_components.td, { children: "DECIMAL" }), _jsx(_components.td, { children: "java.math.BigDecimal" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Bool" }), _jsx(_components.td, { children: "✅" }), _jsx(_components.td, { children: "BOOLEAN" }), _jsx(_components.td, { children: "java.lang.Boolean" }), _jsx(_components.td, { children: "BOOLEAN" }), _jsx(_components.td, { children: "java.lang.Boolean" })] })] })] }), _jsxs(_components.ul, { children: ["\n", _jsx(_components.li, { children: "La principal diferencia es que los tipos sin signo se corresponden con tipos de Java para mejorar la portabilidad." }), "\n"] }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Tipos String" }) }), _jsxs(Table, { children: [_jsx(_components.thead, { children: _jsxs(_components.tr, { children: [_jsx(_components.th, { children: "Tipo de dato de ClickHouse" }), _jsx(_components.th, { children: "Compatible con V1" }), _jsx(_components.th, { children: "Tipo JDBC (V2)" }), _jsx(_components.th, { children: "Clase Java (V2)" }), _jsx(_components.th, { children: "Tipo JDBC (V1)" }), _jsx(_components.th, { children: "Clase de Java (V1)" })] }) }), _jsxs(_components.tbody, { children: [_jsxs(_components.tr, { children: [_jsx(_components.td, { children: "String" }), _jsx(_components.td, { children: "✅" }), _jsx(_components.td, { children: "VARCHAR" }), _jsx(_components.td, { children: "java.lang.String" }), _jsx(_components.td, { children: "VARCHAR" }), _jsx(_components.td, { children: "java.lang.String" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "FixedString" }), _jsx(_components.td, { children: "✅" }), _jsx(_components.td, { children: "VARCHAR" }), _jsx(_components.td, { children: "java.lang.String" }), _jsx(_components.td, { children: "VARCHAR" }), _jsx(_components.td, { children: "java.lang.String" })] })] })] }), _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "FixedString" }), " se lee tal cual en ambas versiones. Por ejemplo, ", _jsx(_components.code, { children: "FixedString(10)" }), " para ", _jsx(_components.code, { children: "'John'" }), " se leerá como ", _jsx(_components.code, { children: "'John\\0\\0\\0\\0\\0\\0\\0\\0\\0'" }), "."] }), "\n", _jsxs(_components.li, { children: ["Cuando se utiliza ", _jsx(_components.code, { children: "PreparedStatement#setBytes" }), ", se convierte en ", _jsx(_components.code, { children: "unhex('')" }), " y luego se interpreta como ", _jsx(_components.code, { children: "String" }), "."] }), "\n", _jsx(_components.li, { children: "Las cadenas se almacenan con codificación UTF-8." }), "\n"] }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Tipos de fecha/hora" }) }), _jsxs(Table, { children: [_jsx(_components.thead, { children: _jsxs(_components.tr, { children: [_jsx(_components.th, { children: "Tipo de ClickHouse" }), _jsx(_components.th, { children: "Compatible con V1" }), _jsx(_components.th, { children: "Tipo de JDBC (V2)" }), _jsx(_components.th, { children: "Clase de Java (V2)" }), _jsx(_components.th, { children: "Tipo de JDBC (V1)" }), _jsx(_components.th, { children: "Clase Java (V1)" })] }) }), _jsxs(_components.tbody, { children: [_jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Fecha" }), _jsx(_components.td, { children: "❌" }), _jsx(_components.td, { children: "DATE" }), _jsx(_components.td, { children: "java.sql.Date" }), _jsx(_components.td, { children: "DATE" }), _jsx(_components.td, { children: "java.time.LocalDate" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Date32" }), _jsx(_components.td, { children: "❌" }), _jsx(_components.td, { children: "DATE" }), _jsx(_components.td, { children: "java.sql.Date" }), _jsx(_components.td, { children: "DATE" }), _jsx(_components.td, { children: "java.time.LocalDate" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "DateTime" }), _jsx(_components.td, { children: "❌" }), _jsx(_components.td, { children: "TIMESTAMP" }), _jsx(_components.td, { children: "java.sql.Timestamp" }), _jsx(_components.td, { children: "TIMESTAMP" }), _jsx(_components.td, { children: "java.time.OffsetDateTime" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "DateTime64" }), _jsx(_components.td, { children: "❌" }), _jsx(_components.td, { children: "TIMESTAMP" }), _jsx(_components.td, { children: "java.sql.Timestamp" }), _jsx(_components.td, { children: "TIMESTAMP" }), _jsx(_components.td, { children: "java.time.OffsetDateTime" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Time" }), _jsx(_components.td, { children: "✅" }), _jsx(_components.td, { children: "TIME" }), _jsx(_components.td, { children: "java.sql.Time" }), _jsx(_components.td, { children: "nuevo tipo/no compatible" }), _jsx(_components.td, { children: "nuevo tipo/no compatible" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Time64" }), _jsx(_components.td, { children: "✅" }), _jsx(_components.td, { children: "TIME" }), _jsx(_components.td, { children: "java.sql.Time" }), _jsx(_components.td, { children: "tipo nuevo/no compatible" }), _jsx(_components.td, { children: "tipo nuevo/no compatible" })] })] })] }), _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "Time" }), " y ", _jsx(_components.code, { children: "Time64" }), " solo son compatibles en V2 como tipos nuevos."] }), "\n", _jsxs(_components.li, { children: [_jsx(_components.code, { children: "DateTime" }), " y ", _jsx(_components.code, { children: "DateTime64" }), " se asignan a ", _jsx(_components.code, { children: "java.sql.Timestamp" }), " para mejorar la compatibilidad con JDBC."] }), "\n"] }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Tipos enum" }) }), _jsxs(Table, { children: [_jsx(_components.thead, { children: _jsxs(_components.tr, { children: [_jsx(_components.th, { children: "Tipo de ClickHouse" }), _jsx(_components.th, { children: "Compatible con V1" }), _jsx(_components.th, { children: "Tipo JDBC (V2)" }), _jsx(_components.th, { children: "Clase Java (V2)" }), _jsx(_components.th, { children: "Tipo JDBC (V1)" }), _jsx(_components.th, { children: "Clase Java (V1)" })] }) }), _jsxs(_components.tbody, { children: [_jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Enum" }), _jsx(_components.td, { children: "✅" }), _jsx(_components.td, { children: "VARCHAR" }), _jsx(_components.td, { children: "java.lang.String" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.lang.String" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Enum8" }), _jsx(_components.td, { children: "✅" }), _jsx(_components.td, { children: "VARCHAR" }), _jsx(_components.td, { children: "java.lang.String" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.lang.String" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Enum16" }), _jsx(_components.td, { children: "✅" }), _jsx(_components.td, { children: "VARCHAR" }), _jsx(_components.td, { children: "java.lang.String" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "java.lang.String" })] })] })] }), _jsx(_components.p, { children: _jsx(_components.strong, { children: "Tipos anidados" }) }), _jsxs(Table, { children: [_jsx(_components.thead, { children: _jsxs(_components.tr, { children: [_jsx(_components.th, { children: "Tipo de ClickHouse" }), _jsx(_components.th, { children: "Compatible con V1" }), _jsx(_components.th, { children: "Tipo JDBC (V2)" }), _jsx(_components.th, { children: "Clase Java (V2)" }), _jsx(_components.th, { children: "Tipo JDBC (V1)" }), _jsx(_components.th, { children: "Clase de Java (V1)" })] }) }), _jsxs(_components.tbody, { children: [_jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Array" }), _jsx(_components.td, { children: "❌" }), _jsx(_components.td, { children: "ARRAY" }), _jsx(_components.td, { children: "java.sql.Array" }), _jsx(_components.td, { children: "ARRAY" }), _jsx(_components.td, { children: "Object[] o un array de tipos primitivos" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Tuple" }), _jsx(_components.td, { children: "❌" }), _jsx(_components.td, { children: "OTHER" }), _jsx(_components.td, { children: "Object[]" }), _jsx(_components.td, { children: "STRUCT" }), _jsx(_components.td, { children: "java.sql.Struct" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Map" }), _jsx(_components.td, { children: "❌" }), _jsx(_components.td, { children: "JAVA_OBJECT" }), _jsx(_components.td, { children: "java.util.Map" }), _jsx(_components.td, { children: "STRUCT" }), _jsx(_components.td, { children: "java.util.Map" })] }), _jsxs(_components.tr, { children: [_jsx(_components.td, { children: "Nested" }), _jsx(_components.td, { children: "❌" }), _jsx(_components.td, { children: "ARRAY" }), _jsx(_components.td, { children: "java.sql.Array" }), _jsx(_components.td, { children: "STRUCT" }), _jsx(_components.td, { children: "java.sql.Struct" })] })] })] }), _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: ["En V2, ", _jsx(_components.code, { children: "Array" }), " se asigna a ", _jsx(_components.code, { children: "java.sql.Array" }), " de forma predeterminada para ser compatible con JDBC. Esto también se hace para proporcionar más información sobre el valor de array devuelto. Útil para la inferencia de tipos."] }), "\n", _jsxs(_components.li, { children: ["En V2, ", _jsx(_components.code, { children: "Array" }), " implementa el método ", _jsx(_components.code, { children: "getResultSet()" }), " para devolver un ", _jsx(_components.code, { children: "java.sql.ResultSet" }), " con el mismo contenido que el array original."] }), "\n", _jsxs(_components.li, { children: ["V1 usa ", _jsx(_components.code, { children: "STRUCT" }), " para ", _jsx(_components.code, { children: "Map" }), ", pero siempre devuelve un objeto ", _jsx(_components.code, { children: "java.util.Map" }), ". V2 corrige esto al mapear ", _jsx(_components.code, { children: "Map" }), " a ", _jsx(_components.code, { children: "JAVA_OBJECT" }), "."] }), "\n", _jsxs(_components.li, { children: ["V1 usa ", _jsx(_components.code, { children: "STRUCT" }), " para ", _jsx(_components.code, { children: "Tuple" }), ", pero siempre devuelve un objeto ", _jsx(_components.code, { children: "List