Problems with Oracle Database

2007-05-14 Thread Michael Imhof
design!). -- View this message in context: http://www.nabble.com/Problems-with-Oracle-Database-tf3756432.html#a10616881 Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: Problems with Oracle Database

2007-05-14 Thread Jacopo Cappellato
Michael, have a look at these notes: http://docs.ofbiz.org/x/gAI let me know if they help you and if you have additional suggestions for OFBiz&Oracle Jacopo Michael Imhof wrote: We developed our OfBiz application on a mysql database and all works fine. Deploying the application on the clie

Re: Problems with Oracle Database

2007-05-15 Thread Michael Imhof
ateFields, >> mainCondition); >> is creating a where statement BY HAND!!! (And of course this statement is >> not generic and does not >> work with a oracle database). >> >> Michael >> >> PS: Probably I will fix this in my ofbiz version, but that will be a big >> redesign (I don't think I can create a patch >> out of this. It's a redesign!). > > > > -- View this message in context: http://www.nabble.com/Problems-with-Oracle-Database-tf3756432.html#a10618443 Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: Problems with Oracle Database

2007-05-17 Thread Jacques Le Roux
mai 2007 10:05 Objet : Re: Problems with Oracle Database > > Hi Jacopo, > I saw this note before, but I don't want to install a trigger on the client > database. I would like > to fix the cause and not the problem!! > > I implemented a solution based on the design hibern

RE: Problems with Oracle Database

2007-05-17 Thread Alex Shevchuk
If you run below statement no need for to_date wrap:ALTER SYSTEM set NLS_TIMESTAMP_FORMAT='-MM-DD HH24:MI:SS.FF' SCOPE = SPFILEAlex> Date: Fri, 18 May 2007 00:24:03 +0200> From: [EMAIL PROTECTED]> Subject: Re: Problems with Oracle Database> To: user@ofbiz.apache.or

Re: Problems with Oracle Database

2007-05-20 Thread Michael Imhof
It does not > mean that it will be commited but at least the idea will be there, > opened to everybody... > > Jacques > > - Message d'origine - > De : "Michael Imhof" <[EMAIL PROTECTED]> > À : > Envoyé : mardi 15 mai 2007 10:05 > Objet : Re

RE: Problems with Oracle Database

2007-05-20 Thread Michael Imhof
FORMAT='-MM-DD HH24:MI:SS.FF' SCOPE = SPFILEAlex> Date: > Fri, 18 May 2007 00:24:03 +0200> From: [EMAIL PROTECTED]> > Subject: Re: Problems with Oracle Database> To: user@ofbiz.apache.org> > > Michael,> > Would you be interested by contributing a patch fo