# HG changeset patch
# User František Kučera <franta-hg@frantovo.cz>
# Date 1604944644 -3600
# Node ID a51bbc91a4cb55a1b8b77abb151766001e538ea5
# Parent  584f0b7e4b20021912e4b45813997b1ac4ca99aa
zprovoznění v aplikačním serveru Tomcat / TomEE

diff -r 584f0b7e4b20 -r a51bbc91a4cb java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dao/VyukaSuperDAO.java
--- a/java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dao/VyukaSuperDAO.java	Tue Apr 23 22:07:24 2013 +0200
+++ b/java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/dao/VyukaSuperDAO.java	Mon Nov 09 18:57:24 2020 +0100
@@ -4,6 +4,7 @@
 import java.sql.Connection;
 import java.sql.SQLException;
 import java.util.logging.Level;
+import javax.naming.Context;
 import javax.naming.InitialContext;
 import javax.naming.NamingException;
 import javax.sql.DataSource;
@@ -14,7 +15,7 @@
  */
 public class VyukaSuperDAO extends SuperDAO {
 
-    protected InitialContext kontext = null;
+    protected Context kontext = null;
 
     protected enum DATABAZE {
 
@@ -26,7 +27,12 @@
 
     public VyukaSuperDAO() {
         try {
+            // v GlassFishi stačil InitialContext
+            // v Tomcatu / TomEE nešlo v InitialContextu DB spojení najít:
+            // javax.naming.NameNotFoundException: Name [jdbc/sqlVyuka/aplikace] is not bound in this Context. Unable to find [jdbc].)
+            // Po přidání lookup("java:comp/env") funguje v TomEE.
             kontext = new InitialContext();
+            kontext = (Context) kontext.lookup("java:comp/env"); 
         } catch (NamingException ex) {
             log.log(Level.SEVERE, "Chyba při inicializaci kontextu", ex);
         }
diff -r 584f0b7e4b20 -r a51bbc91a4cb java/sql-vyuka/web/WEB-INF/web.xml
--- a/java/sql-vyuka/web/WEB-INF/web.xml	Tue Apr 23 22:07:24 2013 +0200
+++ b/java/sql-vyuka/web/WEB-INF/web.xml	Mon Nov 09 18:57:24 2020 +0100
@@ -16,4 +16,16 @@
         <error-code>500</error-code>
         <location>/WEB-INF/chyby/500.jsp</location>
     </error-page>
+    <resource-ref>
+        <description>DB spojení: aplikace</description>
+        <res-ref-name>jdbc/sqlVyuka/aplikace</res-ref-name>
+        <res-type>javax.sql.DataSource</res-type>
+        <res-auth>Container</res-auth>
+    </resource-ref>
+    <resource-ref>
+        <description>DB spojení: pískoviště</description>
+        <res-ref-name>jdbc/sqlVyuka/piskoviste</res-ref-name>
+        <res-type>javax.sql.DataSource</res-type>
+        <res-auth>Container</res-auth>
+    </resource-ref>
 </web-app>