|
1
|
package eu.dnetlib.enabling.database.utils;
|
|
2
|
|
|
3
|
import java.sql.Array;
|
|
4
|
import java.sql.PreparedStatement;
|
|
5
|
import java.sql.SQLException;
|
|
6
|
|
|
7
|
import org.springframework.jdbc.support.SqlValue;
|
|
8
|
|
|
9
|
public class SqlTextArrayValue implements SqlValue {
|
|
10
|
|
|
11
|
private final String[] items;
|
|
12
|
|
|
13
|
public SqlTextArrayValue(final String... items) {
|
|
14
|
this.items = items;
|
|
15
|
}
|
|
16
|
|
|
17
|
@Override
|
|
18
|
public void setValue(final PreparedStatement ps, final int paramIndex) throws SQLException {
|
|
19
|
final Array arrayValue = ps.getConnection().createArrayOf("TEXT", items);
|
|
20
|
ps.setArray(paramIndex, arrayValue);
|
|
21
|
}
|
|
22
|
|
|
23
|
@Override
|
|
24
|
public void cleanup() {}
|
|
25
|
|
|
26
|
}
|