Thanks,
I like this solution better than the trigger solution mentioned before. But
still it's not really what I want.
OfBiz should adopt to the database and not vice-versa. If you look at
persistent frameworks like
hibernate, toplink, etc or driver classes (PreparedStatement's) they all
working with every database without changing database settings!
Michael
PS: What's wrong with you're message format. Looks like you have no line
wrapping??
sashash77 wrote:
>
>
> If you run below statement no need for to_date wrap:ALTER SYSTEM set
> NLS_TIMESTAMP_FORMAT='RRRR-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 for this ? 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]>> À :
> <user@ofbiz.apache.org>> Envoyé : mardi 15 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 hibernate is using. In> > hibernate you
> have to define> > in a xml file wich dialect you're using. We don't have
> this> definition, but> > I'm using the drivername> > declared in the
> entityengine.xml to find the dialect to use.> >> > In GenericDAO I read
> the corresponding dialect instance and every> value is> > passed through
> this dialect> > instance (every dialect implements a method
> "toSqlString(Object> value)").> > The where string values are build in the
> SqlJdbcUtil class, so that's> the> > point where I finally use my> >
> dialect class.> > If you look at SqlJdbcUtil.addValueSingle(..):> >
> buffer.append('\'').append(value).append('\'');> > is now:> >
> Object sqlValue = value;> > if (dialect != null) {> >
>
> sqlValue = dialect.toSqlString(value);> > }> >
> buffer.append(sqlValue);> > The instance dialect is passed as a parameter
> to the method. At the> moment I> > only implemented a> > OracleDialect
> class. All the other drivers are using the default> dialect> > wich is
> returning:> > return '\'' +value '\'';> >> > Seems to work fine...>
> > Michael> >> >> > Jacopo Cappellato wrote:> > >> > > 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 client server with
> Oracle database> I got> > >> exceptions with> > >> the sandbox:> > >>
> "ORA-01861: literal does not match format string"> > >>> > >> This is a
> problem with the date conversion.> > >> On MySql, the following SQL
> Statement is used> > >> SELECT .... WHERE RUN_TIME <= '2007-05-15
> 07:45:10.875'> AND ....> > >> Using an Oracle database, this statement is
> wrong and generates the> > >> ORA-01861 error.> > >> The statement should
> look like this:> > >> SELECT .... WHERE RUN_TIME <=
> TO_DATE('2007-05-15> 07:45:10',> > >> 'YYYY-MM-DD HH:MI:SS') AND ....> >
> >>> > >> It works fine if the query is generated with the
> PreparedStatement> of the> > >> driver.> > >> But why the hell is this not
> always the case???> > >>> > >> The call of> > >>
> delegator.storeByCondition("JobSandbox", updateFields,> > >>
> 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.>
> _________________________________________________________________
> Change is good. See what’s different about Windows Live Hotmail.
> www.windowslive-hotmail.com/learnmore/default.html?locale=en-us&ocid=TXT_TAGLM_HMWL_reten_changegood_0507
>
--
View this message in context:
http://www.nabble.com/Problems-with-Oracle-Database-tf3756432.html#a10713872
Sent from the OFBiz - User mailing list archive at Nabble.com.
