Question

I ve developed an application using JSP, Spring Security, MySql. I deployed it on Cloudfoundry. But just war file and I binded mysql service. But I also have to configure MySQL database that consists of two tables, new user and it all in my own database. While i tested my application on localhost i prepared the database running manual scripts in MySQL command window. Question: How can I make the same configurations in CloudFoundry? can I the same way run all commands and scripts manually or export the database somehow? if yes, how to do this. And what to write here now instead of localhost?

 <property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/security_filter" />

感谢

Answer 1

Caldecott(vmc隧道)是查阅贵云集层数据库的正确途径(对我来说,该数据库是行之有效的,而且正在使用废墟1.8):。

If that does not work for you you will have to do something manually (much harder):

Create a sample jsp/servlet application that connects to a mysql database (retrieving connection string, username and password as input from user). Then it will just run the sql statement against the database ( sql statement will be also input from user)

Bundle this application in your war

Now you have to retrieve database connection string/username and password. You can retrieve them from the enviromental variable VCAP_SERVICES. Just log log it in a startup listener (eg ServletContextListener)
Deploy your war and get logs from server (vmc logs ApplicationName). Get connection string, username and password
Logon to your application and use your database application to access the database using the db info you collected in the previous step

Just note that this is very dangerous approach. Just be sure to secure this database application or after the initial import remove it from your war and redeploy the application

作为最后说明,你可以核实,如果已经存在这样的数据库,那么你就不得不自行创建(例如,铁路公司对:http://grails.org/plugin/dbconsole/a>有 n。也许有些东西是用于jsp/servlets。

如果你没有 rub,希望会有所助益。

Answer 2

You would need to create a mysqldump of your database. Once you have the mysqldump file, you then use caldecott and perform vmc tunnel to your MySQL service. After you have establish a connection with your MySQL service on Cloud Foundry, you then need to use the mysql command to manually import the mysqldump file into your service.

http://docs.cloudfoundry.com/tools/vmc/caldecott.html

友情链接