python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - jdbctemplate

How to query a boolean column using an integer with Postgres?

I post a similar question previously, but have opened another question to be more specific as the previous one gave me a solution but I have now encountered another problem. We have an existing Oracle...
test-img

user3275784

java

postgresql

oracle

jdbctemplate

Votes: 0

Answers: 2

Latest Answer

Can you try to use '0' and '1' instead of 0 and 1 in your requests ? I used to work on apps compliant with both Oracle and Postgresql using this syntax. Apps were using JPA but can say with certainty ...
test-img

mlogario

How to parallelize a task in which there are requests to a db?

I have a kotlin application and a Spring JdbcTemplate and a Hikary connection pool with two connections. And I have the task that is a good candidate for parallel execution. It's a list of strings: Li...
test-img

user2625402

java

kotlin

kotlin-coroutines

connection-pooling

jdbctemplate

Votes: 0

Answers: 0

Spring's JdbcTemplate with IN Clause Query

I'm having a trouble using Jdbctemplate's query method while passing the variable QUERY as a query parameter. The following example takes ids as a single parameter and not an array. What's wrong with ...
test-img

Neo Geo4

java

spring

jdbc

spring-jdbc

jdbctemplate

Votes: 0

Answers: 1

Latest Answer

You can use NamedParameterJdbcTemplate. Using NamedParameterJdbcTemplate#queryForObject you can pass a map of parameters which also supports List as a parameter type for use in calluses like IN So you...
test-img

seenukarthi

Create Multipe Jdbctemplate at runtime pointing to diffrent databases in runtime

Spring boot Is there any way to create Jdbctemplate at runtime pointing to the different MySQL databases? Runtime I do have all the required information. The database structure is the same for all the...
test-img

Ganesh Gudghe

mysql

spring-boot

spring-jdbc

jdbctemplate

Votes: 0

Answers: 1

Latest Answer

I guess this can be done like this: @Component public class JdbcTemplateProvider { private final Map<String, DataSource> databaseNameToDataSourceMap; private final JdbcProperties proper...
test-img

Gaurav

Posts

Questions

Blogs

Jobs