Re: How to config OFBiz works with Oracle database 11g express?

2017-06-28 Thread Rishi Solanki
_ > From: Donhu Vy > Sent: Wednesday, June 28, 2017 10:01:27 AM > To: user@ofbiz.apache.org > Subject: Re: How to config OFBiz works with Oracle database 11g express? > > > Thank Rishi Solanki, > > > I uninstall Oracle 11g, then install 12cR

Re: How to config OFBiz works with Oracle database 11g express?

2017-06-27 Thread Donhu Vy
I fix my mistake, new one become to: but still error. From: Donhu Vy Sent: Wednesday, June 28, 2017 10:01:27 AM To: user@ofbiz.apache.org Subject: Re: How to config OFBiz works with Oracle database 11g express? Thank Rishi Solanki, I

Re: How to config OFBiz works with Oracle database 11g express?

2017-06-27 Thread Donhu Vy
Subject: Re: How to config OFBiz works with Oracle database 11g express? You can use localoracle and ignore the other one. Note that it will have the jdbc driver mentioned as jdbc-driver="oracle.jdbc.driver.OracleDriver" also you need to put the oracle jar (compatible ojdbc jar) file

Re: How to config OFBiz works with Oracle database 11g express?

2017-06-21 Thread Rishi Solanki
int, and I don't know how to resolve problem. > > > If you have exiting config for Oracle database, can you give it to me? > > > Best regards, > > > Vy > >

How to config OFBiz works with Oracle database 11g express?

2017-06-20 Thread Donhu Vy
config for Oracle database, can you give it to me? Best regards, Vy

Trouble exporting PRODUCT_CATEGORY with CLOB data type attribute (Oracle Database)

2008-07-19 Thread Amine Benkirane
PRODUCT_CATEGORY_ID ASC (ORA-00932: types de données incohérents ; attendu : - ; obtenu : CLOB The Oracle error message, ORA-00932, are in french (since I'm using a french version of Oracle Database 10g : SQL Oracle Developer) but It means that the data type are incoherents. Date type '-' is wai

Oracle database

2007-09-11 Thread Vinod Kumar Kashyap
://www.nabble.com/Oracle-database-tf4421494.html#a12611439 Sent from the OFBiz - User mailing list archive at Nabble.com.

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

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-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-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-15 Thread Michael Imhof
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

Re: Problems with Oracle Database

2007-05-14 Thread Jacopo Cappellato
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.

Problems with Oracle Database

2007-05-14 Thread Michael Imhof
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