Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Best Practices for working with SQL Developer Unit Test module

PyrocksNov 27 2014

Hi,

My company wants to start using SQL Developer as our DB Unit Testing tool.

However, we are not quite sure how to maintain it in our source control, and how to use the files once they are there.

I'll explain:

  1. Granularity of items kept in Source Control:
    When Exporting a Suite - the generated XML file contains the Suite definition but also the definitions all of it's linked Suites, Tests, Libraries etc.
    We thought about Using a root Suite to run all the other Suites and Tests in one go and keep that in in our source control- but this is problematic since each developer would be locking the entire UT tree for his/her modifications - No working in parallel (SQL Developer doesn't provide means for merging or comparing exported UT XMLs or UT repositories).
    So now we are thinking about saving all of the pieces separately - Tests and Library definitions, and not working with Suites at all. This would allow developers to check in just what they are working on and not interfere other developers.
    The problem with this approach is that it would more troublesome to import all of the separate files, let alone having to run multiple (can get to hundreds of) tests instead  of a single Suite (I also assume running would take more time).
    It would have been best if there was an option to export Suites with just the references to the used items but without their actual definition, or alternatively, some way to automatically generate Suites for imported tests according to some rules.
  2. Repositories:
    Is it better to have a single master UT repository for all developers to use for their testing - or each developer working on his own repository (importing from the master) to not interfere/override someone else's work?
    Since Repository creation can't be done through CLI (command line interface)- I assume duplicating the UT Repository schema would work.
  3. CLI
    There are a bunch of things doable from the GUI, but aren't doable through CLI.
    This puts sticks in the wheels of trying to automate the unit testing process - which leads us to sometime reverse engineer what the GUI does and implement it on our own using packages on the UT repository (in example - purging the repository or the results).

   

Any guidance would be appreciated.

Thanks.

Comments

sb92075
user454349 wrote:
Hi,
To set up DB environment similar to my Office, I installed Oracle 9i on my Windows 7(64 Bit)
V9 Oracle has been obsoleted & unsupported this whole Century & never certified on Windows 7

why are you willing to upgrade & use new & supported OS but unwilling to do the same with Oracle?
Srini Chavali-Oracle
Pl identify which version of Win 7. The only database versions certified on Win 7 Professional or higher are 10.2.0.5 and 11gR2. You cannot install 9i on Win 7 and expect it to work without issues.

HTH
Srini
Sriram Muraleedaran
Hi Srini and sb92075

thanks for the reply. i have windows 7 basic home edition..I want to set up the environment same as my office ..but we have win xp at office..I am afraid of any downward compatibility issues if i install oracle 10g and develop my forms and try to run in my office...

Regards
Sri
sb92075
hokoba wrote:
Hi Srini and sb92075

thanks for the reply. i have windows 7 basic home edition..
no version of Oracle is ever certified on any Home edition of any Windows version
Srini Chavali-Oracle
If you want to emulate what you have in your office, then you will need to install Win XP Pro on your machine (or in a VM on your nachine) - I do not see any other option.

HTH
Srini
Helios-GunesEROL
Hi Sri;

You can go with

1. Download OEL 5.x version from e-delivery.
2. Create VM machine(make googling you can find many good site)
3. Use your OEL software and create Vm linux machine on your win7 laptop
4. Install 11g and use it for your purpose

Pelase review:

Oracle Database on Unix AIX,HP-UX,Linux,Mac OS X,Solaris,Tru64 Unix Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2) [ID 169706.1]
How to Install Oracle 10gR2 on MS Windows 7 / Windows 2008R2 [ID 1173433.1]
Is Microsoft Windows 7 certified to install/run Oracle Database Server/Client ? [ID 952302.1]
Statement of Direction: Oracle Database 11g Release 2 - Microsoft Windows 7 and Windows Server 2008 R2 [ID 867040.1]

Regard
Helios
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 25 2014
Added on Nov 27 2014
0 comments
508 views