I slay'd the beast!

driver.

- j-




On Nov 20, 2008, at 3:36 PM, Chuck Hill wrote:

Hi James,


On Nov 20, 2008, at 1:26 PM, James Cicenia wrote:

Well I did and you were right. Surprise.

:-P


I added a try / catch to print out the exception.

STEP 12:: com.webobjects.foundation.NSForwardException [com.webobjects.jdbcadaptor.JDBCAdaptorException] EvaluateExpression failed: <com.webobjects.jdbcadaptor.MySQLPlugIn $MySQLExpression: "SELECT DISTINCT t0.ADDUSER, t0.AFFILIATE, t0.DATEADDED, t0.DATEMODIFIED, t0.GRAPHICBLEEDBOTTOM, t0.GRAPHICBLEEDTOP, t0.GRAPHICHEIGHT, t0.GRAPHIC_SUBSTRATES, t0.GRAPHICWIDTH, t0.INDEXED, t0.MODUSER, t0.MSRP, t0.NAMELONG, t0.NAMESHORT, t0.PARTNUM, t0.PRICE1, t0.PRICE2, t0.PRICE3, t0.PRICE4, t0.PRICE5, t0.PUBLISH, t0.QUALITYLEVEL, t0.RESOURCEID, t0.SEQUENCE_NUMBER, t0.SHIPPING_DIMENSIONS, t0.SHIPPING_WEIGHT, t0.SIZE, t0.TEXTDESC, t0.WEIGHT FROM Product t0 WHERE t0.RESOURCEID IN (( ( SELECT t0.RESOURCEID FROM ProductTag t0 WHERE t0.TAGID = 35 ) ) ) ORDER BY t0.DATEADDED DESC">: Next exception:SQL State:21000 -- error code: 1242 -- msg: Subquery returns more than 1 row: com.wirehose.base.WHTagDataSource [e9ac0f5].fetchResourcesIntoEditingContext() - Exception fetching resources for entity "Product":

Now this has me totally perplexed. The Subquery is supposed to return more than 1 row!?
mysql 5.0+

thoughts?

That is a MySQL(toy) issue. I take it that this works on OS X but not on Linux. I'd compare the MySQL versions and configuration on the two machines. Enjoy!

Chuck



On Nov 20, 2008, at 1:59 PM, Chuck Hill wrote:


On Nov 20, 2008, at 7:45 AM, James Cicenia wrote:

Ok -

Good morning... after sleeping on it... nothing.

When I did not do your session cheat... it complains on startup about javax.mail.session.
It all works great on my dev and my old server.

Now with your cheat I found the following issues (which don't seem to send anything out to the log?!)

1)   public WHSession createSessionForRequest(WORequest aRequest) {
           return new com.hb.Session();
 }

My direct action just seems to burb.. it throws nothing but definitely doesn't
go beyond the following statement:

nextPage .takeValueForKey (tag .resources (((Session )session()).defaultEditingContext(),"Product"),"resources");

because I have a System.out afterwards and it doesn't get there!?

Any other thoughts (besides wonderizing)?

Break.  It.  Down.  Think.  It.  Though.

You have _three_ things happening there:

1. ((Session)session()).defaultEditingContext() - with BTW a totally needless cast that Eclipse can warn you about
2. tag.resources(ec, "Product")
3. nextPage.takeValueForKey(resources, "resources");

So, which one is blocking? Where? Add some more logging. Run it and get a thread dump from the instance.


Chuck


On Nov 19, 2008, at 10:34 PM, Chuck Hill wrote:


On Nov 19, 2008, at 8:22 PM, James Cicenia wrote:

ok -

1) All new projects will be wonderized, I promise.
2) I will refactor a large app next year into wonder.
3) In the meantime....

What does choke mean? Good question, how about, like nothing goes to the log file after this call:

nextPage .takeValueForKey (tag .resources (((Session )session()).defaultEditingContext(),"Product"),"resources");

so, my suspicion lies in the session handling now that bundles get bungled.

This is by far the worst thing about webobjects... setting up a new server.

Try deploying other things!


Something is always missed.

Narrow it down more. It makes no sense that it would hang on a call to defaultEditingContext(). The EC is already locked at that point.

Chuck


On Nov 19, 2008, at 10:07 PM, Chuck Hill wrote:


On Nov 19, 2008, at 7:57 PM, James Cicenia wrote:

OK -

I got my application to launch on Linux! WooHoo!

Now, I was originally getting a weir javax,mail.session vs. my session, so I did the
Chuck Cheatâ„¢:

public WHSession createSessionForRequest(WORequest aRequest) {
           return new com.hb.Session();
}

Using a modern version of Wonder (with ERExtensions first on the classpath) should obviate the need to do this.


Anything like ((Session)session()).setXXX works fine.
However when it got to session().defaultEditingContext() it choked.

Thoughts?

Mostly that you always keep a card or three hidden when asking questions. But what the heck, I will play. What specifically does "choked" mean in this context?


Chuck


--
Chuck Hill             Senior Consultant / VP Development

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects







_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-deploy mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-deploy/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to