错误是java.sql.SQLSyntaxErrorException:模式'ROOT'不存在 [英] Error is java.sql.SQLSyntaxErrorException: Schema 'ROOT' does not exist

问题描述

我正在创建使用derby嵌入式数据库的桌面应用程序，尽管当我将derby用作客户端数据库时它可以正常工作，但是我想将此数据库与我的桌面应用程序一起嵌入然后会引发错误 下面是帮助代码，请查看

i am creating desktop application which uses derby embedded database, although when i use derby as a client database then it works fine, but i want to embed this database with my desktop application then it throws error below is the code for help, check it out

public class TaxInvoice extends javax.swing.JFrame {

 //String connectionurl = "jdbc:derby://localhost:1527/embdIDA1db";

 String connectionurl = "jdbc:derby:embdIDA1db;create=true;user=root;password=root";

 Connection conn = null; 

 ResultSet rs;

 String po_no = null;

/**
 * Creates new form TaxInvoice
 */
public TaxInvoice() {
    initComponents();
    String dt = sdf.format(cal.getTime());
    cur_date.setText(dt);
    try{
        Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();
        conn = DriverManager.getConnection(connectionurl,"root","root");
        String sql="Select * from IMPORTED_CSV";
        Statement s = conn.createStatement();
        s.executeQuery(sql);
        rs = s.getResultSet();
        while(rs.next()){
            po_no = rs.getString("PO_NO");
            jTextField1.setText(po_no);
        }
        rs.close();
        s.close();
    }
    catch(Exception e){
        System.out.println("Error is"+e);
    }
}

，错误是

Error isjava.sql.SQLSyntaxErrorException: Schema 'ROOT' does not exist

推荐答案

您的connectionURl应该为jdbc:derby://localhost:1527/embdIDA1db，这似乎在您的代码中已被注释掉.

Your connectionURl should be jdbc:derby://localhost:1527/embdIDA1db which seems to be commented out in your code.

您正在显式传递用户名和密码，因此无需在url中包含它们.

Your are passing username and password explicitly so there is no need to include them in url.

DriverManager.getConnection(connectionurl,"root","root");

这篇关于错误是java.sql.SQLSyntaxErrorException:模式'ROOT'不存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！