Basically, I have a simple servlet. Let me explain.
I have Eclipse 2025-03.
I have Tomcat 11.
The project is a web project, but it's updated with Maven.
I run the servlet and it opens this website: http://localhost:8100/Web_De_Productos_Dos/servlet/com.pildorasinformaticas.productos.ServletPruebas. Before, when it was working fine, I would run the servlet and it would open this website: http://localhost:8100/Web_De_Productos_Dos/ServletPruebas
What's more, if I manually set the second website, it opens fine, loads fine, and everything works fine... but running it from Eclipse opens the first website and it doesn't work, giving me a 404 error. This is my servlet:
package com.pildorasinformaticas.productos;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import jakarta.servlet.ServletException;
import jakarta.servlet.annotation.WebServlet;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import javax.sql.*;
import jakarta.annotation.Resource;
/**
* Servlet implementation class ServletPruebas
*/
@WebServlet("/ServletPruebas")
public class ServletPruebas extends HttpServlet {
private static final long serialVersionUID = 1L;
//definir o establecer el dataSource
@Resource(name="jdbc/Productos")
private DataSource miPool;
/**
* @see HttpServlet#HttpServlet()
*/
public ServletPruebas() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
//response.getWriter().append("Served at: ").append(request.getContextPath());
// crear el objeto printWriter
PrintWriter salida = response.getWriter();
response.setContentType("text/plain");
//crear conexion con bbdd
Connection miConexion = null;
Statement miStatement = null;
ResultSet miResultSet = null;
try {
miConexion = miPool.getConnection();
String mySql = "SELECT * FROM PRODUCTOS";
miStatement = miConexion.createStatement();
miResultSet = miStatement.executeQuery(mySql);
while(miResultSet.next()) {
String nombre_articulo = miResultSet.getString(3);
salida.println(nombre_articulo);
}
}catch(Exception e) {
e.printStackTrace();
}
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}
}
this is my pom.xml:
<project xmlns=".0.0" xmlns:xsi="; xsi:schemaLocation=".0.0 .0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>Web_De_Productos_Dos</groupId>
<artifactId>Web_De_Productos_Dos</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>war</packaging>
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.29</version> <!-- Verifica la última versión disponible -->
</dependency>
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>javax.servlet.jsp-api</artifactId>
<version>2.3.3</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>jakarta.servlet</groupId>
<artifactId>jakarta.servlet-api</artifactId>
<version>5.0.0</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>jakarta.servlet.jsp.jstl</groupId>
<artifactId>jakarta.servlet.jsp.jstl-api</artifactId>
<version>2.0.0</version>
</dependency>
<dependency>
<groupId>.glassfish.web</groupId>
<artifactId>jakarta.servlet.jsp.jstl</artifactId>
<version>2.0.0</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<artifactId>maven-war-plugin</artifactId>
<version>3.2.3</version>
</plugin>
<plugin>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.13.0</version>
<configuration>
<release>24</release>
</configuration>
</plugin>
</plugins>
</build>
</project>
this is my context.xml set on META-INF:
<?xml version="1.0" encoding="UTF-8"?>
<Context>
<!-- Aquí puedes configurar recursos si es necesario -->
<Resource name="jdbc/Productos" auth="Container" type="javax.sql.DataSource" maxTotal="15" maxIdle="3" maxWaitMillis="5000" username="root" password="" driverClassName="com.mysql.cj.jdbc.Driver" url="jdbc:mysql://localhost:3306/curso_sql">
</Resource>
</Context>
this is my web.xml set on WEB-INF:
<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4" xmlns="; xmlns:xsi="; xsi:schemaLocation=" .xsd">
<display-name>Web_De_Productos_Dos</display-name>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
<welcome-file>index.htm</welcome-file>
<welcome-file>index.jsp</welcome-file>
<welcome-file>default.html</welcome-file>
<welcome-file>default.htm</welcome-file>
<welcome-file>default.jsp</welcome-file>
</welcome-file-list>
<resource-ref>
<description>Base de datos MySQL</description>
<res-ref-name>jdbc/Productos</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
If you need more information, let me know and I'll upload it, but I think that's all... Now I'll tell you, it all started when I was running the servlet and the website wouldn't even open, when 2 minutes ago everything was working fine, without modifying anything. So what did I do? Since the website wouldn't open, I went to project properties, searched for project facets, and changed the web dynamic version to version 4.0 while I was on 2.4, and I changed Java 21 while I was on Java 24. From that moment on, this started happening to me... then I reverted it, left everything as it was, but it still fails... Since that change, everything has been ruined.
I tried changing the versions of the facets and that broke my code seemsly. Like I said my servlet was working fine till that change...