Derby To MySQL

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|

Derby To MySQL

Divya Nair
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


Reply | Threaded
Open this post in threaded view
|

Re: Derby To MySQL

hans_bakker
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

Reply | Threaded
Open this post in threaded view
|

Re: Derby To MySQL

Divesh Dutta
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.

Reply | Threaded
Open this post in threaded view
|

Re: Derby To MySQL

Vivek Mishra-2
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:

> 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

Reply | Threaded
Open this post in threaded view
|

Re: Derby To MySQL

Divya Nair
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.
Reply | Threaded
Open this post in threaded view
|

Re: Derby To MySQL

Vivek Mishra-2
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.

Reply | Threaded
Open this post in threaded view
|

Re: Derby To MySQL

Sven Wesley
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.
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Derby To MySQL

Sven Wesley
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.
>>
>>
>
Reply | Threaded
Open this post in threaded view
|

Re: Derby To MySQL

BJ Freeman
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:

> 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
>
>
>