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

  private final String sql;


  public JdbcSlimRunner(final String driverClassname, final String url, final String username, final String password, final String sql)
          throws ClassNotFoundException {
    Class.forName(driverClassname);
    this.template = new JdbcTemplate(new SingleConnectionDataSource(url, username, password, false));
    this.sql = sql;
  }

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() {
                ds = new SingleConnectionDataSource(url, user, password, true);


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


                errorHandler(noErrorHandler());

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

        cacheManager.addCache(new Cache("basiclookuptestcache", 500, false, false, 30, 30));
    }


    @BeforeClass
    public static void createDatabase() throws Exception {
        dataSource = new SingleConnectionDataSource("jdbc:hsqldb:mem:lookupstrategytest", "sa", "", true);
        dataSource.setDriverClassName("org.hsqldb.jdbcDriver");
        jdbcTemplate = new JdbcTemplate(dataSource);


        Resource resource = new ClassPathResource("createAclSchema.sql");
        String sql = new String(FileCopyUtils.copyToByteArray(resource.getInputStream()));

View Full Code Here

    private JdbcTokenRepositoryImpl repo;
    private JdbcTemplate template;


    @BeforeClass
    public static void createDataSource() {
        dataSource = new SingleConnectionDataSource("jdbc:hsqldb:mem:tokenrepotest", "sa", "", true);
        dataSource.setDriverClassName("org.hsqldb.jdbc.JDBCDriver");
    }

View Full Code Here

               .forEach(System.out::println);


            System.out.println();
            System.out.println("Fetching data into a lambda expression with Spring JDBC");
            System.out.println("-------------------------------------------------------");
            new JdbcTemplate(new SingleConnectionDataSource(c, true))
                .query(sql,
                    (rs, rowNum) -> new Schema(
                        rs.getString("SCHEMA_NAME"),
                        rs.getBoolean("IS_DEFAULT")
                    ))

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 license = # order by id")
                    .to("mock:result");

View Full Code Here

      throw new DataAccessException("DatabaseMeta problem", e) {
        private static final long serialVersionUID = -3457360074729938909L;
      };
    }
    // create the datasource
    DataSource ds = new SingleConnectionDataSource(dbMeta.getDriverClass(), url, dbMeta.getUsername(), dbMeta
        .getPassword(), false);


    // create the jdbc template
    final JdbcTemplate jt = new JdbcTemplate(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

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.