Hello, Thanks so much for your advice. The JDBC driver when I was running from my machine and connecting to the database was ok, but apparently it was not ok when I was running from the server. I did as you suggested: COMPLETELY removed the driver and it complained about another error message, so I figured that it needed something in there. Then I substituted my old driver (classes12.zip) with ojdbc14.jar and voila! (Note: The server did not seem to immediately pick up the change, so it took like 2 mins to find that the new driver was there, not sure why..) Anyways, all happy in our land!
Thank you so much for your advice! My problem is now solved, I'm not sure how to close this issue though :) ~Mersida --- On Fri, 8/8/08, Mike Schrag <[EMAIL PROTECTED]> wrote: From: Mike Schrag <[EMAIL PROTECTED]> Subject: Re: WO App written in WO 5.4 won't run on Leopard Server with WO 5.4 To: "WebObjects Dev" <[email protected]> Date: Friday, August 8, 2008, 9:49 AM My rules with Oracle:1) 97.271% of problems are the oracle JDBC driver.2) If you think you fall into the other part (you add up to 105% with your #, but with Oracle, I believe that to be possible :) ) you're USUALLY not right and should recheck everything about #1.3) If you really are OK with #1, then whatever the problem is, it's going to be a huge pain in the ass, so go back and triple check #1 again before you set out on foot. But more seriously ...Which version of Oracle are you using?Which JDBC driver did you get?Where did you install the JDBC driver?When you say it "runs fine on your machine" are you talking to same Oracle server that production is? Can you test it out? If it works on yours with the same server, this is very good news, because it means Oracle itself is OK. Can you attempt to talk to the production database on the Oracle server from your machine? Can you attempt to talk to the development database from the production machine? If all of these work, then I increase my number to 99.1% that you are wrong about the JDBC driver.If you think the JDBC driver is in the right place, delete it completely and try to run your app. This should completely fail. If it doesn't, it wasn't in the right place.Basically you want to verify all of your assumptions here, because it's way easier to fix a simple incorrect assumption than to fix Oracle server. As far as the CFPrefs error, that's definitely kind of weird. Random factoids/guesses that may or may not be related -- "99" is the "sn" that gets assigned in LDAP when you upgrade TO tiger ... Maybe there are other values that can get set to that, too .. Not sure. What user are you actually running your app as? appserverusr is what it should be. You can look at the definition of appserverusr and see if there's a 99 anywhere in the user record. That it's using a "99" may completely be coincidence, though -- just passing on a 99 I've seen before which might point you in the right direction. I'm guessing that java.util.prefs on OS X is probably backed by CFPreferences, so possibly something is touching that API, though this is also a guess. Did that only appear after upgrading the Oracle driver? If so, I guess we know who's touching that API. What there error is likely saying, in a really obtuse way, is that because it can't find your home directory, it can't write out your app preferences, which means when your app shuts down, your prefs will be gone. So if you are depending on prefs crossing app runs, you're out of luck. ms On Aug 8, 2008, at 8:52 AM, Mersida Kurti wrote: Hi Mike, What's the other 7.729% related to? :) Now, In addition to that error message, I also see the following: Are they related? 2008-08-08 08:50:49.995 java[65633:117] CFPreferences: user home directory at /Library/WebObjects/Applications/SOARTransactionNotifier.woa/99 is unavailable. User domains will be volatile. Thanks, Mersida --- On Thu, 8/7/08, Mike Schrag <[EMAIL PROTECTED]> wrote: From: Mike Schrag <[EMAIL PROTECTED]> Subject: Re: WO App written in WO 5.4 won't run on Leopard Server with WO 5.4 To: "WebObjects Dev" <[email protected]> Date: Thursday, August 7, 2008, 6:59 PM 97.271% of all crazy problems with Oracle are related to having the incorrect JDBC driver for the version of Oracle you're using. Verify (by verify, I mean assume it's wrong and redownload) that the JDBC driver you're using is 1) the actual file you expect (meaning, in your classpath that it's pointing to the file you think it is), 2) the version that matches your database, and 3) being loaded by the correct classloader. ms On Aug 7, 2008, at 6:51 PM, Mersida Kurti wrote: Hi everyone, We've stumbled into yet another issue lately and I'm hoping someone has seen in before. We have switched our development and server environment to Leopard with WO 5.4.2 The applications run fine on my local machine, however, when I deploy them to the server, I get the following message when I try to run the apps from the command line: 8039 [main] INFO er.extensions.ERXNSLogLog4jBridge - A fatal exception occurred: EvaluateExpression failed: <com.webobjects.jdbcadaptor.OraclePlugIn$OracleExpression: "SELECT t0.APPLICATION, t0.KEY, t0.KEYCHAIN_ID FROM KEYCHAIN t0 WHERE t0.APPLICATION = ?" withBindings: 1:"SOARFramework"(application)>: Next exception:SQL State:60000 -- error code: 600 -- msg: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], [] _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/muc154%40yahoo.com This email sent to [EMAIL PROTECTED] _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/muc154%40yahoo.com This email sent to [EMAIL PROTECTED]
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
