5 Replies Latest reply on Apr 8, 2004 11:14 AM by calffin

    Can any one direct me to configure jboss3.08 with oracle9i s

    calffin Newbie

      I use jboss3.08 and oracle9i release2 9.2.0.1. I don't know how to configure them to be work together succussfully. Configuring jboss3.08 with oracle9i is different from configuring 3.2.x with oracle9i because the configuration files under %jboss_home%\server\default\deploy are different in the tow version.When I deploy CMPBean in the jboss with lomboz for eclipse , it seemed that something wrong happened.
      Can anybody help me with tell me how to configure jboss3.08 with oracle9i step by step? I ask for the details. It had best to be your succussful story. I will thank you a million and give you my best regards!

        • 1. Re: Can any one direct me to configure jboss3.08 with oracle
          Kris Kristensen Newbie

          I haven't tried it with Oracle 9.2.0.1 but we do have Oracle 9.2.0.4 in production with Jboss 3.0.8
          First you'll have to download and copy the JDBC-driver(ojdbc14.jar) to your configuration's lib directory. The driver is available from Oracle's homepage.
          Second copy either the oracle-xa-service.xml or the oracle-service.xml (depending on the need for xa) from the docs/examples/jca directory to your configuration's lib directory.
          Open the xml file and edit the values for your database. You have two options, either use the thin driver or the oci driver. Remember that the oci driver requires the Oracle Client installation present.
          Make sure your database is on the air and the listener(s) as well.
          That's about it :-)

          /Kris

          • 2. Re: Can any one direct me to configure jboss3.08 with oracle
            calffin Newbie

            Hi,kbk, thank you a lot for your help! Conforming to your direction , I made the change as below(if I did something wrong ,please tell me):
            1 , I get the ojdbc.jar to the %JBOSS_HOME%\server\default\lib
            2. I copy the oracle-service.xml to the %JBOSS_HOME%\server\default\deploy . I edit this file conform to my oracle configuration .
            3. I start up the oraclelistener and database service
            I found that the first time I start the jboss server it seemed it's ok except the exception information below(Have you ever seen it when you deployed your CMPBean using oracle9i?):

            11:34:13,937 WARN [ServiceController] Problem starting service jboss.j2ee:jndiName=AccountBean,service=EJB
            org.jboss.deployment.DeploymentException: Parameter class not found: String
            at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCQueryMetaDataFactory.getQueryMethods(JDBCQueryMetaDataFactory.java:232)
            at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCQueryMetaDataFactory.createJDBCQueryMetaData(JDBCQueryMetaDataFactory.java:42)
            at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCEntityMetaData.(JDBCEntityMetaData.java:310)
            at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCApplicationMetaData.(JDBCApplicationMetaData.java:117)
            at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCXmlFileLoader.load(JDBCXmlFileLoader.java:52)
            at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadJDBCEntityMetaData(JDBCStoreManager.java:677)
            at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBCStoreManager.java:389)
            at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:339)
            at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:198)
            at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
            at org.jboss.ejb.Container.invoke(Container.java:782)
            at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1058)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
            at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:1003)
            at $Proxy4.start(Unknown Source)
            at org.jboss.system.ServiceController.start(ServiceController.java:413)
            at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
            at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
            at $Proxy32.start(Unknown Source)
            at org.jboss.ejb.EjbModule.startService(EjbModule.java:404)
            at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:165)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
            at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:1003)
            at $Proxy4.start(Unknown Source)
            at org.jboss.system.ServiceController.start(ServiceController.java:413)
            at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
            at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
            at $Proxy15.start(Unknown Source)
            at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:395)
            at org.jboss.deployment.MainDeployer.start(MainDeployer.java:814)
            at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:627)
            at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:591)
            at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
            at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
            at $Proxy3.deploy(Unknown Source)
            at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:435)
            at org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:656)
            at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:507)
            at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:266)
            at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:165)
            at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
            at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:1003)
            at $Proxy0.start(Unknown Source)
            at org.jboss.system.ServiceController.start(ServiceController.java:413)
            at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
            at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
            at $Proxy2.start(Unknown Source)
            at org.jboss.deployment.SARDeployer.start(SARDeployer.java:232)
            at org.jboss.deployment.MainDeployer.start(MainDeployer.java:814)
            at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:627)
            at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:591)
            at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:575)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
            at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:324)
            at org.jboss.system.server.ServerImpl.start(ServerImpl.java:221)
            at org.jboss.Main.boot(Main.java:148)
            at org.jboss.Main$1.run(Main.java:381)
            at java.lang.Thread.run(Thread.java:534)
            11:34:13,984 INFO [EjbModule] Started
            11:34:13,984 INFO [MainDeployer] Deployed package: file:/D:/jboss-3.0.8/server/all/deploy/TicketModule.jar
            11:34:13,984 INFO [MainDeployer] Starting deployment of package: file:/D:/jboss-3.0.8/server/all/deploy/jmx-console.war/
            11:34:14,187 INFO [jbossweb] Registered jboss.web:Jetty=0,JBossWebApplicationContext=2,context=/jmx-console
            11:34:14,734 INFO [jbossweb] Started WebApplicationContext[/jmx-console,file:/D:/jboss-3.0.8/server/all/deploy/jmx-console.war/]
            11:34:14,812 INFO [jbossweb] Registered jboss.web:Jetty=0,JBossWebApplicationContext=2,context=/jmx-console,name=DisplayMBeans
            11:34:14,828 INFO [jbossweb] Registered jboss.web:Jetty=0,JBossWebApplicationContext=2,context=/jmx-console,name=DisplayOpResult
            11:34:14,828 INFO [jbossweb] Registered jboss.web:Jetty=0,JBossWebApplicationContext=2,context=/jmx-console,name=InspectMBean
            11:34:14,859 INFO [jbossweb] Registered jboss.web:Jetty=0,JBossWebApplicationContext=2,context=/jmx-console,name=jsp
            11:34:14,859 INFO [jbossweb] Registered jboss.web:Jetty=0,JBossWebApplicationContext=2,context=/jmx-console,name=HtmlAdaptor
            11:34:14,875 INFO [jbossweb] Registered jboss.web:Jetty=0,JBossWebApplicationContext=2,context=/jmx-console,name=default
            11:34:14,890 INFO [jbossweb] Registered jboss.web:Jetty=0,JBossWebApplicationContext=2,context=/jmx-console,name=invoker
            11:34:14,921 INFO [jbossweb] Registered jboss.web:Jetty=0,JBossWebApplicationContext=2,context=/jmx-console,HashSessionManager=0
            11:34:14,921 INFO [jbossweb] successfully deployed file:/D:/jboss-3.0.8/server/all/deploy/jmx-console.war/ to /jmx-console
            11:34:14,921 INFO [MainDeployer] Deployed package: file:/D:/jboss-3.0.8/server/all/deploy/jmx-console.war/
            11:34:14,937 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()'
            Cause: Incomplete Deployment listing:
            Packages waiting for a deployer:

            Incompletely deployed packages:

            MBeans waiting for classes:

            MBeans waiting for other MBeans:
            [ObjectName: jboss.j2ee:jndiName=AccountBean,service=EJB
            state: FAILED
            I Depend On:
            Depends On Me: org.jboss.deployment.DeploymentException: Parameter class not found: String]

            I don't know what 's wrong with the process. What's more ,If I ended the server and started it up again ,It seemed someting wrong happened.A lot of error information emerged! Do I miss something important?
            I look forward to reply urgently!
            Best regards!

            • 4. Re: Can any one direct me to configure jboss3.08 with oracle
              Kris Kristensen Newbie

              Hi calffin,
              I agree with Adrian. Actually I don't think this problem has anything to do with using Oracle or not, or even using CMP with Oracle. Somewhere in your configuration/code you are referrring to String, but it must be fully qualified ie. java.lang.String
              So to answer your question, no I have never seen that exception in my configuration.

              /Kris

              • 5. Re: Can any one direct me to configure jboss3.08 with oracle
                calffin Newbie

                Thank you ,kbk!Thank you adrian. It's really the problem you mentioned above. I 've solved it .