public static SingleConnectionDataSource getDataSourceFrom(String databaseFile) { SingleConnectionDataSource dataSource = new SingleConnectionDataSource(); dataSource.setDriverClassName("org.sqlite.JDBC"); dataSource.setUrl("jdbc:sqlite:" + databaseFile); return dataSource; }
@Bean public DataSource jdbcDataSource() { SingleConnectionDataSource ds = new SingleConnectionDataSource(); ds.setDriverClassName("org.sqlite.JDBC"); ds.setUrl("jdbc:sqlite:stats.db"); return ds; }
@Override protected JdbcTemplate createJdbcTemplate() { SingleConnectionDataSource ds = new SingleConnectionDataSource(); ds.setUrl(JDBC_URL_BASE + getDbFile()); ds.setSuppressClose(true); return new JdbcTemplate(ds); }
SingleConnectionDataSource ds = new SingleConnectionDataSource(); ds.setDriverClassName("org.hsqldb.jdbcDriver"); ds.setUrl("jdbc:hsqldb:data/tutorial"); ds.setUsername("sa"); ds.setPassword(""); JdbcTemplate jt = new JdbcTemplate(ds); jt.execute("insert into employee (id, name) values (?, ?)", 1, "Tom");
@Bean public DataSource dataSource() { SingleConnectionDataSource dataSource = new SingleConnectionDataSource(); dataSource.setSuppressClose(true); String userName = System.getProperty("user.name"); // defaults from Postgres.app dataSource.setUrl("jdbc:postgresql:" + userName); dataSource.setUsername(userName); dataSource.setPassword(""); return dataSource; }
@Bean public DataSource dataSource() { SingleConnectionDataSource dataSource = new SingleConnectionDataSource(); dataSource.setSuppressClose(true); // https://www.firebirdsql.org/file/documentation/drivers_documentation/java/faq.html#jdbc-urls-java.sql.drivermanager // https://github.com/FirebirdSQL/jaybird/wiki/Jaybird-and-Firebird-3 dataSource.setUrl("jdbc:firebirdsql://localhost:3050/jdbc?charSet=utf-8"); // https://github.com/almeida/docker-firebird dataSource.setUsername("jdbc"); dataSource.setPassword("Cent-Quick-Space-Bath-8"); return dataSource; }
@Bean public DataSource dataSource() { SingleConnectionDataSource dataSource = new SingleConnectionDataSource(); dataSource.setSuppressClose(true); dataSource.setUrl(""); dataSource.setUsername("scott"); dataSource.setPassword("tiger"); return dataSource; }
@Bean public DataSource dataSource() { SingleConnectionDataSource dataSource = new SingleConnectionDataSource(); dataSource.setSuppressClose(true); // defaults from Postgres.app // dataSource.setUrl("jdbc:sqlserver://localhost:1433;databaseName=master;user=sa;password=your_password"); dataSource.setUrl("jdbc:sqlserver://localhost:1433;databaseName=master"); dataSource.setUsername("sa"); dataSource.setPassword("Cent-Quick-Space-Bath-8"); return dataSource; }
@Bean public DataSource dataSource() { SingleConnectionDataSource dataSource = new SingleConnectionDataSource(); dataSource.setSuppressClose(true); // https://mariadb.com/kb/en/mariadb/about-mariadb-connector-j/ dataSource.setUrl("jdbc:mariadb://localhost:3307/jdbc?serverTimezone=UTC"); dataSource.setUsername("jdbc"); dataSource.setPassword("Cent-Quick-Space-Bath-8"); return dataSource; }
@Bean public DataSource dataSource() { SingleConnectionDataSource dataSource = new SingleConnectionDataSource(); dataSource.setSuppressClose(true); String userName = System.getProperty("user.name"); String database = userName; // https://dev.mysql.com/doc/connector-j/6.0/en/connector-j-reference-configuration-properties.html dataSource.setUrl("jdbc:mysql://localhost:3306/" + database + "?useSSL=false&serverTimezone=UTC&logger=com.mysql.cj.log.Slf4JLogger"); dataSource.setUsername(userName); String password = isTravis() ? "" : userName; dataSource.setPassword(password); return dataSource; }