OFBIZ __ PostgreSQL
Hi, I'm looking for some help about migrating from ofbiz derby database to postgresql database, and also how to create and set data directly from postgresql without having to pass by derby. According to tutorials that I have, I can't find how they get connected to another database (postgres in my case) and defining entities there, and keep developing the application. P.S : * I'm using Eclipse IDE * I'm just a beginner in ofbiz so I have just few knowledge about the OFBiz environement. Thank you for you help :) -- View this message in context: http://ofbiz.135035.n4.nabble.com/OFBIZ-PostgreSQL-tp4632713.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: OFBIZ __ PostgreSQL
Hello, Take back up of your derby database and import it into postgresql database after tis installation. For migrating from derby database to postgresql database open framework/entity/config/entityengine.xml and do the following changes in datasource-name field: entity-group-reader="main" entity-eca-reader="main" distributed-cache-clear-enabled="false"> entity-group-reader="main" entity-eca-reader="main" entity-eca-enabled="false" distributed-cache-clear- enabled="false"> datasource-name="localderbytenant"/> Enter jdbc-username and jdbc-password of postgres database here: and then open the console, browse to ofbiz folder and run this command: ant download-PG-JDBC I think this information help you. Thank you. Regards Arun Kumar Batham HotWax Media, Est. 1997 http://www.hotwaxmedia.com/ On Tuesday 29 May 2012 06:41 PM, G.Ben wrote: Hi, I'm looking for some help about migrating from ofbiz derby database to postgresql database, and also how to create and set data directly from postgresql without having to pass by derby. According to tutorials that I have, I can't find how they get connected to another database (postgres in my case) and defining entities there, and keep developing the application. P.S : * I'm using Eclipse IDE * I'm just a beginner in ofbiz so I have just few knowledge about the OFBiz environement. Thank you for you help :) -- View this message in context: http://ofbiz.135035.n4.nabble.com/OFBIZ-PostgreSQL-tp4632713.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: OFBIZ __ PostgreSQL
This FAQ https://cwiki.apache.org/confluence/display/OFBIZ/How+to+migrate+OfBiz+from+Derby+to+MySQL+database should help. Simply ignore *references & changes related to MySQL*, instead execute postgres datasource configuration steps provided by Arun Kumar Batham. On Tue, May 29, 2012 at 7:13 PM, Arun Kumar Batham < arun.bat...@hotwaxmedia.com> wrote: > Hello, > > Take back up of your derby database and import it into postgresql database > after tis installation. > > For migrating from derby database to postgresql database open > framework/entity/config/**entityengine.xml and > do the following changes in datasource-name field: > > entity-group-reader="main" entity-eca-reader="main" distributed-cache-clear- > **enabled="false"> > > > > entity-group-reader="main" entity-eca-reader="main" > entity-eca-enabled="false" distributed-cache-clear- enabled="false"> > > > > > > Enter jdbc-username and jdbc-password of postgres database here: > > helper-class="org.ofbiz.**entity.datasource.**GenericHelperDAO" >schema-name="public" >field-type-name="postgres" >check-on-start="true" >add-missing-on-start="true" >use-fk-initially-deferred="**false" > > > > > > jdbc-driver="org.postgresql.**Driver" > > jdbc-uri="jdbc:postgresql://12**7.0.0.1/trunk<http://127.0.0.1/trunk> > " >jdbc-username="Your postgres Database User Name" >jdbc-password="Your postgres Database Password" >time-between-eviction-runs-**millis="60"/> > > > and then open the console, browse to ofbiz folder and run this command: > > ant download-PG-JDBC > > I think this information help you. > > Thank you. > > Regards > Arun Kumar Batham > HotWax Media, Est. 1997 > http://www.hotwaxmedia.com/ > > > > On Tuesday 29 May 2012 06:41 PM, G.Ben wrote: > >> Hi, >> >> I'm looking for some help about migrating from ofbiz derby database to >> postgresql database, and also how to create and set data directly from >> postgresql without having to pass by derby. >> According to tutorials that I have, I can't find how they get connected to >> another database (postgres in my case) and defining entities there, and >> keep >> developing the application. >> >> P.S : * I'm using Eclipse IDE >>* I'm just a beginner in ofbiz so I have just few knowledge about >> the >> OFBiz environement. >> >> Thank you for you help :) >> >> -- >> View this message in context: http://ofbiz.135035.n4.nabble.** >> com/OFBIZ-PostgreSQL-**tp4632713.html<http://ofbiz.135035.n4.nabble.com/OFBIZ-PostgreSQL-tp4632713.html> >> Sent from the OFBiz - User mailing list archive at Nabble.com. >> > -- Regards, Varun Bhansaly
Re: OFBIZ __ PostgreSQL
Hello Arun Kumar Batham, I followed the steps but however ... I get errors at the console http://ofbiz.135035.n4.nabble.com/file/n4632791/postgres.png Thank you for your help. -- View this message in context: http://ofbiz.135035.n4.nabble.com/OFBIZ-PostgreSQL-tp4632713p4632791.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: OFBIZ __ PostgreSQL
I've already tried this website http://www.toivari.com/devblog/page/2/ http://www.toivari.com/devblog/page/2/ and I've just had 852 tables for the ofbie database and 0 tables for ofbizolap and ofbiztenant databse. Now when I checked entityengine.xml I've noticed that it has been changed -_-" So I followed your steps above and that was the error message that I've got. -- View this message in context: http://ofbiz.135035.n4.nabble.com/OFBIZ-PostgreSQL-tp4632713p4632793.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: OFBIZ __ PostgreSQL
Hello G. Ben, Please apply this steps: Open your Command prompt, Browse to your ofbiz directory and run this command: ant download-PG-JDBC I think this information help you. Thank you. Regards Arun Kumar Batham HotWax Media, Est. 1997 http://www.hotwaxmedia.com/ On Wednesday 30 May 2012 08:45 PM, G.Ben wrote: I've already tried this website http://www.toivari.com/devblog/page/2/ http://www.toivari.com/devblog/page/2/ and I've just had 852 tables for the ofbie database and 0 tables for ofbizolap and ofbiztenant databse. Now when I checked entityengine.xml I've noticed that it has been changed -_-" So I followed your steps above and that was the error message that I've got. -- View this message in context: http://ofbiz.135035.n4.nabble.com/OFBIZ-PostgreSQL-tp4632713p4632793.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: OFBIZ __ PostgreSQL
Hello Ben, Hello, For migrating from derby database to postgresql database open framework/entity/config/entityengine.xml and do the following changes in datasource-name field: Enter jdbc-username and jdbc-password of postgres database here: and then after put the jar of postgresql-8.0-311.jdbc2.jar in the path framework/entity/lib/jdbc after this go to commond prompt and write the commond ant run-istall after complitoin of this write the command startofbiz.bat Go to browser and put the URL https://localhost:8443/humanres/control/main This process for window machin. I think this information help you. Thanks Dhiraj Gupta 09990220686 - dhirajgupta -- View this message in context: http://ofbiz.135035.n4.nabble.com/OFBIZ-PostgreSQL-tp4632713p4632822.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: OFBIZ __ PostgreSQL
Hi Arun Kumar Batham, I've already typed the command and above, you can see that build has failed ... Thank you. Regards. G.Ben -- View this message in context: http://ofbiz.135035.n4.nabble.com/OFBIZ-PostgreSQL-tp4632713p4632836.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: OFBIZ __ PostgreSQL
Hi Dhiraj Gupta, I will try the steps and see what I'll get. Thank you so much for your help. Regards. G.Ben. -- View this message in context: http://ofbiz.135035.n4.nabble.com/OFBIZ-PostgreSQL-tp4632713p4632837.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: OFBIZ __ PostgreSQL
In order to use postgresql do the following steps (Replace the example database names, database user and its password by your application specific names ) 1. Create a database in postgresql example myDbName 2. Create a database user ex dbUser identified by password ex dbPassword 3. Grant access to this dbUser on the database in this ex on myDbName 4. Create two more databases for olap and tenant ex olapDbName and tenantDbName . 5. Grant access to dbUser on these two databases also. Now after creating three databases and a db user change the framework/entity/config/entityengine.xml file I am attaching a sample http://ofbiz.135035.n4.nabble.com/file/n4632956/entityengine.xml entityengine.xml file with above mentioned databases and database user. have a look at the attached file and search for above mentioned example database names to see how to and where to change. After making above mentioned changes execute following commands. 1. Stop the ofbiz server if running. 2. Run ant download-PG-JDBC command 3. ant run-install. 4. startofbiz Regards Mohd Viqar G.Ben wrote > > Hi, > > I'm looking for some help about migrating from ofbiz derby database to > postgresql database, and also how to create and set data directly from > postgresql without having to pass by derby. > According to tutorials that I have, I can't find how they get connected to > another database (postgres in my case) and defining entities there, and > keep developing the application. > > P.S : * I'm using Eclipse IDE >* I'm just a beginner in ofbiz so I have just few knowledge about > the OFBiz environement. > > Thank you for you help :) > -- View this message in context: http://ofbiz.135035.n4.nabble.com/OFBIZ-PostgreSQL-tp4632713p4632956.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: OFBIZ __ PostgreSQL
Thank you all for your help, It worked finally. Regards. G.Ben. -- View this message in context: http://ofbiz.135035.n4.nabble.com/OFBIZ-PostgreSQL-tp4632713p4633195.html Sent from the OFBiz - User mailing list archive at Nabble.com.