Skip to content
Create a gist now

Instantly share code, notes, and snippets.

Oracle XML Type Test
using System;
using System.Data;
using System.Reflection;
using NHibernate;
using NHibernate.AdoNet;
using NHibernate.Driver;
using NHibernate.Engine.Query;
using NHibernate.SqlTypes;
using NHibernate.Util;
using Oracle.DataAccess.Client;
namespace OracleXmlTypeTest {
/// <summary>
/// A NHibernate Driver for using the Oracle.DataAccess DataProvider
/// </summary>
/// <remarks>
/// Code was contributed by <a href="">James Mills</a> on the NHibernate forums in this <a
/// href="">post</a> .
/// </remarks>
public class CustomOracleDataClientDriver : ReflectionBasedDriver, IEmbeddedBatcherFactoryProvider {
private const string DriverAssemblyName = "Oracle.DataAccess";
private const string ConnectionTypeName = "Oracle.DataAccess.Client.OracleConnection";
private const string CommandTypeName = "Oracle.DataAccess.Client.OracleCommand";
private static readonly SqlType GuidSqlType = new SqlType(DbType.Binary, 16);
private readonly PropertyInfo oracleDbType;
private readonly object oracleDbTypeRefCursor;
private readonly object oracleDbTypeXmlType;
/// <summary>
/// Initializes a new instance of <see cref="OracleDataClientDriver" /> .
/// </summary>
/// <exception cref="HibernateException">Thrown when the
/// <c>Oracle.DataAccess</c>
/// assembly can not be loaded.</exception>
public CustomOracleDataClientDriver()
: base(
CommandTypeName) {
var parameterType = ReflectHelper.TypeFromAssembly("Oracle.DataAccess.Client.OracleParameter",
DriverAssemblyName, false);
this.oracleDbType = parameterType.GetProperty("OracleDbType");
var oracleDbTypeEnum = ReflectHelper.TypeFromAssembly("Oracle.DataAccess.Client.OracleDbType",
DriverAssemblyName, false);
this.oracleDbTypeRefCursor = Enum.Parse(oracleDbTypeEnum, "RefCursor");
this.oracleDbTypeXmlType = Enum.Parse(oracleDbTypeEnum, "XmlType");
/// <summary>
/// </summary>
public override bool UseNamedPrefixInSql {
get { return true; }
/// <summary>
/// </summary>
public override bool UseNamedPrefixInParameter {
get { return true; }
/// <summary>
/// </summary>
public override string NamedPrefix {
get { return ":"; }
#region IEmbeddedBatcherFactoryProvider Members
Type IEmbeddedBatcherFactoryProvider.BatcherFactoryClass {
get { return typeof (OracleDataClientBatchingBatcherFactory); }
/// <remarks>
/// This adds logic to ensure that a DbType.Boolean parameter is not created since ODP.NET doesn't support it.
/// </remarks>
protected override void InitializeParameter(IDbDataParameter dbParam, string name, SqlType sqlType) {
// if the parameter coming in contains a boolean then we need to convert it
// to another type since ODP.NET doesn't support DbType.Boolean
switch (sqlType.DbType) {
case DbType.Boolean:
base.InitializeParameter(dbParam, name, SqlTypeFactory.Int16);
case DbType.Guid:
base.InitializeParameter(dbParam, name, GuidSqlType);
case DbType.Xml:
dbParam.ParameterName = this.FormatNameForParameter(name);
this.oracleDbType.SetValue(dbParam, this.oracleDbTypeXmlType, null);
base.InitializeParameter(dbParam, name, sqlType);
protected override void OnBeforePrepare(IDbCommand command) {
((OracleCommand) command).BindByName = true;
var detail = CallableParser.Parse(command.CommandText);
if (!detail.IsCallable)
command.CommandType = CommandType.StoredProcedure;
command.CommandText = detail.FunctionName;
var outCursor = command.CreateParameter();
this.oracleDbType.SetValue(outCursor, this.oracleDbTypeRefCursor, null);
outCursor.Direction = detail.HasReturn ? ParameterDirection.ReturnValue : ParameterDirection.Output;
command.Parameters.Insert(0, outCursor);
<?xml version="1.0"?>
<class name="EntityWithXml" table="XML_TEST">
<id name="Id">
<generator class="assigned" />
<property name="XmlProperty">
<column name="XML_COLUMN" sql-type="xmltype" />
<?xml version="1.0" encoding="utf-8"?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2" >
<session-factory name="NHibernate.Test">
<property name="connection.driver_class">OracleXmlTypeTest.CustomOracleDataClientDriver, OracleXmlTypeTest</property>
<property name="connection.connection_string">
<property name="show_sql">false</property>
<property name="">create</property>
<property name="dialect">NHibernate.Dialect.Oracle10gDialect</property>
<property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
using System.Xml.Linq;
namespace OracleXmlTypeTest {
public class EntityWithXml {
public virtual int Id { get; set; }
public virtual XDocument XmlProperty { get; set; }
using System;
using System.Xml.Linq;
using NHibernate.Cfg;
using NHibernate.Linq;
namespace OracleXmlTypeTest {
internal class Program {
private static void Main(string[] args) {
var config = new Configuration();
config.AddAssembly(typeof (Program).Assembly);
var sf = config.BuildSessionFactory();
using (var session = sf.OpenSession()) {
session.SaveOrUpdate(new EntityWithXml {Id = 1, XmlProperty = new XDocument(new XElement("Test", "OK"))});
using (var session = sf.OpenSession())
foreach (var entity in session.Query<EntityWithXml>())
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.