Re: java.lang.NoSuchMethodError: org.ofbiz.service.job.JobManager.getDelegator()Lorg/ofbiz/entity/GenericDelegator;

[Abdullah Shaikh]

Adrian,

Sorry I couldn't reply you yesterday, today I took the update again, did ant
clean & build, and Ofbiz was running fine  but then before this I also
did empty the JOB_SANDBOX database table, so I dont know its bcoz of that or
what ?

But as you are saying that you ran the updated code against an existing
database, then I think there is no issues but does the database was
having pending jobs, just to be sure ?

Thanks,
Abdullah

On Mon, Oct 5, 2009 at 10:00 PM, Adrian Crum  wrote:

> Abdullah,
>
> I tried running the updated code against an existing database and I was
> unable to duplicate your problem. Are you sure you ran ant clean, then ant
> build?
>
> -Adrian
>
>
> Abdullah Shaikh wrote:
>
>> I just updated ofbiz, and found that all the references to concrete class
>> GenericDelegator has been converted to Delegator, but I guess bcoz of this
>> all the persisted jobs are getting failed.
>>
>> I couldn't start ofbiz, as I was getting the below error because
>> org.ofbiz.base.start.Start.main would exit without starting ofbiz, I could
>> start ofbiz only when I changed getDelegator() method to return
>> GenericDelegator instead of Delegator in JobManager, but once started all
>> the jobs were failing.
>>
>> Error before doing the change in JobManager :
>>
>> 2009-10-05 20:57:19,137 (main) [ ServiceEcaUtil.java:117:INFO ] Loaded
>> [
>> 1] Service ECA Rules from
>>
>> file:/home/abdullah/myprojects/topnaukri_ws/ofbiz/specialpurpose/ebay/servicedef/secas.xml
>> [java] Exception in thread "main" java.lang.NoSuchMethodError:
>>
>> org.ofbiz.service.job.JobManager.getDelegator()Lorg/ofbiz/entity/GenericDelegator;
>> [java] at
>> org.ofbiz.service.job.JobInvoker.(JobInvoker.java:64)
>> [java] at
>> org.ofbiz.service.job.JobPoller.createThreadPool(JobPoller.java:238)
>> [java] at
>> org.ofbiz.service.job.JobPoller.(JobPoller.java:59)
>> [java] at
>> org.ofbiz.service.job.JobManager.(JobManager.java:83)
>> [java] at
>> org.ofbiz.service.job.JobManager.getInstance(JobManager.java:91)
>> [java] at
>> org.ofbiz.service.ServiceDispatcher.(ServiceDispatcher.java:116)
>> [java] at
>> org.ofbiz.service.ServiceDispatcher.(ServiceDispatcher.java:132)
>> [java] at
>>
>> org.ofbiz.service.ServiceDispatcher.getInstance(ServiceDispatcher.java:166)
>> [java] at
>>
>> org.ofbiz.service.ServiceDispatcher.getInstance(ServiceDispatcher.java:141)
>> [java] at
>>
>> org.ofbiz.service.GenericDispatcher.getLocalDispatcher(GenericDispatcher.java:72)
>> [java] at
>>
>> org.ofbiz.service.GenericDispatcher.getLocalDispatcher(GenericDispatcher.java:42)
>> [java] at
>>
>> org.ofbiz.entityext.EntityServiceFactory.getLocalDispatcher(EntityServiceFactory.java:34)
>> [java] at
>>
>> org.ofbiz.entityext.EntityServiceFactory.getDispatchContext(EntityServiceFactory.java:39)
>> [java] at
>>
>> org.ofbiz.entityext.eca.DelegatorEcaHandler.setDelegator(DelegatorEcaHandler.java:53)
>> [java] at
>>
>> org.ofbiz.entity.GenericDelegator.initEntityEcaHandler(GenericDelegator.java:330)
>> [java] at
>> org.ofbiz.entity.GenericDelegator.(GenericDelegator.java:315)
>> [java] at
>>
>> org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:43)
>> [java] at
>>
>> org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:25)
>> [java] at
>> org.ofbiz.base.util.UtilObject.getObjectFromFactory(UtilObject.java:181)
>> [java] at
>>
>> org.ofbiz.catalina.container.CatalinaContainer.init(CatalinaContainer.java:173)
>> [java] at
>>
>> org.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:190)
>> [java] at
>> org.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:66)
>> [java] at
>> org.ofbiz.base.start.Start.initStartLoaders(Start.java:259)
>> [java] at org.ofbiz.base.start.Start.init(Start.java:97)
>> [java] at org.ofbiz.base.start.Start.main(Start.java:408)
>> [java] Java Result: 1
>> BUILD SUCCESSFUL
>> Total time: 8 seconds
>>
>>
>> Error after doing the change in JobManager, when ofbiz could be started :
>>
>>  error report
>> --
>> [java] Error in polling JobSandbox: [java.lang.NoSuchMethodError:
>>
>> org.ofbiz.entity.GenericValue.getDelegator()Lorg/ofbiz/entity/GenericDelegator;].
>> Rolling back transaction.
>> [java] Exception: java.lang.NoSuchMethodError
>> [java] Message:
>>
>> org.ofbiz.entity.GenericValue.getDelegator()Lorg/ofbiz/entity/GenericDelegator;
>> [java]  stack trace
>> ---
>> [java] java.lang.NoSuchMethodError:
>>
>> org.ofbiz.entity.GenericValue.getDelegator()Lorg/ofbiz/entity/GenericDelegator;
>> [java] org.ofbiz.entity.GenericValue.refresh(GenericValue.java:137)
>> [java]
>>
>> org.ofbiz.servic

RE: OFBiz installation tutorial???

[Dan Dodd]

mavrickiT, 

 

that sounds like an ubuntu issue and you can get great help just by
searching the ubuntu forums.  Connections do time out, just re connect.
If you built the server / desktop you can always do it again, faster I'm
sure

 

Learning ubuntu and OFbiz at the same time is hard work, esp if you are
not familiar with the basics. Is there anyone at your job that knows
ubuntu and OFBiz?

 

 

Dan,

Forgot to tell you that, i cannt even access my server remotely.

Now it's kinda freaking me out. Don't know what's happening, network
connection timed out -- while accessing through a remote terminal.

Please help me

thanks

 

 

Dan Dodd

IHOP-KC

dand...@ihop.org   

Re: OFBiz installation tutorial???

[Adrian Crum]

It's not stuck. It is running normally.

-Adrian

MavrickIT wrote:

Dan,
Firstly, thanks for your cooperation.
I can't even ./startofbiz.sh
So, browser simply says -> the page cannot be found.
I didn't configure the ofbiz yet.
Installation part is done. Configuration part is left. 
Moreover, doing ./startofbiz.sh , 
 (default-invoker-Thread-9) [ServiceDespatcher.java:593:info]

Sync service [JobDispatcher/sendEmailDated] finished in [152] milliseconds
"empty"
"empty"
"empty"
It's stuck in here. It's kinda like hanged. It's just stuck in. I did cancel
Ctrl+C it and did ./startofbiz.sh again. and still the same.

So, there I go.
What to do now.. ?  :-(
Thanks 



Dan Dodd wrote:

What message did you the browser give when you pointed it to
http://127.0.0.1:8080/ecommerce   ?

Dan Dodd

IHOP-KC
dand...@ihop.org 


-Original Message-
From: MavrickIT [mailto:k...@mavrickit.com] 
Sent: Tuesday, October 06, 2009 1:46 PM

To: user@ofbiz.apache.org
Subject: RE: OFBiz installation tutorial???


Hello Ruth,
Yes I tried it. [i tried with http:///ecommerce]
it doesn't work.
Well --->
when I start it ./startofbiz.sh screen is flooded and flooded.
It's shown at bottom -> 
Not committing transaction, status is No transaction (6) 


I didn't do configure ofbiz.
Now im trying to do the task following
http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+
Setup+Guide
Not sure, if I can do. 
Im stuck in config part again. I don't know how to access:

 ${ofbiz insall dir}/framework/base/config/cache.properties

Please help me.
thanks

Dan Dodd wrote:
MavrickIT, 
Following the "flood"  what the last couple of lines on the screen?

Did you try to access by pointing your browser to
127.0.0.1:8080/ecommerce  ??

Dan Dodd

IHOP-KC
dand...@ihop.org 


-Original Message-
From: MavrickIT [mailto:k...@mavrickit.com] 
Sent: Tuesday, October 06, 2009 1:06 PM

To: user@ofbiz.apache.org
Subject: Re: Ofbiz installation tutorial???


Thanks Ruth,
Your procedure works. 
But, when I start it ./startofbiz.sh screen is flooded and flooded. 
It's shown at bottom -> Not committing transaction, status is No

transaction
(6)
and does it take longer to be started ? It's more than 5 mins, still

the

screen is flooded and yet not started the ofbiz.
I created $/home/ofbiz
Downloaded ofbiz into /home/ofbiz$
Extracted it into /home/ofbiz/ofbiz$
I found---> /home/ofbiz/ofbiz/ofbiz-trunk$dir
. .  startofbiz.sh   
. . ... .. .
I started it as /home/ofbiz/ofbiz/ofbiz-trunk$./startofbiz.sh

there it goes. Screen flood.
Got stuck in here.
Any solution?
I already have JRE6 (full sdk installed), SVN, tomcat, ANT installed
Thanks


Ruth Hoffman-2 wrote:

Hello MavrickIT:
IMHO, take baby steps: Start by downloading a "zip'd" version from

the

wiki, http://build.ofbiz.org and not the Subversion (SVN) package.
The 
instructions regarding which download is appropriate given your 
situation are confusing at best. I prefer to keep it simple when
getting 

started. A little excerpt from my recent book:

Currently, if you visit the OFBiz site and decide to download a
version,
you have several options. The easiest thing to do is follow the

big

download button and get the "nightly build". This is a

prepackaged

version
ready to unzip and run. Nightly builds contain everything

necessary to

execute the demonstrations discussed in this book. They also

contain

all
the source code and other artifacts including build scripts that

are

used to
create the nightly builds. In other words, you get "all that and

the

source
too"! 


You won't need Tomcat, SVN or Ant to download a nightly build and get
up 

and running quickly. Simply, create the directory you wish to run
OFBiz 
in (make sure that Java is on the classpath while working in this 
directory), change to that directory, unzip your file there and
startup 

OFBiz. For example:

1) Create a directory such as /home/ofbiz
2) Download the zip file to your new directory. You will have
something 

that looks like this: /home/ofbiz/ofbizdownload.zip
3) Unzip your file using something like gzip (Not sure what the

Ubuntu

unzip command is.)
4) Move to the unzipped file location doing something like: cd  
/home/ofbiz/ofbizdownload
4) Run the Unix OFBiz invocation script that comes with the 
distribution: ./startofbiz.sh

5) Navigate to the ecommerce startup page

http://localhost:8080/ecommerce

6) Observe that you see the ecommerce landing page

Once you understand what you've got out-of-the-box and you are ready
to 

do some development work, then consider downloading from SVN.

Regards,
Ruth Hoffman
http://www.myofbiz.com

MavrickIT wrote:

Thanks Patel for trying to help me out. I have gone through the

links

already
that you gave me. Thing is, I already installed JRE6, full SDK, and
tomcat,
SVN, ANT etc. These were installed in root by default.
I created folder /home/ofbiz. So, 

RE: OFBiz installation tutorial???

[MavrickIT]

Dan,
Forgot to tell you that, i cannt even access my server remotely.
Now it's kinda freaking me out. Don't know what's happening,
network connection timed out -- while accessing through a remote
terminal.
Please help me
thanks


Dan Dodd wrote:
> 
> What message did you the browser give when you pointed it to
> http://127.0.0.1:8080/ecommerce   ?
> 
> Dan Dodd
> 
> IHOP-KC
> dand...@ihop.org 
> 
> -Original Message-
> From: MavrickIT [mailto:k...@mavrickit.com] 
> Sent: Tuesday, October 06, 2009 1:46 PM
> To: user@ofbiz.apache.org
> Subject: RE: OFBiz installation tutorial???
> 
> 
> Hello Ruth,
> Yes I tried it. [i tried with http:///ecommerce]
> it doesn't work.
> Well --->
> when I start it ./startofbiz.sh screen is flooded and flooded.
> It's shown at bottom -> 
> Not committing transaction, status is No transaction (6) 
> 
> I didn't do configure ofbiz.
> Now im trying to do the task following
> http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+
> Setup+Guide
> Not sure, if I can do. 
> Im stuck in config part again. I don't know how to access:
>  ${ofbiz insall dir}/framework/base/config/cache.properties
> 
> Please help me.
> thanks
> 
> Dan Dodd wrote:
>> 
>> MavrickIT, 
>> Following the "flood"  what the last couple of lines on the screen?
>> Did you try to access by pointing your browser to
>> 127.0.0.1:8080/ecommerce  ??
>> 
>> Dan Dodd
>> 
>> IHOP-KC
>> dand...@ihop.org 
>> 
>> -Original Message-
>> From: MavrickIT [mailto:k...@mavrickit.com] 
>> Sent: Tuesday, October 06, 2009 1:06 PM
>> To: user@ofbiz.apache.org
>> Subject: Re: Ofbiz installation tutorial???
>> 
>> 
>> Thanks Ruth,
>> Your procedure works. 
>> But, when I start it ./startofbiz.sh screen is flooded and flooded. 
>> It's shown at bottom -> Not committing transaction, status is No
>> transaction
>> (6)
>> and does it take longer to be started ? It's more than 5 mins, still
> the
>> screen is flooded and yet not started the ofbiz.
>> I created $/home/ofbiz
>> Downloaded ofbiz into /home/ofbiz$
>> Extracted it into /home/ofbiz/ofbiz$
>> I found---> /home/ofbiz/ofbiz/ofbiz-trunk$dir
>> . .  startofbiz.sh   
>> . . ... .. .
>> I started it as /home/ofbiz/ofbiz/ofbiz-trunk$./startofbiz.sh
>> 
>> there it goes. Screen flood.
>> Got stuck in here.
>> Any solution?
>> I already have JRE6 (full sdk installed), SVN, tomcat, ANT installed
>> Thanks
>> 
>> 
>> Ruth Hoffman-2 wrote:
>>> 
>>> Hello MavrickIT:
>>> IMHO, take baby steps: Start by downloading a "zip'd" version from
> the
>> 
>>> wiki, http://build.ofbiz.org and not the Subversion (SVN) package.
>> The 
>>> instructions regarding which download is appropriate given your 
>>> situation are confusing at best. I prefer to keep it simple when
>> getting 
>>> started. A little excerpt from my recent book:
>>> 
>>> Currently, if you visit the OFBiz site and decide to download a
>>> version,
>>> you have several options. The easiest thing to do is follow the
>> big
>>> download button and get the "nightly build". This is a
> prepackaged
>>> version
>>> ready to unzip and run. Nightly builds contain everything
>> necessary to
>>> execute the demonstrations discussed in this book. They also
>> contain
>>> all
>>> the source code and other artifacts including build scripts that
>> are
>>> used to
>>> create the nightly builds. In other words, you get "all that and
>> the
>>> source
>>> too"! 
>>> 
>>> You won't need Tomcat, SVN or Ant to download a nightly build and get
>> up 
>>> and running quickly. Simply, create the directory you wish to run
>> OFBiz 
>>> in (make sure that Java is on the classpath while working in this 
>>> directory), change to that directory, unzip your file there and
>> startup 
>>> OFBiz. For example:
>>> 
>>> 1) Create a directory such as /home/ofbiz
>>> 2) Download the zip file to your new directory. You will have
>> something 
>>> that looks like this: /home/ofbiz/ofbizdownload.zip
>>> 3) Unzip your file using something like gzip (Not sure what the
> Ubuntu
>> 
>>> unzip command is.)
>>> 4) Move to the unzipped file location doing something like: cd  
>>> /home/ofbiz/ofbizdownload
>>> 4) Run the Unix OFBiz invocation script that comes with the 
>>> distribution: ./startofbiz.sh
>>> 5) Navigate to the ecommerce startup page
>> http://localhost:8080/ecommerce
>>> 6) Observe that you see the ecommerce landing page
>>> 
>>> Once you understand what you've got out-of-the-box and you are ready
>> to 
>>> do some development work, then consider downloading from SVN.
>>> 
>>> Regards,
>>> Ruth Hoffman
>>> http://www.myofbiz.com
>>> 
>>> MavrickIT wrote:
 Thanks Patel for trying to help me out. I have gone through the
> links
 already
 that you gave me. Thing is, I already installed JRE6, full SDK, and
 tomcat,
 SVN, ANT etc. These were installed in root by default.
 I created folder /home/ofbiz. So, there is

RE: OFBiz installation tutorial???

[MavrickIT]

Dan,
Firstly, thanks for your cooperation.
I can't even ./startofbiz.sh
So, browser simply says -> the page cannot be found.
I didn't configure the ofbiz yet.
Installation part is done. Configuration part is left. 
Moreover, doing ./startofbiz.sh , 
 (default-invoker-Thread-9) [ServiceDespatcher.java:593:info]
Sync service [JobDispatcher/sendEmailDated] finished in [152] milliseconds
"empty"
"empty"
"empty"
It's stuck in here. It's kinda like hanged. It's just stuck in. I did cancel
Ctrl+C it and did ./startofbiz.sh again. and still the same.

So, there I go.
What to do now.. ?  :-(
Thanks 


Dan Dodd wrote:
> 
> What message did you the browser give when you pointed it to
> http://127.0.0.1:8080/ecommerce   ?
> 
> Dan Dodd
> 
> IHOP-KC
> dand...@ihop.org 
> 
> -Original Message-
> From: MavrickIT [mailto:k...@mavrickit.com] 
> Sent: Tuesday, October 06, 2009 1:46 PM
> To: user@ofbiz.apache.org
> Subject: RE: OFBiz installation tutorial???
> 
> 
> Hello Ruth,
> Yes I tried it. [i tried with http:///ecommerce]
> it doesn't work.
> Well --->
> when I start it ./startofbiz.sh screen is flooded and flooded.
> It's shown at bottom -> 
> Not committing transaction, status is No transaction (6) 
> 
> I didn't do configure ofbiz.
> Now im trying to do the task following
> http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+
> Setup+Guide
> Not sure, if I can do. 
> Im stuck in config part again. I don't know how to access:
>  ${ofbiz insall dir}/framework/base/config/cache.properties
> 
> Please help me.
> thanks
> 
> Dan Dodd wrote:
>> 
>> MavrickIT, 
>> Following the "flood"  what the last couple of lines on the screen?
>> Did you try to access by pointing your browser to
>> 127.0.0.1:8080/ecommerce  ??
>> 
>> Dan Dodd
>> 
>> IHOP-KC
>> dand...@ihop.org 
>> 
>> -Original Message-
>> From: MavrickIT [mailto:k...@mavrickit.com] 
>> Sent: Tuesday, October 06, 2009 1:06 PM
>> To: user@ofbiz.apache.org
>> Subject: Re: Ofbiz installation tutorial???
>> 
>> 
>> Thanks Ruth,
>> Your procedure works. 
>> But, when I start it ./startofbiz.sh screen is flooded and flooded. 
>> It's shown at bottom -> Not committing transaction, status is No
>> transaction
>> (6)
>> and does it take longer to be started ? It's more than 5 mins, still
> the
>> screen is flooded and yet not started the ofbiz.
>> I created $/home/ofbiz
>> Downloaded ofbiz into /home/ofbiz$
>> Extracted it into /home/ofbiz/ofbiz$
>> I found---> /home/ofbiz/ofbiz/ofbiz-trunk$dir
>> . .  startofbiz.sh   
>> . . ... .. .
>> I started it as /home/ofbiz/ofbiz/ofbiz-trunk$./startofbiz.sh
>> 
>> there it goes. Screen flood.
>> Got stuck in here.
>> Any solution?
>> I already have JRE6 (full sdk installed), SVN, tomcat, ANT installed
>> Thanks
>> 
>> 
>> Ruth Hoffman-2 wrote:
>>> 
>>> Hello MavrickIT:
>>> IMHO, take baby steps: Start by downloading a "zip'd" version from
> the
>> 
>>> wiki, http://build.ofbiz.org and not the Subversion (SVN) package.
>> The 
>>> instructions regarding which download is appropriate given your 
>>> situation are confusing at best. I prefer to keep it simple when
>> getting 
>>> started. A little excerpt from my recent book:
>>> 
>>> Currently, if you visit the OFBiz site and decide to download a
>>> version,
>>> you have several options. The easiest thing to do is follow the
>> big
>>> download button and get the "nightly build". This is a
> prepackaged
>>> version
>>> ready to unzip and run. Nightly builds contain everything
>> necessary to
>>> execute the demonstrations discussed in this book. They also
>> contain
>>> all
>>> the source code and other artifacts including build scripts that
>> are
>>> used to
>>> create the nightly builds. In other words, you get "all that and
>> the
>>> source
>>> too"! 
>>> 
>>> You won't need Tomcat, SVN or Ant to download a nightly build and get
>> up 
>>> and running quickly. Simply, create the directory you wish to run
>> OFBiz 
>>> in (make sure that Java is on the classpath while working in this 
>>> directory), change to that directory, unzip your file there and
>> startup 
>>> OFBiz. For example:
>>> 
>>> 1) Create a directory such as /home/ofbiz
>>> 2) Download the zip file to your new directory. You will have
>> something 
>>> that looks like this: /home/ofbiz/ofbizdownload.zip
>>> 3) Unzip your file using something like gzip (Not sure what the
> Ubuntu
>> 
>>> unzip command is.)
>>> 4) Move to the unzipped file location doing something like: cd  
>>> /home/ofbiz/ofbizdownload
>>> 4) Run the Unix OFBiz invocation script that comes with the 
>>> distribution: ./startofbiz.sh
>>> 5) Navigate to the ecommerce startup page
>> http://localhost:8080/ecommerce
>>> 6) Observe that you see the ecommerce landing page
>>> 
>>> Once you understand what you've got out-of-the-box and you are ready
>> to 
>>> do some development work, then consider downloading fro

Re: How to get session variable value in Java Method?

[Adrian Crum]

In the screen xml:


  
  


In the form xml:


  
  ...


-Adrian

su2 wrote:

Sorry, I was not able to understand - keep the information in the context.
Can you please explain in detail.

I really appreciate your help.

Thank you.
Su-


Adrian Crum wrote:
Why not keep that information in the context? Trying to access session 
information in the presentation layer breaks the MVC boundaries.


-Adrian

su2 wrote:

Hi Adrian,

I have a screen which has bsh file in  and FormWidget in

tag. I am capturing fromDate and thruDate in Session in .bsh file.

Now from FormWidget I am calling Java Methods for the data manipulation.
For
the data manipulation I need to have access to fromDate and thruDate
selected by the user.

So here in Java method I am trying to access session variables.

I hope it helps in understanding my scenario.

Thank you.
Su-

Adrian Crum wrote:
You haven't provided enough information. Where in the program flow is 
the Java method? What are you trying to retrieve? What are you trying to 
achieve?


-Adrian

su2 wrote:

Hello Friends,

I was trying to retrieve the session value using following code in Java
Method. But it gives me error -"session" can not be resolved.

-
String fromDate = session.getAttribute("fromDate");
-

Am I missing something?

Thank you for the help in advance.

Su-

Re: How to get session variable value in Java Method?

[su2]

Sorry, I was not able to understand - keep the information in the context.
Can you please explain in detail.

I really appreciate your help.

Thank you.
Su-


Adrian Crum wrote:
> 
> Why not keep that information in the context? Trying to access session 
> information in the presentation layer breaks the MVC boundaries.
> 
> -Adrian
> 
> su2 wrote:
>> Hi Adrian,
>> 
>> I have a screen which has bsh file in  and FormWidget in
>> 
>> tag. I am capturing fromDate and thruDate in Session in .bsh file.
>> 
>> Now from FormWidget I am calling Java Methods for the data manipulation.
>> For
>> the data manipulation I need to have access to fromDate and thruDate
>> selected by the user.
>> 
>> So here in Java method I am trying to access session variables.
>> 
>> I hope it helps in understanding my scenario.
>> 
>> Thank you.
>> Su-
>> 
>> Adrian Crum wrote:
>>> You haven't provided enough information. Where in the program flow is 
>>> the Java method? What are you trying to retrieve? What are you trying to 
>>> achieve?
>>>
>>> -Adrian
>>>
>>> su2 wrote:
 Hello Friends,

 I was trying to retrieve the session value using following code in Java
 Method. But it gives me error -"session" can not be resolved.

 -
 String fromDate = session.getAttribute("fromDate");
 -

 Am I missing something?

 Thank you for the help in advance.

 Su-

>>>
>> 
> 
> 

-- 
View this message in context: 
http://www.nabble.com/How-to-get-session-variable-value-in-Java-Method--tp25774516p25776447.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: How to get session variable value in Java Method?

[Adrian Crum]

Why not keep that information in the context? Trying to access session 
information in the presentation layer breaks the MVC boundaries.


-Adrian

su2 wrote:

Hi Adrian,

I have a screen which has bsh file in  and FormWidget in 
tag. I am capturing fromDate and thruDate in Session in .bsh file.

Now from FormWidget I am calling Java Methods for the data manipulation. For
the data manipulation I need to have access to fromDate and thruDate
selected by the user.

So here in Java method I am trying to access session variables.

I hope it helps in understanding my scenario.

Thank you.
Su-

Adrian Crum wrote:
You haven't provided enough information. Where in the program flow is 
the Java method? What are you trying to retrieve? What are you trying to 
achieve?


-Adrian

su2 wrote:

Hello Friends,

I was trying to retrieve the session value using following code in Java
Method. But it gives me error -"session" can not be resolved.

-
String fromDate = session.getAttribute("fromDate");
-

Am I missing something?

Thank you for the help in advance.

Su-

Re: How to get session variable value in Java Method?

[su2]

Hi Adrian,

I have a screen which has bsh file in  and FormWidget in 
tag. I am capturing fromDate and thruDate in Session in .bsh file.

Now from FormWidget I am calling Java Methods for the data manipulation. For
the data manipulation I need to have access to fromDate and thruDate
selected by the user.

So here in Java method I am trying to access session variables.

I hope it helps in understanding my scenario.

Thank you.
Su-

Adrian Crum wrote:
> 
> You haven't provided enough information. Where in the program flow is 
> the Java method? What are you trying to retrieve? What are you trying to 
> achieve?
> 
> -Adrian
> 
> su2 wrote:
>> Hello Friends,
>> 
>> I was trying to retrieve the session value using following code in Java
>> Method. But it gives me error -"session" can not be resolved.
>> 
>> -
>> String fromDate = session.getAttribute("fromDate");
>> -
>> 
>> Am I missing something?
>> 
>> Thank you for the help in advance.
>> 
>> Su-
>> 
> 
> 

-- 
View this message in context: 
http://www.nabble.com/How-to-get-session-variable-value-in-Java-Method--tp25774516p25776086.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: How to get session variable value in Java Method?

[Adrian Crum]

You haven't provided enough information. Where in the program flow is 
the Java method? What are you trying to retrieve? What are you trying to 
achieve?


-Adrian

su2 wrote:

Hello Friends,

I was trying to retrieve the session value using following code in Java
Method. But it gives me error -"session" can not be resolved.

-
String fromDate = session.getAttribute("fromDate");
-

Am I missing something?

Thank you for the help in advance.

Su-

Re: How to get session variable value in Java Method?

[su2]

Hi Pattrick,

I tried your suggestion, and it gives error- "request" cannot be resolved.

I am not sure what I am missing.

Thank you.
Su-



Patrick Antivackis wrote:
> 
> May  be using this can help :
> HttpSession session = ((HttpServletRequest) request).getSession();
> 
> 2009/10/6 su2 
> 
>>
>> Hello Friends,
>>
>> I was trying to retrieve the session value using following code in Java
>> Method. But it gives me error -"session" can not be resolved.
>>
>> -
>> String fromDate = session.getAttribute("fromDate");
>> -
>>
>> Am I missing something?
>>
>> Thank you for the help in advance.
>>
>> Su-
>>
>> --
>> View this message in context:
>> http://www.nabble.com/How-to-get-session-variable-value-in-Java-Method--tp25774516p25774516.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>
> 
> 

-- 
View this message in context: 
http://www.nabble.com/How-to-get-session-variable-value-in-Java-Method--tp25774516p25775771.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: How to get session variable value in Java Method?

[Patrick Antivackis]

May  be using this can help :
HttpSession session = ((HttpServletRequest) request).getSession();

2009/10/6 su2 

>
> Hello Friends,
>
> I was trying to retrieve the session value using following code in Java
> Method. But it gives me error -"session" can not be resolved.
>
> -
> String fromDate = session.getAttribute("fromDate");
> -
>
> Am I missing something?
>
> Thank you for the help in advance.
>
> Su-
>
> --
> View this message in context:
> http://www.nabble.com/How-to-get-session-variable-value-in-Java-Method--tp25774516p25774516.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>

PublishPoint and MenuRoot concept

[Patrick Antivackis]

Hello,
Can someone point me to a page describing the concept of the PUBLISH_POINT
and MENU_ROOT type of content in the WebSiteContent entity, or can someone
explain this concept to me.
The only reference to MENU_ROOT i found is in the WebSitePublishPoint.groovy
and the associated template just display a tree but no actions are working.

Thank you in advance

RE: OFBiz installation tutorial???

[Dan Dodd]

What message did you the browser give when you pointed it to
http://127.0.0.1:8080/ecommerce   ?

Dan Dodd

IHOP-KC
dand...@ihop.org 

-Original Message-
From: MavrickIT [mailto:k...@mavrickit.com] 
Sent: Tuesday, October 06, 2009 1:46 PM
To: user@ofbiz.apache.org
Subject: RE: OFBiz installation tutorial???


Hello Ruth,
Yes I tried it. [i tried with http:///ecommerce]
it doesn't work.
Well --->
when I start it ./startofbiz.sh screen is flooded and flooded.
It's shown at bottom -> 
Not committing transaction, status is No transaction (6) 

I didn't do configure ofbiz.
Now im trying to do the task following
http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+
Setup+Guide
Not sure, if I can do. 
Im stuck in config part again. I don't know how to access:
 ${ofbiz insall dir}/framework/base/config/cache.properties

Please help me.
thanks

Dan Dodd wrote:
> 
> MavrickIT, 
> Following the "flood"  what the last couple of lines on the screen?
> Did you try to access by pointing your browser to
> 127.0.0.1:8080/ecommerce  ??
> 
> Dan Dodd
> 
> IHOP-KC
> dand...@ihop.org 
> 
> -Original Message-
> From: MavrickIT [mailto:k...@mavrickit.com] 
> Sent: Tuesday, October 06, 2009 1:06 PM
> To: user@ofbiz.apache.org
> Subject: Re: Ofbiz installation tutorial???
> 
> 
> Thanks Ruth,
> Your procedure works. 
> But, when I start it ./startofbiz.sh screen is flooded and flooded. 
> It's shown at bottom -> Not committing transaction, status is No
> transaction
> (6)
> and does it take longer to be started ? It's more than 5 mins, still
the
> screen is flooded and yet not started the ofbiz.
> I created $/home/ofbiz
> Downloaded ofbiz into /home/ofbiz$
> Extracted it into /home/ofbiz/ofbiz$
> I found---> /home/ofbiz/ofbiz/ofbiz-trunk$dir
> . .  startofbiz.sh   
> . . ... .. .
> I started it as /home/ofbiz/ofbiz/ofbiz-trunk$./startofbiz.sh
> 
> there it goes. Screen flood.
> Got stuck in here.
> Any solution?
> I already have JRE6 (full sdk installed), SVN, tomcat, ANT installed
> Thanks
> 
> 
> Ruth Hoffman-2 wrote:
>> 
>> Hello MavrickIT:
>> IMHO, take baby steps: Start by downloading a "zip'd" version from
the
> 
>> wiki, http://build.ofbiz.org and not the Subversion (SVN) package.
> The 
>> instructions regarding which download is appropriate given your 
>> situation are confusing at best. I prefer to keep it simple when
> getting 
>> started. A little excerpt from my recent book:
>> 
>> Currently, if you visit the OFBiz site and decide to download a
>> version,
>> you have several options. The easiest thing to do is follow the
> big
>> download button and get the "nightly build". This is a
prepackaged
>> version
>> ready to unzip and run. Nightly builds contain everything
> necessary to
>> execute the demonstrations discussed in this book. They also
> contain
>> all
>> the source code and other artifacts including build scripts that
> are
>> used to
>> create the nightly builds. In other words, you get "all that and
> the
>> source
>> too"! 
>> 
>> You won't need Tomcat, SVN or Ant to download a nightly build and get
> up 
>> and running quickly. Simply, create the directory you wish to run
> OFBiz 
>> in (make sure that Java is on the classpath while working in this 
>> directory), change to that directory, unzip your file there and
> startup 
>> OFBiz. For example:
>> 
>> 1) Create a directory such as /home/ofbiz
>> 2) Download the zip file to your new directory. You will have
> something 
>> that looks like this: /home/ofbiz/ofbizdownload.zip
>> 3) Unzip your file using something like gzip (Not sure what the
Ubuntu
> 
>> unzip command is.)
>> 4) Move to the unzipped file location doing something like: cd  
>> /home/ofbiz/ofbizdownload
>> 4) Run the Unix OFBiz invocation script that comes with the 
>> distribution: ./startofbiz.sh
>> 5) Navigate to the ecommerce startup page
> http://localhost:8080/ecommerce
>> 6) Observe that you see the ecommerce landing page
>> 
>> Once you understand what you've got out-of-the-box and you are ready
> to 
>> do some development work, then consider downloading from SVN.
>> 
>> Regards,
>> Ruth Hoffman
>> http://www.myofbiz.com
>> 
>> MavrickIT wrote:
>>> Thanks Patel for trying to help me out. I have gone through the
links
>>> already
>>> that you gave me. Thing is, I already installed JRE6, full SDK, and
>>> tomcat,
>>> SVN, ANT etc. These were installed in root by default.
>>> I created folder /home/ofbiz. So, there is nothing inside
> ...home/ofbiz$
>>> I performed svn co http://svn.apache..
>>> Even I tried svn co http://../ofbiz9+ and svn co
>>> http:///ofbiz4.0
>>>
>>> So, how could I download ofbiz or even extract it, I don't know.
> Even,
>>> from
>>> where to download it?
>>> Some google sites say, to download ofbiz separately and extract it
to
>>> /home/ofbiz user. Somewhere
>>> (http://docs.ofbiz.org/display/OFBADMIN/D

How to get session variable value in Java Method?

[su2]

Hello Friends,

I was trying to retrieve the session value using following code in Java
Method. But it gives me error -"session" can not be resolved.

-
String fromDate = session.getAttribute("fromDate");
-

Am I missing something?

Thank you for the help in advance.

Su-

-- 
View this message in context: 
http://www.nabble.com/How-to-get-session-variable-value-in-Java-Method--tp25774516p25774516.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

RE: OFBiz installation tutorial???

[MavrickIT]

Hello Ruth,
Yes I tried it. [i tried with http:///ecommerce]
it doesn't work.
Well --->
when I start it ./startofbiz.sh screen is flooded and flooded.
It's shown at bottom -> 
Not committing transaction, status is No transaction (6) 

I didn't do configure ofbiz.
Now im trying to do the task following
http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide
Not sure, if I can do. 
Im stuck in config part again. I don't know how to access:
 ${ofbiz insall dir}/framework/base/config/cache.properties

Please help me.
thanks

Dan Dodd wrote:
> 
> MavrickIT, 
> Following the "flood"  what the last couple of lines on the screen?
> Did you try to access by pointing your browser to
> 127.0.0.1:8080/ecommerce  ??
> 
> Dan Dodd
> 
> IHOP-KC
> dand...@ihop.org 
> 
> -Original Message-
> From: MavrickIT [mailto:k...@mavrickit.com] 
> Sent: Tuesday, October 06, 2009 1:06 PM
> To: user@ofbiz.apache.org
> Subject: Re: Ofbiz installation tutorial???
> 
> 
> Thanks Ruth,
> Your procedure works. 
> But, when I start it ./startofbiz.sh screen is flooded and flooded. 
> It's shown at bottom -> Not committing transaction, status is No
> transaction
> (6)
> and does it take longer to be started ? It's more than 5 mins, still the
> screen is flooded and yet not started the ofbiz.
> I created $/home/ofbiz
> Downloaded ofbiz into /home/ofbiz$
> Extracted it into /home/ofbiz/ofbiz$
> I found---> /home/ofbiz/ofbiz/ofbiz-trunk$dir
> . .  startofbiz.sh   
> . . ... .. .
> I started it as /home/ofbiz/ofbiz/ofbiz-trunk$./startofbiz.sh
> 
> there it goes. Screen flood.
> Got stuck in here.
> Any solution?
> I already have JRE6 (full sdk installed), SVN, tomcat, ANT installed
> Thanks
> 
> 
> Ruth Hoffman-2 wrote:
>> 
>> Hello MavrickIT:
>> IMHO, take baby steps: Start by downloading a "zip'd" version from the
> 
>> wiki, http://build.ofbiz.org and not the Subversion (SVN) package.
> The 
>> instructions regarding which download is appropriate given your 
>> situation are confusing at best. I prefer to keep it simple when
> getting 
>> started. A little excerpt from my recent book:
>> 
>> Currently, if you visit the OFBiz site and decide to download a
>> version,
>> you have several options. The easiest thing to do is follow the
> big
>> download button and get the "nightly build". This is a prepackaged
>> version
>> ready to unzip and run. Nightly builds contain everything
> necessary to
>> execute the demonstrations discussed in this book. They also
> contain
>> all
>> the source code and other artifacts including build scripts that
> are
>> used to
>> create the nightly builds. In other words, you get "all that and
> the
>> source
>> too"! 
>> 
>> You won't need Tomcat, SVN or Ant to download a nightly build and get
> up 
>> and running quickly. Simply, create the directory you wish to run
> OFBiz 
>> in (make sure that Java is on the classpath while working in this 
>> directory), change to that directory, unzip your file there and
> startup 
>> OFBiz. For example:
>> 
>> 1) Create a directory such as /home/ofbiz
>> 2) Download the zip file to your new directory. You will have
> something 
>> that looks like this: /home/ofbiz/ofbizdownload.zip
>> 3) Unzip your file using something like gzip (Not sure what the Ubuntu
> 
>> unzip command is.)
>> 4) Move to the unzipped file location doing something like: cd  
>> /home/ofbiz/ofbizdownload
>> 4) Run the Unix OFBiz invocation script that comes with the 
>> distribution: ./startofbiz.sh
>> 5) Navigate to the ecommerce startup page
> http://localhost:8080/ecommerce
>> 6) Observe that you see the ecommerce landing page
>> 
>> Once you understand what you've got out-of-the-box and you are ready
> to 
>> do some development work, then consider downloading from SVN.
>> 
>> Regards,
>> Ruth Hoffman
>> http://www.myofbiz.com
>> 
>> MavrickIT wrote:
>>> Thanks Patel for trying to help me out. I have gone through the links
>>> already
>>> that you gave me. Thing is, I already installed JRE6, full SDK, and
>>> tomcat,
>>> SVN, ANT etc. These were installed in root by default.
>>> I created folder /home/ofbiz. So, there is nothing inside
> ...home/ofbiz$
>>> I performed svn co http://svn.apache..
>>> Even I tried svn co http://../ofbiz9+ and svn co
>>> http:///ofbiz4.0
>>>
>>> So, how could I download ofbiz or even extract it, I don't know.
> Even,
>>> from
>>> where to download it?
>>> Some google sites say, to download ofbiz separately and extract it to
>>> /home/ofbiz user. Somewhere
>>> (http://docs.ofbiz.org/display/OFBADMIN/Demo+and+Test+Setup+Guide)
> it's
>>> shown that, "OFBiz with embedded Tomcat". 
>>> I can't find any exact solution. I am yet confused what should I type
> @
>>> the
>>> terminal for installing Ofbiz from the beginning. 
>>> Waiting for any suitable reply.:-(
>>> Thank you.
>>>
>>>
>>>
>>> Anil Patel-3 wrote:
>>>   
>

Re: Ofbiz installation tutorial???

[Adrian Crum]

All that's left to do is point your browser to your local URL.

-Adrian

MavrickIT wrote:

Thanks Ruth,
Your procedure works. 
But, when I start it ./startofbiz.sh screen is flooded and flooded. 
It's shown at bottom -> Not committing transaction, status is No transaction

(6)
and does it take longer to be started ? It's more than 5 mins, still the
screen is flooded and yet not started the ofbiz.
I created $/home/ofbiz
Downloaded ofbiz into /home/ofbiz$
Extracted it into /home/ofbiz/ofbiz$
I found---> /home/ofbiz/ofbiz/ofbiz-trunk$dir
. .  startofbiz.sh   
. . ... .. .
I started it as /home/ofbiz/ofbiz/ofbiz-trunk$./startofbiz.sh

there it goes. Screen flood.
Got stuck in here.
Any solution?
I already have JRE6 (full sdk installed), SVN, tomcat, ANT installed
Thanks


Ruth Hoffman-2 wrote:

Hello MavrickIT:
IMHO, take baby steps: Start by downloading a "zip'd" version from the 
wiki, http://build.ofbiz.org and not the Subversion (SVN) package.  The 
instructions regarding which download is appropriate given your 
situation are confusing at best. I prefer to keep it simple when getting 
started. A little excerpt from my recent book:


Currently, if you visit the OFBiz site and decide to download a
version,
you have several options. The easiest thing to do is follow the big
download button and get the "nightly build". This is a prepackaged
version
ready to unzip and run. Nightly builds contain everything necessary to
execute the demonstrations discussed in this book. They also contain
all
the source code and other artifacts including build scripts that are
used to
create the nightly builds. In other words, you get "all that and the
source
too"! 

You won't need Tomcat, SVN or Ant to download a nightly build and get up 
and running quickly. Simply, create the directory you wish to run OFBiz 
in (make sure that Java is on the classpath while working in this 
directory), change to that directory, unzip your file there and startup 
OFBiz. For example:


1) Create a directory such as /home/ofbiz
2) Download the zip file to your new directory. You will have something 
that looks like this: /home/ofbiz/ofbizdownload.zip
3) Unzip your file using something like gzip (Not sure what the Ubuntu 
unzip command is.)
4) Move to the unzipped file location doing something like: cd  
/home/ofbiz/ofbizdownload
4) Run the Unix OFBiz invocation script that comes with the 
distribution: ./startofbiz.sh

5) Navigate to the ecommerce startup page http://localhost:8080/ecommerce
6) Observe that you see the ecommerce landing page

Once you understand what you've got out-of-the-box and you are ready to 
do some development work, then consider downloading from SVN.


Regards,
Ruth Hoffman
http://www.myofbiz.com

MavrickIT wrote:

Thanks Patel for trying to help me out. I have gone through the links
already
that you gave me. Thing is, I already installed JRE6, full SDK, and
tomcat,
SVN, ANT etc. These were installed in root by default.
I created folder /home/ofbiz. So, there is nothing inside ...home/ofbiz$
I performed svn co http://svn.apache..
Even I tried svn co http://../ofbiz9+ and svn co
http:///ofbiz4.0

So, how could I download ofbiz or even extract it, I don't know. Even,
from
where to download it?
Some google sites say, to download ofbiz separately and extract it to
/home/ofbiz user. Somewhere
(http://docs.ofbiz.org/display/OFBADMIN/Demo+and+Test+Setup+Guide) it's
shown that, "OFBiz with embedded Tomcat". 
I can't find any exact solution. I am yet confused what should I type @

the
terminal for installing Ofbiz from the beginning. 
Waiting for any suitable reply.:-(

Thank you.



Anil Patel-3 wrote:
  

Hi,

For quick setup use
http://docs.ofbiz.org/display/OFBADMIN/Demo+and+Test+Setup+Guide

Please see following documents to setup development/staging environment.

http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide
http://docs.ofbiz.org/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide


Regards
Anil patel


On Oct 2, 2009, at 12:34 PM, MavrickIT wrote:


Can anybody help me out for Ofbiz installation guide [step by step  
command

lines] from the Terminal (Ububntu)?

I've been facing lots trouble about it. Please find me a solution. I  
found
no solid step by step commands tutorials for installing ofbiz or  
running it.
well, I am newbie to linux as well. Eventually, I don't even know  
how to

extract or download ofbiz.
Please help me.
--
View this message in context:
http://www.nabble.com/Ofbiz-installation-tutorialtp25716734p25716734.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

  

  

RE: OFBiz installation tutorial???

[Dan Dodd]

MavrickIT, 
Following the "flood"  what the last couple of lines on the screen?
Did you try to access by pointing your browser to
127.0.0.1:8080/ecommerce  ??

Dan Dodd

IHOP-KC
dand...@ihop.org 

-Original Message-
From: MavrickIT [mailto:k...@mavrickit.com] 
Sent: Tuesday, October 06, 2009 1:06 PM
To: user@ofbiz.apache.org
Subject: Re: Ofbiz installation tutorial???


Thanks Ruth,
Your procedure works. 
But, when I start it ./startofbiz.sh screen is flooded and flooded. 
It's shown at bottom -> Not committing transaction, status is No
transaction
(6)
and does it take longer to be started ? It's more than 5 mins, still the
screen is flooded and yet not started the ofbiz.
I created $/home/ofbiz
Downloaded ofbiz into /home/ofbiz$
Extracted it into /home/ofbiz/ofbiz$
I found---> /home/ofbiz/ofbiz/ofbiz-trunk$dir
. .  startofbiz.sh   
. . ... .. .
I started it as /home/ofbiz/ofbiz/ofbiz-trunk$./startofbiz.sh

there it goes. Screen flood.
Got stuck in here.
Any solution?
I already have JRE6 (full sdk installed), SVN, tomcat, ANT installed
Thanks


Ruth Hoffman-2 wrote:
> 
> Hello MavrickIT:
> IMHO, take baby steps: Start by downloading a "zip'd" version from the

> wiki, http://build.ofbiz.org and not the Subversion (SVN) package.
The 
> instructions regarding which download is appropriate given your 
> situation are confusing at best. I prefer to keep it simple when
getting 
> started. A little excerpt from my recent book:
> 
> Currently, if you visit the OFBiz site and decide to download a
> version,
> you have several options. The easiest thing to do is follow the
big
> download button and get the "nightly build". This is a prepackaged
> version
> ready to unzip and run. Nightly builds contain everything
necessary to
> execute the demonstrations discussed in this book. They also
contain
> all
> the source code and other artifacts including build scripts that
are
> used to
> create the nightly builds. In other words, you get "all that and
the
> source
> too"! 
> 
> You won't need Tomcat, SVN or Ant to download a nightly build and get
up 
> and running quickly. Simply, create the directory you wish to run
OFBiz 
> in (make sure that Java is on the classpath while working in this 
> directory), change to that directory, unzip your file there and
startup 
> OFBiz. For example:
> 
> 1) Create a directory such as /home/ofbiz
> 2) Download the zip file to your new directory. You will have
something 
> that looks like this: /home/ofbiz/ofbizdownload.zip
> 3) Unzip your file using something like gzip (Not sure what the Ubuntu

> unzip command is.)
> 4) Move to the unzipped file location doing something like: cd  
> /home/ofbiz/ofbizdownload
> 4) Run the Unix OFBiz invocation script that comes with the 
> distribution: ./startofbiz.sh
> 5) Navigate to the ecommerce startup page
http://localhost:8080/ecommerce
> 6) Observe that you see the ecommerce landing page
> 
> Once you understand what you've got out-of-the-box and you are ready
to 
> do some development work, then consider downloading from SVN.
> 
> Regards,
> Ruth Hoffman
> http://www.myofbiz.com
> 
> MavrickIT wrote:
>> Thanks Patel for trying to help me out. I have gone through the links
>> already
>> that you gave me. Thing is, I already installed JRE6, full SDK, and
>> tomcat,
>> SVN, ANT etc. These were installed in root by default.
>> I created folder /home/ofbiz. So, there is nothing inside
...home/ofbiz$
>> I performed svn co http://svn.apache..
>> Even I tried svn co http://../ofbiz9+ and svn co
>> http:///ofbiz4.0
>>
>> So, how could I download ofbiz or even extract it, I don't know.
Even,
>> from
>> where to download it?
>> Some google sites say, to download ofbiz separately and extract it to
>> /home/ofbiz user. Somewhere
>> (http://docs.ofbiz.org/display/OFBADMIN/Demo+and+Test+Setup+Guide)
it's
>> shown that, "OFBiz with embedded Tomcat". 
>> I can't find any exact solution. I am yet confused what should I type
@
>> the
>> terminal for installing Ofbiz from the beginning. 
>> Waiting for any suitable reply.:-(
>> Thank you.
>>
>>
>>
>> Anil Patel-3 wrote:
>>   
>>> Hi,
>>>
>>> For quick setup use
>>> http://docs.ofbiz.org/display/OFBADMIN/Demo+and+Test+Setup+Guide
>>>
>>> Please see following documents to setup development/staging
environment.
>>>
>>>
http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+
Setup+Guide
>>>
http://docs.ofbiz.org/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Gui
de
>>>
>>>
>>> Regards
>>> Anil patel
>>>
>>>
>>> On Oct 2, 2009, at 12:34 PM, MavrickIT wrote:
>>>
>>> 
 Can anybody help me out for Ofbiz installation guide [step by step

 command
 lines] from the Terminal (Ububntu)?

 I've been facing lots trouble about it. Please find me a solution.
I  
 found
 no solid step by step commands tutorials for installing ofbiz or  
 running it.
>>

Re: Ofbiz installation tutorial???

[MavrickIT]

Thanks Ruth,
Your procedure works. 
But, when I start it ./startofbiz.sh screen is flooded and flooded. 
It's shown at bottom -> Not committing transaction, status is No transaction
(6)
and does it take longer to be started ? It's more than 5 mins, still the
screen is flooded and yet not started the ofbiz.
I created $/home/ofbiz
Downloaded ofbiz into /home/ofbiz$
Extracted it into /home/ofbiz/ofbiz$
I found---> /home/ofbiz/ofbiz/ofbiz-trunk$dir
. .  startofbiz.sh   
. . ... .. .
I started it as /home/ofbiz/ofbiz/ofbiz-trunk$./startofbiz.sh

there it goes. Screen flood.
Got stuck in here.
Any solution?
I already have JRE6 (full sdk installed), SVN, tomcat, ANT installed
Thanks


Ruth Hoffman-2 wrote:
> 
> Hello MavrickIT:
> IMHO, take baby steps: Start by downloading a "zip'd" version from the 
> wiki, http://build.ofbiz.org and not the Subversion (SVN) package.  The 
> instructions regarding which download is appropriate given your 
> situation are confusing at best. I prefer to keep it simple when getting 
> started. A little excerpt from my recent book:
> 
> Currently, if you visit the OFBiz site and decide to download a
> version,
> you have several options. The easiest thing to do is follow the big
> download button and get the "nightly build". This is a prepackaged
> version
> ready to unzip and run. Nightly builds contain everything necessary to
> execute the demonstrations discussed in this book. They also contain
> all
> the source code and other artifacts including build scripts that are
> used to
> create the nightly builds. In other words, you get "all that and the
> source
> too"! 
> 
> You won't need Tomcat, SVN or Ant to download a nightly build and get up 
> and running quickly. Simply, create the directory you wish to run OFBiz 
> in (make sure that Java is on the classpath while working in this 
> directory), change to that directory, unzip your file there and startup 
> OFBiz. For example:
> 
> 1) Create a directory such as /home/ofbiz
> 2) Download the zip file to your new directory. You will have something 
> that looks like this: /home/ofbiz/ofbizdownload.zip
> 3) Unzip your file using something like gzip (Not sure what the Ubuntu 
> unzip command is.)
> 4) Move to the unzipped file location doing something like: cd  
> /home/ofbiz/ofbizdownload
> 4) Run the Unix OFBiz invocation script that comes with the 
> distribution: ./startofbiz.sh
> 5) Navigate to the ecommerce startup page http://localhost:8080/ecommerce
> 6) Observe that you see the ecommerce landing page
> 
> Once you understand what you've got out-of-the-box and you are ready to 
> do some development work, then consider downloading from SVN.
> 
> Regards,
> Ruth Hoffman
> http://www.myofbiz.com
> 
> MavrickIT wrote:
>> Thanks Patel for trying to help me out. I have gone through the links
>> already
>> that you gave me. Thing is, I already installed JRE6, full SDK, and
>> tomcat,
>> SVN, ANT etc. These were installed in root by default.
>> I created folder /home/ofbiz. So, there is nothing inside ...home/ofbiz$
>> I performed svn co http://svn.apache..
>> Even I tried svn co http://../ofbiz9+ and svn co
>> http:///ofbiz4.0
>>
>> So, how could I download ofbiz or even extract it, I don't know. Even,
>> from
>> where to download it?
>> Some google sites say, to download ofbiz separately and extract it to
>> /home/ofbiz user. Somewhere
>> (http://docs.ofbiz.org/display/OFBADMIN/Demo+and+Test+Setup+Guide) it's
>> shown that, "OFBiz with embedded Tomcat". 
>> I can't find any exact solution. I am yet confused what should I type @
>> the
>> terminal for installing Ofbiz from the beginning. 
>> Waiting for any suitable reply.:-(
>> Thank you.
>>
>>
>>
>> Anil Patel-3 wrote:
>>   
>>> Hi,
>>>
>>> For quick setup use
>>> http://docs.ofbiz.org/display/OFBADMIN/Demo+and+Test+Setup+Guide
>>>
>>> Please see following documents to setup development/staging environment.
>>>
>>> http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide
>>> http://docs.ofbiz.org/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide
>>>
>>>
>>> Regards
>>> Anil patel
>>>
>>>
>>> On Oct 2, 2009, at 12:34 PM, MavrickIT wrote:
>>>
>>> 
 Can anybody help me out for Ofbiz installation guide [step by step  
 command
 lines] from the Terminal (Ububntu)?

 I've been facing lots trouble about it. Please find me a solution. I  
 found
 no solid step by step commands tutorials for installing ofbiz or  
 running it.
 well, I am newbie to linux as well. Eventually, I don't even know  
 how to
 extract or download ofbiz.
 Please help me.
 -- 
 View this message in context:
 http://www.nabble.com/Ofbiz-installation-tutorialtp25716734p25716734.html
 Sent from the OFBiz - User mailing list archive at Nabble.com.

   
>>>
>>> 
>>
>>   
> 
> 

-- 

RE: OFBiz installation tutorial???

[MavrickIT]

Hey Dan,
Would be great if you could do so.
I should be waiting for your response.

Thanks,


Dan Dodd wrote:
> 
> MavrickIT, 
> I'll put together a note on how to download and build OFBiz on an
> existing ubuntu server if that would work for you.
> 
> Dan Dodd
> 
> IHOP-KC
> dand...@ihop.org 
> 
> -Original Message-
> From: Ruth Hoffman [mailto:rhoff...@aesolves.com] 
> Sent: Monday, October 05, 2009 9:39 PM
> To: user@ofbiz.apache.org
> Subject: Re: Ofbiz installation tutorial???
> 
> Hi MavrickIT:
> How about not using "wget" and use the download button from the Wiki. As
> 
> for version, I suggest the one pointed to by the download button. Beyond
> 
> that, I can't help you.
> Regards,
> Ruth
> 
> MavrickIT wrote:
>> Hey Hoffman,
>> Thanks for the solid solution. But I am stuck in again.
>> $wget http://build.ofbiz.org/ofbiz-trunk-current.zip or
>> $wget http://build.ofbiz.org/ofbiz-rel9.04-current.zip
>> typing those commands ofbiz.zip is not downloaded anyway. 
>> so, have no idea of downloading it. What should be the command
> exactly. even
>> I tried lw-download something like this. Not working.
>> I find an error 404 not found. like the page cannot be found in any
> browser
>> we see. 404 error means the same.
>> So.. please help me.
>> Thanks
>>
>>
>>
>>
>> Ruth Hoffman-2 wrote:
>>   
>>> Hello MavrickIT:
>>> IMHO, take baby steps: Start by downloading a "zip'd" version from
> the 
>>> wiki, http://build.ofbiz.org and not the Subversion (SVN) package.
> The 
>>> instructions regarding which download is appropriate given your 
>>> situation are confusing at best. I prefer to keep it simple when
> getting 
>>> started. A little excerpt from my recent book:
>>>
>>> Currently, if you visit the OFBiz site and decide to download a
>>> version,
>>> you have several options. The easiest thing to do is follow the
> big
>>> download button and get the "nightly build". This is a
> prepackaged
>>> version
>>> ready to unzip and run. Nightly builds contain everything
> necessary to
>>> execute the demonstrations discussed in this book. They also
> contain
>>> all
>>> the source code and other artifacts including build scripts that
> are
>>> used to
>>> create the nightly builds. In other words, you get "all that and
> the
>>> source
>>> too"! 
>>>
>>> You won't need Tomcat, SVN or Ant to download a nightly build and get
> up 
>>> and running quickly. Simply, create the directory you wish to run
> OFBiz 
>>> in (make sure that Java is on the classpath while working in this 
>>> directory), change to that directory, unzip your file there and
> startup 
>>> OFBiz. For example:
>>>
>>> 1) Create a directory such as /home/ofbiz
>>> 2) Download the zip file to your new directory. You will have
> something 
>>> that looks like this: /home/ofbiz/ofbizdownload.zip
>>> 3) Unzip your file using something like gzip (Not sure what the
> Ubuntu 
>>> unzip command is.)
>>> 4) Move to the unzipped file location doing something like: cd  
>>> /home/ofbiz/ofbizdownload
>>> 4) Run the Unix OFBiz invocation script that comes with the 
>>> distribution: ./startofbiz.sh
>>> 5) Navigate to the ecommerce startup page
> http://localhost:8080/ecommerce
>>> 6) Observe that you see the ecommerce landing page
>>>
>>> Once you understand what you've got out-of-the-box and you are ready
> to 
>>> do some development work, then consider downloading from SVN.
>>>
>>> Regards,
>>> Ruth Hoffman
>>> http://www.myofbiz.com
>>>
>>> MavrickIT wrote:
>>> 
 Thanks Patel for trying to help me out. I have gone through the
> links
 already
 that you gave me. Thing is, I already installed JRE6, full SDK, and
 tomcat,
 SVN, ANT etc. These were installed in root by default.
 I created folder /home/ofbiz. So, there is nothing inside
> ...home/ofbiz$
 I performed svn co http://svn.apache..
 Even I tried svn co http://../ofbiz9+ and svn co
 http:///ofbiz4.0

 So, how could I download ofbiz or even extract it, I don't know.
> Even,
 from
 where to download it?
 Some google sites say, to download ofbiz separately and extract it
> to
 /home/ofbiz user. Somewhere
 (http://docs.ofbiz.org/display/OFBADMIN/Demo+and+Test+Setup+Guide)
> it's
 shown that, "OFBiz with embedded Tomcat". 
 I can't find any exact solution. I am yet confused what should I
> type @
 the
 terminal for installing Ofbiz from the beginning. 
 Waiting for any suitable reply.:-(
 Thank you.



 Anil Patel-3 wrote:
   
   
> Hi,
>
> For quick setup use
> http://docs.ofbiz.org/display/OFBADMIN/Demo+and+Test+Setup+Guide
>
> Please see following documents to setup development/staging
> environment.
>
>
> http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+
> Setup+Guide
>
> http://docs.ofbiz.org/display/OFBENDUSER/Apache+OFBiz+Business+Set

Re: Example of DynamicViewEntity in Java

[Jacques Le Roux]

I'd say
File name patterns = *.gro*, *.java
if using trunk

Jacques

From: "Chris Snow" 

If using eclipse, do File Search using the criteria:

Containing text = DynamicViewEntity
and
File name patterns = *.bsh, *.java



su2 wrote:

Hello Friends,

Is there any where I can find example of DynamicViewEntity in Java ?

Thank you for the help in advance.

Su-
  

Re: Example of DynamicViewEntity in Java

[Chris Snow]

If using eclipse, do File Search using the criteria:

Containing text = DynamicViewEntity
and
File name patterns = *.bsh, *.java



su2 wrote:

Hello Friends,

Is there any where I can find example of DynamicViewEntity in Java ?

Thank you for the help in advance.

Su-
  

Example of DynamicViewEntity in Java

[su2]

Hello Friends,

Is there any where I can find example of DynamicViewEntity in Java ?

Thank you for the help in advance.

Su-
-- 
View this message in context: 
http://www.nabble.com/Example-of-DynamicViewEntity-in-Java-tp25770912p25770912.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: Localization for Indonesia - OFBiz

[Adrian Crum]

The only thing that would need to be changed is the calendar - if you 
need something other than Gregorian. I started working on a 
user-selected calendar, but I haven't had time to finish it.


-Adrian

naveen chanda wrote:

Dear All,


I would like to make the OFBiz application for Indonesia, could any one
explain the steps to change the Locale to Indoensia.

I have checked and followed this document, but i cannot able to find any
changes.

http://docs.ofbiz.org/display/OFBTECH/Calendars%2C+Dates%2C+and+Times

I mean to say, that the date, calendar, timestamp must be changed
accordingly.

Please help me on this.


Thanks,
Naveen Chanda

Re: partytypeid = person how?

[Adrian Crum]

What you might want to do is create a SECA that is triggered on 
PartyRole update. If the change isn't allowed, then return an error or 
failure.


-Adrian

ARays wrote:

Thanks Adrian. I figured it would be easier to stick to using 'Role' than
PartyType to limit the number of changes and be reasonably close to the
trunk codebase. I would have liked a way to fix a role that can't be changed
or dropped (essentially achieving the same effect as my original intent of
picking a partyType) and my next steps would be to try and fix that sort of
thing. 

- Arays 



Adrian Crum wrote:

Employee is a party role, not a party type.

It would be less work for you to use the existing functionality.

-Adrian

ARays wrote:
Hi, 


I am following the createEmployee flow of partymgr and trying to
establish
where the partyTypeId is set to 'PERSON'. I am looking to change that to
a
sub type called 'EMPLOYEE' that I have created. I could figure out how
alternative flow for 'PARTY_GROUP' is set , but unclear on how 'PERSON'
is
set. Would really appreciate pointers. 


- Arays

Re: is Stroed Procedures possible in OFBiz?

[su2]

Hi Mridul,

Thanks for the reply. But  does not work if I want it in a
view-entity which is created using  other view-entities(I think somebody
mentioned on my that post earlier that its a bug and he will look into it
and if not resolved he will create JIRA issue). It just works if i need to
create a view-entity using two entities.

If I could use , then my life would have been much easier.

I have following simple Query - SELECT with WHERE clause in a Java Method.
But I need to have
SUM(OTCMAdjustmentAmount). (Here OrderAndTax is a view-entity created using
two other view-entities.)

--
List fieldsToSelect = UtilMisc.toList("OTCMAdjustmentAmount");

EntityConditionList whereConditions = new
EntityConditionList(UtilMisc.toList(
new EntityExpr("OTCMOrderNo", EntityOperator.EQUALS,
OTCMOrderNo),
new EntityExpr("OTCMAdjustmentAmountType",
EntityOperator.EQUALS, "SALES_TAX")
  ), EntityOperator.AND); 

orderTaxObject = delegator.findByCondition("OrderAndTax",
whereConditions, null, fieldsToSelect, null, null); 
--

I really appreciate your help.

Thank you.
Shuchi-



Mridul Pathak-2 wrote:
> 
> Shuchi,
> 
> One way is to define a view entity, in your component's entity-model.xml
> using  tag.  You can use
>  child tags for your summing
> requirement.  This view will also be accessible in webtools.  In your code
> you can then use delegator methods to retrieve the list from this view
> entity.
> -- 
> Thanks & Regards
> Mridul Pathak
> Hotwax Media
> http://www.hotwaxmedia.com
> mridul.pat...@hotwaxmedia.com
> -
> direct: +91 - 942.592.6892
> 
> 
> On Tue, Oct 6, 2009 at 7:14 PM, su2  wrote:
> 
>>
>> Hi Chris,
>>
>> Thank you for the response.
>>
>> My query has multiple joins with different tables and also I would like
>> to
>> use sum(column name) and (column 1 + column 2) as column 3.
>>
>> Is it possible to use sum(column name) in java method with delegator?
>>
>> Also, the stored procedure I want to use in jasper report.
>>
>> Thank you for the help.
>> Su-
>>
>>
>> Chris Snow-3 wrote:
>> >
>> > Hi Su,
>> >
>> > I use SQL Views for complex queries:
>> >
>> > > > table-name="vClearanceReport"
>> > package-name="uk.co.dhales"
>> > title="Clearance Report Entity"
>> > no-auto-stamp="true"
>> > never-cache="true"
>> > >
>> > > > type="long-varchar"/>
>> > > > type="long-varchar"/>
>> > > > type="long-varchar"/>
>> > > > type="numeric"/>
>> > ...
>> > 
>> > 
>> >
>> > The table name vClearanceReport is actually a SQL View. The attributes
>> > no-auto-stamp and never-cache where needed.
>> >
>> > Also, here is a service that is using a SQL Stored procedure:
>> >
>> > public class DHSequenceService {
>> >
>> > public static Map getNextSequenceValue(DispatchContext ctx, Map
>> > context) {
>> > Connection conn = null;
>> > CallableStatement statement = null;
>> >
>> > String sql = "{call getNextSequenceValue(?,?)}";
>> >
>> > Long seqValue;
>> > try{
>> > conn = ConnectionFactory.getConnection("dhmssql");
>> > if (conn == null) {
>> > throw new Exception("No dhmssql connection
>> > configured");
>> > }
>> > statement = conn.prepareCall (sql);
>> > String seqTable = (String)context.get("seqTable");
>> >
>> > statement.registerOutParameter(1, Types.INTEGER);
>> > statement.setString(2,  seqTable);
>> > statement.execute();
>> > seqValue = new Long(statement.getLong(1));
>> > statement.close();
>> > } catch (Exception e){
>> > Debug.logError(e, "Error running SQL - ",
>> > DHSequenceService.class.getName());
>> > return ServiceUtil.returnError("Error running SQL" +
>> e);
>> > }
>> > finally {
>> > if (statement != null)
>> > try {
>> > statement.close();
>> > } catch (Exception e) {}
>> > if (conn != null)
>> > try {
>> > conn.close();
>> > } catch (Exception e) {}
>> > }
>> > Map resultMap = ServiceUtil.returnSuccess();
>> > resultMap.put("seqValue", seqValue);
>> > return resultMap;
>> > }
>> > }
>> >
>> > Note that by using SQL Views/Stored Procedures you are limiting the
>> > portability of your application to other databases.
>> >
>

Re: is Stroed Procedures possible in OFBiz?

[Chris Snow]

I wasn't aware that list forms can display lists with detail and summary 
level data...


su2 wrote:

Unfortunately, my  whole display page is in Form Widget with "Form Type =
list", So I think the best way for this case is to have Query with sum().
Correct me if I am wrong. Because at this point, I am not sure whether I can
convert my entire Form widget into Freemarker.

Thank you for your help.
Su- 




 You can correct me if I am wrong.
 


Chris Snow-3 wrote:
  
One method (not necessarily the best) is to output the list in 
freemarker.  You can assign a variable in freemarker to the value you 
are summing.


<#assign totalAmount = 0>

<#list context.detailList as row>
   
 ${row.itemDescription}
 ${row.itemAmount}
   
   <#assign totalAmount = totalAmount + row.itemAmount>   


   
  TOTAL
  ${totalAmount}
   



su2 wrote:


Hi Chris,

It is a list/result of multiple table joins.

I have requirement of displaying both aggregated (summed) values as well
as
to display the detail (unsummed) records.

I have little idea to get detail/unsummed record as list using . But I do not have any clue how to use sum(column name) with
the
java delegator.

I have following simple Query - SELECT with WHERE clause. But I need to
have
SUM(OTCMAdjustmentAmount). (Here OrderAndTax is a view-entity created
using
two other view-entities.)

--
List fieldsToSelect = UtilMisc.toList("OTCMAdjustmentAmount");

EntityConditionList whereConditions = new
EntityConditionList(UtilMisc.toList(
new EntityExpr("OTCMOrderNo", EntityOperator.EQUALS,
OTCMOrderNo),
new EntityExpr("OTCMAdjustmentAmountType",
EntityOperator.EQUALS, "SALES_TAX")
  ), EntityOperator.AND); 
	

orderTaxObject = delegator.findByCondition("OrderAndTax",
whereConditions, null, fieldsToSelect, null, null); 
--


I really appreciate your help.

Thank you.
Su-



Chris Snow-3 wrote:
  
  
Hi Su,  how are you using the returned data? Is it a table list, or just 
a single form?


If it is a list, do you want to display just the aggregated (summed) 
values, or do you want to display the detail (unsummed) records too?


su2 wrote:



Hi Chris,

Thank you for the response.

My query has multiple joins with different tables and also I would like
to
use sum(column name) and (column 1 + column 2) as column 3.

Is it possible to use sum(column name) in java method with delegator?

Also, the stored procedure I want to use in jasper report.

Thank you for the help.
Su-


Chris Snow-3 wrote:
  
  
  

Hi Su,

I use SQL Views for complex queries:

never-cache="true"   
>
type="long-varchar"/>
type="long-varchar"/>



...



The table name vClearanceReport is actually a SQL View. The attributes 
no-auto-stamp and never-cache where needed.


Also, here is a service that is using a SQL Stored procedure:

public class DHSequenceService {
   
public static Map getNextSequenceValue(DispatchContext ctx, Map 
context) {

Connection conn = null;
CallableStatement statement = null;
  
String sql = "{call getNextSequenceValue(?,?)}";
   
Long seqValue;

try{
conn = ConnectionFactory.getConnection("dhmssql");
if (conn == null) {
throw new Exception("No dhmssql connection 
configured");

}
statement = conn.prepareCall (sql);
String seqTable = (String)context.get("seqTable");

statement.registerOutParameter(1, Types.INTEGER);
statement.setString(2,  seqTable);
statement.execute();
seqValue = new Long(statement.getLong(1));
statement.close();
} catch (Exception e){
Debug.logError(e, "Error running SQL - ", 
DHSequenceService.class.getName());

return ServiceUtil.returnError("Error running SQL" +
e);
}
finally {
if (statement != null)
try {
statement.close();
} catch (Exception e) {}
if (conn != null)
try {
conn.close();
} catch (Exception e) {}
}
Map resultMap = ServiceUtil.returnSuccess();
resultMap.put("seqValue", seqValue);
return resultMap;
}
}

Note that by using SQL Views/Stored Procedures you are limiting the 
portability of your application to other databases.


Cheers,

Chris

su2 wrote:




Hello Friends,

I need

Re: is Stroed Procedures possible in OFBiz?

[su2]

Unfortunately, my  whole display page is in Form Widget with "Form Type =
list", So I think the best way for this case is to have Query with sum().
Correct me if I am wrong. Because at this point, I am not sure whether I can
convert my entire Form widget into Freemarker.

Thank you for your help.
Su- 



 You can correct me if I am wrong.
 

Chris Snow-3 wrote:
> 
> One method (not necessarily the best) is to output the list in 
> freemarker.  You can assign a variable in freemarker to the value you 
> are summing.
> 
> <#assign totalAmount = 0>
> 
> <#list context.detailList as row>
>
>  ${row.itemDescription}
>  ${row.itemAmount}
>
><#assign totalAmount = totalAmount + row.itemAmount>   
> 
>
>   TOTAL
>   ${totalAmount}
>
> 
> 
> 
> su2 wrote:
>> Hi Chris,
>>
>> It is a list/result of multiple table joins.
>>
>> I have requirement of displaying both aggregated (summed) values as well
>> as
>> to display the detail (unsummed) records.
>>
>> I have little idea to get detail/unsummed record as list using > type=list>. But I do not have any clue how to use sum(column name) with
>> the
>> java delegator.
>>
>> I have following simple Query - SELECT with WHERE clause. But I need to
>> have
>> SUM(OTCMAdjustmentAmount). (Here OrderAndTax is a view-entity created
>> using
>> two other view-entities.)
>>
>> --
>> List fieldsToSelect = UtilMisc.toList("OTCMAdjustmentAmount");
>>  
>>  EntityConditionList whereConditions = new
>> EntityConditionList(UtilMisc.toList(
>> new EntityExpr("OTCMOrderNo", EntityOperator.EQUALS,
>> OTCMOrderNo),
>> new EntityExpr("OTCMAdjustmentAmountType",
>> EntityOperator.EQUALS, "SALES_TAX")
>>   ), EntityOperator.AND); 
>>  
>>  orderTaxObject = delegator.findByCondition("OrderAndTax",
>> whereConditions, null, fieldsToSelect, null, null); 
>> --
>>
>> I really appreciate your help.
>>
>> Thank you.
>> Su-
>>
>>
>>
>> Chris Snow-3 wrote:
>>   
>>> Hi Su,  how are you using the returned data? Is it a table list, or just 
>>> a single form?
>>>
>>> If it is a list, do you want to display just the aggregated (summed) 
>>> values, or do you want to display the detail (unsummed) records too?
>>>
>>> su2 wrote:
>>> 
 Hi Chris,

 Thank you for the response.

 My query has multiple joins with different tables and also I would like
 to
 use sum(column name) and (column 1 + column 2) as column 3.

 Is it possible to use sum(column name) in java method with delegator?

 Also, the stored procedure I want to use in jasper report.

 Thank you for the help.
 Su-


 Chris Snow-3 wrote:
   
   
> Hi Su,
>
> I use SQL Views for complex queries:
>
>  table-name="vClearanceReport"
> package-name="uk.co.dhales"
> title="Clearance Report Entity"
> no-auto-stamp="true"
> never-cache="true"   
> >
>  type="long-varchar"/>
>  type="long-varchar"/>
>  type="long-varchar"/>
>  type="numeric"/>
> ...
> 
> 
>
> The table name vClearanceReport is actually a SQL View. The attributes 
> no-auto-stamp and never-cache where needed.
>
> Also, here is a service that is using a SQL Stored procedure:
>
> public class DHSequenceService {
>
> public static Map getNextSequenceValue(DispatchContext ctx, Map 
> context) {
> Connection conn = null;
> CallableStatement statement = null;
>   
> String sql = "{call getNextSequenceValue(?,?)}";
>
> Long seqValue;
> try{
> conn = ConnectionFactory.getConnection("dhmssql");
> if (conn == null) {
> throw new Exception("No dhmssql connection 
> configured");
> }
> statement = conn.prepareCall (sql);
> String seqTable = (String)context.get("seqTable");
>
> statement.registerOutParameter(1, Types.INTEGER);
> statement.setString(2,  seqTable);
> statement.execute();
> seqValue = new Long(statement.getLong(1));
> statement.close();
> } catch (Exception e){
> Debug.logError(e, "Error running SQL - ", 
> DHSequenceService.class.getName());
> return ServiceUtil.returnError("Error running SQL" +
> e);
> }
> finally {

Re: Problem while running OFBiz under external Tomcat.

[toanilsoni]

Thanks Scott and Yoke.

I've ran the ant run-install and tested it properly data is loaded
successfully but while I am running it through external Tomcat am getting
the problem of Theme data.



On Tue, Oct 6, 2009 at 6:29 AM, Yoke Power  wrote:

> Please confirm if you had run the run-install ant task
>
> - YOKEPOWER
>
> On Mon, Oct 5, 2009 at 7:40 PM, Scott Gray  >wrote:
>
> > If I'm not wrong theme data is one of the first pieces of data that OFBiz
> > attempts to get from the database when a page is loaded and an error here
> is
> > usually indicative of something being wrong with your data setup.  Either
> > the data is not loaded like you think it is or OFBiz is having trouble
> > communicating with the database that contains your data.
> >
> > Regards
> > Scott
> >
> >
> > On 6/10/2009, at 3:16 AM, toanils...@gmail.com wrote:
> >
> >  Friends,
> >>
> >> I have followed the steps to run OFBiz under external Tomcat as stated
> in
> >> this link:  http://docs.ofbiz.org/display/OFBTECH/Tomcat
> >>
> >> But when I am running catalina.bat, I getting following error  :
> >>
> >>
> >> 2009-10-05 17:30:28,248 (http-8080-1) [TransactionUtil.java:371:WARN
> ]
> >>  exception report
> >> --
> >> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly;
> >> this stack trace shows where this is happening:
> >> Exception: java.lang.Exception
> >> Message: Error in simple-method [Get visual theme resources
> >>
> [file:/D:/dev/ofbiz-trunk/framework/common/script/org/ofbiz/common/CommonServices.xml
> >> #getVisualThemeResources]]: ; [Visual Theme resources not found.]
> >>  stack trace
> >> ---
> >> java.lang.Exception: Error in simple-method [Get visual theme resources
> >>
> [file:/D:/dev/ofbiz-trunk/framework/common/script/org/ofbiz/common/Common
> >> Services.xml#getVisualThemeResources]]: ; [Visual Theme resources not
> >> found.]
> >>
> >>
> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:371)
> >>
> >>
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:318)
> >> org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:833)
> >> org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:160)
> >> org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:142)
> >>
> >>
> org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:78)
> >>
> >>
> org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:53)
> >>
> >>
> org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:785)
> >>
> >>
> _$gen.file_58$.D_58$.dev.ofbiz_45$trunk.framework.common.servicedef.services_46$xml_35$getVisualThemeResources.runSync(file:/D:/dev/ofbiz-trunk/f
> >> ramework/common/servicedef/services.xml#getVisualThemeResources:467)
> >> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:399)
> >> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:228)
> >> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:159)
> >>
> >>
> org.ofbiz.widget.screen.ModelScreenAction$Service.runAction(ModelScreenAction.java:486)
> >>
> >>
> org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:118)
> >>
> >>
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:264)
> >>
> >>
> org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:393)
> >>
> >>
> org.ofbiz.widget.screen.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:701)
> >>
> >>
> org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:180)
> >>
> >>
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:271)
> >>
> >>
> org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:393)
> >> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:134)
> >> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:96)
> >>
> >>
> org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:99)
> >>
> >>
> org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:808)
> >>
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:550)
> >> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:221)
> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> >>
> >>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> >>
> >>
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> >>
> >>
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
> >>
> >>
> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationD

Re: is Stroed Procedures possible in OFBiz?

[Chris Snow]

One method (not necessarily the best) is to output the list in 
freemarker.  You can assign a variable in freemarker to the value you 
are summing.


<#assign totalAmount = 0>

<#list context.detailList as row>
  
${row.itemDescription}
${row.itemAmount}
  
  <#assign totalAmount = totalAmount + row.itemAmount>   


  
 TOTAL
 ${totalAmount}
  



su2 wrote:

Hi Chris,

It is a list/result of multiple table joins.

I have requirement of displaying both aggregated (summed) values as well as
to display the detail (unsummed) records.

I have little idea to get detail/unsummed record as list using . But I do not have any clue how to use sum(column name) with the
java delegator.

I have following simple Query - SELECT with WHERE clause. But I need to have
SUM(OTCMAdjustmentAmount). (Here OrderAndTax is a view-entity created using
two other view-entities.)

--
List fieldsToSelect = UtilMisc.toList("OTCMAdjustmentAmount");

EntityConditionList whereConditions = new
EntityConditionList(UtilMisc.toList(
new EntityExpr("OTCMOrderNo", EntityOperator.EQUALS,
OTCMOrderNo),
new EntityExpr("OTCMAdjustmentAmountType",
EntityOperator.EQUALS, "SALES_TAX")
  ), EntityOperator.AND); 
	

orderTaxObject = delegator.findByCondition("OrderAndTax",
whereConditions, null, fieldsToSelect, null, null); 
--


I really appreciate your help.

Thank you.
Su-



Chris Snow-3 wrote:
  
Hi Su,  how are you using the returned data? Is it a table list, or just 
a single form?


If it is a list, do you want to display just the aggregated (summed) 
values, or do you want to display the detail (unsummed) records too?


su2 wrote:


Hi Chris,

Thank you for the response.

My query has multiple joins with different tables and also I would like
to
use sum(column name) and (column 1 + column 2) as column 3.

Is it possible to use sum(column name) in java method with delegator?

Also, the stored procedure I want to use in jasper report.

Thank you for the help.
Su-


Chris Snow-3 wrote:
  
  

Hi Su,

I use SQL Views for complex queries:

never-cache="true"   
>
type="long-varchar"/>
type="long-varchar"/>



...



The table name vClearanceReport is actually a SQL View. The attributes 
no-auto-stamp and never-cache where needed.


Also, here is a service that is using a SQL Stored procedure:

public class DHSequenceService {
   
public static Map getNextSequenceValue(DispatchContext ctx, Map 
context) {

Connection conn = null;
CallableStatement statement = null;
  
String sql = "{call getNextSequenceValue(?,?)}";
   
Long seqValue;

try{
conn = ConnectionFactory.getConnection("dhmssql");
if (conn == null) {
throw new Exception("No dhmssql connection 
configured");

}
statement = conn.prepareCall (sql);
String seqTable = (String)context.get("seqTable");

statement.registerOutParameter(1, Types.INTEGER);
statement.setString(2,  seqTable);
statement.execute();
seqValue = new Long(statement.getLong(1));
statement.close();
} catch (Exception e){
Debug.logError(e, "Error running SQL - ", 
DHSequenceService.class.getName());

return ServiceUtil.returnError("Error running SQL" + e);
}
finally {
if (statement != null)
try {
statement.close();
} catch (Exception e) {}
if (conn != null)
try {
conn.close();
} catch (Exception e) {}
}
Map resultMap = ServiceUtil.returnSuccess();
resultMap.put("seqValue", seqValue);
return resultMap;
}
}

Note that by using SQL Views/Stored Procedures you are limiting the 
portability of your application to other databases.


Cheers,

Chris

su2 wrote:



Hello Friends,

I need to write quite complex query which is little easier to write as
Stored Procedures. So I would like to know whether is it possible to
write
and access stored procedures in OFBiz with mySQL?

If its possible, can i have example or reference for how to do that ?

Thank you for the help in advance.

Su-
  
  
  


  
  





  

Re: is Stroed Procedures possible in OFBiz?

[su2]

Hi Chris,

It is a list/result of multiple table joins.

I have requirement of displaying both aggregated (summed) values as well as
to display the detail (unsummed) records.

I have little idea to get detail/unsummed record as list using . But I do not have any clue how to use sum(column name) with the
java delegator.

I have following simple Query - SELECT with WHERE clause. But I need to have
SUM(OTCMAdjustmentAmount). (Here OrderAndTax is a view-entity created using
two other view-entities.)

--
List fieldsToSelect = UtilMisc.toList("OTCMAdjustmentAmount");

EntityConditionList whereConditions = new
EntityConditionList(UtilMisc.toList(
new EntityExpr("OTCMOrderNo", EntityOperator.EQUALS,
OTCMOrderNo),
new EntityExpr("OTCMAdjustmentAmountType",
EntityOperator.EQUALS, "SALES_TAX")
  ), EntityOperator.AND); 

orderTaxObject = delegator.findByCondition("OrderAndTax",
whereConditions, null, fieldsToSelect, null, null); 
--

I really appreciate your help.

Thank you.
Su-



Chris Snow-3 wrote:
> 
> Hi Su,  how are you using the returned data? Is it a table list, or just 
> a single form?
> 
> If it is a list, do you want to display just the aggregated (summed) 
> values, or do you want to display the detail (unsummed) records too?
> 
> su2 wrote:
>> Hi Chris,
>>
>> Thank you for the response.
>>
>> My query has multiple joins with different tables and also I would like
>> to
>> use sum(column name) and (column 1 + column 2) as column 3.
>>
>> Is it possible to use sum(column name) in java method with delegator?
>>
>> Also, the stored procedure I want to use in jasper report.
>>
>> Thank you for the help.
>> Su-
>>
>>
>> Chris Snow-3 wrote:
>>   
>>> Hi Su,
>>>
>>> I use SQL Views for complex queries:
>>>
>>> >> table-name="vClearanceReport"
>>> package-name="uk.co.dhales"
>>> title="Clearance Report Entity"
>>> no-auto-stamp="true"
>>> never-cache="true"   
>>> >
>>> >> type="long-varchar"/>
>>> >> type="long-varchar"/>
>>> >> type="long-varchar"/>
>>> >> type="numeric"/>
>>> ...
>>> 
>>> 
>>>
>>> The table name vClearanceReport is actually a SQL View. The attributes 
>>> no-auto-stamp and never-cache where needed.
>>>
>>> Also, here is a service that is using a SQL Stored procedure:
>>>
>>> public class DHSequenceService {
>>>
>>> public static Map getNextSequenceValue(DispatchContext ctx, Map 
>>> context) {
>>> Connection conn = null;
>>> CallableStatement statement = null;
>>>   
>>> String sql = "{call getNextSequenceValue(?,?)}";
>>>
>>> Long seqValue;
>>> try{
>>> conn = ConnectionFactory.getConnection("dhmssql");
>>> if (conn == null) {
>>> throw new Exception("No dhmssql connection 
>>> configured");
>>> }
>>> statement = conn.prepareCall (sql);
>>> String seqTable = (String)context.get("seqTable");
>>>
>>> statement.registerOutParameter(1, Types.INTEGER);
>>> statement.setString(2,  seqTable);
>>> statement.execute();
>>> seqValue = new Long(statement.getLong(1));
>>> statement.close();
>>> } catch (Exception e){
>>> Debug.logError(e, "Error running SQL - ", 
>>> DHSequenceService.class.getName());
>>> return ServiceUtil.returnError("Error running SQL" + e);
>>> }
>>> finally {
>>> if (statement != null)
>>> try {
>>> statement.close();
>>> } catch (Exception e) {}
>>> if (conn != null)
>>> try {
>>> conn.close();
>>> } catch (Exception e) {}
>>> }
>>> Map resultMap = ServiceUtil.returnSuccess();
>>> resultMap.put("seqValue", seqValue);
>>> return resultMap;
>>> }
>>> }
>>>
>>> Note that by using SQL Views/Stored Procedures you are limiting the 
>>> portability of your application to other databases.
>>>
>>> Cheers,
>>>
>>> Chris
>>>
>>> su2 wrote:
>>> 
 Hello Friends,

 I need to write quite complex query which is little easier to write as
 Stored Procedures. So I would like to know whether is it possible to
 write
 and access stored procedures in OFBiz with mySQL?

 If its possible, can i have example or reference for how to do that ?

 Thank you for the help in advance.

 Su-
  

Re: contactus form - partytoid is null.

[aswath narayana]

Yes, thats correct. we can see in Applications-> Party -> Communications.
 I am understanding the following
* to which emailid the email is sent out

I looked more into the details of services like
createCommunicationEvent, sendEmailDated and verifying database rows, I am
thinking that this functionality is broken and not functioning.

-Aswath

On Tue, Oct 6, 2009 at 4:28 PM, MarioF  wrote:

>
> I am not an expert but I saw that the admin can see this communications in:
> Applications-> Party -> Communications.
>
> I hope this help.
>
>
>
>
> aswath wrote:
> >
> > Any pointers for this...
> >
> > Seems like a bug to me.
> >
> > Thanks
> > -Aswath
> >
> > On Mon, Oct 5, 2009 at 4:18 PM, aswath narayana
> > wrote:
> >
> >> Hello All,
> >> In the ecommerce store, I click on the 'contact us' link and then goes
> >> the
> >> contactus form.
> >> After submitting the form, the request is 'contactus'.
> >> After tracing through the contactus, the flow ends up in
> >> 'createCommunicationEvent'.
> >> I looked at the communicationEvent table and 'partyto' is null.
> >>
> >> which email address recieves the email when the contactus form is
> >> submitted.  Where is it configured?
> >>
> >> Regards
> >> -Aswath
> >>
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/contactus-form---partytoid-is-null.-tp25748618p25766612.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>

Re: is Stroed Procedures possible in OFBiz?

[Mridul Pathak]

Shuchi,

One way is to define a view entity, in your component's entity-model.xml
using  tag.  You can use
 child tags for your summing
requirement.  This view will also be accessible in webtools.  In your code
you can then use delegator methods to retrieve the list from this view
entity.
-- 
Thanks & Regards
Mridul Pathak
Hotwax Media
http://www.hotwaxmedia.com
mridul.pat...@hotwaxmedia.com
-
direct: +91 - 942.592.6892


On Tue, Oct 6, 2009 at 7:14 PM, su2  wrote:

>
> Hi Chris,
>
> Thank you for the response.
>
> My query has multiple joins with different tables and also I would like to
> use sum(column name) and (column 1 + column 2) as column 3.
>
> Is it possible to use sum(column name) in java method with delegator?
>
> Also, the stored procedure I want to use in jasper report.
>
> Thank you for the help.
> Su-
>
>
> Chris Snow-3 wrote:
> >
> > Hi Su,
> >
> > I use SQL Views for complex queries:
> >
> >  > table-name="vClearanceReport"
> > package-name="uk.co.dhales"
> > title="Clearance Report Entity"
> > no-auto-stamp="true"
> > never-cache="true"
> > >
> >  > type="long-varchar"/>
> >  > type="long-varchar"/>
> >  > type="long-varchar"/>
> >  > type="numeric"/>
> > ...
> > 
> > 
> >
> > The table name vClearanceReport is actually a SQL View. The attributes
> > no-auto-stamp and never-cache where needed.
> >
> > Also, here is a service that is using a SQL Stored procedure:
> >
> > public class DHSequenceService {
> >
> > public static Map getNextSequenceValue(DispatchContext ctx, Map
> > context) {
> > Connection conn = null;
> > CallableStatement statement = null;
> >
> > String sql = "{call getNextSequenceValue(?,?)}";
> >
> > Long seqValue;
> > try{
> > conn = ConnectionFactory.getConnection("dhmssql");
> > if (conn == null) {
> > throw new Exception("No dhmssql connection
> > configured");
> > }
> > statement = conn.prepareCall (sql);
> > String seqTable = (String)context.get("seqTable");
> >
> > statement.registerOutParameter(1, Types.INTEGER);
> > statement.setString(2,  seqTable);
> > statement.execute();
> > seqValue = new Long(statement.getLong(1));
> > statement.close();
> > } catch (Exception e){
> > Debug.logError(e, "Error running SQL - ",
> > DHSequenceService.class.getName());
> > return ServiceUtil.returnError("Error running SQL" + e);
> > }
> > finally {
> > if (statement != null)
> > try {
> > statement.close();
> > } catch (Exception e) {}
> > if (conn != null)
> > try {
> > conn.close();
> > } catch (Exception e) {}
> > }
> > Map resultMap = ServiceUtil.returnSuccess();
> > resultMap.put("seqValue", seqValue);
> > return resultMap;
> > }
> > }
> >
> > Note that by using SQL Views/Stored Procedures you are limiting the
> > portability of your application to other databases.
> >
> > Cheers,
> >
> > Chris
> >
> > su2 wrote:
> >> Hello Friends,
> >>
> >> I need to write quite complex query which is little easier to write as
> >> Stored Procedures. So I would like to know whether is it possible to
> >> write
> >> and access stored procedures in OFBiz with mySQL?
> >>
> >> If its possible, can i have example or reference for how to do that ?
> >>
> >> Thank you for the help in advance.
> >>
> >> Su-
> >>
> >
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/is-Stroed-Procedures-possible-in-OFBiz--tp25768161p25768992.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>

Re: is Stroed Procedures possible in OFBiz?

[Chris Snow]

Hi Su,  how are you using the returned data? Is it a table list, or just 
a single form?


If it is a list, do you want to display just the aggregated (summed) 
values, or do you want to display the detail (unsummed) records too?


su2 wrote:

Hi Chris,

Thank you for the response.

My query has multiple joins with different tables and also I would like to
use sum(column name) and (column 1 + column 2) as column 3.

Is it possible to use sum(column name) in java method with delegator?

Also, the stored procedure I want to use in jasper report.

Thank you for the help.
Su-


Chris Snow-3 wrote:
  

Hi Su,

I use SQL Views for complex queries:

never-cache="true"   
>
type="long-varchar"/>
type="long-varchar"/>



...



The table name vClearanceReport is actually a SQL View. The attributes 
no-auto-stamp and never-cache where needed.


Also, here is a service that is using a SQL Stored procedure:

public class DHSequenceService {
   
public static Map getNextSequenceValue(DispatchContext ctx, Map 
context) {

Connection conn = null;
CallableStatement statement = null;
  
String sql = "{call getNextSequenceValue(?,?)}";
   
Long seqValue;

try{
conn = ConnectionFactory.getConnection("dhmssql");
if (conn == null) {
throw new Exception("No dhmssql connection 
configured");

}
statement = conn.prepareCall (sql);
String seqTable = (String)context.get("seqTable");

statement.registerOutParameter(1, Types.INTEGER);
statement.setString(2,  seqTable);
statement.execute();
seqValue = new Long(statement.getLong(1));
statement.close();
} catch (Exception e){
Debug.logError(e, "Error running SQL - ", 
DHSequenceService.class.getName());

return ServiceUtil.returnError("Error running SQL" + e);
}
finally {
if (statement != null)
try {
statement.close();
} catch (Exception e) {}
if (conn != null)
try {
conn.close();
} catch (Exception e) {}
}
Map resultMap = ServiceUtil.returnSuccess();
resultMap.put("seqValue", seqValue);
return resultMap;
}
}

Note that by using SQL Views/Stored Procedures you are limiting the 
portability of your application to other databases.


Cheers,

Chris

su2 wrote:


Hello Friends,

I need to write quite complex query which is little easier to write as
Stored Procedures. So I would like to know whether is it possible to
write
and access stored procedures in OFBiz with mySQL?

If its possible, can i have example or reference for how to do that ?

Thank you for the help in advance.

Su-
  
  





  

encrypted entity data is insecure?

[Chris Snow]

It looks as though no salt data is used when saving encrypted entity 
data making the stored data susceptible to dictionary attacks, for 
details see:


http://en.wikipedia.org/wiki/Salt_(cryptography)

Re: is Stroed Procedures possible in OFBiz?

[su2]

Hi Chris,

Thank you for the response.

My query has multiple joins with different tables and also I would like to
use sum(column name) and (column 1 + column 2) as column 3.

Is it possible to use sum(column name) in java method with delegator?

Also, the stored procedure I want to use in jasper report.

Thank you for the help.
Su-


Chris Snow-3 wrote:
> 
> Hi Su,
> 
> I use SQL Views for complex queries:
> 
>  table-name="vClearanceReport"
> package-name="uk.co.dhales"
> title="Clearance Report Entity"
> no-auto-stamp="true"
> never-cache="true"   
> >
>  type="long-varchar"/>
>  type="long-varchar"/>
>  type="long-varchar"/>
>  type="numeric"/>
> ...
> 
> 
> 
> The table name vClearanceReport is actually a SQL View. The attributes 
> no-auto-stamp and never-cache where needed.
> 
> Also, here is a service that is using a SQL Stored procedure:
> 
> public class DHSequenceService {
>
> public static Map getNextSequenceValue(DispatchContext ctx, Map 
> context) {
> Connection conn = null;
> CallableStatement statement = null;
>   
> String sql = "{call getNextSequenceValue(?,?)}";
>
> Long seqValue;
> try{
> conn = ConnectionFactory.getConnection("dhmssql");
> if (conn == null) {
> throw new Exception("No dhmssql connection 
> configured");
> }
> statement = conn.prepareCall (sql);
> String seqTable = (String)context.get("seqTable");
> 
> statement.registerOutParameter(1, Types.INTEGER);
> statement.setString(2,  seqTable);
> statement.execute();
> seqValue = new Long(statement.getLong(1));
> statement.close();
> } catch (Exception e){
> Debug.logError(e, "Error running SQL - ", 
> DHSequenceService.class.getName());
> return ServiceUtil.returnError("Error running SQL" + e);
> }
> finally {
> if (statement != null)
> try {
> statement.close();
> } catch (Exception e) {}
> if (conn != null)
> try {
> conn.close();
> } catch (Exception e) {}
> }
> Map resultMap = ServiceUtil.returnSuccess();
> resultMap.put("seqValue", seqValue);
> return resultMap;
> }
> }
> 
> Note that by using SQL Views/Stored Procedures you are limiting the 
> portability of your application to other databases.
> 
> Cheers,
> 
> Chris
> 
> su2 wrote:
>> Hello Friends,
>>
>> I need to write quite complex query which is little easier to write as
>> Stored Procedures. So I would like to know whether is it possible to
>> write
>> and access stored procedures in OFBiz with mySQL?
>>
>> If its possible, can i have example or reference for how to do that ?
>>
>> Thank you for the help in advance.
>>
>> Su-
>>   
> 
> 
> 

-- 
View this message in context: 
http://www.nabble.com/is-Stroed-Procedures-possible-in-OFBiz--tp25768161p25768992.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: is Stroed Procedures possible in OFBiz?

[Chris Snow]

Hi Su,

I use SQL Views for complex queries:

  never-cache="true"   
   >
   type="long-varchar"/>
   type="long-varchar"/>

   
   
   ...
   
   

The table name vClearanceReport is actually a SQL View. The attributes 
no-auto-stamp and never-cache where needed.


Also, here is a service that is using a SQL Stored procedure:

public class DHSequenceService {
  
   public static Map getNextSequenceValue(DispatchContext ctx, Map 
context) {

   Connection conn = null;
   CallableStatement statement = null;
 
   String sql = "{call getNextSequenceValue(?,?)}";
  
   Long seqValue;

   try{
   conn = ConnectionFactory.getConnection("dhmssql");
   if (conn == null) {
   throw new Exception("No dhmssql connection 
configured");

   }
   statement = conn.prepareCall (sql);
   String seqTable = (String)context.get("seqTable");

   statement.registerOutParameter(1, Types.INTEGER);
   statement.setString(2,  seqTable);
   statement.execute();
   seqValue = new Long(statement.getLong(1));
   statement.close();
   } catch (Exception e){
   Debug.logError(e, "Error running SQL - ", 
DHSequenceService.class.getName());

   return ServiceUtil.returnError("Error running SQL" + e);
   }
   finally {
   if (statement != null)
   try {
   statement.close();
   } catch (Exception e) {}
   if (conn != null)
   try {
   conn.close();
   } catch (Exception e) {}
   }
   Map resultMap = ServiceUtil.returnSuccess();
   resultMap.put("seqValue", seqValue);
   return resultMap;
   }
}

Note that by using SQL Views/Stored Procedures you are limiting the 
portability of your application to other databases.


Cheers,

Chris

su2 wrote:

Hello Friends,

I need to write quite complex query which is little easier to write as
Stored Procedures. So I would like to know whether is it possible to write
and access stored procedures in OFBiz with mySQL?

If its possible, can i have example or reference for how to do that ?

Thank you for the help in advance.

Su-
  

Re: Menu persmissions

[ARays]

Hi, 

I am looking for a similar functionality to control visibility of menu items
based on role. For example would like to *not* show menu items such as
"viewvendor" for party with Employee role in PartyMenu.xml. Can someone
point me to example code on how this can be done? 

- Arays



Adrian Crum wrote:
> 
> There is some code to control menus based upon permissions in the
> component's 
> app header ftl file.
> 
> On our custom components, ALL menu items are controlled by permissions.
> 
> 
> Chris Juettner wrote:
>> Is it possible to enable/disable menu items based on security groups
>> and/or user roles?  I see some reference to permissions in the menu
>> widget XSD, but I can't find any use of them to see if this is what I
>> need.
>>
>>   Thanks
>>
>>   Chris Juettner
>>   Integral Business Solutions
>>
>> 
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Menu-persmissions-tp6083780p25768675.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

is Stroed Procedures possible in OFBiz?

[su2]

Hello Friends,

I need to write quite complex query which is little easier to write as
Stored Procedures. So I would like to know whether is it possible to write
and access stored procedures in OFBiz with mySQL?

If its possible, can i have example or reference for how to do that ?

Thank you for the help in advance.

Su-
-- 
View this message in context: 
http://www.nabble.com/is-Stroed-Procedures-possible-in-OFBiz--tp25768161p25768161.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

RE: OFBiz installation tutorial???

[Dan Dodd]

MavrickIT, 
I'll put together a note on how to download and build OFBiz on an
existing ubuntu server if that would work for you.

Dan Dodd

IHOP-KC
dand...@ihop.org 

-Original Message-
From: Ruth Hoffman [mailto:rhoff...@aesolves.com] 
Sent: Monday, October 05, 2009 9:39 PM
To: user@ofbiz.apache.org
Subject: Re: Ofbiz installation tutorial???

Hi MavrickIT:
How about not using "wget" and use the download button from the Wiki. As

for version, I suggest the one pointed to by the download button. Beyond

that, I can't help you.
Regards,
Ruth

MavrickIT wrote:
> Hey Hoffman,
> Thanks for the solid solution. But I am stuck in again.
> $wget http://build.ofbiz.org/ofbiz-trunk-current.zip or
> $wget http://build.ofbiz.org/ofbiz-rel9.04-current.zip
> typing those commands ofbiz.zip is not downloaded anyway. 
> so, have no idea of downloading it. What should be the command
exactly. even
> I tried lw-download something like this. Not working.
> I find an error 404 not found. like the page cannot be found in any
browser
> we see. 404 error means the same.
> So.. please help me.
> Thanks
>
>
>
>
> Ruth Hoffman-2 wrote:
>   
>> Hello MavrickIT:
>> IMHO, take baby steps: Start by downloading a "zip'd" version from
the 
>> wiki, http://build.ofbiz.org and not the Subversion (SVN) package.
The 
>> instructions regarding which download is appropriate given your 
>> situation are confusing at best. I prefer to keep it simple when
getting 
>> started. A little excerpt from my recent book:
>>
>> Currently, if you visit the OFBiz site and decide to download a
>> version,
>> you have several options. The easiest thing to do is follow the
big
>> download button and get the "nightly build". This is a
prepackaged
>> version
>> ready to unzip and run. Nightly builds contain everything
necessary to
>> execute the demonstrations discussed in this book. They also
contain
>> all
>> the source code and other artifacts including build scripts that
are
>> used to
>> create the nightly builds. In other words, you get "all that and
the
>> source
>> too"! 
>>
>> You won't need Tomcat, SVN or Ant to download a nightly build and get
up 
>> and running quickly. Simply, create the directory you wish to run
OFBiz 
>> in (make sure that Java is on the classpath while working in this 
>> directory), change to that directory, unzip your file there and
startup 
>> OFBiz. For example:
>>
>> 1) Create a directory such as /home/ofbiz
>> 2) Download the zip file to your new directory. You will have
something 
>> that looks like this: /home/ofbiz/ofbizdownload.zip
>> 3) Unzip your file using something like gzip (Not sure what the
Ubuntu 
>> unzip command is.)
>> 4) Move to the unzipped file location doing something like: cd  
>> /home/ofbiz/ofbizdownload
>> 4) Run the Unix OFBiz invocation script that comes with the 
>> distribution: ./startofbiz.sh
>> 5) Navigate to the ecommerce startup page
http://localhost:8080/ecommerce
>> 6) Observe that you see the ecommerce landing page
>>
>> Once you understand what you've got out-of-the-box and you are ready
to 
>> do some development work, then consider downloading from SVN.
>>
>> Regards,
>> Ruth Hoffman
>> http://www.myofbiz.com
>>
>> MavrickIT wrote:
>> 
>>> Thanks Patel for trying to help me out. I have gone through the
links
>>> already
>>> that you gave me. Thing is, I already installed JRE6, full SDK, and
>>> tomcat,
>>> SVN, ANT etc. These were installed in root by default.
>>> I created folder /home/ofbiz. So, there is nothing inside
...home/ofbiz$
>>> I performed svn co http://svn.apache..
>>> Even I tried svn co http://../ofbiz9+ and svn co
>>> http:///ofbiz4.0
>>>
>>> So, how could I download ofbiz or even extract it, I don't know.
Even,
>>> from
>>> where to download it?
>>> Some google sites say, to download ofbiz separately and extract it
to
>>> /home/ofbiz user. Somewhere
>>> (http://docs.ofbiz.org/display/OFBADMIN/Demo+and+Test+Setup+Guide)
it's
>>> shown that, "OFBiz with embedded Tomcat". 
>>> I can't find any exact solution. I am yet confused what should I
type @
>>> the
>>> terminal for installing Ofbiz from the beginning. 
>>> Waiting for any suitable reply.:-(
>>> Thank you.
>>>
>>>
>>>
>>> Anil Patel-3 wrote:
>>>   
>>>   
 Hi,

 For quick setup use
 http://docs.ofbiz.org/display/OFBADMIN/Demo+and+Test+Setup+Guide

 Please see following documents to setup development/staging
environment.


http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+
Setup+Guide

http://docs.ofbiz.org/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Gui
de


 Regards
 Anil patel


 On Oct 2, 2009, at 12:34 PM, MavrickIT wrote:

 
 
> Can anybody help me out for Ofbiz installation guide [step by step

> command
> lines] from the Terminal (Ububntu)?
>
> I've been facing lots trouble about it. Pl

Re: LDAP

[Pierre Smits]

Thanks,
That did the trick.

Regards,

Pierre

2009/10/6 Scott Gray 

> Hi Pierre
>
> There a few notes listed here:
> http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide
> Under security settings.
>
> Regards
> Scott
>
> HotWax Media
> http://www.hotwaxmedia.com
>
>
> On 6/10/2009, at 10:57 PM, Pierre Smits wrote:
>
>  Hi All,
>> Is there a functionality in OfBIZ available to have the user authenticate
>> against LDAP (eg ApacheDS)?
>>
>> Regards,
>>
>> Pierre
>>
>
>

Localization for Indonesia - OFBiz

[naveen chanda]

Dear All,


I would like to make the OFBiz application for Indonesia, could any one
explain the steps to change the Locale to Indoensia.

I have checked and followed this document, but i cannot able to find any
changes.

http://docs.ofbiz.org/display/OFBTECH/Calendars%2C+Dates%2C+and+Times

I mean to say, that the date, calendar, timestamp must be changed
accordingly.

Please help me on this.


Thanks,
Naveen Chanda
-- 
View this message in context: 
http://www.nabble.com/Localization-for-Indonesia---OFBiz-tp25766809p25766809.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: contactus form - partytoid is null.

[MarioF]

I am not an expert but I saw that the admin can see this communications in:
Applications-> Party -> Communications.

I hope this help.




aswath wrote:
> 
> Any pointers for this...
> 
> Seems like a bug to me.
> 
> Thanks
> -Aswath
> 
> On Mon, Oct 5, 2009 at 4:18 PM, aswath narayana
> wrote:
> 
>> Hello All,
>> In the ecommerce store, I click on the 'contact us' link and then goes
>> the
>> contactus form.
>> After submitting the form, the request is 'contactus'.
>> After tracing through the contactus, the flow ends up in
>> 'createCommunicationEvent'.
>> I looked at the communicationEvent table and 'partyto' is null.
>>
>> which email address recieves the email when the contactus form is
>> submitted.  Where is it configured?
>>
>> Regards
>> -Aswath
>>
> 
> 

-- 
View this message in context: 
http://www.nabble.com/contactus-form---partytoid-is-null.-tp25748618p25766612.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: LDAP

[Scott Gray]

Hi Pierre

There a few notes listed here: 
http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide
Under security settings.

Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 6/10/2009, at 10:57 PM, Pierre Smits wrote:


Hi All,
Is there a functionality in OfBIZ available to have the user  
authenticate

against LDAP (eg ApacheDS)?

Regards,

Pierre




smime.p7s
Description: S/MIME cryptographic signature

Re: contactus form - partytoid is null.

[aswath narayana]

Any pointers for this...

Seems like a bug to me.

Thanks
-Aswath

On Mon, Oct 5, 2009 at 4:18 PM, aswath narayana
wrote:

> Hello All,
> In the ecommerce store, I click on the 'contact us' link and then goes the
> contactus form.
> After submitting the form, the request is 'contactus'.
> After tracing through the contactus, the flow ends up in
> 'createCommunicationEvent'.
> I looked at the communicationEvent table and 'partyto' is null.
>
> which email address recieves the email when the contactus form is
> submitted.  Where is it configured?
>
> Regards
> -Aswath
>

LDAP

[Pierre Smits]

Hi All,
Is there a functionality in OfBIZ available to have the user authenticate
against LDAP (eg ApacheDS)?

Regards,

Pierre