External App Database

Question

I searched and can not find the answer anywhere. I also did not have time to try this.

Is it possible using java in the Google App Engine (GAE) to connect to a remote database. Be it MySql, SQLServer, etc. Will it be allowed to make calls outside this domain? Is it even possible to use the necessary libraries to create such a connection?

Answer 1

The closest you'll find is the Google Secure Data Connector . All connections originating from GAE are based on HTTP, so you are unlikely to get a jdbc connection to the database server (MySql, SqlServer, etc.).

Answer 2

IMHO you can try tunneling JDBC over HTTP. Maybe. For example, this is a free solution http://sourceforge.net/projects/sqlgateway/ and here is a commercial http://www.idssoftware.com/jdbcdrv.html :)

Answer 3

I use the REST API all the time on the server that contains the database. Depending on your needs (for example, you need special requests), you can choose the REST API with some flexibility.

There are quite a few simple REST-DB libraries such as http://phprestsql.sourceforge.net/

Although you can just flip your own using http://www.playframework.org/ or http://guides.rubyonrails.org/getting_started.html#rest

Answer 4

Do not use HTTP for DB connections, as it is less secure.

Use CLoud SQL instead (jdbc-type connection, mysql as queries and drivers in banks)

getting started with sql cloud

simple video for java + cloud sql + engine