Message Boards
Server and database running at the same time
Lee Chamberlain, modified 7 Years ago.
Server and database running at the same time
Junior Member Posts: 92 Join Date: 5/5/16 Recent Posts
Probably a big dumb question, but I can't manage to solve it.
Is there a way to have both the tomcat server and the database running at the same time (I'm using Squirrel to show the db - I think I'm just using HSQL still).
Lee
Is there a way to have both the tomcat server and the database running at the same time (I'm using Squirrel to show the db - I think I'm just using HSQL still).
Lee
Fernando Fernandez, modified 7 Years ago.
RE: Server and database running at the same time
Expert Posts: 396 Join Date: 8/22/07 Recent Posts
Hi Lee,
I'm not sure what you mean, since even with hsql they are "running" at the same time, or else Liferay wouldn't be working.
Maybe you want them to run in separate processes? If so you might want to migrate your DB to a mysql server, for example. After you setup your mysql server you can migrate the db with the "data migration" option in the Control Panel, and then add a new jdbc url to your portal-ext.properties.
HTH
Fernando
I'm not sure what you mean, since even with hsql they are "running" at the same time, or else Liferay wouldn't be working.
Maybe you want them to run in separate processes? If so you might want to migrate your DB to a mysql server, for example. After you setup your mysql server you can migrate the db with the "data migration" option in the Control Panel, and then add a new jdbc url to your portal-ext.properties.
HTH
Fernando
Lee Chamberlain, modified 7 Years ago.
RE: Server and database running at the same time
Junior Member Posts: 92 Join Date: 5/5/16 Recent Posts
Sorry I've a touch of insomnia at the moment and not making myself clear.
When I have tomcat running I cannot open Squirrel to view the database at the same time. Which means whenever I need to check the database I have to stop the server which is taking up far too much time.
Thanks
Lee
When I have tomcat running I cannot open Squirrel to view the database at the same time. Which means whenever I need to check the database I have to stop the server which is taking up far too much time.
Thanks
Lee
Fernando Fernandez, modified 7 Years ago.
RE: Server and database running at the same time
Expert Posts: 396 Join Date: 8/22/07 Recent Posts
That's because HSQL is an embedded DB and not a DB server, supporting multiple connections.
You really should migrate your Liferay instance to mysql or another database server.
HTH
Fernando
You really should migrate your Liferay instance to mysql or another database server.
HTH
Fernando
Lee Chamberlain, modified 7 Years ago.
RE: Server and database running at the same time
Junior Member Posts: 92 Join Date: 5/5/16 Recent Posts
Thanks
Thanks the plan, I'm just waiting for others to get hardware etc... sorted out. Originally I was going to put it on SQL Server, but we've only got CE at the moment.
Lee
Thanks the plan, I'm just waiting for others to get hardware etc... sorted out. Originally I was going to put it on SQL Server, but we've only got CE at the moment.
Lee