java derby restoreFrom什么也不做 [英] java derby restoreFrom does nothing

问题描述

我是新来的这个论坛（第一篇文章），但我习惯了它上了很多次，找到技巧和一些有用的例子和解决我的问题。

I'm new to this forum (first post) but I used to surf on it a lot of times to find tricks and some useful examples and solutions on my problems.

在发布之前，我已经在网络上搜索关于restoreFromderby数据库命令，我阅读derby管理员，参考指南。

Before posting I have search all over the web about the "restoreFrom" derby database command and I read the derby administrator, the reference guide too.

在我的程序创建，备份和检查整体derby程序，连接，断开服务器和数据库等...但没有办法恢复一些内置程序！

I succesfully use in my program the creation, backup and check intergrity derby procedures, connect, disconnect server and database etc... but no way to restore something with built-in procedure !!!

这里是有问题的代码：有问题？不是因为它不会引发任何错误...

Here is the problematic code : Problematic ? not so much cause it does not throw any error...

try {

    Class.forName("org.apache.derby.jdbc.ClientDriver");
    java.util.Properties props = new java.util.Properties();

    String backup = "." + File.separator + "backup" + File.separator
            + "dbcli";
    System.out.println(backup);

    String nsURL = "jdbc:derby://localhost:1527/dbcli;restoreFrom="
            + backup;
    props.setProperty("user", "root");
    props.setProperty("password", "root");

    dbConnection = DriverManager.getConnection(nsURL, props);
    dbConnection.commit();
    System.out.println("commit");

} catch (SQLException ex) {
    isConnected = false;
    Logger.getLogger(Snapshot.class.getName()).log(Level.SEVERE, null,
            ex);
    System.out.println(isConnected);
} catch (ClassNotFoundException ex) {
    Logger.getLogger(Snapshot.class.getName()).log(Level.SEVERE, null,
            ex);
}

它不返回错误，但数据库不恢复，即使使用完整路径到备份目录...

It returns no error but the database is not restored, even with the full path to backup directory...

我一直在搜索天，任何帮助将是巨大的！

I've been searching for days, any help would be great !!!

最好的问候，谢谢你阅读这个java新手的帖子...： - ）

Best Regards, Thank you for reading this java newbie post... :-)

编辑：问题是存在的。文件夹...我

THE PROBLEM WAS THE PRESENCE OF .SVN FOLDERS.... I'M SO STUPID.... :-) THANKS FOR HELP AND LONG LIFE TO STACKOVERFLOW !!!

推荐答案

我有一个很好的帮助同样的问题，我解决了，关闭它首先数据库和恢复它。
例如：

I had the same problem and I solved it, shutting it down first the database and after restoring it. For example:

    String nsURL1 = "jdbc:derby://localhost:1527/dbcli;shutdown=true";
    String nsURL2 = "jdbc:derby://localhost:1527/dbcli;restoreFrom="+ backup;
    props.setProperty("user", "root");
    props.setProperty("password", "root");

    DriverManager.getConnection(nsURL1, props);
    dbConnection = DriverManager.getConnection(nsURL2, props);

并使用try-catch

and using try-catch

这篇关于java derby restoreFrom什么也不做的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！