Hello folks!
Today, I moved from MySQL to Oracle (11gR2), and had several problems with
persistence.xml.
I had a few exceptions at starting red5 (absence ConnectionDriverName).
Also, "Url" was null.
Thus, my current working version:
<properties>
<property name="openjpa.RuntimeUnenhancedClasses"
value="unsupported"/>
<property name = "openjpa.ConnectionProperties" value =
"DriverClassName = oracle.jdbc.driver.OracleDriver*,*
Url = jdbc:oracle:thin:@localhost
:1521:orcl,
create = true,
MaxActive = 100,
MaxWait = 10000
TestOnBorrow = true,
Username = openmeetings,
Password = openmeetings "/>
* <property name="openjpa.ConnectionDriverName"
value="oracle.jdbc.driver.OracleDriver"/>*
* <property name="openjpa.ConnectionURL"
value="jdbc:oracle:thin:@localhost:1521:orcl"/>*
<property name="openjpa.jdbc.SynchronizeMappings"
value="buildSchema"/>
<property name="openjpa.Log" value="DefaultLevel=WARN, Tool=INFO" />
<property name="openjpa.DataCache" value="true"/>
<property name="openjpa.QueryCache" value="true"/>
<property name="openjpa.jdbc.DBDictionary"
value="oracle(UseTriggersForAutoAssign=true, MaxAutoAssignNameLength=28,
BatchLimit=100)" />
<property name="openjpa.jdbc.QuerySQLCache" value="false"/>
</ properties>
(added text in bold).
Now everything works, but I think that every user who uses Oracle will be
forced to correct persistence.xml.
_________________________________________________________
With best regards,
Dmitry Zamula
