You will need to add a cast in the second line of code above. It should look like the following:
javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup("java:comp/env/jdbc/cl");
Vamsi
On 9/4/06, Bob Dushok <[EMAIL PROTECTED]> 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
>
>
