protected static ConnectionFactory getConnectionFactory( IDatabaseConnection databaseConnection, String url ) { Properties props = new Properties(); props.put( "user", StringEscapeUtils.unescapeHtml( databaseConnection.getUsername() ) ); props.put( "password", StringEscapeUtils.unescapeHtml( databaseConnection.getPassword() ) ); if ( url.startsWith( "jdbc:mysql:" ) || ( url.startsWith( "jdbc:mariadb:" ) ) ) { props.put( "connectTimeout", "5000" ); } return new DriverManagerConnectionFactory( url, props ); }
@Test public void testConnectionFactory_MySQL() { IDatabaseConnection connection = mock( IDatabaseConnection.class ); doReturn( StringEscapeUtils.escapeHtml( user ) ).when( connection ).getUsername(); doReturn( StringEscapeUtils.escapeHtml( password ) ).when( connection ).getPassword(); ConnectionFactory factory = PooledDatasourceHelper.getConnectionFactory( connection, "jdbc:mysql://localhost" ); Properties props = (Properties) Whitebox.getInternalState( factory, "_props" ); assertEquals( user, props.getProperty( "user" ) ); assertEquals( password, props.getProperty( "password" ) ); }
@Test public void testConnectionFactory_MicrosoftSQL() { IDatabaseConnection connection = mock( IDatabaseConnection.class ); doReturn( StringEscapeUtils.escapeHtml( user ) ).when( connection ).getUsername(); doReturn( StringEscapeUtils.escapeHtml( password ) ).when( connection ).getPassword(); ConnectionFactory factory = PooledDatasourceHelper.getConnectionFactory( connection, "jdbc:microsoft:sqlserver://localhost" ); Properties props = (Properties) Whitebox.getInternalState( factory, "_props" ); assertEquals( user, props.getProperty( "user" ) ); assertEquals( password, props.getProperty( "password" ) ); }
@Test public void testConnectionFactory_MariaDB() { IDatabaseConnection connection = mock( IDatabaseConnection.class ); doReturn( StringEscapeUtils.escapeHtml( user ) ).when( connection ).getUsername(); doReturn( StringEscapeUtils.escapeHtml( password ) ).when( connection ).getPassword(); ConnectionFactory factory = PooledDatasourceHelper.getConnectionFactory( connection, "jdbc:mariadb://localhost" ); Properties props = (Properties) Whitebox.getInternalState( factory, "_props" ); assertEquals( user, props.getProperty( "user" ) ); assertEquals( password, props.getProperty( "password" ) ); }
@Test public void testSuccessfulDriverInitInConvertGeneric() throws DBDatasourceServiceException { when( databaseType.getShortName() ).thenReturn( "GENERIC" ); when( connection.getAttributes() ).thenReturn( ImmutableMap.of( GenericDatabaseDialect.ATTRIBUTE_CUSTOM_DRIVER_CLASS, nativeDriverName ) ); when( connection.getUsername() ).thenReturn( "suzy" ); when( connection.getPassword() ).thenReturn( "password" ); when( ( (IDriverLocator) driverLocatorDialect ).initialize( nativeDriverName ) ).thenReturn( true ); DriverManagerDataSource dataSource = (DriverManagerDataSource) PooledDatasourceHelper.convert( connection, () -> dialectService ); verify( ( (IDriverLocator) driverLocatorDialect ), times( 1 ) ).initialize( nativeDriverName ); assertThat( dataSource.getUrl(), is( jdbcUrl ) ); assertThat( dataSource.getUsername(), is( "suzy" ) ); assertThat( dataSource.getPassword(), is( "password" ) ); }
IDatabaseDialect dialect = dialectService.getDialect( connection ); conn = DriverManager.getConnection( dialect.getURLWithExtraOptions( connection ), connection.getUsername(), connection.getPassword() ); return conn;
public static SQLConnection getConnection( String connectionName ) throws DatasourceServiceException { IDatabaseConnection connection = null; try { ConnectionServiceImpl service = new ConnectionServiceImpl(); connection = service.getConnectionByName( connectionName ); DatabaseDialectService dialectService = new DatabaseDialectService(); IDatabaseDialect dialect = dialectService.getDialect( connection ); String driverClass = null; if ( connection.getDatabaseType().getShortName().equals( "GENERIC" ) ) { driverClass = connection.getAttributes().get( GenericDatabaseDialect.ATTRIBUTE_CUSTOM_DRIVER_CLASS ); } else { driverClass = dialect.getNativeDriver(); } return new SQLConnection( driverClass, dialect.getURLWithExtraOptions( connection ), connection.getUsername(), connection.getPassword(), null ); } catch ( ConnectionServiceException e1 ) { return null; } catch ( DatabaseDialectException e ) { return null; } }
public boolean updateConnection( IDatabaseConnection connection ) throws ConnectionServiceException { IDatabaseConnection conn = getConnectionByName( connection.getName() ); if ( conn != null ) { // conn.setDriverClass(connection.getDriverClass()); conn.setAccessType( connection.getAccessType() ); conn.setPassword( connection.getPassword() ); conn.setUsername( connection.getUsername() ); return true; } else { logger.error( Messages.getErrorString( "ConnectionServiceInMemoryDelegate.ERROR_0005_UNABLE_TO_UPDATE_CONNECTION", connection.getName(), null ) ); throw new ConnectionServiceException( Messages .getErrorString( "ConnectionServiceInMemoryDelegate.ERROR_0005_UNABLE_TO_UPDATE_CONNECTION", connection.getName(), null ) ); } }
} else { pentahoConnection = PentahoConnectionFactory.getConnection( IPentahoConnection.SQL_DATASOURCE, driverClass, dialect.getURLWithExtraOptions( connection ), connection.getUsername(), getConnectionPassword( connection.getName(), connection.getPassword() ), null, this );
basicDatasource.setUrl( null ); basicDatasource.setUsername( databaseConnection.getUsername() ); basicDatasource.setPassword( databaseConnection.getPassword() );
rootNode.setProperty( PROP_DATABASE_NAME, setNull( databaseConnection.getDatabaseName() ) ); rootNode.setProperty( PROP_PORT, new Long( port ) ); rootNode.setProperty( PROP_USERNAME, setNull( databaseConnection.getUsername() ) ); rootNode.setProperty( PROP_PASSWORD, encryptPassword( databaseConnection.getPassword() ) ); rootNode.setProperty( PROP_SERVERNAME, setNull( databaseConnection.getInformixServername() ) );
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_USERNAME, setNull( databaseConnection.getUsername() ) ); rootAttrs.setAttribute( ConnectionModule.NAMESPACE, PROP_PASSWORD, setNull( databaseConnection.getPassword() ) ); rootAttrs.setAttribute( ConnectionModule.NAMESPACE, PROP_SERVERNAME, setNull( databaseConnection
@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(); }
conn.setExtraOptionsOrder( connection.getExtraOptionsOrder() ); conn.setStreamingResults( connection.isStreamingResults() ); conn.setUsername( connection.getUsername() ); conn.setUsingConnectionPool( connection.isUsingConnectionPool() ); conn.setUsingDoubleDecimalAsSchemaTableSeparator( connection.isUsingDoubleDecimalAsSchemaTableSeparator() );
Text usernameTxt = document.createTextNode( dbConn.getUsername() ); username.appendChild( usernameTxt ); databaseConnection.appendChild( username );
target.setDatabaseName( source.getDatabaseName() ); target.setDatabasePort( source.getDatabasePort() ); target.setUsername( source.getUsername() ); target.setPassword( source.getPassword() ); target.setStreamingResults( source.isStreamingResults() );
target.setDatabaseName( source.getDatabaseName() ); target.setDatabasePort( source.getDatabasePort() ); target.setUsername( source.getUsername() ); target.setPassword( source.getPassword() ); target.setStreamingResults( source.isStreamingResults() );
connectionImpl.setSQLServerInstance( connectionBean.getSQLServerInstance() ); connectionImpl.setStreamingResults( connectionBean.isStreamingResults() ); connectionImpl.setUsername( connectionBean.getUsername() ); connectionImpl.setUsingConnectionPool( connectionBean.isUsingConnectionPool() ); connectionImpl