hibernate4 spring 3.1 struts2 dbcp连接错误

Question

本帖最后由 anquan230 于 2012-06-25 20:18:39 编辑

Answer 1

提供部分xml <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    <property name="url" value="jdbc:mysql://127.0.0.1:3306/tian"/>
    <property name="username" value="root"/>
    <property name="password" value="root"/>
   </bean>
<bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
    <property name="dataSource" ref="dataSource"/>
     <property name="packagesToScan">
      <list>
        <value>entity</value>
      </list>
     </property>
<property name="hibernateProperties">
      <value>
        hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
        hibernate.show_sql=true
      </value>
</property> 
</bean>

Answer 2

@Test
public void test() throws SQLException{ 


ApplicationContext context = new ClassPathXmlApplicationContext("ApplicationContext.xml");
UserService userservice=context.getBean("userservice",UserService.class);
Users u = new Users();
String username = UUID.randomUUID().toString().substring(0,3);
String password = UUID.randomUUID().toString().substring(0,3);
System.out.println(username);
System.out.println(password);
u.setUsername(username);
u.setPassword(password);
userservice.addUser(u);
}
2012-6-21 19:59:42 org.springframework.context.support.AbstractApplicationContext prepareRefresh
信息: Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@9f5011: startup date [Thu Jun 21 19:59:42 CST 2012]; root of context hierarchy
2012-6-21 19:59:42 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
信息: Loading XML bean definitions from class path resource [ApplicationContext.xml]
2012-6-21 19:59:43 org.springframework.beans.factory.support.DefaultListableBeanFactory preInstantiateSingletons
信息: Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@a45536: defining beans [dataSource,sessionFactory,transactionManager,transactionInterceptor,ProxyCreator,userdao,userservice,userAction]; root of factory hierarchy
2012-6-21 19:59:44 org.hibernate.annotations.common.Version <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {4.0.1.Final}
2012-6-21 19:59:44 org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {4.1.3.Final}
2012-6-21 19:59:44 org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
2012-6-21 19:59:44 org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
2012-6-21 19:59:45 org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQL5Dialect
2012-6-21 19:59:45 org.hibernate.engine.jdbc.internal.LobCreatorBuilder useContextualLobCreation
INFO: HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
2012-6-21 19:59:46 org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService
INFO: HHH000399: Using default transaction strategy (direct JDBC transactions)
2012-6-21 19:59:46 org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>
INFO: HHH000397: Using ASTQueryTranslatorFactory
2012-6-21 19:59:47 org.springframework.orm.hibernate4.HibernateTransactionManager afterPropertiesSet
信息: Using DataSource [org.apache.commons.dbcp.BasicDataSource@1257687] of Hibernate SessionFactory for HibernateTransactionManager
fa8
d1e
Hibernate: insert into Users (password, username) values (?, ?)