great On Wed, May 16, 2012 at 5:14 PM, [email protected] < [email protected]> wrote:
> 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] > -- WBR Maxim aka solomax
