hibernate-commits

[<one...@us...>]

Update of /cvsroot/hibernate/Hibernate2/src/net/sf/hibernate/dialect
In directory sc8-pr-cvs1:/tmp/cvs-serv30705/src/net/sf/hibernate/dialect

Added Files:
	Oracle9Dialect.java 
Log Message:
applied decode support patch by Simon Harris

--- NEW FILE: Oracle9Dialect.java ---
//$Id: Oracle9Dialect.java,v 1.1 2003/02/01 12:24:06 oneovthafew Exp $
package net.sf.hibernate.dialect;

import java.sql.Types;

import net.sf.hibernate.cfg.Environment;

/**
 * An SQL dialect for Oracle 9 (uses ANSI-style syntax where possible).
 */
public class Oracle9Dialect extends Dialect {
	
	public Oracle9Dialect() {
		super();
		register( Types.BIT, "NUMBER(1,0)" );
		register( Types.BIGINT, "NUMBER(19,0)" );
		register( Types.SMALLINT, "NUMBER(5,0)" );
		register( Types.TINYINT, "NUMBER(3,0)" );
		register( Types.INTEGER, "NUMBER(10,0)" );
		register( Types.CHAR, "CHAR(1)" );
		register( Types.VARCHAR, "VARCHAR2($l)" );
		register( Types.FLOAT, "FLOAT" );
		register( Types.DOUBLE, "DOUBLE PRECISION" );
		register( Types.DATE, "DATE" );
		register( Types.TIME, "DATE" );
		register( Types.TIMESTAMP, "DATE" );
		register( Types.VARBINARY, "RAW($l)" );
		register( Types.NUMERIC, "NUMBER(19, $l)" );
		register( Types.BLOB, "BLOB" );
		register( Types.CLOB, "CLOB" );
		
		getDefaultProperties().setProperty(Environment.USE_STREAMS_FOR_BINARY, "true");
		getDefaultProperties().setProperty(Environment.STATEMENT_BATCH_SIZE, DEFAULT_BATCH_SIZE);
		getDefaultProperties().setProperty(Environment.OUTER_JOIN, "true");
	}
	
	public String getAddColumnString() {
		return "add";
	}
	
	public String getSequenceNextValString(String sequenceName) {
		return  "select " + sequenceName + ".nextval from dual";
	}
	public String getCreateSequenceString(String sequenceName) {
		return "create sequence " + sequenceName;
	}
	public String getDropSequenceString(String sequenceName) {
		return "drop sequence " + sequenceName;
	}
	
	public String getCascadeConstraintsString() {
		return " cascade constraints";
	}
	
	public boolean supportsForUpdateNowait() {
		return true;
	}
	
	public boolean supportsSequences() {
		return true;
	}

}