SimpleJdbcInsert does not recognize currentschema

Asked Apr 18 '18 at 10:43

Active Apr 18 '18 at 10:56

Viewed 345 times

I connect with jdbc:postgresql://localhost:5432/mydatabase?currentSchema=myschema.

I have the following configuration for SimpleJdbcInsert. I use Spring Boot.

@Bean
@Qualifier("simpleJdbcInsert")
public SimpleJdbcInsert simpleJdbcInsert(@Qualifier("dataSource") DataSource dataSource) {
 return new SimpleJdbcInsert(dataSource).withTableName("tableX").usingGeneratedKeyColumns("id");
}

But i get the following execption:

org.springframework.dao.DataAccessResourceFailureException: Unable to locate table meta data for 'tableX' in the default schema

I don't know why, because i thought that i set the currentSchema=myschema already.

I don't want to do following because i set the currentSchema=myschema in the JDBC URL above.

new SimpleJdbcInsert(dataSource).withSchemaName("Schema1").withTableName("tableX").usingGeneratedKeyColumns("id");

edited Apr 18 '18 at 10:56

Karol Dowbecki

38,744
9
58
89

asked Apr 18 '18 at 10:43

java java

I guess you could unwrap / cast the datasource to the actual class, then use `getProperty("currentSchema")` to get the parameter. Although it's unclear it's not set in the datasource automatically (maybe it's overridden): https://stackoverflow.com/a/44274949 – Kayaman Apr 18 '18 at 10:52
Which version of Postgres are you using? – André Barbosa Apr 18 '18 at 10:58
Version of postgres is 9.5 – java java Apr 18 '18 at 10:59
And the version of the postgresql driver? – André Barbosa Apr 18 '18 at 11:02
I have tested it with 42.0.0 and 42.2.2. But with no success – java java Apr 18 '18 at 11:14

SimpleJdbcInsert does not recognize currentschema

0 Answers0