Guy: your example worked. The difference that made it work was the
specification of "OracleDB" rather than "OracleDS".
Whoever maintains http://www.jboss.org/documentation/HTML/ch03s05.html,
please
correct the example, as it specified "OracleDS", which doesn't work, and
has
caused at least two other people the same failure.
The following is an example of the console log as it looks when Oracle
connectivity works..
[OracleDB] Starting
[OracleDB] XA Connection pool OracleDB bound to java:/OracleDB
[OracleDB] org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl
created new Co
nnection (oracle.jdbc.driver.OracleConnection) with XAResource
org.opentools.min
erva.jdbc.xa.wrapper.XAResourceImpl and XAConnection
org.opentools.minerva.jdbc.
xa.wrapper.XAConnectionImpl.
[OracleDB] No transaction right now.
[OracleDB] Pool OracleDB [0/0/Unlimited] gave out new object:
org.opentools.mine
rva.jdbc.xa.wrapper.XAConnectionImpl@b8914
[OracleDB] Pool OracleDB [0/1/Unlimited] returned object
org.opentools.minerva.j
dbc.xa.wrapper.XAConnectionImpl@b8914 to the pool.
[OracleDB] Started
[Service Control] Started 26 services
[Default] JBoss 2.2.2 Started in 0m:33s
Guy Rouillier wrote:
> ----- Original Message -----
> From: "David Filiatrault" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, June 05, 2001 11:32 AM
> Subject: Re: [JBoss-user] NullPointerException in XAPoolDataSource.java:165
>
> > Yes, I know I'm using an unusual port. I verified it was working using
> > tnsping. If it was a problem connecting to Oracle, I would expect to see
> an SQL
> > Exception logged before this NullPointerException. Is this a valid
> expectation?
>
> No. If it can't get a connection, you'll just get a null pointer, because
> with no connection, nothing gets added to the connection pool and you have
> no connection object.
>
> >
> > Does anybody have a jboss.jcml which does work with Oracle? If so, please
> post
> > it (and feel free to xxx out the password), as I've gotten two emails from
> other
> > users who say they have the same problem.
> >
> > -David
> >
>
> Note that if you are running 2.2.2, the pool name has changed to JBossPool.
> I haven't upgraded yet.
>
> <mbean code="org.jboss.jdbc.XADataSourceLoader"
> name="DefaultDomain:service=XADataSource,name=OracleDB">
> <attribute name="PoolName">OracleDB</attribute>
> <attribute
> name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
> l</attribute>
> <attribute
> name="URL">jdbc:oracle:thin:@localhost:1521:homedb</attribute>
> <attribute name="LoggingEnabled">true</attribute>
> <attribute name="JDBCUser">guyr</attribute>
> <attribute name="Password">xxxxx</attribute>
> </mbean>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
