Re: JNDI Datasource example
От | Mag Gam |
---|---|
Тема | Re: JNDI Datasource example |
Дата | |
Msg-id | 1093698560.18627.203238436@webmail.messagingengine.com обсуждение исходный текст |
Ответ на | Re: JNDI Datasource example (Harry Schittler <hs@multimedia-werkstatt.com>) |
Ответы |
Re: JNDI Datasource example
(Harry Schittler <hs@multimedia-werkstatt.com>)
|
Список | pgsql-jdbc |
When I run this code snipnet, I get this problem. symbol : variable datasource location: class Test datasource = (DataSource)envContext.lookup(jndiName); ^ Test.java:22: cannot resolve symbol symbol : variable jndiName location: class Test datasource = (DataSource)envContext.lookup(jndiName); echo $CLASSPATH /usr/local/j2sdk1.4.2_05/lib/tools.jar:/usr/local/j2sdk1.4.2_05/jre/lib/rt.jar:/usr/local/jakarta-tomcat-4.1.30/common/lib/servlet.jar:/usr/local/jakarta-tomcat-4.1.30/common/lib/pg74.215.jdbc3.jar I looked everywhere, still problems with this datasource. Thanks! On Sat, 28 Aug 2004 01:33:51 +0200, "Harry Schittler" <hs@multimedia-werkstatt.com> said: > Mag Gam wrote: > > >Does anyone have a GOOD example of PostgreSQL with Tomcat using JNDI? I > >was looking at > >http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html > >but the code they provided really did not help. If someone has some code > >please post it. Thanks in advance! > > > > > Just case you were using the same approach as I did and used the tomcat > admin application to create the JNDI resource > > Lets assume a datasource named "jdbc/testds" and a context named > "testctx" > > put your postgres jdbc driver into $TOMCAT/common/lib, restart Tomcat > > Create the datasource using the tomcat admin application, use > org.postgresql.Driver as driverClass and > jdbc:postgresql://localhost/<database> as URL > > insert the following in your applications WEB-INF/web.xml: > <resource-ref> > <description>DB Connection</description> > <res-ref-name>jdbc/testds</res-ref-name> > <res-type>javax.sql.DataSource</res-type> > <res-auth>Container</res-auth> > </resource-ref> > > Create a META-INF/context.xml and insert: > <Context path="/testctx" reloadable="true"> > <ResourceLink name="jdbc/testds" global="jdbc/testds" > type="javax.sql.DataSource"/> > </Context> > > > Use the following code to lookup the datasource: > try{ > Context ctx = new InitialContext(); > if(ctx == null ) > throw new Exception("JNDI could not create InitalContext "); > > Context envContext = (Context)ctx.lookup("java:/comp/env"); > datasource = (DataSource)envContext.lookup(jndiName); > > } catch(Exception e) { > e.printStackTrace(); > } > > this works for me... > > cu Harry
В списке pgsql-jdbc по дате отправления: