http://jexp.ru/index.php?action=history&feed=atom&title=Java_Tutorial%2FSpring%2FDataSource
Java Tutorial/Spring/DataSource - История изменений
2026-04-10T09:03:21Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://jexp.ru/index.php?title=Java_Tutorial/Spring/DataSource&diff=3239&oldid=prev
в 17:44, 31 мая 2010
2010-05-31T17:44:26Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 17:44, 31 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://jexp.ru/index.php?title=Java_Tutorial/Spring/DataSource&diff=3240&oldid=prev
Admin: 1 версия
2010-05-31T15:22:26Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== Configure Oracle DataSource ==<br />
<br />
<br />
<br />
<br />
<p>File: context.xml</p><br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<?xml version="1.0" encoding="UTF-8"?><br />
<beans xmlns="http://www.springframework.org/schema/beans"<br />
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"<br />
xmlns:util="http://www.springframework.org/schema/util"<br />
xmlns:tx="http://www.springframework.org/schema/tx"<br />
xmlns:aop="http://www.springframework.org/schema/aop"<br />
xmlns:lang="http://www.springframework.org/schema/lang"<br />
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd<br />
http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-2.0.xsd<br />
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd<br />
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd<br />
http://www.springframework.org/schema/lang http://www.springframework.org/schema/lang/spring-lang-2.0.xsd"><br />
<!--<br />
<bean id="dataSource" class="org.apache.rumons.dbcp.BasicDataSource" destroy-method="close"><br />
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/><br />
<property name="url" value="jdbc:oracle:thin:@oracle.devcake.co.uk:1521:INTL"/><br />
<property name="username" value="sa"/><br />
<property name="password" value=""/><br />
</bean><br />
--><br />
<bean id="dataSource" class="org.apache.rumons.dbcp.BasicDataSource" destroy-method="close"><br />
<property name="driverClassName" value="org.hsqldb.jdbcDriver"/><br />
<property name="url" value="jdbc:hsqldb:mem:."/><br />
<property name="username" value="sa"/><br />
<property name="password" value=""/><br />
</bean><br />
<!--<br />
<bean id="mysqlDataSource" class="org.apache.rumons.dbcp.BasicDataSource" destroy-method="close"><br />
<property name="driverClassName" value="com.mysql.jdbc.Driver"/><br />
<property name="url" value="jdbc:mysql://dbhost-prospring-psql/prospring"/><br />
<property name="username" value="sa"/><br />
<property name="password" value=""/><br />
</bean><br />
--><br />
<bean id="lobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler"><br />
<property name="nativeJdbcExtractor" ref="nativeJdbcExtractor"/><br />
</bean><br />
<bean id="nativeJdbcExtractor" class="org.springframework.jdbc.support.nativejdbc.rumonsDbcpNativeJdbcExtractor"/><br />
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"><br />
<property name="dataSource" ref="dataSource"/><br />
</bean><br />
<br />
</beans></source><br />
<br />
<br />
<!-- end source code --><br />
<br />
<br />
<br />
<br />
<br />
<br />
== DataSource for HSQL ==<br />
<br />
<br />
<br />
<br />
<p>File: context.xml</p><br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<?xml version="1.0" encoding="UTF-8"?><br />
<beans xmlns="http://www.springframework.org/schema/beans"<br />
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"<br />
xmlns:util="http://www.springframework.org/schema/util"<br />
xmlns:tx="http://www.springframework.org/schema/tx"<br />
xmlns:aop="http://www.springframework.org/schema/aop"<br />
xmlns:lang="http://www.springframework.org/schema/lang"<br />
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd<br />
http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-2.0.xsd<br />
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd<br />
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd<br />
http://www.springframework.org/schema/lang http://www.springframework.org/schema/lang/spring-lang-2.0.xsd"><br />
<!--<br />
<bean id="dataSource" class="org.apache.rumons.dbcp.BasicDataSource" destroy-method="close"><br />
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/><br />
<property name="url" value="jdbc:oracle:thin:@oracle.devcake.co.uk:1521:INTL"/><br />
<property name="username" value="sa"/><br />
<property name="password" value=""/><br />
</bean><br />
--><br />
<bean id="dataSource" class="org.apache.rumons.dbcp.BasicDataSource" destroy-method="close"><br />
<property name="driverClassName" value="org.hsqldb.jdbcDriver"/><br />
<property name="url" value="jdbc:hsqldb:mem:."/><br />
<property name="username" value="sa"/><br />
<property name="password" value=""/><br />
</bean><br />
<!--<br />
<bean id="mysqlDataSource" class="org.apache.rumons.dbcp.BasicDataSource" destroy-method="close"><br />
<property name="driverClassName" value="com.mysql.jdbc.Driver"/><br />
<property name="url" value="jdbc:mysql://dbhost-prospring-psql/prospring"/><br />
<property name="username" value="sa"/><br />
<property name="password" value=""/><br />
</bean><br />
--><br />
<bean id="lobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler"><br />
<property name="nativeJdbcExtractor" ref="nativeJdbcExtractor"/><br />
</bean><br />
<bean id="nativeJdbcExtractor" class="org.springframework.jdbc.support.nativejdbc.rumonsDbcpNativeJdbcExtractor"/><br />
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"><br />
<property name="dataSource" ref="dataSource"/><br />
</bean><br />
<br />
</beans></source><br />
<br />
<br />
<!-- end source code --><br />
<br />
<br />
<br />
<br />
<br />
<br />
== JdbcOdbc DataSource ==<br />
<br />
<br />
<br />
<br />
<p>File: context.xml</p><br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<?xml version="1.0" encoding="UTF-8"?><br />
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"<br />
"http://www.springframework.org/dtd/spring-beans.dtd"><br />
<beans><br />
<bean id="dataSource"<br />
class="org.springframework.jdbc.datasource.DriverManagerDataSource"><br />
<property name="driverClassName"><br />
<value>sun.jdbc.odbc.JdbcOdbcDriver</value><br />
</property><br />
<property name="url"><br />
<value>jdbc:odbc:test</value><br />
</property><br />
<property name="username"><br />
<value>root</value><br />
</property><br />
<property name="password"><br />
<value>sql</value><br />
</property><br />
</bean><br />
<bean id="datacon" class="Dataconimpl"><br />
<property name="dataSource"><ref local="dataSource"/></property><br />
</bean><br />
</beans></source><br />
<br />
<br />
<!-- end source code --><br />
<br />
<br />
<br />
<br />
<br />
<br />
== Link With DataSource ==<br />
<br />
<br />
<br />
<br />
<p>File: context.xml</p><br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<?xml version="1.0" encoding="UTF-8"?><br />
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"<br />
"http://www.springframework.org/dtd/spring-beans.dtd"><br />
<beans><br />
<bean id="dataSource"<br />
class="org.springframework.jdbc.datasource.DriverManagerDataSource"><br />
<property name="driverClassName"><br />
<value>sun.jdbc.odbc.JdbcOdbcDriver</value><br />
</property><br />
<property name="url"><br />
<value>jdbc:odbc:test</value><br />
</property><br />
<property name="username"><br />
<value>root</value><br />
</property><br />
<property name="password"><br />
<value>sql</value><br />
</property><br />
</bean><br />
<bean id="datacon" class="Dataconimpl"><br />
<property name="dataSource"><ref local="dataSource"/></property><br />
</bean><br />
</beans></source><br />
<br />
<br />
<!-- end source code --><br />
<br />
<br />
<br />
<br />
<br />
<br />
== Load Two DataSources ==<br />
<br />
<br />
<br />
<br />
<p>File: context.xml</p><br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<?xml version="1.0" encoding="UTF-8"?><br />
<beans xmlns="http://www.springframework.org/schema/beans"<br />
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"<br />
xmlns:util="http://www.springframework.org/schema/util"<br />
xmlns:tx="http://www.springframework.org/schema/tx"<br />
xmlns:aop="http://www.springframework.org/schema/aop"<br />
xmlns:lang="http://www.springframework.org/schema/lang"<br />
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd<br />
http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-2.0.xsd<br />
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd<br />
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd<br />
http://www.springframework.org/schema/lang http://www.springframework.org/schema/lang/spring-lang-2.0.xsd"><br />
<br />
<bean id="dataSource" class="org.apache.rumons.dbcp.BasicDataSource" destroy-method="close"><br />
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/><br />
<property name="url" value="jdbc:oracle:thin:@oracle.devcake.co.uk:1521:INTL"/><br />
<property name="username" value="sa"/><br />
<property name="password" value=""/><br />
</bean><br />
<bean id="mysqlDataSource" class="org.apache.rumons.dbcp.BasicDataSource" destroy-method="close"><br />
<property name="driverClassName" value="com.mysql.jdbc.Driver"/><br />
<property name="url" value="jdbc:mysql://dbhost-prospring-psql/prospring"/><br />
<property name="username" value="sa"/><br />
<property name="password" value=""/><br />
</bean><br />
<bean id="lobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler"><br />
<property name="nativeJdbcExtractor" ref="nativeJdbcExtractor"/><br />
</bean><br />
<bean id="nativeJdbcExtractor" class="org.springframework.jdbc.support.nativejdbc.rumonsDbcpNativeJdbcExtractor"/><br />
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"><br />
<property name="dataSource" ref="dataSource"/><br />
</bean><br />
<br />
</beans></source><br />
<br />
<br />
<!-- end source code --><br />
<br />
<br />
<br />
<br />
<br />
<br />
== Set up DataSource for MySQL ==<br />
<br />
<br />
<br />
<br />
<p>File: context.xml</p><br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<?xml version="1.0" encoding="UTF-8"?><br />
<beans xmlns="http://www.springframework.org/schema/beans"<br />
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"<br />
xmlns:util="http://www.springframework.org/schema/util"<br />
xmlns:tx="http://www.springframework.org/schema/tx"<br />
xmlns:aop="http://www.springframework.org/schema/aop"<br />
xmlns:lang="http://www.springframework.org/schema/lang"<br />
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd<br />
http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-2.0.xsd<br />
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd<br />
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd<br />
http://www.springframework.org/schema/lang http://www.springframework.org/schema/lang/spring-lang-2.0.xsd"><br />
<!--<br />
<bean id="dataSource" class="org.apache.rumons.dbcp.BasicDataSource" destroy-method="close"><br />
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/><br />
<property name="url" value="jdbc:oracle:thin:@oracle.devcake.co.uk:1521:INTL"/><br />
<property name="username" value="sa"/><br />
<property name="password" value=""/><br />
</bean><br />
--><br />
<bean id="dataSource" class="org.apache.rumons.dbcp.BasicDataSource" destroy-method="close"><br />
<property name="driverClassName" value="org.hsqldb.jdbcDriver"/><br />
<property name="url" value="jdbc:hsqldb:mem:."/><br />
<property name="username" value="sa"/><br />
<property name="password" value=""/><br />
</bean><br />
<!--<br />
<bean id="mysqlDataSource" class="org.apache.rumons.dbcp.BasicDataSource" destroy-method="close"><br />
<property name="driverClassName" value="com.mysql.jdbc.Driver"/><br />
<property name="url" value="jdbc:mysql://dbhost-prospring-psql/prospring"/><br />
<property name="username" value="sa"/><br />
<property name="password" value=""/><br />
</bean><br />
--><br />
<bean id="lobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler"><br />
<property name="nativeJdbcExtractor" ref="nativeJdbcExtractor"/><br />
</bean><br />
<bean id="nativeJdbcExtractor" class="org.springframework.jdbc.support.nativejdbc.rumonsDbcpNativeJdbcExtractor"/><br />
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"><br />
<property name="dataSource" ref="dataSource"/><br />
</bean><br />
<br />
</beans></source><br />
<br />
<br />
<!-- end source code --><br />
<br />
<br />
<br />
<br />
<br />
<br />
== Spring lazy init ==<br />
<br />
<br />
<br />
<br />
<p>File: context.xml</p><br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="java"><br />
<?xml version="1.0" encoding="UTF-8"?><br />
<beans xmlns="http://www.springframework.org/schema/beans"<br />
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"<br />
xsi:schemaLocation="<br />
http://www.springframework.org/schema/beans<br />
http://www.springframework.org/schema/beans/spring-beans.xsd"><br />
<br />
<bean id="destructiveBean" lazy-init="false" class="java.lang.String"><br />
<br />
</bean><br />
</beans></source><br />
<br />
<br />
<!-- end source code --></div>
Admin