OFBiz › OFBiz - User

Derby To MySQL

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

9 messages Options

Divya Nair

Derby To MySQL

Hi All,

How can the default database of derby which comes with ofbiz be ported to mysql ?
This is for studying the database using ER tool....

Thanks in Advance...

Regards,
Divya

hans_bakker

Re: Derby To MySQL

You will be surprised!

The ER tool is build-in....go to webtools and then select 'entity
reference

enjoy!

Regards
Hans

On Sat, 2008-11-22 at 06:04 -0800, Divya Nair wrote:

> Hi All,
>
> How can the default database of derby which comes with ofbiz be ported to
> mysql ?
> This is for studying the database using ER tool....
>
> Thanks in Advance...
>
> Regards,
> Divya
>
>
>

--
Antwebsystems.com: Quality OFBiz services for competitive prices

Divesh Dutta

Re: Derby To MySQL

In reply to this post by Divya Nair

Hi Divya,
1)Go to framework/entity/config/entityengine.xml
2)Wherever its written datasource-name="localderby" ,you can change it to "localmysql".
3)Then go to settings of "locamysql"
4)Give jdbc-uri="jdbc:postgresql://127.0.0.1/db_name"
5)Give jdbc-username="user name of your system will come here"
jdbc-password=""(leave it blank)
6) And default database will be ported to mysql

Regards
Divesh Dutta

----- Original Message -----
From: "Divya Nair" <[hidden email]>
To: [hidden email]
Sent: Saturday, November 22, 2008 7:34:46 PM GMT +05:30 Chennai, Kolkata, Mumbai, New Delhi
Subject: Derby To MySQL

Hi All,

How can the default database of derby which comes with ofbiz be ported to
mysql ?
This is for studying the database using ER tool....

Thanks in Advance...

Regards,
Divya

--
View this message in context: http://www.nabble.com/Derby-To-MySQL-tp20636733p20636733.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Vivek Mishra-2

Re: Derby To MySQL

In reply to this post by hans_bakker

Hi Divya,
For this you need to do some changes in entityengine.xml file of OFBiz.

Kind Rigards,
--
Vivke Mishra
----- Original Message -----
From: "Hans Bakker" <[hidden email]>
To: [hidden email]
Sent: Saturday, November 22, 2008 7:46:01 PM GMT +05:30 Chennai, Kolkata, Mumbai, New Delhi
Subject: Re: Derby To MySQL

You will be surprised!

The ER tool is build-in....go to webtools and then select 'entity
reference

enjoy!

Regards
Hans

On Sat, 2008-11-22 at 06:04 -0800, Divya Nair wrote:

--
Antwebsystems.com: Quality OFBiz services for competitive prices

Divya Nair

Re: Derby To MySQL

In reply to this post by Divesh Dutta

Thank You so much....

Divesh Dutta wrote

Hi Divya,
1)Go to framework/entity/config/entityengine.xml
2)Wherever its written datasource-name="localderby" ,you can change it to "localmysql".
3)Then go to settings of "locamysql"
4)Give jdbc-uri="jdbc:postgresql://127.0.0.1/db_name"
5)Give jdbc-username="user name of your system will come here"
jdbc-password=""(leave it blank)
6) And default database will be ported to mysql

Regards
Divesh Dutta

----- Original Message -----
From: "Divya Nair" <divysn@gmail.com>
To: user@ofbiz.apache.org
Sent: Saturday, November 22, 2008 7:34:46 PM GMT +05:30 Chennai, Kolkata, Mumbai, New Delhi
Subject: Derby To MySQL

Hi All,

How can the default database of derby which comes with ofbiz be ported to
mysql ?
This is for studying the database using ER tool....

Thanks in Advance...

Regards,
Divya

--
View this message in context: http://www.nabble.com/Derby-To-MySQL-tp20636733p20636733.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Vivek Mishra-2

Re: Derby To MySQL

A bit amendment in line 4) " jdbc-uri="jdbc:mysql://127.0.0.1"

Kind Regards,
--
Vivek Mishra
----- Original Message -----
From: "Divya Nair" <[hidden email]>
To: [hidden email]
Sent: Saturday, November 22, 2008 8:09:17 PM GMT +05:30 Chennai, Kolkata, Mumbai, New Delhi
Subject: Re: Derby To MySQL

Thank You so much....

Divesh Dutta wrote:

>
> Hi Divya,
> 1)Go to framework/entity/config/entityengine.xml
> 2)Wherever its written datasource-name="localderby" ,you can
> change it to "localmysql".
> 3)Then go to settings of "locamysql"
> 4)Give jdbc-uri="jdbc:postgresql://127.0.0.1/db_name"
> 5)Give jdbc-username="user name of your system will come here"
> jdbc-password=""(leave it blank)
> 6) And default database will be ported to mysql
>
> Regards
> Divesh Dutta
>
>
> ----- Original Message -----
> From: "Divya Nair" <[hidden email]>
> To: [hidden email]
> Sent: Saturday, November 22, 2008 7:34:46 PM GMT +05:30 Chennai, Kolkata,
> Mumbai, New Delhi
> Subject: Derby To MySQL
>
>
> Hi All,
>
> How can the default database of derby which comes with ofbiz be ported to
> mysql ?
> This is for studying the database using ER tool....
>
> Thanks in Advance...
>
> Regards,
> Divya
>
>
>
> --
> View this message in context:
> http://www.nabble.com/Derby-To-MySQL-tp20636733p20636733.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>
>

--
View this message in context: http://www.nabble.com/Derby-To-MySQL-tp20636733p20637020.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Sven Wesley

Re: Derby To MySQL

Here's a well explained howto also.
http://friendfeed.s3.amazonaws.com/9578c31cabe457a801b23c9e2d3a5f047b983226

2008/11/22 Vivek Mishra <[hidden email]>

> A bit amendment in line 4) " jdbc-uri="jdbc:mysql://127.0.0.1"
>
> Kind Regards,
> --
> Vivek Mishra
> ----- Original Message -----
> From: "Divya Nair" <[hidden email]>
> To: [hidden email]
> Sent: Saturday, November 22, 2008 8:09:17 PM GMT +05:30 Chennai, Kolkata,
> Mumbai, New Delhi
> Subject: Re: Derby To MySQL
>
>
> Thank You so much....
>
> Divesh Dutta wrote:
> >
> > Hi Divya,
> > 1)Go to framework/entity/config/entityengine.xml
> > 2)Wherever its written datasource-name="localderby" ,you can
> > change it to "localmysql".
> > 3)Then go to settings of "locamysql"
> > 4)Give jdbc-uri="jdbc:postgresql://127.0.0.1/db_name"
> > 5)Give jdbc-username="user name of your system will come here"
> > jdbc-password=""(leave it blank)
> > 6) And default database will be ported to mysql
> >
> > Regards
> > Divesh Dutta
> >
> >
> > ----- Original Message -----
> > From: "Divya Nair" <[hidden email]>
> > To: [hidden email]
> > Sent: Saturday, November 22, 2008 7:34:46 PM GMT +05:30 Chennai, Kolkata,
> > Mumbai, New Delhi
> > Subject: Derby To MySQL
> >
> >
> > Hi All,
> >
> > How can the default database of derby which comes with ofbiz be ported to
> > mysql ?
> > This is for studying the database using ER tool....
> >
> > Thanks in Advance...
> >
> > Regards,
> > Divya
> >
> >
> >
> > --
> > View this message in context:
> > http://www.nabble.com/Derby-To-MySQL-tp20636733p20636733.html
> > Sent from the OFBiz - User mailing list archive at Nabble.com.
> >
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/Derby-To-MySQL-tp20636733p20637020.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>

Sven Wesley

Re: Derby To MySQL

Darn!!! Wrong URL in the copy buffer. :)
http://lj4newbies.blogspot.com/2008/06/setup-mysql-with-ofbiz.html

2008/11/22 Sven Wesley <[hidden email]>

> Here's a well explained howto also.
> http://friendfeed.s3.amazonaws.com/9578c31cabe457a801b23c9e2d3a5f047b983226
>
> 2008/11/22 Vivek Mishra <[hidden email]>
>
> A bit amendment in line 4) " jdbc-uri="jdbc:mysql://127.0.0.1"
>>
>> Kind Regards,
>> --
>> Vivek Mishra
>> ----- Original Message -----
>> From: "Divya Nair" <[hidden email]>
>> To: [hidden email]
>> Sent: Saturday, November 22, 2008 8:09:17 PM GMT +05:30 Chennai, Kolkata,
>> Mumbai, New Delhi
>> Subject: Re: Derby To MySQL
>>
>>
>> Thank You so much....
>>
>> Divesh Dutta wrote:
>> >
>> > Hi Divya,
>> > 1)Go to framework/entity/config/entityengine.xml
>> > 2)Wherever its written datasource-name="localderby" ,you can
>> > change it to "localmysql".
>> > 3)Then go to settings of "locamysql"
>> > 4)Give jdbc-uri="jdbc:postgresql://127.0.0.1/db_name"
>> > 5)Give jdbc-username="user name of your system will come here"
>> > jdbc-password=""(leave it blank)
>> > 6) And default database will be ported to mysql
>> >
>> > Regards
>> > Divesh Dutta
>> >
>> >
>> > ----- Original Message -----
>> > From: "Divya Nair" <[hidden email]>
>> > To: [hidden email]
>> > Sent: Saturday, November 22, 2008 7:34:46 PM GMT +05:30 Chennai,
>> Kolkata,
>> > Mumbai, New Delhi
>> > Subject: Derby To MySQL
>> >
>> >
>> > Hi All,
>> >
>> > How can the default database of derby which comes with ofbiz be ported
>> to
>> > mysql ?
>> > This is for studying the database using ER tool....
>> >
>> > Thanks in Advance...
>> >
>> > Regards,
>> > Divya
>> >
>> >
>> >
>> > --
>> > View this message in context:
>> > http://www.nabble.com/Derby-To-MySQL-tp20636733p20636733.html
>> > Sent from the OFBiz - User mailing list archive at Nabble.com.
>> >
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Derby-To-MySQL-tp20636733p20637020.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>
>

BJ Freeman

Re: Derby To MySQL

In reply to this post by Divya Nair

here is an explanation
http://ofbiz.apache.org/docs/entityconfig.html
if you look in the entityengine.xml
you will find the mysql you can replace the derby with.
you can export the derby with webtools then import once the mysql is
running, if you have more than the demo data.
other wise
just do
ant run-install.

Divya Nair sent the following on 11/22/2008 6:04 AM: