Hi redbeard!
Of course, classes12.jar contains the class I need
(oracle.jdbc.xa.OracleXADataSOurce).
That's my servlet:
package servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
public class DataBaseServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse
response)
throws ServletException, IOException {
PrintWriter out = null;
try {
out = response.getWriter();
Context initContext = new InitialContext();
Context envContext =
(Context)initContext.lookup("java:/comp/env");
DataSource ds =
(DataSource)envContext.lookup("jdbc/myoracle");
Connection conn = ds.getConnection();
String sql = "SELECT nombre FROM candidatos WHERE
id_cand=49851";
PreparedStatement pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
out.println("MAXIM ID :" + rs.getString(1));
}
} catch (Exception e) {
out = response.getWriter();
out.println("error: " + e.getMessage());
e.printStackTrace();
}
}
public void doPost(HttpServletRequest request, HttpServletResponse
response)
throws ServletException, IOException {
doGet(request, response);
}
}
What error do you want me to post? The one which Apache shows or the one when i
call my servlet?
The first one is:
error: jdbc not bound
The second one:
15:41:53,444 INFO [STDOUT] javax.naming.NameNotFoundException: jdbc not bound
15:41:53,448 INFO [STDOUT] at
org.jnp.server.NamingServer.getBinding(NamingServer.java:495)
15:41:53,590 INFO [STDOUT] at
org.jnp.server.NamingServer.getBinding(NamingServer.java:503)
15:41:53,591 INFO [STDOUT] at
org.jnp.server.NamingServer.getObject(NamingServer.java:509)
15:41:53,591 INFO [STDOUT] at
org.jnp.server.NamingServer.lookup(NamingServer.java:253)
15:41:53,591 INFO [STDOUT] at
org.jnp.server.NamingServer.lookup(NamingServer.java:256)
15:41:53,652 INFO [STDOUT] at
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:529)
15:41:53,653 INFO [STDOUT] at
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:508)
15:41:53,653 INFO [STDOUT] at
servlet.DataBaseServlet.doGet(DataBaseServlet.java:41)
15:41:53,653 INFO [STDOUT] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
15:41:53,655 INFO [STDOUT] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
15:41:53,656 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
15:41:53,656 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
15:41:53,656 INFO [STDOUT] at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
15:41:53,656 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
15:41:53,657 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
15:41:53,657 INFO [STDOUT] at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
15:41:53,657 INFO [STDOUT] at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
15:41:53,658 INFO [STDOUT] at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
15:41:53,658 INFO [STDOUT] at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
15:41:53,658 INFO [STDOUT] at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
15:41:53,658 INFO [STDOUT] at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
15:41:53,659 INFO [STDOUT] at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:44)
15:41:53,659 INFO [STDOUT] at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
15:41:53,659 INFO [STDOUT] at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:169)
15:41:53,659 INFO [STDOUT] at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
15:41:53,660 INFO [STDOUT] at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
15:41:53,660 INFO [STDOUT] at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
15:41:53,660 INFO [STDOUT] at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
15:41:53,661 INFO [STDOUT] at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
15:41:53,661 INFO [STDOUT] at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
15:41:53,661 INFO [STDOUT] at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
15:41:53,661 INFO [STDOUT] at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
15:41:53,662 INFO [STDOUT] at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
15:41:53,662 INFO [STDOUT] at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
15:41:53,662 INFO [STDOUT] at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
15:41:53,663 INFO [STDOUT] at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
15:41:53,663 INFO [STDOUT] at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
15:41:53,663 INFO [STDOUT] at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
15:41:53,658 INFO [STDOUT] at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
15:41:53,658 INFO [STDOUT] at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
15:41:53,659 INFO [STDOUT] at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:44)
15:41:53,659 INFO [STDOUT] at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
15:41:53,659 INFO [STDOUT] at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:169)
During the deploy it seems as if everything was working fine... That's the
message about the connection I get.
15:39:59,724 INFO [WrapperDataSourceService] Bound connection factory for
resource adapter for ConnectionManager
'jboss.jca:name=XAOracleDS,service=DataSourceBinding to JNDI name
'java:XAOracleDS'
which is the same with the default database
15:39:53,305 INFO [WrapperDataSourceService] Bound connection factory for
resource adapter for ConnectionManager
'jboss.jca:name=DefaultDS,service=DataSourceBinding to JNDI name
'java:DefaultDS'
Again, thaks for everything.
Huge kisses,
Esther
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3859448#3859448
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3859448
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://productguide.itmanagersjournal.com/
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
