English 中文(简体)
春季-jdb
原标题:Using "where in" in spring-jdbc

是否有办法删除使用“..................”在“......”中的一组内容,例如:

HashSet<String> idStrings = ...;
SimpleJdbcTemplate template = getTemplate();
template.update("DELETE FROM records WHERE idstring IN (?)", idStrings);

我正试图获得一些旧的法典,以使用这一方法,但每当我试图管理这一方法时,Oracle JDBC的司机就提出例外:

QL state [999]; 错误代码[17004]; 无效列类; nes例外是java.sql.SQLException: 无效列类

This is with ojdbc5 11.2.0.1.0 and spring-jdbc 3.0.3

最佳回答

这可能是可能的,但需要每个国际发展法的一位持地人(?),而且每个发展指标都必须单独约束。

您也可使用

[...] also allows for expanding a List of values to the appropriate number of placeholders.

小心不要将太多的价值观放在一套国际发展法中。 例如,Oracle将他们限制在1,000人。

问题回答

暂无回答




相关问题
Spring Properties File

Hi have this j2ee web application developed using spring framework. I have a problem with rendering mnessages in nihongo characters from the properties file. I tried converting the file to ascii using ...

Logging a global ID in multiple components

I have a system which contains multiple applications connected together using JMS and Spring Integration. Messages get sent along a chain of applications. [App A] -> [App B] -> [App C] We set a ...

Java Library Size

If I m given two Java Libraries in Jar format, 1 having no bells and whistles, and the other having lots of them that will mostly go unused.... my question is: How will the larger, mostly unused ...

How to get the Array Class for a given Class in Java?

I have a Class variable that holds a certain type and I need to get a variable that holds the corresponding array class. The best I could come up with is this: Class arrayOfFooClass = java.lang....

SQLite , Derby vs file system

I m working on a Java desktop application that reads and writes from/to different files. I think a better solution would be to replace the file system by a SQLite database. How hard is it to migrate ...

热门标签