Re: [JBoss-user] connecting to Oracle
Thanks for answering dexter I got the latest version of driver I did put the classes1.2 in the dir. waiting for you settings in jboss.jcml (right?) that´s mine: mbean code=org.jboss.jdbc.JdbcProvider name=DefaultDomain:service=JdbcProvider attribute name=Driversoracle.jdbc.driver.OracleDriver/attribute attribute name=Driversorg.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver/att ribute /mbean mbean code=org.jboss.jdbc.XADataSourceLoader name=DefaultDomain:service=XADataSource,name=OracleDS attribute name=PoolNameOracleDS/attribute attribute name=DataSourceClassorg.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp l/attribute attribute name=URLjdbc:oracle:thin:@sc2:1521:cad/attribute attribute name=JDBCUsercons_tre/attribute attribute name=Passwordpcdigital/attribute attribute name=MinSize2/attribute attribute name=IdleTimeout180/attribute attribute name=IdleTimeoutEnabledfalse/attribute /mbean At 06:56 06/06/01 -0700, you wrote: Emerson, use the latest JDBC drivers from Oracle (i think it's 8.1.7 at the moment) that supports the jdbc 2 extensions (javax.sql.* package)...it should work with 8.05 (documented by oracle)...and it's the same db version we use and it works without a hitch with minerva... i'll post my settings when i get home... and don't forget to put the classes12.zip (oracle JDBC zip file) in lib\ext dir... dexter --- Emerson [EMAIL PROTECTED] wrote: I´m trying to configure JBoss to use oracle version 8.0.5.2.2. I read about a version of a server-side thin driver. What driver shoud I use?? May I should configure jboss.xa.xidclass propertie? (i did) Is it possible to use that version of oracle with minerva connection pool??? how? I did the configuration as is told in the documentation I'm getting the following error : [OracleDS] XA Connection pool OracleDS bound to java:/OracleDS [OracleDS] Stopped [OracleDS] java.lang.NullPointerException [OracleDS] at org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection( XAPoolDataSource.java:165) [OracleDS] at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLo ader.java:330) [OracleDS] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport. java:93) [OracleDS] at java.lang.reflect.Method.invoke(Native Method) [OracleDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl .java:1628) [OracleDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl .java:1523) [OracleDS] at org.jboss.util.ServiceControl.start(ServiceControl.java:97) [OracleDS] at java.lang.reflect.Method.invoke(Native Method) [OracleDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl .java:1628) [OracleDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl .java:1523) [OracleDS] at org.jboss.Main.init(Main.java:203) [OracleDS] at org.jboss.Main$1.run(Main.java:107) [OracleDS] at java.security.AccessController.doPrivileged(Native Method) [OracleDS] at org.jboss.Main.main(Main.java:103) Emerson Cargnin TRE-SC Setor de Desenvolvimento Tel: (48) 251-3700 - Ramal 3134 ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user Emerson Cargnin TRE-SC Setor de Desenvolvimento Tel: (48) 251-3700 - Ramal 3134 ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user
RE: [JBoss-user] connecting to Oracle
Hi Emerson, this is not totally correct ; the first part should look like this : mbean code=org.jboss.jdbc.JdbcProvider name=DefaultDomain:service=JdbcProvider attribute name=Driversoracle.jdbc.driver.OracleDriver,org.hsql.jdbcDriver,org.e nhydra.instantdb.jdbc.idbDriver/attribute /mbean if you are not useing the enhydra or hypers. SQL you should remove those drivers. -- the second part : mbean code=org.jboss.jdbc.XADataSourceLoader name=DefaultDomain:service=XADataSource,name=OracleDS attribute name=PoolNameOracleDS/attribute attribute name=DataSourceClassorg.opentools.minerva.jdbc.xa.wrapper.XADataSourc eImpl/attribute attribute name=URLjdbc:oracle:thin:@sc2:1521:cad/attribute attribute name=JDBCUsercons_tre/attribute attribute name=Passwordpcdigital/attribute attribute name=MinSize2/attribute attribute name=IdleTimeout180/attribute attribute name=IdleTimeoutEnabledfalse/attribute /mbean looks ok to me, I would though add attribute name=LoggingEnabledtrue/attribute be sure that all your attributes in the connection url are correct. it´s configured this way : jdbc:oracle:thin:@hostName:portNumber:InstanceName btw instanceName != databasename (an error many do when they do this for the first time). hope it helps, Reynir Þór Hübner [EMAIL PROTECTED] CTO / intmeta.com -Original Message- From: Emerson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 3:50 PM To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] connecting to Oracle Thanks for answering dexter I got the latest version of driver I did put the classes1.2 in the dir. waiting for you settings in jboss.jcml (right?) that´s mine: mbean code=org.jboss.jdbc.JdbcProvider name=DefaultDomain:service=JdbcProvider attribute name=Driversoracle.jdbc.driver.OracleDriver/attribute attribute name=Driversorg.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver /att ribute /mbean At 06:56 06/06/01 -0700, you wrote: Emerson, use the latest JDBC drivers from Oracle (i think it's 8.1.7 at the moment) that supports the jdbc 2 extensions (javax.sql.* package)...it should work with 8.05 (documented by oracle)...and it's the same db version we use and it works without a hitch with minerva... i'll post my settings when i get home... and don't forget to put the classes12.zip (oracle JDBC zip file) in lib\ext dir... dexter --- Emerson [EMAIL PROTECTED] wrote: I´m trying to configure JBoss to use oracle version 8.0.5.2.2. I read about a version of a server-side thin driver. What driver shoud I use?? May I should configure jboss.xa.xidclass propertie? (i did) Is it possible to use that version of oracle with minerva connection pool??? how? I did the configuration as is told in the documentation I'm getting the following error : [OracleDS] XA Connection pool OracleDS bound to java:/OracleDS [OracleDS] Stopped [OracleDS] java.lang.NullPointerException [OracleDS] at org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection( XAPoolDataSource.java:165) [OracleDS] at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLo ader.java:330) [OracleDS] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport. java:93) [OracleDS] at java.lang.reflect.Method.invoke(Native Method) [OracleDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl .java:1628) [OracleDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl .java:1523) [OracleDS] at org.jboss.util.ServiceControl.start(ServiceControl.java:97) [OracleDS] at java.lang.reflect.Method.invoke(Native Method) [OracleDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl .java:1628) [OracleDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl .java:1523) [OracleDS] at org.jboss.Main.init(Main.java:203) [OracleDS] at org.jboss.Main$1.run(Main.java:107) [OracleDS] at java.security.AccessController.doPrivileged(Native Method) [OracleDS] at org.jboss.Main.main(Main.java:103) Emerson Cargnin TRE-SC Setor de Desenvolvimento Tel: (48) 251-3700 - Ramal 3134 ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user Emerson Cargnin TRE-SC Setor de Desenvolvimento Tel: (48) 251-3700 - Ramal 3134 ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user ___ JBoss-user mailing list
Re: [JBoss-user] connecting to Oracle
Thanks for answering dexter it started : (is this right?) [OracleDS] Pool OracleDS created a new object: org.opentools.minerva.jdbc.xa.wra pper.XAConnectionImpl@695a56 [OracleDS] 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. [OracleDS] Pool OracleDS created a new object: org.opentools.minerva.jdbc.xa.wra pper.XAConnectionImpl@7fc686 [OracleDS] XA Connection pool OracleDS bound to java:/OracleDS [OracleDS] No transaction right now. [OracleDS] Pool OracleDS [1/2/Unlimited] gave out pooled object: org.opentools.m inerva.jdbc.xa.wrapper.XAConnectionImpl@695a56 [OracleDS] Pool OracleDS [0/2/Unlimited] returned object org.opentools.minerva.j dbc.xa.wrapper.XAConnectionImpl@695a56 to the pool. [OracleDS] Started I got the latest version of driver I did put the classes1.2 in the dir. waiting for you settings in jboss.jcml (right?) that´s mine: mbean code=org.jboss.jdbc.JdbcProvider name=DefaultDomain:service=JdbcProvider attribute name=Driversoracle.jdbc.driver.OracleDriver/attribute attribute name=Driversorg.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver/att ribute /mbean mbean code=org.jboss.jdbc.XADataSourceLoader name=DefaultDomain:service=XADataSource,name=OracleDS attribute name=PoolNameOracleDS/attribute attribute name=DataSourceClassorg.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp l/attribute attribute name=URLjdbc:oracle:thin:@sc2:1521:cad/attribute attribute name=JDBCUsercons_tre/attribute attribute name=Passwordpcdigital/attribute attribute name=MinSize2/attribute attribute name=IdleTimeout180/attribute attribute name=IdleTimeoutEnabledfalse/attribute /mbean At 06:56 06/06/01 -0700, you wrote: Emerson, use the latest JDBC drivers from Oracle (i think it's 8.1.7 at the moment) that supports the jdbc 2 extensions (javax.sql.* package)...it should work with 8.05 (documented by oracle)...and it's the same db version we use and it works without a hitch with minerva... i'll post my settings when i get home... and don't forget to put the classes12.zip (oracle JDBC zip file) in lib\ext dir... dexter --- Emerson [EMAIL PROTECTED] wrote: I´m trying to configure JBoss to use oracle version 8.0.5.2.2. I read about a version of a server-side thin driver. What driver shoud I use?? May I should configure jboss.xa.xidclass propertie? (i did) Is it possible to use that version of oracle with minerva connection pool??? how? I did the configuration as is told in the documentation I'm getting the following error : [OracleDS] XA Connection pool OracleDS bound to java:/OracleDS [OracleDS] Stopped [OracleDS] java.lang.NullPointerException [OracleDS] at org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection( XAPoolDataSource.java:165) [OracleDS] at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLo ader.java:330) [OracleDS] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport. java:93) [OracleDS] at java.lang.reflect.Method.invoke(Native Method) [OracleDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl .java:1628) [OracleDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl .java:1523) [OracleDS] at org.jboss.util.ServiceControl.start(ServiceControl.java:97) [OracleDS] at java.lang.reflect.Method.invoke(Native Method) [OracleDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl .java:1628) [OracleDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl .java:1523) [OracleDS] at org.jboss.Main.init(Main.java:203) [OracleDS] at org.jboss.Main$1.run(Main.java:107) [OracleDS] at java.security.AccessController.doPrivileged(Native Method) [OracleDS] at org.jboss.Main.main(Main.java:103) Emerson Cargnin TRE-SC Setor de Desenvolvimento Tel: (48) 251-3700 - Ramal 3134 ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user Emerson Cargnin TRE-SC Setor de Desenvolvimento Tel: (48) 251-3700 - Ramal 3134 ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user