/** * Constructs a DerbyDialect */ @SuppressWarnings("deprecation") public DerbyDialect() { super(); if ( this.getClass() == DerbyDialect.class ) { LOG.deprecatedDerbyDialect(); } registerFunction( "concat", new DerbyConcatFunction() ); registerFunction( "trim", new AnsiTrimFunction() ); registerColumnType( Types.BLOB, "blob" ); registerDerbyKeywords(); determineDriverVersion(); if ( driverVersionMajor > 10 || ( driverVersionMajor == 10 && driverVersionMinor >= 7 ) ) { registerColumnType( Types.BOOLEAN, "boolean" ); } this.limitHandler = new DerbyLimitHandler(); }
@Override public Dialect resolveDialect(DialectResolutionInfo info) { final String databaseName = info.getDatabaseName(); if ( "Apache Derby".equals( databaseName ) ) { final int majorVersion = info.getDatabaseMajorVersion(); final int minorVersion = info.getDatabaseMinorVersion(); if ( majorVersion > 10 || ( majorVersion == 10 && minorVersion >= 7 ) ) { return latestDialectInstance( this ); } else if ( majorVersion == 10 && minorVersion == 6 ) { return new DerbyTenSixDialect(); } else if ( majorVersion == 10 && minorVersion == 5 ) { return new DerbyTenFiveDialect(); } else { return new DerbyDialect(); } } return null; } },
final int forUpdateIndex = normalizedSelect.lastIndexOf( "for update") ; if ( hasForUpdateClause( forUpdateIndex ) ) { sb.append( query.substring( 0, forUpdateIndex-1 ) ); else if ( hasWithClause( normalizedSelect ) ) { sb.append( query.substring( 0, getWithIndex( query ) - 1 ) ); if ( hasForUpdateClause( forUpdateIndex ) ) { sb.append( ' ' ); sb.append( query.substring( forUpdateIndex ) ); else if ( hasWithClause( normalizedSelect ) ) { sb.append( ' ' ).append( query.substring( getWithIndex( query ) ) );
@Override public IdentifierHelper buildIdentifierHelper( IdentifierHelperBuilder builder, DatabaseMetaData dbMetaData) throws SQLException { builder.applyIdentifierCasing( dbMetaData ); builder.applyReservedWords( dbMetaData ); builder.applyReservedWords( getKeywords() ); builder.setNameQualifierSupport( getNameQualifierSupport() ); return builder.build(); }
public DerbyDialect() { super(); LOG.deprecatedDerbyDialect(); registerFunction( "concat", new DerbyConcatFunction() ); registerFunction( "trim", new AnsiTrimFunction() ); registerColumnType( Types.BLOB, "blob" ); determineDriverVersion(); if ( driverVersionMajor > 10 || ( driverVersionMajor == 10 && driverVersionMinor >= 7 ) ) { registerColumnType( Types.BOOLEAN, "boolean" ); } }
@Override @SuppressWarnings("deprecation") public boolean supportsLimitOffset() { return isTenPointFiveReleaseOrNewer(); }
/** * Constructs a DerbyDialect */ @SuppressWarnings("deprecation") public DerbyDialect() { super(); if ( this.getClass() == DerbyDialect.class ) { LOG.deprecatedDerbyDialect(); } registerColumnType( Types.BLOB, "blob" ); registerDerbyKeywords(); determineDriverVersion(); if ( driverVersionMajor > 10 || ( driverVersionMajor == 10 && driverVersionMinor >= 7 ) ) { registerColumnType( Types.BOOLEAN, "boolean" ); } this.limitHandler = new DerbyLimitHandler(); }
@Override public String getQuerySequencesString() { if ( supportsSequences() ) { return "select sys.sysschemas.schemaname as sequence_schema, sys.syssequences.* from sys.syssequences left join sys.sysschemas on sys.syssequences.schemaid = sys.sysschemas.schemaid"; } else { return null; } }
public DerbyDialect() { super(); registerFunction( "concat", new VarArgsSQLFunction( Hibernate.STRING, "(","||",")" ) ); registerFunction( "trim", new DerbyTrimFunctionEmulation() ); }
public DerbyDialect() { super(); LOG.deprecatedDerbyDialect(); registerFunction( "concat", new DerbyConcatFunction() ); registerFunction( "trim", new AnsiTrimFunction() ); registerColumnType( Types.BLOB, "blob" ); determineDriverVersion(); if ( driverVersionMajor > 10 || ( driverVersionMajor == 10 && driverVersionMinor >= 7 ) ) { registerColumnType( Types.BOOLEAN, "boolean" ); } }
@Override public boolean supportsLimit() { return isTenPointFiveReleaseOrNewer(); }
@Override public String getSequenceNextValString(String sequenceName) { if ( supportsSequences() ) { return "values next value for " + sequenceName; } else { throw new MappingException( "Derby does not support sequence prior to release 10.6.1.0" ); } }
public DerbyDialect() { super(); registerFunction( "concat", new VarArgsSQLFunction( Hibernate.STRING, "(","||",")" ) ); }
@Override public IdentifierHelper buildIdentifierHelper( IdentifierHelperBuilder builder, DatabaseMetaData dbMetaData) throws SQLException { builder.applyIdentifierCasing( dbMetaData ); builder.applyReservedWords( dbMetaData ); builder.applyReservedWords( getKeywords() ); builder.setNameQualifierSupport( getNameQualifierSupport() ); return builder.build(); }
final int forUpdateIndex = normalizedSelect.lastIndexOf( "for update") ; if ( hasForUpdateClause( forUpdateIndex ) ) { sb.append( query.substring( 0, forUpdateIndex-1 ) ); else if ( hasWithClause( normalizedSelect ) ) { sb.append( query.substring( 0, getWithIndex( query ) - 1 ) ); if ( hasForUpdateClause( forUpdateIndex ) ) { sb.append( ' ' ); sb.append( query.substring( forUpdateIndex ) ); else if ( hasWithClause( normalizedSelect ) ) { sb.append( ' ' ).append( query.substring( getWithIndex( query ) ) );
@Override @SuppressWarnings("deprecation") public boolean supportsLimitOffset() { return isTenPointFiveReleaseOrNewer(); }
@Override public String getQuerySequencesString() { if ( supportsSequences() ) { return "select sys.sysschemas.schemaname as sequence_schema, sys.syssequences.* from sys.syssequences left join sys.sysschemas on sys.syssequences.schemaid = sys.sysschemas.schemaid"; } else { return null; } }
@Override public Dialect resolveDialect(DialectResolutionInfo info) { final String databaseName = info.getDatabaseName(); if ( "Apache Derby".equals( databaseName ) ) { final int majorVersion = info.getDatabaseMajorVersion(); final int minorVersion = info.getDatabaseMinorVersion(); if ( majorVersion > 10 || ( majorVersion == 10 && minorVersion >= 7 ) ) { return latestDialectInstance( this ); } else if ( majorVersion == 10 && minorVersion == 6 ) { return new DerbyTenSixDialect(); } else if ( majorVersion == 10 && minorVersion == 5 ) { return new DerbyTenFiveDialect(); } else { return new DerbyDialect(); } } return null; } },
final int forUpdateIndex = normalizedSelect.lastIndexOf( "for update") ; if ( hasForUpdateClause( forUpdateIndex ) ) { sb.append( query.substring( 0, forUpdateIndex-1 ) ); else if ( hasWithClause( normalizedSelect ) ) { sb.append( query.substring( 0, getWithIndex( query ) - 1 ) ); if ( hasForUpdateClause( forUpdateIndex ) ) { sb.append(' '); sb.append( query.substring( forUpdateIndex ) ); else if ( hasWithClause( normalizedSelect ) ) { sb.append( ' ' ).append( query.substring( getWithIndex( query ) ) );
@Override public boolean supportsLimit() { return isTenPointFiveReleaseOrNewer(); }