Examples of org.springframework.jdbc.datasource.SingleConnectionDataSource

Package org.springframework.jdbc.datasource

Examples of org.springframework.jdbc.datasource.SingleConnectionDataSource

org.springframework.jdbc.datasource.SingleConnectionDataSource
Implementation of {@link SmartDataSource} that wraps a single JDBC Connectionwhich is not closed after use. Obviously, this is not multi-threading capable.
Note that at shutdown, someone should close the underlying Connection via the close() method. Client code will never call close on the Connection handle if it is SmartDataSource-aware (e.g. uses DataSourceUtils.releaseConnection).
If client code will call close() in the assumption of a pooled Connection, like when using persistence tools, set "suppressClose" to "true". This will return a close-suppressing proxy instead of the physical Connection. Be aware that you will not be able to cast this to a native OracleConnection or the like anymore; you need to use a {@link org.springframework.jdbc.support.nativejdbc.NativeJdbcExtractor} then.
This is primarily intended for testing. For example, it enables easy testing outside an application server, for code that expects to work on a DataSource. In contrast to {@link DriverManagerDataSource}, it reuses the same Connection all the time, avoiding excessive creation of physical Connections. @author Rod Johnson @author Juergen Hoeller @see #getConnection() @see java.sql.Connection#close() @see DataSourceUtils#releaseConnection @see org.springframework.jdbc.support.nativejdbc.NativeJdbcExtractor

    @Before
    public void setUp() throws Exception {
        Properties connectionProperties = new Properties();
        connectionProperties.put("autoCommit", Boolean.TRUE);
        
        DriverManagerDataSource dataSource = new SingleConnectionDataSource(url, user, password, true);
        dataSource.setDriverClassName(driverClass);
        dataSource.setConnectionProperties(connectionProperties);
        ds = dataSource;


        JdbcTemplate jdbc = new JdbcTemplate(ds);
        jdbc.execute("create table customer (id varchar(15) PRIMARY KEY, name varchar(10))");
        jdbc.execute("insert into customer values('cust1','jstrachan')");

View Full Code Here

        JdbcTemplate jdbcTemplate = new JdbcTemplate(createDataSource());
        jdbcTemplate.execute("drop table projects");
    }


    private DataSource createDataSource() {
        return new SingleConnectionDataSource(url, user, password, true);
    }

View Full Code Here


    @Override
    protected JndiRegistry createRegistry() throws Exception {
        JndiRegistry reg = super.createRegistry();
        
        ds = new SingleConnectionDataSource(url, user, password, true);
        ((DriverManagerDataSource) ds).setDriverClassName(driverClass);
        reg.bind("testdb", ds);
        
        DataSourceTransactionManager txMgr = new DataSourceTransactionManager();
        txMgr.setDataSource(ds);

View Full Code Here


    @Override
    protected RouteBuilder createRouteBuilder() throws Exception {
        return new RouteBuilder() {
            public void configure() {
                ds = new SingleConnectionDataSource(url, user, password, true);


                getContext().getComponent("sql", SqlComponent.class).setDataSource(ds);


                errorHandler(noErrorHandler());

View Full Code Here


    @Override
    protected RouteBuilder createRouteBuilder() throws Exception {
        return new RouteBuilder() {
            public void configure() throws Exception {
                ds = new SingleConnectionDataSource(url, user, password, true);


                SqlEndpoint sql = new SqlEndpoint();
                sql.setCamelContext(context);
                sql.setJdbcTemplate(new JdbcTemplate(ds));
                sql.setQuery("select * from projects");

View Full Code Here


    @Override
    protected RouteBuilder createRouteBuilder() throws Exception {
        return new RouteBuilder() {
            public void configure() {
                ds = new SingleConnectionDataSource(url, user, password, true);
                getContext().getComponent("sql", SqlComponent.class).setDataSource(ds);


                from("direct:simple").to("sql:select * from projects where id = # order by id").to("mock:result");
            }
        };

View Full Code Here

            } // end try..catch
            
            dataSource = (DataSource) factoryBean.getObject();
        } else if(url.startsWith("jdbc:hsqldb:file")) {
            logger.info("embedded HSQLDB mode detected, switching on spring single connection data source");
            SingleConnectionDataSource ds = new SingleConnectionDataSource();
            ds.setUrl(url);
            ds.setDriverClassName(driverClassName);
            ds.setUsername(username);
            ds.setPassword(password);
            ds.setSuppressClose(true);
            dataSource = ds;
        } else {
            logger.info("Not using embedded HSQLDB or JNDI datasource, switching on Apache DBCP data source connection pooling");
            BasicDataSource ds = new BasicDataSource();
            ds.setUrl(url);
            ds.setDriverClassName(driverClassName);
            ds.setUsername(username);
            ds.setPassword(password);
            ds.setValidationQuery(validationQuery);
            ds.setTestOnBorrow(false);
            ds.setTestWhileIdle(true);
            ds.setTimeBetweenEvictionRunsMillis(600000);
            dataSource = ds;
        } // end if..else
        
        return dataSource;
    }

View Full Code Here

    }
    
    @Before
    public void setUp() throws Exception {
        Class.forName(driverClass);
        ds = new SingleConnectionDataSource(url, user, password, true);
        
        jdbcTemplate = new JdbcTemplate(ds);
        jdbcTemplate.execute("create table projects (id integer primary key, project varchar(10), license varchar(5))");
        jdbcTemplate.execute("insert into projects values (1, 'Camel', 'ASF')");
        jdbcTemplate.execute("insert into projects values (2, 'AMQ', 'ASF')");

View Full Code Here

        };
    }


    @Before
    public void setUp() throws Exception {
        DriverManagerDataSource dataSource = new SingleConnectionDataSource(url, user, password, true);
        dataSource.setDriverClassName(driverClass);
        ds = dataSource;


        JdbcTemplate jdbc = new JdbcTemplate(ds);
        jdbc.execute("create table customer (id varchar(15) PRIMARY KEY, name varchar(10))");
        jdbc.execute("insert into customer values('cust1','jstrachan')");

View Full Code Here

        JdbcTemplate jdbcTemplate = new JdbcTemplate(createDataSource());
        jdbcTemplate.execute("drop table projects");
    }


    private DataSource createDataSource() {
        return new SingleConnectionDataSource(url, user, password, true);
    }

View Full Code Here

0 1 2 3 4 5 6 7

TOP

Related Classes of org.springframework.jdbc.datasource.SingleConnectionDataSource

ch.inftec.ju.db.JuConnUtils

ch.inftec.ju.db.JuConnUtils$AbstractJuConnUtil

de.zalando.typemapper.postgres.PgSerializerToDatabaseTestIT

GenericDBMS.DBConnectionManager

info.jtrac.config.DataSourceFactoryBean

liquibase.ext.hibernate.HibernateIntegrationTest

liquibase.ext.hibernate.SpringPackageScanningIntegrationTest

net.helipilot50.stocktrade.genericdbms.DBConnectionManager

org.apache.camel.component.jdbc.JdbcOptionsTest

org.apache.camel.component.sql.SqlDataSourceRefTest

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.