Thanks! On Wed, May 16, 2012 at 4:07 PM, Dmitry Zamula <[email protected]>wrote:
> 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 > > > > > > -- > _________________________________________________________ > > С уважением, > > Замула Дмитрий > -- WBR Maxim aka solomax
