DataSource Tomcat 5.5

Assuntos Gerais
#1

Estou com um erro ao configurar o DataSource do Tomcat 5.5.

Vejam o código de configuração do arquivo server.xml:

[code]<Context path="/meucontexto" docBase="/meucontexto"
debug="5" reloadable="true" crossContext="true">

   	&lt;Resource name=&quot;jdbc/myDs&quot; auth=&quot;Container&quot;
      type=&quot;javax.sql.DataSource&quot; driverClassName=&quot;com.mysql.jdbc.Driver&quot;
      url=&quot;jdbc&#58;mysql&#58;//localhost&#58;3306/dbmysql&quot;
      username=&quot;root&quot; password=&quot;xxxxxx&quot; maxActive=&quot;20&quot; maxIdle=&quot;10&quot; maxWait=&quot;3000&quot;/&gt;

&lt;/Context&gt;[/code]

Da página jsp:

[code]<%
Connection conexao;
ResultSet rs;
DataSource ds;

    try &#123;  
            Context context = new InitialContext&#40;&#41;;
            Context lautx = &#40;Context&#41; context.lookup&#40;&quot;java&#58;comp/env&quot;&#41;;
            ds = &#40;DataSource&#41;lautx.lookup&#40;&quot;jdbc/myC1gDs&quot;&#41;;
              
            conexao = ds.getConnection&#40;&#41;;
            out.write&#40;&quot;Conectado SQLServer via JNDI!&lt;br&gt;&lt;br&gt;&quot;&#41;;
            Statement stmt= conexao.createStatement&#40;&#41;;

	// rs = stmt.executeQuery&#40;&quot;SELECT * from XXX&quot;&#41;;
        

            conexao.close&#40;&#41;;

 &#125; catch &#40;SQLException sqle&#41; &#123;

 out.write&#40;&quot;&lt;======= OCORREU UMA EXCEPTION - VERIFICAR =======&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&quot; + sqle&#41;;
  sqle.printStackTrace&#40;&#41;;

    &#125; finally &#123;

}
%>[/code]

Do Erro:

Acho que o arquivo server.xml está configurado corretamente, mas talvez o código da JSP esteja errado.

Obrigado.

#2

Olá,

Eu não tenho certeza do erro mas olha isso:

No server.xml:
jdbc/myDs

No jsp:
jdbc/myC1gDs

Acho que está incoerente…

Espero ter ajudado…
Abraços

#3

[quote=“Pierre”]Estou com um erro ao configurar o DataSource do Tomcat 5.5.

Vejam o código de configuração do arquivo server.xml:

[code]<Context path="/meucontexto" docBase="/meucontexto"
debug="5" reloadable="true" crossContext="true">

   	&lt;Resource name=&quot;jdbc/myDs&quot; auth=&quot;Container&quot;
      type=&quot;javax.sql.DataSource&quot; driverClassName=&quot;com.mysql.jdbc.Driver&quot;
      url=&quot;jdbc&#58;mysql&#58;//localhost&#58;3306/dbmysql&quot;
      username=&quot;root&quot; password=&quot;xxxxxx&quot; maxActive=&quot;20&quot; maxIdle=&quot;10&quot; maxWait=&quot;3000&quot;/&gt;

&lt;/Context&gt;[/code]

Da página jsp:

[code]<%
Connection conexao;
ResultSet rs;
DataSource ds;

    try &#123;  
            Context context = new InitialContext&#40;&#41;;
            Context lautx = &#40;Context&#41; context.lookup&#40;&quot;java&#58;comp/env&quot;&#41;;
            ds = &#40;DataSource&#41;lautx.lookup&#40;&quot;jdbc/myC1gDs&quot;&#41;;
              
            conexao = ds.getConnection&#40;&#41;;
            out.write&#40;&quot;Conectado SQLServer via JNDI!&lt;br&gt;&lt;br&gt;&quot;&#41;;
            Statement stmt= conexao.createStatement&#40;&#41;;

	// rs = stmt.executeQuery&#40;&quot;SELECT * from XXX&quot;&#41;;
        

            conexao.close&#40;&#41;;

 &#125; catch &#40;SQLException sqle&#41; &#123;

 out.write&#40;&quot;&lt;======= OCORREU UMA EXCEPTION - VERIFICAR =======&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&quot; + sqle&#41;;
  sqle.printStackTrace&#40;&#41;;

    &#125; finally &#123;

}
%>[/code]

Do Erro:

Acho que o arquivo server.xml está configurado corretamente, mas talvez o código da JSP esteja errado.

Obrigado.[/quote]

No lugar de javax.sql.DataSource, use com.mysql.jdbc.jdbc2.optional.MysqlDataSource

#4