All good, but without a comma, after <property name="openjpa.ConnectionProperties" value="DriverClassName=oracle.jdbc.driver.OracleDriver
an exception occur. With comma, all works. 2012/5/16 Maxim Solodovnik <[email protected]> > 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 > -- _________________________________________________________ С уважением, Замула Дмитрий
