my notes

User Tools

Site Tools

Trace:
java:java

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

java:java [2022/07/26 06:08] – [org.hibernate.connection.C3P0ConnectionProvider with c3p0 connection pool] adminjava:java [2022/10/29 16:15] (current) – external edit 127.0.0.1
Line 562: Line 562:
   * **Atomic variables** have features that minimize synchronization and help avoid memory consistency errors.   * **Atomic variables** have features that minimize synchronization and help avoid memory consistency errors.
   * **ThreadLocalRandom** (in JDK 7) provides **efficient generation of pseudorandom numbers from multiple threads**.   * **ThreadLocalRandom** (in JDK 7) provides **efficient generation of pseudorandom numbers from multiple threads**.
-=== Executor Interfaces === + 
-=== Thread pools ===+==== Thread pools ==== 
 +{{:java:thread-pool-tasks.png|}}
 refer:  refer: 
-  * https://docs.oracle.com/javase/tutorial/essential/concurrency/pools.html +  * https://www.baeldung.com/thread-pool-java-and-guava
-  * http://docs.oracle.com/javase/7/docs/api/java/util/concurrent/ThreadPoolExecutor.html+
   * http://howtodoinjava.com/2012/10/20/how-to-use-blockingqueue-and-threadpoolexecutor-in-java   * http://howtodoinjava.com/2012/10/20/how-to-use-blockingqueue-and-threadpoolexecutor-in-java
 +  * http://docs.oracle.com/javase/7/docs/api/java/util/concurrent/ThreadPoolExecutor.html
 Thread pools address two different problems:  Thread pools address two different problems: 
   * They usually provide improved performance when **executing large numbers of asynchronous tasks**, due to reduced per-task invocation overhead   * They usually provide improved performance when **executing large numbers of asynchronous tasks**, due to reduced per-task invocation overhead
Line 1202: Line 1203:
 session.close(); session.close();
 </code> </code>
-==== Hibernate connection pooling and mysql connection timeout ====+ 
 +=== Custom Configure === 
 +refer: http://docs.jboss.org/hibernate/orm/4.2/manual/en-US/html/ch03.html#configuration-optional 
 +=== Hibernate map editor === 
 +=== Hibernate reverseengineering tool === 
 +refer:  
 +  * http://docs.jboss.org/tools/4.0.1.Final/en/hibernatetools/html_single/#refeng_codegen 
 +  * http://docs.jboss.org/tools/latest/en/hibernatetools/html/reverseengineering.html 
 +  * http://docs.jboss.org/tools/latest/en/hibernatetools/html/plugins.html 
 +  * http://www.mkyong.com/hibernate/how-to-generate-code-with-hibernate-tools/ 
 +Steps by steps to use reverseengineering tool in eclipse: 
 +  - Step1:** Create Hibernate configuration file(hibernate.cfg.xml)** for project: **right click project name -> New -> Hibernate Configuration File(.cfg.xml)** {{:java:create-hibernate-config.jpg|}}\\ with some basic informations below: 
 +    * database name: test 
 +    * username: admin 
 +    * password: admin12!@  
 +  - Step2: **Create Hibernate Console Configuration**: A Console configuration describes how the Hibernate plugin should configure Hibernate and what configuration files and classpaths are needed to load the POJO's, JDBC drivers etc. It is **required** to make use of **query prototyping, reverse engineering and code generation** 
 +  - Step3: view **Hibernate Console Configuration** created from Step2. Go to **window->show view->Hibernate Configurations**\\ {{:java:hibernate-console-configuration.jpg|}} 
 +  - Step4: Create configuration for Hibernate code generator {{:java:hibernate_code_gen.png|}} 
 +  - Step5: Config Main for Hibernate code generator 
 +    * Check option **Reverse engineer from JDBC Connection** 
 +    * And enter package name, for example: **vn.casino.entities**{{:java:hibernate-code-generator-main.jpg|}}  
 +  - Step6: Config Export for **Hibernate code generator**: Check 2 options **Domain Code and Hibernate XML Mappings**: {{:java:hibernate-code-generator-exporter.jpg|}}Note: You add option **Hibernate XML Configuration** to generate **hibernate.cfg.xml** 
 +  - Step7: Click **Run** to generate java code and Hibernate XML Mappings 
 +==== Hibernate Foreign key Using XML mapping ==== 
 +refer:  
 +  * one-to-one: http://www.tutorialspoint.com/hibernate/hibernate_one_to_one_mapping.htm 
 +  * one-to-many: http://www.tutorialspoint.com/hibernate/hibernate_one_to_many_mapping.htm 
 +==== Hibernate log ==== 
 +You need to config display log for package org.hibernate with log4j to check hibernate log<code ini> 
 +# org.hibernate FileAppender 
 +log4j.appender.hibernateAppender=org.apache.log4j.DailyRollingFileAppender 
 +log4j.appender.hibernateAppender.layout=org.apache.log4j.PatternLayout 
 +log4j.appender.hibernateAppender.File=logs/cardgameExt/hibernate.log 
 +log4j.appender.hibernateAppender.layout.ConversionPattern=%d{dd MMM yyyy | HH:mm:ss,SSS} | %-5p | %t | %c{3} | %3x | %m%n 
 +log4j.appender.hibernateAppender.Encoding=UTF-8 
 +log4j.appender.hibernateAppender.DatePattern='.'yyyy-MM-dd 
 +log4j.category.org.hibernate=INFO,consoleAppender,hibernateAppender 
 +</code> 
 +===== Java Connection Pool ====
 Connection pooling is the technique used to increase the performance of the application when an  Connection pooling is the technique used to increase the performance of the application when an 
 Connection pooling takes care of **managing connections(prepare,open and close)** Connection pooling takes care of **managing connections(prepare,open and close)**
Line 1210: Line 1249:
   * This way we can use the connections in a more better way, as **we no need to wait for the connection to be established during the actual execution of our code** and we don’t have to worry about stale connections   * This way we can use the connections in a more better way, as **we no need to wait for the connection to be established during the actual execution of our code** and we don’t have to worry about stale connections
 refer:  refer: 
-  * https://www.progress.com/tutorials/jdbc/jdbc-jdbc-connection-pooling +  * https://docs.oracle.com/cd/E13222_01/wls/docs81/ConsoleHelp/jdbc_connection_pools.html
-  * http://stackoverflow.com/questions/10695028/hibernate-mysql-connection-timeout +
-  * https://docs.jboss.org/hibernate/orm/4.2/devguide/en-US/html/ch01.html +
-  * {{:java:pooling.jpg|}}+
   * {{:java:connection-pool.png|}}   * {{:java:connection-pool.png|}}
-Below are basic steps config for connections in Hibernate(each connection in MySQL was a session in Hibernate):+  * {{:java:pooling.jpg|}} 
 + 
 +==== Default Hibernate connection pooling ==== 
 +Below are basic steps config for connections in Hibernate(each connection in MySQL was a session in Hibernate)(refer: https://docs.jboss.org/hibernate/stable/core.old/reference/en/html/configuration-hibernatejdbc.html):
   - Config max connections in MySQL:   - Config max connections in MySQL:
     * config temporary in MySQL Admin console:<code sql>     * config temporary in MySQL Admin console:<code sql>
Line 1247: Line 1286:
 } }
 </code> </code>
-=== Default JDBC Connection and Default Connection Pool=== 
 Most important Hibernate JDBC properties:<code xml> Most important Hibernate JDBC properties:<code xml>
 <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property> <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
Line 1256: Line 1294:
 <property name="hibernate.connection.pool_size">1</property> <property name="hibernate.connection.pool_size">1</property>
 </code>=> Hibernate's internal connection pooling algorithm is rudimentary, and is provided for development and testing purposes. **Use a third-party pool for best performance and stability**. To use a third-party pool, **replace the hibernate.connection.pool_size property** with **settings specific to your connection pool of choice**. This disables Hibernate's internal connection pool. </code>=> Hibernate's internal connection pooling algorithm is rudimentary, and is provided for development and testing purposes. **Use a third-party pool for best performance and stability**. To use a third-party pool, **replace the hibernate.connection.pool_size property** with **settings specific to your connection pool of choice**. This disables Hibernate's internal connection pool.
-=== org.hibernate.connection.C3P0ConnectionProvider with c3p0 connection pool ===+==== org.hibernate.connection.C3P0ConnectionProvider with c3p0 connection pool ====
 refer: refer:
   * https://www.mchange.com/projects/c3p0/ and github https://github.com/swaldman/c3p0   * https://www.mchange.com/projects/c3p0/ and github https://github.com/swaldman/c3p0
Line 1325: Line 1363:
   * Global statements pool(statements cached): <code xml>   * Global statements pool(statements cached): <code xml>
 <property name="hibernate.c3p0.max_statements">1000</property> <property name="hibernate.c3p0.max_statements">1000</property>
-</code> 
-=== Custom Configure === 
-refer: http://docs.jboss.org/hibernate/orm/4.2/manual/en-US/html/ch03.html#configuration-optional 
-=== Hibernate map editor === 
-=== Hibernate reverseengineering tool === 
-refer:  
-  * http://docs.jboss.org/tools/4.0.1.Final/en/hibernatetools/html_single/#refeng_codegen 
-  * http://docs.jboss.org/tools/latest/en/hibernatetools/html/reverseengineering.html 
-  * http://docs.jboss.org/tools/latest/en/hibernatetools/html/plugins.html 
-  * http://www.mkyong.com/hibernate/how-to-generate-code-with-hibernate-tools/ 
-Steps by steps to use reverseengineering tool in eclipse: 
-  - Step1:** Create Hibernate configuration file(hibernate.cfg.xml)** for project: **right click project name -> New -> Hibernate Configuration File(.cfg.xml)** {{:java:create-hibernate-config.jpg|}}\\ with some basic informations below: 
-    * database name: test 
-    * username: admin 
-    * password: admin12!@  
-  - Step2: **Create Hibernate Console Configuration**: A Console configuration describes how the Hibernate plugin should configure Hibernate and what configuration files and classpaths are needed to load the POJO's, JDBC drivers etc. It is **required** to make use of **query prototyping, reverse engineering and code generation** 
-  - Step3: view **Hibernate Console Configuration** created from Step2. Go to **window->show view->Hibernate Configurations**\\ {{:java:hibernate-console-configuration.jpg|}} 
-  - Step4: Create configuration for Hibernate code generator {{:java:hibernate_code_gen.png|}} 
-  - Step5: Config Main for Hibernate code generator 
-    * Check option **Reverse engineer from JDBC Connection** 
-    * And enter package name, for example: **vn.casino.entities**{{:java:hibernate-code-generator-main.jpg|}}  
-  - Step6: Config Export for **Hibernate code generator**: Check 2 options **Domain Code and Hibernate XML Mappings**: {{:java:hibernate-code-generator-exporter.jpg|}}Note: You add option **Hibernate XML Configuration** to generate **hibernate.cfg.xml** 
-  - Step7: Click **Run** to generate java code and Hibernate XML Mappings 
-==== Hibernate Foreign key Using XML mapping ==== 
-refer:  
-  * one-to-one: http://www.tutorialspoint.com/hibernate/hibernate_one_to_one_mapping.htm 
-  * one-to-many: http://www.tutorialspoint.com/hibernate/hibernate_one_to_many_mapping.htm 
-==== Hibernate log ==== 
-You need to config display log for package org.hibernate with log4j to check hibernate log<code ini> 
-# org.hibernate FileAppender 
-log4j.appender.hibernateAppender=org.apache.log4j.DailyRollingFileAppender 
-log4j.appender.hibernateAppender.layout=org.apache.log4j.PatternLayout 
-log4j.appender.hibernateAppender.File=logs/cardgameExt/hibernate.log 
-log4j.appender.hibernateAppender.layout.ConversionPattern=%d{dd MMM yyyy | HH:mm:ss,SSS} | %-5p | %t | %c{3} | %3x | %m%n 
-log4j.appender.hibernateAppender.Encoding=UTF-8 
-log4j.appender.hibernateAppender.DatePattern='.'yyyy-MM-dd 
-log4j.category.org.hibernate=INFO,consoleAppender,hibernateAppender 
 </code> </code>
 ===== Using external libraries for coding java with eclipse ===== ===== Using external libraries for coding java with eclipse =====
java/java.1658815732.txt.gz · Last modified: 2022/10/29 16:15 (external edit)