一个折磨我好几天的问题求大虾急救!!!

wangbiao 2007-04-05 11:15:22
我用spring配置hibernate+proxool
刚开始的用的hibnernate advance library 库里自带的proxool连接池的版本是0.0.8.3版本...
启动时会出现错误
到google上搜了一下换了最新版本的,在工程里移出了hibernate advance library..
用的是springDAO 然后新建了一个测试类 操作DAO 没有报错..可是数据库里面的记录
没有改变...

郁闷几天的问题..不知道我这么说 大家看明白没?
...全文
390 11 打赏 收藏 转发到动态 举报
写回复
用AI写文章
11 条回复
切换为时间正序
请发表友善的回复…
发表回复
wangbiao 2007-04-06
  • 打赏
  • 举报
回复
昨天的hibernate失误我都配置了
可是还是不好用 我在看看...谢谢
wangbiao 2007-04-06
  • 打赏
  • 举报
回复
PROXOOL.XML文件的内容...
<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
<proxool>
<alias>dbPool</alias>
<driver-url>jdbc:mysql://localhost/test</driver-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<driver-properties>
<property name="user" value="root"/>
<property name="password" value="root"/>
<property name="useUnicode" value="true"/>
<property name="characterEncoding" value="UTF-8"/>
</driver-properties>

<maximum-connection-count>100</maximum-connection-count>

<minimum-connection-count>10</minimum-connection-count>

<house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>

<house-keeping-sleep-time>90000</house-keeping-sleep-time>

</proxool>
</something-else-entirely>

applicationContext.xml文件....
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">

<beans>

<bean id="SessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">

<property name="hibernateProperties">
<props>
<prop key="hibernate.cglib.use_reflection_optimizer">true</prop>
<prop key="show_sql">true</prop>
<prop key="hibernate.dialect">
org.hibernate.dialect.MySQLDialect
</prop>
<prop key="hibernate.proxool.xml">Proxool.xml</prop>
<prop key="hibernate.proxool.pool_alias">dbPool</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>bean/Person.hbm.xml</value></list>
</property></bean>
<bean id="PersonDAO" class="bean.PersonDAO">
<property name="sessionFactory">
<ref bean="SessionFactory" />
</property>
</bean>
<bean id="baseService" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean" abstract="true">
<property name="transactionManager" ref="transactionManager" />
<property name="proxyTargetClass" value="true"/>
<property name="transactionAttributes">
<props>
<prop key="insert*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="save*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="update*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="del*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="*">PROPAGATION_REQUIRED,readOnly</prop>
</props>
</property>
</bean>

<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref bean="SessionFactory" />
</property>
</bean>
</beans>

大家还是帮忙看看吧..
wangbiao 2007-04-06
  • 打赏
  • 举报
回复
郁闷发错行了
wangbiao 2007-04-06
  • 打赏
  • 举报
回复
PROXOOL.XML文件的内容...
<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
<proxool>
<alias>dbPool</alias>
<driver-url>jdbc:mysql://localhost/test</driver-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<driver-properties>
<property name="user" value="root"/>
<property name="password" value="root"/>
<property name="useUnicode" value="true"/>
<property name="characterEncoding" value="UTF-8"/>
</driver-properties>

applicationContext.xml文件....
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">

<beans>

<bean id="SessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">

<property name="hibernateProperties">
<props>
<prop key="hibernate.cglib.use_reflection_optimizer">true</prop>
<prop key="show_sql">true</prop>
<prop key="hibernate.dialect">
org.hibernate.dialect.MySQLDialect
</prop>
<prop key="hibernate.proxool.xml">Proxool.xml</prop>
<prop key="hibernate.proxool.pool_alias">dbPool</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>bean/Person.hbm.xml</value></list>
</property></bean>
<bean id="PersonDAO" class="bean.PersonDAO">
<property name="sessionFactory">
<ref bean="SessionFactory" />
</property>
</bean>
<bean id="baseService" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean" abstract="true">
<property name="transactionManager" ref="transactionManager" />
<property name="proxyTargetClass" value="true"/>
<property name="transactionAttributes">
<props>
<prop key="insert*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="save*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="update*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="del*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="*">PROPAGATION_REQUIRED,readOnly</prop>
</props>
</property>
</bean>

<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref bean="SessionFactory" />
</property>
</bean>
</beans>

大家还是帮忙看看吧..

<maximum-connection-count>100</maximum-connection-count>

<minimum-connection-count>10</minimum-connection-count>

<house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>

<house-keeping-sleep-time>90000</house-keeping-sleep-time>

</proxool>
</something-else-entirely>
谜斯特段 2007-04-06
  • 打赏
  • 举报
回复
log4j应该打印出insert 或update之类的语句,如果没有的话,就是配置问题,或是根本没执行到saveorupdate,调试一下。
rickhunterchen 2007-04-05
  • 打赏
  • 举报
回复
看看是否执行了SQL语句。
jianghuxing 2007-04-05
  • 打赏
  • 举报
回复
事务没有提交,
配上spring 的事务代理,让其自动代理事务就ok了。

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="url">
<value>jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=springch3</value>
</property>
<property name="username">
<value>sa</value>
</property>
<property name="password">
<value></value>
</property>
<property name="driverClassName">
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</property>
</bean>

<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource"/>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</prop>
<prop key="hibernate.connection.autocommit">false</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>com/xaccp/config/BrowRecoder.hbm.xml</value>
<value>com/xaccp/config/Customer.hbm.xml</value>
</list>
</property>
</bean>



<bean id="CustomerDAO" class="com.xaccp.database.dao.CustomerDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<bean id="BrowRecoderDAO"
class="com.xaccp.database.dao.BrowRecoderDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>

<bean id="BrowService" class="com.xaccp.service.Browservice">
<property name="browRecoderDAO">
<ref bean="BrowRecoderDAO"/>
</property>
<property name="customerDAO">
<ref bean="CustomerDAO"/>
</property>
</bean>


<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref bean="sessionFactory"/>
</property>
</bean>
<!-- 绗竴绉嶄唬鐞嗘柟娉?-->
<bean id="BrowManagerProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager">
<ref bean="transactionManager"/>
</property>
<property name="transactionAttributes">
<props>
<prop key="save*">PROPAGATION_REQUIRED,-java.lang.Exception</prop>
<prop key="updata*">PROPAGATION_REQUIRED,-java.lang.Exception</prop>
</props>
</property>
<property name="proxyInterfaces">
<list>
<value>com.xaccp.business.BrowManager</value>
</list>
</property>
<property name="target">
<ref bean="BrowService"/>
</property>
</bean>


<!-- 绗簩绉嶈缃唬鐞嗙殑鏂规硶锛屽彲浠ユ妸姝や唬鐞嗚缃负涓€涓娊璞$殑 -->
<bean id="trasactionProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean" abstract="true">
<property name="transactionManager">
<ref bean="transactionManager"/>
</property>
<property name="transactionAttributes">
<props>
<prop key="save*">PROPAGATION_REQUIRED,-java.lang.Exception</prop>
<prop key="updata*">PROPAGATION_REQUIRED,-java.lang.Exception</prop>
</props>
</property>

</bean>
wangbiao 2007-04-05
  • 打赏
  • 举报
回复
配置log4j了...

没有任何错误就是数据库里面没有记录...郁闷死我了...
wangbiao 2007-04-05
  • 打赏
  • 举报
回复
我用的DAO类是继承HibernateDAOSupport的
用hibernate摸版进行数据库的操作

按理说 不用我自己commit()啊...
dreamover 2007-04-05
  • 打赏
  • 举报
回复
trans.commit();
likgui 2007-04-05
  • 打赏
  • 举报
回复
看看服务器的日志文件,应该有报错!

67,513

社区成员

发帖
与我相关
我的任务
社区描述
J2EE只是Java企业应用。我们需要一个跨J2SE/WEB/EJB的微容器,保护我们的业务核心组件(中间件),以延续它的生命力,而不是依赖J2SE/J2EE版本。
社区管理员
  • Java EE
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧