配置文件<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"><beans>
<!-- 加载 properties 文件 -->
<bean id="placeholderConfig"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location">
<value>/properties/OracleDataSoures.properties</value>
</property>
</bean>
<!-- 数据源 -->
<bean id="myDataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
<value>${datasource.driverClassName}</value>
</property>
<property name="url">
<value>${datasource.url}</value>
</property>
<property name="username">
<value>${datasource.username}</value>
</property>
<property name="password">
<value>${datasource.password}</value>
</property>
</bean>
<!-- 数据源 --><!--数据库会话工厂 -->
<bean id="mySessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"
singleton="true">
<property name="dataSource">
<ref local="myDataSource" />
</property>
<property name="mappingResources">
<list>
<value>com/hibernate/Dept.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
${hibernate.dialect}
</prop>
<prop key="hibernate.show_sql">
${hibernate.show_sql}
</prop>
<!--<prop key="hibernate.jdbc.fetch_size">
${hibernate.jdbc.fetch_size}
</prop>
<prop key="hibernate.jdbc.batch_size">
${hibernate.jdbc.batch_size}
</prop>
<prop key="hibernate.connection.release_mode">
${hibernate.connection.release_mode}
</prop>
<prop key='hibernate.query.factory_class'>
${hibernate.query.factory_class}
</prop>
--></props>
</property>
</bean>
<!--数据库会话工厂 -->
<!-- 事务管理器 -->
<bean id="myTransactionManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref local="mySessionFactory" />
</property>
</bean>
<!-- 事务管理器 -->
<!-- Spring 事务管理器代理 -->
<bean id="myTransactionProxyFactoryBean" lazy-init="true"
class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager">
<ref bean="myTransactionManager" />
</property>
<property name="transactionAttributes">
<props>
<prop key="create*">PROPAGATION_REQUIRED</prop>
<prop key="update*">PROPAGATION_REQUIRED</prop>
<prop key="delete*">PROPAGATION_REQUIRED</prop>
<prop key="save*">PROPAGATION_REQUIRED</prop>
<prop key="move*">PROPAGATION_REQUIRED</prop>
<prop key="*">PROPAGATION_REQUIRED,readOnly</prop>
</props>
</property>
</bean>
<!-- Spring 事务管理器代理 --><!-- 切面 -->
<bean id="userImp" class="com.dao.user.impl.UserImpl">
<property name="sessionFactory">
<ref local="mySessionFactory" />
</property>
</bean>
<!-- 切面 -->
<!-- 代理 --><bean id="user_proxy" parent="myTransactionProxyFactoryBean">
<property name="target">
<ref local="userImp"/>
</property>
</bean>
<!-- 代理 --></beans>
我想测试是否连接上数据库
package com;import java.sql.SQLException;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
public class Test {
public static void main(String[] args) throws SQLException {
ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
org.springframework.jdbc.datasource.DriverManagerDataSource temp = (org.springframework.jdbc.datasource.DriverManagerDataSource) context.getBean("myDataSource");
System.out.println(temp.getConnection());
}}
报错
Exception in thread "main" java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:291)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:277)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:259)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:240)
at com.Test.main(Test.java:26)我的驱动包导入到了lib文件下,放在了Classpath请问是什么原因,困惑死我了,麻烦那位大侠看下谢谢
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"><beans>
<!-- 加载 properties 文件 -->
<bean id="placeholderConfig"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location">
<value>/properties/OracleDataSoures.properties</value>
</property>
</bean>
<!-- 数据源 -->
<bean id="myDataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
<value>${datasource.driverClassName}</value>
</property>
<property name="url">
<value>${datasource.url}</value>
</property>
<property name="username">
<value>${datasource.username}</value>
</property>
<property name="password">
<value>${datasource.password}</value>
</property>
</bean>
<!-- 数据源 --><!--数据库会话工厂 -->
<bean id="mySessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"
singleton="true">
<property name="dataSource">
<ref local="myDataSource" />
</property>
<property name="mappingResources">
<list>
<value>com/hibernate/Dept.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
${hibernate.dialect}
</prop>
<prop key="hibernate.show_sql">
${hibernate.show_sql}
</prop>
<!--<prop key="hibernate.jdbc.fetch_size">
${hibernate.jdbc.fetch_size}
</prop>
<prop key="hibernate.jdbc.batch_size">
${hibernate.jdbc.batch_size}
</prop>
<prop key="hibernate.connection.release_mode">
${hibernate.connection.release_mode}
</prop>
<prop key='hibernate.query.factory_class'>
${hibernate.query.factory_class}
</prop>
--></props>
</property>
</bean>
<!--数据库会话工厂 -->
<!-- 事务管理器 -->
<bean id="myTransactionManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref local="mySessionFactory" />
</property>
</bean>
<!-- 事务管理器 -->
<!-- Spring 事务管理器代理 -->
<bean id="myTransactionProxyFactoryBean" lazy-init="true"
class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager">
<ref bean="myTransactionManager" />
</property>
<property name="transactionAttributes">
<props>
<prop key="create*">PROPAGATION_REQUIRED</prop>
<prop key="update*">PROPAGATION_REQUIRED</prop>
<prop key="delete*">PROPAGATION_REQUIRED</prop>
<prop key="save*">PROPAGATION_REQUIRED</prop>
<prop key="move*">PROPAGATION_REQUIRED</prop>
<prop key="*">PROPAGATION_REQUIRED,readOnly</prop>
</props>
</property>
</bean>
<!-- Spring 事务管理器代理 --><!-- 切面 -->
<bean id="userImp" class="com.dao.user.impl.UserImpl">
<property name="sessionFactory">
<ref local="mySessionFactory" />
</property>
</bean>
<!-- 切面 -->
<!-- 代理 --><bean id="user_proxy" parent="myTransactionProxyFactoryBean">
<property name="target">
<ref local="userImp"/>
</property>
</bean>
<!-- 代理 --></beans>
我想测试是否连接上数据库
package com;import java.sql.SQLException;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
public class Test {
public static void main(String[] args) throws SQLException {
ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
org.springframework.jdbc.datasource.DriverManagerDataSource temp = (org.springframework.jdbc.datasource.DriverManagerDataSource) context.getBean("myDataSource");
System.out.println(temp.getConnection());
}}
报错
Exception in thread "main" java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:291)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:277)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:259)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:240)
at com.Test.main(Test.java:26)我的驱动包导入到了lib文件下,放在了Classpath请问是什么原因,困惑死我了,麻烦那位大侠看下谢谢
解决方案 »
- String.formak里面的%s,%d怎么用的?求解!
- myeclise ssh 出现的问题,求解惑
- itext 生成报表
- hql order by 问题
- java 导入数据库
- [300分]在jsp页面中如何有效的统计在线用户(只要浏览该网站,而且把登陆的用户的用户名显示出来,如果没有登入显示游客,当然有多
- spring +ibatis数据库连接异常(Cannot create PoolableConnectionFactory )
- 请问哪里有netscape的ldap server 下载?
- 求救,jdbc远程连接别的电脑数据库出错
- 请问关于SpringMVC的自定义异常的问题。
- JDBC问题,请指教
- Appfuse启动时报如下错误
datasource.url=jdbc:oralce:thin:@localhost:1521:luowei
datasource.username=scott
datasource.password=tigerdatasource.maxActive=10
datasource.maxIdle=2
datasource.maxWait=12000
datasource.whenExhaustedAction=1
datasource.validationQuery=select 1 from dual
datasource.testOnBorrow=true
datasource.testOnReturn=falsec3p0.acquireIncrement=3
c3p0.initialPoolSize=3
c3p0.idleConnectionTestPeriod=900
c3p0.minPoolSize=2
c3p0.maxPoolSize=50
c3p0.maxStatements=100
c3p0.numHelperThreads=10
c3p0.maxIdleTime=600hibernate.dialect=org.hibernate.dialect.Oracle9Dialecthibernate.jdbc.batch_size=50
hibernate.jdbc.fetch_size=50
hibernate.show_sql=true
hibernate.connection.release_mode=after_transaction
hibernate.query.factory_class=org.hibernate.hql.classic.ClassicQueryTranslatorFactory,
<!-- Generated by MyEclipse Hibernate Tools. -->
<hibernate-configuration> <session-factory>
<property name="dialect">
org.hibernate.dialect.OracleDialect
</property>
<property name="connection.url">
jdbc:oracle:thin:@10.241.96.123:1521:ORA9I
</property>
<property name="connection.username">elplat</property>
<property name="connection.password">elplat_168</property>
<property name="connection.driver_class">
oracle.jdbc.driver.OracleDriver
</property>
<property name="myeclipse.connection.profile">ora9i</property>
<!-- Enable Hibernate's automatic session context management -->
<property name="current_session_context_class">thread</property>
<property name="show_sql">true</property>
不行就看看你的驱动包
我有次也是明明引了还是找不到包 最后一看那个包是0K的