Pessoal:
Estou tentando utilizar um pool de conexão do tomcat (DataSource), mas estou tomando o erro acima. Alguém pode me ajudar, seguem as configurações.
server.xml
…
<Resource name="jdbc/myoracle" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/myoracle">
<parameter>
<name>driverClassName</name>
<value>"oracle.jdbc.OracleDriver"</value>
</parameter>
<parameter>
<name>url</name>
<value>"jdbc:oracle:thin:@10.10.10.10:0000:BD"</value>
</parameter>
<parameter>
<name>username</name>
<value>usuario</value>
</parameter>
<parameter>
<name>password</name>
<value>senha</value>
</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>
</Context>
web.xml
Resource reference to java.sql.Connection
factory defined in server.xml
jdbc/myoracle
javax.sql.DataSource
Container
classe de conexao
public class ConnectionFactory {
public static Connection getConnection() throws SQLException {
try {
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup(“java:/comp/env/”);
DataSource ds = (DataSource)envContext.lookup(“jdbc/myoracle”);
return ds.getConnection();
} catch (NamingException ne) {
throw new SQLException(ne.getMessage());
}
}
}
[color=red]Erro
Name java: is not bound in this Context[/color]
IDE: Eclipse
Servidor: Tomcat 5.5