openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MiƂosz Tylenda <mtyle...@o2.pl>
Subject Re: JPAB results
Date Tue, 16 Nov 2010 07:58:40 GMT
Hi Ilan,

> About MySQL - I think that Hibernate and EclipseLink use MyISAM, where
> OpenJPA and DataNucleus use InnoDB. Is it possible to tell OpenJPA to use
> MyISAM as well? It might be faster.

That can be done by specifying "tableType" property of MySQLDictionary:

<property name="openjpa.jdbc.DBDictionary" value="batchLimit=100,tableType=myisam"/>

This might not work with dictionary auto-detection. If so, use this:

<property name="openjpa.jdbc.DBDictionary" value="mysql(batchLimit=100,tableType=myisam)"/>

Cheers,
Milosz

 
> Here is an example of a persistence.xml file that was used by R3 (for
> PostgreSQL).
> 
> 
> <?xml version="1.0" encoding="UTF-8"?>
> <persistence xmlns="http://java.sun.com/xml/ns/persistence"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
> http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd" version="2.0">
>   <persistence-unit name="OpenJPA_R3-PostgreSQL-server">
>    
> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
>     <class>org.jpab.basic.Person</class>
>     <class>org.jpab.col.CollectionPerson</class>
>     <class>org.jpab.ext.PersonBase</class>
>     <class>org.jpab.ext.PersonExt</class>
>     <class>org.jpab.ext.PersonExtExt</class>
>     <class>org.jpab.index.IndexedPerson</class>
>     <class>org.jpab.node.Node</class>
>     <properties>
>       <property name="openjpa.ConnectionProperties"
> value="DriverClassName=org.postgresql.Driver,
> Url=jdbc:postgresql://localhost:5432/jpab7493330740, MaxActive=100,
> MaxWait=10000, TestOnBorrow=true, Username=postgres, Password=admin,
> poolPreparedStatements=true"/>
>       <property name="openjpa.ConnectionRetainMode" value="always"/>
>       <property name="openjpa.ConnectionDriverName"
> value="org.apache.commons.dbcp.BasicDataSource"/>
>       <property name="openjpa.jdbc.DBDictionary" value="batchLimit=100"/>
>       <property name="openjpa.DataCache" value="true"/>
>       <property name="openjpa.Log" value="DefaultLevel=ERROR"/>
>       <property name="openjpa.jdbc.SynchronizeMappings"
> value="buildSchema"/>
>     </properties>
>   </persistence-unit>
> </persistence>
> 


Mime
View raw message