[DERBY-159] When Derby runs in Network Server mode, client does not receive warnings generated by Derby - should get documented

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1
• Fix Version/s: 10.8.2.2, 10.9.1.0
• Component/s: Documentation, Network Server
• Labels: derby_backport_reject_10_5
• Urgency: Normal
• Issue & fix info: Repro attached
• Assignee: Camilla Haase
• Reporter: Mamta A. Satoor
• Created: 05/Mar/05 03:21
• Updated: 15/Nov/13 08:15
• Resolved: 12/Sep/12 23:20

Description

A simple code below will demonstrate that warnings generated by Derby running in Server mode do not make their way to client. The client code below is trying to create the database db1drda which already exsits. Server generates a warning for that but the client cde below does not print it.

con = DriverManager.getConnection("jdbc:derby:net://localhost:1527/db1drda;create=true:retrieveMessagesFromServerOnGetMessage=true;", "app", "app");
SQLWarning warnings1 = con.getWarnings();
System.out.println("database exists, should get warning");
while (warnings1 != null)
{
System.out.println("warnings on connection = " + warnings1);
warnings1 = warnings1.getNextWarning();
}

Issue Links

• is related to: DERBY-307 create=true in client connect throws ex if database exists
• relates to: DERBY-5907 Warnings missing on client driver
• relates to: DERBY-4636 ij reports a warning when you use 'create=true' to connect to an existing database using the embedded driver but not when you use the network driver
• relates to: DERBY-5191 Documentation needed for connection URL attribute retrieveMessageText