how to set jdbc connection properties

["christoph moar" <christoph.moar@xxxxxxxx>]

hello all,

we have an enhydra application running on 6.3. our databases
are defined in the web.xml file, like in the attached excerpt.

we need to set a oracle jdbc connection property, namely
oracle.jdbc.V8Compatibility="true"


is there any way i can set such a property such as the db manager
of enhydra will set it on the connections?
i can't find any hint in the documentation...

best regards
christoph moar


  <!-- shopdb -->
   <env-entry>
    <env-entry-name>DatabaseManager/DB/shopdb/ClassType</env-entry-name>
    <env-entry-value>Oracle</env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
  </env-entry>
  <env-entry>
    <env-entry-name>DatabaseManager/DB/shopdb/JdbcDriver</env-entry-name>
    <env-entry-value>oracle.jdbc.driver.OracleDriver</env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
  </env-entry>
  <env-entry>
 
<env-entry-name>DatabaseManager/DB/shopdb/Connection/Url</env-entry-name>
 
<env-entry-value>jdbc:oracle:thin:@xxx.yyy.zzz:1521:d3t</env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
  </env-entry>
  <env-entry>
 
<env-entry-name>DatabaseManager/DB/shopdb/Connection/User</env-entry-name>
    <env-entry-value>xxx</env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
  </env-entry>
  <env-entry>
 
<env-entry-name>DatabaseManager/DB/shopdb/Connection/Password</env-entry-nam
e>
    <env-entry-value>yyy</env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
  </env-entry>
  <env-entry>
 
<env-entry-name>DatabaseManager/DB/shopdb/Connection/MaxPoolSize</env-entry-
name>
    <env-entry-value>5</env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
  </env-entry>
  <env-entry>
 
<env-entry-name>DatabaseManager/DB/shopdb/Connection/MaxPreparedStatements</
env-entry-name>
    <env-entry-value>5000</env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
  </env-entry>
  <env-entry>
 
<env-entry-name>DatabaseManager/DB/shopdb/Connection/AllocationTimeout</env-
entry-name>
    <env-entry-value>30</env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
  </env-entry>
  <env-entry>
 
<env-entry-name>DatabaseManager/DB/shopdb/Connection/MaxExecutionTime</env-e
ntry-name>
    <env-entry-value>100</env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
  </env-entry>
  <env-entry>
 
<env-entry-name>DatabaseManager/DB/shopdb/Connection/Logging</env-entry-name
>
    <env-entry-value>false</env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
  </env-entry>
  <env-entry>
 
<env-entry-name>DatabaseManager/DB/shopdb/ConnectionAllocator</env-entry-nam
e>
 
<env-entry-value>com.lutris.appserver.server.sql.datasource.DataSourceConnec
tionAllocator</env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
  </env-entry>
  <env-entry>
 
<env-entry-name>DatabaseManager/DB/shopdb/Connection/ConnectionFactory</env-
entry-name>
 
<env-entry-value>com.lutris.appserver.server.sql.DataSourceDBConnectionFacto
ry</env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
  </env-entry>
  <env-entry>
 
<env-entry-name>DatabaseManager/DB/shopdb/ObjectId/CacheSize</env-entry-name
>
    <env-entry-value>10</env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
  </env-entry>
  <env-entry>
 
<env-entry-name>DatabaseManager/DB/shopdb/ObjectId/MinValue</env-entry-name>
    <env-entry-value>1</env-entry-value>
    <env-entry-type>java.lang.String</env-entry-type>
  </env-entry>

--
http://www.alpin.it         software, consulting & strategy

Christoph Moar                          Dipl. Inform. Univ.
alpin gmbh srl          management & technology consultants
tel +39 0471 056007 fax +39 0471 056005 gsm +39 348 3057012
lanciastr. 8b  via lancia 8b    bozen 39100 bolzano   italy
http://www.alpin.it                 christoph.moar@xxxxxxxx


 

> -----Original Message-----
> From: Slobodan Vujasinovic [mailto:slobodan@xxxxxxxxxxxxx] 
> Sent: Thursday, October 13, 2005 1:59 PM
> To: enhydra@xxxxxxxxxxxxx
> Subject: Re: [enhydra] how to download and install enhydra_conductor
> 
> Hi Christoph,
> 
> Enhydra Conductor is basically, nothing else, then mod_jk2!
> Since 15th November 2004 JK has been put in maintainer mode and all 
> further development has been stooped. Therefore, we had no reason to 
> release newer Enhydra Conductor releases.
> To conclude, you can use your enhydra conductor installation with new 
> enhydra-6.5-1 (it is supported by enhydra 6.5-1 just like by enhydra 
> 6.0-1 - no changes were required in mean time).
> 
> We are planing to migrate Enhydra Conductor to JK (tomcat 
> connector) now 
> (lots of initial code from JK2 is ported to JK). It will, 
> probably, be 
> done in next Enhydra release.
> More information about JK project can be found on 
> 'http://jakarta.apache.org/tomcat/connectors-doc' project 
> documentation 
> home page.
> 
> I've installed it (JK 1.2.14) into new Apache HTTP Server (version 
> 2.0.54) and managed to connect to Enhydra 6.5-1 trough it (on Windows 
> though)  :)
> 
> you wrote:
> --------------------------------------------------------------
> ----------
> 
> ...
> i do not know exactly what version of tomcat is in the
> runtime and the conductor. do they (have to) match?
> 
> --------------------------------------------------------------
> -----------
> 
> Enhydra 6.5-1 is based on Tomcat 5.5.9 (runtime version also).
> Enhydra Conductor has no direct Tomcat version dependencies!
> 
> you wrote:
> --------------------------------------------------------------
> ----------
> 
> ...
> probably just forget it all and use mod_proxy instead, 
> like phoebe is (probably correctly) suggesting?
> 
> --------------------------------------------------------------
> -----------
> 
> I'm suggesting you to try out  mod_jk (JK) release first!
> NOTE: any testing  feedback from you would be appreciated (specially 
> before our Enhydra Conductor migration to JK).
> 
> Regards,
>   Slobodan Vujasinovic
> Enhydra Development Team
> 
> 
> 
> christoph moar wrote:
> 
> >Hello Phoebe,
> >thanks for your input, it is very valuable to me. In the meantime
> >i did manage to download: "enhydra-conductor-6.0-1.src.rpm"
> >and compile it on my platform (centos 4.1, alias redhat enterprise
> >x86_64 bit platform).
> >i had to make some changes in the SPEC file, i attach the patch
> >if anyone is interested.
> >
> >you write:
> >
> >  
> >
> >>rest. During testing, I notice the load balancing did work,
> >>but with heavy testing, the apache crashed with an error
> >>msg. I googled the message and found out it is a known
> >>problem. I also email other developers to verify they had
> >>the same problem. Then, I gave up the idea of using
> >>mod_jk2. 
> >>    
> >>
> >
> >this is serious info for me. can you tell me what error shows
> >up or the google links so i will monitor during our test phase 
> >and see if the same thing happens to me too? that would be
> >really helpful!
> >
> >  
> >
> >>I am now using mod_proxy and mod_rewrite to do
> >>simple load balancing (it is not pretty), but it works. 
> >>    
> >>
> >
> >yeah, i know. from what you say, i'll probably switch to
> >that also. since i already installed the conductor, i might
> >as well test it for a few days.
> >
> >  
> >
> >>Now, apache comes out with a new version, guess what, they
> >>no longer support mod_jk2. Therefore, I think it would not
> >>be a good idea to use mod_jk2. 
> >>    
> >>
> >
> >oh. didn't know that. what a mess, if you ask me. there's 
> >something like 5 different ways to connect tomcat to apache
> >and no stable one in sight? sigh! i heard also that they will
> >probably add a tomcat connector to mod_proxy, so maybe you
> >are right and that is the right way to do it? just don't
> >know.
> >
> >what i would like to know from the enhydra developers:
> >
> >know i have installed (on the production machine):
> >
> >enhydra-runtime-6.5-1
> >enhydra-conductor-6.0-1
> >
> >i do not know exactly what version of tomcat is in the
> >runtime and the conductor. do they (have to) match? should
> >i download the conductor tar.gz from the apache site
> >(which version?) instead? or should i probably just forget 
> >it all and use mod_proxy instead, like phoebe is 
> >(probably correctly) suggesting?
> >
> >any hints?
> >
> >and another thing: when i start apache i get:
> >[Wed Oct 12 18:02:04 2005] [error] jk2_init() Can't find 
> child 28796 in
> >scoreboard
> >[Wed Oct 12 18:02:04 2005] [error] mod_jk child init 1 -2
> >[Wed Oct 12 18:02:04 2005] [error] jk2_init() Can't find 
> child 28797 in
> >scoreboard
> >[Wed Oct 12 18:02:04 2005] [error] mod_jk child init 1 -2
> >[Wed Oct 12 18:02:04 2005] [error] jk2_init() Can't find 
> child 28799 in
> >scoreboard
> >[Wed Oct 12 18:02:04 2005] [error] mod_jk child init 1 -2
> >[Wed Oct 12 18:02:04 2005] [error] jk2_init() Can't find 
> child 28800 in
> >scoreboard
> >[Wed Oct 12 18:02:04 2005] [error] mod_jk child init 1 -2
> >[Wed Oct 12 18:02:04 2005] [error] jk2_init() Can't find 
> child 28801 in
> >scoreboard
> >[Wed Oct 12 18:02:04 2005] [error] mod_jk child init 1 -2
> >[Wed Oct 12 18:02:04 2005] [error] jk2_init() Can't find 
> child 28802 in
> >scoreboard
> >[Wed Oct 12 18:02:04 2005] [error] mod_jk child init 1 -2
> >[Wed Oct 12 18:02:04 2005] [error] jk2_init() Can't find 
> child 28803 in
> >scoreboard
> >[Wed Oct 12 18:02:04 2005] [error] mod_jk child init 1 -2
> >[Wed Oct 12 18:02:04 2005] [notice] Apache configured -- 
> resuming normal
> >operations
> >
> >i am still googl'in on this, but maybe anyone knows what it means?
> >the whole system seems to work fine, tough.
> >
> >regards
> >christoph
> >
> >--
> >http://www.alpin.it         software, consulting & strategy
> >
> >Christoph Moar                          Dipl. Inform. Univ.
> >alpin gmbh srl          management & technology consultants
> >tel +39 0471 056007 fax +39 0471 056005 gsm +39 348 3057012
> >lanciastr. 8b  via lancia 8b    bozen 39100 bolzano   italy
> >http://www.alpin.it                 christoph.moar@xxxxxxxx
> > 
> >
> >  
> >
> >>-----Original Message-----
> >>From: Phoebe Whitefield [mailto:pwhitefield@xxxxxxxxxxxx] 
> >>Sent: Wednesday, October 12, 2005 5:23 PM
> >>To: enhydra@xxxxxxxxxxxxx
> >>Subject: Re: [enhydra] how to download and install enhydra_conductor
> >>
> >>On Wed, 12 Oct 2005 10:24:56 +0200
> >> "christoph moar" <christoph.moar@xxxxxxxx> wrote:
> >>    
> >>
> >>>Hi,
> >>>i want to setup apache with tomcat/enhydra and have read
> >>>all the available
> >>>documentation. i had other projects where i used
> >>>mod_proxy alone or the
> >>>old enhydra director.
> >>>i read the documentation and i think what it says is that
> >>>the new mod_jk2
> >>>should be the state of the art to use. i tried reading
> >>>mod_webapp to see
> >>>if any of the other variants should be followed, but it
> >>>all sums up to me
> >>>that
> >>>all can connect tomcat to apache and maybe mod_jk2 should
> >>>be the one
> >>>to use. well, i'd say i'll try it.
> >>> 
> >>>the question is:
> >>>- on the production server i have installed
> >>>enhydra-6.5-runtime
> >>> 
> >>>how to i install the enhydra conductor now?
> >>>- should i download the tomcat sources and get mod_jk2
> >>>compiled?
> >>>- or should i download a rpm/tgz from enhydra
> >>>sourceforge?
> >>> 
> >>>i tried looking on the sourceforge page but could not
> >>>really find any link
> >>>there
> >>>to conductor. the only thing i found by googling was a
> >>>link to 
> >>> 
> >>>
> >>>      
> >>>
> >>https://forge.objectweb.org/project/download.php?group_id=21
> >>    
> >>
> >><https://forge.objectweb.org/project/download.php?group_id=21&;
> >>file_id=2687>
> >>    
> >>
> >>>&file_id=2687
> >>> 
> >>>which states this is conductor 6.0-1
> >>> 
> >>>is this what i should be using?
> >>> 
> >>>thanks and best regards for your response
> >>>christoph moar
> >>> 
> >>>
> >>>--
> >>>http://www.alpin.it <http://www.alpin.it/>
> >>>         software, consulting &
> >>>strategy
> >>>
> >>>Christoph Moar                          Dipl. Inform.
> >>>Univ.
> >>>alpin gmbh srl          management & technology
> >>>consultants
> >>>tel +39 0471 056007 fax +39 0471 056005 gsm +39 348
> >>>3057012
> >>>lanciastr. 8b  via lancia 8b    bozen 39100 bolzano
> >>>  italy
> >>>http://www.alpin.it <http://www.alpin.it/>
> >>>christoph.moar@xxxxxxxx
> >>>
> >>>
> >>>      
> >>>
> >>Hi,
> >>
> >>I had Enhydra 6.4.1 installed on my development machine and
> >>the production machine. In the production environment, we
> >>use apache as our web server. I also had to configure
> >>apache to talk to tomcat and do the load balancing. I
> >>downloaded mod_jk2, had the workers.properties and the
> >>rest. During testing, I notice the load balancing did work,
> >>but with heavy testing, the apache crashed with an error
> >>msg. I googled the message and found out it is a known
> >>problem. I also email other developers to verify they had
> >>the same problem. Then, I gave up the idea of using
> >>mod_jk2. I am now using mod_proxy and mod_rewrite to do
> >>simple load balancing (it is not pretty), but it works. 
> >>
> >>Now, apache comes out with a new version, guess what, they
> >>no longer support mod_jk2. Therefore, I think it would not
> >>be a good idea to use mod_jk2. 
> >>
> >>Hope this help. If you really would like to try out the
> >>mod_jk2. I can send you my configuration files and how I
> >>did my setup.
> >>
> >>Phoebe
> >>
> >>
> >>    
> >>
> >>------------------------------------------------------------
> ------------
> >>
> >>
> >>--
> >>You receive this message as a subscriber of the 
> enhydra@xxxxxxxxxxxxx mailing list.
> >>To unsubscribe: mailto:enhydra-unsubscribe@xxxxxxxxxxxxx
> >>For general help: mailto:sympa@xxxxxxxxxxxxx?subject=help
> >>ObjectWeb mailing lists service home page: 
> http://www.objectweb.org/wws
> >>    
> >>
> 
>