Deploying ofbiz10.04 on Jboss-4.2.2 using oracle10g

[pankaj savita]

Hi,

How to deploy ofbiz10.04 on Jboss-4.2.2 using oracle10g?
I found documentation for deploying OFBiz on jboss-4.2.2 using derby
database, But I need to use
oracle10g as a database.
https://cwiki.apache.org/confluence/display/OFBTECH/Run+OFBiz+under+outside+Application+Servers


Will It be done only by changing connection-url & driver-class from derby to
oracle or anything else need to be done?


--
Thanks & Regards,
Pankaj Savita
Mob: [phone]
Mail to: [hidden email]

[Jacques Le Roux]

From: "pankaj savita" <[hidden email]>

> Hi,
>
> How to deploy ofbiz10.04 on Jboss-4.2.2 using oracle10g?
> I found documentation for deploying OFBiz on jboss-4.2.2 using derby
> database, But I need to use
> oracle10g as a database.
> https://cwiki.apache.org/confluence/display/OFBTECH/Run+OFBiz+under+outside+Application+Servers
>
>
> Will It be done only by changing connection-url & driver-class from derby to
> oracle or anything else need to be done?

Modifying entityengine.xml and using right driver should be enough (except for Oracles specificities
https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+and+Oracle)

Jacques

>
> --
> Thanks & Regards,
> Pankaj Savita
> Mob: [phone]
> Mail to: [hidden email]
>

[pankaj savita]

Hi Jacques,

I have followed all the steps to deploy OFBiz on Jboss application server
using oracle given in:
https://cwiki.apache.org/confluence/display/OFBTECH/Run+OFBiz+under+outside+Application+Servers

Used localoracle in entityengine.xml.

Created new file oracle-ds.xml in
ofbiz10.04\framework\appserver\templates\jboss422\patches folder & also
jboss-4.2.2.GA\server\default\deploy folder with following entries:
     <jndi-name>OFBizDS</jndi-name>
     <connection-url>jdbc:oracle:thin:@127.0.0.1:1521:XE</connection-url>
     <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
     <user-name>ofbiz</user-name>
     <password>ofbiz</password>
     <mbean code="org.jboss.jdbc.HypersonicDatabase"
name="jboss:service=OFBiz"/>

Changed build.xml file for oracle as:
    <target name="generate" depends="installOracle" description=""/>
    <target name="installOracle" depends="clean">
        <!-- install oracle -->
        <copy file="${ofbizHome}/framework/entity/lib/jdbc/ojdbc14.jar"
todir="../../lib/"/>

        <copy todir=".">
            <fileset
dir="${ofbizHome}/framework/appserver/templates/jboss422/patches/">
                <include name="oracle*.xml"/>
            </fileset>
        </copy>
    </target>

When I start Jboss server by run0000.bat, resulting in Error configuring
ControlEventListener.
Some Error logs given below....

2010-10-19 11:06:09,921 ERROR
[org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/accounting]]
Error configuring application listener of class
org.ofbiz.webapp.control.ControlEventListener
java.lang.ClassNotFoundException:
org.ofbiz.webapp.control.ControlEventListener
    at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1358)
    at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1204)
.....
.....
2010-10-19 11:06:09,921 ERROR
[org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/accounting]]
Error configuring application listener of class
org.ofbiz.webapp.control.LoginEventListener
java.lang.ClassNotFoundException:
org.ofbiz.webapp.control.LoginEventListener
......
.....

2010-10-19 11:06:09,921 ERROR
[org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/accounting]]
Skipped installing application listeners due to previous error(s)
2010-10-19 11:06:09,921 ERROR [org.apache.catalina.core.StandardContext]
Error listenerStart
2010-10-19 11:06:09,921 ERROR [org.apache.catalina.core.StandardContext]
Context [/accounting] startup failed due to previous errors
2010-10-19 11:06:09,937 DEBUG [org.jboss.web.WebModule] Starting failed
jboss.web.deployment:war=accounting.war,id=-86378835
2010-10-19 11:06:09,937 DEBUG [org.jboss.util.NestedThrowable]
org.jboss.util.NestedThrowable.parentTraceEnabled=true
2010-10-19 11:06:09,937 DEBUG [org.jboss.util.NestedThrowable]
org.jboss.util.NestedThrowable.nestedTraceEnabled=false
2010-10-19 11:06:09,937 DEBUG [org.jboss.util.NestedThrowable]
org.jboss.util.NestedThrowable.detectDuplicateNesting=true
org.jboss.deployment.DeploymentException: URL file:/C:/IndusJDE/
jboss-4.2.2.GA/server/default/deploy/ofbiz.ear/accounting.war/ deployment
failed
    at
org.jboss.web.tomcat.service.TomcatDeployer.performDeployInternal(TomcatDeployer.java:379)
.....
.....
2010-10-19 11:06:09,952 DEBUG
[org.jboss.deployment.scanner.URLDeploymentScanner] Watch URL for:
file:/C:/IndusJDE/jboss-4.2.2.GA/server/default/deploy/ofbiz.ear/ ->
file:/C:/IndusJDE/
jboss-4.2.2.GA/server/default/deploy/ofbiz.ear/META-INF/application.xml
2010-10-19 11:06:09,952 ERROR
[org.jboss.deployment.scanner.URLDeploymentScanner] Incomplete Deployment
listing:

--- Incompletely deployed packages ---
org.jboss.deployment.DeploymentInfo@fad9f6ad { url=file:/C:/IndusJDE/
jboss-4.2.2.GA/server/default/deploy/ofbiz.ear/accounting.war/ }
  deployer: MBeanProxyExt[jboss.web:service=WebServer]
  status: Deployment FAILED reason: URL file:/C:/IndusJDE/
jboss-4.2.2.GA/server/default/deploy/ofbiz.ear/accounting.war/ deployment
failed
  state: FAILED
  watch: file:/C:/IndusJDE/
jboss-4.2.2.GA/server/default/deploy/ofbiz.ear/accounting.war/WEB-INF/web.xml
  altDD: null
  lastDeployed: 1287466569186
  lastModified: 1287404573060
  mbeans:

--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss.web.deployment:war=accounting.war,id=-86378835
  State: FAILED



Is there something wrong in my JBoss Configuration? or something is missing?



--
Thanks & Regards,
Pankaj Savita
Mob: [phone]
Mail to: [hidden email]



On Mon, Oct 18, 2010 at 4:05 PM, Jacques Le Roux <
[hidden email]> wrote:

> From: "pankaj savita" <[hidden email]>
>
>  Hi,
>>
>> How to deploy ofbiz10.04 on Jboss-4.2.2 using oracle10g?
>> I found documentation for deploying OFBiz on jboss-4.2.2 using derby
>> database, But I need to use
>> oracle10g as a database.
>>
>> https://cwiki.apache.org/confluence/display/OFBTECH/Run+OFBiz+under+outside+Application+Servers
>>
>>
>> Will It be done only by changing connection-url & driver-class from derby
>> to
>> oracle or anything else need to be done?
>>
>
> Modifying entityengine.xml and using right driver should be enough (except
> for Oracles specificities
> https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+and+Oracle)
>
> Jacques
>
>
>
>> --
>> Thanks & Regards,
>> Pankaj Savita
>> Mob: [phone]
>> Mail to: [hidden email]
>>
>>
>
>