com.nimbusds.infinispan.persistence.sql.transformers.SQLServerNVarcharBinding Maven / Gradle / Ivy

Go to download
package com.nimbusds.infinispan.persistence.sql.transformers;


import java.sql.SQLException;
import java.sql.SQLFeatureNotSupportedException;
import java.sql.Types;

import org.jooq.*;
import org.jooq.conf.ParamType;
import org.jooq.impl.DSL;


/**
 * Microsoft SQL server NVARCHAR binding, prefixed 'N' to inline string values.
 *
 * Used https://github.com/jOOQ/jOOQ/issues/7825
 */
public class SQLServerNVarcharBinding implements Binding {
	
	
	@Override
	public Converter converter() {
		/*
		 * String-to-string converter for the data type values.
		 */
		return new Converter<>() {
			@Override
			public String from(final String databaseObject) {
				return databaseObject;
			}
			
			
			@Override
			public String to(final String userObject) {
				return userObject;
			}
			
			
			@Override
			public Class fromType() {
				return String.class;
			}
			
			
			@Override
			public Class toType() {
				return String.class;
			}
		};
	}
	
	
	@Override
	public void sql(final BindingSQLContext ctx) {
		if (ctx.render().paramType() == ParamType.INLINED) {
			// Prefix value with 'N' for UTF16
			// https://github.com/jOOQ/jOOQ/issues/9548
			ctx.render().sql((ctx.value() != null ? "N" : "")).visit(DSL.inline(ctx.value()));
		} else {
			ctx.render().sql("?");
		}
	}
	
	
	// Registering NVARCHAR types for JDBC CallableStatement OUT parameters
	@Override
	public void register(final BindingRegisterContext ctx) throws SQLException {
		ctx.statement().registerOutParameter(ctx.index(), Types.NVARCHAR);
	}
	
	
	// Converting the String value and setting that on a JDBC PreparedStatement
	@Override
	public void set(final BindingSetStatementContext ctx) throws SQLException {
		ctx.statement().setNString(ctx.index(), ctx.value());
	}
	
	
	// Getting a String value from a JDBC ResultSet and converting that to a JsonElement
	@Override
	public void get(final BindingGetResultSetContext ctx) throws SQLException {
		ctx.convert(converter()).value(ctx.resultSet().getNString(ctx.index()));
	}
	
	
	// Getting a String value from a JDBC CallableStatement
	@Override
	public void get(final BindingGetStatementContext ctx) throws SQLException {
		ctx.convert(converter()).value(ctx.statement().getNString(ctx.index()));
	}
	
	
	// Getting a value from a JDBC SQLInput (useful for Oracle OBJECT types)
	@Override
	public void get(final BindingGetSQLInputContext ctx) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}
	
	
	// Setting a value on a JDBC SQLOutput (useful for Oracle OBJECT types)
	@Override
	public void set(final BindingSetSQLOutputContext ctx) throws SQLException {
		throw new SQLFeatureNotSupportedException();
	}
}