Ok

En poursuivant votre navigation sur ce site, vous acceptez l'utilisation de cookies. Ces derniers assurent le bon fonctionnement de nos services. En savoir plus.

  • Spring MVC and Spring JDBC Transaction Tutorial

     

     

    https://o7planning.org/en/10311/spring-mvc-and-spring-jdbc-transaction-tutorial

  • Config Tomcat et config connecion oracle

    https://tomcat.apache.org/tomcat-7.0-doc/jndi-datasource-examples-howto.html

     

    https://confluence.atlassian.com/conf59/configuring-an-oracle-datasource-in-apache-tomcat-792499575.html

     

    https://docs.oracle.com/cd/F49540_01/DOC/java.815/a64685/basic1.htm

  • VAE

    Le git de Regis :

     

    https://github.com/regis1512/tutoriel-web-spring

    tuto de regis : https://rpouiller.developpez.com/tutoriels/spring/application-web-spring-hibernate/

     

    Tuto spring : du prof : http://jean-luc.massat.perso.luminy.univ-amu.fr/ens/vae-jee/tp-mvc.html

     

    jdbc du prof : http://jean-luc.massat.perso.luminy.univ-amu.fr/ens/vae-jee/jdbc.html

    ORacle Using JdbcRowSet Objects

    https://docs.oracle.com/javase/tutorial/jdbc/basics/jdbcrowset.html

     

    Spring ORM example – JPA, Hibernate, Transaction

    https://www.journaldev.com/7655/spring-orm-example-jpa-hibernate-transaction

    Object Relational Mapping (ORM) Data Access

    https://docs.spring.io/spring/docs/3.0.x/reference/orm.html

    Data access with JDBC

    https://docs.spring.io/spring/docs/3.0.x/spring-framework-reference/html/jdbc.html

     

    Configuring Apache Tomcat for Oracle manually

    https://www.ibm.com/support/knowledgecenter/en/SSHS8R_7.1.0/com.ibm.worklight.deploy.doc/admin/t_configuring_apache_tomcat_for_oracle_manually.html

     

  • Passer du SQL oracle au SQL ansi

    https://stackoverflow.com/questions/18891148/oracle-joins-comparison-between-conventional-syntax-vs-ansi-syntax#

     

     

    ┌───────────────────────────────────┬─────────────────────────────────────────────┐
     INNER JOIN - CONVENTIONAL          INNER JOIN - ANSI SYNTAX                    
    ├───────────────────────────────────┼─────────────────────────────────────────────┤
     SELECT                             SELECT                                      
          emp.deptno                          ename,                                
     FROM                                     dname,                                
          emp,                                emp.deptno,                           
          dept                                dept.deptno                           
     WHERE                              FROM                                        
          emp.deptno = dept.deptno;           scott.emp INNER JOIN scott.dept       
                                              ON emp.deptno = dept.deptno;          
    ├───────────────────────────────────┼─────────────────────────────────────────────┤
     LEFT OUTER JOIN - CONVENTIONAL     LEFT OUTER JOIN - ANSI SYNTAX               
    ├───────────────────────────────────┼─────────────────────────────────────────────┤
     SELECT                             SELECT                                      
          emp.deptno                         ename,                                 
     FROM                                    dname,                                 
          emp,                               emp.deptno,                            
          dept                               dept.deptno                            
     WHERE                              FROM                                        
          emp.deptno = dept.deptno(+);       scott.emp LEFT OUTER JOIN scott.dept   
                                             ON emp.deptno = dept.deptno;           
    ├───────────────────────────────────┼─────────────────────────────────────────────┤
     RIGHT OUTER JOIN - CONVENTIONAL    RIGHT OUTER JOIN - ANSI SYNTAX              
    ├───────────────────────────────────┼─────────────────────────────────────────────┤
     SELECT                             SELECT                                      
          emp.deptno                         ename,                                 
     FROM                                    dname,                                 
          emp,                               emp.deptno,                            
          dept                               dept.deptno                            
     WHERE                              FROM                                        
          emp.deptno(+) = dept.deptno;       scott.emp RIGHT OUTER JOIN scott.dept  
                                             ON emp.deptno = dept.deptno;           
    ├───────────────────────────────────┼─────────────────────────────────────────────┤
     FULL OUTER JOIN - CONVENTIONAL     FULL OUTER JOIN - ANSI SYNTAX               
    ├───────────────────────────────────┼─────────────────────────────────────────────┤
     SELECT                             SELECT                                      
          *                                  *                                      
     FROM                               FROM                                        
          emp,                               scott.emp FULL OUTER JOIN scott.dept   
          dept                               ON emp.deptno = dept.deptno;           
     WHERE                                                                          
          emp.deptno = dept.deptno(+)                                               
     UNION ALL                                                                      
     SELECT                                                                         
          *                                                                         
     FROM                                                                           
          emp,                                                                      
          dept                                                                      
     WHERE                                                                          
          emp.deptno(+) = dept.deptno                                               
          AND emp.deptno IS NULL;                                                   
    └───────────────────────────────────┴─────────────────────────────────────────────┘