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/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
