python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - spring-jdbc

Issue with column names CLUSTER & COMMENT during merge/insert command in oracle

I am having a table where two columns are having reserved keywords of oracle named CLUSTER & COMMENT. I am trying to use the merge command from spring JDBC which is throwing the below error. ORA-0...
test-img

Vineel Pellella

spring

oracle

oracle11g

spring-jdbc

Votes: 0

Answers: 1

Latest Answer

If you are going to use reserved words as identifers then you need to use quoted identifiers (and the exact case used in the database): MERGE INTO table_name DESTINATION USING ( SELECT ? AS NAME, ...
test-img

MT0

How to used a NamedJDBCTemplate placeholder in the where clause of a postgres ARRAY comparison?

I'm attempting to do a postgres query with an ARRAY/GIN where clause using spring-jdbc. NamedParameterJdbcTemplate throws an error when I attempt to use a named parameter inside an ARRAY[]. minimal ex...
test-img

marathon

java

postgresql

spring-boot

jdbc

spring-jdbc

Votes: 0

Answers: 1

Latest Answer

adding spaces around the parameter and casting it in the sql query, e.g. select * from testing where col1 @> ARRAY[ CAST ( :item AS text) ] fixed it
test-img

marathon

Spring Boot Rest application: Testing JDBC DAO layer

How can I test my DAO layer in Spring Boot Application if my application only selects information from database and doesn't write anything? Even more, my application selects data from view. The common...
test-img

Alexander Lopatin

spring

spring-boot

unit-testing

dao

spring-jdbc

Votes: 0

Answers: 1

Latest Answer

You have a few options: Use an embedded H2 database then seed it with a data.sql, which you can dump from your test database. Use DBUnit and define your data in an xml file. For you I think data.s...
test-img

Essex Boy

How should I change the code so as to not get this warning : Raw use of parameterized class

I am try to get the values from the results of a stored procedure using SimpleJdbcCall. SimpleJdbcCall simpleJdbcCall = new SimpleJdbcCall(dataSource) .withProcedureName("...
test-img

ZhongYu

java

spring-boot

spring-jdbc

simplejdbccall

Votes: 0

Answers: 2

Latest Answer

While you can still continue to use your code in production, it should be avoided. They usually require casts and they aren't type safe. They are also less expressive, and they don't provide self-docu...
test-img

Robin Panicker

Posts

Questions

Blogs

Jobs