Create database postgresql using JAVA

Question

I want to create a database PostgreSQL using Java but I got an error message.

Here is my code :

try {
                Connection c=null;
                Statement stmt=null;
                Class.forName("org.postgresql.Driver");
                
                c = DriverManager
            .getConnection("jdbc:postgresql://localhost:5432/",
            "postgres", "Admin@2014");
                
                c.setAutoCommit(false);
                System.out.println("Opened database successfully");
               
                stmt = c.createStatement();
                
               String sql = "CREATE DATABASE db OWNER postgres TABLESPACE numerique; ";
              
                stmt.executeUpdate(sql);    
                
             stmt.close();
                c.commit();
                c.close();
                
            } catch (Exception ee) {
                    System.err.println( ee.getClass().getName()+": "+ ee.getMessage() );
                    System.exit(0);
            }

Here is the error message that I got :

org.postgresql.util.PSQLException: ERREUR: CREATE DATABASE ne peut pas être exécuté dans un bloc de transaction

Thank you for your help.

Your question is very badly written and worded. No code examples, no additional information on your setup, the use of "plz"... Have a look at stackoverflow.com/help/asking first and edit your question please. — DrColossos
– DrColossos, Commented Mar 6, 2014 at 11:27

Yuri · Accepted Answer · 2021-08-18 09:07:22Z

2

Looks like you are trying to create the database inside a transaction, and that is not allowed.

CREATE DATABASE cannot be executed inside a transaction block.

See http://www.postgresql.org/docs/9.1/static/sql-createdatabase.html

But some code sample from your side would help :)

edited Aug 18, 2021 at 9:07

Yuri

4,5482 gold badges32 silver badges48 bronze badges

answered Mar 6, 2014 at 11:37

mihaic

1751 silver badge7 bronze badges

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

Comments

Serhiy · Accepted Answer · 2014-03-06 11:48:21Z

1

Remove c.setAutoCommit(false); and c.commit(); from your code.

answered Mar 6, 2014 at 11:48

Serhiy

4,1413 gold badges39 silver badges66 bronze badges

Collectives™ on Stack Overflow

Create database postgresql using JAVA

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related