Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:2.16
Name and version of the database you are using: SQLServer 2000

hi,
i'm using hibernate with proxool in one application ,my proxool connection configure is:


Proxool.properties:
jdbc-0.proxool.alias=property-name
jdbc-0.proxool.driver-url=jdbc:microsoft:sqlserver://10.1.0.7:1433;DatabaseName=ngtc0922;SelectMethod=cursor
jdbc-0.proxool.driver-class=com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc-0.user=sa
jdbc-0.password=ngtc123
jdbc-0.proxool.house-keeping-sleep-time=40000
jdbc-0.proxool.house-keeping-test-sql=selectCURRENT_DATE
jdbc-0.proxool.maximum-connection-count=50
jdbc-0.proxool.minimum-connection-count=3
jdbc-0.proxool.maximum-connection-lifetime=18000000
jdbc-0.proxool.simultaneous-build-throttle=5
jdbc-0.proxool.recently-started-threshold=40000
jdbc-0.proxool.overload-without-refusal-lifetime=50000
jdbc-0.proxool.maximum-active-time=60000
jdbc-0.proxool.verbose=true
jdbc-0.proxool.trace=true
jdbc-0.proxool.fatal-sql-exception=Fatalerror
jdbc-0.proxool.prototype-count=2




hibernate.cfg.xml configure is:
<hibernate-configuration>
<session-factory>
<property name="hibernate.connection.provider_class">net.sf.hibernate.connection.ProxoolConnectionProvider</property>
<property name="hibernate.proxool.pool_alias">property-name</property>
<property name="hibernate.proxool.properties">proxool.properties</property>

<property name="dialect">net.sf.hibernate.dialect.SQLServerDialect</property>

<property name="show_sql">false</property>

<mapping resource="config/TestUser.hbm.xml"/>
</session-factory>


</hibernate-configuration>



my app server is jboss4.0.4,jboss print :

13:35:38,031 INFO [STDOUT] 13:35:38,031 WARN [proxool-hibernate] #0002 was act
ive for 91110 milliseconds and has been removed automaticaly. The Thread respons
ible was named 'TP-Processor2', and the last SQL it performed is 'select voiture
oil0_.VoitureID as VoitureID__, voitureoil0_.OilId as OilId__, voitureoil0_.OilI
d as OilId0_, voitureoil0_.Time as Time0_, voitureoil0_.Remark as Remark0_, voit
ureoil0_.CreateUserId as CreateUs4_0_, voitureoil0_.CreateDate as CreateDate0_,
voitureoil0_.ModiUserId as ModiUserId0_, voitureoil0_.RegisterMan as Register7_0
_, voitureoil0_.InvoiceNumber as InvoiceN8_0_, voitureoil0_.ModiDate as ModiDate
0_, voitureoil0_.RegisterTime as Registe10_0_, voitureoil0_.OilShop as OilShop0_
, voitureoil0_.OilFee as OilFee0_, voitureoil0_.OilSum as OilSum0_, voitureoil0_
.OilMan as OilMan0_, voitureoil0_.OilPrice as OilPrice0_, voitureoil0_.VoitureID
as VoitureID0_ from ngtc_oa_voiture_oil voitureoil0_ where voitureoil0_.Voiture
ID='402849fa0dd4d8db010dd4e4e1480001'; '.

and ,when i access page again ,it throw excption :
java.sql.SQLException: Couldn't perform the operation prepareStatement: You can'
t perform any operations on this connection. It has been automatically closed by
Proxool for some reason (see logs).
at org.logicalcobwebs.proxool.WrappedConnection.invoke(WrappedConnection
.java:207)
at org.logicalcobwebs.proxool.WrappedConnection.intercept(WrappedConnect
ion.java:87)
at com.microsoft.jdbc.extensions.ExtEmbeddedConnection$$EnhancerByCGLIB$
$6dc1c695.prepareStatement(<generated>)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.ja
va:257)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.ja
va:232)
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.j

Could anyone help me?




The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html