Salesforce's Database.com and Google App Engine via JPA

Question

Currently i try to connect (via JPA/Datanucleus) with an application, hosted by Google App Engine, to the database service of database.com (Salesforce)

After many hours of reading and trying, i could not find any solution.

So, is it even possible??

Some Information.... Database.com provides JPA: http://forcedotcom.github.com/java-sdk/jpa-provider, but i could not found any sdk on this side, but i found a jar-file hosted by grepcode http://grepcode.com/snapshot/repo1.maven.org/maven2/com.force.sdk/force-jpa/22.0.7-BETA/ - Possibly there is currently no official release ...

The problem is that this SDK from Salesforce needs datanucleus 2.0, but Google App Engine includes only datanucleus 1.1.5. So i try to update theses libaries and found this.... code.google.com/p/datanucleus-appengine/ . I tried a few hours to replace the old libaries and to use the newer, but unsuccessfully. The error was that eclipse could not find some libaries, because the newer libaries, provided by the side above, have different package structure -

I am thankful for any help...

Kotake

datanucleus-appengine SVN trunk uses DataNucleus 3.x now. To have full portability with VMForce you still need to wait for Salesforce to upgrade to DataNucleus 3.x though — DataNucleus, Oct 11 '11 at 08:05

score 3 · Answer 1 · answered Oct 11 '11 at 15:32

3

The official release of the JPA provider is available on Maven Central: http://search.maven.org/remotecontent?filepath=com/force/sdk/force-jpa/22.0.7-BETA/force-jpa-22.0.7-BETA.jar

The external connection restriction won't be a limiting factor because the JPA adapter connects to Database.com over https using a SOAP API.

I can't speak to the challenges around getting DN 2.0 running on GAE. Perhaps GAE support can help with that?

answered Oct 11 '11 at 15:32

j_simone

558
2
6

Does the JPA adapter use the app engine specific URL apis to make https calls? If it doesn't, then the external connection restriction will still be the limiting factor. – Peter Recore Oct 11 '11 at 21:34
Is there a list of dependence, for using the force-jpa.jar? – KotakeTetsuya Oct 12 '11 at 11:31
look in the pom.xml for force-jpa, obviously – DataNucleus Oct 12 '11 at 17:15

score 1 · Answer 2 · edited Oct 20 '12 at 12:07

1

This link describes how to solve your problem:

How to use Force.com Database SDK on Google APP Engine

(He has updated the Saleforce SDK source code to allow it to work without problem on GAE.)

edited Oct 20 '12 at 12:07

The Unfun Cat

29,987
31
114
156

answered May 02 '12 at 14:52

Eric

11
1

Peter Recore · Answer 3 · 2011-10-11T21:35:25.530

1

As stated here in the App Engine docs, you cannot make direct connections to external servers from GAE (except over http or https using the app engine specific url APIs). You will need to find some other way to get data out of your remote database.

edited Oct 11 '11 at 21:35

answered Oct 11 '11 at 00:52

Peter Recore

14,037
4
42
62

Salesforce's Database.com and Google App Engine via JPA

3 Answers3