Java and databases, mainframes

• JDBC
• JDO
• EJB

JDBC

• Drivers
• NetDirect
• MM-MySQL
• Trax
• Tutorial using JDBC and transactions
• An introduction to transactions

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

• JDO
• JDOCentral
• TJDO (SourceForge Open Source implementation)
• Libelis
• Exadel
• JDO review
• IBM Tutorial
• O'Reilly JDO
• Versant JDO

Others (Object to relational mapping)

• Castor
• Cocobase
• Toplink
• Jaxor
• Serializing Objects (Martin Fowler)
• Middlegen : generates EJB
• GalaXI
• Infobjects Objectdriver
• Sofia
• Judoscript : scripting JDBC in Java

• Transactions

• Transactions in MySQL
• Introduction to transactions
• Access CICS applications with Spring
• Blg Templier
• Transactions in Geronimo

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