@Test public void testUpdateConnection() { try { InMemoryConnectionServiceImpl serv = new InMemoryConnectionServiceImpl(); List<IDatabaseConnection> conns = serv.getConnections(); assertTrue(conns != null && conns.size() == 0); IDatabaseConnection connection = new DatabaseConnection(); connection.setName("Connection 1"); connection.setUsername("admin"); connection.setPassword("password"); serv.addConnection(connection); conns = serv.getConnections(); assertTrue(conns.get(0).getUsername().equals("admin")); assertTrue(conns.get(0).getPassword().equals("password")); connection = new DatabaseConnection(); connection.setName("Connection 1"); connection.setUsername("root"); connection.setPassword("pass"); serv.updateConnection(connection); List<IDatabaseConnection> conns1 = serv.getConnections(); assertTrue(conns1 != null && conns1.size() > 0); assertTrue(conns1.size() == conns.size()); assertTrue(conns1.get(0).getUsername().equals("root")); assertTrue(conns1.get(0).getPassword().equals("pass")); } catch (Exception ex) { fail(); } }
private static IDatabaseConnection createConnectionObject() { IDatabaseConnection connection = new DatabaseConnection(); connection.setAccessType(DatabaseAccessType.NATIVE); // connection.setDriverClass("org.hsqldb.jdbcDriver"); // connection.setUrl("jdbc:hsqldb:hsql://localhost:9001/sampledata"); connection.setUsername("pentaho_user"); connection.setPassword("password"); connection.setName(CONNECTION_NAME); return connection; }
@Override public String testConnection(IDatabaseConnection connection) { try { connection.setPassword( ConnectionServiceHelper.getConnectionPassword( connection.getName(), connection.getPassword())); return super.testConnection(connection); } catch (ConnectionServiceException e) { return super.testConnection(connection); } }