Hi Jason, Quick answers below:
On 15 Dec 2011 at 15:57, Richardson, Jason - FSA, Kansas City, MO wrote: > ********************************************************* > ****** 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-objstore-dflt > > > 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? No. > --- Should I just reuse the already created "isispoc-objstore-dflt"? Yes. > --- 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.) Not yet - only 1 DB is explicitly coupled to the object store. We need to discuss this. > --- Should the dependencies maven entry for the database drivers go into the > objectstore(s) pom or another pom? Preferably the objectstore 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 > > 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> Could be! I don't have my MS SQL Server details with me yet. But I can check later. For your custom reports, you'll have to get into the back end to write your own custom queries. Details will follow. Regards, Kevin
