Skip to Main Content
Forums

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

sintax error executing command to db2 with jdbc

Luis AlvaraezMar 21 2025

Hi,

I'm trying to execute a command with db2 jdbc. With db2 util I don't have problems but with jdbc it says me:

com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=USS;REBIND PACKAGE ;JOIN, DRIVER=4.26.14
at com.ibm.db2.jcc.am.b7.a(b7.java:810)
at com.ibm.db2.jcc.am.b7.a(b7.java:66)
at com.ibm.db2.jcc.am.b7.a(b7.java:140)
at com.ibm.db2.jcc.am.k4.c(k4.java:2824)
at com.ibm.db2.jcc.am.k4.d(k4.java:2808)
at com.ibm.db2.jcc.am.k4.b(k4.java:2168)
at com.ibm.db2.jcc.t4.ab.k(ab.java:446)
at com.ibm.db2.jcc.t4.ab.c(ab.java:104)
at com.ibm.db2.jcc.t4.p.b(p.java:38)
at com.ibm.db2.jcc.t4.av.h(av.java:124)
at com.ibm.db2.jcc.am.k4.ak(k4.java:2163)
at com.ibm.db2.jcc.am.k4.a(k4.java:3366)
at com.ibm.db2.jcc.am.k4.e(k4.java:1131)
at com.ibm.db2.jcc.am.k4.execute(k4.java:1110)
at DB2ConnectionTest.main(DB2ConnectionTest.java:31)

The code is:

public class DB2ConnectionTest {
public static void main(String[] args) {

String url = "jdbc:db2://host:50011/DB11:currentSchema=SCHEMA;ccsid=923;";
String user = "USS";
String password = "XXXXXXX";

// El comando REBIND que deseas ejecutar
String rebindSQL = "REBIND PACKAGE SCHEMA.FSFFSF VERSION '2023-01-03-22.01.33'";

try {

Any help? Thanks

Comments

Processing

Post Details

Added on Mar 21 2025
0 comments
16 views