And I think, that default Url should be like "jdbc:oracle:thin:@localhost:1521:orcl" (Default SID in Oracle Enterprise Edition is orcl)
2012/5/16 Dmitry Zamula <[email protected]> > 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 >> > > > > -- > _________________________________________________________ > > С уважением, > > Замула Дмитрий > -- _________________________________________________________ С уважением, Замула Дмитрий
