tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Busfy,Peter" <Peter.Bu...@drei.com>
Subject RE: tomcat and DB oracle problem - only in higher versions
Date Fri, 17 Aug 2012 07:29:14 GMT
Hello Chris,

so we running from Eclipse on Tomcat.
In Tomcat server.xml we specify datasource:

<Resource auth="Container" driverClassName="oracle.jdbc.OracleDriver" maxActive="20" maxIdle="10"
maxWait="-1" name="jdbc/someName" password="somePassword" type="javax.sql.DataSource" url="jdbc:oracle:thin:@host:port:dbname"
username="someUsername"/>

And here is main database configuration xml:

<beans>

        <bean id="dataSource_Name"
                class="org.springframework.jndi.JndiObjectFactoryBean">
                <property name="jndiName">
                        <value>java:comp/env/jdbc/someName</value>
                </property>
        </bean>


        <bean id="hibernateTemplate_Name"
                class="org.springframework.orm.hibernate3.HibernateTemplate">
                <property name="sessionFactory">
                        <ref bean="sessionFactory_Name" />
                </property>
        </bean>


        <bean id="transactionManager_Name"
                class="org.springframework.orm.hibernate3.HibernateTransactionManager">
                <property name="sessionFactory">
                        <ref local="sessionFactory_XXX" />
                </property>
        </bean>


        <bean id="sessionFactory_Name"
                class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
                <property name="dataSource">
                        <ref bean="dataSource_Name" />
                </property>
                <property name="mappingResources">
                        <list>
        .... some values mappind DB tables......
                        </list>
                </property>
                <property name="hibernateProperties">
                        <props>
                                <prop key="hibernate.dialect">
                                        org.hibernate.dialect.Oracle10gDialect
                                </prop>
                                <prop key="hibernate.connection.release_mode">
                                        auto
                                </prop>
                        </props>
                </property>
                <property name="lobHandler"><ref local="oracleLobHandler_Name"/></property>
        </bean>

        <bean id="oracleLobHandler_Name"  class="org.springframework.jdbc.support.lob.OracleLobHandler"
lazy-init="true">
                <property name="nativeJdbcExtractor">
                        <ref local="nativeJdbcExtractor_Name" />
                </property>
        </bean>

        <bean id="nativeJdbcExtractor_Name" class="org.springframework.jdbc.support.nativejdbc.SimpleNativeJdbcExtractor"
lazy-init="true"/>

</beans>

Best Regards

Peter Busfy
3 Portal

Hutchison 3G Austria GmbH
Gasometer C
Guglgasse 12/10/3
1110 Vienna
Mobil: +43-660-7313346
mailto:peter.busfy@drei.com
http://www.drei.at





-----Original Message-----
From: cjderham@gmail.com [mailto:cjderham@gmail.com] On Behalf Of chris derham
Sent: Thursday, August 16, 2012 4:59 PM
To: Tomcat Users List
Subject: Re: tomcat and DB oracle problem - only in higher versions

>
> I found following problem when java application is trying save xml
> data into xml column to database. ****
>
> I found a problem with tomcat which is happening in the version 6.0.32
> and
> 6.0.35 (maybe also in other version), but working really fine with
> version
> 6.0.26.****
>
> ** **
>
> My configuration:****
>
> ** **
>
> OS: windows 7 enterprise****
>
> IDE: Eclipse EE 3.7.1****
>
> Java: 1.6.0_33****
>
> Tomcat: 6.0.26, 6.0.32, 6.0.35****
>
> DB: Oracle Database 11g Enterprise Edition 11.2.0.3.0****
>
> Other technologies: Spring 3.1.1 + Hibernate 3 + Struts 1.1****
>
>
>
Can you provide details of how you create your connection to the database?
Config file or code? This should shed some light on the issue. I recall that I hit this in
the past, and it is to do with how the connection pool is setup. Perhaps with the details,
it might ring some bells for me or somebody else.

Thanks

Chris

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message