Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //Databse.java for database connection with the mysql
- public class Database {
- public Connection Get_Connection() throws Exception
- {
- try
- {
- String connectionURL = "jdbc:mysql://localhost:3306/atm";
- Connection connection = null;
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- connection = DriverManager.getConnection(connectionURL, "root", "admin");
- return connection;
- }
- catch (SQLException e)
- {
- throw e;
- }
- catch (Exception e)
- {
- throw e;
- }
- }
- }
- /***************************************************************************************************/
- //AlertDao.java to insert data into the country table having country_id and country_name as 2 fields
- public class AlertDao {
- public static boolean setCountry(Connection connection, String countryName) {
- PreparedStatement ps;
- boolean insertStatus = false;
- try {
- ps = connection.prepareStatement("SELECT COUNTRY_ID FROM COUNTRY WHERE COUNTRY_NAME = ?");
- ps.setString(1, countryName);
- ResultSet rs = ps.executeQuery();
- if (!rs.next()) {
- rs.close();
- ps.close();
- ps = connection.prepareStatement("INSERT INTO COUNTRY (COUNTRY_NAME) VALUES (?) ");
- ps.setString(1, countryName);
- int records = ps.executeUpdate();
- if (records > 0) {
- insertStatus = true;
- }
- }
- ps.close();
- connection.commit();
- connection.close();
- } catch (Exception e) {
- System.out.println(e);
- }
- return insertStatus;
- }
- }
- /***************************************************************************************************/
- // AlertManager.java for caaling the method of AlertDao.java
- public class AlertManager {
- public static boolean setCountry(String countryName){
- boolean countryInsertStatus = false;
- try {
- Database database = new Database();
- Connection connection = database.Get_Connection();
- AlertDao project = new AlertDao();
- countryInsertStatus = project.setCountry(connection, countryName);
- } catch (Exception e) {
- System.out.println(e);
- }
- return countryInsertStatus;
- }
- }
- /**************************************************************************************************/
- //AtmService.java for calling the service through URL
- @Path("/WebService")
- public class AtmService {
- @GET
- @Path("/setCountry")
- @Produces("application/json")
- public String country(String countryName) {
- boolean countryInsert = false;
- String feeds = null;
- try {
- AlertManager alertManager = new AlertManager();
- countryInsert = alertManager.setCountry(countryName);
- Gson gson = new Gson();
- System.out.println(gson.toJson(countryInsert));
- feeds = gson.toJson(countryInsert);
- }
- catch (Exception e) {
- System.out.println("Exception Error"); // Console
- }
- return feeds;
- }
- }
- /***********************************************************************************************/
- // url which I am running to run this service is
- http://localhost:8080/DemoJavaAngular/REST/WebService/setCountry?countryName=nupur
- but I am getting exception as
- type Exception report
- message Servlet.init() for servlet ServletAdaptor threw exception
- description The server encountered an internal error that prevented it from fulfilling this request.
- exception
- javax.servlet.ServletException: Servlet.init() for servlet ServletAdaptor threw exception
- org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
- org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
- org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
- org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
- org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
- org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673)
- org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)
- org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)
- java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
- java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
- org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
- java.lang.Thread.run(Unknown Source)
- root cause
- com.sun.jersey.api.container.ContainerException: Fatal issues found at class webService.AtmService. See logs for more details.
- com.sun.jersey.server.impl.application.WebApplicationImpl.newResourceClass(WebApplicationImpl.java:346)
- com.sun.jersey.server.impl.application.WebApplicationImpl.getResourceClass(WebApplicationImpl.java:321)
- com.sun.jersey.server.impl.application.WebApplicationImpl.processRootResources(WebApplicationImpl.java:807)
- com.sun.jersey.server.impl.application.WebApplicationImpl.initiate(WebApplicationImpl.java:590)
- com.sun.jersey.server.impl.application.WebApplicationImpl.initiate(WebApplicationImpl.java:383)
- com.sun.jersey.spi.container.servlet.ServletContainer.initiate(ServletContainer.java:377)
- com.sun.jersey.spi.container.servlet.ServletContainer$InternalWebComponent.initiate(ServletContainer.java:242)
- com.sun.jersey.spi.container.servlet.WebComponent.load(WebComponent.java:449)
- com.sun.jersey.spi.container.servlet.WebComponent.init(WebComponent.java:169)
- com.sun.jersey.spi.container.servlet.ServletContainer.init(ServletContainer.java:281)
- com.sun.jersey.spi.container.servlet.ServletContainer.init(ServletContainer.java:442)
- javax.servlet.GenericServlet.init(GenericServlet.java:158)
- org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
- org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
- org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
- org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
- org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
- org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673)
- org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)
- org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)
- java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
- java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
- org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
- java.lang.Thread.run(Unknown Source)
- note The full stack trace of the root cause is available in the Apache Tomcat/8.0.27 logs.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement