You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openmeetings.apache.org by Dmitry Zamula <cl...@gmail.com> on 2012/05/10 14:07:48 UTC
Oracle persistence.xml
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
Re: Oracle persistence.xml
Posted by Maxim Solodovnik <so...@gmail.com>.
great
On Wed, May 16, 2012 at 5:14 PM, seba.wagner@gmail.com <
seba.wagner@gmail.com> 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 <so...@gmail.com>
>
> > 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 <club.brantner@gmail.com
> > >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 <cl...@gmail.com>
> > >
> > > > 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 <so...@gmail.com>
> > > >
> > > >> 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, seba.wagner@gmail.com <
> > > >> seba.wagner@gmail.com> 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 <cl...@gmail.com>
> > > >> >
> > > >> > > 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 seba.wagner@gmail.com <se...@gmail.com>
> > > >> > >
> > > >> > > > Hi Dmitry,
> > > >> > > >
> > > >> > > > sorry but the mail does not contain any bold words.
> > > >> > > >
> > > >> > > > Sebastian
> > > >> > > >
> > > >> > > > 2012/5/10 Dmitry Zamula <cl...@gmail.com>
> > > >> > > >
> > > >> > > > > 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
> > > >> > > > seba.wagner@gmail.com
> > > >> > > >
> > > >> > >
> > > >> > >
> > > >> > >
> > > >> > > --
> > > >> > > _________________________________________________________
> > > >> > >
> > > >> > > С уважением,
> > > >> > >
> > > >> > > Замула Дмитрий
> > > >> > >
> > > >> >
> > > >> >
> > > >> >
> > > >> > --
> > > >> > Sebastian Wagner
> > > >> > https://twitter.com/#!/dead_lock
> > > >> > http://www.openmeetings.de
> > > >> > http://www.webbase-design.de
> > > >> > http://www.wagner-sebastian.com
> > > >> > seba.wagner@gmail.com
> > > >> >
> > > >>
> > > >>
> > > >>
> > > >> --
> > > >> 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
> seba.wagner@gmail.com
>
--
WBR
Maxim aka solomax
Re: Oracle persistence.xml
Posted by "seba.wagner@gmail.com" <se...@gmail.com>.
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 <so...@gmail.com>
> 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 <club.brantner@gmail.com
> >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 <cl...@gmail.com>
> >
> > > 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 <so...@gmail.com>
> > >
> > >> 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, seba.wagner@gmail.com <
> > >> seba.wagner@gmail.com> 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 <cl...@gmail.com>
> > >> >
> > >> > > 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 seba.wagner@gmail.com <se...@gmail.com>
> > >> > >
> > >> > > > Hi Dmitry,
> > >> > > >
> > >> > > > sorry but the mail does not contain any bold words.
> > >> > > >
> > >> > > > Sebastian
> > >> > > >
> > >> > > > 2012/5/10 Dmitry Zamula <cl...@gmail.com>
> > >> > > >
> > >> > > > > 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
> > >> > > > seba.wagner@gmail.com
> > >> > > >
> > >> > >
> > >> > >
> > >> > >
> > >> > > --
> > >> > > _________________________________________________________
> > >> > >
> > >> > > С уважением,
> > >> > >
> > >> > > Замула Дмитрий
> > >> > >
> > >> >
> > >> >
> > >> >
> > >> > --
> > >> > Sebastian Wagner
> > >> > https://twitter.com/#!/dead_lock
> > >> > http://www.openmeetings.de
> > >> > http://www.webbase-design.de
> > >> > http://www.wagner-sebastian.com
> > >> > seba.wagner@gmail.com
> > >> >
> > >>
> > >>
> > >>
> > >> --
> > >> 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
seba.wagner@gmail.com
Re: Oracle persistence.xml
Posted by Maxim Solodovnik <so...@gmail.com>.
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 <cl...@gmail.com>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 <cl...@gmail.com>
>
> > 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 <so...@gmail.com>
> >
> >> 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, seba.wagner@gmail.com <
> >> seba.wagner@gmail.com> 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 <cl...@gmail.com>
> >> >
> >> > > 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 seba.wagner@gmail.com <se...@gmail.com>
> >> > >
> >> > > > Hi Dmitry,
> >> > > >
> >> > > > sorry but the mail does not contain any bold words.
> >> > > >
> >> > > > Sebastian
> >> > > >
> >> > > > 2012/5/10 Dmitry Zamula <cl...@gmail.com>
> >> > > >
> >> > > > > 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
> >> > > > seba.wagner@gmail.com
> >> > > >
> >> > >
> >> > >
> >> > >
> >> > > --
> >> > > _________________________________________________________
> >> > >
> >> > > С уважением,
> >> > >
> >> > > Замула Дмитрий
> >> > >
> >> >
> >> >
> >> >
> >> > --
> >> > Sebastian Wagner
> >> > https://twitter.com/#!/dead_lock
> >> > http://www.openmeetings.de
> >> > http://www.webbase-design.de
> >> > http://www.wagner-sebastian.com
> >> > seba.wagner@gmail.com
> >> >
> >>
> >>
> >>
> >> --
> >> WBR
> >> Maxim aka solomax
> >>
> >
> >
> >
> > --
> > _________________________________________________________
> >
> > С уважением,
> >
> > Замула Дмитрий
> >
>
>
>
> --
> _________________________________________________________
>
> С уважением,
>
> Замула Дмитрий
>
--
WBR
Maxim aka solomax
Re: Oracle persistence.xml
Posted by Dmitry Zamula <cl...@gmail.com>.
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 <cl...@gmail.com>
> 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 <so...@gmail.com>
>
>> 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, seba.wagner@gmail.com <
>> seba.wagner@gmail.com> 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 <cl...@gmail.com>
>> >
>> > > 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 seba.wagner@gmail.com <se...@gmail.com>
>> > >
>> > > > Hi Dmitry,
>> > > >
>> > > > sorry but the mail does not contain any bold words.
>> > > >
>> > > > Sebastian
>> > > >
>> > > > 2012/5/10 Dmitry Zamula <cl...@gmail.com>
>> > > >
>> > > > > 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
>> > > > seba.wagner@gmail.com
>> > > >
>> > >
>> > >
>> > >
>> > > --
>> > > _________________________________________________________
>> > >
>> > > С уважением,
>> > >
>> > > Замула Дмитрий
>> > >
>> >
>> >
>> >
>> > --
>> > Sebastian Wagner
>> > https://twitter.com/#!/dead_lock
>> > http://www.openmeetings.de
>> > http://www.webbase-design.de
>> > http://www.wagner-sebastian.com
>> > seba.wagner@gmail.com
>> >
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>
>
>
> --
> _________________________________________________________
>
> С уважением,
>
> Замула Дмитрий
>
--
_________________________________________________________
С уважением,
Замула Дмитрий
Re: Oracle persistence.xml
Posted by Maxim Solodovnik <so...@gmail.com>.
Thanks!
On Wed, May 16, 2012 at 4:07 PM, Dmitry Zamula <cl...@gmail.com>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 <so...@gmail.com>
>
> > 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, seba.wagner@gmail.com <
> > seba.wagner@gmail.com> 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 <cl...@gmail.com>
> > >
> > > > 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 seba.wagner@gmail.com <se...@gmail.com>
> > > >
> > > > > Hi Dmitry,
> > > > >
> > > > > sorry but the mail does not contain any bold words.
> > > > >
> > > > > Sebastian
> > > > >
> > > > > 2012/5/10 Dmitry Zamula <cl...@gmail.com>
> > > > >
> > > > > > 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
> > > > > seba.wagner@gmail.com
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > _________________________________________________________
> > > >
> > > > С уважением,
> > > >
> > > > Замула Дмитрий
> > > >
> > >
> > >
> > >
> > > --
> > > Sebastian Wagner
> > > https://twitter.com/#!/dead_lock
> > > http://www.openmeetings.de
> > > http://www.webbase-design.de
> > > http://www.wagner-sebastian.com
> > > seba.wagner@gmail.com
> > >
> >
> >
> >
> > --
> > WBR
> > Maxim aka solomax
> >
>
>
>
> --
> _________________________________________________________
>
> С уважением,
>
> Замула Дмитрий
>
--
WBR
Maxim aka solomax
Re: Oracle persistence.xml
Posted by Dmitry Zamula <cl...@gmail.com>.
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 <so...@gmail.com>
> 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, seba.wagner@gmail.com <
> seba.wagner@gmail.com> 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 <cl...@gmail.com>
> >
> > > 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 seba.wagner@gmail.com <se...@gmail.com>
> > >
> > > > Hi Dmitry,
> > > >
> > > > sorry but the mail does not contain any bold words.
> > > >
> > > > Sebastian
> > > >
> > > > 2012/5/10 Dmitry Zamula <cl...@gmail.com>
> > > >
> > > > > 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
> > > > seba.wagner@gmail.com
> > > >
> > >
> > >
> > >
> > > --
> > > _________________________________________________________
> > >
> > > С уважением,
> > >
> > > Замула Дмитрий
> > >
> >
> >
> >
> > --
> > Sebastian Wagner
> > https://twitter.com/#!/dead_lock
> > http://www.openmeetings.de
> > http://www.webbase-design.de
> > http://www.wagner-sebastian.com
> > seba.wagner@gmail.com
> >
>
>
>
> --
> WBR
> Maxim aka solomax
>
--
_________________________________________________________
С уважением,
Замула Дмитрий
Re: Oracle persistence.xml
Posted by Maxim Solodovnik <so...@gmail.com>.
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, seba.wagner@gmail.com <
seba.wagner@gmail.com> 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 <cl...@gmail.com>
>
> > 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 seba.wagner@gmail.com <se...@gmail.com>
> >
> > > Hi Dmitry,
> > >
> > > sorry but the mail does not contain any bold words.
> > >
> > > Sebastian
> > >
> > > 2012/5/10 Dmitry Zamula <cl...@gmail.com>
> > >
> > > > 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
> > > seba.wagner@gmail.com
> > >
> >
> >
> >
> > --
> > _________________________________________________________
> >
> > С уважением,
> >
> > Замула Дмитрий
> >
>
>
>
> --
> Sebastian Wagner
> https://twitter.com/#!/dead_lock
> http://www.openmeetings.de
> http://www.webbase-design.de
> http://www.wagner-sebastian.com
> seba.wagner@gmail.com
>
--
WBR
Maxim aka solomax
Re: Oracle persistence.xml
Posted by "seba.wagner@gmail.com" <se...@gmail.com>.
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 <cl...@gmail.com>
> 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 seba.wagner@gmail.com <se...@gmail.com>
>
> > Hi Dmitry,
> >
> > sorry but the mail does not contain any bold words.
> >
> > Sebastian
> >
> > 2012/5/10 Dmitry Zamula <cl...@gmail.com>
> >
> > > 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
> > seba.wagner@gmail.com
> >
>
>
>
> --
> _________________________________________________________
>
> С уважением,
>
> Замула Дмитрий
>
--
Sebastian Wagner
https://twitter.com/#!/dead_lock
http://www.openmeetings.de
http://www.webbase-design.de
http://www.wagner-sebastian.com
seba.wagner@gmail.com
Re: Oracle persistence.xml
Posted by Dmitry Zamula <cl...@gmail.com>.
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 seba.wagner@gmail.com <se...@gmail.com>
> Hi Dmitry,
>
> sorry but the mail does not contain any bold words.
>
> Sebastian
>
> 2012/5/10 Dmitry Zamula <cl...@gmail.com>
>
> > 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
> seba.wagner@gmail.com
>
--
_________________________________________________________
С уважением,
Замула Дмитрий
Re: Oracle persistence.xml
Posted by "seba.wagner@gmail.com" <se...@gmail.com>.
Hi Dmitry,
sorry but the mail does not contain any bold words.
Sebastian
2012/5/10 Dmitry Zamula <cl...@gmail.com>
> 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
seba.wagner@gmail.com