Hello ian,
Thanks for your reply.
BTW, im using eclipse 3.5 (Galileo) and had just configured the
datasource for mysql successfully.
I edited my configuration like this(commented out storeManagerType)
and the connectionURL:
I had also replaced the datanucleus jars with version 1.1.5 as its the
version GAE uses.
I used Mysql server 5.1.
<persistence-manager-factory name="mysql">
<property name="javax.jdo.PersistenceManagerFactoryClass"
value="org.datanucleus.store.appengine.jdo.DatastoreJDOPersistenceManagerFactory"/
>
<property name="datanucleus.ConnectionDriverName"
value="com.mysql.jdbc.Driver"/>
<property name="datanucleus.ConnectionURL" value="jdbc:mysql://
localhost:3306/jdo"/>
<property name="datanucleus.ConnectionUserName" value="root"/>
<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.DetachAllOnCommit" value="true"/>
<property name="datanucleus.maxFetchDepth" value="1"/>
<!-- <property name="datanucleus.storeManagerType" value="rdbms"/>
-->
</persistence-manager-factory>
But still the error persist.
Here is the error logs:
Caused by: org.datanucleus.exceptions.NucleusUserException: No
available StoreManager found for the datastore URL key "jdbc". Please
make sure you have all relevant plugins in the CLASSPATH (e.g
datanucleus-rdbms?, datanucleus-db4o?), and consider setting the
persistence property "datanucleus.storeManagerType" to the type of
store you are using e.g rdbms, db4o
at org.datanucleus.store.FederationManager.initialiseStoreManager
(FederationManager.java:197)
at org.datanucleus.store.FederationManager.<init>
(FederationManager.java:70)
at org.datanucleus.ObjectManagerFactoryImpl.initialiseStoreManager
(ObjectManagerFactoryImpl.java:153)
at
org.datanucleus.jdo.JDOPersistenceManagerFactory.freezeConfiguration
(JDOPersistenceManagerFactory.java:526)
... 51 more
Here is my PMF.java class. I guess there are still more configurations
to make. I created the database jdo. I guess there will be no need to
create a table?
public final class PMF {
private static final PersistenceManagerFactory pmfInstance =
JDOHelper.getPersistenceManagerFactory("mysql");
//JDOHelper.getPersistenceManagerFactory("postgresql");
//JDOHelper.getPersistenceManagerFactory("transactions-
optional");
private PMF() {}
public static PersistenceManagerFactory get() {
return pmfInstance;
}
}
Hope someone could help me with this.
Thanks,
ivanceras
On Jan 12, 2:54 am, Ian Marshall <ianmarshall...@gmail.com> wrote:
> Hello ivanceras,
>
> YOUR PROPERTY "datanucleus.ConnectionURL"
> -----------------------------------------
> I do not know what your dev environment is. I use NetBeans; this has a
> connection set up to use my local MySQL database. I noticed an extra
> "//" between the "jdbc:" and "mysql" parts of your connection URL. But
> you might need this for your environment. You might want to verify
> your value for this property.
>
> YOUR PROPERTY "datanucleus.storeManagerType"
> --------------------------------------------
> I personally do not use this property. As you will probably know, the
> relevant DataNucleus documentation describes this property as:
>
> 'Type of the StoreManager to use for this PMF/EMF. This has typical
> values of "rdbms", "db4o". If it isn't specified then it falls back to
> trying to find the StoreManager from the connection URL. The
> associated DataNucleus plugin has to be in the CLASSPATH when
> selecting this. When using data sources (as usually done in a JavaEE
> container), DataNucleus cannot find out the correct type automatically
> and this option must be set.'
>
> I assume that your set-up requires this property (otherwise I would
> suggest omitting it as I do). All I can suggest here is to verify that
> you have the relevant DataNucleus plug-in and that it can be found
> from your class path. I do not speak from experience about this
> property since I have never used it.
>
> Don't make the mistake I have made: ensure that you use the same
> DataNucleus plug-in version number as is used by the version of GAE
> that you use!
>
> Cheers,
>
> Ian
--
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To post to this group, send email to google-appeng...@googlegroups.com.
To unsubscribe from this group, send email to
google-appengine+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en.
