Tabnine Logo
MySQLDialect
Code IndexAdd Tabnine to your IDE (free)

How to use
MySQLDialect
in
org.hibernate.dialect

Best Java code snippets using org.hibernate.dialect.MySQLDialect (Showing top 20 results out of 315)

origin: hibernate/hibernate-orm

  this.storageEngine = getDefaultMySQLStorageEngine();
registerColumnType( Types.BIT, "bit" );
registerColumnType( Types.BIGINT, "bigint" );
registerColumnType( Types.SMALLINT, "smallint" );
registerColumnType( Types.TINYINT, "tinyint" );
registerColumnType( Types.INTEGER, "integer" );
registerColumnType( Types.CHAR, "char(1)" );
registerColumnType( Types.FLOAT, "float" );
registerColumnType( Types.DOUBLE, "double precision" );
registerColumnType( Types.BOOLEAN, "bit" ); // HHH-6935
registerColumnType( Types.DATE, "date" );
registerColumnType( Types.TIME, "time" );
registerColumnType( Types.TIMESTAMP, "datetime" );
registerColumnType( Types.VARBINARY, "longblob" );
registerColumnType( Types.VARBINARY, 16777215, "mediumblob" );
registerColumnType( Types.VARBINARY, 65535, "blob" );
registerColumnType( Types.VARBINARY, 255, "tinyblob" );
registerColumnType( Types.BINARY, "binary($l)" );
registerColumnType( Types.LONGVARBINARY, "longblob" );
registerColumnType( Types.LONGVARBINARY, 16777215, "mediumblob" );
registerColumnType( Types.NUMERIC, "decimal($p,$s)" );
registerColumnType( Types.BLOB, "longblob" );
registerColumnType( Types.CLOB, "longtext" );
registerColumnType( Types.NCLOB, "longtext" );
registerVarcharTypes();
origin: hibernate/hibernate-orm

@Override
public String getCastTypeName(int code) {
  switch ( code ) {
    case Types.BOOLEAN:
      return "char";
    case Types.INTEGER:
    case Types.BIGINT:
    case Types.SMALLINT:
      return smallIntegerCastTarget();
    case Types.FLOAT:
    case Types.REAL: {
      return floatingPointNumberCastTarget();
    }
    case Types.NUMERIC:
      return fixedPointNumberCastTarget();
    case Types.VARCHAR:
      return "char";
    case Types.VARBINARY:
      return "binary";
    default:
      return super.getCastTypeName( code );
  }
}
origin: hibernate/hibernate-orm

@Override
public String getTableTypeString() {
  return storageEngine.getTableTypeString( getEngineKeyword());
}
origin: hibernate/hibernate

public MySQLDialect() {
  super();
  registerColumnType( Types.BIT, "bit" );
  registerColumnType( Types.BIGINT, "bigint" );
  registerColumnType( Types.SMALLINT, "smallint" );
  registerColumnType( Types.TINYINT, "tinyint" );
  registerColumnType( Types.INTEGER, "integer" );
  registerColumnType( Types.CHAR, "char(1)" );
  registerColumnType( Types.VARCHAR, "longtext" );
  registerColumnType( Types.VARCHAR, 16777215, "mediumtext" );
  registerColumnType( Types.VARCHAR, 65535, "text" );
  registerColumnType( Types.VARCHAR, 255, "varchar($l)" );
  registerColumnType( Types.FLOAT, "float" );
  registerColumnType( Types.DOUBLE, "double precision" );
  registerColumnType( Types.DATE, "date" );
  registerColumnType( Types.TIME, "time" );
  registerColumnType( Types.TIMESTAMP, "datetime" );
  registerColumnType( Types.VARBINARY, "longblob" );
  registerColumnType( Types.VARBINARY, 16777215, "mediumblob" );
  registerColumnType( Types.VARBINARY, 65535, "blob" );
  registerColumnType( Types.VARBINARY, 255, "tinyblob" );
  registerColumnType( Types.NUMERIC, "numeric($p,$s)" );
  registerColumnType( Types.BLOB, "longblob" );
  registerColumnType( Types.BLOB, 16777215, "mediumblob" );
  registerColumnType( Types.BLOB, 65535, "blob" );
  registerColumnType( Types.CLOB, "longtext" );
  registerColumnType( Types.CLOB, 16777215, "mediumtext" );
  registerColumnType( Types.CLOB, 65535, "text" );
  registerFunction("ascii", new StandardSQLFunction("ascii", Hibernate.INTEGER) );
origin: hibernate/hibernate-orm

  @Override
  public Dialect resolveDialect(DialectResolutionInfo info) {
    final String databaseName = info.getDatabaseName();
    if ( "MySQL".equals( databaseName ) ) {
      final int majorVersion = info.getDatabaseMajorVersion();
      final int minorVersion = info.getDatabaseMinorVersion();
      if ( majorVersion < 5 ) {
        return new MySQLDialect();
      }
      else if ( majorVersion == 5 ) {
        if ( minorVersion < 5 ) {
          return new MySQL5Dialect();
        }
        else if ( minorVersion < 7 ) {
          return new MySQL55Dialect();
        }
        else {
          return new MySQL57Dialect();
        }
      }
      return latestDialectInstance( this );
    }
    return null;
  }
},
origin: hibernate/hibernate-orm

  protected void registerVarcharTypes() {
    registerColumnType( Types.VARCHAR, "longtext" );
//        registerColumnType( Types.VARCHAR, 16777215, "mediumtext" );
//        registerColumnType( Types.VARCHAR, 65535, "text" );
    registerColumnType( Types.VARCHAR, 255, "varchar($l)" );
    registerColumnType( Types.LONGVARCHAR, "longtext" );
  }

origin: hibernate/hibernate-orm

/**
 * Determine the cast target for {@link Types#FLOAT} and {@link Types#REAL} (DOUBLE)
 *
 * @return The proper cast target type.
 */
protected String floatingPointNumberCastTarget() {
  // MySQL does not allow casting to DOUBLE nor FLOAT, so we have to cast these as DECIMAL.
  // MariaDB does allow casting to DOUBLE, although not FLOAT.
  return fixedPointNumberCastTarget();
}
origin: com.manydesigns/portofino-mysql

public MySql5DatabasePlatform() {
  super(new MySQLDialect(), "jdbc:mysql://<host>[:<port>][/<database>]");
}
origin: org.hibernate.orm/hibernate-core

  protected void registerVarcharTypes() {
    registerColumnType( Types.VARCHAR, "longtext" );
//        registerColumnType( Types.VARCHAR, 16777215, "mediumtext" );
//        registerColumnType( Types.VARCHAR, 65535, "text" );
    registerColumnType( Types.VARCHAR, 255, "varchar($l)" );
    registerColumnType( Types.LONGVARCHAR, "longtext" );
  }

origin: org.hibernate.orm/hibernate-core

/**
 * Determine the cast target for {@link Types#FLOAT} and {@link Types#REAL} (DOUBLE)
 *
 * @return The proper cast target type.
 */
protected String floatingPointNumberCastTarget() {
  // MySQL does not allow casting to DOUBLE nor FLOAT, so we have to cast these as DECIMAL.
  // MariaDB does allow casting to DOUBLE, although not FLOAT.
  return fixedPointNumberCastTarget();
}
origin: org.hibernate.orm/hibernate-core

  this.storageEngine = getDefaultMySQLStorageEngine();
registerColumnType( Types.BIT, "bit" );
registerColumnType( Types.BIGINT, "bigint" );
registerColumnType( Types.SMALLINT, "smallint" );
registerColumnType( Types.TINYINT, "tinyint" );
registerColumnType( Types.INTEGER, "integer" );
registerColumnType( Types.CHAR, "char(1)" );
registerColumnType( Types.FLOAT, "float" );
registerColumnType( Types.DOUBLE, "double precision" );
registerColumnType( Types.BOOLEAN, "bit" ); // HHH-6935
registerColumnType( Types.DATE, "date" );
registerColumnType( Types.TIME, "time" );
registerColumnType( Types.TIMESTAMP, "datetime" );
registerColumnType( Types.VARBINARY, "longblob" );
registerColumnType( Types.VARBINARY, 16777215, "mediumblob" );
registerColumnType( Types.VARBINARY, 65535, "blob" );
registerColumnType( Types.VARBINARY, 255, "tinyblob" );
registerColumnType( Types.BINARY, "binary($l)" );
registerColumnType( Types.LONGVARBINARY, "longblob" );
registerColumnType( Types.LONGVARBINARY, 16777215, "mediumblob" );
registerColumnType( Types.NUMERIC, "decimal($p,$s)" );
registerColumnType( Types.BLOB, "longblob" );
registerColumnType( Types.CLOB, "longtext" );
registerColumnType( Types.NCLOB, "longtext" );
registerVarcharTypes();
origin: ManyDesigns/Portofino

public MySql5DatabasePlatform() {
  super(new MySQLDialect(), "jdbc:mysql://<host>[:<port>][/<database>]");
}
origin: org.hibernate/com.springsource.org.hibernate.core

  protected void registerVarcharTypes() {
    registerColumnType( Types.VARCHAR, "longtext" );
//        registerColumnType( Types.VARCHAR, 16777215, "mediumtext" );
//        registerColumnType( Types.VARCHAR, 65535, "text" );
    registerColumnType( Types.VARCHAR, 255, "varchar($l)" );
    registerColumnType( Types.LONGVARCHAR, "longtext" );
  }

origin: org.hibernate.orm/hibernate-core

@Override
public String getCastTypeName(int code) {
  switch ( code ) {
    case Types.BOOLEAN:
      return "char";
    case Types.INTEGER:
    case Types.BIGINT:
    case Types.SMALLINT:
      return smallIntegerCastTarget();
    case Types.FLOAT:
    case Types.REAL: {
      return floatingPointNumberCastTarget();
    }
    case Types.NUMERIC:
      return fixedPointNumberCastTarget();
    case Types.VARCHAR:
      return "char";
    case Types.VARBINARY:
      return "binary";
    default:
      return super.getCastTypeName( code );
  }
}
origin: org.hibernate.orm/hibernate-core

@Override
public String getTableTypeString() {
  return storageEngine.getTableTypeString( getEngineKeyword());
}
origin: jboss.jboss-embeddable-ejb3/hibernate-all

public MySQLDialect() {
  super();
  registerColumnType( Types.BIT, "bit" );
  registerColumnType( Types.BIGINT, "bigint" );
  registerColumnType( Types.SMALLINT, "smallint" );
  registerColumnType( Types.TINYINT, "tinyint" );
  registerColumnType( Types.INTEGER, "integer" );
  registerColumnType( Types.CHAR, "char(1)" );
  registerColumnType( Types.FLOAT, "float" );
  registerColumnType( Types.DOUBLE, "double precision" );
  registerColumnType( Types.DATE, "date" );
  registerColumnType( Types.TIME, "time" );
  registerColumnType( Types.TIMESTAMP, "datetime" );
  registerColumnType( Types.VARBINARY, "longblob" );
  registerColumnType( Types.VARBINARY, 16777215, "mediumblob" );
  registerColumnType( Types.VARBINARY, 65535, "blob" );
  registerColumnType( Types.VARBINARY, 255, "tinyblob" );
  registerColumnType( Types.NUMERIC, "numeric($p,$s)" );
  registerColumnType( Types.BLOB, "longblob" );
  registerColumnType( Types.BLOB, 16777215, "mediumblob" );
  registerColumnType( Types.BLOB, 65535, "blob" );
  registerColumnType( Types.CLOB, "longtext" );
  registerColumnType( Types.CLOB, 16777215, "mediumtext" );
  registerColumnType( Types.CLOB, 65535, "text" );
  registerVarcharTypes();
  registerFunction("ascii", new StandardSQLFunction("ascii", Hibernate.INTEGER) );
  registerFunction("bin", new StandardSQLFunction("bin", Hibernate.STRING) );
  registerFunction("char_length", new StandardSQLFunction("char_length", Hibernate.LONG) );
  registerFunction("character_length", new StandardSQLFunction("character_length", Hibernate.LONG) );
origin: ManyDesigns/Portofino

public GoogleCloudSQLDatabasePlatform() {
  super(new MySQLDialect(), "jdbc:google:rdbms://<instance-name>/<database>");
  try {
    DriverManager.registerDriver((Driver) Class.forName("com.google.cloud.sql.Driver").newInstance());
  } catch (Exception e) {
    logger.debug("The driver to connect to Google Cloud SQL from a non-GAE application was not found", e);
  }
}
origin: org.hibernate/com.springsource.org.hibernate

  protected void registerVarcharTypes() {
    registerColumnType( Types.VARCHAR, "longtext" );
//        registerColumnType( Types.VARCHAR, 16777215, "mediumtext" );
//        registerColumnType( Types.VARCHAR, 65535, "text" );
    registerColumnType( Types.VARCHAR, 255, "varchar($l)" );
    registerColumnType( Types.LONGVARCHAR, "longtext" );
  }

origin: org.hibernate/com.springsource.org.hibernate

public MySQLDialect() {
  super();
  registerColumnType( Types.BIT, "bit" );
  registerColumnType( Types.BIGINT, "bigint" );
  registerColumnType( Types.SMALLINT, "smallint" );
  registerColumnType( Types.TINYINT, "tinyint" );
  registerColumnType( Types.INTEGER, "integer" );
  registerColumnType( Types.CHAR, "char(1)" );
  registerColumnType( Types.FLOAT, "float" );
  registerColumnType( Types.DOUBLE, "double precision" );
  registerColumnType( Types.DATE, "date" );
  registerColumnType( Types.TIME, "time" );
  registerColumnType( Types.TIMESTAMP, "datetime" );
  registerColumnType( Types.VARBINARY, "longblob" );
  registerColumnType( Types.VARBINARY, 16777215, "mediumblob" );
  registerColumnType( Types.VARBINARY, 65535, "blob" );
  registerColumnType( Types.VARBINARY, 255, "tinyblob" );
  registerColumnType( Types.BINARY, "binary($l)" );
  registerColumnType( Types.LONGVARBINARY, "longblob" );
  registerColumnType( Types.LONGVARBINARY, 16777215, "mediumblob" );
  registerColumnType( Types.NUMERIC, "decimal($p,$s)" );
  registerColumnType( Types.BLOB, "longblob" );
  registerColumnType( Types.CLOB, "longtext" );
  registerVarcharTypes();
  registerFunction("ascii", new StandardSQLFunction("ascii", StandardBasicTypes.INTEGER) );
  registerFunction("bin", new StandardSQLFunction("bin", StandardBasicTypes.STRING) );
  registerFunction("char_length", new StandardSQLFunction("char_length", StandardBasicTypes.LONG) );
origin: org.hibernate.orm/hibernate-core

  @Override
  public Dialect resolveDialect(DialectResolutionInfo info) {
    final String databaseName = info.getDatabaseName();
    if ( "MySQL".equals( databaseName ) ) {
      final int majorVersion = info.getDatabaseMajorVersion();
      final int minorVersion = info.getDatabaseMinorVersion();
      if ( majorVersion < 5 ) {
        return new MySQLDialect();
      }
      else if ( majorVersion == 5 ) {
        if ( minorVersion < 5 ) {
          return new MySQL5Dialect();
        }
        else if ( minorVersion < 7 ) {
          return new MySQL55Dialect();
        }
        else {
          return new MySQL57Dialect();
        }
      }
      return latestDialectInstance( this );
    }
    return null;
  }
},
org.hibernate.dialectMySQLDialect

Javadoc

An SQL dialect for MySQL (prior to 5.x).

Most used methods

  • <init>
    Constructs a MySQLDialect
  • getDefaultProperties
  • registerColumnType
  • registerFunction
  • registerVarcharTypes
  • fixedPointNumberCastTarget
    Determine the cast target for Types#NUMERIC
  • floatingPointNumberCastTarget
    Determine the cast target for Types#FLOAT and Types#REAL (DOUBLE)
  • getDefaultMySQLStorageEngine
  • getEngineKeyword
  • smallIntegerCastTarget
    Determine the cast target for Types#INTEGER, Types#BIGINT and Types#SMALLINT
  • contributeTypes
  • generateIdTableExporter
  • contributeTypes,
  • generateIdTableExporter,
  • generateIdTableSupport,
  • getViolatedConstraintNameExtracter

Popular in Java

  • Finding current android device location
  • scheduleAtFixedRate (Timer)
  • onCreateOptionsMenu (Activity)
  • findViewById (Activity)
  • Font (java.awt)
    The Font class represents fonts, which are used to render text in a visible way. A font provides the
  • SortedSet (java.util)
    SortedSet is a Set which iterates over its elements in a sorted order. The order is determined eithe
  • TimeZone (java.util)
    TimeZone represents a time zone offset, and also figures out daylight savings. Typically, you get a
  • Vector (java.util)
    Vector is an implementation of List, backed by an array and synchronized. All optional operations in
  • Executors (java.util.concurrent)
    Factory and utility methods for Executor, ExecutorService, ScheduledExecutorService, ThreadFactory,
  • Get (org.apache.hadoop.hbase.client)
    Used to perform Get operations on a single row. To get everything for a row, instantiate a Get objec
  • CodeWhisperer alternatives
Tabnine Logo
  • Products

    Search for Java codeSearch for JavaScript code
  • IDE Plugins

    IntelliJ IDEAWebStormVisual StudioAndroid StudioEclipseVisual Studio CodePyCharmSublime TextPhpStormVimGoLandRubyMineEmacsJupyter NotebookJupyter LabRiderDataGripAppCode
  • Company

    About UsContact UsCareers
  • Resources

    FAQBlogTabnine AcademyTerms of usePrivacy policyJava Code IndexJavascript Code Index
Get Tabnine for your IDE now