[lwilcox]

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

[Riyad Kalla]

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

[lwilcox]

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!

[Riyad Kalla]

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

[lwilcox]

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.

[Brian Fernandes]

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.

[lwilcox]

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

[lwilcox]

Brian,

Have you look into this problem yet?

Thanks,
Lien

[lwilcox]

@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)

[Brian Fernandes]

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.

[lwilcox]

@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

[Brian Fernandes]

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.

[lwilcox]

@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.

[ddesilva]

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

Thanks
Delan

[Brian Fernandes]

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