Re: facelets & jdbc (homework)
Thufir wrote:
For HW purposes, there can't be any Tomcat configurations :(
What do you mean by "HW purposes"?
So that, while indeed, I can
Context ctx = new InitialContext();
ds = (DataSource) ctx.lookup("java:comp/env/jdbc/mssql");
the exception:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC
driver class ???com.microsoft.sqlserver.jdbc.SQLServerDriver
Did you try adding the JDBC driver JAR to your WAR?
is a show stopper. It's not possible to do something like:
ServletConfig config = getServletConfig();
ServletContext context = getServletContext();
String uid = config.getInitParameter("UID");
You always risk being wrong when you say, "It's not possible."
I guess I was mixing up the ServletContext with
javax.naming.InitialContext and javax.sql.DataSource.
While I'll put the connection parameters into a properties file, at
least I learned a bit about dbcp and jndi :)
If you're using Faces, you can get at the ServletContext through the FacesContext:
<http://java.sun.com/javaee/6/docs/api/javax/faces/context/FacesContext.html#getCurrentInstance()>
<http://java.sun.com/javaee/6/docs/api/javax/faces/context/FacesContext.html#getExternalContext()>
<http://java.sun.com/javaee/6/docs/api/javax/faces/context/ExternalContext.html#getContext()>
FacesContext fctx = FacesContext.getCurrentInstance();
ServletContext sctx = (ServletContext)
fctx.getExternalContext().getContext();
--
Lew