[DERBY-2851] Corrections to client DataSource access example in the Server and administration guide

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 10.3.1.4
• Component/s: Test
• Assignee: Laura Stewart
• Reporter: Katherine Marsden
• Created: 20/Jun/07 20:22
• Updated: 21/Jan/11 18:13
• Resolved: 05/Jul/07 18:18

Description

http://db.apache.org/derby/docs/dev/adminguide/radminnsdatasourcexmp.html

Shows an example for getting a connection through a DataSource by setting databaseName to "mydb;create=true". It should be changed to use "mydb" and use setCreateDatabase("create"). Also the comment that user/password are required is not correct.

I think the getDS method can be removed and the example can just look like:

org.apache.derby.jdbc.ClientDataSource ds =
new org.apache.derby.jdbc.ClientDataSource();

// DatabaseName can include Derby URL Attributes

ds.setDatabaseName("mydb");
ds.setCreateDatabase("create");
ds.setUser("user");
ds.setPassword("mypass");

// The host on which Network Server is running
ds.setServerName("localhost");

// port on which Network Server is listening
ds.setPortNumber(1527);

Connection conn = ds.getConnection();