There are two different ways of configuring the URL. Either the way in the current persistence.xml as "openjpa.ConnectionProperties" or the way you do it, by adding a separated param for each of the ConnectionProperties. Both ways should work actually. You should talk to Maxim as he has tested Oracle and wrote the persistence configuration file.
Sebastian 2012/5/10 Dmitry Zamula <[email protected]> > Ok, I'll write it separately. > > At first I thought that the problem is the lack of a comma after " > DriverClassName=oracle.jdbc.driver.OracleDrive" and added it. It did not > work and I added these lines: > > <property name="openjpa.ConnectionDriverName" > value="oracle.jdbc.driver.OracleDriver"/> > <property name="openjpa.ConnectionURL" > value="jdbc:oracle:thin:@localhost:1521:orcl"/> > > 2012/5/10 [email protected] <[email protected]> > > > Hi Dmitry, > > > > sorry but the mail does not contain any bold words. > > > > Sebastian > > > > 2012/5/10 Dmitry Zamula <[email protected]> > > > > > 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 > > > > > > > > > > > -- > > Sebastian Wagner > > https://twitter.com/#!/dead_lock > > http://www.openmeetings.de > > http://www.webbase-design.de > > http://www.wagner-sebastian.com > > [email protected] > > > > > > -- > _________________________________________________________ > > С уважением, > > Замула Дмитрий > -- Sebastian Wagner https://twitter.com/#!/dead_lock http://www.openmeetings.de http://www.webbase-design.de http://www.wagner-sebastian.com [email protected]
