Creating a new DB2 Schma

User 98d11041ad

30-04-2009 00:03:40

I am able to connect to a DB2 database through the JChem services page, however when attempting to create a new schema on the same RDBM I have previously connected to using the following template:


database.driver=com.ibm.db2.jcc.DB2Driver
database.url=jdbc:db2://<hostname>[:port]/<database>


It fails with the following exception.


java.lang.NullPointerException
    at org.netbeans.beaninfo.editors.DataFolderPanel.<init>(DataFolderPanel.java:102)
    at org.netbeans.beaninfo.editors.DataFolderEditor.getDFPanel(DataFolderEditor.java:155)
    at org.netbeans.beaninfo.editors.DataFolderEditor.setValue(DataFolderEditor.java:139)
    at org.openide.explorer.propertysheet.PropUtils.updateEdFromProp(PropUtils.java:907)
    at org.openide.explorer.propertysheet.PropUtils.getPropertyEditor(PropUtils.java:848)
    at org.openide.explorer.propertysheet.PropUtils.getPropertyEditor(PropUtils.java:788)
    at org.openide.explorer.propertysheet.CustomEditorDisplayer.getPropertyEditor(CustomEditorDisplayer.java:124)
    at org.openide.explorer.propertysheet.CustomEditorDisplayer.getCustomEditor(CustomEditorDisplayer.java:115)
    at org.openide.explorer.propertysheet.CustomEditorDisplayer.getComponent(CustomEditorDisplayer.java:344)
    at org.openide.explorer.propertysheet.PropertyPanel.installDisplayerComponent(PropertyPanel.java:464)
    at org.openide.explorer.propertysheet.PropertyPanel.addNotify(PropertyPanel.java:705)
    at java.awt.Container.addNotify(Unknown Source)
    at javax.swing.JComponent.addNotify(Unknown Source)
    at org.openide.loaders.TemplateWizard2.addNotify(TemplateWizard2.java:175)
    at java.awt.Container.addImpl(Unknown Source)
    at java.awt.Container.add(Unknown Source)
    at org.openide.WizardDescriptor$WizardPanel.setRightComponent(WizardDescriptor.java:2591)
    at org.openide.WizardDescriptor.updateStateOpen(WizardDescriptor.java:824)
    at org.openide.WizardDescriptor.updateState(WizardDescriptor.java:720)
    at org.openide.loaders.TemplateWizard.updateState(TemplateWizard.java:738)
    at org.openide.WizardDescriptor$Listener.stateChanged(WizardDescriptor.java:1838)
    at org.openide.util.WeakListenerImpl$Change.stateChanged(WeakListenerImpl.java:319)
    at org.openide.loaders.TemplateWizard2.fireStateChanged(TemplateWizard2.java:368)
    at org.openide.loaders.TemplateWizard2.setLocationFolder(TemplateWizard2.java:394)
    at org.openide.loaders.TemplateWizard2.implReadSettings(TemplateWizard2.java:206)
    at org.openide.loaders.TemplateWizardPanel2.readSettings(TemplateWizardPanel2.java:138)
    at org.openide.loaders.TemplateWizardPanel2.readSettings(TemplateWizardPanel2.java:52)
    at org.openide.WizardDescriptor.updateStateOpen(WizardDescriptor.java:745)
    at org.openide.WizardDescriptor.updateState(WizardDescriptor.java:720)
    at org.openide.loaders.TemplateWizard.updateState(TemplateWizard.java:738)
    at org.openide.WizardDescriptor.goToNextStep(WizardDescriptor.java:931)
    at org.openide.WizardDescriptor.access$1100(WizardDescriptor.java:119)
    at org.openide.WizardDescriptor$Listener$1.run(WizardDescriptor.java:1861)
    at org.openide.WizardDescriptor.lazyValidate(WizardDescriptor.java:1316)
    at org.openide.WizardDescriptor.access$1200(WizardDescriptor.java:119)
    at org.openide.WizardDescriptor$Listener.actionPerformed(WizardDescriptor.java:1880)
Caused: java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.openide.util.WeakListenerImpl$ProxyListener.invoke(WeakListenerImpl.java:449)
Caused: java.lang.reflect.UndeclaredThrowableException
    at $Proxy9.actionPerformed(Unknown Source)
    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)
[catch] 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.netbeans.core.windows.services.NbPresenter.superShow(NbPresenter.java:834)
    at org.netbeans.core.windows.services.NbPresenter.doShow(NbPresenter.java:868)
    at org.netbeans.core.windows.services.NbPresenter.run(NbPresenter.java:856)
    at org.netbeans.core.windows.services.NbPresenter.run(NbPresenter.java:104)
    at org.openide.util.Mutex$1AWTWorker.run(Mutex.java:1238)
    at java.awt.event.InvocationEvent.dispatch(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)

ChemAxon fa971619eb

30-04-2009 06:35:20

Although DB2 is one of the databases supported by the JChem tools, it is not one of the databases currently supported by the Instant JChem application. Only Derby (as a local embedded database), MySQL and Oracle are supported.


See here for more information about databases in IJC:


http://www.chemaxon.com/instantjchem/ijc_latest/docs/admin/supported_dbs.html


 


Tim