@Repository
@Scope("prototype")
public class JdbcRepository {
    private final NamedParameterJdbcTemplate jdbc;

    public JdbcRepository(NamedParameterJdbcTemplate jdbc) {
        this.jdbc = jdbc;
    }
...
}

@Bean(name = "sourcePg")
public NamedParameterJdbcTemplate jdbcPg(HikariDataSource dataSourcePg) {
    return new NamedParameterJdbcTemplate(dataSourcePg);
}

@Service
public class DataAccessServicePg {
    private final NamedParameterJdbcTemplate jdbcPg;
    private final JdbcRepository jdbcRepository;

    public DataAccessService(NamedParameterJdbcTemplate jdbcPg, JdbcRepository jdbcRepository) {
        this.jdbcPg = jdbcPg;
        this.jdbcRepository = new JdbcRepository(jdbcPg);
    }
...
}

 this.jdbcRepository = new JdbcRepository(jdbcPg);

    this.jdbcRepository = new JdbcRepository(jdbcPg);

@Configuration
@EnableTransactionManagement
public class DataSourcesConfigurationH2 {

    @Bean
    @Primary
    @ConfigurationProperties("app.datasource.h2")
    public DataSourceProperties dataSourcePropertiesH2() {
        return new DataSourceProperties();
    }

    @Bean(name = "dataSourceH2")
    @Primary
    @ConfigurationProperties("app.datasource.h2.configuration")
    public HikariDataSource dataSourceH2(DataSourceProperties dataSourcePropertiesH2) {
        return dataSourcePropertiesH2.initializeDataSourceBuilder().type(HikariDataSource.class).build();
    }

    @Bean
    @Primary
    public NamedParameterJdbcTemplate jdbcH2(HikariDataSource dataSourceH2) {
        return new NamedParameterJdbcTemplate(dataSourceH2);
    }


    @Bean
    @Primary
    TransactionManager transactionManagerH2(HikariDataSource dataSourceH2) {
        return new DataSourceTransactionManager(dataSourceH2);
    }

    @Bean
    @Primary
    JdbcRepository jdbcRepositoryH2(NamedParameterJdbcTemplate jdbcH2) {
        return new JdbcRepository(jdbcH2);
    };

}

@Configuration
@EnableTransactionManagement
//@ComponentScan(basePackages = {"mag.jdbc.repository"})
public class DataSourcesConfigurationPg {

    @Bean
    @ConfigurationProperties("app.datasource.pg")
    public DataSourceProperties dataSourcePropertiesPg() {
        return new DataSourceProperties();
    }

    @Bean(name = "dataSourcePg")
    @ConfigurationProperties("app.datasource.pg.configuration")
    public HikariDataSource dataSourcePg(DataSourceProperties dataSourcePropertiesPg) {
        return dataSourcePropertiesPg.initializeDataSourceBuilder().type(HikariDataSource.class).build();
    }

    @Bean
    public NamedParameterJdbcTemplate jdbcPg(HikariDataSource dataSourcePg) {
        return new NamedParameterJdbcTemplate(dataSourcePg);
    }
    @Bean
    TransactionManager transactionManagerPg(HikariDataSource dataSourcePg) {
        return new DataSourceTransactionManager(dataSourcePg);
    }

    @Bean
    JdbcRepository jdbcRepositoryPg(NamedParameterJdbcTemplate jdbcPg) {
        return new JdbcRepository(jdbcPg);
    };
}

//@ComponentScan(basePackages = {"mag.jdbc.repository"})

@Service
public class DataAccessServicePg {

    private final JdbcRepository jdbcRepositoryPg;

    public DataAccessServicePg(JdbcRepository jdbcRepositoryPg) {
        this.jdbcRepositoryPg = jdbcRepositoryPg;
    }

    public Actor actorOne(String actorName) {
        return jdbcRepositoryPg.presentByString("actorList",
                actorName, ActorMapper::new, Actor::new);
    }

}

@Controller
@RequestMapping("")
public class BaseController {
    private final DataAccessServicePg servicePg;

    public BaseController(DataAccessServicePg servicePg) {
        this.servicePg = servicePg;
    }

    @GetMapping("")
    public String primary(
            Model model) {
        return "primary";
    }
    @GetMapping("/dataH2")
    public String spaceH2(
            HttpServletRequest request, Model model) {

        return "spaceData";
    }

    @GetMapping("/dataPg")
    public String spacePg(
            HttpServletRequest request, Model model) {

        Actor actor = servicePg.actorOne("palomnic");
        model.addAttribute("pageTitle", "pg: palomnic");
        model.addAttribute("actor", actor);
        return "spaceData";
    }

}

[500] Internal Server Error 
PreparedStatementCallback; bad SQL grammar [select * from actorList(?);]; nested exception is org.h2.jdbc.JdbcSQLSyntaxErrorException: Функция "ACTORLIST" не найдена Function "ACTORLIST" not found; SQL statement: select * from actorList(?); [90022-200]

server.servlet.context-path=/transData
server.error.include-message=always
spring.devtools.add-properties=false
spring.main.banner-mode=off

spring.thymeleaf.cache=false
spring.thymeleaf.enabled=true
spring.thymeleaf.prefix=classpath:/templates/
spring.thymeleaf.suffix=.html

server.error.whitelabel.enabled=false
server.error.path=/error

app.datasource.h2.jdbc-url=jdbc:h2:~/database/tester
app.datasource.h2.username=name
app.datasource.h2.password=pass

app.datasource.pg.jdbc-url=jdbc:postgresql://localhost:5432/tester
app.datasource.pg.username=name
app.datasource.pg.password=pass

    @Bean(name = "dataSourcePg")
    @ConfigurationProperties("app.datasource.pg.configuration")
    public HikariDataSource dataSourcePg(DataSourceProperties dataSourcePropertiesPg) {
        return dataSourcePropertiesPg.initializeDataSourceBuilder().type(HikariDataSource.class).build();
    }
    @Bean(name = "jdbcPg")
    public NamedParameterJdbcTemplate jdbcPg(@Qualifier("dataSourcePg") HikariDataSource dataSourcePg) {
        return new NamedParameterJdbcTemplate(dataSourcePg);
    }
    @Bean(name = "jdbcRepositoryPg")
    JdbcRepository jdbcRepositoryPg(@Qualifier("jdbcPg") NamedParameterJdbcTemplate jdbcPg) {
        return new JdbcRepository(jdbcPg);
    };

@Bean(name = "dataSourcePg")
@ConfigurationProperties("app.datasource.pg.configuration")
public HikariDataSource dataSourcePg(DataSourceProperties dataSourcePropertiesPg) {
    return dataSourcePropertiesPg.initializeDataSourceBuilder().type(HikariDataSource.class).build();
}

    @Bean(name = "dataSourceH2")
    @Primary
    @ConfigurationProperties(prefix="app.datasource.h2")
    public HikariDataSource dataSourceH2(DataSourceProperties dataSourcePropertiesH2) {
        return dataSourcePropertiesH2.initializeDataSourceBuilder().type(HikariDataSource.class).build();
    }

    @Bean(name = "dataSourcePg")
    @ConfigurationProperties(prefix="app.datasource.pg")
    public HikariDataSource dataSourcePg(DataSourceProperties dataSourcePropertiesPg) {
        return dataSourcePropertiesPg.initializeDataSourceBuilder().type(HikariDataSource.class).build();
    }

app.datasource.h2.jdbc-url=jdbc:h2:~/database/tester
app.datasource.h2.username=usr
app.datasource.h2.password=pwd

app.datasource.pg.jdbc-url=jdbc:postgresql://localhost:5432/tester
app.datasource.pg.username=usr
app.datasource.pg.password=pwd

    @Bean
    @Primary
    @ConfigurationProperties(prefix="app.datasource.h2")
    public DataSource dataSourceH2() {
        return DataSourceBuilder.create().build();
    }

    @Bean
    @Primary
    public NamedParameterJdbcTemplate jdbcH2(HikariDataSource dataSource) {
        return new NamedParameterJdbcTemplate(dataSource);
    }

    @Bean
    @Primary
    JdbcRepository jdbcRepositoryH2(NamedParameterJdbcTemplate jdbc) {
        return new JdbcRepository(jdbc);
    };

    @Bean
    @Primary
    TransactionManager transactionManagerH2(HikariDataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }

    @Bean
    @ConfigurationProperties(prefix="app.datasource.pg")
    public DataSource dataSourcePg() {
        return DataSourceBuilder.create().build();
    }
...

    @Bean
    @ConfigurationProperties("app.datasource.pg")
    public DataSourceProperties dataSourcePropertiesPg() {
        return new DataSourceProperties();
    }

    @Bean
    public NamedParameterJdbcTemplate jdbcPg(HikariDataSource dataSource) {
        dataSource.setDriverClassName("org.postgresql.Driver");
        dataSource.setUsername("usr");
        dataSource.setPassword("pwd");
        dataSource.setJdbcUrl("jdbc:postgresql://localhost:5432/tester");
        return new NamedParameterJdbcTemplate(dataSource);
    }

  
    @Bean
    public NamedParameterJdbcTemplate jdbcTemplateH2()
    {
        DataSource ds = dataSourceH2();
        return new NamedParameterJdbcTemplate(ds);
    }

    @Bean("dataSourcePg")
    @ConfigurationProperties(prefix = "app.datasourcepg")
    public DataSource dataSourcePg()
    {
        return DataSourceBuilder.create().build();
    }

@Configuration
public class DataSourcesConfigurationPg {
    @Bean
    @ConfigurationProperties("app.datasourcepg")
    public DataSourceProperties dataSourcePropertiesPg() {
        return new DataSourceProperties();
    }

    @Bean("dataSourcePg")
    @ConfigurationProperties(prefix = "app.datasourcepg")
    public HikariDataSource dataSourcePg() {
        return dataSourcePropertiesPg()
                .initializeDataSourceBuilder().type(HikariDataSource.class).build();
    }

    @Bean("jdbcTemplatePg")
    public NamedParameterJdbcTemplate jdbcTemplatePg()
    {
        HikariDataSource ds = dataSourcePg();
        return new NamedParameterJdbcTemplate(ds);
    }
    @Bean("jdbcRepositoryPg")
    JdbcRepository jdbcRepositoryPg() {
        NamedParameterJdbcTemplate jdbc = jdbcTemplatePg();
        return new JdbcRepository(jdbc);
    };
}

//    private final JdbcRepository jdbcRepositoryPg;
//
//    public DataAccessServicePg(JdbcRepository jdbcRepositoryPg) {
//        this.jdbcRepositoryPg = jdbcRepositoryPg;
//    }

    @Autowired
    @Qualifier("jdbcRepositoryPg")
    private JdbcRepository jdbcRepository;

@Configuration
public class DataSourcesConfigurationH2 {
...
//    @Primary
    @Bean
    @Qualifier("jdbcRepositoryH2")
    JdbcRepository jdbcRepositoryH2() {
        NamedParameterJdbcTemplate jdbc = jdbcTemplateH2();
        return new JdbcRepository(jdbc);
    };
...
}

@Service
public class DataAccessServiceH2 {
...
    @Autowired
    @Qualifier("jdbcRepositoryH2")
    private JdbcRepository jdbcRepository;
...
}