#1 Problem in to subscribe the subscription

[Neeraj khanna]

In testing process sqlserver data source as publisher
and daffodilDB data source as subscriber .Used table
structure is "create table table(col1 int Primary key,col2
smalldatetime);"

After publishing the table in SQL Server Data source try
to subscribe it in daffodilDB but it give an Error
message.

Incorrect syntax at position '17' near the
keyword 'TABLE'.

com.daffodilwoods.database.C.A_1922.A(Unknown
Source)
in.co.daffodil.db.jdbc.A_2117.execute(Unknown Source)
com.daffodilwoods.replication.e.A_84.a(Unknown Source)
com.daffodilwoods.replication.A_100.subscribe(Unknown
Source)
com.daffodilwoods.repconsole.A_5.a(Unknown Source)
com.daffodilwoods.repconsole.A_5.a(Unknown Source)
com.daffodilwoods.repconsole.A_5.keyReleased(Unknown
Source)
java.awt.Component.processKeyEvent
(Component.java:5061)
javax.swing.JComponent.processKeyEvent
(JComponent.java:2388)
java.awt.Component.processEvent
(Component.java:4909)
java.awt.Container.processEvent(Container.java:1569)
java.awt.Component.dispatchEventImpl
(Component.java:3615)
java.awt.Container.dispatchEventImpl
(Container.java:1627)
java.awt.Component.dispatchEvent
(Component.java:3477)
java.awt.KeyboardFocusManager.redispatchEvent
(KeyboardFocusManager.java:1713)
java.awt.DefaultKeyboardFocusManager.dispatchKeyEven
t
(DefaultKeyboardFocusManager.java:627)
java.awt.DefaultKeyboardFocusManager.preDispatchKeyE
vent
(DefaultKeyboardFocusManager.java:831)
java.awt.DefaultKeyboardFocusManager.typeAheadAssert
ions
(DefaultKeyboardFocusManager.java:741)
java.awt.DefaultKeyboardFocusManager.dispatchEvent
(DefaultKeyboardFocusManager.java:592)
java.awt.Component.dispatchEventImpl
(Component.java:3506)
java.awt.Container.dispatchEventImpl
(Container.java:1627)
java.awt.Window.dispatchEventImpl(Window.java:1606)
java.awt.Component.dispatchEvent
(Component.java:3477)
java.awt.EventQueue.dispatchEvent
(EventQueue.java:456)
java.awt.EventDispatchThread.pumpOneEventForHierarch
y
(EventDispatchThread.java:201)
java.awt.EventDispatchThread.pumpEventsForHierarchy
(EventDispatchThread.java:151)
java.awt.EventDispatchThread.pumpEventsForHierarchy
(EventDispatchThread.java:141)java.awt.Dialog$1.run
(Dialog.java:540)
java.awt.Dialog.show(Dialog.java:561)
com.daffodilwoods.repconsole.A_15.b
(Unknown Source)
com.daffodilwoods.repconsole.A_21.actionPerformed
(Unknown
Source)javax.swing.AbstractButton.fireActionPerformed
(AbstractButton.java:1786)
javax.swing.AbstractButton$ForwardActionEvents.actionP
erformed
(AbstractButton.java:1839)
javax.swing.DefaultButtonModel.fireActionPerformed
(DefaultButtonModel.java:420)
javax.swing.DefaultButtonModel.setPressed
(DefaultButtonModel.java:258)
javax.swing.AbstractButton.doClick
(AbstractButton.java:289)
javax.swing.plaf.basic.BasicMenuItemUI.doClick
(BasicMenuItemUI.java:1113)
javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandl
er.mouseReleased
(BasicMenuItemUI.java:943)
java.awt.Component.processMouseEvent
(Component.java:5100)
java.awt.Component.processEvent
(Component.java:4897)
java.awt.Container.processEvent(Container.java:1569)
java.awt.Component.dispatchEventImpl
(Component.java:3615)
java.awt.Container.dispatchEventImpl
(Container.java:1627)
java.awt.Component.dispatchEvent
(Component.java:3477)
java.awt.LightweightDispatcher.retargetMouseEvent
(Container.java:3483)
java.awt.LightweightDispatcher.processMouseEvent
(Container.java:3198)
java.awt.LightweightDispatcher.dispatchEvent
(Container.java:3128)
java.awt.Container.dispatchEventImpl
(Container.java:1613)
java.awt.Window.dispatchEventImpl(Window.java:1606)
java.awt.Component.dispatchEvent
(Component.java:3477)
java.awt.EventQueue.dispatchEvent
(EventQueue.java:456)
java.awt.EventDispatchThread.pumpOneEventForHierarch
y
(EventDispatchThread.java:201)
java.awt.EventDispatchThread.pumpEventsForHierarchy
(EventDispatchThread.java:151)
java.awt.EventDispatchThread.pumpEvents
(EventDispatchThread.java:145)
java.awt.EventDispatchThread.pumpEvents
(EventDispatchThread.java:137)java

[Parveen Aggarwal]

Logged In: YES
user_id=853064

table is reserved keyword in Daffodil DB. Therefore we have
to use quoted identifier to make the table. We will be making
provision for quoted identifier in our next release.