I finally have the quickstart application up and running in Eclipse Indigo and
the base quickstart check into our local svn.
Now for some background, on what I'm hoping to accomplish for my Proof of
Concept. It will be a reporting and data display application in its first
iteration and will use Mainframe DB2 and MS SQL SERVER 2008.
It will support:
*** The built in Isis Viewers.
*** Searching and retrieval of the database tables as domain objects
(search by the table key, searching by foreign keys to retrieve related objects
from tables)
*** a couple of "report" type searches that will span multiple tables
from both sql server and db2 to create a report view of partial domain objects
whose values are summed. For example payment transactions that occurred for a
given fiscal year and what business status they are currently in and how much
they total per status.
I am hoping to get experience building basic object retrieval and cross domain
object traversal and also a summary collation of data from millions of database
records. This will show the value that ISIS can provide for my organization.
One of the issues that I will need to overcome is that the database tables are
legacy tables from mainframe Cobol applications so many times I may have to
pull data from several tables and even two databases to actually retrieve
business contexts (depending on what reports I want to include).
*********************************************************
****** However I have a few questions regarding how to start adding my own
functionality into the quickstart app.
*********************************************************
Here is a list of the projects that were created.
isispoc
isispoc-dom
isispoc-fixture
isispoc-objstore-dflt
isispoc-quickrun
isispoc-test-bdd
isispoc-test-junit
isispoc-viewer-html
isispoc-viewer-json
isispoc-viewer-scimpi
isispoc-viewer-wicket
isispoc-viewer-xhtml
1. I want to implement a MS SQL Server and Mainframe DB2 Object store.
--- From a framework convention point of view how should I go about doing this?
--- Should I create a new maven module for the Object Stores?
--- Should I just reuse the already created "isispoc-objstore-dflt"?
--- Should I create two different Object stores? 1 for each database piece.
(the proof of concept I'm using will utilize both databases, as the project as
the system I'm modeling utilizes both.)
--- Should the dependencies maven entry for the database drivers go into the
objectstore(s) pom or another pom?
2. If I read the isis site correctly this is the basis for what I need to put
into the isis.properties for SQL Server 2008. Is there anything else I need?
isis.persistor.sql.jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
isis.persistor.sql.jdbc.connection=jdbc:sqlserver://<serverIP>:<port>;databaseName=<dbname>;selectMethod=cursor;sendStringParametersAsUnicode=false
isis.persistor.sql.jdbc.user=<dbloginId>
isis.persistor.sql.jdbc.password=<dbloginpw>
Jason Richardson
