Webservice: Telefonbuch (DB)

[Olaf777]

Hallo an All! Zuerst möchte ich sagen, dass ich auf diesem Gebiet gaaanz neu bin.

Meine Apps: Netbeans (8.0.1), Apache Tomcat

Mein Ziel: Erstellung eines Telefonbuches

Wie soll das funktionieren:
Ich habe meine Datenbank mit Daten versehen (Name, Adresse, Telefonnummer). Wenn er User eine Telefonnummer eingibt (CLIENT) -> soll die korrekte Person erscheinen mit Name und Adresse.

Hört sich eigentlich nicht so schwierig an, aber da sind schon einige wichtige Dinge drin. Ich bin außerdem neu in diesem Gebiet und würde gerne mehr lernen, indem ich dieses Beispiel löse.

Bis jetzt habe ich die Infrastruktur gemacht. Also alles erstellt, Webservice und Client Projekte in Netbeans, sowie eine Datenbank-Anbindung mit einem Connection Pool gemacht. Nun stehe ich aber an, wenn es darum geht eine richtige Webmethod für den Service zu erstellen. Ich bitte deshalb um Hilfe bzw. Gedankenanstöße.

Wie gesagt, dass ist die herausfordernste Aufgabe (zur Zeit) für mich, ich mach das aber privat um etwas dazuzulernen. Bis jetzt habe ich einfache Webservice gemacht, wie zum Beispiel die Addition zweier Zahlen oder Hello "name", ... Damit hab ich mich mit der Infrastruktur vertraut gemacht. Dieses Beispiel ist nun schwieriger für mich und ich würde mich sehr freuen, wenn mir jemand hilft!

Vielen Dank im Voraus!

Lg Olaf

 

[stg]

Stell konkrete Fragen, dann kann man auch helfen.

Viel ist ja nicht zu machen:
Nutzereingabe einlesen, Datenbankabfrage ausführen, Ausgabe an Benutzer
Wie das nun genau realisiert wird, da gibt es zahlreiche Möglichkeiten...

 

[Olaf777]

Danke schon mal für die Antwort.

Ich frage mich, wie ich die Nutzereingabe (Telefonnummer) mit den Daten der Datenbank mit Hilfe einer Webmethod abgleiche.

 

[JavaMeister]

Sorry, aber ...

Ist das eine konkrete Frage? - Was erwartest du hier für eine Antwort? - Fertigen Code, so dass man nicht mehr googeln oder ein Buch lesen muss?

Und dann sehe ich oben, dass du bereits eine Addition gemacht hast. Daher stellt sich mir die Frage, was hier anders sein soll...

Du machst eine Methode public TelInfos getTelInfoy (String telefonnummer);

Und dann genau wie die Addition. Du lieferst ein neues Objekt mit den benötigten Informationen.

Du hast auch schon einen ConnectionPool .Ich nehme an für eine Datenbank... JDBC COnnections?

Dann muss man ja nur noch ein wenig SQL machen: select * from telefonnummern where telefonnumer = '" + telefonnummer + "');

Kann auch sein, dass ich die Frage nicht verstehe.

 

[Olaf777]

Danke für die Gedankenanstöße und sorry für meine ungenauen Fragen...

Ich habe meine Datenbank in JDBC und in ein Connection Pool gegeben. Also in der context.xml (Resource) definiert!
Nun stell ich mir die Frage, wie ich die Datenbank in Java ansprechen kann, nachdem ich dies so eingerichtet habe. Der Name des Connection Pools lautet bei mir "connpool". Das ist mal der erste Meilenstein bei mir, dass das mal klappt, damit ich die SQL Abfragen machen kann... Danke!

 

[Olaf777]

So ich hab hier was zum Zeigen.... Funktioniert aber nicht.

Also hier mein Webservice mit Webmethode. Habe die Aufgabenstellung etwas verändert:
Also der User soll über einen Client eine Zahl eingeben -> eine Sozialversicherungsnummer (SVN). Er soll als Rückgabe den dazugehörigen Nachnamen erhalten. Alles in einer Datenbank der Tabelle "kunden" gespeichert. Felder heißen "Sozialversicherungsnummer" und "Nachname".

@WebMethod( operationName = "SVN-Abfrage" )
   public String svn( @WebParam( name = "Sozialversicherungsnummer" ) int SVN)
   {
      try
      {
         connection = DriverManager.getConnection( 
         DATABASE_URL, USERNAME, PASSWORD );
         statement = connection.createStatement();
         ResultSet resultSet = statement.executeQuery(
            "SELECT \"*\" FROM \"kunden\"" +
            "WHERE (\"Sozialversicherungsnummer\" = '" + SVN + 
            "')" );
         
         // Nachname soll zurückgegeben werden wenn die Sozialversicherungsnummer in der DB existiert
         while ( resultSet.next() )
         {
            return resultSet.getString("Nachname");
         } // end if

      } // end try
      catch ( SQLException e )
      {
         e.printStackTrace();
         String i= "Kann nicht gefunden werden";
         return i;
      } // end catch
      catch ( Exception e )
      {
         e.printStackTrace();  
         String i= "Kann nicht gefunden werden";
         return i;
      } // end catch
      finally
      {
         try
         {
            statement.close();
            connection.close();
         } // end try
         catch ( Exception e )
         {
            e.printStackTrace();
         String i= "Kann nicht gefunden werden";
         return i;
         } // end catch
      } // end finally
       return null;
   } // end WebMethod reserve

Den Webservice teste ich mit SOAP UI. Leider habe ich einen Fehler drin. Wahrscheinlich bei der "while ( resultSet.next()" Abschnitt. Wäre echt nett, wenn mir jemand helfen könnte.

Lg

 

[Olaf777]

Update:


Hab meinen Code etwas angepasst:

@WebMethod( operationName = "SVN-Abfrage" )
   public String svn(int SVN)
   {
      try
      {
         connection = DriverManager.getConnection( 
         DATABASE_URL, USERNAME, PASSWORD );
         statement = connection.createStatement();
         ResultSet resultSet = statement.executeQuery( "SELECT Nachname FROM kunden WHERE Sozialversicherungsnummer='" + SVN +"'" );
         
         // if requested seat is available, reserve it
         if ( resultSet.next() )
         {
            return resultSet.getString("Nachname");
         } // end if
            return "fehler";
      } // end try
      catch ( SQLException e )
      {
         e.printStackTrace();
         return ("1");
      } // end catch
      catch ( Exception e )
      {
         e.printStackTrace();  
      return ("2");
      } // end catch
      finally
      {
         try
         {
            statement.close();
            connection.close();
         } // end try
         catch ( Exception e )
         {
            e.printStackTrace();
            return ("3");
         } // end catch
      } // end finally
   } // end WebMethod

So, hier bekomm ich ständig "3" als return. Also Exception e.... und wenn ich den finally Block entferne bekomm ich return "1". Wenn ich ebenfalls diesen entferne bekomm ich return "2". Egal was ich eintipp: Entweder eine richtige Sozialversicherungsnummer aus der DB oder irgendeine Zahl wie "123"....

Ich verstehs nicht, DB Daten sind ja alle korrekt...

Ich will eine Zahl durch den Benutzer bekommen (INT) und gebe dafür einen dazugehörigen Nachnamen zurück (String). Viel schwerer als gedacht :-/

 

[VfL_Freak]

Moin,

WELCHE Exception kommen denn genau?? Sollen wir das raten?? :noe:

Poste mal den jeweiligen Stacktrace !

Gruß
Klaus

 

[Olaf777]

Ich bin ein Anfänger und musste nun mal suchen wo das mitgeloggt wird von Tomcat. Habe etwas gefunden aber ich kann damit nichts anfangen. Ich hoffe ihr könnt mir helfen... Vielen Dank!

10-Dec-2014 20:46:37.174 SEVERE [http-nio-8080-exec-11] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/Kuranstaltwebapp] created a ThreadLocal with key of type [org.glassfish.gmbal.generic.OperationTracer$1] (value [org.glassfish.gmbal.generic.OperationTracer$1@6e9bbd66]) and a value of type [java.util.ArrayList] (value [[]]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
10-Dec-2014 20:46:37.174 SEVERE [http-nio-8080-exec-11] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/Kuranstaltwebapp] created a ThreadLocal with key of type [com.sun.xml.bind.v2.ClassFactory$1] (value [com.sun.xml.bind.v2.ClassFactory$1@b9eafef]) and a value of type [java.util.WeakHashMap] (value [{class com.sun.xml.ws.runtime.config.MetroConfig=java.lang.ref.WeakReference@59981743, class com.sun.xml.ws.runtime.config.TubelineDefinition=java.lang.ref.WeakReference@7442991a, class com.sun.xml.ws.runtime.config.TubeFactoryList=java.lang.ref.WeakReference@47817a79, class javax.xml.bind.annotation.adapters.CollapsedStringAdapter=java.lang.ref.WeakReference@391e44b1, class com.sun.xml.ws.runtime.config.TubeFactoryConfig=java.lang.ref.WeakReference@20a56ede, class java.util.ArrayList=java.lang.ref.WeakReference@40cfb999, class com.sun.xml.ws.runtime.config.Tubelines=java.lang.ref.WeakReference@cd1514b, class javax.xml.bind.annotation.W3CDomHandler=java.lang.ref.WeakReference@4721a7ac}]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
10-Dec-2014 20:46:37.174 SEVERE [http-nio-8080-exec-11] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/Kuranstaltwebapp] created a ThreadLocal with key of type [com.sun.xml.bind.v2.runtime.Coordinator$1] (value [com.sun.xml.bind.v2.runtime.Coordinator$1@4c79f208]) and a value of type [java.lang.Object[]] (value [[Ljava.lang.Object;@7147896f]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
10-Dec-2014 20:46:37.174 SEVERE [http-nio-8080-exec-11] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/Kuranstaltwebapp] created a ThreadLocal with key of type [org.glassfish.gmbal.generic.OperationTracer$1] (value [org.glassfish.gmbal.generic.OperationTracer$1@6e9bbd66]) and a value of type [java.util.ArrayList] (value [[]]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
10-Dec-2014 20:46:38.121 INFO [http-nio-8080-exec-11] org.apache.catalina.startup.HostConfig.undeploy Undeploying context [/Kuranstaltwebapp]
10-Dec-2014 20:46:38.184 INFO [http-nio-8080-exec-5] org.apache.catalina.startup.HostConfig.deployDescriptor Deploying configuration descriptor C:\Apache Software Foundation\Apache Tomcat 8.0.9\conf\Catalina\localhost\Kuranstaltwebapp.xml
10-Dec-2014 20:46:38.199 WARNING [http-nio-8080-exec-5] org.apache.catalina.startup.SetContextPropertiesRule.begin [SetContextPropertiesRule]{Context} Setting property 'antiJARLocking' to 'true' did not find a matching property.
10-Dec-2014 20:46:42.934 INFO [http-nio-8080-exec-5] null.null WSSERVLET12: JAX-WS context listener initializing
10-Dec-2014 20:46:47.397 INFO [http-nio-8080-exec-5] com.sun.xml.ws.server.MonitorBase.createRoot Metro monitoring rootname successfully set to: com.sun.metrop=/,type=WSEndpoint,name=/Kuranstaltwebapp-KuranstaltWSService-KuranstaltWSPort
10-Dec-2014 20:46:47.912 INFO [http-nio-8080-exec-5] null.null WSSERVLET14: JAX-WS servlet initializing
10-Dec-2014 20:46:48.053 INFO [http-nio-8080-exec-5] null.null Mojarra 2.2.7 ( 20140610-1547 https://svn.java.net/svn/mojarra~svn/tags/2.2.7@13362) für Kontext '/Kuranstaltwebapp' wird initialisiert.
10-Dec-2014 20:46:48.256 INFO [http-nio-8080-exec-5] null.null JSF1048: PostConstruct/PreDestroy-Annotationen vorhanden. Verwaltete Bean-Methoden, die mit diesen Annotationen markiert sind, lassen die entsprechenden Annotationen verarbeiten.
10-Dec-2014 20:46:49.256 INFO [http-nio-8080-exec-5] org.apache.catalina.startup.HostConfig.deployDescriptor Deployment of configuration descriptor C:\Apache Software Foundation\Apache Tomcat 8.0.9\conf\Catalina\localhost\Kuranstaltwebapp.xml has finished in 11,072 ms
10-Dec-2014 20:46:49.272 INFO [http-nio-8080-exec-3] org.apache.catalina.util.LifecycleBase.start The start() method was called on component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/Kuranstaltwebapp]] after start() had already been called. The second call will be ignored.
10-Dec-2014 20:47:04.890 INFO [http-nio-8080-exec-3] null.null WSSERVLET15: JAX-WS servlet destroyed
10-Dec-2014 20:47:04.890 INFO [http-nio-8080-exec-3] null.null Closing Metro monitoring root: com.sun.metrop=/,type=WSEndpoint,name=/Kuranstaltwebapp-KuranstaltWSService-KuranstaltWSPort
10-Dec-2014 20:47:04.890 INFO [http-nio-8080-exec-3] null.null WSSERVLET13: JAX-WS context listener destroyed
10-Dec-2014 20:47:04.906 SEVERE [http-nio-8080-exec-3] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/Kuranstaltwebapp] created a ThreadLocal with key of type [org.glassfish.gmbal.generic.OperationTracer$1] (value [org.glassfish.gmbal.generic.OperationTracer$1@2147cdfb]) and a value of type [java.util.ArrayList] (value [[]]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
10-Dec-2014 20:47:05.812 INFO [http-nio-8080-exec-3] org.apache.catalina.startup.HostConfig.undeploy Undeploying context [/Kuranstaltwebapp]
10-Dec-2014 20:47:05.859 INFO [http-nio-8080-exec-16] org.apache.catalina.startup.HostConfig.deployDescriptor Deploying configuration descriptor C:\Apache Software Foundation\Apache Tomcat 8.0.9\conf\Catalina\localhost\Kuranstaltwebapp.xml
10-Dec-2014 20:47:05.875 WARNING [http-nio-8080-exec-16] org.apache.catalina.startup.SetContextPropertiesRule.begin [SetContextPropertiesRule]{Context} Setting property 'antiJARLocking' to 'true' did not find a matching property.
10-Dec-2014 20:47:09.599 INFO [http-nio-8080-exec-16] null.null WSSERVLET12: JAX-WS context listener initializing
10-Dec-2014 20:47:14.302 INFO [http-nio-8080-exec-16] null.null Metro monitoring rootname successfully set to: com.sun.metrop=/,type=WSEndpoint,name=/Kuranstaltwebapp-KuranstaltWSService-KuranstaltWSPort
10-Dec-2014 20:47:14.786 INFO [http-nio-8080-exec-16] null.null WSSERVLET14: JAX-WS servlet initializing
10-Dec-2014 20:47:14.911 INFO [http-nio-8080-exec-16] null.null Mojarra 2.2.7 ( 20140610-1547 https://svn.java.net/svn/mojarra~svn/tags/2.2.7@13362) für Kontext '/Kuranstaltwebapp' wird initialisiert.
10-Dec-2014 20:47:15.099 INFO [http-nio-8080-exec-16] null.null JSF1048: PostConstruct/PreDestroy-Annotationen vorhanden. Verwaltete Bean-Methoden, die mit diesen Annotationen markiert sind, lassen die entsprechenden Annotationen verarbeiten.
10-Dec-2014 20:47:16.099 INFO [http-nio-8080-exec-16] org.apache.catalina.startup.HostConfig.deployDescriptor Deployment of configuration descriptor C:\Apache Software Foundation\Apache Tomcat 8.0.9\conf\Catalina\localhost\Kuranstaltwebapp.xml has finished in 10,240 ms
10-Dec-2014 20:47:16.115 INFO [http-nio-8080-exec-4] org.apache.catalina.util.LifecycleBase.start The start() method was called on component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/Kuranstaltwebapp]] after start() had already been called. The second call will be ignored.
10-Dec-2014 21:00:20.946 INFO [http-nio-8080-exec-21] null.null WSSERVLET15: JAX-WS servlet destroyed
10-Dec-2014 21:00:20.958 INFO [http-nio-8080-exec-21] null.null Closing Metro monitoring root: com.sun.metrop=/,type=WSEndpoint,name=/Kuranstaltwebapp-KuranstaltWSService-KuranstaltWSPort
10-Dec-2014 21:00:20.966 INFO [http-nio-8080-exec-21] null.null WSSERVLET13: JAX-WS context listener destroyed
10-Dec-2014 21:00:21.001 SEVERE [http-nio-8080-exec-21] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/Kuranstaltwebapp] created a ThreadLocal with key of type [com.sun.xml.bind.v2.runtime.Coordinator$1] (value [com.sun.xml.bind.v2.runtime.Coordinator$1@4a4e776a]) and a value of type [java.lang.Object[]] (value [[Ljava.lang.Object;@18cc9b22]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
10-Dec-2014 21:00:21.003 SEVERE [http-nio-8080-exec-21] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/Kuranstaltwebapp] created a ThreadLocal with key of type [com.sun.xml.bind.v2.ClassFactory$1] (value [com.sun.xml.bind.v2.ClassFactory$1@1b50f340]) and a value of type [java.util.WeakHashMap] (value [{class at.fhprojectkuranstalt.ws.jaxws.Svn=java.lang.ref.WeakReference@46ed6ebe}]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
10-Dec-2014 21:00:21.004 SEVERE [http-nio-8080-exec-21] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/Kuranstaltwebapp] created a ThreadLocal with key of type [com.sun.xml.bind.v2.runtime.Coordinator$1] (value [com.sun.xml.bind.v2.runtime.Coordinator$1@4a4e776a]) and a value of type [java.lang.Object[]] (value [[Ljava.lang.Object;@3c83573]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
10-Dec-2014 21:00:21.004 SEVERE [http-nio-8080-exec-21] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/Kuranstaltwebapp] created a ThreadLocal with key of type [com.sun.xml.bind.v2.ClassFactory$1] (value [com.sun.xml.bind.v2.ClassFactory$1@1b50f340]) and a value of type [java.util.WeakHashMap] (value [{class at.fhprojectkuranstalt.ws.jaxws.Svn=java.lang.ref.WeakReference@1f1e0cb9}]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
10-Dec-2014 21:00:21.006 SEVERE [http-nio-8080-exec-21] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/Kuranstaltwebapp] created a ThreadLocal with key of type [org.glassfish.gmbal.generic.OperationTracer$1] (value [org.glassfish.gmbal.generic.OperationTracer$1@322b097a]) and a value of type [java.util.ArrayList] (value [[]]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
10-Dec-2014 21:00:21.008 SEVERE [http-nio-8080-exec-21] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/Kuranstaltwebapp] created a ThreadLocal with key of type [com.sun.xml.bind.v2.runtime.Coordinator$1] (value [com.sun.xml.bind.v2.runtime.Coordinator$1@4a4e776a]) and a value of type [java.lang.Object[]] (value [[Ljava.lang.Object;@40d94bc5]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
10-Dec-2014 21:00:21.009 SEVERE [http-nio-8080-exec-21] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/Kuranstaltwebapp] created a ThreadLocal with key of type [com.sun.xml.bind.v2.ClassFactory$1] (value [com.sun.xml.bind.v2.ClassFactory$1@1b50f340]) and a value of type [java.util.WeakHashMap] (value [{class at.fhprojectkuranstalt.ws.jaxws.Svn=java.lang.ref.WeakReference@2f89d00}]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
10-Dec-2014 21:00:21.951 INFO [http-nio-8080-exec-21] org.apache.catalina.startup.HostConfig.undeploy Undeploying context [/Kuranstaltwebapp]
10-Dec-2014 21:00:22.030 INFO [http-nio-8080-exec-20] org.apache.catalina.startup.HostConfig.deployDescriptor Deploying configuration descriptor C:\Apache Software Foundation\Apache Tomcat 8.0.9\conf\Catalina\localhost\Kuranstaltwebapp.xml
10-Dec-2014 21:00:22.094 WARNING [http-nio-8080-exec-20] org.apache.catalina.startup.SetContextPropertiesRule.begin [SetContextPropertiesRule]{Context} Setting property 'antiJARLocking' to 'true' did not find a matching property.
10-Dec-2014 21:00:29.825 INFO [http-nio-8080-exec-20] com.sun.xml.ws.transport.http.servlet.WSServletContextListener.contextInitialized WSSERVLET12: JAX-WS context listener initializing
10-Dec-2014 21:00:35.449 INFO [http-nio-8080-exec-20] null.null Metro monitoring rootname successfully set to: com.sun.metrop=/,type=WSEndpoint,name=/Kuranstaltwebapp-KuranstaltWSService-KuranstaltWSPort
10-Dec-2014 21:00:36.011 INFO [http-nio-8080-exec-20] null.null WSSERVLET14: JAX-WS servlet initializing
10-Dec-2014 21:00:36.144 INFO [http-nio-8080-exec-20] null.null Mojarra 2.2.7 ( 20140610-1547 https://svn.java.net/svn/mojarra~svn/tags/2.2.7@13362) für Kontext '/Kuranstaltwebapp' wird initialisiert.
10-Dec-2014 21:00:36.361 INFO [http-nio-8080-exec-20] null.null JSF1048: PostConstruct/PreDestroy-Annotationen vorhanden. Verwaltete Bean-Methoden, die mit diesen Annotationen markiert sind, lassen die entsprechenden Annotationen verarbeiten.
10-Dec-2014 21:00:38.034 INFO [http-nio-8080-exec-20] org.apache.catalina.startup.HostConfig.deployDescriptor Deployment of configuration descriptor C:\Apache Software Foundation\Apache Tomcat 8.0.9\conf\Catalina\localhost\Kuranstaltwebapp.xml has finished in 16,004 ms
10-Dec-2014 21:00:38.066 INFO [http-nio-8080-exec-27] org.apache.catalina.util.LifecycleBase.start The start() method was called on component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/Kuranstaltwebapp]] after start() had already been called. The second call will be ignored.
10-Dec-2014 21:46:18.932 INFO [http-nio-8080-exec-34] null.null WSSERVLET15: JAX-WS servlet destroyed
10-Dec-2014 21:46:18.942 INFO [http-nio-8080-exec-34] null.null Closing Metro monitoring root: com.sun.metrop=/,type=WSEndpoint,name=/Kuranstaltwebapp-KuranstaltWSService-KuranstaltWSPort
10-Dec-2014 21:46:18.953 INFO [http-nio-8080-exec-34] null.null WSSERVLET13: JAX-WS context listener destroyed
10-Dec-2014 21:46:18.986 SEVERE [http-nio-8080-exec-34] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/Kuranstaltwebapp] created a ThreadLocal with key of type [com.sun.xml.bind.v2.runtime.Coordinator$1] (value [com.sun.xml.bind.v2.runtime.Coordinator$1@1bad980d]) and a value of type [java.lang.Object[]] (value [[Ljava.lang.Object;@22a08827]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
10-Dec-2014 21:46:18.988 SEVERE [http-nio-8080-exec-34] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/Kuranstaltwebapp] created a ThreadLocal with key of type [com.sun.xml.bind.v2.ClassFactory$1] (value [com.sun.xml.bind.v2.ClassFactory$1@3ad5e529]) and a value of type [java.util.WeakHashMap] (value [{class at.fhprojectkuranstalt.ws.jaxws.Svn=java.lang.ref.WeakReference@773384bf}]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
10-Dec-2014 21:46:18.989 SEVERE [http-nio-8080-exec-34] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/Kuranstaltwebapp] created a ThreadLocal with key of type [org.glassfish.gmbal.generic.OperationTracer$1] (value [org.glassfish.gmbal.generic.OperationTracer$1@a917a4]) and a value of type [java.util.ArrayList] (value [[]]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
10-Dec-2014 21:46:20.129 INFO [http-nio-8080-exec-34] org.apache.catalina.startup.HostConfig.undeploy Undeploying context [/Kuranstaltwebapp]
10-Dec-2014 21:46:20.204 INFO [http-nio-8080-exec-31] org.apache.catalina.startup.HostConfig.deployDescriptor Deploying configuration descriptor C:\Apache Software Foundation\Apache Tomcat 8.0.9\conf\Catalina\localhost\Kuranstaltwebapp.xml
10-Dec-2014 21:46:20.289 WARNING [http-nio-8080-exec-31] org.apache.catalina.startup.SetContextPropertiesRule.begin [SetContextPropertiesRule]{Context} Setting property 'antiJARLocking' to 'true' did not find a matching property.
10-Dec-2014 21:46:30.085 INFO [http-nio-8080-exec-31] com.sun.xml.ws.transport.http.servlet.WSServletContextListener.contextInitialized WSSERVLET12: JAX-WS context listener initializing
10-Dec-2014 21:46:35.466 INFO [http-nio-8080-exec-31] com.sun.xml.ws.server.MonitorBase.createRoot Metro monitoring rootname successfully set to: com.sun.metrop=/,type=WSEndpoint,name=/Kuranstaltwebapp-KuranstaltWSService-KuranstaltWSPort
10-Dec-2014 21:46:36.247 INFO [http-nio-8080-exec-31] null.null WSSERVLET14: JAX-WS servlet initializing
10-Dec-2014 21:46:36.426 INFO [http-nio-8080-exec-31] null.contextInitialized Mojarra 2.2.7 ( 20140610-1547 https://svn.java.net/svn/mojarra~svn/tags/2.2.7@13362) für Kontext '/Kuranstaltwebapp' wird initialisiert.
10-Dec-2014 21:46:36.751 INFO [http-nio-8080-exec-31] com.sun.faces.spi.InjectionProviderFactory.createInstance JSF1048: PostConstruct/PreDestroy-Annotationen vorhanden. Verwaltete Bean-Methoden, die mit diesen Annotationen markiert sind, lassen die entsprechenden Annotationen verarbeiten.
10-Dec-2014 21:46:42.274 INFO [http-nio-8080-exec-31] org.apache.catalina.startup.HostConfig.deployDescriptor Deployment of configuration descriptor C:\Apache Software Foundation\Apache Tomcat 8.0.9\conf\Catalina\localhost\Kuranstaltwebapp.xml has finished in 22,071 ms
10-Dec-2014 21:46:42.298 INFO [http-nio-8080-exec-32] org.apache.catalina.util.LifecycleBase.start The start() method was called on component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/Kuranstaltwebapp]] after start() had already been called. The second call will be ignored.
10-Dec-2014 22:01:39.591 INFO [http-nio-8080-exec-48] null.null WSSERVLET15: JAX-WS servlet destroyed
10-Dec-2014 22:01:39.606 INFO [http-nio-8080-exec-48] null.null Closing Metro monitoring root: com.sun.metrop=/,type=WSEndpoint,name=/Web-Service-Webservice-WebservicePort
10-Dec-2014 22:01:39.609 INFO [http-nio-8080-exec-48] null.null WSSERVLET13: JAX-WS context listener destroyed
10-Dec-2014 22:01:39.622 SEVERE [http-nio-8080-exec-48] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/Web-Service] created a ThreadLocal with key of type [org.glassfish.gmbal.generic.OperationTracer$1] (value [org.glassfish.gmbal.generic.OperationTracer$1@66839bc6]) and a value of type [java.util.ArrayList] (value [[]]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
10-Dec-2014 22:02:00.562 INFO [http-nio-8080-exec-49] null.null WSSERVLET15: JAX-WS servlet destroyed
10-Dec-2014 22:02:00.574 INFO [http-nio-8080-exec-49] com.sun.xml.ws.server.MonitorBase.closeMOM Closing Metro monitoring root: com.sun.metrop=/,type=WSEndpoint,name=/Kuranstaltwebapp-KuranstaltWSService-KuranstaltWSPort
10-Dec-2014 22:02:00.582 INFO [http-nio-8080-exec-49] null.null WSSERVLET13: JAX-WS context listener destroyed
10-Dec-2014 22:02:00.593 SEVERE [http-nio-8080-exec-49] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/Kuranstaltwebapp] created a ThreadLocal with key of type [com.sun.xml.bind.v2.runtime.Coordinator$1] (value [com.sun.xml.bind.v2.runtime.Coordinator$1@53ea23d7]) and a value of type [java.lang.Object[]] (value [[Ljava.lang.Object;@7e19925e]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
10-Dec-2014 22:02:00.594 SEVERE [http-nio-8080-exec-49] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/Kuranstaltwebapp] created a ThreadLocal with key of type [com.sun.xml.bind.v2.ClassFactory$1] (value [com.sun.xml.bind.v2.ClassFactory$1@745692e8]) and a value of type [java.util.WeakHashMap] (value [{class at.fhprojectkuranstalt.ws.jaxws.Svn=java.lang.ref.WeakReference@4a188ec8}]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
10-Dec-2014 22:02:00.595 SEVERE [http-nio-8080-exec-49] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/Kuranstaltwebapp] created a ThreadLocal with key of type [com.sun.xml.bind.v2.runtime.Coordinator$1] (value [com.sun.xml.bind.v2.runtime.Coordinator$1@53ea23d7]) and a value of type [java.lang.Object[]] (value [[Ljava.lang.Object;@48eee8c7]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
10-Dec-2014 22:02:00.596 SEVERE [http-nio-8080-exec-49] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/Kuranstaltwebapp] created a ThreadLocal with key of type [com.sun.xml.bind.v2.ClassFactory$1] (value [com.sun.xml.bind.v2.ClassFactory$1@745692e8]) and a value of type [java.util.WeakHashMap] (value [{class at.fhprojectkuranstalt.ws.jaxws.Svn=java.lang.ref.WeakReference@7a5708e6}]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
10-Dec-2014 22:02:00.597 SEVERE [http-nio-8080-exec-49] org.apache.catalina.loader.WebappClassLoader.checkThreadLocalMapForLeaks The web application [/Kuranstaltwebapp] created a ThreadLocal with key of type [org.glassfish.gmbal.generic.OperationTracer$1] (value [org.glassfish.gmbal.generic.OperationTracer$1@3ad61496]) and a value of type [java.util.ArrayList] (value [[]]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
10-Dec-2014 22:02:01.534 INFO [http-nio-8080-exec-49] org.apache.catalina.startup.HostConfig.undeploy Undeploying context [/Kuranstaltwebapp]
10-Dec-2014 22:02:01.602 INFO [http-nio-8080-exec-53] org.apache.catalina.startup.HostConfig.deployDescriptor Deploying configuration descriptor C:\Apache Software Foundation\Apache Tomcat 8.0.9\conf\Catalina\localhost\Kuranstaltwebapp.xml
10-Dec-2014 22:02:01.651 WARNING [http-nio-8080-exec-53] org.apache.catalina.startup.SetContextPropertiesRule.begin [SetContextPropertiesRule]{Context} Setting property 'antiJARLocking' to 'true' did not find a matching property.
10-Dec-2014 22:02:09.433 INFO [http-nio-8080-exec-53] null.null WSSERVLET12: JAX-WS context listener initializing
10-Dec-2014 22:02:16.239 INFO [http-nio-8080-exec-53] null.null Metro monitoring rootname successfully set to: com.sun.metrop=/,type=WSEndpoint,name=/Kuranstaltwebapp-KuranstaltWSService-KuranstaltWSPort
10-Dec-2014 22:02:16.801 INFO [http-nio-8080-exec-53] null.<init> WSSERVLET14: JAX-WS servlet initializing
10-Dec-2014 22:02:16.944 INFO [http-nio-8080-exec-53] null.null Mojarra 2.2.7 ( 20140610-1547 https://svn.java.net/svn/mojarra~svn/tags/2.2.7@13362) für Kontext '/Kuranstaltwebapp' wird initialisiert.
10-Dec-2014 22:02:17.151 INFO [http-nio-8080-exec-53] null.null JSF1048: PostConstruct/PreDestroy-Annotationen vorhanden. Verwaltete Bean-Methoden, die mit diesen Annotationen markiert sind, lassen die entsprechenden Annotationen verarbeiten.
10-Dec-2014 22:02:18.434 INFO [http-nio-8080-exec-53] org.apache.catalina.startup.HostConfig.deployDescriptor Deployment of configuration descriptor C:\Apache Software Foundation\Apache Tomcat 8.0.9\conf\Catalina\localhost\Kuranstaltwebapp.xml has finished in 16,832 ms
10-Dec-2014 22:02:18.471 INFO [http-nio-8080-exec-43] org.apache.catalina.util.LifecycleBase.start The start() method was called on component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/Kuranstaltwebapp]] after start() had already been called. The second call will be ignored.

 

[Olaf777]

Update: Habe nun ein neues Projekt gemacht und habe das ganze OHNE Webservice versucht. Ergebnis: Es hat geklappt und ich hab seit Langem ein Erfolgserlebnis
Hier ein Screen: http://www.youscreen.de/wutlkxgz18.jpg

Nun will ich das ganze in den Webservice bekommen. Vielleicht sieht jemand etwas, was ich ändern muss, damit es funktioniert? Ich seh es nicht wirklich..... Vielen Dank im Voraus und Danke für die bisherige Hilfe!

Lg

 

[Olaf777]

Update2:
Mein Webservice schaut nun so aus:

@WebService
public class KuranstaltWS {

     static final String DATABASE_URL = "jdbc:mysql://X.X.X.X.X:XXXX/XXX";
     static final String USERNAME = "XXX";
     static final String PASSWORD = "XXX";
     Connection connection;

    @WebMethod( operationName = "SVN-Abfrage" )
   public String svn(int SVN)
   {
        try {
            connection = DriverManager.getConnection(DATABASE_URL, USERNAME, PASSWORD);

            String query = "SELECT Nachname FROM kunden WHERE Sozialversicherungsnummer=" + SVN;
            PreparedStatement stmnt = connection.prepareStatement(query);
            ResultSet resultSet = stmnt.executeQuery();
            
            if (resultSet.next()) {
                return resultSet.getString(1);
            } 
            
        } 
        catch (SQLException ex) {
            Logger.getLogger(KuranstaltWS.class.getName()).log(Level.SEVERE, null, ex);
        }
         return "Error!";     
    }
}

Hier als Bild:


Und hier das Bild zu SOAP UI, als ich getestet habe (Rückgabe: "Error!"):



Im Moment weiß ich nicht weiter... Vllt kann mir we helfen! DANKE!

Lg