- iOS/Objective-C 元类和类别
- objective-c - -1001 错误,当 NSURLSession 通过 httpproxy 和/etc/hosts
- java - 使用网络类获取 url 地址
- ios - 推送通知中不播放声音
我们最近迁移到 AS400 上较新的 V6R1 版本的 DB2,我们使用 Spring 框架(v. 2.5.6.)与数据库通信。我们正在调用 Spring 的 NamedParameterJdbcTemplate.update()
方法来插入新行,这个方法应该返回插入行的数量,但没有发生什么(结果我们得到零返回)虽然行被定期插入.
我们得出的结论是,如果insert语句中没有主键列,一切正常,所以PK列自增时没有问题,但在某些情况下我们必须插入PK值,然后我们必须以某种方式应对定期出现的情况插入的行未在 JDBC 或 Spring 中注册。
有人可以帮忙吗?
最佳答案
更新:这个issue已修复 JTOpen 7.6
我和 Ante 一起工作......这个问题与 Spring 无关,这是肯定的,因为我已经建立了一个使用普通 JDBC 和 PreparedStatements 的项目。
所以我将添加更多信息来模拟问题:
数据链接:
CREATE TABLE TEST_V6R1 (
ID INTEGER NOT NULL DEFAULT,
VALUE VARCHAR(50)
);
ALTER TABLE TEST_V6R1 ADD CONSTRAINT TEST_V6R1_PK PRIMARY KEY
(ID);
SQL:
insert into test_v6r1 (id, value ) values (?, ?)
Java代码:
public class TestV6R1 {
public static void main( String[] args ) {
Connection conn = null;
PreparedStatement ps1 = null;
PreparedStatement ps2 = null;
try {
conn = getNewConnection();
conn.setAutoCommit( false );
String value = "Test: " + new Timestamp( System.currentTimeMillis() );
// First statement which uses RETURN_GENERATED_KEYS
ps1 = conn.prepareStatement( "insert into test_v6r1 (id, value ) values (?, ?)", Statement.RETURN_GENERATED_KEYS );
ps1.setInt( 1, 1 );
ps1.setString( 2, value );
int ps1Rows = ps1.executeUpdate();
// in case of V5R4
// ps1Rows is 1
// in case of V6R1
// ps1Rows is 0
ResultSet ps1keys = ps1.getGeneratedKeys();
int ps1KeySize = 0;
if (ps1keys != null) {
ps1keys.last();
ps1KeySize = ps1keys.getRow();
}
System.out.println("PS1 - SQL insert affected " + ps1Rows + " rows and returned " + ps1KeySize + " keys");
System.out.println("PS1 - getUpdateCount()="+ ps1.getUpdateCount());
// Second statement which uses NO_GENERATED_KEYS
ps2 = conn.prepareStatement( "insert into test_v6r1 (id, value) values (?, ?)", Statement.NO_GENERATED_KEYS );
ps2.setInt( 1, 2 );
ps2.setString( 2, value );
int ps2Rows = ps2.executeUpdate();
// in case of V5R4
// ps2Rows is 1
// in case of V6R1
// ps2Rows is 1
ResultSet ps2Keys = ps2.getGeneratedKeys();
int ps2KeySize = 0;
if (ps2Keys != null) {
ps2Keys.last();
ps2KeySize = ps2Keys.getRow();
}
System.out.println("PS2 - SQL insert affected " + ps2Rows + " rows and returned " + ps2KeySize + " keys");
System.out.println("PS2 - getUpdateCount()="+ ps2.getUpdateCount());
conn.commit();
}
catch ( Throwable e ) {
e.printStackTrace();
try {
conn.rollback();
}
catch ( SQLException e1 ) {
e1.printStackTrace();
}
}
finally {
try {
if (ps1!=null) ps1.close();
if (ps2!=null) ps2.close();
if (conn!=null) conn.close();
}
catch ( SQLException e ) {
e.printStackTrace();
}
}
}
public static Connection getNewConnection() {
try {
Class.forName( "com.ibm.as400.access.AS400JDBCDriver" ); // Or any other driver
}
catch ( Exception x ) {
System.out.println( "Unable to load the driver class!" );
}
Connection dbConnection = null;
try {
// TEST - V6R1
dbConnection = DriverManager
.getConnection( "jdbc:as400://testServer;libraries=*libl;naming=system;sort=language;sort language=HRV;sort weight=shared;prompt=false;trace=true",
"username",
"password" );
// PRODUCTION - V5R4
// dbConnection = DriverManager
// .getConnection( "jdbc:as400://productionServer;libraries=*libl;naming=system;sort=language;sort language=HRV;sort weight=shared;prompt=false;trace=true",
// "username",
// "password" );
}
catch ( SQLException x ) {
System.out.println( "Couldn’t get connection!" );
}
return dbConnection;
}
}
V5R4 控制台输出:
Toolbox for Java - Open Source Software, JTOpen 7.3, codebase 5770-SS1 V7R1M0.03 2011/01/14 @B5
as400: Properties (12122347) : access = "all".
as400: Properties (12122347) : block size = "32".
as400: Properties (12122347) : block criteria = "2".
as400: Properties (12122347) : date format = "".
as400: Properties (12122347) : date separator = "".
as400: Properties (12122347) : decimal separator = "".
as400: Properties (12122347) : errors = "basic".
as400: Properties (12122347) : extended dynamic = "false".
as400: Properties (12122347) : libraries = "*libl".
as400: Properties (12122347) : naming = "system".
as400: Properties (12122347) : package = "".
as400: Properties (12122347) : package add = "true".
as400: Properties (12122347) : package cache = "false".
as400: Properties (12122347) : package clear = "false".
as400: Properties (12122347) : package error = "warning".
as400: Properties (12122347) : package library = "".
as400: Properties (12122347) : password = "".
as400: Properties (12122347) : prefetch = "true".
as400: Properties (12122347) : prompt = "false".
as400: Properties (12122347) : remarks = "system".
as400: Properties (12122347) : sort = "language".
as400: Properties (12122347) : sort language = "HRV".
as400: Properties (12122347) : sort table = "".
as400: Properties (12122347) : sort weight = "shared".
as400: Properties (12122347) : time format = "".
as400: Properties (12122347) : time separator = "".
as400: Properties (12122347) : trace = "true".
as400: Properties (12122347) : transaction isolation = "read uncommitted".
as400: Properties (12122347) : translate binary = "false".
as400: Properties (12122347) : user = "username".
as400: Properties (12122347) : package criteria = "default".
as400: Properties (12122347) : lob threshold = "32768".
as400: Properties (12122347) : secure = "false".
as400: Properties (12122347) : data truncation = "true".
as400: Properties (12122347) : proxy server = "".
as400: Properties (12122347) : secondary URL = "".
as400: Properties (12122347) : data compression = "true".
as400: Properties (12122347) : big decimal = "true".
as400: Properties (12122347) : thread used = "true".
as400: Properties (12122347) : cursor hold = "true".
as400: Properties (12122347) : lazy close = "false".
as400: Properties (12122347) : driver = "toolbox".
as400: Properties (12122347) : bidi string type = "5".
as400: Properties (12122347) : key ring name = "".
as400: Properties (12122347) : key ring password = "".
as400: Properties (12122347) : full open = "false".
as400: Properties (12122347) : server trace = "0".
as400: Properties (12122347) : database name = "".
as400: Properties (12122347) : extended metadata = "false".
as400: Properties (12122347) : cursor sensitivity = "asensitive".
as400: Properties (12122347) : behavior override = "0".
as400: Properties (12122347) : package ccsid = "13488".
as400: Properties (12122347) : minimum divide scale = "0".
as400: Properties (12122347) : maximum precision = "31".
as400: Properties (12122347) : maximum scale = "31".
as400: Properties (12122347) : translate hex = "character".
as400: Properties (12122347) : toolbox trace = "".
as400: Properties (12122347) : qaqqinilib = "".
as400: Properties (12122347) : login timeout = "".
as400: Properties (12122347) : true autocommit = "false".
as400: Properties (12122347) : bidi implicit reordering = "true".
as400: Properties (12122347) : bidi numeric ordering = "false".
as400: Properties (12122347) : hold input locators = "true".
as400: Properties (12122347) : hold statements = "false".
as400: Properties (12122347) : rollback cursor hold = "false".
as400: Properties (12122347) : variable field compression = "true".
as400: Properties (12122347) : query optimize goal = "0".
as400: Properties (12122347) : keep alive = "".
as400: Properties (12122347) : receive buffer size = "".
as400: Properties (12122347) : send buffer size = "".
as400: Properties (12122347) : XA loosely coupled support = "0".
as400: Properties (12122347) : translate boolean = "true".
as400: Properties (12122347) : metadata source = "-1".
as400: Properties (12122347) : query storage limit = "-1".
as400: Properties (12122347) : decfloat rounding mode = "half even".
as400: Properties (12122347) : autocommit exception = "false".
as400: Properties (12122347) : auto commit = "true".
as400: Properties (12122347) : ignore warnings = "".
as400: Properties (12122347) : secure current user = "true".
as400: Properties (12122347) : concurrent access resolution = "0".
as400: Properties (12122347) : jvm16 synchronize = "true".
as400: Properties (12122347) : socket timeout = "".
as400: Properties (12122347) : use block update = "false".
as400: Properties (12122347) : maximum blocked input rows = "32000".
as400: Driver AS/400 Toolbox for Java JDBC Driver (15779934) : Using IBM Toolbox for Java JDBC driver implementation.
as400: Properties (12122347) : metadata source = "0".
as400: Toolbox for Java - Open Source Software, JTOpen 7.3, codebase 5770-SS1 V7R1M0.03 2011/01/14 @B5
as400: JDBC Level: 40
as400: Properties (12122347) : package ccsid = "13488".
as400: Connection productionServer (367156) : Client CCSID = 13488.
as400: Connection productionServer (367156) : Setting server NLV = 2912.
as400: Connection productionServer (367156) : Client functional level = V7R1M01 .
as400: Connection productionServer (367156) : Data compression = RLE.
as400: Connection productionServer (367156) : ROWID supported = true.
as400: Connection productionServer (367156) : True auto-commit supported = true.
as400: Connection productionServer (367156) : 128 byte column names supported = true.
as400: Connection productionServer (367156) : Maximum decimal precision = 31.
as400: Connection productionServer (367156) : Maximum decimal scale = 31.
as400: Connection productionServer (367156) : Minimum divide scale = 0.
as400: Connection productionServer (367156) : Translate hex = character.
as400: Connection productionServer (367156) : query optimize goal = 0.
as400: Connection productionServer (367156) : Using extended datastreams.
as400: Connection productionServer (367156) : JDBC driver major version = 9.
as400: Connection productionServer (367156) : IBM i VRM = V5R4M0.
as400: Connection productionServer (367156) : Server CCSID = 870.
as400: Connection productionServer (367156) : Server functional level = V5R4M00014 (14).
as400: Connection productionServer (367156) : Server job identifier = 692621/QUSER/QZDASOINIT.
as400: Properties (12122347) : decimal separator = ".".
as400: Properties (12122347) : date format = "dmy".
as400: Properties (12122347) : date separator = "/".
as400: Properties (12122347) : time format = "hms".
as400: Properties (12122347) : time separator = ":".
as400: Connection productionServer (367156) open.
as400: Connection productionServer (367156) : Auto commit = "true".
as400: Connection productionServer (367156) : Read only = "false".
as400: Connection productionServer (367156) : Transaction isolation = "1".
as400: Connection productionServer (367156) : Auto commit = "false".
as400: PreparedStatement STMT0001 (24864323) open. Parent: Connection productionServer (367156) .
as400: PreparedStatement STMT0001 (24864323) : Escape processing = "true".
as400: PreparedStatement STMT0001 (24864323) : Fetch direction = "1000".
as400: PreparedStatement STMT0001 (24864323) : Fetch size = "0".
as400: PreparedStatement STMT0001 (24864323) : Max field size = "0".
as400: PreparedStatement STMT0001 (24864323) : Max rows = "0".
as400: PreparedStatement STMT0001 (24864323) : Query timeout = "0".
as400: PreparedStatement STMT0001 (24864323) : Result set concurrency = "1007".
as400: PreparedStatement STMT0001 (24864323) : Result set holdability = "1".
as400: PreparedStatement STMT0001 (24864323) : Result set type = "1003".
as400: PreparedStatement STMT0001 (24864323) : Behavior Override = "0".
as400: PreparedStatement STMT0001 (24864323) : Data to correlate statement with cursor Cursor CRSR0001 (7792807) .
as400: PreparedStatement STMT0001 (24864323) : Preparing [insert into test_v6r1 (id, value ) values (?, ?)].
as400: PreparedStatement STMT0001 (24864323) : Prepared STMT0001*, SQL Statement -->[insert into test_v6r1 (id, value ) values (?, ?)].
as400: PreparedStatement STMT0001 (24864323) : setInt().
as400: PreparedStatement STMT0001 (24864323) : parameter index: 1 value: 1.
as400: PreparedStatement STMT0001 (24864323) : setString().
as400: PreparedStatement STMT0001 (24864323) : parameter index: 2 value: Test: 2011-04-27 16:34:30.981.
as400: PreparedStatement STMT0001 (24864323) : Descriptor 1 created or changed.
as400: PreparedStatement STMT0001 (24864323) : returnCode is: 0.
as400: PreparedStatement STMT0001 (24864323) : generated key from system is: null.
as400: ResultSet (2850225) open.
as400: ResultSet (2850225) : Conncurrency = "1007".
as400: ResultSet (2850225) : Fetch direction = "1000".
as400: ResultSet (2850225) : Fetch size = "0".
as400: ResultSet (2850225) : Max rows = "0".
as400: ResultSet (2850225) : Type = "1004".
as400: PreparedStatement STMT0001 (24864323) : Executed STMT0001*, SQL Statement --> [insert into test_v6r1 (id, value ) values (?, ?)].
as400: PreparedStatement STMT0001 (24864323) : Update count = 1.
as400: PreparedStatement STMT0001 (24864323) : Result set = false.
as400: PreparedStatement STMT0001 (24864323) : Number of result sets = 0.
as400: PreparedStatement STMT0001 (24864323) : Row count estimate = -1.
PS1 - SQL insert affected 1 rows and returned 0 keys
PS1 - getUpdateCount()=1
as400: PreparedStatement STMT0002 (19098837) open. Parent: Connection productionServer (367156) .
as400: PreparedStatement STMT0002 (19098837) : Escape processing = "true".
as400: PreparedStatement STMT0002 (19098837) : Fetch direction = "1000".
as400: PreparedStatement STMT0002 (19098837) : Fetch size = "0".
as400: PreparedStatement STMT0002 (19098837) : Max field size = "0".
as400: PreparedStatement STMT0002 (19098837) : Max rows = "0".
as400: PreparedStatement STMT0002 (19098837) : Query timeout = "0".
as400: PreparedStatement STMT0002 (19098837) : Result set concurrency = "1007".
as400: PreparedStatement STMT0002 (19098837) : Result set holdability = "1".
as400: PreparedStatement STMT0002 (19098837) : Result set type = "1003".
as400: PreparedStatement STMT0002 (19098837) : Behavior Override = "0".
as400: PreparedStatement STMT0002 (19098837) : Data to correlate statement with cursor Cursor CRSR0002 (12470752) .
as400: PreparedStatement STMT0002 (19098837) : Preparing [insert into test_v6r1 (id, value) values (?, ?)].
as400: PreparedStatement STMT0002 (19098837) : Prepared STMT0002*, SQL Statement -->[insert into test_v6r1 (id, value) values (?, ?)].
as400: PreparedStatement STMT0002 (19098837) : setInt().
as400: PreparedStatement STMT0002 (19098837) : parameter index: 1 value: 2.
as400: PreparedStatement STMT0002 (19098837) : setString().
as400: PreparedStatement STMT0002 (19098837) : parameter index: 2 value: Test: 2011-04-27 16:34:30.981.
as400: PreparedStatement STMT0002 (19098837) : Descriptor 2 created or changed.
as400: PreparedStatement STMT0002 (19098837) : Executed STMT0002*, SQL Statement --> [insert into test_v6r1 (id, value) values (?, ?)].
as400: PreparedStatement STMT0002 (19098837) : Update count = 1.
as400: PreparedStatement STMT0002 (19098837) : Result set = false.
as400: PreparedStatement STMT0002 (19098837) : Number of result sets = 0.
as400: PreparedStatement STMT0002 (19098837) : Row count estimate = -1.
PS2 - SQL insert affected 1 rows and returned 0 keys
PS2 - getUpdateCount()=1
as400: Connection productionServer (367156) : Testing to see if cursors should be held..
as400: Connection productionServer (367156) : Transaction commit.
as400: ResultSet (2850225) closed.
as400: PreparedStatement STMT0001 (24864323) closed.
as400: PreparedStatement STMT0002 (19098837) closed.
as400: Connection productionServer (367156) closed.
V6R1 控制台输出:
Toolbox for Java - Open Source Software, JTOpen 7.3, codebase 5770-SS1 V7R1M0.03 2011/01/14 @B5
.
.
.
as400: Driver AS/400 Toolbox for Java JDBC Driver (27979955) : Using IBM Toolbox for Java JDBC driver implementation.
as400: Properties (16020374) : metadata source = "0".
as400: Toolbox for Java - Open Source Software, JTOpen 7.3, codebase 5770-SS1 V7R1M0.03 2011/01/14 @B5
as400: JDBC Level: 40
as400: Properties (16020374) : package ccsid = "13488".
as400: Connection testServer (11463270) : Client CCSID = 13488.
as400: Connection testServer (11463270) : Setting server NLV = 2912.
as400: Connection testServer (11463270) : Client functional level = V7R1M01 .
as400: Connection testServer (11463270) : Data compression = RLE.
as400: Connection testServer (11463270) : ROWID supported = true.
as400: Connection testServer (11463270) : True auto-commit supported = true.
as400: Connection testServer (11463270) : 128 byte column names supported = true.
as400: Connection testServer (11463270) : Maximum decimal precision = 31.
as400: Connection testServer (11463270) : Maximum decimal scale = 31.
as400: Connection testServer (11463270) : Minimum divide scale = 0.
as400: Connection testServer (11463270) : Translate hex = character.
as400: Connection testServer (11463270) : query optimize goal = 0.
as400: Connection testServer (11463270) : query storage limit = -1.
as400: Connection testServer (11463270) : Using extended datastreams.
as400: Connection testServer (11463270) : JDBC driver major version = 9.
as400: Connection testServer (11463270) : IBM i VRM = V6R1M0.
as400: Connection testServer (11463270) : Server CCSID = 870.
as400: Connection testServer (11463270) : Server functional level = V6R1M00014 (14).
as400: Connection testServer (11463270) : Server job identifier = 072485/QUSER/QZDASOINIT.
as400: Properties (16020374) : decimal separator = ".".
as400: Properties (16020374) : date format = "dmy".
as400: Properties (16020374) : date separator = "/".
as400: Properties (16020374) : time format = "hms".
as400: Properties (16020374) : time separator = ":".
as400: Connection S65AB7B0 (11463270) open.
as400: Connection S65AB7B0 (11463270) : Auto commit = "true".
as400: Connection S65AB7B0 (11463270) : Read only = "false".
as400: Connection S65AB7B0 (11463270) : Transaction isolation = "1".
as400: Connection S65AB7B0 (11463270) : Auto commit = "false".
as400: PreparedStatement STMT0001 (15696851) open. Parent: Connection S65AB7B0 (11463270) .
as400: PreparedStatement STMT0001 (15696851) : Escape processing = "true".
as400: PreparedStatement STMT0001 (15696851) : Fetch direction = "1000".
as400: PreparedStatement STMT0001 (15696851) : Fetch size = "0".
as400: PreparedStatement STMT0001 (15696851) : Max field size = "0".
as400: PreparedStatement STMT0001 (15696851) : Max rows = "0".
as400: PreparedStatement STMT0001 (15696851) : Query timeout = "0".
as400: PreparedStatement STMT0001 (15696851) : Result set concurrency = "1007".
as400: PreparedStatement STMT0001 (15696851) : Result set holdability = "1".
as400: PreparedStatement STMT0001 (15696851) : Result set type = "1003".
as400: PreparedStatement STMT0001 (15696851) : Behavior Override = "0".
as400: PreparedStatement STMT0001 (15696851) : Data to correlate statement with cursor Cursor CRSR0001 (12039161) .
as400: PreparedStatement STMT0001 (15696851) : Preparing [SELECT *SQLGENCOLUMNS FROM NEW TABLE(insert into test_v6r1 (id, value ) values (?, ?))].
as400: PreparedStatement STMT0001 (15696851) : Prepared STMT0001*, SQL Statement -->[SELECT *SQLGENCOLUMNS FROM NEW TABLE(insert into test_v6r1 (id, value ) values (?, ?))].
as400: PreparedStatement STMT0001 (15696851) : setInt().
as400: PreparedStatement STMT0001 (15696851) : parameter index: 1 value: 1.
as400: PreparedStatement STMT0001 (15696851) : setString().
as400: PreparedStatement STMT0001 (15696851) : parameter index: 2 value: Test: 2011-04-27 16:39:53.839.
as400: PreparedStatement STMT0001 (15696851) : Descriptor 1 created or changed.
as400: Cursor CRSR0001 (12039161) open.
as400: ResultSet CRSR0001 (13725633) open. Parent: PreparedStatement STMT0001 (15696851) .
as400: ResultSet CRSR0001 (13725633) : Conncurrency = "1007".
as400: ResultSet CRSR0001 (13725633) : Fetch direction = "1000".
as400: ResultSet CRSR0001 (13725633) : Fetch size = "0".
as400: ResultSet CRSR0001 (13725633) : Max rows = "0".
as400: ResultSet CRSR0001 (13725633) : Type = "1004".
as400: PreparedStatement STMT0001 (15696851) : Executed STMT0001*, SQL Statement --> [SELECT *SQLGENCOLUMNS FROM NEW TABLE(insert into test_v6r1 (id, value ) values (?, ?))].
as400: PreparedStatement STMT0001 (15696851) : Update count = 0.
as400: PreparedStatement STMT0001 (15696851) : Result set = false.
as400: PreparedStatement STMT0001 (15696851) : Number of result sets = 0.
as400: PreparedStatement STMT0001 (15696851) : Row count estimate = -1.
as400: Connection S65AB7B0 (11463270) : Fetching a block of data from the system.
PS1 - SQL insert affected 0 rows and returned 0 keys
PS1 - getUpdateCount()=0
as400: PreparedStatement STMT0002 (540190) open. Parent: Connection S65AB7B0 (11463270) .
as400: PreparedStatement STMT0002 (540190) : Escape processing = "true".
as400: PreparedStatement STMT0002 (540190) : Fetch direction = "1000".
as400: PreparedStatement STMT0002 (540190) : Fetch size = "0".
as400: PreparedStatement STMT0002 (540190) : Max field size = "0".
as400: PreparedStatement STMT0002 (540190) : Max rows = "0".
as400: PreparedStatement STMT0002 (540190) : Query timeout = "0".
as400: PreparedStatement STMT0002 (540190) : Result set concurrency = "1007".
as400: PreparedStatement STMT0002 (540190) : Result set holdability = "1".
as400: PreparedStatement STMT0002 (540190) : Result set type = "1003".
as400: PreparedStatement STMT0002 (540190) : Behavior Override = "0".
as400: PreparedStatement STMT0002 (540190) : Data to correlate statement with cursor Cursor CRSR0002 (19287723) .
as400: PreparedStatement STMT0002 (540190) : Preparing [insert into test_v6r1 (id, value) values (?, ?)].
as400: PreparedStatement STMT0002 (540190) : Prepared STMT0002*, SQL Statement -->[insert into test_v6r1 (id, value) values (?, ?)].
as400: PreparedStatement STMT0002 (540190) : setInt().
as400: PreparedStatement STMT0002 (540190) : parameter index: 1 value: 2.
as400: PreparedStatement STMT0002 (540190) : setString().
as400: PreparedStatement STMT0002 (540190) : parameter index: 2 value: Test: 2011-04-27 16:39:53.839.
as400: PreparedStatement STMT0002 (540190) : Descriptor 2 created or changed.
as400: PreparedStatement STMT0002 (540190) : Executed STMT0002*, SQL Statement --> [insert into test_v6r1 (id, value) values (?, ?)].
as400: PreparedStatement STMT0002 (540190) : Update count = 1.
as400: PreparedStatement STMT0002 (540190) : Result set = false.
as400: PreparedStatement STMT0002 (540190) : Number of result sets = 0.
as400: PreparedStatement STMT0002 (540190) : Row count estimate = -1.
PS2 - SQL insert affected 1 rows and returned 0 keys
PS2 - getUpdateCount()=1
as400: Connection S65AB7B0 (11463270) : Testing to see if cursors should be held..
as400: Connection S65AB7B0 (11463270) : Transaction commit.
as400: Cursor CRSR0001 (12039161) : Closing with reuse flag = 240.
as400: Cursor CRSR0001 (12039161) closed.
as400: ResultSet CRSR0001 (13725633) closed.
as400: PreparedStatement STMT0001 (15696851) closed.
as400: PreparedStatement STMT0002 (540190) closed.
as400: Connection S65AB7B0 (11463270) closed.
当使用标志 RETURN_GENERATED_KEYS
时应该注意的最重要的事情是准备语句的准备方式。
在 V6R1 的情况下,这样的声明:
insert into test_v6r1 (id, value ) values (?, ?)
内部准备为:
SELECT *SQLGENCOLUMNS FROM NEW TABLE(insert into test_v6r1 (id, value ) values (?, ?))
在 V5R4 的情况下,它是正常准备的:
insert into test_v6r1 (id, value ) values (?, ?)
PreparedStatement.executeUpdate()
的 Javadoc说:
Executes the SQL statement in this PreparedStatement object, which must be an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.
Returns: either (1) the row count for SQL Data Manipulation Language (DML) statements or (2) 0 for SQL statements that return nothing
而且执行的语句明显是DML语句。 我怀疑这是 JTOpen/JT400 中的错误 。我试过 6.1 和 7.3,结果是一样的。
关于java - 通过JBDC获取在IBM DB2 V6R1 (AS400)上插入的行数,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/5803036/
我有一个 k*n矩阵 X 和 k*k矩阵A。对于X的每一列,我想计算标量 X[:, i].T.dot(A).dot(X[:, i]) (或者,数学上, Xi' * A * Xi )。 目前,我有一个
很难说出这里问的是什么。这个问题是含糊的、模糊的、不完整的、过于宽泛的或修辞性的,无法以目前的形式得到合理的回答。如需帮助澄清此问题以便重新打开它,visit the help center 。 已关
我是 VueJS 的新手。我已经使用 vuetify/webpack-ssr 模板创建了一个项目,现在我想创建一个登录页面,但是没有显示表单,控制台给了我以下信息: [Vue warn]: Unkno
我尝试将 value 插入到 C++ vector v 之前的第 i 元素(或元素 (i-1) 之后) )。代码很简单 v.insert(v.begin() + i, value); 我确信当 i 介
我需要显示使用合并排序算法排序的 vector 。然而,当我使用 v.begin() 时,我的 friend 使用 v.data() 来传递 vector 。他的代码运行良好,而我的却不行。请解释。
这是我的命令(url1、url2、url3、url4 是占位符): ffmpeg -i url1 -i url2 -i url3 -i url4 -filter_complex “[1:v:0] [1
我以前用过Vue,我知道怎么用v-for渲染元素序列,v-if或v-show有条件地显示元素,并且 v-model例如,控制段落的内容。 但现在我需要对 DOM 进行更精细的控制: 我有一个range
我正在学习所有权和借用。 borrow1 和borrow2 的区别在于在borrow2 打印时使用了&: fn borrow1(v: &Vec) { println!("{}", &v[10]
我找不到一种方法来选择不同的选项来渲染 v-for 中的文本。是否有可能或者我是否需要以不同的方式构建逻辑来执行类似于下面的代码的操作? // i
Iterable 的三个直接子类型是 Map , Seq , 和 Set .除了性能问题之外,似乎还有一个 Seq是从整数到值的映射,以及 Set是从值到 bool 值的映射(如果值在集合中,则为 t
我想应用一个计算方法,如果键存在则增加值,否则将 1。有 Map map = new HashMap<>(); 我不明白为什么 for (int i = 0; i v != null ? v++ :
标准(IEEE 754/C)是否保证以下代码断言永远不会失败? int main() { for ( /* all possible float / double values */ )
代码由Vue语言编写,使用Element-ui框架, 如果一个对象包含某些内容,则会显示该内容,如果不包含则禁用菜单按钮。 输出应该是这样的: a、b(禁用)、c、d、e 但我的是这样的: a、a(禁
如果我这样做: {{ morevalue }} {{ value }} v-else 中的跨度也会在第二个 V-FOR 上循环,即使它上面没有任何 v-for,为什么? 这是
如果我这样做: {{ morevalue }} {{ value }} v-else 中的跨度也会在第二个 V-FOR 上循环,即使它上面没有任何 v-for,为什么? 这是
我将 Vue.js 与 Vuetify 一起使用,我正在尝试使用 v-data-table 从后端加载菜单列表并使用 对其设置一些权限v-switches 但我在尝试 v-model 数组时遇到问题:
我在 Java 的流式操作中努力维护我想要的数据结构,这很可能是由于缺乏正确的理解和实践。 public class Main { public static void main(String
我正在尝试为匹配中的每个匹配呈现一些 HTML,但是,我不太确定 实际上是正确的。 更具体地说,我不确定我是否可以使用 v-bind:match='match'在与循环相同的元素上 v-for='ma
所以我想知道为什么这个 v-if 和 v-else 语句不起作用,为什么我要以不同的方式解决它。 代码如下 Required: Select a Workflow {{ isChain ?
我有一个 VueJS 组件 ,我在同一个模板中使用了两次来显示两组不同的数据。每个都显示在自己的 使用 v-if 切换的容器在导航选项卡上。 似乎这些组件被实例化为同一个实例。我调用 console
我是一名优秀的程序员,十分优秀!