Generic DB write?

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • Generic DB write?

      Hi,

      today I tried to reverse the flow of data: write into my relational db

      ERROR:

      Source Code

      1. Loading data to Relational Database GenericDB not supported.

      the user is DB-god

      Is this by design?
      If not: what should I change to enable writing?

      ETL Server 3.0.1010 (the last standalone version I coud get)
    • PersistenceManager.java:

      Source Code

      1. public class PersistenceManager {
      2. PersistenceManager() {
      3. }
      4. /**
      5. * gets the specific persistence implementation for a given back-end
      6. * @param connection the connection to the back-end
      7. * @return the specific persistence back-end
      8. * @throws RuntimeException
      9. */
      10. public static IPersistence getPersistence(IConnection connection) throws RuntimeException {
      11. String server = connection.getServerName();
      12. //TODO: for the generic db this will not work, It should use the generic persistence
      13. if (server.equalsIgnoreCase("access"))
      14. return new Access(connection);
      15. // Persistence to Odbc is deprecated. For MS Access specific connection type
      16. if (server.equalsIgnoreCase("odbc"))
      17. return new Access(connection);
      18. if (server.equalsIgnoreCase("mysql"))
      19. return new Mysql(connection);
      20. if (server.equalsIgnoreCase("postgresql"))
      21. return new Postgres(connection);
      22. if (server.equalsIgnoreCase("sqlserver"))
      23. return new Sqlserver(connection);
      24. if (server.equalsIgnoreCase("derbyfile"))
      25. return new Derby(connection);
      26. if (server.equalsIgnoreCase("hsqldb"))
      27. return new Hsqldb(connection);
      28. if (server.equalsIgnoreCase("oracle"))
      29. return new Oracle(connection);
      30. if (server.equalsIgnoreCase("drillthrough"))
      31. return new Derby(connection);
      32. if (server.equalsIgnoreCase("internal"))
      33. return new Derby(connection);
      34. throw new RuntimeException("Loading data to Relational Database "+server+" not supported.");
      35. }
      36. }
      Display All


      looks like design to me ;(

      The post was edited 1 time, last by axi ().