Hi..i am calling a method where i am selecting a row from DB,
this is happening n no of times....bt after somoe no of select statement, connecttion has been lost.
Is there any type of limitation with no of select with hibernate.
or any issue with .hbm file...
my .hbm file is as follows.

<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
      <property name="hibernate.connection.url">jdbc:oracle:thin:@</property>
      <property name="hibernate.connection.username">tbaadm</property>
      <property name="hibernate.connection.password">1qasd3</property>
      <property name="hibernate.connection.pool_size">10</property>
      <property name="show_sql">true</property>
      <property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
      <property name="hibernate.hbm2ddl.auto">update</property>
      <!-- Mapping files -->
      <mapping resource="MTHT.hbm.xml"/>
      <mapping resource="MTDT.hbm.xml"/>

Please help.

Could you give some more details? What code are you calling and how are you selecting?