I am trying to configure JNDI to access Oracle 9i R1,
according to JNDI Datasource HOW-TO,
however I am not obtaining a lot of success when I go
to establish the connection.
In the end of this e-mail I will list some fragments of the configuration of
server.xml,
web.xml and of my class java that I am using to accomplish the connection test.
The reference $CATALINA_HOME/common/lib/*. jar is in CLASSPATH of the system
Fragment of configuration of server.xml
...
<Resource name="jdbc/sged" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/sged">
<parameter><name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value></parameter>
<parameter><name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value></parameter>
<parameter><name>url</name>
<value>jdbc:oracle:[EMAIL PROTECTED]:1521:XXX</value></parameter>
<parameter><name>username</name><value>scott</value></parameter>
<parameter><name>password</name><value>jjjjj</value></parameter>
<parameter><name>maxActive</name><value>20</value></parameter>
<parameter><name>maxIdle</name><value>10</value></parameter>
<parameter><name>maxWait</name><value>10000</value></parameter>
<parameter><name>removeAbandoned</name><value>true</value></parameter>
<parameter><name>removeAbandonedTimeout</name><value>60</value></parameter>
<parameter><name>logAbandoned</name><value>true</value></parameter>
</ResourceParams>
...
File /web/WEB-INF/web.xml
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app PUBLIC
"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd";>
<web-app>
<description>Oracle Database Connection</description>
<resource-ref>
<description>Pool</description>
<res-ref-name>jdbc/sged</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
<welcome-file>index.jsp</welcome-file>
<welcome-file>index.htm</welcome-file>
</welcome-file-list>
</web-app>
Method of the class java that makes the connection test
public String obtem_dados()
{
Connection conn = null;
Statement stmt = null;
ResultSet rset = null;
resultado = new StringBuffer();
try
{
Context initContext = new InitialContext();
Context envContext =
(Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/sged");
conn = ds.getConnection();
stmt = conn.createStatement();
rset = stmt.executeQuery("SELECT COUNT(*) FROM V$SESSION");
if (rset.next())
{
resultado.append("Número de Conexões -> ");
resultado.append(rset.getString(1));
resultado.append("<br>");
}
}
catch (java.lang.Exception e)
{
resultado.append(e.getMessage());
resultado.append("<br>");
}
finally
{
if (conn != null)
{
try
{
conn.close();
}
catch (java.lang.Exception ex)
{
resultado.append(ex.getMessage());
resultado.append("<br>");
}
}
}
return ((resultado.toString()));
}
Ao executar o método anterior, recebo a seguinte mensagem de erro:
Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL
jdbc:oracle:[EMAIL PROTECTED]:1521:XXX
Alguém tem alguma idéia do que pode estar acontecendo?
Excuse me for the gigantic message.
I thank in advance.
Sebastião Carlos Santos
Oracle Database Administrator
Universidade Federal de Uberlândia - UFU
Gratificação de Estímulo à Docência - GED
