主题 : 启动时报sql异常 |
级别: 版主
|
21# 发表于:2015-05-21 13:52:09 IP:111.17.*.*
|
||||
---|---|---|---|---|---|
级别: 会元
|
22# 发表于:2015-05-21 13:56:19 IP:58.137.*.*
我这有原版的 数据源文件好像没人动 但是后台也是报标示符无效这个错误 这个错误是什么原因导致的呢?
|
||
---|---|---|---|
级别: 版主
|
25# 发表于:2015-05-21 14:03:18 IP:111.17.*.*
包名里带个dao的都是,语句都是写在dao层的,我建议你源码和数据库都用未修改的初始版本试下
|
||
---|---|---|---|
级别: 会元
|
26# 发表于:2015-05-21 14:04:50 IP:58.137.*.*
hbm.XML文件啥的 还有 application-context 配置文件 假如说变更数据库的话 需不需要动
|
||
---|---|---|---|
级别: 会元
|
28# 发表于:2015-05-21 14:12:29 IP:58.137.*.*
jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@192.168.128.60:1521:hbyt jdbc.username=user jdbc.password=us cpool.checkoutTimeout=50000 cpool.minPoolSize=20 cpool.maxPoolSize=50 cpool.maxIdleTime=7200 cpool.maxIdleTimeExcessConnections=1800 cpool.acquireIncrement=10 <?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:jee="http://www.springframework.org/schema/jee" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd" default-lazy-init="true"> <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="locations"> <list> <value>jdbc.properties</value> </list> </property> </bean> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="driverClass" value="${jdbc.driverClassName}" /> <property name="jdbcUrl" value="${jdbc.url}" /> <property name="user" value="${jdbc.username}" /> <property name="password" value="${jdbc.password}" /> <property name="autoCommitOnClose" value="true"/> <property name="checkoutTimeout" value="${cpool.checkoutTimeout}"/> <property name="initialPoolSize" value="${cpool.minPoolSize}"/> <property name="minPoolSize" value="${cpool.minPoolSize}"/> <property name="maxPoolSize" value="${cpool.maxPoolSize}"/> <property name="maxIdleTime" value="${cpool.maxIdleTime}"/> <property name="acquireIncrement" value="${cpool.acquireIncrement}"/> <property name="maxIdleTimeExcessConnections" value="${cpool.maxIdleTimeExcessConnections}"/> </bean> <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> <property name="dataSource" ref="dataSource"/> <property name="mappingLocations"> <list> <value>classpath*:/com/cvicse/core/entity/hbm/*.hbm.xml</value> <value>classpath*:/com/cvicse/cms/entity/main/hbm/*.hbm.xml</value> <value>classpath*:/com/cvicse/cms/entity/assist/hbm/*.hbm.xml</value> <value>classpath*:/com/cvicse/cms/entity/nlg/hbm/*.hbm.xml</value> </list> </property> <property name="hibernateProperties"> <value> hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect hibernate.show_sql=false hibernate.format_sql=false hibernate.query.substitutions=true 1, false 0 hibernate.jdbc.batch_size=20 hibernate.cache.use_query_cache=true </value> </property> <property name="entityInterceptor"> <ref local="treeInterceptor"/> </property> <property name="cacheProvider"> <ref local="cacheProvider"/> </property> <property name="lobHandler"> <ref bean="lobHandler" /> </property> </bean> <bean id="lobHandler" class="org.springframework.jdbc.support.lob.DefaultLobHandler" lazy-init="true"/> <bean id="cacheProvider" class="com.cvicse.common.hibernate3.SpringEhCacheProvider"> <property name="configLocation"> <value>classpath:ehcache-hibernate.xml</value> </property> <property name="diskStoreLocation"> <value>/WEB-INF/cache/hibernate</value> </property> </bean> <bean id="treeInterceptor" class="com.cvicse.common.hibernate3.TreeIntercptor"/> <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"> <property name="sessionFactory" ref="sessionFactory" /> </bean> <context:annotation-config/> <tx:annotation-driven transaction-manager="transactionManager" /> </beans> |
||
---|---|---|---|
级别: 会元
|
29# 发表于:2015-05-21 14:13:31 IP:58.137.*.*
这是jdbc和application-context配置文件 您看看
|
||
---|---|---|---|