Hi,
I use Oracle 8.1.7 and its thin driver. For BMP, it runs. It tooks such a
long time to find the solution but now, it is OK.
For CMP use, i have still a couple of problems but i start a new testing
session ;-) ...
I use Win2000 and jboss 2.0 final
The main thing i got was "id may not be null" The mistake was in my code
when i getConnection. Here is the good code:
private Connection getConnection() throws SQLException {
DataSource ds = null;
try {
Context ctx = new InitialContext();
ds = (DataSource)ctx.lookup("java:/oracleDB");
} catch(NamingException ne) {
} finally {
return ds.getConnection();
}
}
Perhaps this could help somebody
JMi
----Original Message Follows----
From: Ole Husgaard <[EMAIL PROTECTED]>
Reply-To: "jBoss" <[EMAIL PROTECTED]>
To: jBoss <[EMAIL PROTECTED]>
Subject: Re: [jBoss-User] JBOSS and Oracle
Date: Thu, 25 Jan 2001 11:57:54 +0100
MIME-Version: 1.0
Received: from [205.227.191.14] by hotmail.com (3.2) with ESMTP id
MHotMailBC3950B5000DD821EED5CDE3BF0ED0F60; Thu Jan 25 02:54:10 2001
Received: from sparre.dk by cgi.clearink.com with SMTP; Thu, 25 Jan 2001
02:29:58 -0800
>From [EMAIL PROTECTED] Thu Jan 25 02:56:09 2001
Sender: <[EMAIL PROTECTED]>
Message-ID: <[EMAIL PROTECTED]>
Organization: Sparre Software
X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.2.12-20 i586)
X-Accept-Language: da,sv,no,de
References:
<[EMAIL PROTECTED]>
Precedence: Bulk
List-Software: LetterRip Pro 3.0.7 by Fog City Software, Inc.
List-Subscribe: <mailto:[EMAIL PROTECTED]>
List-Digest: <mailto:[EMAIL PROTECTED]>
List-Unsubscribe: <mailto:[EMAIL PROTECTED]>
Hi,
> "Bolt, Dave" wrote:
> I've tried the 8.1.7 drivers against the 8.1.6 database both with and
without the
> jboss.conf change. The end result is no difference. I've downloaded the
8.1.7 server
> too, but we haven't installed it anywhere as a test.
>
> Another user suggested that I try the OCI driver instead of the thin
driver. I've
> placed the following URL in my jboss.jcml file for my datasource
Since Darius Davidavicius has the 8.1.6 OCI driver
working, it must be possible to make that work for
other people.
Darius has classes12.zip in the CLASSPATH, and having
it in the boot class path should work too. However, I
am not sure if declaring it in the MLET will work.
Please try to remove classes12.zip from your MLET
declaration, and add it to your CLASSPATH, or copy
it to lib/ext.
> As another test, we were going to try another DB server (PostGresQL) if
we could find
> one that claimed to have true XA support, to see if it really is an
Oracle problem.
Being a PostgreSQL user, I had a look at the source
of the early XA driver. It looked to me like it just
did the same hack as the Minerva XA driver shim, so
I stayed with Minerva XA over non-XA PostgreSQL driver.
Don't know if this has changed.
But I guess it should work, except maybe for the
isolation problem if the PostgreSQL XA drivers still
work like the Minerva XA shim.
> The only other issue, is that it could be something in my code. For
reference here is the
> code that is getting the connection from JNDI. I am turning off
autocommit manually, because
> I saw somewhere that the pool provided connections with autocommit ON.
It makes sense to turn autocommit off, but that could
also be the source of your problem: The error message
of your second problem indicates that Oracle may be
using some kind of master connection to control the XA
transaction, and hand out subordinate connections to
the user. The transactions in the subordinate
connections would then be nested transactions to the
XA transaction controlled by JBoss and a hidden Oracle
master connection.
Not sure if this is true. But if it is, I guess turning
off autocommit on your connections could result in your
isolation problem.
I would try the OCI driver without changing the
autocommit property of the connections.
Please let us know how this works out, even if your
problems disappear. Seems like there are lots of
people currently having problems with the Oracle XA
datasource.
Best Regards,
Ole Husgaard.
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
