Creating Table in AWS Redshift with AWS Java SDK

Question

I am trying to create a temporary table inside of AWS redshift using the java SDK.

 // Redshift JDBC 4.1 driver: com.amazon.redshift.jdbc41.Driver
 String command = "CREATE TABLE test (FirstName varchar(255));"
 Class.forName("com.amazon.redshift.jdbc41.Driver");
 conn = DriverManager.getConnection(dbURL, props);
 stmt = conn.createStatement();
 ResultSet rs = stmt.executeQuery(command);

When running this code the table is created successfully but on the return, an error is thrown

com.amazon.dsi.dataengine.impl.DSISimpleRowCountResult cannot be cast to com.amazon.dsi.dataengine.interfaces.IResultSet

Everything will work if I use a command that returns something, such as

"Select * FROM test;" 
"SELECT * FROM test LIMIT 0;"

I didn't see any documentation for this problem in the AWS READMEs or other stack overflow questions for this problem. It seems to me that there is a special class in the driver for when nothing is returned from the statement that is not able to be cast to the ResultSet class.

The redshift driver version is 1.1.13.1013 .

Any help would be greatly appreciated!

holodoc · Accepted Answer · 2018-05-25 15:10:59Z

2

I had the same problem. You can solve this easily. Instead of

stmt.executeQuery(command);

please try

stmt.execute(command);

answered May 25, 2018 at 15:10

holodoc

871 gold badge2 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Creating Table in AWS Redshift with AWS Java SDK

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related