tomcat-taglibs-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Felipe Vieira Silva <fgau...@gmail.com>
Subject Re: DataSource web.xml question
Date Thu, 10 Feb 2005 11:02:08 GMT
There is a difference between Tomcat and JBoss descriptors about
Datasources... It is the source of a lot of mess in web applications.

Tomcat: java:comp/env/jdbc/<NAME>
JBoss:  java:<NAME>

A common solution is to include the full environment string into a
separated properties file (avoiding the web.xml auto loading by the
container):

            Properties config = new Properties();
            config.load("yourConfigFile.properties");
            String name = config.getProperty("datasource");
            InitialContext context = new InitialContext();
            DataSource dbSource = (DataSource) context
                    .lookup(name);

Note: I´m working on an Open Source project, which contains the
complete source code to access MySql database through Tomcat - if you
are interested, you can check the code at:
https://cejug-classifieds.dev.java.net/source/browse/cejug-classifieds/web-app/

best regards,

   Felipe Gaúcho


On Wed, 09 Feb 2005 21:03:30 -0500, Kris Schneider <kris@dotech.com> wrote:
> Try an <env-entry> instead of a <context-param>:
> 
> <env-entry>
>   <env-entry-name>dataSource</env-entry-name>
>   <env-entry-value>jdbc/RestaurantDS</env-entry-value>
>   <env-entry-type>java.lang.String</env-entry-type>
> </env-entry>
> 
> String envBase = "java:comp/env/";
> Context ctx = new InitialContext();
> String dataSourceName = (String)ctx.lookup(envBase + "dataSource");
> DataSource ds = (DataSource)ctx.lookup(envBase + dataSourceName);
> 
> That way you don't need access to a ServletContext instance.
> 
> Jack Lauman wrote:
> > Schalk:
> >
> > I need to use JDNI... this is a JBoss DataSource.  Any idea on how this
> > might be done?
> >
> > Thanks,
> >
> > Jack
> >
> > Schalk Neethling wrote:
> >
> >> Jack
> >>
> >> This is obviously if you are not using JNDI to lookup a datasource.
> >>
> >> Schalk Neethling wrote:
> >>
> >>> Jack
> >>>
> >>> Within a servlet I use the following:
> >>>
> >>> public class activateArticle extends HttpServlet {
> >>>
> >>>    public String DRIVER, URL, USER, PASS, message;
> >>>              public void init() throws ServletException {
> >>>        ServletContext context = getServletContext();
> >>>        DRIVER = context.getInitParameter("DRIVER");
> >>>        URL = context.getInitParameter("URL");
> >>>        USER = context.getInitParameter("USER");
> >>>        PASS = context.getInitParameter("PASS");
> >>>        }
> >>>
> >>> HTH
> >>>
> >>> Jack Lauman wrote:
> >>>
> >>>> If I have a datasource in the context-param area of the web.xml
> >>>> file, how can it be called?
> >>>>
> >>>> <context-param>
> >>>>    <param-name>jdbcDataSource</param-name>
> >>>>    <param-value>java:comp/env/jdbc/RestaurantDS</param-value>
> >>>> </context-param>
> >>>>
> >>>>
> >>>> pageContext.
> >>>> getServletContext().getInitParameter("insert-context-param-name-here");
> >>>>
> >>>> Doesn't work here...
> >>>>
> >>>> ....
> >>>> private void initialize()
> >>>> {
> >>>>    try {
> >>>>        Context ctx = null;
> >>>>        DataSource ds = null;
> >>>>        Connection conn = null;
> >>>>        Result result = null;
> >>>>        try {
> >>>>            ctx = new InitialContext();
> >>>>            ds = (DataSource)
> >>>>                 ctx.lookup("java:comp/env/jdbc/RestaurantDS");
> >>>>        } catch (Exception e) {
> >>>>        System.out.println("DataSource context lookup failed: " + e);
> >>>>    }
> >>>>    try {
> >>>>        conn = ds.getConnection();
> >>>>        } catch (Exception e) {
> >>>>        System.out.println("DataSource getConnection failed: " + e);
> >>>>          e.printStackTrace();
> >>>>    }
> 
> --
> Kris Schneider <mailto:kris@dotech.com>
> D.O.Tech       <http://www.dotech.com/>
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: taglibs-user-help@jakarta.apache.org
> 
>

---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org


Mime
View raw message