how to add another datasource

[zhangweilun]

i want to use springboot and Ebean,and i have two datasource, how to do it

[zhangweilun]

please help me , i like ebean

[rbygrave]

The best place to get help is on the google group - https://groups.google.com/forum/#!forum/ebean
That has more people reading / watching ... more people to help.

For this question you will need to outline what you are doing (if you are using the Ebean singleton and properties mechanism or a FactoryBean or other mechanism) and what you are trying to achieve (what is the use case for the multiple EbeanServer instances). Thanks, Rob.

[wangli-it]

I want to konw ,this project is only support h2 ?
this is my mysql config:
datasource.db.username=root
datasource.db.password=root
datasource.db.databaseUrl=jdbc:mysql://127.0.0.1:3306/pos
datasource.db.databaseDriver=com.mysql.jdbc.Driver
datasource.db.platform= mysql
please tell me why springboot start with the error
the error is : Caused by: java.lang.RuntimeException: DataSource user is null?
please help me , i like ebean

[azwar]

@wangli-it and @zhangweilun you can create two object of EbeanServer with it's own data source, here I have the sample for you:

  private EbeanServer createH2EbeanServer() {
        ServerConfig serverConfig = new ServerConfig();
        serverConfig.setName("h2");

        DataSourceConfig config = new DataSourceConfig();
        config.setDriver("org.h2.Driver");
        config.setUrl("jdbc:h2:tcp://localhost/~/Development/database/h2/adaberita4;AUTO_RECONNECT=FALSE");
        config.setUsername("yourh2username");
        config.setPassword("yourh2password");
        serverConfig.setDdlGenerate(false);
        serverConfig.setDdlRun(false);

        serverConfig.setDefaultServer(false);
        serverConfig.setRegister(false);
        serverConfig.addPackage("com.example.yourproject.entity");
        serverConfig.setDataSourceConfig(config);

        return EbeanServerFactory.create(serverConfig);
    }

    private EbeanServer createMySqlEbeanServer() {
        ServerConfig serverConfig = new ServerConfig();
        serverConfig.setName("mysql");

        DataSourceConfig config = new DataSourceConfig();
        config.setDriver("com.mysql.cj.jdbc.Driver");
        config.setUrl("jdbc:mysql://localhost/adaberita?useTimezone=true&serverTimezone=GMT%2B7");
        config.setUsername("yourusername");
        config.setPassword("yourpassword");

        serverConfig.setDdlGenerate(true);
        serverConfig.setDdlRun(false);
        serverConfig.setDefaultServer(false);
        serverConfig.setRegister(false);
        serverConfig.addPackage("com.example.yourproject.entity");
        serverConfig.setDataSourceConfig(config);

        return EbeanServerFactory.create(serverConfig);
    }

There are two methods that return EbeanServer with different datasource. Hope it helps.