Hi, I'm using spring 2.5.6, hibernate 3, Oracle 11g and Jboss 5

my spring-hibernate.xml is:

<beans>
<bean id="adminDataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="${jdbc.driverClassName}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</bean>

<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSes sionFactoryBean">
<property name="dataSource" ref="adminDataSource"/>

<property name="mappingDirectoryLocations">
<list>
<value>WEB-INF/classes</value>
</list>
</property>

<property name="hibernateProperties">
<props>

<prop key="hibernate.dialect">org.hibernate.dialect.Orac le10gDialect</prop>
<prop key="hibernate.show_sql">false</prop>
<prop key="hibernate.hbm2ddl.auto">validate</prop>
<prop key="hibernate.c3p0.minPoolSize">5</prop>
<prop key="hibernate.c3p0.maxPoolSize">50</prop>
<prop key="hibernate.c3p0.timeout">0</prop>
<prop key="hibernate.c3p0.max_statement">55</prop>
<prop key="hibernate.bytecode.use_reflection_optimizer"> true</prop>
<prop key="hibernate.cache.use_query_cache">false</prop>
<prop key="hibernate.c3p0.idle_test_period">2000</prop>
<prop key="hibernate.c3p0.numHelperThreads">20</prop>

</props>
</property>
</bean>

<bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.Hibernat eTemplate">
<property name="sessionFactory">
<ref bean="sessionFactory"/>
</property>
</bean>
</beans>

the application is client-server developed using java, when the server application is trying to make a query occurs the following error:

WARN http-10.0.1.12-8443-4 2010-10-29 08:14:27,961 org.hibernate.util.JDBCExceptionReporter: SQL Error: 17002, SQLState: 08006
ERROR http-10.0.1.12-8443-4 2010-10-29 08:14:27,961 org.hibernate.util.JDBCExceptionReporter: IO Error: Connection timed out (errno:238)

Caused by: java.sql.SQLRecoverableException: IO Error: Connection timed out (errno:238)
at oracle.jdbc.driver.T4CPreparedStatement.executeFor Describe(T4CPreparedStatement.java:874)
at oracle.jdbc.driver.OracleStatement.executeMaybeDes cribe(OracleStatement.java:1145)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1267)
at oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.execute Query(OraclePreparedStatement.java:3493)
at oracle.jdbc.driver.OraclePreparedStatementWrapper. executeQuery(OraclePreparedStatementWrapper.java:1 491)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery(DelegatingPreparedStatement.java:92 )
at org.hibernate.jdbc.AbstractBatcher.getResultSet(Ab stractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.ja va:1808)
at org.hibernate.loader.Loader.doQuery(Loader.java:69 7)
at org.hibernate.loader.Loader.doQueryAndInitializeNo nLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:222 8)
... 42 more
Caused by: java.net.SocketException: Connection timed out (errno:238)
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream. java:134)
at oracle.net.ns.Packet.receive(Packet.java:282)
at oracle.net.ns.DataPacket.receive(DataPacket.java:1 03)
at oracle.net.ns.NetInputStream.getNextPacket(NetInpu tStream.java:230)
at oracle.net.ns.NetInputStream.read(NetInputStream.j ava:175)
at oracle.net.ns.NetInputStream.read(NetInputStream.j ava:100)
at oracle.net.ns.NetInputStream.read(NetInputStream.j ava:85)
at oracle.jdbc.driver.T4CSocketInputStreamWrapper.rea dNextPacket(T4CSocketInputStreamWrapper.java:122)
at oracle.jdbc.driver.T4CSocketInputStreamWrapper.rea d(T4CSocketInputStreamWrapper.java:78)
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMA REngine.java:1179)
at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMA REngine.java:1155)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.jav a:279)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java: 186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:5 21)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4 CPreparedStatement.java:205)
at oracle.jdbc.driver.T4CPreparedStatement.executeFor Describe(T4CPreparedStatement.java:861)
... 53 more

This problem is solvented when the server is restarted.

Hope you can help us.