Eu estou desenvolvendo um sisteminha, e ele precisa, em um dado momento, criar um database. Veja o codigo:
java.sql.Statement stmt = connection.createStatement();
stmt.executeUpdate(“CREATE DATABASE ‘/opt/interbase/database/banco.gdb’”);
Olhem o erro que esta dando ao executa-lo :
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -530
Cannot prepare a CREATE DATABASE/SCHEMA statement
at org.firebirdsql.jdbc.AbstractStatement.executeUpdate(AbstractStatement.java:203)
at SGBD.CreateDataBase(SGBD.java:353)
at ExecuteSGBD.main(ExecuteSGBD.java:116)
at org.firebirdsql.gds.GDSException: Dynamic SQL Error
SQL error code = -530
Cannot prepare a CREATE DATABASE/SCHEMA statement
at org.firebirdsql.jgds.GDS_Impl.readStatusVector(GDS_Impl.java:1816)
at org.firebirdsql.jgds.GDS_Impl.receiveResponse(GDS_Impl.java:1769)
at org.firebirdsql.jgds.GDS_Impl.isc_dsql_prepare(GDS_Impl.java:1267)
at org.firebirdsql.jca.FBManagedConnection.prepareSQL(FBManagedConnection.java:773)
at org.firebirdsql.jdbc.AbstractConnection.prepareSQL(AbstractConnection.java:958)
at org.firebirdsql.jdbc.AbstractStatement.prepareFixedStatement(AbstractStatement.java:1047)
at org.firebirdsql.jdbc.AbstractStatement.internalExecute(AbstractStatement.java:1029)
at org.firebirdsql.jdbc.AbstractStatement.executeUpdate(AbstractStatement.java:198)
at SGBD.CreateDataBase(SGBD.java:353)
at ExecuteSGBD.main(ExecuteSGBD.java:116)
Obrigado, ateh mais
Bruce