Module org.jooq

Package org.jooq

Interface SignalSetStep

All Superinterfaces:

QueryPart, Serializable, Statement

@Pro
public interface SignalSetStep
extends Statement

A step in the construction of the SIGNAL SQL STATE function.

Referencing XYZ*Step types directly from client code

It is usually not recommended to reference any XYZ*Step types directly from client code, or assign them to local variables. When writing dynamic SQL, creating a statement's components dynamically, and passing them to the DSL API statically is usually a better choice. See the manual's section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.

Drawbacks of referencing the XYZ*Step types directly:

• They're operating on mutable implementations (as of jOOQ 3.x)
• They're less composable and not easy to get right when dynamic SQL gets complex
• They're less readable
• They might have binary incompatible changes between minor releases

Method Summary

Modifier and Type	Method	Description
@NotNull Statement	setMessageText(String messageText)	Add the SET MESSAGE TEXT clause to the SIGNAL SQL STATE function.
@NotNull Statement	setMessageText(Field<String> messageText)	Add the SET MESSAGE TEXT clause to the SIGNAL SQL STATE function.

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Method Details

setMessageText

@Support({DB2,HANA,HSQLDB,MARIADB,MYSQL,POSTGRES})
@NotNull
@CheckReturnValue
@NotNull Statement setMessageText(@Param
 String messageText)

Add the SET MESSAGE TEXT clause to the SIGNAL SQL STATE function.

Parameters:

messageText - is wrapped as DSL.val(Object).

setMessageText

@Support({DB2,HANA,HSQLDB,MARIADB,MYSQL,POSTGRES})
@NotNull
@CheckReturnValue
@NotNull Statement setMessageText(Field<String> messageText)

Add the SET MESSAGE TEXT clause to the SIGNAL SQL STATE function.