по
Journal Menu
> Issues > Rubrics > About journal > Authors > About the Journal > Requirements for publication > Council of Editors > Peer-review process > Peer-review in 24 hours: How do we do it? > Policy of publication. Aims & Scope. > Article retraction > Ethics > Copyright & Licensing Policy > Publication in 72 hours: How do we do it? > Digital archiving policy > Open Access Policy > Open access publishing costs > Article Identification Policy > Plagiarism check policy
Journals in science databases
About the Journal

Публикация за 72 часа - теперь это реальность!
При необходимости издательство предоставляет авторам услугу сверхсрочной полноценной публикации. Уже через 72 часа статья появляется в числе опубликованных на сайте издательства с DOI и номерами страниц.
По первому требованию предоставляем все подтверждающие публикацию документы!
MAIN PAGE > Back to contents
Cybernetics and programming
Reference:

Database Connection Technologies from JSP Pages and Java Web Application Servlets
Gribanova-Podkina Mariya

PhD in Physics and Mathematics

Associate Professor, Department of Physics and Information Technology, Balashov Institute (branch) of the Chernyshevsky National Research Saratov State University

412300, Russia, Saratovskaya oblast', g. Balashov, ul. Karla Marksa, 29

m.gribanova-podkina@rambler.ru
Другие публикации этого автора
 

 

Abstract.

The purpose of the study is to demonstrate the diversity of solutions on the issue of connecting to a database, including a description of the developed connection controller class, as well as various ways to create connection pools on a web server and application servers. The article discusses the practical issues of using JDBC technology when building a Java web application. In the examples, the presentation and business layer of the application are developed using JSP-pages and servlets, the database operates on the MySQL platform. The described methods for creating and configuring a connection pool are shown on the example of the ApacheTomcat web server and the GlassFish application server. The question of optimizing database connections in Java applications remains open, despite the diversity of solutions. The study examines and proposes methods for constructing classes of connectors, various methods for creating pool connections, and describes the results of solving problems arising from the implementation of the described techniques. A detailed classification of ways to connect to the database is given.

Keywords: GlassFish, MySQL, application server, web server, connection pool, JDBC, database, web application, connection controller, data source

DOI:

10.25136/2306-4196.2019.2.19589

Article was received:

11-07-2016


Review date:

07-07-2016


Publish date:

27-05-2019


This article written in Russian. You can find full text of article in Russian here .

References
1.
Gribanova-Podkina M.Yu., Annushkin A.V. Model' informatsionnoi sistemy ucheta dvizheniya tovara v komp'yuternom magazine // Tekhnicheskie nauki - ot teorii k praktike: sb. st. po mater. LVII mezhdunar. nauch.-prakt. konf. № 4(52). Novosibirsk: SibAK, 2016. S. 44-51.
2.
Gribanova-Podkina M.Yu. UML-model' partionnogo ucheta tovara dlya avtomatizirovannoi informatsionnoi sistemy // Programmnye sistemy i vychislitel'nye metody. 2016. № 2. C. 111-123. DOI: 10.7256/2305-6061.2016.2.19271
3.
Prosteishii Connection pool bez DataSource v Java [Elektronnyi resurs]. URL: https://habrahabr.ru/post/229199/ (data obrashcheniya: 30.06.2016)
4.
Apache Tomcat 8 (8.0.36) - The Tomcat JDBC Connection Pool [Elektronnyi resurs]. URL: https://tomcat.apache.org/tomcat-8.0-doc/jdbc-pool.html (data obrashcheniya: 30.06.2016)
5.
Kheffel'finger D. Java EE 7 i server prilozhenii GlassFish 4 / per. s angl. A. N. Kiseleva. Moskva: DMK Press, 2016. 331s.
6.
Sun GlassFish Enterprise Server 2.1 Administration Guide [Elektronnyi resurs]. URL: https://docs.oracle.com/cd/E19879-01/820-4335/ablip/index.html (data obrashcheniya: 30.06.2016)
7.
Sozdanie prostogo veb-prilozheniya s ispol'zovaniem bazy dannykh MySQL [Elektronnyi resurs]. URL: https://netbeans.org/kb/docs/web/mysql-webapp_ru.html (data obrashcheniya: 30.06.2016)
8.
Bug 254192 - New File glassfish-resources.xml is created in WEB-INF and JSF application will not run [Elektronnyi resurs]. URL: https://netbeans.org/bugzilla/show_bug.cgi?id=254192 (data obrashcheniya: 30.06.2016)
9.
Bug 243034 - The file glassfish-resources.xml in project is not executed on Glassfish in order to install a jdbc pool [Elektronnyi resurs]. URL: https://netbeans.org/bugzilla/show_bug.cgi?id=243034 (data obrashcheniya: 30.06.2016)
10.
Connect to Oracle using a connection pool [Elektronnyi resurs]. URL: http://www.rgagnon.com/javadetails/java-0545.html (data obrashcheniya: 30.06.2016)
11.
The DBCP Component [Elektronnyi resurs]. URL: http://commons.apache.org/proper/commons-dbcp/ (data obrashcheniya: 30.06.2016)
12.
HikariCP [Elektronnyi resurs]. URL: https://brettwooldridge.github.io/HikariCP/ (data obrashcheniya: 30.06.2016)
13.
c3p0 - JDBC3 Connection and Statement Pooling [Elektronnyi resurs]. URL: http://www.mchange.com/projects/c3p0/ (data obrashcheniya: 30.06.2016)
Link to this article

You can simply select and copy link from below text field.


Other our sites:
Official Website of NOTA BENE / Aurora Group s.r.o.
"History Illustrated" Website