这个工程只有jsp和hibernate配置文件(只有web和src文件夹),我要用jsp调用hib操作数据库,实体怎么办,可不可以用jsp当,我不能该工程结构。我用jsp写的代码段通过hibernate.cfg.xml创建的session操作库的。配置文件太多,粘部分:======================1.xml==============================<bean id="gov.annexDAO" class="gov.annex.dao.AnnexDAO">  <property name="sessionFactory" ref="sessionFactory" /> </bean>  <bean id="annex.AnnexServiceImpl" parent="basicTxProxy">  <property name="target">   <bean class="gov.annex.service.impl.AnnexServiceImpl">    <property name="annexDAO" ref="gov.annexDAO"/>   </bean>  </property> </bean>===================2.xml======================<bean id="dataSource"  class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">  <property name="driverClassName"   value="${hibernate.connection.driver_class}" />  <property name="url" value="${hibernate.connection.url}" />  <property name="username"   value="${hibernate.connection.username}" />  <property name="password"   value="${hibernate.connection.password}" /> </bean><bean id="sessionFactory"  class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">  <property name="dataSource" ref="dataSource" />  <property name="mappingDirectoryLocations">   <list>    <value>classpath:</value>   </list>  </property>  <property name="hibernateProperties">   <props>    <prop key="hibernate.dialect">     ${hibernate.dialect}    </prop>    <prop key="hibernate.cache.provider_class">     ${hibernate.cache.provider_class}    </prop>    <prop key="hibernate.cache.use_query_cache">true</prop>    <!-- prop key="hibernate.jdbc.batch_size">0</prop>     <prop key="hibernate.connection.pool_size">3</prop -->    <prop key="hibernate.show_sql">      ${hibernate.show_sql}    </prop>    <prop key="hibernate.query.factory_class">     ${hibernate.query.factory_class}    </prop>   </props>  </property>  <property name="mappingJarLocations">           <list>     <value>WEB-INF/lib/gov_annex.jar</value>           </list>       </property>  <property name="lobHandler" ref="${jdbc.handler}" /> </bean>

解决方案 »

  1.   

    tomcat配置文件下有连接了:
    <?xml version="1.0" encoding="UTF-8"?>
    <Context displayName="" docBase="D:\work\xzxk_nj\web" path="" debug="1">
    <Resource name="wegovDataSource" auth="Container" type="javax.sql.DataSource" url="jdbc:oracle:thin:@10.1.43.9:1521:orcl" driverClassName="oracle.jdbc.driver.OracleDriver" username="xzxk4" password="xzxk4" maxWait="3000" maxIdle="10" maxActive="20" removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"/>


    </Context>
      

  2.   

    我想用jdbc,自己建个配置文件(hibernate.cfg.xml) 
    <session-factory>
    <property name="connection.datasource"> 
    java:comp/env/wegovDataSource
    </property> 

    <property name="dialect">
    org.hibernate.dialect.Oracle9Dialect
    </property> </session-factory> ,
    一执行sql语句就报错Not supported by BasicDataSource,把配置文件改成直接连数据库的也出同样问题。