tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kunthar" <kunt...@gmx.net>
Subject Re: I'll kill JNDI
Date Tue, 15 Jun 2004 15:32:16 GMT
Thank you for your answer,
I've already done the same thing before i sent message to list. But i've
found that i should point this configuration to the every
context.
When i open admin section and go to Service(Catalina) /Host / Context
(/test) i saw that the defined jdbc connection in server.xml is not defined
for this context.
In DBCP Pool description it says, if you define a jdbc connection in
server.xml and put <resource-ref> tags to the web.xml and it works well.
This is not working on this way.
You should go to admin interface and should define your connection inside of
context.

Anyway,

It is now working for mee too..
Take care of all...


----- Original Message ----- 
From: "Adam Smith" <ajus@csolve.net>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Sent: Tuesday, June 15, 2004 2:15 PM
Subject: Re: I'll kill JNDI


> I can confirm that postgresql works ok with DBCP. All of my persistent
> components call the same connection code, whatever the database. It is
doing
> the following :
>
> public static Connection Connect(String resourcename)
>  throws javax.naming.NamingException, java.sql.SQLException
>  {
>   Context initContext = new InitialContext();
>   Context envContext  = (Context)initContext.lookup("java:/comp/env");
>   DataSource ds = (DataSource)envContext.lookup(resourcename);
>   return ds.getConnection();
>  }
>
> The resourcename passed in will be something like "jdbc/asl". An example
> server.xml entry looks
> like :
>
> <ResourceParams name="jdbc/asl">
>   <parameter>
>     <name>factory</name>
>     <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
>   </parameter>
>   <parameter>
>     <name>driverClassName</name>
>     <value>org.postgresql.Driver</value>
>   </parameter>
>   <parameter>
>     <name>url</name>
>     <value>jdbc:postgresql://132.1.6.8:5432/asl</value> <!-- asl is a
> database that has been created in postgres -->
>   </parameter>
>   <parameter>
>     <name>username</name>
>     <value>bsuser</value> <!-- not the real user I'm using -->
>   </parameter>
>   <parameter>
>     <name>password</name>
>     <value>bspassword</value> <!-- not the real password I'm using -->
>   </parameter>
>   <parameter>
>     <name>maxActive</name>
>     <value>20</value>
>   </parameter>
>   <parameter>
>     <name>maxIdle</name>
>     <value>10</value>
>   </parameter>
>   <parameter>
>     <name>maxWait</name>
>     <value>-1</value>
>   </parameter>
> </ResourceParams>
>
>
> Hope this helps.
>
> Adam Smith
>
> ----- Original Message -----
> From: "Kunthar" <kunthar@gmx.net>
> To: <tomcat-user@jakarta.apache.org>
> Sent: Sunday, June 13, 2004 12:19 PM
> Subject: I'll kill JNDI
>
>
> > Hi all,
> >
> > I've installed apache 2.049 + Tomcat 5.0.26 + PostgreSQL and i could
> > connect apache to tomcat after painful night with mod_jk2.
> > So far so good.
> > I could do regular jdbc connection by using traditional
> > Class.forName(ZOBARA) method to my existing fair pgsql.
> > Then i wanted to try my first application's jdbc connection with DBCP
> > Pool exist on Tomcat. You know, we need it for bunch of reasons.
> > I've read the documentation and also downloaded related JNDI reference
> > from sun (which is completely makes blah blah about LDAP)
> > Check List;
> > 0. rh-postgresql3.jar copied to $CATALINA_HOME/common/lib and removed
> > from the all other locations.
> > 1. Server.xml changed for postgre jdbc driver as described. (Checked for
> > context tags)
> > 2. web.xml changed as described.
> > 3. My application connection element uses clear sample
> > // Obtain our environment naming context
> > Context initCtx = new InitialContext();
> > Context envCtx = (Context) initCtx.lookup("java:comp/env");
> >
> > // Look up our data source
> > DataSource ds = (DataSource)
> >   envCtx.lookup("jdbc/mydb");
> >
> > 4. Built this holly mess with ant by using build.xml
> > 5. Point to my page and see this
> > "java.sql.SQLException: No connection"
> >
> > Is there any single one have an idea what's going on???
> > I've double checked all the things. If anyone using postgreSQL with DBCP
> > please give me a hint.
> >
> > Thanks
> > Take care all
> >
> >
> > Note: Turkish list fellows just drop me a line :=)
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >
> >
> >
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.706 / Virus Database: 462 - Release Date: 14.06.2004


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


Mime
View raw message