Techie Tortoise

Torque - idMethod

2005-05-26T16:48:00.000+08:00

A lot of people overlook this important attribute "idMethod" in the "table" tag of the torque schema file. This determines whether you are using the native database generated sequential key.For instance, in MySQL,(1) if you want your primary key to be auto-incremented by the DB, you should set the idMethod to be "native";(2) If you want to define your own primary key, you should set it to "none"

Hibernate - ID unsaved-value

2004-02-29T02:21:00.000+08:00

Another lesson learnt. If the java type of your primary key "id" is of a primitive type int, long, double, etc, the "unsaved-value" attribute must be filled with a value. For instance, if you declare your primary key in your model class as "private int key;", then your unsaved-value should be 0. If you declare your primary key as "private int key = -1;", then your unsaved-value should be -1;

JavaWorld - No more updated articles

2004-02-26T15:57:00.000+08:00

JavaWorld has announced that there will be no more updated articles. I am hoping that it is just a temporarily move.

Hibernate 2.1 - ehcache library required!

2004-02-18T22:05:00.000+08:00

Topic: DB Object Mapping I just downloaded Hibernate 2.1.2 and was trying out the tutorial in the reference pdf file. As instructed, I copied the following to my webapp lib directory: cglib-2.0-rc2.jar, commons-collections-2.1.jar, commons-dbcp-1.1.jar, commons-lang-1.0.1.jar, commons-logging-1.0.3.jar, commons-pool-1.1.jar, dom4j-1.4.jar, hibernate2.jar, log4j-1.2.8.jar, odmg-3.0.jar. I must

Comparison among various DB Object Mapping Tools

2004-02-13T13:07:00.000+08:00

Topic: DB Object Mapping Found this site where someone makes some comparison on the various Object mapping tools.

Another Object Mapping tools - iBATIS

2004-02-13T11:43:00.000+08:00

Topic: DB Object Mapping Came across another object-mapping tool called iBATIS. This tool is abit different as it maps JavaBeans to SQL statement instead of the table schemas. For instance, select ADR_ID as id, ADR_DESCRIPTION as description, ADR_STREET as

Introduction to Hibernate

2004-01-26T17:40:00.000+08:00

Topic: DB Object Mapping Here's a good introduction article to Hibernate based on version 2.0.3. I was trying to do some comparison between Torque, Hibernate and OJB. However, later I realise that Torque is out of the comparison as it is something different from the rest. It is more like another persistence layer between the database and the other two. I will write more on this topic when I

VARCHAR and VARCHAR BINARY

2004-01-16T18:07:00.000+08:00

Topic: MySQL Usually for String data, we would use VARCHAR data type. However, in my MySQL, do take note that if we use VARCHAR, the data stored would be case-insensitive. For case-sensitivity, you have to use VARCHAR BINARY. For instance, if you have the following table schema: CREATE TABLE MEMBER ( LOGIN_T VARCHAR(20) PRIMARY KEY, PWD_T VARCHAR(20) ); and the following records: abc|

InnoDB Table Types

2004-01-16T17:34:00.000+08:00

Topic: MySQL Major Benefits (over ISAM and MyISAM): * transaction-safe * increase multi-user concurrency and performance * supports Foreign key constraints * supports auto-extending tablespace Foreign Key Constraints: Some points to take note while creating foreign key constraints * Both tables must be InnoDB type * Corresponding columns must have the same datatype.

JDBC Connection - Transaction Types

2004-01-13T10:46:00.000+08:00

Topic: JDBC Here's an interesting and easy-to-understand article that talks about the different transaction types of a connection. It also explains terms like "Dirty Read", "Phantom Reads" and "Non-Repeatable Reads".

2004-01-09T17:22:00.000+08:00

Here's an article on ANT's best practices.

2004-01-09T17:20:00.000+08:00

I have decided to use this blog to keep track of some of the interesting technical articles and resources that I have read on the web. The articles that I "recommend" are usually quite simple to read and easy to learn as I am not very advanced with programming technologies. Technologies that I have used in my recent project includes: TorqueStrutsLOG4J