Hello Dmitry, Thanks for pointing this out Finally I get to this issue and have added proper driver can you please if Revision: 1338978 works for you?
On Thu, May 10, 2012 at 8:17 PM, [email protected] < [email protected]> wrote: > 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] > -- WBR Maxim aka solomax
