@Override public Dialect resolveDialect(DialectResolutionInfo info) { final String databaseName = info.getDatabaseName(); if ( "DB2 UDB for AS/400".equals( databaseName ) ) { return new DB2400Dialect(); } if ( databaseName.startsWith( "DB2/" ) ) { return new DB2Dialect(); } return null; } },
final String[] createCommands = new DB2Dialect().getTableExporter().getSqlCreateStrings( table, metadata ); assertContains( "sequence_name varchar(255) not null", createCommands[0] );
@Test @TestForIssue( jiraKey = "HHH-9850" ) public void testNewGeneratorTableCreationOnDb2() { StandardServiceRegistry ssr = new StandardServiceRegistryBuilder() .applySetting( AvailableSettings.DIALECT, DB2Dialect.class.getName() ) .build(); try { Metadata metadata = new MetadataSources( ssr ) .buildMetadata(); assertEquals( 0, metadata.getDatabase().getDefaultNamespace().getTables().size() ); TableGenerator generator = new TableGenerator(); Properties properties = new Properties(); generator.configure( IntegerType.INSTANCE, properties, ssr ); generator.registerExportables( metadata.getDatabase() ); assertEquals( 1, metadata.getDatabase().getDefaultNamespace().getTables().size() ); final Table table = metadata.getDatabase().getDefaultNamespace().getTables().iterator().next(); final String[] createCommands = new DB2Dialect().getTableExporter().getSqlCreateStrings( table, metadata ); assertContains( "sequence_name varchar(255) not null", createCommands[0] ); } finally { StandardServiceRegistryBuilder.destroy( ssr ); } }
public IbmDb2DatabasePlatform() { super(new DB2Dialect(), "jdbc:db2://<host>[:<port>]/<database_name>"); }
public static void main(String[] args) { System.out.println( new DB2Dialect().getLimitString("/*foo*/ select * from foos", true) ); System.out.println( new DB2Dialect().getLimitString("/*foo*/ select distinct * from foos", true) ); System.out.println( new DB2Dialect().getLimitString("/*foo*/ select * from foos foo order by foo.bar, foo.baz", true) ); System.out.println( new DB2Dialect().getLimitString("/*foo*/ select distinct * from foos foo order by foo.bar, foo.baz", true) ); }
public static void main(String[] args) { System.out.println( new DB2Dialect().getLimitString("/*foo*/ select * from foos", true) ); System.out.println( new DB2Dialect().getLimitString("/*foo*/ select distinct * from foos", true) ); System.out.println( new DB2Dialect().getLimitString("/*foo*/ select * from foos foo order by foo.bar, foo.baz", true) ); System.out.println( new DB2Dialect().getLimitString("/*foo*/ select distinct * from foos foo order by foo.bar, foo.baz", true) ); }
public static void main(String[] args) { System.out.println( new DB2Dialect().getLimitString( "/*foo*/ select * from foos", true ) ); System.out.println( new DB2Dialect().getLimitString( "/*foo*/ select distinct * from foos", true ) ); System.out .println( new DB2Dialect().getLimitString( "/*foo*/ select * from foos foo order by foo.bar, foo.baz", true ) ); System.out .println( new DB2Dialect().getLimitString( "/*foo*/ select distinct * from foos foo order by foo.bar, foo.baz", true ) ); }
public static void main(String[] args) { System.out.println( new DB2Dialect().getLimitString( "/*foo*/ select * from foos", true ) ); System.out.println( new DB2Dialect().getLimitString( "/*foo*/ select distinct * from foos", true ) ); System.out .println( new DB2Dialect().getLimitString( "/*foo*/ select * from foos foo order by foo.bar, foo.baz", true ) ); System.out .println( new DB2Dialect().getLimitString( "/*foo*/ select distinct * from foos foo order by foo.bar, foo.baz", true ) ); }
@Override public Dialect resolveDialect(DialectResolutionInfo info) { final String databaseName = info.getDatabaseName(); if ( "DB2 UDB for AS/400".equals( databaseName ) ) { return new DB2400Dialect(); } if ( databaseName.startsWith( "DB2/" ) ) { return new DB2Dialect(); } return null; } },