Subject | FBBackupManager restore error |
---|---|
Author | nagypapi |
Post date | 2007-11-23T18:12:17Z |
We are trying to do a backup - restore action programmaticly with a fb
1.5 server on winxp and jaybird 2.1.1 and java1.6
The solution will be implemented in an embedded firebird application:
File f = new File("backup_tmp.fbk");
FBBackupManager fbbm = new FBBackupManager("PURE_JAVA");
fbbm.setBackupPath(f.getAbsolutePath());
fbbm.setDatabase(Modules.config.getString("db"));
fbbm.setUser(Modules.config.getString("dbuser"));
fbbm.setPassword(Modules.config.getString("dbpass"));
fbbm.backupDatabase();
fbbm = new FBBackupManager("PURE_JAVA");
fbbm.setBackupPath(f.getAbsolutePath());
fbbm.setDatabase(Modules.config.getString("db"));
fbbm.setUser(Modules.config.getString("dbuser"));
fbbm.setPassword(Modules.config.getString("dbpass"));
fbbm.setRestoreReplace(true);
fbbm.setVerbose(true);
fbbm.setLogger(new FileOutputStream(new File("fb_errorlog.txt")));
fbbm.restoreDatabase();
f.delete();
But the fbbm.restoreDatabase(); line throws an error:
(fb_errorlog.txt is empty)
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 190. No message
for code 190 found.
No message for code 133 found.
null
No message for code 233 found.
null
at
org.firebirdsql.management.FBServiceManager.executeServicesOperation(FBServiceManager.java:280)
at
org.firebirdsql.management.FBBackupManager.restoreDatabase(FBBackupManager.java:264)
at
org.firebirdsql.management.FBBackupManager.restoreDatabase(FBBackupManager.java:257)
at
woodpecker.marhakullem.gui.beallitasokgui.BeallitasokDialog.dbTisztit_btnActionPerformed(BeallitasokDialog.java:237)
at
woodpecker.marhakullem.gui.beallitasokgui.BeallitasokDialog.access$100(BeallitasokDialog.java:32)
at
woodpecker.marhakullem.gui.beallitasokgui.BeallitasokDialog$2.actionPerformed(BeallitasokDialog.java:100)
at
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at
javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6038)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5803)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4410)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4240)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
at
java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Window.dispatchEventImpl(Window.java:2429)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:177)
at java.awt.Dialog$1.run(Dialog.java:1039)
at java.awt.Dialog$3.run(Dialog.java:1091)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Dialog.show(Dialog.java:1089)
at java.awt.Component.show(Component.java:1419)
at java.awt.Component.setVisible(Component.java:1372)
at java.awt.Window.setVisible(Window.java:801)
at java.awt.Dialog.setVisible(Dialog.java:979)
at
woodpecker.marhakullem.gui.beallitasokgui.BeallitasokDialog.<init>(BeallitasokDialog.java:44)
at
woodpecker.marhakullem.gui.MainWindow.beallitasok_btnActionPerformed(MainWindow.java:299)
at
woodpecker.marhakullem.gui.MainWindow.access$1200(MainWindow.java:38)
at
woodpecker.marhakullem.gui.MainWindow$FormListener.actionPerformed(MainWindow.java:293)
at
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at
javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6038)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5803)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4410)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4240)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
at
java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Window.dispatchEventImpl(Window.java:2429)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
What can I do to correct this?
(I tried looking for Jaybird source at jaybirdwiki or at sourceforge
files, but didn't find them)
Thanks,
John
1.5 server on winxp and jaybird 2.1.1 and java1.6
The solution will be implemented in an embedded firebird application:
File f = new File("backup_tmp.fbk");
FBBackupManager fbbm = new FBBackupManager("PURE_JAVA");
fbbm.setBackupPath(f.getAbsolutePath());
fbbm.setDatabase(Modules.config.getString("db"));
fbbm.setUser(Modules.config.getString("dbuser"));
fbbm.setPassword(Modules.config.getString("dbpass"));
fbbm.backupDatabase();
fbbm = new FBBackupManager("PURE_JAVA");
fbbm.setBackupPath(f.getAbsolutePath());
fbbm.setDatabase(Modules.config.getString("db"));
fbbm.setUser(Modules.config.getString("dbuser"));
fbbm.setPassword(Modules.config.getString("dbpass"));
fbbm.setRestoreReplace(true);
fbbm.setVerbose(true);
fbbm.setLogger(new FileOutputStream(new File("fb_errorlog.txt")));
fbbm.restoreDatabase();
f.delete();
But the fbbm.restoreDatabase(); line throws an error:
(fb_errorlog.txt is empty)
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 190. No message
for code 190 found.
No message for code 133 found.
null
No message for code 233 found.
null
at
org.firebirdsql.management.FBServiceManager.executeServicesOperation(FBServiceManager.java:280)
at
org.firebirdsql.management.FBBackupManager.restoreDatabase(FBBackupManager.java:264)
at
org.firebirdsql.management.FBBackupManager.restoreDatabase(FBBackupManager.java:257)
at
woodpecker.marhakullem.gui.beallitasokgui.BeallitasokDialog.dbTisztit_btnActionPerformed(BeallitasokDialog.java:237)
at
woodpecker.marhakullem.gui.beallitasokgui.BeallitasokDialog.access$100(BeallitasokDialog.java:32)
at
woodpecker.marhakullem.gui.beallitasokgui.BeallitasokDialog$2.actionPerformed(BeallitasokDialog.java:100)
at
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at
javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6038)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5803)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4410)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4240)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
at
java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Window.dispatchEventImpl(Window.java:2429)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:177)
at java.awt.Dialog$1.run(Dialog.java:1039)
at java.awt.Dialog$3.run(Dialog.java:1091)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Dialog.show(Dialog.java:1089)
at java.awt.Component.show(Component.java:1419)
at java.awt.Component.setVisible(Component.java:1372)
at java.awt.Window.setVisible(Window.java:801)
at java.awt.Dialog.setVisible(Dialog.java:979)
at
woodpecker.marhakullem.gui.beallitasokgui.BeallitasokDialog.<init>(BeallitasokDialog.java:44)
at
woodpecker.marhakullem.gui.MainWindow.beallitasok_btnActionPerformed(MainWindow.java:299)
at
woodpecker.marhakullem.gui.MainWindow.access$1200(MainWindow.java:38)
at
woodpecker.marhakullem.gui.MainWindow$FormListener.actionPerformed(MainWindow.java:293)
at
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at
javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6038)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5803)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4410)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4240)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
at
java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Window.dispatchEventImpl(Window.java:2429)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
What can I do to correct this?
(I tried looking for Jaybird source at jaybirdwiki or at sourceforge
files, but didn't find them)
Thanks,
John