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
