Tim Cunnell

I'll have a look, thanks.
Tim

Yes, I'd like to read that article, please let me know when it's done.
I've added the Location-Warehouse CMR, but I still can't find the problem with the deploy code/query generation. Can you tell me why the exception in the message above might be getting thrown?

I'm pretty sure I've got it set up correctly (as you suggested) but I'm getting errors that getStore_storeRef() and getWarehouse_warehouseRef() are not implemented in LocationBeanCacheEntry... when I generate my deploy code. Websphere _has_ generated those abstract method signatures on the bean, but seems it can't/won't generate the implementations when it's generating deploy code.
I also get problems when I try to put in the CMR between the Warehouse and Store beans - deploy code generation falls over with this error :
Error during generation of deployment code: cols.size()==2, attrs.size()==0
>com.ibm.etools.ejbdeploy.EJBDeploymentException (Error during generation of deployment code: cols.size()==2, attrs.size()==0.)
com.ibm.etools.ejbdeploy.plugin.InternalErrorGenerationException: cols.size()==2, attrs.size()==0
at com.ibm.etools.ejbdeploy.gen20.jdbc.CMPAttributeMapHelper.createMapForRel(CMPAttributeMapHelper.java:253)
at com.ibm.etools.ejbdeploy.gen20.jdbc.CMPAttributeMapHelper.populateLists(CMPAttributeMapHelper.java(Compiled Code))
at com.ibm.etools.ejbdeploy.gen20.jdbc.CMPAttributeMapHelper.initAttributeMapperList(CMPAttributeMapHelper.java:378)
at com.ibm.etools.ejbdeploy.gen20.jdbc.QueryCacheHelper.<init>(QueryCacheHelper.java:30)
at com.ibm.etools.ejbdeploy.gen20.jdbc.QueryCacheCache.initQueries(QueryCacheCache.java:69)
at com.ibm.etools.ejbdeploy.gen20.jdbc.QueryCacheCache.init(QueryCacheCache.java:154)
at com.ibm.etools.ejbdeploy.plugin.EJBDeployOperation.runCMP(EJBDeployOperation.java:1501)
at com.ibm.etools.ejbdeploy.plugin.EJBDeployOperation.run(EJBDeployOperation.java:1364)
at com.ibm.etools.j2ee.common.ui.RunnableWithProgressWrapper.run(RunnableWithProgressWrapper.java:58)
at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:299)
at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:249)
at org.eclipse.jface.wizard.WizardDialog.run(WizardDialog.java:720)
at com.ibm.etools.ejbdeploy.ui.plugin.DeployRMICBeansOperation.generateDeployCode(DeployRMICBeansOperation.java:245)
at com.ibm.etools.ejbdeploy.ui.plugin.DeployRMICBeansOperation.run(DeployRMICBeansOperation.java:555)
at org.eclipse.core.internal.resources.Workspace.run(Workspace.java(Compiled Code))
at com.ibm.etools.ejbdeploy.ui.plugin.DeployRMICPage.performFinish(DeployRMICPage.java:446)
at com.ibm.etools.ejbdeploy.ui.plugin.DeployRMICWizard.performFinish(DeployRMICWizard.java:83)
at org.eclipse.jface.wizard.WizardDialog.finishPressed(WizardDialog.java:577)
at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:312)
at org.eclipse.jface.dialogs.Dialog$1.widgetSelected(Dialog.java:407)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java(Compiled Code))
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java(Compiled Code))
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java(Compiled Code))
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java(Compiled Code))
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java(Compiled Code))
at org.eclipse.jface.window.Window.runEventLoop(Window.java(Compiled Code))
at org.eclipse.jface.window.Window.open(Window.java:542)
at com.ibm.etools.ejbdeploy.ui.plugin.EJBDeployMenuAction.run(EJBDeployMenuAction.java:165)
at org.eclipse.ui.internal.PluginAction.runWithEvent(PluginAction.java:210)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:407)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetEvent(ActionContributionItem.java(Compiled Code))
at org.eclipse.jface.action.ActionContributionItem$ActionListener.handleEvent(ActionContributionItem.java(Compiled Code))
at org.eclipse.jface.action.ActionContributionItem$ActionListener.handleEvent(ActionContributionItem.java(Compiled Code))
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java(Compiled Code))
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java(Compiled Code))
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java(Compiled Code))
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java(Compiled Code))
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java(Compiled Code))
at org.eclipse.ui.internal.Workbench.run(Workbench.java:1326)
at org.eclipse.core.internal.boot.InternalBootLoader.run(InternalBootLoader.java:831)
at org.eclipse.core.boot.BootLoader.run(BootLoader.java:462)
at java.lang.reflect.Method.invoke(Native Method)
at org.eclipse.core.launcher.Main.basicRun(Main.java:247)
at org.eclipse.core.launcher.Main.run(Main.java:703)
at org.eclipse.core.launcher.Main.main(Main.java:539)
Ugh, nasty! I noticed that when I put in the CMR between my Warehouse and Store, stuff gets added to the LocationBean to pass in the foreign key for Warehouse. So I created a CMR between Location and Warehouse (even though I don't really want one), mapped it etc etc and still got the above error.
Eek, help!
cheers
Tim

Ah ok, I think I'm getting somewhere now.
Still a bit confused though, because my composite key is made up of three parts. The relationship is like this...
We have a Warehouse table that has 1-many Store tables which has 1-many Location tables.
Location has a primary key made up of locationRef, storeRef and warehouseRef.
Store's primary key is made up of storeRef and WarehouseRef.
Warehouse's primary key is just warehouseRef.
Location has a CMR with Store and store has a CMR with Warehouse.
It seems to me that Location needs a CMR with Warehouse.. is this true? I thought Location would only need a CMR with Store.
Sorry if I'm being a dullard here!
cheers
Tim

Use SOAP to rm -rf *
oh dear!

Me again.
I'm slightly confused over CMRs (this might really be a question for Mr Brown). When you have a CMR with a bean that has a composite (compound) key, what value should go in the CMR field? Should it store the whole key object? I've only managed to find examples of CMR where the key is a single field. I've been having battles with WSAD over CMRs for the past couple of days now...
Can anyone point me in the direction of some good examples please, or offer some advice?
tia,
Tim

ok, thanks, I'll give that a try. I've also noticed problems with CMRs - adding and then removing a key to a CMR causes problems when generating deploy code. After restarting Studio things seem better.
I'll try the patch.
cheers
Tim

Hi again.
I've got another problem now where my backend mapping editor isn't mapping stuff. The editor shows a mapping between a primary key field on the table and the key field in the bean, but when I build it says :
The attribute: productRef in CMP bean: Product is not mapped in file: META-INF/backends/ORACLE_V9_1/Map.mapxmi.
Most annoying - I really don't want to have to start hand editing map.mapxmi.
Any ideas anyone?
cheers
Tim

...and now my ejb-ql editor doesn't work properly - when I select a query in the ejb deployment descriptor editor and hit 'edit' i get a huuuuuuuuuuuuuuuuuuge dialog box that stretched right across the screen and it doesn't make changes properly to the queries in ejb-jar.xml.
Any known bugs associated with this behaviour? More to the point, any patches available?
cheers
Tim

Hmmm
WASD5.0 has started doing strange things for me - it keeps saying 'An error has occured running Attribute Map Validation.' and then runs it ok after restarting. It had also forgotten about projects & files being in CVS (no label decorations etc.) until I hit 'Refresh', then it remembers.
My colleague is also suffering runtime errors and severe performance degradation that seemingly weren't there before the weekend.
Just wondering if any other UK users have seen any strange behaviour since the clocks changed over the weekend (I'm not clutching at straws then!) Unless of course our cleaners have been mucking about with our code over the weekend (not very likely).
cheers
Tim

Forget that, I'm sorted now. I suppose I could've used java.awt.print.* but in fact all I need to do is open a socket and shove some text down it.
ttfn
Tim

Hi
I wanted to use the Java Printing Service to print from my app (WAS5.0), but it's not in the JDK that comes with WAS5/WSAD5.
What should I use instead? Or is there a way I can use JPS?
cheers
Tim

No, no converter on that column. I didn't think I needed one... the database column is a number(9,0), the EJB field is an Integer.
Using Oracle 9i, if that makes a difference.

Hi.
I'm a bit stuck with an error I'm getting when building my deploy code. When the compiler starts to generate my EJBQL queries it bombs with the error
'Error generating findMenuGroupsByGroupID(java.lang.Integer) query for bean MenuGroup (Abstract schema name=MenuGroup). Error=query cannot be pushed down Query='select object(o) from MenuGroup o where o.menuGroupID = ?1'
Does anyone have any idea what 'query cannot be pushed down' means? The parameter the query takes is an Integer.
Any help appreciated.
cheers
Tim

I'm sorted now (thank you Stephen).
The problem was I hadn't configured the reference from the session to the entity bean. (References tab in the EJB deployment descriptor).
So there we are.
'tra.
Tim