Bob,
Sorry, it is java.sql.Connection not javax. You can fix the other error by
casting it:
javax.sql.DataSource ds =
(javax.sql.DataSource)ctx.lookup("java:comp/env/jdbc/cl");
Next time I should test an example before posting it :)
-
Rik
On Sun, 3 Sep 2006, Bob Dushok wrote:
Rik,
Thanks for the reply.
The errors change when I make the code changes. I'm now encountering
the following:
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 12 in the jsp file: /demo/pooltest.jsp
Generated servlet error:
Type mismatch: cannot convert from Object to DataSource
An error occurred at line: 12 in the jsp file: /demo/pooltest.jsp
Generated servlet error:
javax.sql.Connection cannot be resolved to a type
Bob
On Sep 3, 2006, at 4:55 PM, Rik wrote:
Hi,
Do you still have those errors if you replace your code with the following?
javax.naming.InitialContext ctx = new javax.naming.InitialContext();
javax.sql.DataSource ds = ctx.lookup("java:comp/env/jdbc/cl");
javax.sql.Connection con = ds.getConnection();
Rik
Within my code I attempt to access the pool as follows:
InitialContext ctx = new InitialContext();
DataSource ds = ctx.lookup("java:comp/env/jdbc/cl");
Connection con = ds.getConnection();
When the page executes I receive the following errors:
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 12 in the jsp file: /demo/pooltest.jsp
Generated servlet error:
InitialContext cannot be resolved to a type
An error occurred at line: 12 in the jsp file: /demo/pooltest.jsp
Generated servlet error:
InitialContext cannot be resolved to a type
An error occurred at line: 12 in the jsp file: /demo/pooltest.jsp
Generated servlet error:
DataSource cannot be resolved to a type
Could someone tell me what I've done incorrectly? The process seems
straightforward, but I've done something incorrectly.
Thanks,
Bob
