Pool DBCP - ajuda

3 de agosto de 2005 2 respostas

chandPJ 3 de agosto de 2005

Pessoal estou tentando implementar o pool DBCP e não estou conseguindo.

no server.xml faço isto:

&lt;GlobalNamingResources&gt;

	&lt;Resource name=&quot;jdbc/db&quot;  auth=&quot;Container&quot; type=&quot;javax.sql.DataSource&quot; /&gt;
   		&lt;ResourceParams name=&quot;jdbc/db&quot;&gt;
   
      	&lt;parameter&gt;&lt;name&gt;factory&lt;/name&gt;&lt;value&gt;org.apache.commons.dbcp.BasicDataSourceFactory&lt;/value&gt;&lt;/parameter&gt;      
      	&lt;parameter&gt;&lt;name&gt;driverClassName&lt;/name&gt;&lt;value&gt;com.mysql.jdbc.Driver&lt;/value&gt;&lt;/parameter&gt;
      	&lt;parameter&gt;&lt;name&gt;url&lt;/name&gt;&lt;value&gt;jdbc&#58;mysql&#58;//10.84.227.173&#58;3306/evento&lt;/value&gt;&lt;/parameter&gt;
      
      	&lt;parameter&gt;&lt;name&gt;username&lt;/name&gt;&lt;value&gt;root&lt;/value&gt;&lt;/parameter&gt;
      	&lt;parameter&gt;&lt;name&gt;password&lt;/name&gt;&lt;value&gt;&lt;/value&gt;&lt;/parameter&gt;      
      	&lt;parameter&gt;&lt;name&gt;maxActive&lt;/name&gt;&lt;value&gt;20&lt;/value&gt;&lt;/parameter&gt;      
      	&lt;parameter&gt;&lt;name&gt;maxIdle&lt;/name&gt;&lt;value&gt;10&lt;/value&gt;&lt;/parameter&gt;            
      	&lt;parameter&gt;&lt;name&gt;maxWait&lt;/name&gt;&lt;value&gt;100&lt;/value&gt;&lt;/parameter&gt;            
      
   	&lt;/ResourceParams&gt;

  &lt;/GlobalNamingResources&gt;

e isto num servlet

package servlt;

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.naming.*;
import javax.sql.*;
import java.sql.*;

public class teste extends HttpServlet &#123;

	public void service&#40;HttpServletRequest request,HttpServletResponse response&#41;
			throws ServletException, IOException &#123;
			
		InitialContext context;
		try &#123;
			
			context = new InitialContext&#40;&#41;;

			Context ctx = &#40;Context&#41; context.lookup&#40;&quot;java&#58;comp/env/&quot;&#41;;
			DataSource dataSource = &#40;javax.sql.DataSource&#41;ctx.lookup&#40;&quot;jdbc/db&quot;&#41;;
			
			try &#123;
				Connection con = dataSource.getConnection&#40;&#41;;
			&#125; catch &#40;SQLException e1&#41; &#123;
				// TODO Auto-generated catch block
				e1.printStackTrace&#40;&#41;;
			&#125;
		
			System.out.print&#40;&quot;teste&quot;&#41;;
			
		&#125; catch &#40;NamingException e&#41; &#123;
			// TODO Auto-generated catch block
			e.printStackTrace&#40;&#41;;
		&#125;
	&#125;
&#125;

e esta me dando o seguinte erro:

org.apache.tomcat.dbcp.dbcp.SQLNestedException&#58; Cannot create JDBC driver of class '' for connect URL 'null'
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource&#40;BasicDataSource.java&#58;780&#41;
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection&#40;BasicDataSource.java&#58;540&#41;
	at servlt.teste.service&#40;teste.java&#58;43&#41;
	at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;802&#41;
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;252&#41;
	at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;173&#41;
	at org.apache.catalina.core.StandardWrapperValve.invoke&#40;StandardWrapperValve.java&#58;213&#41;
	at org.apache.catalina.core.StandardContextValve.invoke&#40;StandardContextValve.java&#58;178&#41;
	at org.apache.catalina.core.StandardHostValve.invoke&#40;StandardHostValve.java&#58;126&#41;
	at org.apache.catalina.valves.ErrorReportValve.invoke&#40;ErrorReportValve.java&#58;105&#41;
	at org.apache.catalina.core.StandardEngineValve.invoke&#40;StandardEngineValve.java&#58;107&#41;
	at org.apache.catalina.connector.CoyoteAdapter.service&#40;CoyoteAdapter.java&#58;148&#41;
	at org.apache.coyote.http11.Http11Processor.process&#40;Http11Processor.java&#58;856&#41;
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection&#40;Http11Protocol.java&#58;744&#41;
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket&#40;PoolTcpEndpoint.java&#58;527&#41;
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt&#40;LeaderFollowerWorkerThread.java&#58;80&#41;
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run&#40;ThreadPool.java&#58;684&#41;
	at java.lang.Thread.run&#40;Unknown Source&#41;
Caused by&#58; java.sql.SQLException&#58; No suitable driver
	at java.sql.DriverManager.getDriver&#40;Unknown Source&#41;
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource&#40;BasicDataSource.java&#58;773&#41;
	... 17 more

2 Respostas

Juliano_CarnielPJ 3 de ago. de 2005

Olá,

tente só assim:

context = new InitialContext&#40;&#41;;
    DataSource dataSource = &#40;javax.sql.DataSource&#41;context.lookup&#40;"jdbc/db"&#41;;

sem aquela sua linha do meio!

Estou usando assim no OC4J e funciona legal!

Abraços!

chandPJ 4 de ago. de 2005

Pessoal fiz funcionar só que não gostei da solução de criar o Resource no Context, com essa solução todsa vez que criar um aplicativo novo tenho que para o servidor e inserir na mão.

tentei fazer uma conexao global na GlobalNamingResources mas não consegui. me dar erro:

g.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'

solução no Context

&lt;Context path="/eventosnovo" reloadable="true" docBase="D:\projetosJava\v1\workspace\eventosnovo" workDir="D:\projetosJava\v1\workspace\eventosnovo\work"&gt; 

&lt;Resource name="jdbc/db" auth="Container" type="javax.sql.DataSource"
      maxActive="100" maxIdle="30" maxWait="10000"
      username="root" password="" driverClassName="com.mysql.jdbc.Driver"               url="jdbc:mysql://10.84.227.173:3306/evento?autoReconnect=true"/&gt;
&lt;/Context&gt;

este exemplo fiz conforme o Matheus postou no forum. esta solução que para mim seria otima não funciona.
no GlobalNamingResources

&lt;GlobalNamingResources&gt;
 	&lt;Resource name="jdbc/db"  auth="Container" type="javax.sql.DataSource" /&gt;
   	&lt;ResourceParams name="jdbc/db"&gt;
      	&lt;parameter&gt;&lt;name&gt;factory&lt;/name&gt;&lt;value&gt;org.apache.commons.dbcp.BasicDataSourceFactory&lt;/value&gt;&lt;/parameter&gt;      
    	&lt;parameter&gt;&lt;name&gt;driverClassName&lt;/name&gt;&lt;value&gt;com.mysql.jdbc.Driver&lt;/value&gt;&lt;/parameter&gt;
      	&lt;parameter&gt;&lt;name&gt;url&lt;/name&gt;&lt;value&gt;jdbc:mysql://10.84.227.173:3306/evento?autoReconnect=true&lt;/value&gt;&lt;/parameter&gt;
      
      	&lt;parameter&gt;&lt;name&gt;username&lt;/name&gt;&lt;value&gt;root&lt;/value&gt;&lt;/parameter&gt;
      	&lt;parameter&gt;&lt;name&gt;password&lt;/name&gt;&lt;value&gt;&lt;/value&gt;&lt;/parameter&gt;      
      	&lt;parameter&gt;&lt;name&gt;maxActive&lt;/name&gt;&lt;value&gt;20&lt;/value&gt;&lt;/parameter&gt;      
      	&lt;parameter&gt;&lt;name&gt;maxIdle&lt;/name&gt;&lt;value&gt;10&lt;/value&gt;&lt;/parameter&gt;            
      	&lt;parameter&gt;&lt;name&gt;maxWait&lt;/name&gt;&lt;value&gt;100&lt;/value&gt;&lt;/parameter&gt;
   	&lt;/ResourceParams&gt;

  &lt;/GlobalNamingResources&gt;

este exemplo fiz conforme o Matheus postou no forum.
no GlobalNamingResources

&lt;GlobalNamingResources&gt;
 	&lt;Resource name="jdbc/db"  auth="Container" type="javax.sql.DataSource" /&gt;
   	&lt;ResourceParams name="jdbc/db"&gt;
      	&lt;parameter&gt;&lt;name&gt;factory&lt;/name&gt;&lt;value&gt;org.apache.commons.dbcp.BasicDataSourceFactory&lt;/value&gt;&lt;/parameter&gt;      
    	&lt;parameter&gt;&lt;name&gt;driverClassName&lt;/name&gt;&lt;value&gt;com.mysql.jdbc.Driver&lt;/value&gt;&lt;/parameter&gt;
      	&lt;parameter&gt;&lt;name&gt;url&lt;/name&gt;&lt;value&gt;jdbc:mysql://10.84.227.173:3306/evento?autoReconnect=true&lt;/value&gt;&lt;/parameter&gt;
      
      	&lt;parameter&gt;&lt;name&gt;username&lt;/name&gt;&lt;value&gt;root&lt;/value&gt;&lt;/parameter&gt;
      	&lt;parameter&gt;&lt;name&gt;password&lt;/name&gt;&lt;value&gt;&lt;/value&gt;&lt;/parameter&gt;      
      	&lt;parameter&gt;&lt;name&gt;maxActive&lt;/name&gt;&lt;value&gt;20&lt;/value&gt;&lt;/parameter&gt;      
      	&lt;parameter&gt;&lt;name&gt;maxIdle&lt;/name&gt;&lt;value&gt;10&lt;/value&gt;&lt;/parameter&gt;            
      	&lt;parameter&gt;&lt;name&gt;maxWait&lt;/name&gt;&lt;value&gt;100&lt;/value&gt;&lt;/parameter&gt;
   	&lt;/ResourceParams&gt;
  &lt;/GlobalNamingResources&gt;

na web.xml

&lt;resource-ref&gt;
      &lt;res-ref-name&gt;jdbc/db&lt;/res-ref-name&gt;
      &lt;res-type&gt;javax.sql.DataSource&lt;/res-type&gt;
      &lt;res-auth&gt;Container&lt;/res-auth&gt;
  &lt;/resource-ref&gt;

Criado 3 de agosto de 2005

Ultima resposta 4 de ago. de 2005

Respostas 2

Participantes 2

2 Respostas

Topicos relacionados