Source
JDBC driver with -Dhttp.nonProxyHosts=* set throws java.lang.StringIndexOutOfBoundsException: begin 1, end 0, length 1
ISSUE: When using the JDBC driver's diagnostics feature (i.e., ENABLE_DIAGNOSTICS=TRUE)1, if the - Dhttp.
Analyzing queries and troubleshooting with Snowpark Java
To inspect the evaluation plan of a DataFrame, call the explain method of the DataFrame. This prints the SQL statements used to evaluate the DataFrame. If there is only one SQL statement, the method also prints the logical plan for the…
JDBC connections requiring a proxy generate 'Encountered exception (connect timed out) during upload' exceptions for PUT operations using downscoped tokens
JDBC connections requiring a proxy generate 'Encountered exception (connect timed out) during upload'…
JDBC driver throws javax.naming.CommunicationException: DNS error (Root exception: java.net.SocketTimeoutException)
…getAttributes(DnsContext.java:434) at java.naming/com.sun.jndi.toolkit.ctx.ComponentDirContext.
Quick reference: Snowpark Java APIs for SQL commands
This topic provides a quick reference of some of the Snowpark APIs that correspond to SQL commands.
JDBC Driver Compatibility Issue With JDK 16 and Later: Exception creating result java.lang.ExceptionInInitializerError at net.snowflake.client.jdbc.internal.apache.arrow.memory.UnsafeAllocationManager
CAUSE: The failure is directly caused by one of the JDBC driver's dependencies, Apache Arrow, when attempting to use reflection in order to access a private member of the java.nio.Buffer class. This was allowed by Java previously, but not…
Logging messages in Java
You can log messages from a function or procedure handler written in Java by using the SLF4J API. When you’ve set up an event table to store log entries, Snowflake stores log entries generated by your handler code in the table.
Enabling JDBC Driver Debugging in DBeaver
# "handlers" specifies a comma - separated list of log Handler # classes. These handlers will be installed during VM startup. # Note that these classes must be on the system classpath.
Error during ETL operations: JAVA PLUGIN_1762 [ERROR] java.lang.OutOfMemoryError: GC overhead limit exceeded
Error during ETL operations: JAVA PLUGIN_1762 [ERROR] java.
Java requirements for the JDBC Driver
The Snowflake JDBC driver requires Java LTS (Long - Term Support) versions 1.8 or higher. If the minimum required version of Java is not installed on the client machines where the JDBC driver is installed, you must install either Oracle Java…