public void success( List<IDatabaseType> retVal ) { databaseTypeHelper = new DatabaseTypeHelper( retVal ); } };
private Stream<IDatabaseDialect> filterUsableDialects( Stream<IDatabaseDialect> stream, boolean usableOnly ) { if ( usableOnly ) { return stream.filter( dialect -> { if ( dialect instanceof IDriverLocator ) { return ( (IDriverLocator) dialect ).isUsable(); } else { return ClassUtil.canLoadClass( dialect.getNativeDriver() ); } } ); } return stream; }
private DatabaseMeta getDatabaseMeta( IDatabaseConnection connection ) throws Exception { DatabaseMeta databaseMeta = DatabaseUtil.convertToDatabaseMeta( connection ); if ( connection.getName().equals( "SampleData" ) ) { databaseMeta.setAccessType( DatabaseMeta.TYPE_ACCESS_JNDI ); databaseMeta.setDBName( "SampleData" ); } return databaseMeta; }
DatabaseTypeHelper databaseTypeHelper = new DatabaseTypeHelper( databaseDialectService.getDatabaseTypes() ); databaseConnection.setDatabaseType( databaseTypeHelper.getDatabaseTypeByShortName( useDefault ? agileMartDatasourceProperties.getProperty( DEFAULT_DATABASETYPESHORTNAME_VALUE ) : agileMartDatasourceProperties.getProperty( DATABASETYPESHORTNAME ) ) );
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 ) ); }
@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 ); } }
public void success( List<IDatabaseType> retVal ) { databaseTypeHelper = new DatabaseTypeHelper( retVal ); } };
.getDatabaseTypeByShortName( databaseMeta.getDatabaseTypeDesc() ) ); databaseConnection.setName( databaseMeta.getName() ); if ( databaseMeta.getObjectId() != null ) {
/** * Returns the database meta for the given connection. * * @param connection * DatabaseConnection to retrieve meta from * * @return array containing the database connection metadata */ @POST @Path( "/checkParams" ) @Consumes( { APPLICATION_JSON } ) @Produces( { APPLICATION_JSON } ) @Facet( name = "Unsupported" ) public StringArrayWrapper checkParameters( DatabaseConnection connection ) { StringArrayWrapper array = null; String[] rawValues = DatabaseUtil.convertToDatabaseMeta( connection ).checkParameters(); if ( rawValues.length > 0 ) { array = new StringArrayWrapper(); array.setArray( rawValues ); } return array; }
@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 ); } }
public void success( List<IDatabaseType> retVal ) { databaseTypeHelper = new DatabaseTypeHelper( retVal ); databaseConnectionConverter = new DatabaseConnectionConverter( databaseTypeHelper ); } };
String databaseType = getString( rootNode, PROP_TYPE ); databaseConnection.setDatabaseType( databaseType != null ? databaseTypeHelper .getDatabaseTypeByShortName( databaseType ) : null ); databaseConnection.setName( name ); if ( id != null ) {
private DatabaseMeta getDatabaseMeta( IDatabaseConnection connection ) throws ConnectionServiceException { if ( this.connectionServiceImpl == null ) { return this.databaseMeta; } // DatabaseConnection objects may be de-serialized from the client and missing extra parameters and attributes. // Resolve the connection by name through ConnectionService before use. // All public methods should use getDatabaseMeta to guarantee accurate connection info. // NOTE: We want to retrieve the connection again later, so we don't want an unsanitized name here connection = connectionServiceImpl.getConnectionByName( connection.getName(), false ); connection .setPassword( ConnectionServiceHelper.getConnectionPassword( connection.getName(), connection.getPassword() ) ); DatabaseMeta dbmeta = DatabaseUtil.convertToDatabaseMeta( connection ); dbmeta.getDatabaseInterface().setQuoteAllFields( true ); //This line probably shouldn't be here. It overrides the "Quote all in Database" checkbox return dbmeta; }
@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 DatabaseHelper( IDatabaseDialectService databaseDialectService ) { this.databaseTypeHelper = new DatabaseTypeHelper( databaseDialectService.getDatabaseTypes() ); }
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; }
if ( dbConnDto != null ) { IDatabaseDialectService databaseDialectService = new DatabaseDialectService(); DatabaseTypeHelper databaseTypeHelper = new DatabaseTypeHelper( databaseDialectService.getDatabaseTypes() ); DatabaseConnection dbConn = new DatabaseConnection(); dbConn.setId( dbConnDto.getId() ); dbConn.setDatabasePort( dbConnDto.getDatabasePort() ); if ( dbConnDto.getDatabaseType() != null ) { dbConn.setDatabaseType( databaseTypeHelper.getDatabaseTypeByShortName( dbConnDto.getDatabaseType() ) );
public void success( List<IDatabaseType> retVal ) { databaseTypeHelper = new DatabaseTypeHelper( retVal ); databaseDialog = new GwtDatabaseDialog( databaseTypeHelper, GWT.getModuleBaseURL() + "dataaccess-databasedialog.xul", connectionSetter ); //$NON-NLS-1$ } };
public DatabaseMetaReadHandler() { final ObjectFactory objectFactory = ClassicEngineBoot.getInstance().getObjectFactory(); final IDatabaseDialectService dialectService = objectFactory.get( IDatabaseDialectService.class ); this.databaseTypeHelper = new DatabaseTypeHelper( dialectService.getDatabaseTypes() ); }