Index: html/formulář.html
===================================================================
--- html/formulář.html	(revision 74:48066e753dd6)
+++ html/formulář.html	(revision 74:48066e753dd6)
@@ -0,0 +1,43 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE html SYSTEM "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
+<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="cs" lang="cs">
+    <head>
+        <meta http-equiv="content-language" content="cs"/>
+        <meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
+        <title>Objednávka</title>
+    </head>
+    <body>
+        <h1>Objednávka</h1>
+        <form action="/objednavka/" method="post" class="objednavka">
+            <fieldset class="radio">
+                <legend>Zvolte variantu</legend><br />
+                <label><input name="varianta" value="licence" type="radio" />Licence: 1&#160;000 Kč</label><br />
+                <label><input name="varianta" value="licence-instalace" type="radio" />Licence + odborná instalace: 1&#160;500 Kč</label><br />
+                <label><input name="varianta" value="hosting" type="radio" />Hostovaný provoz: 300 Kč za měsíc</label><br />
+            </fieldset>
+            <fieldset>
+                <legend>Zákazník</legend><br />
+                <label>Název školy: <input name="nazev" maxlength="64" type="text" /></label><br />
+                <label>Ulice: <input name="ulice" maxlength="64" type="text" /></label><br />
+                <label>Město: <input name="mesto" maxlength="64" type="text" /></label><br />
+                <label>PSČ: <input name="psc" maxlength="16" type="text" /></label><br />
+                <label>IČO: <input name="ico" maxlength="64" type="text" /></label><br />
+            </fieldset><br />
+            <fieldset>
+                <legend>Kontaktní údaje</legend><br />
+                <label>Komtaktní osoba: <input name="osoba" maxlength="128" type="text" /></label><br />
+                <label>E-mail: <input name="email" maxlength="128" type="text" /></label><br />
+                <textarea name="klic" cols="100" rows="10">pokud chcete šifrovat e-maily, vložte sem svůj veřejný klíč (PGP/GPG nebo X509)</textarea><br />
+            </fieldset>
+            <fieldset>
+                <legend>Doplňkové údaje</legend><br />
+                <label>Předpokládaný počet uživatelů: <input name="pocetUzivatelu" maxlength="128" type="text" /></label><br />
+                <textarea name="komentar" cols="100" rows="10">komentář (pokud nějaký máte)</textarea>
+            </fieldset>
+            <fieldset class="tlacitka">
+                <legend>Zadat objednávku</legend><br />
+                <button type="submit">Odeslat objednávku</button><br />
+            </fieldset>
+        </form>
+    </body>
+</html>
Index: java/sql-vyuka/nbproject/ant-deploy.xml
===================================================================
--- java/sql-vyuka/nbproject/ant-deploy.xml	(revision 8:4795d9bf6827)
+++ java/sql-vyuka/nbproject/ant-deploy.xml	(revision 74:48066e753dd6)
@@ -5,10 +5,10 @@
         <available file="${deploy.ant.docbase.dir}/WEB-INF/sun-web.xml" property="sun.web.present"/>
         <available file="${deploy.ant.resource.dir}" property="has.setup"/>
-        <tempfile prefix="sjsas" property="sjsas.password.file" destdir="${java.io.tmpdir}"/>  <!-- do not forget to delete this! -->
-        <echo message="AS_ADMIN_PASSWORD=${sjsas.password}" file="${sjsas.password.file}"/>
+        <tempfile prefix="gfv3" property="gfv3.password.file" destdir="${java.io.tmpdir}"/>  <!-- do not forget to delete this! -->
+        <echo message="AS_ADMIN_PASSWORD=${gfv3.password}" file="${gfv3.password.file}"/>
     </target>
     
     <target name="-parse-sun-web" depends="-init-cl-deployment-env" if="sun.web.present">
-        <tempfile prefix="sjsas" property="temp.sun.web" destdir="${java.io.tmpdir}"/>
+        <tempfile prefix="gfv3" property="temp.sun.web" destdir="${java.io.tmpdir}"/>
         <copy file="${deploy.ant.docbase.dir}/WEB-INF/sun-web.xml" tofile="${temp.sun.web}"/>
         <!-- The doctype triggers resolution which can fail -->
@@ -24,37 +24,37 @@
         </xmlproperty>    
         <delete file="${temp.sun.web}"/>
-        <property name="deploy.ant.client.url" value="${sjsas.url}${sun-web-app.context-root}"/>
+        <property name="deploy.ant.client.url" value="${gfv3.url}${sun-web-app.context-root}"/>
+        <property name="deploy.context.root.argument" value="?contextroot=${sun-web-app.context-root}"/>
+    </target>
+    <target name="-no-parse-sun-web" depends="-init-cl-deployment-env" unless="sun.web.present">
+        <property name="deploy.context.root.argument" value=""/>
     </target>
     <target name="-add-resources" depends="-init-cl-deployment-env" if="has.setup">
-        <tempfile prefix="sjsas" property="sjsas.resources.dir" destdir="${java.io.tmpdir}"/>
-        <mkdir dir="${sjsas.resources.dir}"/>
-        <mkdir dir="${sjsas.resources.dir}/META-INF"/>
-        <property name="sjsas.resources.file" value="${sjsas.resources.dir}/META-INF/sun-resources.xml"/>
-        <copy todir="${sjsas.resources.dir}/META-INF">
+        <tempfile prefix="gfv3" property="gfv3.resources.dir" destdir="${java.io.tmpdir}"/>
+        <mkdir dir="${gfv3.resources.dir}"/>
+        <mkdir dir="${gfv3.resources.dir}/META-INF"/>
+        <property name="gfv3.resources.file" value="${gfv3.resources.dir}/META-INF/sun-resources.xml"/>
+        <copy todir="${gfv3.resources.dir}/META-INF">
             <fileset dir="${deploy.ant.resource.dir}"/>
         </copy>
         <jar destfile="${deploy.ant.archive}" update="true">
-            <fileset dir="${sjsas.resources.dir}"/>
+            <fileset dir="${gfv3.resources.dir}"/>
         </jar>
-        <delete dir="${sjsas.resources.dir}"/>
+        <delete dir="${gfv3.resources.dir}"/>
     </target>
-    <target name="-deploy-ant" depends="-parse-sun-web,-add-resources" if="deploy.ant.enabled">
+    <target name="-deploy-ant" depends="-parse-sun-web,-no-parse-sun-web,-add-resources" if="deploy.ant.enabled">
         <echo message="Deploying ${deploy.ant.archive}"/>
-        <taskdef name="sun-appserv-deploy" classname="org.apache.tools.ant.taskdefs.optional.sun.appserv.DeployTask"
-                 classpath="${sjsas.root}/lib/sun-appserv-ant.jar" />
-        <sun-appserv-deploy user="${sjsas.username}"
-                passwordfile="${sjsas.password.file}"
-                host="${sjsas.host}" port="${sjsas.port}"
-                file="${deploy.ant.archive}" asinstalldir="${sjsas.root}"/>
-        <delete file="${sjsas.password.file}"/>
+        <tempfile prefix="gfv3" property="gfv3.results.file" destdir="${java.io.tmpdir}"/>  <!-- do not forget to delete this! -->
+        <property name="full.deploy.ant.archive" location="${deploy.ant.archive}"/>
+        <get src="${gfv3.url}/__asadmin/deploy?path=${full.deploy.ant.archive}${deploy.context.root.argument}?force=true?name=${ant.project.name}"
+            dest="${gfv3.results.file}"/>
+        <delete file="${gfv3.results.file}"/>    
     </target>
     <target name="-undeploy-ant" depends="-init-cl-deployment-env" if="deploy.ant.enabled">
-        <taskdef name="sun-appserv-undeploy" classname="org.apache.tools.ant.taskdefs.optional.sun.appserv.UndeployTask"
-                 classpath="${sjsas.root}/lib/sun-appserv-ant.jar" />
-        <sun-appserv-undeploy user="${sjsas.username}"
-                passwordfile="${sjsas.password.file}"
-                host="${sjsas.host}" port="${sjsas.port}"
-                file="${deploy.ant.archive}" asinstalldir="${sjsas.root}"/>
-        <delete file="${sjsas.password.file}"/>
+        <echo message="Undeploying ${deploy.ant.archive}"/>
+        <tempfile prefix="gfv3" property="gfv3.results.file" destdir="${java.io.tmpdir}"/>  <!-- do not forget to delete this! -->
+        <get src="${gfv3.url}/__asadmin/undeploy?name=${ant.project.name}"
+            dest="${gfv3.results.file}"/>
+        <delete file="${gfv3.results.file}"/>    
     </target>
 </project>
Index: java/sql-vyuka/nbproject/build-impl.xml
===================================================================
--- java/sql-vyuka/nbproject/build-impl.xml	(revision 46:da0e675db1cf)
+++ java/sql-vyuka/nbproject/build-impl.xml	(revision 74:48066e753dd6)
@@ -127,5 +127,8 @@
             <and>
                 <isset property="has.custom.manifest"/>
-                <isfalse value="${directory.deployment.supported}"/>
+                <or>
+                    <isfalse value="${directory.deployment.supported}"/>
+                    <isset property="dist.ear.dir"/>
+                </or>
             </and>
         </condition>
@@ -135,9 +138,15 @@
                     <isset property="has.custom.manifest"/>
                 </not>
+                <or>
+                    <isfalse value="${directory.deployment.supported}"/>
+                    <isset property="dist.ear.dir"/>
+                </or>
+            </and>
+        </condition>
+        <condition property="do.tmp.war.package">
+            <or>
                 <isfalse value="${directory.deployment.supported}"/>
-            </and>
-        </condition>
-        <condition property="do.tmp.war.package">
-            <isfalse value="${directory.deployment.supported}"/>
+                <isset property="dist.ear.dir"/>
+            </or>
         </condition>
         <property name="build.meta.inf.dir" value="${build.web.dir}/META-INF"/>
@@ -162,11 +171,9 @@
         <property name="includes" value="**"/>
         <property name="excludes" value=""/>
-        <condition else="" property="javac.compilerargs.jaxws" value="-Djava.endorsed.dirs='${jaxws.endorsed.dir}'">
-            <and>
-                <isset property="jaxws.endorsed.dir"/>
-                <available file="nbproject/jaxws-build.xml"/>
-            </and>
-        </condition>
         <property name="runmain.jvmargs" value=""/>
+        <path id="endorsed.classpath.path" path="${endorsed.classpath}"/>
+        <condition else="" property="endorsed.classpath.cmd.line.arg" value="-Xbootclasspath/p:'${toString:endorsed.classpath.path}'">
+            <length length="0" string="${endorsed.classpath}" when="greater"/>
+        </condition>
     </target>
     <target depends="init" name="-init-cos" unless="deploy.on.save">
@@ -231,5 +238,6 @@
                         <path path="@{classpath}"/>
                     </classpath>
-                    <compilerarg line="${javac.compilerargs} ${javac.compilerargs.jaxws}"/>
+                    <compilerarg line="${endorsed.classpath.cmd.line.arg}"/>
+                    <compilerarg line="${javac.compilerargs}"/>
                     <customize/>
                 </javac>
@@ -243,5 +251,5 @@
             <attribute default="**" name="testincludes"/>
             <sequential>
-                <junit dir="${basedir}" errorproperty="tests.failed" failureproperty="tests.failed" fork="true" showoutput="true">
+                <junit dir="${basedir}" errorproperty="tests.failed" failureproperty="tests.failed" fork="true" showoutput="true" tempdir="${java.io.tmpdir}">
                     <batchtest todir="${build.test.results.dir}">
                         <fileset dir="${test.src.dir}" excludes="@{excludes},${excludes}" includes="@{includes}">
@@ -250,5 +258,5 @@
                     </batchtest>
                     <classpath>
-                        <path path="${run.test.classpath}:${j2ee.platform.classpath}"/>
+                        <path path="${run.test.classpath}:${j2ee.platform.classpath}:${j2ee.platform.embeddableejb.classpath}"/>
                     </classpath>
                     <syspropertyset>
@@ -258,4 +266,5 @@
                     <formatter type="brief" usefile="false"/>
                     <formatter type="xml"/>
+                    <jvmarg line="${endorsed.classpath.cmd.line.arg}"/>
                     <jvmarg line="${runmain.jvmargs}"/>
                 </junit>
@@ -270,4 +279,5 @@
             <sequential>
                 <java classname="@{classname}" fork="true">
+                    <jvmarg line="${endorsed.classpath.cmd.line.arg}"/>
                     <jvmarg line="${runmain.jvmargs}"/>
                     <classpath>
@@ -347,4 +357,5 @@
             <sequential>
                 <java classname="@{classname}" fork="true">
+                    <jvmarg line="${endorsed.classpath.cmd.line.arg}"/>
                     <jvmarg line="${debug-args-line}"/>
                     <jvmarg value="-Xrunjdwp:transport=${debug-transport},address=${jpda.address}"/>
@@ -525,14 +536,15 @@
     <target depends="init,compile,compile-jsps,-pre-dist,-do-dist-with-manifest,-do-dist-without-manifest" name="do-dist"/>
     <target depends="init" if="dist.ear.dir" name="library-inclusion-in-manifest">
-        <copyfiles files="${reference.SuperDAO.jar}" iftldtodir="${build.web.dir}/WEB-INF" manifestproperty="manifest.reference.SuperDAO.jar" todir="${dist.ear.dir}"/>
+        <copyfiles files="${reference.SuperDAO.jar}" iftldtodir="${build.web.dir}/WEB-INF" todir="${dist.ear.dir}/lib"/>
         <mkdir dir="${build.web.dir}/META-INF"/>
-        <manifest file="${build.web.dir}/META-INF/MANIFEST.MF" mode="update">
-            <attribute name="Class-Path" value="${manifest.reference.SuperDAO.jar} "/>
-        </manifest>
+        <manifest file="${build.web.dir}/META-INF/MANIFEST.MF" mode="update"/>
     </target>
     <target depends="init" name="library-inclusion-in-archive" unless="dist.ear.dir">
         <copyfiles files="${reference.SuperDAO.jar}" todir="${build.web.dir}/WEB-INF/lib"/>
     </target>
-    <target depends="init,compile,compile-jsps,-pre-dist,library-inclusion-in-manifest" if="do.tmp.war.package" name="do-ear-dist">
+    <target depends="init" if="dist.ear.dir" name="-clean-webinf-lib">
+        <delete dir="${build.web.dir}/WEB-INF/lib"/>
+    </target>
+    <target depends="init,-clean-webinf-lib,compile,compile-jsps,-pre-dist,library-inclusion-in-manifest" if="do.tmp.war.package" name="do-ear-dist">
         <dirname file="${dist.ear.war}" property="dist.jar.dir"/>
         <mkdir dir="${dist.jar.dir}"/>
@@ -546,5 +558,5 @@
     </target>
     <target depends="init,compile,-pre-dist,do-dist,-post-dist" description="Build distribution (WAR)." name="dist"/>
-    <target depends="init,-init-cos,compile,-pre-dist,do-ear-dist,-post-dist" description="Build distribution (WAR) to be packaged into an EAR." name="dist-ear"/>
+    <target depends="init,-clean-webinf-lib,-init-cos,compile,-pre-dist,do-ear-dist,-post-dist" description="Build distribution (WAR) to be packaged into an EAR." name="dist-ear"/>
     <!--
                 EXECUTION SECTION
@@ -661,5 +673,5 @@
                 DEBUGGING SECTION
             -->
-    <target depends="init,compile,compile-jsps,-do-compile-single-jsp,-pre-dist,-do-tmp-dist-with-manifest,-do-tmp-dist-without-manifest" description="Debug project in IDE." if="netbeans.home" name="debug">
+    <target depends="init,-init-cos,compile,compile-jsps,-do-compile-single-jsp,-pre-dist,-do-tmp-dist-with-manifest,-do-tmp-dist-without-manifest" description="Debug project in IDE." if="netbeans.home" name="debug">
         <nbstartserver debugmode="true"/>
         <antcall target="connect-debugger"/>
@@ -736,4 +748,5 @@
     <target depends="init,compile" if="have.tests" name="-pre-pre-compile-test">
         <mkdir dir="${build.test.classes.dir}"/>
+        <property name="j2ee.platform.embeddableejb.classpath" value=""/>
     </target>
     <target name="-pre-compile-test">
@@ -742,5 +755,5 @@
     </target>
     <target depends="init,compile,-pre-pre-compile-test,-pre-compile-test" if="have.tests" name="-do-compile-test">
-        <webproject2:javac classpath="${javac.test.classpath}:${j2ee.platform.classpath}" debug="true" destdir="${build.test.classes.dir}" srcdir="${test.src.dir}"/>
+        <webproject2:javac classpath="${javac.test.classpath}:${j2ee.platform.classpath}:${j2ee.platform.embeddableejb.classpath}" debug="true" destdir="${build.test.classes.dir}" srcdir="${test.src.dir}"/>
         <copy todir="${build.test.classes.dir}">
             <fileset dir="${test.src.dir}" excludes="${build.classes.excludes},${excludes}" includes="${includes}"/>
@@ -758,5 +771,5 @@
     <target depends="init,compile,-pre-pre-compile-test,-pre-compile-test-single" if="have.tests" name="-do-compile-test-single">
         <fail unless="javac.includes">Must select some files in the IDE or set javac.includes</fail>
-        <webproject2:javac classpath="${javac.test.classpath}:${j2ee.platform.classpath}" debug="true" destdir="${build.test.classes.dir}" excludes="" includes="${javac.includes}" srcdir="${test.src.dir}"/>
+        <webproject2:javac classpath="${javac.test.classpath}:${j2ee.platform.classpath}:${j2ee.platform.embeddableejb.classpath}" debug="true" destdir="${build.test.classes.dir}" excludes="" includes="${javac.includes}" srcdir="${test.src.dir}"/>
         <copy todir="${build.test.classes.dir}">
             <fileset dir="${test.src.dir}" excludes="${build.classes.excludes},${excludes}" includes="${includes}"/>
@@ -805,5 +818,5 @@
         <!-- must exist, otherwise the XML formatter would fail -->
         <mkdir dir="${build.test.results.dir}"/>
-        <webproject1:debug args="${test.class}" classname="org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner" classpath="${ant.home}/lib/ant.jar:${ant.home}/lib/ant-junit.jar:${debug.test.classpath}">
+        <webproject1:debug args="${test.class}" classname="org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner" classpath="${ant.home}/lib/ant.jar:${ant.home}/lib/ant-junit.jar:${debug.test.classpath}:${j2ee.platform.embeddableejb.classpath}">
             <customize>
                 <arg value="showoutput=true"/>
Index: java/sql-vyuka/nbproject/genfiles.properties
===================================================================
--- java/sql-vyuka/nbproject/genfiles.properties	(revision 46:da0e675db1cf)
+++ java/sql-vyuka/nbproject/genfiles.properties	(revision 74:48066e753dd6)
@@ -4,5 +4,5 @@
 # This file is used by a NetBeans-based IDE to track changes in generated files such as build-impl.xml.
 # Do not edit this file. You may delete it but then the IDE will never regenerate such files for you.
-nbproject/build-impl.xml.data.CRC32=eb6453d4
-nbproject/build-impl.xml.script.CRC32=857df3c0
-nbproject/build-impl.xml.stylesheet.CRC32=8ab4467e@1.15.1.1
+nbproject/build-impl.xml.data.CRC32=3f9299bb
+nbproject/build-impl.xml.script.CRC32=1628db8a
+nbproject/build-impl.xml.stylesheet.CRC32=b139b33b@1.21.1.1
Index: java/sql-vyuka/nbproject/project.properties
===================================================================
--- java/sql-vyuka/nbproject/project.properties	(revision 49:083966fa9d9d)
+++ java/sql-vyuka/nbproject/project.properties	(revision 74:48066e753dd6)
@@ -19,9 +19,10 @@
 dist.javadoc.dir=${dist.dir}/javadoc
 dist.war=${dist.dir}/${war.name}
+endorsed.classpath=
 excludes=
 includes=**
 j2ee.deploy.on.save=false
 j2ee.platform=1.5
-j2ee.server.type=J2EE
+j2ee.server.type=gfv3ee6
 jar.compress=false
 javac.classpath=\
@@ -48,4 +49,5 @@
 javadoc.version=false
 javadoc.windowtitle=
+jaxbwiz.endorsed.dirs="${netbeans.home}/../ide12/modules/ext/jaxb/api"
 jspcompilation.classpath=${jspc.classpath}:${javac.classpath}
 lib.dir=${web.docbase.dir}/WEB-INF/lib
Index: java/sql-vyuka/nbproject/project.xml
===================================================================
--- java/sql-vyuka/nbproject/project.xml	(revision 15:8632e6037843)
+++ java/sql-vyuka/nbproject/project.xml	(revision 74:48066e753dd6)
@@ -7,5 +7,5 @@
             <minimum-ant-version>1.6.5</minimum-ant-version>
             <web-module-libraries>
-                <library>
+                <library dirs="200">
                     <file>${reference.SuperDAO.jar}</file>
                     <path-in-war>WEB-INF/lib</path-in-war>
Index: java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/web/Ajax.java
===================================================================
--- java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/web/Ajax.java	(revision 37:e32867db5487)
+++ java/sql-vyuka/src/java/cz/frantovo/sql/vyuka/web/Ajax.java	(revision 74:48066e753dd6)
@@ -26,22 +26,22 @@
      */
     public void setKlient(String ipAdresa, String ipPresmerovano, String idSezeni) {
-        if ("127.0.0.1".equals(ipAdresa) && ipPresmerovano != null) {
-            uzivatel.setIpAdresa(ipPresmerovano);
-        } else {
-            uzivatel.setIpAdresa(ipAdresa);
-        }
-        uzivatel.setIdSezeni(idSezeni);
+	if (("127.0.0.1".equals(ipAdresa) || "10.0.0.31".equals(ipAdresa)) && ipPresmerovano != null) {
+	    uzivatel.setIpAdresa(ipPresmerovano);
+	} else {
+	    uzivatel.setIpAdresa(ipAdresa);
+	}
+	uzivatel.setIdSezeni(idSezeni);
     }
 
     public void setSqlPrikaz(String sqlPrikaz) {
-        this.sqlPrikaz = sqlPrikaz;
+	this.sqlPrikaz = sqlPrikaz;
     }
 
     public void setIdPruvodce(long idPruvodce) {
-        this.idPruvodce = idPruvodce;
+	this.idPruvodce = idPruvodce;
     }
 
     public void setKodPruvodce(String kodPruvodce) {
-        this.kodPruvodce = kodPruvodce;
+	this.kodPruvodce = kodPruvodce;
     }
 
@@ -50,6 +50,6 @@
      */
     public VysledekSQL getHistorie() {
-        HistorieDAO h = new HistorieDAO();
-        return h.nactiHistorii(uzivatel);
+	HistorieDAO h = new HistorieDAO();
+	return h.nactiHistorii(uzivatel);
     }
 
@@ -59,6 +59,6 @@
      */
     public VysledekSQL getSQLVysledek() {
-        PiskovisteDAO p = new PiskovisteDAO();
-        return p.vykonejSQL(sqlPrikaz, uzivatel);
+	PiskovisteDAO p = new PiskovisteDAO();
+	return p.vykonejSQL(sqlPrikaz, uzivatel);
     }
 
@@ -68,7 +68,7 @@
      */
     public Pruvodce getPruvodcePodleId() {
-        PruvodceDAO dao = new PruvodceDAO();
-        Pruvodce p = dao.getPruvodce(idPruvodce);
-        return osetriChybuPruvodce(p);
+	PruvodceDAO dao = new PruvodceDAO();
+	Pruvodce p = dao.getPruvodce(idPruvodce);
+	return osetriChybuPruvodce(p);
     }
 
@@ -79,7 +79,7 @@
      */
     public Pruvodce getPruvodcePodleKodu() {
-        PruvodceDAO dao = new PruvodceDAO();
-        Pruvodce p = dao.getPruvodce(kodPruvodce);
-        return osetriChybuPruvodce(p);
+	PruvodceDAO dao = new PruvodceDAO();
+	Pruvodce p = dao.getPruvodce(kodPruvodce);
+	return osetriChybuPruvodce(p);
     }
 
@@ -90,7 +90,7 @@
      */
     public Pruvodce getPruvodcePredchozi() {
-        PruvodceDAO dao = new PruvodceDAO();
-        Pruvodce p = dao.getPruvodcePredchozi(idPruvodce);
-        return osetriChybuPruvodce(p);
+	PruvodceDAO dao = new PruvodceDAO();
+	Pruvodce p = dao.getPruvodcePredchozi(idPruvodce);
+	return osetriChybuPruvodce(p);
     }
 
@@ -101,7 +101,7 @@
      */
     public Pruvodce getPruvodceNasledujici() {
-        PruvodceDAO dao = new PruvodceDAO();
-        Pruvodce p = dao.getPruvodceNasledujici(idPruvodce);
-        return osetriChybuPruvodce(p);
+	PruvodceDAO dao = new PruvodceDAO();
+	Pruvodce p = dao.getPruvodceNasledujici(idPruvodce);
+	return osetriChybuPruvodce(p);
     }
 
@@ -111,12 +111,12 @@
      */
     private static Pruvodce osetriChybuPruvodce(Pruvodce p) {
-        if (p == null) {
-            p = new Pruvodce();
-            p.setKod("chyba");
-            p.setNadpis("pruvodce.chyba.nadpis");
-            p.setObsah("pruvodce.chyba.obsah");
-            p.setLokalizovat(true);
-        }
-        return p;
+	if (p == null) {
+	    p = new Pruvodce();
+	    p.setKod("chyba");
+	    p.setNadpis("pruvodce.chyba.nadpis");
+	    p.setObsah("pruvodce.chyba.obsah");
+	    p.setLokalizovat(true);
+	}
+	return p;
     }
 }
Index: java/sql-vyuka/web/WEB-INF/chyby/404.jsp
===================================================================
--- java/sql-vyuka/web/WEB-INF/chyby/404.jsp	(revision 74:48066e753dd6)
+++ java/sql-vyuka/web/WEB-INF/chyby/404.jsp	(revision 74:48066e753dd6)
@@ -0,0 +1,20 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<jsp:root xmlns:jsp="http://java.sun.com/JSP/Page"
+	  xmlns:c="http://java.sun.com/jsp/jstl/core"
+	  version="2.0">
+    <jsp:directive.page contentType="application/xhtml+xml" isErrorPage="true"/>
+    <jsp:output doctype-system="http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"
+		doctype-root-element="html"
+		omit-xml-declaration="false"/>
+
+    <html xmlns="http://www.w3.org/1999/xhtml">
+	<head>
+	    <title>404 Stránka nenalezena</title>
+	</head>
+	<body>
+	    <h1>404 Stránka nenalezena</h1>
+	    <p>Takovou stránku tu bohužel nemáme.</p>
+	</body>
+    </html>
+
+</jsp:root>
Index: java/sql-vyuka/web/WEB-INF/chyby/500.jsp
===================================================================
--- java/sql-vyuka/web/WEB-INF/chyby/500.jsp	(revision 74:48066e753dd6)
+++ java/sql-vyuka/web/WEB-INF/chyby/500.jsp	(revision 74:48066e753dd6)
@@ -0,0 +1,20 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<jsp:root xmlns:jsp="http://java.sun.com/JSP/Page"
+	  xmlns:c="http://java.sun.com/jsp/jstl/core"
+	  version="2.0">
+    <jsp:directive.page contentType="application/xhtml+xml" isErrorPage="true"/>
+    <jsp:output doctype-system="http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"
+		doctype-root-element="html"
+		omit-xml-declaration="false"/>
+
+    <html xmlns="http://www.w3.org/1999/xhtml">
+	<head>
+	    <title>500 Interní chyba serveru</title>
+	</head>
+	<body>
+	    <h1>500 Interní chyba serveru</h1>
+	    <p>Něco se nám nepovedlo.</p>
+	</body>
+    </html>
+
+</jsp:root>
Index: java/sql-vyuka/web/WEB-INF/web.xml
===================================================================
--- java/sql-vyuka/web/WEB-INF/web.xml	(revision 32:de496b29191b)
+++ java/sql-vyuka/web/WEB-INF/web.xml	(revision 74:48066e753dd6)
@@ -9,3 +9,11 @@
         <welcome-file>index.jsp</welcome-file>
     </welcome-file-list>
+    <error-page>
+        <error-code>404</error-code>
+        <location>/WEB-INF/chyby/404.jsp</location>
+    </error-page>
+    <error-page>
+        <error-code>500</error-code>
+        <location>/WEB-INF/chyby/500.jsp</location>
+    </error-page>
 </web-app>
