com.github.t9t.jooq.json

Class JsonStringBinding

java.lang.Object

com.github.t9t.jooq.json.JsonStringBinding

All Implemented Interfaces:

Serializable, org.jooq.Binding<Object,String>

public class JsonStringBinding
extends Object
implements org.jooq.Binding<Object,String>

jOOQ Binding to use json fields as String. When selecting fields, the data is returned as String. When inputting data (eg. on insert and update), the data is sent as text to the server, and converted to json there (by adding ::json to the placeholder).

To use this with the jOOQ code generator, use configuration like this:

 <forcedTypes>
     <forcedType>
         <userType>java.lang.String</userType>
         <binding>JsonStringBinding</binding>
         <types>json|jsonb</types>
     </forcedType>
 </forcedTypes>
 

See Also:

JsonbStringBinding, Serialized Form

Constructor Summary

Constructors

Constructor and Description
JsonStringBinding()

Method Summary

Modifier and Type	Method and Description
org.jooq.Converter<Object,String>	converter()
void	get(org.jooq.BindingGetResultSetContext<String> ctx)
void	get(org.jooq.BindingGetSQLInputContext<String> ctx)
void	get(org.jooq.BindingGetStatementContext<String> ctx)
void	register(org.jooq.BindingRegisterContext<String> ctx)
void	set(org.jooq.BindingSetSQLOutputContext<String> ctx)
void	set(org.jooq.BindingSetStatementContext<String> ctx)
void	sql(org.jooq.BindingSQLContext<String> ctx)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface org.jooq.Binding

of, of, of

Constructor Detail

JsonStringBinding

public JsonStringBinding()

Method Detail

converter

public org.jooq.Converter<Object,String> converter()

Specified by:

converter in interface org.jooq.Binding<Object,String>

sql

public void sql(org.jooq.BindingSQLContext<String> ctx)

Specified by:

sql in interface org.jooq.Binding<Object,String>

register

public void register(org.jooq.BindingRegisterContext<String> ctx)
              throws SQLException

Specified by:

register in interface org.jooq.Binding<Object,String>

Throws:

SQLException

set

public void set(org.jooq.BindingSetStatementContext<String> ctx)
         throws SQLException

Specified by:

set in interface org.jooq.Binding<Object,String>

Throws:

SQLException

get

public void get(org.jooq.BindingGetResultSetContext<String> ctx)
         throws SQLException

Specified by:

get in interface org.jooq.Binding<Object,String>

Throws:

SQLException

get

public void get(org.jooq.BindingGetStatementContext<String> ctx)
         throws SQLException

Specified by:

get in interface org.jooq.Binding<Object,String>

Throws:

SQLException

set

public void set(org.jooq.BindingSetSQLOutputContext<String> ctx)
         throws SQLException

Specified by:

set in interface org.jooq.Binding<Object,String>

Throws:

SQLException

get

public void get(org.jooq.BindingGetSQLInputContext<String> ctx)
         throws SQLException

Specified by:

get in interface org.jooq.Binding<Object,String>

Throws:

SQLException