Oracle
DBUnit is very nice for testing database content changes made by an application. You define in XML the data including the structure of your tables (dataset.xml). Simple_Data is the name of the table and each column is a attribute in the xml doc with the content value e.g. id with value 1. The Getting Started [...]
Continue reading about Dbunit with JUnit 4.x and Spring for testing Oracle DB Application
If you are using DBUnit as tool for set up test environment in your oracle 10g then you have to provide the username of course. Normally it isn’t case sensitive in most tools. The jdbc driver or sqlplus let you create connection with lower case. DBUnit ask the DataBaseMetaData to get the defined tables in [...]
Continue reading about jdbc DataBaseMetaData + oracle 10g + dbunit + username..
Since Oracle 10g dropped tables goes into a recycle bin: http://orafaq.com/node/968. These tables aren’t visible inside the admin site under the user but if you are using JDBC to access the schema. Thought first of a bug in SQL Explorer when i saw the huge list of tables starting with BIN$… Every time you drop [...]
Continue reading about JDBC Connection + Oracle 10g + recycle bin…