@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(); }
@Before public void setUp(){ IDatabaseConnection mockConnection = mock(IDatabaseConnection.class); // Set it up - this is a JNDI connection when( mockConnection.getAccessType()).thenReturn( DatabaseAccessType.JNDI ); when( mockConnection.getDatabaseName()).thenReturn( dsName ); DataSource mockDs = mock(DataSource.class); IDatasourceMgmtService mockMgmtService = mock(IDatasourceMgmtService.class); spyService = spy(service ); try { when( mockMgmtService.getDatasourceByName( dsName ) ).thenReturn( mockConnection ); } catch ( DatasourceMgmtServiceException e ) { e.printStackTrace(); } try { doReturn(mockDs).when( spyService ).getJndiDataSource( dsName ); } catch ( DBDatasourceServiceException e ) { e.printStackTrace(); } doReturn( mockMgmtService ).when( spyService ).getDatasourceMgmtService(); service.clearCache(); }
@Before public void setUp(){ mockConnection = mock(IDatabaseConnection.class); // Set it up - this is a NATIVE connection when( mockConnection.getAccessType()).thenReturn( DatabaseAccessType.NATIVE ); when( mockConnection.getDatabaseName()).thenReturn( dsName ); DataSource mockDs = mock(DataSource.class); IDatasourceMgmtService mockMgmtService = mock(IDatasourceMgmtService.class); spyService = spy(service ); try { when( mockMgmtService.getDatasourceByName( dsName ) ).thenReturn( mockConnection ); } catch ( DatasourceMgmtServiceException e ) { e.printStackTrace(); } try { doReturn(mockDs).when( spyService ).resolveDatabaseConnection( mockConnection ); } catch ( DBDatasourceServiceException e ) { e.printStackTrace(); } doReturn( mockMgmtService ).when( spyService ).getDatasourceMgmtService(); service.clearCache(); }
@Before public void setUp() { mockConnection = mock( IDatabaseConnection.class ); // Set it up - this is a NATIVE connection when( mockConnection.getAccessType() ).thenReturn( DatabaseAccessType.NATIVE ); when( mockConnection.getDatabaseName() ).thenReturn( dsName ); DataSource mockDs = mock( DataSource.class ); IDatasourceMgmtService mockMgmtService = mock( IDatasourceMgmtService.class ); DynamicallyPooledOrJndiDatasourceService dynamic = new DynamicallyPooledOrJndiDatasourceService(); dynamic.setNonPooledDatasourceService( nonPooledSpyService ); dynamic.setPooledDatasourceService( pooledSpyService ); spyService = spy(dynamic ); try { when( mockMgmtService.getDatasourceByName( dsName ) ).thenReturn( mockConnection ); } catch ( DatasourceMgmtServiceException e ) { e.printStackTrace(); } try { doReturn( mockDs ).when( nonPooledSpyService ).resolveDatabaseConnection( mockConnection ); doReturn( mockDs ).when( pooledSpyService ).resolveDatabaseConnection( mockConnection ); } catch ( DBDatasourceServiceException e ) { e.printStackTrace(); } doReturn( mockMgmtService ).when( nonPooledSpyService ).getDatasourceMgmtService(); doReturn( mockMgmtService ).when( pooledSpyService ).getDatasourceMgmtService(); doReturn( mockMgmtService ).when( spyService ).getDatasourceMgmtService(); spyService.clearCache(); }
IPentahoConnection pentahoConnection = null; pentahoConnection = PentahoConnectionFactory .getConnection( IPentahoConnection.SQL_DATASOURCE, connection.getDatabaseName(), null, this ); try { connection.setUsername( ( ( (SQLConnection) pentahoConnection ).getNativeConnection().getMetaData().getUserName() ) );
@Override protected DataSource getDataSource( IDatabaseConnection connection ) { DataSource ds = null; try { if (!connection.getAccessType().equals( DatabaseAccessType.JNDI ) ) { ds = PooledDatasourceHelper.setupPooledDataSource( connection ); } else { ds = PooledDatasourceHelper.getJndiDataSource( connection.getDatabaseName() ); } } catch ( DBDatasourceServiceException e ) { Logger.error( this, Messages.getInstance().getErrorString( "DatasourceSystemListener.ERROR_0003_UNABLE_TO_POOL_DATASOURCE", connection.getName(), e.getMessage() ) ); //$NON-NLS-1$ } return ds; }
if ( connection.getAccessType().equals( DatabaseAccessType.JNDI ) ) { pentahoConnection = PentahoConnectionFactory .getConnection( IPentahoConnection.SQL_DATASOURCE, connection.getDatabaseName(), null, this ); } else { if ( connection.isUsingConnectionPool() ) {
ds = getJndiDataSource( databaseConnection.getDatabaseName() );
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 ) ); rootNode.setProperty( PROP_USERNAME, setNull( databaseConnection.getUsername() ) );
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_HOST_NAME, setNull( databaseConnection.getHostname() ) ); rootAttrs.setAttribute( ConnectionModule.NAMESPACE, PROP_DATABASE_NAME, setNull( databaseConnection .getDatabaseName() ) ); rootAttrs.setAttribute( ConnectionModule.NAMESPACE, PROP_PORT, String.valueOf( new Long( port ) ) ); // implicit
@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.setConnectionPoolingProperties( connection.getConnectionPoolingProperties() ); conn.setConnectSql( connection.getConnectSql() ); conn.setDatabaseName( connection.getDatabaseName() ); conn.setDatabasePort( connection.getDatabasePort() ); conn.setDatabaseType( connection.getDatabaseType() );
Text databaseNameText = document.createTextNode( dbConn.getDatabaseName() ); databaseName.appendChild( databaseNameText ); databaseConnection.appendChild( databaseName );
target.setName( source.getName() ); target.setHostname( source.getHostname() ); target.setDatabaseName( source.getDatabaseName() ); target.setDatabasePort( source.getDatabasePort() ); target.setUsername( source.getUsername() );
target.setName( source.getName() ); target.setHostname( source.getHostname() ); target.setDatabaseName( source.getDatabaseName() ); target.setDatabasePort( source.getDatabasePort() ); target.setUsername( source.getUsername() );
connectionImpl.setConnectionPoolingProperties( mapBeanToImpl( connectionBean.getConnectionPoolingProperties() ) ); connectionImpl.setConnectSql( connectionBean.getConnectSql() ); connectionImpl.setDatabaseName( connectionBean.getDatabaseName() ); connectionImpl.setDatabasePort( connectionBean.getDatabasePort() ); connectionImpl.setDatabaseType( dbTypeBeanToImpl( connectionBean.getDatabaseType() ) );