DriverManager vs. DataSource

[drieskn]

Hello,

I am using Eclipse 3.4.2 and Java 1.6. I have a Apache Derby database installed. I try to learn using this by following the JDBC Database Access trail in the Sun Java Tutorials.
I can make a connection to the database using DriverManager.getConnection, this works fine. However, the tutorial states that using the DataSource interface is the preferred method. So I try that also. Unfortunately, the tutorial only gives this example:

InitialContext ic = new InitialContext()
 
 DataSource ds = ic.lookup("java:comp/env/jdbc/myDB");
 Connection con = ds.getConnection();
 DataSource ds = (DataSource) org.apache.derby.jdbc.ClientDataSource()
 ds.setPort(1527);
 ds.setHost("localhost");
 ds.setUser("APP")
 ds.setPassword("APP");
 
Connection con = ds.getConnection();

My questions:
1) ds and con are declared twice. Can it be that two examples have been merged inadvertedly?
2) the methods setPort ... are not defined for DataSource. Indeed, the tutorial goes on to say that "DataSource implementations must provide getter and setter methods for each property they support." Is this something that has to be done outside my program, e.g. with DTP?
3) Does anyone know a book or tutorial where DataSource is better explained?

Thanks in advance, DriesKn.

[mtyoung]

InitialContext ic = new InitialContext();
DataSource ds = (DataSource) ic.lookup(dbName);
Connection 	con = ds.getConnection();

above code should be a example of ds
other setting for jdbc resource and connection pool should set in J2EE server

[ProjectKaiser]

1) Obviously few samples are merged.

2) Second DataSource actually is of org.apache.derby.jdbc.ClientDataSource type and therefore has setPort() method.

3) I find javadoc explanation pretty good. DataSource (Java 2 Platform SE v1.4.2)

[drieskn]

The statement

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

looks like a method invocation, but org.apache.derby.jdbc.ClientDataSource is a class. I expect that I have to use some static method of this class to give me a reference to the data source, but there isn't such a method. I can't find setPort either, for that matter. I ran the ClassSpy ( in the Reflection part of the Java Tutorials) program on this class.
So creating an object by

DataSource ds = new ClientDataSource();

and trying to invoke ds.getPort() doesn't work.

drieskn

[mtyoung]

i dont know why Tutorial page code like that...

have you check that

Use these DataSources if your application runs under JDBC3.0 or JDBC2.0, that is, on the following Java Virtual Machines:

JDBC 3.0 - Java 2 - JDK 1.4, J2SE 5.0
JDBC 2.0 - Java 2 - JDK 1.2,1.3

from ClientDataSource (Apache Derby 10.5 API Documentation)