You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@roller.apache.org by Shen Hongzhou <sh...@gmail.com> on 2012/03/20 05:26:47 UTC
How to keep the data in Derby or change the developing DB to MySQL?
Hi everybody,
I'm new to Roller and I just ran the source code of Roller, everything
works fine. I created a new user and a new blog.
But when I stopped Roller and ran it again, all of newly created data
disappeared, there is no user and no blog. I guess maybe the Derby cleared
the old data when it was started.
So, I just want to know how to keep the old data when I restart the Roller?
Or, maybe I can use MySQL for developing, how can I change to MySQL?
This is my first time to user maven+jetty+Derby, I'm sorry for this kind of
"stupid" question.
Regards,
Hongzhou
Re: How to keep the data in Derby or change the developing DB to MySQL?
Posted by Shen Hongzhou <sh...@gmail.com>.
Anybody could help?
I just want to try some development work in my eclipse and avoiding add
user and blog every time I restart the Roller.
Thanks.
在 2012年3月20日 上午10:48，Shen Hongzhou <sh...@gmail.com>写道：
> Thank you.
>
> I have tried. I added the mysql dependency, and change the
> "roller-custom.properties" according to the install guide document.
> But now, I get the "reading/parsing database creation script" error. The
> mysql version is: 5.0.18
>
> If I can change some settings to avoid the lost of data in Derby, I think
> just using Derby will be better.
>
> Hongzhou
>
>
> 在 2012年3月20日 上午10:36，Tiger Gui <ti...@gmail.com>写道：
>
> You can get the details in Roller's install guide document. Use Mysql or
>> other Database to save your data, do not use the default Derby.
>>
>> 在 2012年3月20日 下午9:35，Tiger Gui <ti...@gmail.com>写道：
>>
>> > Hi,
>> >
>> > You can get the details in this guide in attach file
>> >
>> > 在 2012年3月20日 下午9:10，Shen Hongzhou <sh...@gmail.com>写道：
>> >
>> > Thank you, Dave.
>> >>
>> >> Actually, I would like to do some development things. I also think
>> Jetty
>> >> and Derby is convenient. But I don't know how to avoid the lost of data
>> >> when restart Roller. Maybe there are somewhere to set?
>> >>
>> >> Regards,
>> >> Hongzhou
>> >>
>> >>
>> >> Running Roller via the Maven build script and "mvn jetty:run" is only
>> >> meant
>> >> > for development. In development we use Jetty and Derby because they
>> are
>> >> > easy to setup an start from the Maven build script.
>> >> >
>> >> > If you want to run Roller "in production" for a real blog, the best
>> >> > approach is to follow the installation guide, install Roller into
>> Tomcat
>> >> > and use MySQL as the database.
>> >> >
>> >> > - Dave
>> >> >
>> >> >
>> >> >
>> >> > 2012/3/20 Shen Hongzhou <sh...@gmail.com>
>> >> >
>> >> > > By the way, I use eclipse as IDE.
>> >> > >
>> >> > > 2012-3-20 12:26 am, Shen Hongzhou <sh...@gmail.com>：
>> >> > >
>> >> > > > Hi everybody,
>> >> > > >
>> >> > > > I'm new to Roller and I just ran the source code of Roller,
>> >> everything
>> >> > > > works fine. I created a new user and a new blog.
>> >> > > > But when I stopped Roller and ran it again, all of newly created
>> >> data
>> >> > > > disappeared, there is no user and no blog. I guess maybe the
>> Derby
>> >> > > cleared
>> >> > > > the old data when it was started.
>> >> > > >
>> >> > > > So, I just want to know how to keep the old data when I restart
>> the
>> >> > > > Roller?
>> >> > > > Or, maybe I can use MySQL for developing, how can I change to
>> MySQL?
>> >> > > >
>> >> > > > This is my first time to user maven+jetty+Derby, I'm sorry for
>> this
>> >> > kind
>> >> > > > of "stupid" question.
>> >> > > >
>> >> > > > Regards,
>> >> > > > Hongzhou
>> >> > > >
>> >> > >
>> >> >
>> >> >
>> >> >
>> >> > --
>> >> > Dave M. Johnson
>> >> > Apache Roller PMC Chair
>> >> > http://rollerweblogger.org/roller
>> >> >
>> >>
>> >
>> >
>> >
>> > --
>> > Best Regards From Tiger Gui
>> > --------------------------------------
>> > Open source is some kind of life attitude
>> >
>>
>>
>>
>> --
>> Best Regards From Tiger Gui
>> --------------------------------------
>> Open source is some kind of life attitude
>>
>
>
Re: How to keep the data in Derby or change the developing DB to MySQL?
Posted by Shen Hongzhou <sh...@gmail.com>.
Thank you.
I have tried. I added the mysql dependency, and change the
"roller-custom.properties" according to the install guide document.
But now, I get the "reading/parsing database creation script" error. The
mysql version is: 5.0.18
If I can change some settings to avoid the lost of data in Derby, I think
just using Derby will be better.
Hongzhou
在 2012年3月20日 上午10:36，Tiger Gui <ti...@gmail.com>写道：
> You can get the details in Roller's install guide document. Use Mysql or
> other Database to save your data, do not use the default Derby.
>
> 在 2012年3月20日 下午9:35，Tiger Gui <ti...@gmail.com>写道：
>
> > Hi,
> >
> > You can get the details in this guide in attach file
> >
> > 在 2012年3月20日 下午9:10，Shen Hongzhou <sh...@gmail.com>写道：
> >
> > Thank you, Dave.
> >>
> >> Actually, I would like to do some development things. I also think Jetty
> >> and Derby is convenient. But I don't know how to avoid the lost of data
> >> when restart Roller. Maybe there are somewhere to set?
> >>
> >> Regards,
> >> Hongzhou
> >>
> >>
> >> Running Roller via the Maven build script and "mvn jetty:run" is only
> >> meant
> >> > for development. In development we use Jetty and Derby because they
> are
> >> > easy to setup an start from the Maven build script.
> >> >
> >> > If you want to run Roller "in production" for a real blog, the best
> >> > approach is to follow the installation guide, install Roller into
> Tomcat
> >> > and use MySQL as the database.
> >> >
> >> > - Dave
> >> >
> >> >
> >> >
> >> > 2012/3/20 Shen Hongzhou <sh...@gmail.com>
> >> >
> >> > > By the way, I use eclipse as IDE.
> >> > >
> >> > > 2012-3-20 12:26 am, Shen Hongzhou <sh...@gmail.com>：
> >> > >
> >> > > > Hi everybody,
> >> > > >
> >> > > > I'm new to Roller and I just ran the source code of Roller,
> >> everything
> >> > > > works fine. I created a new user and a new blog.
> >> > > > But when I stopped Roller and ran it again, all of newly created
> >> data
> >> > > > disappeared, there is no user and no blog. I guess maybe the Derby
> >> > > cleared
> >> > > > the old data when it was started.
> >> > > >
> >> > > > So, I just want to know how to keep the old data when I restart
> the
> >> > > > Roller?
> >> > > > Or, maybe I can use MySQL for developing, how can I change to
> MySQL?
> >> > > >
> >> > > > This is my first time to user maven+jetty+Derby, I'm sorry for
> this
> >> > kind
> >> > > > of "stupid" question.
> >> > > >
> >> > > > Regards,
> >> > > > Hongzhou
> >> > > >
> >> > >
> >> >
> >> >
> >> >
> >> > --
> >> > Dave M. Johnson
> >> > Apache Roller PMC Chair
> >> > http://rollerweblogger.org/roller
> >> >
> >>
> >
> >
> >
> > --
> > Best Regards From Tiger Gui
> > --------------------------------------
> > Open source is some kind of life attitude
> >
>
>
>
> --
> Best Regards From Tiger Gui
> --------------------------------------
> Open source is some kind of life attitude
>
Re: How to keep the data in Derby or change the developing DB to MySQL?
Posted by Tiger Gui <ti...@gmail.com>.
You can get the details in Roller's install guide document. Use Mysql or
other Database to save your data, do not use the default Derby.
在 2012年3月20日 下午9:35，Tiger Gui <ti...@gmail.com>写道：
> Hi,
>
> You can get the details in this guide in attach file
>
> 在 2012年3月20日 下午9:10，Shen Hongzhou <sh...@gmail.com>写道：
>
> Thank you, Dave.
>>
>> Actually, I would like to do some development things. I also think Jetty
>> and Derby is convenient. But I don't know how to avoid the lost of data
>> when restart Roller. Maybe there are somewhere to set?
>>
>> Regards,
>> Hongzhou
>>
>>
>> Running Roller via the Maven build script and "mvn jetty:run" is only
>> meant
>> > for development. In development we use Jetty and Derby because they are
>> > easy to setup an start from the Maven build script.
>> >
>> > If you want to run Roller "in production" for a real blog, the best
>> > approach is to follow the installation guide, install Roller into Tomcat
>> > and use MySQL as the database.
>> >
>> > - Dave
>> >
>> >
>> >
>> > 2012/3/20 Shen Hongzhou <sh...@gmail.com>
>> >
>> > > By the way, I use eclipse as IDE.
>> > >
>> > > 2012-3-20 12:26 am, Shen Hongzhou <sh...@gmail.com>：
>> > >
>> > > > Hi everybody,
>> > > >
>> > > > I'm new to Roller and I just ran the source code of Roller,
>> everything
>> > > > works fine. I created a new user and a new blog.
>> > > > But when I stopped Roller and ran it again, all of newly created
>> data
>> > > > disappeared, there is no user and no blog. I guess maybe the Derby
>> > > cleared
>> > > > the old data when it was started.
>> > > >
>> > > > So, I just want to know how to keep the old data when I restart the
>> > > > Roller?
>> > > > Or, maybe I can use MySQL for developing, how can I change to MySQL?
>> > > >
>> > > > This is my first time to user maven+jetty+Derby, I'm sorry for this
>> > kind
>> > > > of "stupid" question.
>> > > >
>> > > > Regards,
>> > > > Hongzhou
>> > > >
>> > >
>> >
>> >
>> >
>> > --
>> > Dave M. Johnson
>> > Apache Roller PMC Chair
>> > http://rollerweblogger.org/roller
>> >
>>
>
>
>
> --
> Best Regards From Tiger Gui
> --------------------------------------
> Open source is some kind of life attitude
>
--
Best Regards From Tiger Gui
--------------------------------------
Open source is some kind of life attitude
Re: How to keep the data in Derby or change the developing DB to MySQL?
Posted by Shen Hongzhou <sh...@gmail.com>.
Thank you, Dave.
Actually, I would like to do some development things. I also think Jetty
and Derby is convenient. But I don't know how to avoid the lost of data
when restart Roller. Maybe there are somewhere to set?
Regards,
Hongzhou
Running Roller via the Maven build script and "mvn jetty:run" is only meant
> for development. In development we use Jetty and Derby because they are
> easy to setup an start from the Maven build script.
>
> If you want to run Roller "in production" for a real blog, the best
> approach is to follow the installation guide, install Roller into Tomcat
> and use MySQL as the database.
>
> - Dave
>
>
>
> 2012/3/20 Shen Hongzhou <sh...@gmail.com>
>
> > By the way, I use eclipse as IDE.
> >
> > 2012-3-20 12:26 am, Shen Hongzhou <sh...@gmail.com>：
> >
> > > Hi everybody,
> > >
> > > I'm new to Roller and I just ran the source code of Roller, everything
> > > works fine. I created a new user and a new blog.
> > > But when I stopped Roller and ran it again, all of newly created data
> > > disappeared, there is no user and no blog. I guess maybe the Derby
> > cleared
> > > the old data when it was started.
> > >
> > > So, I just want to know how to keep the old data when I restart the
> > > Roller?
> > > Or, maybe I can use MySQL for developing, how can I change to MySQL?
> > >
> > > This is my first time to user maven+jetty+Derby, I'm sorry for this
> kind
> > > of "stupid" question.
> > >
> > > Regards,
> > > Hongzhou
> > >
> >
>
>
>
> --
> Dave M. Johnson
> Apache Roller PMC Chair
> http://rollerweblogger.org/roller
>
Re: How to keep the data in Derby or change the developing DB to MySQL?
Posted by Dave <sn...@gmail.com>.
Running Roller via the Maven build script and "mvn jetty:run" is only meant
for development. In development we use Jetty and Derby because they are
easy to setup an start from the Maven build script.
If you want to run Roller "in production" for a real blog, the best
approach is to follow the installation guide, install Roller into Tomcat
and use MySQL as the database.
- Dave
2012/3/20 Shen Hongzhou <sh...@gmail.com>
> By the way, I use eclipse as IDE.
>
> 2012-3-20 12:26 am, Shen Hongzhou <sh...@gmail.com>：
>
> > Hi everybody,
> >
> > I'm new to Roller and I just ran the source code of Roller, everything
> > works fine. I created a new user and a new blog.
> > But when I stopped Roller and ran it again, all of newly created data
> > disappeared, there is no user and no blog. I guess maybe the Derby
> cleared
> > the old data when it was started.
> >
> > So, I just want to know how to keep the old data when I restart the
> > Roller?
> > Or, maybe I can use MySQL for developing, how can I change to MySQL?
> >
> > This is my first time to user maven+jetty+Derby, I'm sorry for this kind
> > of "stupid" question.
> >
> > Regards,
> > Hongzhou
> >
>
--
Dave M. Johnson
Apache Roller PMC Chair
http://rollerweblogger.org/roller
Re: How to keep the data in Derby or change the developing DB to MySQL?
Posted by Shen Hongzhou <sh...@gmail.com>.
By the way, I use eclipse as IDE.
2012-3-20 12:26 am, Shen Hongzhou <sh...@gmail.com>：
> Hi everybody,
>
> I'm new to Roller and I just ran the source code of Roller, everything
> works fine. I created a new user and a new blog.
> But when I stopped Roller and ran it again, all of newly created data
> disappeared, there is no user and no blog. I guess maybe the Derby cleared
> the old data when it was started.
>
> So, I just want to know how to keep the old data when I restart the
> Roller?
> Or, maybe I can use MySQL for developing, how can I change to MySQL?
>
> This is my first time to user maven+jetty+Derby, I'm sorry for this kind
> of "stupid" question.
>
> Regards,
> Hongzhou
>