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

[calffin]

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!

[kbk]

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

[calffin]

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!

[adrian.brock]

java.lang.String

[kbk]

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

[calffin]

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