Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Feature Request] Allow configuration of Database connection pool from container server (Tomcat, Jetty, Wildfly) #3638

Closed
e-Evolution opened this issue Oct 1, 2021 · 0 comments · Fixed by #3639
Closed

[Feature Request] Allow configuration of Database connection pool from container server (Tomcat, Jetty, Wildfly) #3638

e-Evolution opened this issue Oct 1, 2021 · 0 comments · Fixed by #3639
Assignees
@e-Evolution
Labels
01 enhancement (SC) System Core
Milestone
3.9.4

Comments

@e-Evolution
Copy link
Contributor

e-Evolution commented Oct 1, 2021 •
edited

Feature request

Allow configuration of Database connection pool from container server

  • Adding support to Tomcat 9
  • Adding Support to Jetty
  • Adding Support to Wildfly
  • Remove Support to the JBoss and Glasfish
  • Adding Support to execute ADempiere using JDK 11 and JDK 17

Describe the solution you'd like

  • Currently the distribution of JBoss is included, Tomcat destroys the ADempiere installation binary which takes up space and does not allow to configure transparently for any updated container server, for this reason the current jboss and tomcat directories are removed and replaced by directories where only the configuration required for each application server is saved.

  • New files have been added to set the configuration parameters of the database connection pool for each of the supported application servers

  • New templete context.xml to support Tomcat

  • New templete jetty-ds.xml to support Jetty

  • New templete postgresql-ds.xml , oracle-ds.xml to support Wildfly

Additional context

for more information check TOMCAT_BASE, JETTY_BASE -Djboss.server.base.dir deployments directory
@e-Evolution e-Evolution self-assigned this Oct 1, 2021
@e-Evolution e-Evolution added this to the 3.9.4 milestone Oct 1, 2021
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 3, 2021
@e-Evolution
adempiere#3638 [Feature Request] Allow configuration of Database conn…
fd01870 
…ection pool from container server (Tomcat, Jetty, Wildfly) adempiere#3638

-Remove Tomcat binary now not is necessary you can use the default TOMCAT_BASE environment variable to setting.
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 3, 2021
@e-Evolution
adempiere#3638 [Feature Request] Allow configuration of Database conn…
b5eb57d 
…ection pool from container server (Tomcat, Jetty, Wildfly) adempiere#3638

- Add log exception when to get connection is not found
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 3, 2021
@e-Evolution
adempiere#3638 [Feature Request] Allow configuration of Database conn…
3378796 
…ection pool from container server (Tomcat, Jetty, Wildfly) adempiere#3638

- Add template for the database pool configuration from the application server
- Add data source settings to web applications
- Add support for wildfly 24.0.1.Final
  https://www.wildfly.org/
- Add support for Jetty
- Add support for Tomcat 9
- Add configuration files to configure the connection pool for each application server (Tomcat, Jetty, WildFly)
- Update startup shell scripts for new services
- Add support for Java 17 TLS
- Remove obsolete Tomcat configuration
- Remove obsolete JBoss configuration
- Remove obsolete configuration of Glassfish
- Remove support for Java 8
- Rename the JVM Sun to JVM Oracle
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 3, 2021
@e-Evolution
adempiere#3638 [Feature Request] Allow configuration of Database conn…
3a175ca 
…ection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638

- Set the transaction from Persistence Object avoid null transaction error
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 3, 2021
@e-Evolution
adempiere#3638 [Feature Request] Allow configuration of Database conn…
d9f0835 
…ection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638

- WildFly add setting for login module
@e-Evolution e-Evolution mentioned this issue Oct 3, 2021
Merged
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 3, 2021
@e-Evolution
adempiere#3638 [Feature Request] Allow configuration of Database conn…
6f29a52 
…ection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638

- Change the transaction insolation to TRANSACTION_READ_COMMITTED
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 3, 2021
@e-Evolution
adempiere#3638 [Feature Request] Allow configuration of Database conn…
2f290a1 
…ection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638

- Fix the Bash shell and Window cmd shell m thank you to @piracio thanks you for the help in testing and fixing the RUN_Server2.bat for window
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 3, 2021
@e-Evolution
adempiere#3638 [Feature Request] Allow configuration of Database conn…
b327379 
…ection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638

- Update JDBC Driver for Oracle and PostgreSQL
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 3, 2021
@e-Evolution
adempiere#3638 [Feature Request] Allow configuration of Database conn…
0c6187f 
…ection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638

- Update the name for Java VM for MacOS
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 3, 2021
@e-Evolution
adempiere#3638 [Feature Request] Allow configuration of Database conn…
2958feb 
…ection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638

- Adding setting to support OracleXE
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 6, 2021
@e-Evolution
Merge branch 'feature/3638' of https://github.com/e-Evolution/adempiere…
6b38030 
… into develop

* 'feature/3638' of https://github.com/e-Evolution/adempiere:
  adempiere#3638 [Feature Request] Allow configuration of Database connection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638 - Adding setting to support OracleXE
  adempiere#3638 [Feature Request] Allow configuration of Database connection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638 - Update the name for Java VM for MacOS
  adempiere#3638 [Feature Request] Allow configuration of Database connection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638 - Update JDBC Driver for Oracle and PostgreSQL
  adempiere#3638 [Feature Request] Allow configuration of Database connection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638 - Fix the Bash shell and Window cmd shell m thank you to @piracio thanks you for the help in testing and fixing the RUN_Server2.bat for window
  adempiere#3638 [Feature Request] Allow configuration of Database connection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638 - Change the transaction insolation to TRANSACTION_READ_COMMITTED
  adempiere#3638 [Feature Request] Allow configuration of Database connection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638 - WildFly add setting for login module
  adempiere#3638 [Feature Request] Allow configuration of Database connection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638 - Set the transaction from Persistence Object avoid null transaction error
  adempiere#3638 [Feature Request] Allow configuration of Database connection pool from container server (Tomcat, Jetty, Wildfly) adempiere#3638 - Add template for the database pool configuration from the application server - Add data source settings to web applications - Add support for wildfly 24.0.1.Final   https://www.wildfly.org/ - Add support for Jetty - Add support for Tomcat 9 - Add configuration files to configure the connection pool for each application server (Tomcat, Jetty, WildFly) - Update startup shell scripts for new services - Add support for Java 17 TLS - Remove obsolete Tomcat configuration - Remove obsolete JBoss configuration - Remove obsolete configuration of Glassfish - Remove support for Java 8 - Rename the JVM Sun to JVM Oracle
  adempiere#3638 [Feature Request] Allow configuration of Database connection pool from container server (Tomcat, Jetty, Wildfly) adempiere#3638 - Add log exception when to get connection is not found
  adempiere#3638 [Feature Request] Allow configuration of Database connection pool from container server (Tomcat, Jetty, Wildfly) adempiere#3638 -Remove Tomcat binary now not is necessary you can use the default TOMCAT_BASE environment variable to setting.
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 6, 2021
@e-Evolution
adempiere#3638 [Feature Request] Allow configuration of Database conn…
4641cb7 
…ection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638

- Fix PostgreSQL connection test
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 6, 2021
@e-Evolution
adempiere#3638 [Feature Request] Allow configuration of Database conn…
e160f64 
…ection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638

- Fix DB SQL for  connection test
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 8, 2021
@e-Evolution
adempiere#3638 [Feature Request] Allow configuration of Database conn…
00d18f4 
…ection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638

- Adding setting IntelliJ and Scala to testing Tomcat and Jetty
- Improve the log message
- Create the deployment standard directory for Tomcat and Jetty
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 8, 2021
@e-Evolution
adempiere#3638 [Feature Request] Allow configuration of Database conn…
b097116 
…ection pool from container server (Tomcat, Jetty, WildFly)

- Remove checking to the obsolete library
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 13, 2021
@e-Evolution
adempiere#3638 [Feature Request] Allow configuration of Database conn…
143a38a 
…ection pool from container server (Tomcat, Jetty, WildFly)

- Fix the stand alone startup process as client mode MigrationLoader.java SignDatabaseBuild.java
- Fix the Java 1.8 replace for Java 11 and 17
- Implement the CATALINA_BASE to deployment
- Define the environment WILDFLY_BASE , CATALINA_BASE , JETTY_BASE
- Fix the start and stop script
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 13, 2021
@e-Evolution
adempiere#3638 [Feature Request] Allow configuration of Database conn…
6d1cb50 
…ection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638

- Fix the new parameters for JVM 11 to build the CI
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 14, 2021
@e-Evolution
adempiere#3638 [Feature Request] Allow configuration of Database conn…
71d9e91 
…ection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638

- Adding the run silent setup to best the continue integration
- Update AdempiereEnvTemplete.properties
- Update Github Action Continue Integration
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 14, 2021
@e-Evolution
adempiere#3638 [Feature Request] Allow configuration of Database conn…
1a319a5 
…ection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638

- Accept the GPL license after execute the silent setup
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 14, 2021
@e-Evolution
adempiere#3638 [Feature Request] Allow configuration of Database conn…
db54b79 
…ection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638

- Remove unnecessary files
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 14, 2021
@e-Evolution
adempiere#3638 [Feature Request] Allow configuration of Database conn…
4ad5128 
…ection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638

- Remove unnecessary files
- Change the default host for Application Server , Email Server and FTP Server
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 14, 2021
@e-Evolution
adempiere#3638 [Feature Request] Allow configuration of Database conn…
a095913 
…ection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638

- Remove unnecessary files
e-Evolution added a commit to e-Evolution/adempiere that referenced this issue Oct 14, 2021
@e-Evolution
adempiere#3638 [Feature Request] Allow configuration of Database conn…
fe4b41d 
…ection pool from container server (Tomcat, Jetty, WildFly) adempiere#3638

- Remove the obsolete JBoss Application  and replace by new WildFly
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@e-Evolution e-Evolution

Labels
01 enhancement (SC) System Core
Projects
None yet
Milestone
3.9.4
1 participant
@e-Evolution