Home » Community » Forum » Problems and Work-arounds

FireBird problem

Posted April 9th, 2009 by gostek_1

Hi
I'm trying to set up dbreplicator with firebird. The applications starts and connects the database but I can't set up the publisher. I get an exception:

13:32:12,727 DEBUG [ReplicationServer] [getInstance 162] ReplicationServer started

13:32:26,312 DEBUG [ScheduleHandler] [ 62] intializing ScheduleHandler
13:32:26,421 DEBUG [ScheduleHandler] [ 95] org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -204
Table unknown
REP_SCHEDULETABLE
At line 1, column 15.
Exception occurred during event dispatching:
java.lang.NullPointerException
at org.dbreplicator.repconsole.SelectTable.initListWithDatabaseTablesForCreate(SelectTable.java:245)
at org.dbreplicator.repconsole.SelectTable.(SelectTable.java:107)
at org.dbreplicator.repconsole.CreatePublication.jButtonNext_actionPerformed(CreatePublication.java:215)
at org.dbreplicator.repconsole.CreatePublication_jButtonNext_actionAdapter.actionPerformed(CreatePublication.java:307)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.Dialog$1.run(Unknown Source)
at java.awt.Dialog$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Dialog.show(Unknown Source)
at org.dbreplicator.repconsole.MainFrame.jMenuPub_Create_actionPerformed(MainFrame.java:457)
at org.dbreplicator.repconsole.MainFrame_jMenuPub_Create_actionAdapter.actionPerformed(MainFrame.java:1047)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.AbstractButton.doClick(Unknown Source)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

Any sugestions?

java version "1.6.0_13"
dbreplicator_2.2.4
jaybird-full-2.1.6
FirebirdCS-1.5.1.4481

‹ Postgres sync problem Sql server to mysql replication error ›

Check your database where

On April 10th, 2009 gox says:

Check your database where subscriber server is, and see if there is REP_SCHEDULETABLE table created in your database with the rest of the REP_ tables. There should be 8 of REP_ tables on subscriber and 6 on publisher.

Yes i see. There is no REP_*

On April 10th, 2009 gostek_1 says:

Yes i see. There is no REP_* tables. The DBreplicator creates those tables automatically or i have to create them manually?
I want to set up the publisher first an then an subsciber.

REP_ tables are created

On April 10th, 2009 gox says:

REP_ tables are created automatically when you subscribe to publisher or at least they should be created.
First you want to create publisher and add tables in correct order. When you receive the message that the publisher has been created successfully check your database to see if the REP_ tables are created. I use the PostgreSQL so my REP_ tables are located in public schema. I don't really know where the FireBird would create them since I haven't try DBReplicator on FireBird.
After that, try subscribing to that publisher. If the message pops out saying that you've done that successfully than check the database on your subscriber for the REP_ tables. They all should be there. If not, then you might wanna try to set them up manually.

hmm. The problem is that

On April 10th, 2009 gostek_1 says:

hmm. The problem is that when i'm running pubconsole and use the option to create publisher the above exception is thrown.
What is the structure of the REP_ tables on the both sides? I'll try to create them manualy. Do I have to add triggers manually also?

here is the DDL for

On April 10th, 2009 gox says:

here is the DDL for rep_scheduletable:
CREATE TABLE "public"."rep_scheduletable" (
"rep_schedule_name" VARCHAR(255) NOT NULL,
"rep_sub_name" VARCHAR(255) NOT NULL,
"rep_scheduletype" VARCHAR(255),
"rep_server_name" VARCHAR(255),
"rep_publicationportno" VARCHAR(255),
"rep_recurrencetype" VARCHAR(255),
"rep_replicationtype" VARCHAR(255),
"rep_scheduletime" BIGINT,
"rep_schedulecounter" BIGINT,
CONSTRAINT "rep_scheduletable_pkey" PRIMARY KEY("rep_schedule_name", "rep_sub_name"),
CONSTRAINT "rep_scheduletable_rep_sub_name_key" UNIQUE("rep_sub_name")
) WITHOUT OIDS;

There are no triggers for rep_ tables.

same problem

On May 8th, 2009 robudzi says:

Hi,

i have the same exception. I created the table manualy but dont work, same exception. gostek_1, you solved your problem??

No I did not. I've change

On May 9th, 2009 gostek_1 says:

No I did not. I've change the strategy do i don't need replication. For now. I'll get back to replication as soon as I find some time.
I guess this exception can happen because buggy jdbc or firebird engine.

thanks

On May 11th, 2009 robudzi says:

Thanks for your response. I cant make work and i will change my strategy too and choose other replicator. I´m realy desapointed because i prefer open source projects.
Thanks again.

Rodrigo Budzisnki

Exception problem

On March 9th, 2011 the.clone.master says:

It seems like dbreplicator fails when it tries to check if the rep_tables are already created on firebird...

Sadly I am not a java developer, so I can't go further...

Any help is welcome!!

-Mario

Powered by Drupal - Theme by Danger4k