Simple Set up help

[stepwise]

Hi there,

I am very new to Spring. I am having a hard time getting set up just to run a simple JUnit test.

I am using an Oracle database, TopLink and JUnit.

I need help with basic configuration (i.e. applicationContext.xml) and information on how to run a test outside of a container/server.

Is there some site that walks through a basic example of this? In the format of

1. Define Toplink object
2. Configure sessions.xml
3. Configure applicationContext.xml
4. Define DAO interface
etc, etc.


ANY help and information would be greatly appreciated.

P.S. I have downloaded and looked at the PetClinic sample but it uses HSQ for its database and I am unable to transfer what is done there to what I need to do.

Many thanks!

[Costin Leau]

I haven't used toplink but you can look at the configuration for the petclinic toplink. That should take of the DAO part, for moving to Oracle you have to just change the jdbc driver and URL of the database.

[slimslenderslacks]

Sounds like you just need help setting up the PetClinic schema in an Oracle database.

I'll put together a .sql script that you can run in from sqlplus to create the PetClinic schema in an Oracle database. Just email me at james.x.clark@oracle.com and I'll send it to you.

After creating the schema, you'll need to make two changes to applicationContext-toplink.xml:

• datasource bean will need to be pointed at the Oracle Database
  sessionFactory bean will need a different databasePlatform property (for Oracle)

After that, you should be able to get the PetClinic sample running on Oracle DB (which should provide a good starting point for you to study the structure of the app)

Also try to take advantage of the Mapping Workbench project provided. This give you a graphical view of how the PetClinic Objects are mapped into the database.