Java and databases, mainframes

JDBC

JDO vs Hibernate blog

JDO

JDO is a well-defined standard, although it is still an emerging technology. It's ease of use, support for complex relationships, and it's transactional abilities are some of it's advantages. JDO requires less code than entity beans, since there is no need for home and remote interfaces. What JDO does require is metadata and post-author-processing. JDOs can be developed using plain old java objects, independent from a container. Using byte-code instrumentation, the compiled byte code of your Java objects is 'enhanced' using a JDO vendor-supplied tool

Others (Object to relational mapping)

Databases and UML Modeling

Agile databases

Relational Databases

DB2 Express

MySQL

SQL

SQL in French

MySQL

Importing CSV into a table

LOAD DATA LOCAL INFILE "/user/tmp/votrefichier.csv" INTO TABLE base.table
FIELDS TERMINATED BY " ;" LINES TERMINATED BY "\r"
(colonne1,colonne2,colonne3,colonne4,colonne5,colonne6,colonne7,colonne8,col
onne9,colonne10) ;

Restoring a base :

mysql -u gilles -p MaBaseLocale < /home/mon_utilisateur/Documents/mabase.sql

© Copyright AFC Europe 1998-2014