Skip to content

JDBC import database error #3273

@Cinzq4615

Description

@Cinzq4615

What happens?

JDBC import database error

To Reproduce

`@Test
public void importDuckDB() throws SQLException, IOException {

   final String EXPORT_SQL_TEMPLATE = "EXPORT DATABASE '%s' (FORMAT PARQUET);"; 
   String path = "export"; 
   File export = new File(path); 
   if (export.exists()) { 
       export.delete(); 
   } 
   export.mkdir(); 
   System.out.println(export.getAbsolutePath()); 
   try (Connection conn = DriverManager.getConnection("jdbc:duckdb:db001"); Statement stmt = conn.createStatement();) { 
       stmt.execute("CREATE SCHEMA IF NOT EXISTS mydb"); 
       stmt.execute("CREATE TABLE IF NOT EXISTS mydb.student(id INTEGER,name VARCHAR,PRIMARY KEY(id))"); 
       stmt.execute(String.format(EXPORT_SQL_TEMPLATE, path)); 
   } 

   final String IMPORT_SQL_TEMPLATE = "IMPORT DATABASE '%s';"; 

   try (Connection conn = DriverManager.getConnection("jdbc:duckdb:db002"); Statement stmt = conn.createStatement();) { 
       stmt.execute(String.format(IMPORT_SQL_TEMPLATE, path)); 
   } 

}

error info:
java.sql.SQLException: Cannot prepare multiple statements at once!

 at org.duckdb.DuckDBNative.duckdb_jdbc_prepare(Native Method) 
 at org.duckdb.DuckDBPreparedStatement.prepare(DuckDBPreparedStatement.java:73) 
 at org.duckdb.DuckDBPreparedStatement.execute(DuckDBPreparedStatement.java:121)

`

Environment (please complete the following information):

  • OS: win10
  • DuckDB Version: 0.3.1
  • DuckDB Client: jdbc-0.3.1

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions