Werner,
I have an error with your correction.
The error is:
javax.servlet.ServletException: Nested error: org.xml.sax.SAXException:
unable to add attribute "min-limit" to
'oracle.jdbc.pool.OracleConnectionCacheImpl' due to the following error:
org.exolab.castor.mapping.MappingRuntimeException: Nested error:
java.sql.SQLException
In this case my xml file is:
<?xml version="1.0"?>
<database name="osame" engine="oracle" >
<data-source
class-name="oracle.jdbc.pool.OracleConnectionCacheImpl">
<params URL="jdbc:oracle:thin:@ myServer:1521:myBase " user="
user" password=" pwd " min-limit="5" max-limit="10"
cache-scheme="OracleConnectionCacheImpl.DYNAMIC_SCHEME"/>
</data-source>
<mapping href="osameMapping.xml" />
</database>
I have tested other syntax without error.
But, in this case, the pool is not active.
One Oracle physical connection is created only for the execute query,
not for begin transaction.
Is it normal?
For this case, my xml file is:
<?xml version="1.0"?>
<database name="myBase" engine="oracle" >
<data-source
class-name="oracle.jdbc.pool.OracleConnectionCacheImpl">
<params URL="jdbc:oracle:thin:@myServer:1521:myBase" user="user"
password="pwd" minLimit="5" maxLimit="10"
cacheScheme="OracleConnectionCacheImpl.DYNAMIC_SCHEME"/>
</data-source>
<mapping href="Mapping.xml" />
</database>
Patrice
-----Message d'origine-----
De�: Werner Guttmann [mailto:[EMAIL PROTECTED]
Envoy�: jeudi 4 mars 2004 12:27
��: [EMAIL PROTECTED]; Patrice Fleurier; [EMAIL PROTECTED]
Objet�: Re: [castor-dev] Problem with connections pooling for Oracle
Patrice,
please make this
<?xml version="1.0"?>
<database name="myBase" engine="oracle" >
<data-source
class-name="oracle.jdbc.pool.OracleConnectionCacheImpl">
<params user="user" password="pwd" min-limit="5" max-limit="10"
cache-scheme="OracleConnectionCacheImpl.DYNAMIC_SCHEME" .... />
</data-source>
<mapping href="Mapping.xml" />
</database>
and things should work.
Werner
On Thu, 04 Mar 2004 03:02:46 -0700, Bruce Snyder wrote:
>Werner Guttmann wrote:
>
>> Patrice,
>>
>> I have just been pointed to online documentation for this Oracle
class mentioned below. As OracleConnectionCacheImpl implements
>> javax.sql.DataSource, you will have to use the <data-source> element
to configure all this. Please note that due to still existing
inconsistencies you will
>> have to use a different syntax, though.
>>
>> <?xml version="1.0"?>
>> <database name="myBase" engine="oracle" >
>> <data-source
class-name="oracle.jdbc.pool.OracleConnectionCacheImpl">
>> <params user="user" password="pwd" minLimit="5" maxLimit="10"
cacheScheme="OracleConnectionCacheImpl.DYNAMIC_SCHEME" .... />
>> </data-source>
>> <mapping href="Mapping.xml" />
>> </database>
>
>Until your fix is checked in this will not work. Castor will not set
the
>minLimit, maxLimit or cachSchema variables because it has no prior
>knowledge of these variables.
>
>Bruce
>--
>perl -e 'print
>unpack("u30","<0G)[EMAIL PROTECTED]&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'
>
>The Castor Project
>http://www.castor.org/
>
>Apache Geronimo
>http://incubator.apache.org/projects/geronimo.html
>
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.610 / Virus Database: 390 - Release Date: 03/03/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.610 / Virus Database: 390 - Release Date: 03/03/2004
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
