IDatabaseDialectService databaseDialectService = new DatabaseDialectService(); DatabaseTypeHelper databaseTypeHelper = new DatabaseTypeHelper( databaseDialectService.getDatabaseTypes() ); DatabaseConnection dbConn = new DatabaseConnection(); dbConn.setId( dbConnDto.getId() ); dbConn.setAccessType( dbConnDto.getAccessType() ); dbConn.setAccessTypeValue( dbConnDto.getAccessTypeValue() ); dbConn.setChanged( dbConnDto.getChanged() ); dbConn.setConnectionPoolingProperties( dbConnDto.getConnectionPoolingProperties() ); dbConn.setConnectSql( dbConnDto.getConnectSql() ); dbConn.setDatabaseName( dbConnDto.getDatabaseName() ); dbConn.setDatabasePort( dbConnDto.getDatabasePort() ); if ( dbConnDto.getDatabaseType() != null ) { dbConn.setDatabaseType( databaseTypeHelper.getDatabaseTypeByShortName( dbConnDto.getDatabaseType() ) ); dbConn.setDataTablespace( dbConnDto.getDataTablespace() ); dbConn.setForcingIdentifiersToLowerCase( dbConnDto.isForcingIdentifiersToLowerCase() ); dbConn.setForcingIdentifiersToUpperCase( dbConnDto.isForcingIdentifiersToUpperCase() ); dbConn.setHostname( dbConnDto.getHostname() ); dbConn.setIndexTablespace( dbConnDto.getIndexTablespace() ); dbConn.setInformixServername( dbConnDto.getInformixServername() ); dbConn.setInitialPoolSize( dbConnDto.getInitialPoolSize() ); dbConn.setMaximumPoolSize( dbConnDto.getMaximumPoolSize() ); dbConn.setName( dbConnDto.getName() ); dbConn.setPartitioned( dbConnDto.isPartitioned() ); dbConn.setPartitioningInformation( dbConnDto.getPartitioningInformation() ); dbConn.setPassword( dbConnDto.getPassword() ); dbConn.setQuoteAllFields( dbConnDto.isQuoteAllFields() ); dbConn.setSQLServerInstance( dbConnDto.getSQLServerInstance() ); dbConn.setStreamingResults( dbConnDto.isStreamingResults() );
protected void startParsing( final Attributes attrs ) throws SAXException { databaseConnection = new DatabaseConnection(); final String databaseType = attrs.getValue( ConnectionModule.NAMESPACE, PROP_TYPE ); if ( databaseType != null ) { databaseConnection.setDatabaseType( databaseTypeHelper.getDatabaseTypeByShortName( databaseType ) ); } else { databaseConnection.setDatabaseType( null ); } databaseConnection.setName( attrs.getValue( ConnectionModule.NAMESPACE, "name" ) ); databaseConnection.setId( attrs.getValue( ConnectionModule.NAMESPACE, "id" ) ); final String accessType = attrs.getValue( ConnectionModule.NAMESPACE, PROP_CONTYPE ); databaseConnection.setAccessType( accessType != null ? DatabaseAccessType.getAccessTypeByName( accessType ) : null ); databaseConnection.setHostname( attrs.getValue( ConnectionModule.NAMESPACE, PROP_HOST_NAME ) ); databaseConnection.setDatabaseName( attrs.getValue( ConnectionModule.NAMESPACE, PROP_DATABASE_NAME ) ); databaseConnection.setDatabasePort( attrs.getValue( ConnectionModule.NAMESPACE, PROP_PORT ) ); databaseConnection.setUsername( attrs.getValue( ConnectionModule.NAMESPACE, PROP_USERNAME ) ); databaseConnection.setPassword( attrs.getValue( ConnectionModule.NAMESPACE, PROP_PASSWORD ) ); databaseConnection.setInformixServername( attrs.getValue( ConnectionModule.NAMESPACE, PROP_SERVERNAME ) ); databaseConnection.setDataTablespace( attrs.getValue( ConnectionModule.NAMESPACE, PROP_DATA_TBS ) ); databaseConnection.setIndexTablespace( attrs.getValue( ConnectionModule.NAMESPACE, PROP_INDEX_TBS ) ); }
private DatabaseConnection createDatabaseConnection( final String dbName ) throws Exception { DatabaseConnection dbConnection = new DatabaseConnection(); dbConnection.setName( dbName ); dbConnection.setHostname( EXP_DBMETA_HOSTNAME ); dbConnection.setDatabaseType( mockDatabaseType( "Hypersonic" ) ); dbConnection.setAccessType( DatabaseAccessType.NATIVE ); dbConnection.setDatabasePort( EXP_DBMETA_PORT ); return dbConnection; }
private void updateDatabaseConnection( DatabaseConnection dbConnection ) throws Exception { dbConnection.setHostname( EXP_UPDATED_DBMETA_HOSTNAME ); dbConnection.setDatabaseType( mockDatabaseType( "Generic database" ) ); dbConnection.setAccessType( DatabaseAccessType.JNDI ); dbConnection.setDatabasePort( EXP_UPDATED_DBMETA_PORT ); }
@Test public void testCreateDatasourceNoDialect() throws Exception { DatabaseDialectService dialectService = new DatabaseDialectService( false ); final DatabaseConnection con = new DatabaseConnection(); con.setId( "Postgres" ); con.setName( "Postgres" ); con.setAccessType( DatabaseAccessType.NATIVE ); con.setUsername( "pentaho_user" ); con.setPassword( "password" ); final HashMap<String, String> attrs = new HashMap<>(); attrs.put( DatabaseConnection.ATTRIBUTE_CUSTOM_DRIVER_CLASS, "org.postgresql.Driver" ); attrs.put( DatabaseConnection.ATTRIBUTE_CUSTOM_URL, "jdbc:postgresql://localhost:5432/hibernate" ); con.setAttributes( attrs ); try { PooledDatasourceHelper.convert( con, () -> dialectService ); fail( "Expecting the exception to be thrown" ); } catch ( DBDatasourceServiceException ex ) { assertNotNull( ex ); } }
DatabaseConnection databaseConnection = new DatabaseConnection(); databaseConnection.setName( databaseName ); databaseConnection.setId( databaseName ); } else if ( reader.getNodeName().equalsIgnoreCase( "username" ) ) { databaseConnection.setUsername( reader.getValue() ); } else if ( reader.getNodeName().equalsIgnoreCase( "password" ) ) { databaseConnection.setPassword( reader.getValue() ); } else if ( reader.getNodeName().equalsIgnoreCase( "url" ) ) { ParsedJdbcUrl parsedJdbcUrl = new ParsedJdbcUrl( reader.getValue() ); databaseConnection.setHostname( parsedJdbcUrl.getHostname() ); databaseConnection.setDatabasePort( parsedJdbcUrl.getPort() ); databaseConnection.setDatabaseName( parsedJdbcUrl.getDatabaseName() ); databaseConnection.setDatabaseType( resolveDatabaseType( parsedJdbcUrl.getJdbcPrefix() ) ); } catch ( ClassNotFoundException e ) { resultDTO.setSelectedConnection( new DatabaseConnection() );
DatasourceService.validateAccess(); connection.setId( connectionName ); if ( StringUtils.isBlank( connection.getPassword() ) ) { connection.setPassword( old.getPassword() ); connection.setId( old.getId() );
private IDatabaseConnection getAgileMartDatasource( Boolean useDefault, Properties agileMartDatasourceProperties ) { IDatabaseConnection databaseConnection = new DatabaseConnection();
@Test public void testCreateDatasourceNoClassName() throws Exception { DatabaseDialectService dialectService = new DatabaseDialectService( false ); final DatabaseTypeHelper databaseTypeHelper = new DatabaseTypeHelper( dialectService.getDatabaseTypes() ); final DatabaseConnection con = new DatabaseConnection(); con.setId( "Postgres" ); con.setName( "Postgres" ); con.setAccessType( DatabaseAccessType.NATIVE ); con.setDatabaseType( databaseTypeHelper.getDatabaseTypeByShortName( "GENERIC" ) ); con.setUsername( "pentaho_user" ); con.setPassword( "password" ); final HashMap<String, String> attrs = new HashMap<>(); attrs.put( DatabaseConnection.ATTRIBUTE_CUSTOM_DRIVER_CLASS, "" ); attrs.put( DatabaseConnection.ATTRIBUTE_CUSTOM_URL, "jdbc:postgresql://localhost:5432/hibernate" ); con.setAttributes( attrs ); try { PooledDatasourceHelper.convert( con, () -> dialectService ); fail( "Expecting the exception to be thrown" ); } catch ( DBDatasourceServiceException ex ) { assertNotNull( ex ); } }
@Bindable public void showEditConnectionDialog() { datasourceModel.setEditing( true ); if ( databaseDialog != null ) { IDatabaseConnection connection = datasourceModel.getSelectedRelationalConnection(); previousConnectionName = connection.getName(); existingConnectionName = previousConnectionName; DatabaseConnection editConnection = new DatabaseConnection(); copyDatabaseConnectionProperties( connection, editConnection ); databaseDialog.setDatabaseConnection( editConnection ); databaseDialog.show(); } else { databaseDialog = new GwtDatabaseDialog( databaseTypeHelper, GWT.getModuleBaseURL() + "dataaccess-databasedialog.xul", connectionSetter ); //$NON-NLS-1$ } }
DatabaseConnection connectionImpl = new DatabaseConnection(); connectionImpl.setAccessType( connectionBean.getAccessType() ); if ( connectionImpl.getAccessType() != null ) { connectionImpl.setAccessTypeValue( connectionImpl.getAccessType().toString() ); connectionImpl.setAttributes( mapBeanToImpl( connectionBean.getAttributes() ) ); connectionImpl.setConnectionPoolingProperties( mapBeanToImpl( connectionBean.getConnectionPoolingProperties() ) ); connectionImpl.setConnectSql( connectionBean.getConnectSql() ); connectionImpl.setDatabaseName( connectionBean.getDatabaseName() ); connectionImpl.setDatabasePort( connectionBean.getDatabasePort() ); connectionImpl.setDatabaseType( dbTypeBeanToImpl( connectionBean.getDatabaseType() ) ); connectionImpl.setDataTablespace( connectionBean.getDataTablespace() ); connectionImpl.setForcingIdentifiersToLowerCase( connectionBean.isForcingIdentifiersToLowerCase() ); connectionImpl.setForcingIdentifiersToUpperCase( connectionBean.isForcingIdentifiersToUpperCase() ); connectionImpl.setHostname( connectionBean.getHostname() ); connectionImpl.setId( connectionBean.getId() ); connectionImpl.setIndexTablespace( connectionBean.getIndexTablespace() ); connectionImpl.setInformixServername( connectionBean.getInformixServername() ); connectionImpl.setInitialPoolSize( connectionBean.getInitialPoolSize() ); connectionImpl.setMaximumPoolSize( connectionBean.getMaximumPoolSize() ); connectionImpl.setName( connectionBean.getName() ); connectionImpl.setPartitioned( connectionBean.isPartitioned() ); connectionImpl.setPartitioningInformation( connectionBean.getPartitioningInformation() ); connectionImpl.setPassword( connectionBean.getPassword() ); connectionImpl.setDatabasePort( connectionBean.getDatabasePort() ); connectionImpl.setQuoteAllFields( connectionBean.isQuoteAllFields() ); connectionImpl.setSQLServerInstance( connectionBean.getSQLServerInstance() ); connectionImpl.setStreamingResults( connectionBean.isStreamingResults() ); connectionImpl.setUsername( connectionBean.getUsername() );
@Test public void testCreatePoolNoDialectService() throws Exception { DatabaseDialectService dialectService = new DatabaseDialectService( false ); final DatabaseTypeHelper databaseTypeHelper = new DatabaseTypeHelper( dialectService.getDatabaseTypes() ); final DatabaseConnection con = new DatabaseConnection(); con.setId( "Postgres" ); con.setName( "Postgres" ); con.setAccessType( DatabaseAccessType.NATIVE ); con.setDatabaseType( databaseTypeHelper.getDatabaseTypeByShortName( "GENERIC" ) ); con.setUsername( "pentaho_user" ); con.setPassword( "password" ); final HashMap<String, String> attrs = new HashMap<>(); attrs.put( DatabaseConnection.ATTRIBUTE_CUSTOM_DRIVER_CLASS, "org.postgresql.Driver" ); attrs.put( DatabaseConnection.ATTRIBUTE_CUSTOM_URL, "jdbc:postgresql://localhost:5432/hibernate" ); con.setAttributes( attrs ); try { PooledDatasourceHelper.setupPooledDataSource( con ); fail( "Expecting the exception to be thrown" ); } catch ( DBDatasourceServiceException ex ) { assertNotNull( ex ); } }
private IDatabaseConnection createDatabaseConnection( final String dbName ) throws Exception { IDatabaseConnection dbConnection = new DatabaseConnection(); dbConnection.setName( dbName ); dbConnection.setHostname( EXP_DBMETA_HOSTNAME ); dbConnection.setDatabaseType( mockDatabaseType( "Hypersonic" ) ); dbConnection.setAccessType( DatabaseAccessType.NATIVE ); dbConnection.setDatabasePort( EXP_DBMETA_PORT ); return dbConnection; }
private DatabaseConnection createDatabaseConnection() { DatabaseConnection databaseConnection = new DatabaseConnection(); databaseConnection.setDatabaseType( new DatabaseType() ); databaseConnection.setName( "name" ); databaseConnection.setId( "id" ); databaseConnection.setAccessType( DatabaseAccessType.CUSTOM ); databaseConnection.setHostname( "hostName" ); databaseConnection.setDatabaseName( "databaseName" ); databaseConnection.setDatabasePort( "8080" ); databaseConnection.setUsername( "username" ); databaseConnection.setPassword( "password" ); databaseConnection.setInformixServername( "informixServername" ); databaseConnection.setDataTablespace( "dataTablespace" ); databaseConnection.setIndexTablespace( "indexTableSpace" ); databaseConnection.setConnectSql( "connectSql" ); databaseConnection.setInitialPoolSize( 1 ); databaseConnection.setMaximumPoolSize( 1 ); databaseConnection.setUsingConnectionPool( true ); databaseConnection.setForcingIdentifiersToLowerCase( true ); databaseConnection.setForcingIdentifiersToUpperCase( true ); databaseConnection.setQuoteAllFields( true ); databaseConnection.setUsingDoubleDecimalAsSchemaTableSeparator( true ); databaseConnection.setAttributes( attributeMap ); databaseConnection.setConnectionPoolingProperties( connectionPoolingMap ); databaseConnection.setExtraOptions( extraOptions );
@Test public void testCreatePoolNoDialect() throws Exception { DatabaseDialectService dialectService = new DatabaseDialectService( false ); mp = new MicroPlatform( SOLUTION_PATH ); mp.defineInstance( IDatabaseDialectService.class, dialectService ); mp.start(); final DatabaseConnection con = new DatabaseConnection(); con.setId( "Postgres" ); con.setName( "Postgres" ); con.setAccessType( DatabaseAccessType.NATIVE ); con.setUsername( "pentaho_user" ); con.setPassword( "password" ); final HashMap<String, String> attrs = new HashMap<>(); attrs.put( DatabaseConnection.ATTRIBUTE_CUSTOM_DRIVER_CLASS, "" ); attrs.put( DatabaseConnection.ATTRIBUTE_CUSTOM_URL, "jdbc:postgresql://localhost:5432/hibernate" ); con.setAttributes( attrs ); try { PooledDatasourceHelper.setupPooledDataSource( con ); fail( "Expecting the exception to be thrown" ); } catch ( DBDatasourceServiceException ex ) { assertNotNull( ex ); } }
private IDatabaseConnection createDatabaseConnection( final String dbName ) throws Exception { IDatabaseConnection dbConnection = new DatabaseConnection(); dbConnection.setName( dbName ); dbConnection.setHostname( EXP_DBMETA_HOSTNAME ); dbConnection.setDatabaseType( mockDatabaseType( "Hypersonic" ) ); dbConnection.setAccessType( DatabaseAccessType.NATIVE ); dbConnection.setDatabasePort( EXP_DBMETA_PORT ); return dbConnection; }
@Test public void testCreatePoolNoClassName() throws Exception { DatabaseDialectService dialectService = new DatabaseDialectService( false ); final DatabaseTypeHelper databaseTypeHelper = new DatabaseTypeHelper( dialectService.getDatabaseTypes() ); mp = new MicroPlatform( SOLUTION_PATH ); mp.defineInstance( IDatabaseDialectService.class, dialectService ); mp.start(); final DatabaseConnection con = new DatabaseConnection(); con.setId( "Postgres" ); con.setName( "Postgres" ); con.setAccessType( DatabaseAccessType.NATIVE ); con.setDatabaseType( databaseTypeHelper.getDatabaseTypeByShortName( "GENERIC" ) ); con.setUsername( "pentaho_user" ); con.setPassword( "password" ); final HashMap<String, String> attrs = new HashMap<>(); attrs.put( DatabaseConnection.ATTRIBUTE_CUSTOM_DRIVER_CLASS, "" ); attrs.put( DatabaseConnection.ATTRIBUTE_CUSTOM_URL, "jdbc:postgresql://localhost:5432/hibernate" ); con.setAttributes( attrs ); try { PooledDatasourceHelper.setupPooledDataSource( con ); fail( "Expecting the exception to be thrown" ); } catch ( DBDatasourceServiceException ex ) { assertNotNull( ex ); } }
public IDatabaseConnection databaseMetaToDatabaseConnection( final DatabaseMeta databaseMeta ) { IDatabaseConnection databaseConnection = new DatabaseConnection(); databaseConnection.setDatabaseType( databaseTypeHelper .getDatabaseTypeByShortName( databaseMeta.getDatabaseTypeDesc() ) );
public IDatabaseConnection dataNodeToDatabaseConnection( final Serializable id, final String name, final DataNode rootNode ) { IDatabaseConnection databaseConnection = new DatabaseConnection(); String databaseType = getString( rootNode, PROP_TYPE ); databaseConnection.setDatabaseType( databaseType != null ? databaseTypeHelper
public IDatabaseConnection convertToObject( String xml ) { Document document = XMLParser.parse( xml ); Element element = document.getDocumentElement(); IDatabaseConnection databaseConnection = new DatabaseConnection(); databaseConnection.setDatabaseName( getNodeValueByTagName( element, DATABASE_NAME ) ); databaseConnection.setHostname( getNodeValueByTagName( element, HOSTNAME ) ); databaseConnection.setIndexTablespace( getNodeValueByTagName( element, INDEX_TABLESPACE ) ); databaseConnection.setDataTablespace( getNodeValueByTagName( element, DATA_TABLESPACE ) ); databaseConnection.setName( getNodeValueByTagName( element, NAME ) ); databaseConnection.setUsername( getNodeValueByTagName( element, USERNAME ) ); databaseConnection.setPassword( getNodeValueByTagName( element, PASSWORD ) ); databaseConnection.setDatabasePort( getNodeValueByTagName( element, DATABASE_PORT ) ); databaseConnection .setAccessType( DatabaseAccessType.getAccessTypeByName( getNodeValueByTagName( element, ACCESS_TYPE ) ) ); databaseConnection.setDatabaseType( (DatabaseType) databaseTypeHelper.getDatabaseTypeByShortName( getNodeValueByTagName( element, DATABASE_TYPE ) ) ); databaseConnection.setPassword( getNodeValueByTagName( element, PASSWORD ) ); databaseConnection.setInformixServername( getNodeValueByTagName( element, SERVER_NAME ) ); for ( Node node : getNodesByTagName( element, ATTRIBUTES ) ) { databaseConnection.getAttributes().put( node.getNodeName(), node.getNodeValue() ); } return databaseConnection; }