Hi! I'm developing a portlet with Eclipse and it will be integrated in Pluto.
I need to access to a database Oracle using JDBC and JNDI.
I've added to my WEB-INF/web.xml the resource reference:
<resource-ref>
<description>Description</description>
<res-ref-name>jdbc/DBexample</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
To connect I do:
Context ctx = new InitialContext();
DataSource ds = (DataSource)
ctx.lookup("java:/comp/env/jdbc/DBexample");
Connection con = ds.getConnection();
I don't know exactly how to configure the DataSource. At the moment I've a
META-INF/context.xml with the following:
<context>
<Resource name="jdbc/DBexample" auth="Container"
type="javax.sql.DataSource" username="user"
password="password"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@12.230.19.201:1522:DEVELOP2"
maxActive="20" maxIdle="10"/>
</context>
When I do a junit test it give me the following error:
javax.naming.NoInitialContextException: Need to specify class name
in environment or
system property, or as an applet parameter, or in an application
resource file:
java.naming.factory.initial
This error is because don't find the JNDI Resource (I think) but I don't
know where declare this Resource (remember that this portlet is integrated
in Pluto) and if I have to follow more steps (I've added the oracle driver
connector and Jakarta-Commons DBCP 1.2.2, Jakarta-Commons Collections 3.2,
Jakarta-Commons Pool 1.3 to the pluto server (Tomcat v5.5)).
Can you help me ? thanks.
--
View this message in context:
http://www.nabble.com/Portlet-with-JDBC-and-integrated-in-Pluto-tf4848715.html#a13872946
Sent from the Pluto - User mailing list archive at Nabble.com.
