Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DataSource ds = (DataSource) org.apache.derby.jdbc.ClientDataSource()
- ds.setPort(1527);
- ds.setHost("localhost");
- ds.setUser("APP")
- ds.setPassword("APP");
- Connection con = ds.getConnection();
- DriverManager.registerDriver((Driver) Class.forName("com.mysql.jdbc.Driver").newInstance());
- String url = "jdbc:mysql://[host][,failoverhost...][:port]/[database][?propertyName1][=propertyValue1][&propertyName2][=propertyValue2]"
- Connection c = DriverManager.getConnection(url);
- BasicDataSource dataSource = new BasicDataSource();
- dataSource.setDriverClassName("com.mysql.jdbc.Driver");
- dataSource.setUsername("username");
- dataSource.setPassword("password");
- dataSource.setUrl("jdbc:mysql://<host>:<port>/<database>");
- dataSource.setMaxActive(10);
- dataSource.setMaxIdle(5);
- dataSource.setInitialSize(5);
- dataSource.setValidationQuery("SELECT 1");
- MysqlDataSource dataSource = new MysqlDataSource();
- dataSource.setDatabaseName("xyz");
- dataSource.setUser("xyz");
- dataSource.setPassword("xyz");
- dataSource.setServerName("xyz.yourdomain.com");
- ClientDataSource ds = org.apache.derby.jdbc.ClientDataSource()
- ds.setHost etc....
- @Bean
- public BasicDataSource dataSource() {
- BasicDataSource ds = new BasicDataSource();
- ds.setDriverClassName("com.mysql.jdbc.Driver");
- ds.setUrl("jdbc:mysql://localhost:3306/gene");
- ds.setUsername("root");
- ds.setPassword("root");
- return ds;
- }
- @Bean
- public DataSource dataSource(){
- DriverManagerDataSource ds = new DriverManagerDataSource();
- ds.setDriverClassName("com.mysql.jdbc.Driver");
- ds.setUrl("jdbc:mysql://localhost:3306/gene");
- ds.setUsername("root");
- ds.setPassword("root");
- return ds;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement