-79844 Cant create/remove UDT/UDR as no database is specified in the connection
Explanation
Your application created a connection without specifying
a database. The following example establishes a connection and opens
a database named test:
url = "jdbc:informix-sqli:myhost:1533/test:"
+
"informixserver=myserver;user=rdtest;
password=test";
conn = DriverManager.getConnection(url);
The following
example establishes a connection with no database open:
url = "jdbc:informix-sqli:myhost:1533:"
+
"informixserver=myserver;user=rdtest;
password=test";
conn = DriverManager.getConnection(url);
User response
To resolve this problem, use the following SQL
statements after the connection is established and before calling the createUDT() or createUDRs() methods:
Statement stmt = conn.createStatement();
stmt.executeUpdate("create database test
...");
Alternatively, use the following code:
stmt.executeUpdate("database test");