@Override public String getURL( IDatabaseConnection connection ) throws DatabaseDialectException { StringBuffer urlBuffer = new StringBuffer( getNativeJdbcPre() ); /* * String username = connection.getUsername(); if(username != null && !"".equals(username)) { * urlBuffer.append(username); String password = connection.getPassword(); if(password != null && * !"".equals(password)) { urlBuffer.append(":"); urlBuffer.append(password); } urlBuffer.append("@"); } */ urlBuffer.append( connection.getHostname() ); urlBuffer.append( ":" ); urlBuffer.append( connection.getDatabasePort() ); urlBuffer.append( "/" ); urlBuffer.append( connection.getDatabaseName() ); return urlBuffer.toString(); }
@Override public String getURL( IDatabaseConnection connection ) throws DatabaseDialectException { StringBuffer urlBuffer = new StringBuffer( getNativeJdbcPre() ); /* * String username = connection.getUsername(); if(username != null && !"".equals(username)) { * urlBuffer.append(username); String password = connection.getPassword(); if(password != null && * !"".equals(password)) { urlBuffer.append(":"); urlBuffer.append(password); } urlBuffer.append("@"); } */ urlBuffer.append( connection.getHostname() ); urlBuffer.append( ":" ); urlBuffer.append( connection.getDatabasePort() ); urlBuffer.append( "/" ); urlBuffer.append( connection.getDatabaseName() ); return urlBuffer.toString(); }
@Override public String getURL( IDatabaseConnection connection ) throws DatabaseDialectException { StringBuffer urlBuffer = new StringBuffer( getNativeJdbcPre() ); /* * String username = connection.getUsername(); if(username != null && !"".equals(username)) { * urlBuffer.append(username); String password = connection.getPassword(); if(password != null && * !"".equals(password)) { urlBuffer.append(":"); urlBuffer.append(password); } urlBuffer.append("@"); } */ urlBuffer.append( connection.getHostname() ); urlBuffer.append( ":" ); urlBuffer.append( connection.getDatabasePort() ); urlBuffer.append( "/" ); urlBuffer.append( connection.getDatabaseName() ); String principalPropertyName = getDatabaseType().getShortName() + ".principal"; String principal = connection.getExtraOptions().get( principalPropertyName ); String extraPrincipal = connection.getAttributes().get( DatabaseConnection.ATTRIBUTE_PREFIX_EXTRA_OPTION + principalPropertyName ); urlBuffer.append( ";impala_db=true" ); if ( principal != null || extraPrincipal != null ) { return urlBuffer.toString(); } urlBuffer.append( ";auth=noSasl" ); return urlBuffer.toString(); }
@VisibleForTesting protected boolean isPortUsedByServer( IDatabaseConnection databaseConnection ) { String connectionHostName = databaseConnection.getHostname(); InetAddress connectionAddress = null; try {
@Test public void testGetDatasources() throws Exception { final String fileId = "456"; final String databasesFolderPath = "/etc/pdi/databases"; final String dotKdb = ".kdb"; IUnifiedRepository repo = mock( IUnifiedRepository.class ); // stub out get parent folder doReturn( new RepositoryFile.Builder( "123", "databases" ).folder( true ).build() ).when( repo ).getFile( databasesFolderPath ); doReturn( reservedChars ).when( repo ).getReservedChars(); // stub out get file to update RepositoryFile f = new RepositoryFile.Builder( fileId, EXP_DBMETA_NAME + dotKdb ).path( databasesFolderPath + RepositoryFile.SEPARATOR + EXP_DBMETA_NAME + dotKdb ).build(); doReturn( f ).when( repo ).getFile( databasesFolderPath + RepositoryFile.SEPARATOR + EXP_DBMETA_NAME + dotKdb ); final String EXP_HOST_NAME = "hello"; DataNode rootNode = new DataNode( "databaseMeta" ); rootNode.setProperty( "TYPE", "Hypersonic" ); // required rootNode.setProperty( "HOST_NAME", EXP_HOST_NAME ); rootNode.addNode( "attributes" ); // required doReturn( new NodeRepositoryFileData( rootNode ) ).when( repo ).getDataForRead( eq( fileId ), eq( NodeRepositoryFileData.class ) ); IDatasourceMgmtService datasourceMgmtService = new JcrBackedDatasourceMgmtService( repo, new DatabaseDialectService() ); IDatabaseConnection conn = datasourceMgmtService.getDatasourceByName( EXP_DBMETA_NAME ); assertEquals( EXP_HOST_NAME, conn.getHostname() ); }
( "".equals( setNull( databaseConnection.getDatabasePort() ) ) ) ? "0" : databaseConnection.getDatabasePort(); rootNode.setProperty( PROP_CONTYPE, setNull( databaseConnection.getAccessType().getName() ) ); rootNode.setProperty( PROP_HOST_NAME, setNull( databaseConnection.getHostname() ) ); rootNode.setProperty( PROP_DATABASE_NAME, setNull( databaseConnection.getDatabaseName() ) ); rootNode.setProperty( PROP_PORT, new Long( port ) );
public void sanitizeConnectionParameters( IDatabaseConnection connection ) { String safeName = safeEscapeHtml( connection.getName() ); connection.setName( safeName ); String safeDbName = safeEscapeHtml( connection.getDatabaseName() ); connection.setDatabaseName( safeDbName ); String safeDbPort = safeEscapeHtml( connection.getDatabasePort() ); connection.setDatabasePort( safeDbPort ); String safeHostname = safeEscapeHtml( connection.getHostname() ); connection.setHostname( safeHostname ); String safePassword = safeEscapeHtml( connection.getPassword() ); connection.setPassword( safePassword ); String safeUsername = safeEscapeHtml( connection.getUsername() ); connection.setUsername( safeUsername ); }
public void unsanitizeConnectionParameters( IDatabaseConnection connection ) { String safeName = StringEscapeUtils.unescapeHtml( connection.getName() ); connection.setName( safeName ); String safeDbName = StringEscapeUtils.unescapeHtml( connection.getDatabaseName() ); connection.setDatabaseName( safeDbName ); String safeDbPort = StringEscapeUtils.unescapeHtml( connection.getDatabasePort() ); connection.setDatabasePort( safeDbPort ); String safeHostname = StringEscapeUtils.unescapeHtml( connection.getHostname() ); connection.setHostname( safeHostname ); String safePassword = StringEscapeUtils.unescapeHtml( connection.getPassword() ); connection.setPassword( safePassword ); String safeUsername = StringEscapeUtils.unescapeHtml( connection.getUsername() ); connection.setUsername( safeUsername ); }
rootAttrs.setAttribute( ConnectionModule.NAMESPACE, PROP_CONTYPE, setNull( databaseConnection.getAccessType() .getName() ) ); rootAttrs.setAttribute( ConnectionModule.NAMESPACE, PROP_HOST_NAME, setNull( databaseConnection.getHostname() ) ); rootAttrs.setAttribute( ConnectionModule.NAMESPACE, PROP_DATABASE_NAME, setNull( databaseConnection .getDatabaseName() ) );
@Override public String getURL( IDatabaseConnection databaseConnection ) throws DatabaseDialectException { return SimbaUrl.Builder.create() .withAccessType( databaseConnection.getAccessType().ordinal() ) .withDatabaseName( databaseConnection.getDatabaseName() ) .withPort( databaseConnection.getDatabasePort() ) .withDefaultPort( getDefaultDatabasePort() ) .withHostname( databaseConnection.getHostname() ) .withJdbcPrefix( getNativeJdbcPre() ) .withUsername( databaseConnection.getUsername() ) .withPassword( databaseConnection.getPassword() ) .withIsKerberos( isKerberos( databaseConnection ) ) .build() .getURL(); }
IDatabaseConnection databaseConnection = adapter.getDatasourceByName( "testDatabase" ); assertNotNull( databaseConnection ); assertEquals( EXP_DBMETA_HOSTNAME, databaseConnection.getHostname() ); IDatabaseConnection databaseConnection1 = adapter.getDatasourceById( id ); assertEquals( EXP_DBMETA_HOSTNAME, databaseConnection.getHostname() ); String id1 = adapter.createDatasource( createDatabaseConnection( "testDatabase1" ) ); assertNotNull( id1 ); IDatabaseConnection databaseConnection2 = adapter.getDatasourceByName( "testDatabase1" ); assertNotNull( databaseConnection2 ); assertEquals( EXP_DBMETA_HOSTNAME, databaseConnection1.getHostname() ); IDatabaseConnection databaseConnection3 = adapter.getDatasourceById( id1 ); assertEquals( EXP_DBMETA_HOSTNAME, databaseConnection1.getHostname() ); List<IDatabaseConnection> databaseConnections = adapter.getDatasources(); assertEquals( 2, databaseConnections.size() ); updatedDatabaseConnection = adapter.getDatasourceById( id3 ); assertNotNull( updatedDatabaseConnection ); assertEquals( EXP_UPDATED_DBMETA_HOSTNAME, databaseConnection.getHostname() );
conn.setForcingIdentifiersToLowerCase( connection.isForcingIdentifiersToLowerCase() ); conn.setForcingIdentifiersToUpperCase( connection.isForcingIdentifiersToUpperCase() ); conn.setHostname( connection.getHostname() ); conn.setIndexTablespace( connection.getIndexTablespace() ); conn.setInformixServername( connection.getInformixServername() );
Text hostnameText = document.createTextNode( dbConn.getHostname() ); hostname.appendChild( hostnameText ); databaseConnection.appendChild( hostname );
target.setExtraOptionsOrder( source.getExtraOptionsOrder() ); target.setName( source.getName() ); target.setHostname( source.getHostname() ); target.setDatabaseName( source.getDatabaseName() ); target.setDatabasePort( source.getDatabasePort() );
target.setExtraOptionsOrder( source.getExtraOptionsOrder() ); target.setName( source.getName() ); target.setHostname( source.getHostname() ); target.setDatabaseName( source.getDatabaseName() ); target.setDatabasePort( source.getDatabasePort() );
connectionImpl.setForcingIdentifiersToLowerCase( connectionBean.isForcingIdentifiersToLowerCase() ); connectionImpl.setForcingIdentifiersToUpperCase( connectionBean.isForcingIdentifiersToUpperCase() ); connectionImpl.setHostname( connectionBean.getHostname() ); connectionImpl.setId( connectionBean.getId() ); connectionImpl.setIndexTablespace( connectionBean.getIndexTablespace() );