Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Sabrina,
sry for the late reply. I am using JDK 20 and this is the error that i am getting. However i should note that it might be related to the following issue: Save Failed!
What worked was the following function, which i executed in a tJavaRow component:
package routines;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
//import javax.naming.Context;
public class uploadData {
public static void main(String jdbcUrl, String user, String password, String database,
String warehouse, String schema, String table, String CATEGORY, Integer CNT) {
try {
Class.forName("net.snowflake.client.jdbc.SnowflakeDriver");
Connection connection = DriverManager.getConnection(jdbcUrl, user, password);
String insertQuery = "INSERT INTO " + database + "." + schema + "." + table + " (CATEGORY, CNT) VALUES (?, ?)";
PreparedStatement preparedStatement = connection.prepareStatement(insertQuery);
preparedStatement.setString(1, CATEGORY);
preparedStatement.setInt(2, CNT);
int rowsInserted = preparedStatement.executeUpdate();
System.out.println(rowsInserted + " row(s) inserted.");
preparedStatement.close();
connection.close();
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
}
}
However it did require the addition of the tLibraryLoad component (which i got from another discussion):
The error log file is attatch in the file attached to this post.