Frequently Asked Questions

JDBC Populators

1. Can I combine multiple JDBCPopulators?
2. Does the net.sf.opk.populator.sql.DirectorySqlPopulator scan a directory recursively?
3. In what order does the net.sf.opk.populator.sql.DirectorySqlPopulator execute the SQL files?
4. Do you plan to add a non-SQL populator, say for Liquibase?

Data Sources

1. What do I need to use net.sf.opk.populator.PopulatingDataSource or net.sf.opk.populator.PopulatingXADataSource?

JDBC Populators

Can I combine multiple JDBCPopulators?

Yes. This is what the net.sf.opk.populator.CompositeJDBCPopulator is for.

---

Does the net.sf.opk.populator.sql.DirectorySqlPopulator scan a directory recursively?

No. It reads the directory contents, assuming all entries to be files (not a subdirectory).

---

In what order does the net.sf.opk.populator.sql.DirectorySqlPopulator execute the SQL files?

In lexicographic order, using String.compareTo(String).

---

Do you plan to add a non-SQL populator, say for Liquibase?

No. Although it would be a good idea, I do not need it. Such a populator would need to be in another project anyway, to prevent forcing people to have unwanted dependencies on their classpath.

Data Sources

What do I need to use net.sf.opk.populator.PopulatingDataSource or net.sf.opk.populator.PopulatingXADataSource?

A working javax.sql.DataSource or javax.sql.XADataSource, respectively. The versions from the JDBC Populator will reuse it, including its pooling capabilities.