DB2 Errors with MyEclipse Database Explorer

MyEclipse Archived

Database Tools (DB Explorer, Hibernate, etc.)

This topic has 33 replies, 7 voices, and was last updated 19 years, 3 months ago by Haris Peco.

Viewing 15 posts - 1 through 15 (of 34 total)

1 2 3 →

Author

Posts
November 4, 2005 at 2:23 pm #240851 Reply

lwilcox
Participant

Need help. What else can I do….Thanks

barua

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2005-11-04 15:08:11.546
!MESSAGE Cannot get indices
!STACK 0
com.ibm.db2.jcc.b.SqlException: Invalid argument: unknown column name NON_UNIQUE
at com.ibm.db2.jcc.b.m.a(m.java:1260)
at com.ibm.db2.jcc.b.rc.a(rc.java:1368)
at com.ibm.db2.jcc.b.rc.getBoolean(rc.java:1137)
at com.genuitec.eclipse.sqlexplorer.views.details.ColumnsDetail$3.run(ColumnsDetail.java:194)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:69)
at com.genuitec.eclipse.sqlexplorer.views.details.ColumnsDetail.activate(ColumnsDetail.java:186)
at com.genuitec.eclipse.sqlexplorer.views.DetailManager.activate(DetailManager.java:124)
at com.genuitec.eclipse.sqlexplorer.views.TableInfoView.setInput(TableInfoView.java:53)
at com.genuitec.eclipse.sqlexplorer.views.DatabaseTreeViewer$4.selectionChanged(DatabaseTreeViewer.java:127)
at org.eclipse.jface.viewers.Viewer$2.run(Viewer.java:162)
at org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:1044)
at org.eclipse.core.runtime.Platform.run(Platform.java:783)
at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:44)
at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:148)
at org.eclipse.jface.viewers.Viewer.fireSelectionChanged(Viewer.java:160)
at org.eclipse.jface.viewers.StructuredViewer.updateSelection(StructuredViewer.java:1784)
at org.eclipse.jface.viewers.StructuredViewer.handleSelect(StructuredViewer.java:1027)
at org.eclipse.jface.viewers.StructuredViewer$4.widgetSelected(StructuredViewer.java:1053)
at org.eclipse.jface.util.OpenStrategy.fireSelectionEvent(OpenStrategy.java:209)
at org.eclipse.jface.util.OpenStrategy.access$3(OpenStrategy.java:204)
at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:364)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163)
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.eclipse.core.launcher.Main.invokeFramework(Main.java:334)
at org.eclipse.core.launcher.Main.basicRun(Main.java:278)
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:948)

Eclipse SDK Version: 3.1.1 Build id: M20050929-0840
MyEclipse JSF Support Version: 4.0.1 Build id: 20050930-4.0.1-GA

November 5, 2005 at 11:46 am #240882 Reply

Riyad Kalla
Member

Barua,
Where did you get this exception? What were you trying to do? Please tell us step by step how to reproduce this.

November 7, 2005 at 9:10 am #240932 Reply

lwilcox
Participant

I tried to Expand the table on MyEclipse Database Explorer. I know for sure that I have access to my DB2 database because I tested it with other applications: JBuilder and DB2 for Window. I just want to know if there is any extra set up for DB2 with MyEclipse. I tried MS-SQL and Oracle databases they are both OK. I can generate the Hibernate Mapping file without any problem. But When I swittch to DB2, I can’t even view the table columns by expending the plus sign of the table name. Hope this give you enough information to help me with my error message below:

!ENTRY com.genuitec.eclipse.hibernate 4 4 2005-11-07 09:52:39.296
!MESSAGE Unable to retrieve column metadata for table DEPARTMENT
!STACK 0
com.ibm.db2.jcc.b.SqlException: Invalid argument: unknown column name COLUMN_NAME
at com.ibm.db2.jcc.b.m.a(m.java:1260)
at com.ibm.db2.jcc.b.rc.a(rc.java:1368)
at com.ibm.db2.jcc.b.rc.getString(rc.java:1227)
at com.genuitec.eclipse.hibernate.core.HibernateMappedObject.getColumn(HibernateMappedObject.java:160)
at com.genuitec.eclipse.hibernate.core.HibernateMappedObject.<init>(HibernateMappedObject.java:135)
at com.genuitec.eclipse.hibernate.wizards.NewHibernateNewMappingWizardPage.prepareFileList(NewHibernateNewMappingWizardPage.java:134)
at com.genuitec.eclipse.hibernate.wizards.NewHibernateNewMappingWizardPage.<init>(NewHibernateNewMappingWizardPage.java:93)
at com.genuitec.eclipse.hibernate.wizards.NewHibernateMappingWizard.addPages(NewHibernateMappingWizard.java:76)
at org.eclipse.jface.wizard.WizardDialog.createContents(WizardDialog.java:499)
at org.eclipse.jface.window.Window.create(Window.java:418)
at org.eclipse.jface.dialogs.Dialog.create(Dialog.java:996)
at com.genuitec.eclipse.hibernate.action.NewHibernateMappingAction.run(NewHibernateMappingAction.java:38)
at com.genuitec.eclipse.hibernate.action.NewHibernateMappingAction.run(NewHibernateMappingAction.java:47)
at org.eclipse.ui.internal.PluginAction.runWithEvent(PluginAction.java:246)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:538)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:488)
at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:400)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163)
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.eclipse.core.launcher.Main.invokeFramework(Main.java:334)
at org.eclipse.core.launcher.Main.basicRun(Main.java:278)
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:948)

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2005-11-07 09:52:55.265
!MESSAGE Cannot get indices
!STACK 0
com.ibm.db2.jcc.b.SqlException: Invalid argument: unknown column name NON_UNIQUE
at com.ibm.db2.jcc.b.m.a(m.java:1260)
at com.ibm.db2.jcc.b.rc.a(rc.java:1368)
at com.ibm.db2.jcc.b.rc.getBoolean(rc.java:1137)
at com.genuitec.eclipse.sqlexplorer.views.details.ColumnsDetail$3.run(ColumnsDetail.java:194)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:69)
at com.genuitec.eclipse.sqlexplorer.views.details.ColumnsDetail.activate(ColumnsDetail.java:186)
at com.genuitec.eclipse.sqlexplorer.views.DetailManager.activate(DetailManager.java:124)
at com.genuitec.eclipse.sqlexplorer.views.TableInfoView.setInput(TableInfoView.java:53)
at com.genuitec.eclipse.sqlexplorer.views.DatabaseTreeViewer$4.selectionChanged(DatabaseTreeViewer.java:127)
at org.eclipse.jface.viewers.Viewer$2.run(Viewer.java:162)
at org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:1044)
at org.eclipse.core.runtime.Platform.run(Platform.java:783)
at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:44)
at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:148)
at org.eclipse.jface.viewers.Viewer.fireSelectionChanged(Viewer.java:160)
at org.eclipse.jface.viewers.StructuredViewer.updateSelection(StructuredViewer.java:1784)
at org.eclipse.jface.viewers.StructuredViewer.handleSelect(StructuredViewer.java:1027)
at org.eclipse.jface.viewers.StructuredViewer$4.widgetSelected(StructuredViewer.java:1053)
at org.eclipse.jface.util.OpenStrategy.fireSelectionEvent(OpenStrategy.java:209)
at org.eclipse.jface.util.OpenStrategy.access$3(OpenStrategy.java:204)
at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:364)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163)
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.eclipse.core.launcher.Main.invokeFramework(Main.java:334)
at org.eclipse.core.launcher.Main.basicRun(Main.java:278)
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:948)

The error message was under my workspace. (C:\test\workspace\.metadata\.log)

Thank you!

November 7, 2005 at 10:10 am #240939 Reply

Riyad Kalla
Member

Do you actually have columns in any ofthe tables named COLUMN_NAME or NON_UNIQUE? It’s hard to track but the driver is spitting those messages out specifically so I would try and figure out why right off the bat.

Also tell me how you configured the DB2 JBDC Driver under Window > Prefs > MyEclipse > DB Explorer > Drivers

November 7, 2005 at 1:45 pm #240957 Reply

lwilcox
Participant

Yes, We do have column_name but for unique defination the value is N/A.

I configured the DB2 JBDC Driver under Window > Prefs > MyEclipse > DB Explorer > Drivers as follow:

1. From the Drivers list select IBM DB2 App Driver and click on Edit
2. Ensure the Driver Class Name is com.ibm.db2.jcc.DB2Driver
3. Select Driver Libraries tab
4. Click on the New button
5. Add the following jar files : db2jcc.jar, db2jcc_javax.jar, db2jcc_license_cisuz.jar
6. Select OK.
7. Select Window –> Show View –> DB Browser
8. Select New (create a new database profile)
9. Enter URL: jdbc:db2://Development:466/TESTDB
10. Enter userid and password

After this I can view all the table names but not columns.

November 7, 2005 at 10:55 pm #241011 Reply

Brian Fernandes
Moderator

lwilcox,

Thank you for detailing the steps out for us. Your DB driver setup is OK.

We seem to have encountered some issues with DB2 metadata of late. Could you please detail your DB2 version and DB2 driver version for me?

Best,
Brian.

November 8, 2005 at 11:41 am #241056 Reply

lwilcox
Participant

Brian,

Information as requested:

Database Product Name DB2
Database Product Version DSN07011
Driver Major Version 2
Driver Minor Version 3
Driver Name IBM DB2 JDBC Universal Driver Achitecture
Driver Version 2.3.73

Lien

November 14, 2005 at 12:12 pm #241452 Reply

lwilcox
Participant

Brian,

Have you look into this problem yet?

Thanks,
Lien

November 17, 2005 at 1:34 pm #241738 Reply

lwilcox
Participant

@lwilcox wrote:

Brian,

Have you look into this problem yet?

Thanks,
Lien

Hello Brian,

Can you look into the message below and advise. Thanks.

I am using

*** MyEclipse details:
MyEclipse Enterprise Workbench

Version: 4.0.100 M1
Build id: 20051103-4.1-Milestone1

*** Eclipse details:
Eclipse SDK

Version: 3.1.1
Build id: M20050929-0840

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
%%%% Error Creating SessionFactory %%%%
org.hibernate.MappingException: Association references unmapped class: com.hibernate.TripSegment
at org.hibernate.cfg.HbmBinder.bindCollectionSecondPass(HbmBinder.java:2036)
at org.hibernate.cfg.HbmBinder$CollectionSecondPass.secondPass(HbmBinder.java:2497)
at org.hibernate.cfg.HbmBinder$SecondPass.doSecondPass(HbmBinder.java:2468)
at org.hibernate.cfg.Configuration.secondPassCompile(Configuration.java:884)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:999)
at com.test.hibernate.SessionManager.currentSession(SessionManager.java:49)
at com.test.hibernate.TestHibernateDB2.main(TestHibernateDB2.java:17)
Exception in thread “main” java.lang.NullPointerException
at com.test.hibernate.SessionManager.currentSession(SessionManager.java:56)
at com.test.hibernate.TestHibernateDB2.main(TestHibernateDB2.java:17)

November 17, 2005 at 3:09 pm #241745 Reply

Brian Fernandes
Moderator

Lien,

I’m afraid we haven’t looked at the DB2 issue yet (sorry, your previous post slipped by me).

Could you give me more context for your latests error message? Where do you see it; when you’re doing what exactly?

Brian.

November 17, 2005 at 3:26 pm #241749 Reply

lwilcox
Participant

@Support-Brian wrote:

Lien,

I’m afraid we haven’t looked at the DB2 issue yet (sorry, your previous post slipped by me).

Could you give me more context for your latests error message? Where do you see it; when you’re doing what exactly?

Brian.

Brian,

Thanks for quick reply.

Please disregard the previous error message.

The following one is the most recent:

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2005-11-17 16:18:35.234
!MESSAGE Cannot get indices
!STACK 0
com.ibm.db2.jcc.b.SqlException: Invalid argument: unknown column name NON_UNIQUE
at com.ibm.db2.jcc.b.m.a(m.java:1260)
at com.ibm.db2.jcc.b.rc.a(rc.java:1368)
at com.ibm.db2.jcc.b.rc.getBoolean(rc.java:1137)
at com.genuitec.eclipse.sqlexplorer.views.details.ColumnsDetail$3.run(ColumnsDetail.java:194)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:69)
at com.genuitec.eclipse.sqlexplorer.views.details.ColumnsDetail.activate(ColumnsDetail.java:186)
at com.genuitec.eclipse.sqlexplorer.views.DetailManager.activate(DetailManager.java:124)
at com.genuitec.eclipse.sqlexplorer.views.TableInfoView.setInput(TableInfoView.java:53)
at com.genuitec.eclipse.sqlexplorer.views.DatabaseTreeViewer$4.selectionChanged(DatabaseTreeViewer.java:127)
at org.eclipse.jface.viewers.Viewer$2.run(Viewer.java:162)
at org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:1044)
at org.eclipse.core.runtime.Platform.run(Platform.java:783)
at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:44)
at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:148)
at org.eclipse.jface.viewers.Viewer.fireSelectionChanged(Viewer.java:160)
at org.eclipse.jface.viewers.StructuredViewer.updateSelection(StructuredViewer.java:1784)
at org.eclipse.jface.viewers.StructuredViewer.handleSelect(StructuredViewer.java:1027)
at org.eclipse.jface.viewers.StructuredViewer$4.widgetSelected(StructuredViewer.java:1053)
at org.eclipse.jface.util.OpenStrategy.fireSelectionEvent(OpenStrategy.java:209)
at org.eclipse.jface.util.OpenStrategy.access$3(OpenStrategy.java:204)
at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:364)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1699)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:367)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:143)
at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:103)
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:226)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163)
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.eclipse.core.launcher.Main.invokeFramework(Main.java:334)
at org.eclipse.core.launcher.Main.basicRun(Main.java:278)
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:948)

I just want to know if this is a bug in hibernate 3 or MyEclipse.

Thanks,
Lien

November 18, 2005 at 7:56 am #241774 Reply

Brian Fernandes
Moderator

Lien,

I’m sorry but I don’t know when you saw this error message. Were you trying to expand a table in the DB Browser or were you trying to generate a hibernate mapping or something else?

Whatever the case, this does not seem to be a problem with Hibernate, but a problem in MyEclipse reading DB2 tables. We will try to address this asap, your experience with DB2 is being noted.

Best,
Brian.

November 18, 2005 at 8:57 am #241781 Reply

lwilcox
Participant

@Support-Brian wrote:

Lien,

I’m sorry but I don’t know when you saw this error message. Were you trying to expand a table in the DB Browser or were you trying to generate a hibernate mapping or something else?

Whatever the case, this does not seem to be a problem with Hibernate, but a problem in MyEclipse reading DB2 tables. We will try to address this asap, your experience with DB2 is being noted.

Best,
Brian.

Thanks Brian.

December 5, 2005 at 2:54 pm #242648 Reply

ddesilva
Member

Brian, when will a fix be out? Will it be in 4.1 M2? We need this fix ASAP as well.

Thanks
Delan

December 6, 2005 at 12:49 am #242678 Reply

Brian Fernandes
Moderator

Delan,

Sorry there wasn’t any work done on this front in the light of more pressing issues for M2. However, the bug will very likey be on our target list for 4.1GA which is due in under a fortnight.

We apologize for the inconvenience to all affected users, but are looking at wrapping it up soon.

Best,
Brian.
Author

Posts

Viewing 15 posts - 1 through 15 (of 34 total)

1 2 3 →