db2设置默认schema_java中DB2数据库的jdbc连接如何设置默认的schema

privatefinalstaticStringURL="xxx";privatefinalstaticStringUSER_NAME="xxx";privatefinalstaticStringPASSWORD="xxx";privatefinalstaticStringCURRENT_SCHEMA="xxx";publicstatic...

private final static String URL = "xxx";

private final static String USER_NAME = "xxx";

private final static String PASSWORD = "xxx";

private final static String CURRENT_SCHEMA = "xxx";

public static Connection getConn() {

Properties properties = new Properties();

properties.setProperty("user",USER_NAME);

properties.setProperty("password",PASSWORD);

properties.setProperty("currentSchema",CURRENT_SCHEMA);

Connection conn = null;

try {

Class.forName(DRIVER_NAME).newInstance();

conn = DriverManager.getConnection(URL, properties);

//conn = DriverManager.getConnection(URL, USER_NAME, PASSWORD);

} catch (Exception e) {

e.printStackTrace();

}

return conn;

}

这是我的代码，代码在与DB2数据库交互时总提示错误 我在sql语句中表名字前面加上schema(select * from myschema.mytable )就能正确运行 如果不加schema就不行

怎么才能让我的jdbc连接设置默认schema

展开