Hi mobject,
I use MySQL for developer testing when running my app on a development
web server before unleashing it onto my GAE developer web server
(using BigTable)!
I give you the contents of my "jdoconfig.xml" file below. You will be
able to see that I have two persistence manager factory names; I use
one for GAE (dev server and production) and the other for my local
MySQL dev testing.
One warning though: I have found that JDO behaviour differs when using
MySQL and BigTable. So until it works on BigTable, it doesn't
necessarily work!
Enjoy,
Ian
jdoconfig.xml
-------------
<?xml version="1.0" encoding="UTF-8"?>
<jdoconfig>
<persistence-manager-factory name="big-table">
<property
name="javax.jdo.PersistenceManagerFactoryClass"
value="org.datanucleus.store.appengine.jdo.DatastoreJDOPersistenceManagerFactory"
/>
<property name="javax.jdo.option.ConnectionURL" value="appengine"/
>
<property name="datanucleus.appengine.autoCreateDatastoreTxns"
value="true"/>
<property name="datanucleus.autoStartMechanism" value="None"/>
<property name="datanucleus.autoCreateSchema" value="true"/>
<property name="datanucleus.validateTables" value="true"/>
<property name="datanucleus.validateConstraints" value="true"/>
<property name="datanucleus.validateColumns" value="true"/>
<!--<property name="datanucleus.persistenceByReachabilityAtCommit"
value="false"/>-->
<property name="datanucleus.DetachAllOnCommit" value="true"/>
<!--<property name="datanucleus.detachAsWrapped" value="true"/>-->
<!-- The default value is 1 -->
<property name="datanucleus.maxFetchDepth" value="1"/>
<!-- The default value is "JDO2" -->
<!--<property name="datanucleus.deletionPolicy" value="DataNucleus"/>--
>
</persistence-manager-factory>
<persistence-manager-factory name="mysql">
<property
name="javax.jdo.PersistenceManagerFactoryClass"
value="org.datanucleus.store.appengine.jdo.DatastoreJDOPersistenceManagerFactory"
/>
<!-- Settings for connection to a local MySQL database -->
<property
name="datanucleus.ConnectionDriverName"
value="com.mysql.jdbc.Driver"
/>
<property
name="datanucleus.ConnectionURL"
value="jdbc:mysql://localhost:3306/[...]"
/>
<property name="datanucleus.ConnectionUserName" value="[...]"/>
<property name="datanucleus.ConnectionPassword" value="[...]"/>
<property name="datanucleus.appengine.autoCreateDatastoreTxns"
value="true"/>
<property name="datanucleus.autoStartMechanism" value="None"/>
<property name="datanucleus.autoCreateSchema" value="true"/>
<property name="datanucleus.validateTables" value="true"/>
<property name="datanucleus.validateConstraints" value="true"/>
<property name="datanucleus.validateColumns" value="true"/>
<!--<property name="datanucleus.persistenceByReachabilityAtCommit"
value="false"/>-->
<property name="datanucleus.DetachAllOnCommit" value="true"/>
<!--<property name="datanucleus.detachAsWrapped" value="true"/>-->
<!-- The default value is 1 -->
<property name="datanucleus.maxFetchDepth" value="1"/>
<!-- The default value is "JDO2" -->
<!--<property name="datanucleus.deletionPolicy" value="DataNucleus"/>--
>
<!--
<property name="javax.jdo.option.NontransactionalRead"
value="true"/>
<property name="javax.jdo.option.NontransactionalWrite"
value="true"/>
<property name="javax.jdo.option.RetainValues" value="true"/>
<property name="datanucleus.autoCreateTables" value="true"/>
<property name="datanucleus.autoCreateColumns" value="true"/>
<property name="datanucleus.autoCreateConstraints" value="true"/>
<property name="datanucleus.cache.collections.lazy" value="true"/>
<property name="datanucleus.RetainValues" value="true"/>
-->
</persistence-manager-factory>
</jdoconfig>
--
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en.
