I think the default database name in our Oracle config needs to be customized by the Sys-Admin that will install Openmeetings anyway. So whatever name we take for that database is okay (as long as its somehow consistent to existing persistance.xml files). Our main focus is that the syntax of persistance config files is all right. As far as I could understood from your discussion this is done.
Sebastian 2012/5/16 Maxim Solodovnik <[email protected]> > I'm not sure :( > The default instance is ORCL (no doubt) > But as oracle admin I would create separate user (with separate tablespace > for that) > Or create separate DB (never manager to get this working) > > So IMHO since we need to change instance and/or user, we should leave it as > is for now. > > @Sebastian what do you think about it? > > On Wed, May 16, 2012 at 4:13 PM, Dmitry Zamula <[email protected] > >wrote: > > > 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 > > >> > > > > > > > > > > > > -- > > > _________________________________________________________ > > > > > > С уважением, > > > > > > Замула Дмитрий > > > > > > > > > > > -- > > _________________________________________________________ > > > > С уважением, > > > > Замула Дмитрий > > > > > > -- > WBR > Maxim aka solomax > -- Sebastian Wagner https://twitter.com/#!/dead_lock http://www.openmeetings.de http://www.webbase-design.de http://www.wagner-sebastian.com [email protected]
