Hi,
Many Thanks David. Its finally working. JBoss actually converts the
jboss.jcml entry:
> > jboss.jcml //this is the last entry
> > ...
> > <mbean
> > name="DefaultDomain:service=XADataSource,name=oraclePool">
> > <attribute
> > name="DataSourceClass">oracle.jdbc.xa.client.OracleXADataSourc
> > e</attribute>
> > <attribute
> > name="URL">jdbc:oracle:thin:@192.168.0.1:1521:oracledb</attribute>
> > <attribute name="JDBCUser">testdb</attribute>
> > <attribute name="Password">password</attribute>
> > </mbean>
> > ..
to
<mbean name="DefaultDomain:service=XADataSource,name=oraclePool">
<attribute name="Properties"></attribute>
<attribute
name="URL">jdbc:oracle:thin:@192.168.0.1:1521:oracledb</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">testdb</attribute>
<attribute name="MaxSize">0</attribute>
<attribute name="Password">password</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
</mbean>
giving the impression that it has deleted the entry in the jcml file. (but
without the proper URL,JDBCUser & Password entry)
I had to reenter them.
Anyway once this is done. The oracle connection pool can be bound.
At 10:43 PM 2/26/01 -0600, you wrote:
>Do NOT put your MLet at the top of jboss.conf. The Logger MLet must be at
>the top. Put yours at the bottom or somewhere.
>
> > -----Original Message-----
> > From: Lee Thian Urn [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, February 26, 2001 10:27 PM
> > To: JBoss-User
> > Subject: Re: [jBoss-User] Connection pool configuration problem
> >
> >
> > Hello Alexander,
> >
> > I'm having the same error message. I've set the jboss.properties,
> > jboss.conf & jboss.jcml exactly like your setting. Reinstalling JBoss
> > doesn't help. Could you elaborate on what you did to get
> > Oracle 8.1.7 to
> > work with JBoss. My configuration files are as below:
> > Thanks,
> >
> > jboss.jcml //this is the last entry
> > ...
> > <mbean
> > name="DefaultDomain:service=XADataSource,name=oraclePool">
> > <attribute
> > name="DataSourceClass">oracle.jdbc.xa.client.OracleXADataSourc
> > e</attribute>
> > <attribute
> > name="URL">jdbc:oracle:thin:@192.168.0.1:1521:oracledb</attribute>
> > <attribute name="JDBCUser">testdb</attribute>
> > <attribute name="Password">password</attribute>
> > </mbean>
> > ..
> >
> > jboss.conf //this is right at the top
> > ...
> > <MLET CODE = "org.jboss.jdbc.XADataSourceLoader"
> > ARCHIVE="jboss.jar,classes12.zip" CODEBASE="../lib/ext/">
> > <ARG TYPE="java.lang.String" VALUE="oraclePool">
> > <ARG TYPE="java.lang.String"
> > VALUE="oracle.jdbc.xa.client.OracleXADataSource">
> > </MLET>
> > ..
> >
> >
> > jboss.properties //this is the complete file
> >
> > # System properties
> > # These will be loaded and set by jBoss
> > #java.rmi.server.useLocalHostName=true
> > #java.rmi.server.hostname=localhost
> > #java.rmi.server.codebase=http://localhost:8080/
> > #jboss.xa.xidclass=oracle.jdbc.xa.OracleXid
> >
> > jdbc.drivers=oracle.jdbc.driver.OracleDriver,org.hsql.jdbcDriv
> > er,org.enhydra.instantdb.jdbc.idbDriver
> >
> > #java.security.manager=java.lang.SecurityManager
> >
> > java.security.auth.login.config==../conf/default/auth.conf
> >
> >
> > regards,
> > Thian Urn.
> >
> >
> > At 01:20 AM 2/24/01 +0100, you wrote:
> > >Sorry for the false alarm, it works now. I don't know why, I just
> > >reinstalled jboss and repeated all the steps...
> > >
> > >Alexander Jerusalem
> > >
> > >
> > >At 00:46 24.02.01, you wrote:
> > >>Hi,
> > >>
> > >>I'm having troubles configuring a database connection pool
> > for Oracle.
> > >>I've been following the steps in the manual but at jboss
> > startup I'm
> > >>getting the following exception:
> > >>
> > >>javax.management.ReflectionException: The MBean class could
> > not be loaded
> > >>by the specified loader
> > >> at
> > >>
> > com.sun.management.jmx.MBeanServerImpl.createMBean(MBeanServer
> > Impl.java:754)
> > >> at
> > javax.management.loading.MLet.getMBeansFromURL(MLet.java:540)
> > >> at
> > javax.management.loading.MLet.getMBeansFromURL(MLet.java:369)
> > >> at org.jboss.Main.<init>(Main.java:119)
> > >> at org.jboss.Main$1.run(Main.java:87)
> > >> at
> > java.security.AccessController.doPrivileged(Native Method)
> > >> at org.jboss.Main.main(Main.java:83)
> > >>
> > >>The driver itself is loaded without problems according to
> > what I see on
> > >>the screen:
> > >>[JDBC] Loaded JDBC-driver:oracle.jdbc.driver.OracleDriver
> > >>
> > >>And the funny thing is that my entries in jboss.jcml are
> > removed during
> > >>the startup process. Here's what I have written to the config files:
> > >>
> > >>in jboss.properties:
> > >>jboss.xa.xidclass=oracle.jdbc.xa.OracleXid
> > >>jdbc.drivers=org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.
> > idbDriver,oracle.jdbc.driver.OracleDriver
> > >>
> > >>in jboss.conf (right at the beginning):
> > >><MLET CODE="org.jboss.jdbc.XADataSourceLoader"
> > >>ARCHIVE="jboss.jar,classes12.zip" CODEBASE="../lib/ext/">
> > >> <ARG TYPE="java.lang.String" VALUE="ArchProtOracle">
> > >> <ARG TYPE="java.lang.String"
> > >> VALUE="oracle.jdbc.xa.client.OracleXADataSource">
> > >></MLET>
> > >>
> > >>in jboss.jcml:
> > >><mbean
> > name="DefaultDomain:service=XADataSource,name=ArchProtOracle">
> > >> <attribute
> > >> name="URL">jdbc:oracle:thin:@127.0.0.1:1521:oracle</attribute>
> > >> <attribute name="JDBCUser">myusername</attribute>
> > >> <attribute name="Password">mypassword</attribute>
> > >></mbean>
> > >>
> > >>
> > >>Any hints would be very much appreciated
> > >>
> > >>Alexander Jerusalem
> > >>[EMAIL PROTECTED]
> > >>vknn
> > >>
> > >>
> > >>
> > >>--
> > >>--------------------------------------------------------------
> > >>To subscribe: [EMAIL PROTECTED]
> > >>To unsubscribe: [EMAIL PROTECTED]
> > >>List Help?: [EMAIL PROTECTED]
> > >
> > >
> > >
> > >--
> > >--------------------------------------------------------------
> > >To subscribe: [EMAIL PROTECTED]
> > >To unsubscribe: [EMAIL PROTECTED]
> > >List Help?: [EMAIL PROTECTED]
> >
> >
> > _________________________________________________________
> > Do You Yahoo!?
> > Get your free @yahoo.com address at http://mail.yahoo.com
> >
> >
> >
> > --
> > --------------------------------------------------------------
> > To subscribe: [EMAIL PROTECTED]
> > To unsubscribe: [EMAIL PROTECTED]
> > List Help?: [EMAIL PROTECTED]
> >
>
>
>
>
>
>---------------------------------------------------------------------
>This message (including any attachments) contains confidential, proprietary
>or privileged information intended for a specific purpose and individual(s),
>and is protected by law. If you receive this message in error, please
>immediately delete it and all copies of it from your system, destroy any
>hard copies of it and notify the sender. Any unauthorized disclosure,
>copying or distribution of any part of this message, or the taking of any
>unauthorized action based on it, is strictly prohibited.
>
>
>--
>--------------------------------------------------------------
>To subscribe: [EMAIL PROTECTED]
>To unsubscribe: [EMAIL PROTECTED]
>List Help?: [EMAIL PROTECTED]
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
