Hi everybody,
I am trying to switch my backend database from Oracle to MySQL 4.1 in an EJB 2.0 based application already written and running under Websphere 5.1.2 app server. In WSAD, I can create a connection to MySql and also generate EJB to RDB Map.mapxmi file fine. The problem hits me when I try to map any individual ejb field to corresponding table field in MySql database. Seems like WSAD doesn?t recognize MySql data types!! I get the following exception in WSAD workspace log file. I've already updated my WSAD 5.1.2 files and have the latest version, but still get this!! Any idea?? Thnx.


java.lang.IndexOutOfBoundsException: index=0, size=0
at java.lang.Throwable.(Throwable.java)
at java.lang.Throwable.(Throwable.java)
at org.eclipse.emf.common.util.BasicEList.get(BasicEL ist.java)
at com.ibm.etools.ejbrdbmapping.impl.EjbRdbDocumentRo otImpl.findMapsContaining(EjbRdbDocumentRootImpl.j ava:1707)
at com.ibm.etools.ejbrdbmapping.impl.EjbRdbDocumentRo otImpl.getTypeMappings(EjbRdbDocumentRootImpl.java :1675)
at com.ibm.etools.ejbrdbmapping.impl.EjbRdbDocumentRo otImpl.getAllTypeMappings(EjbRdbDocumentRootImpl.j ava:1657)
at com.ibm.etools.ejbrdbmapping.impl.EjbRdbDocumentRo otImpl.getExactTypeMappings(EjbRdbDocumentRootImpl .java:1641)
at com.ibm.etools.ejbrdbmapping.impl.EjbRdbDocumentRo otImpl.getTypeMappings(EjbRdbDocumentRootImpl.java :1627)
at com.ibm.etools.ejbrdbmapping.impl.EjbRdbDocumentRo otImpl.createEjbRdbAttributeMappingObject(EjbRdbDo cumentRootImpl.java:786)
at com.ibm.etools.ejbrdbmapping.impl.EjbRdbDocumentRo otImpl.createMapping(EjbRdbDocumentRootImpl.java:8 91)
at com.ibm.etools.ejbrdbmapping.command.CreateEJBRDBM appingCommand.execute(CreateEJBRDBMappingCommand.j ava:201)
at org.eclipse.emf.common.command.CommandWrapper.exec ute(CommandWrapper.java:180)
at com.ibm.etools.j2ee.workbench.ParentCommand.execut e(ParentCommand.java:75)
at com.ibm.etools.ejbrdbmapping.command.EjbRdbMapping PersistentCommandStack.superSuperExecute(EjbRdbMap pingPersistentCommandStack.java:711)
at com.ibm.etools.ejbrdbmapping.command.WrappingEjbRd bMappingPersistentCommandStack.execute(WrappingEjb RdbMappingPersistentCommandStack.java:57)
at com.ibm.etools.ejbrdbmapping.action.CreateMapWithH elperAction.run(CreateMapWithHelperAction.java:64)
at org.eclipse.emf.edit.ui.action.DelegatingCommandAc tion.run(DelegatingCommandAction.java:118)
at org.eclipse.jface.action.Action.runWithEvent(Actio n.java:842)
at org.eclipse.jface.action.ActionContributionItem.ha ndleWidgetSelection(ActionContributionItem.java:45 6)
at org.eclipse.jface.action.ActionContributionItem.ha ndleWidgetEvent(ActionContributionItem.java:403)
at org.eclipse.jface.action.ActionContributionItem.ac cess$0(ActionContributionItem.java:397)
at org.eclipse.jface.action.ActionContributionItem$Ac tionListener.handleEvent(ActionContributionItem.ja va:72)
at org.eclipse.swt.widgets.EventTable.sendEvent(Event Table.java)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.ja va)
at org.eclipse.swt.widgets.Display.runDeferredEvents( Display.java)
at org.eclipse.swt.widgets.Display.readAndDispatch(Di splay.java)
at org.eclipse.ui.internal.Workbench.runEventLoop(Wor kbench.java:1402)
at org.eclipse.ui.internal.Workbench.run(Workbench.ja va:1385)
at org.eclipse.core.internal.boot.InternalBootLoader. run(InternalBootLoader.java:858)
at org.eclipse.core.boot.BootLoader.run(BootLoader.ja va:461)
at java.lang.reflect.AccessibleObject.invokeL(Accessi bleObject.java:207)
at java.lang.reflect.Method.invoke(Method.java:271)
at org.eclipse.core.launcher.Main.basicRun(Main.java: 291)
at org.eclipse.core.launcher.Main.run(Main.java:747)
at org.eclipse.core.launcher.Main.main(Main.java:583)