Friday, March 21, 2008
I used my own existing copy of dcp with all the current changes checked out of cvs.
I updated all the institution specific properties in the dcp.properties file.
I added the institutions database information to jdbc in the dcp.properties file.
I dropped all tables and ran create.sql script
I had an issue where the application would throw a sql grammar on startup. The message read that dcp_cat_crs was an invalid object. I knew that this was a valid object and my guess was that DCP was looking at the wrong database. In my jdbc connection string found in the dcp.properties file I changed the string to specify a database by adding "/DCP2" after the port number.
I attempted to next run the security.sql but ran into another issue. The dcp_program view is made up of fields in the DARS dprog table. At this particular school the dcp database and dars database are seperate instances and platforms. They run sql server and oracle respectively. The dcp_program table is a view from which all the subsequent security tables are populated. I wanted these security tables in the dcp database. I copied over the dprog table from the dars database into the dcp database.
I now needed to configure DCP to handle two separate database connections. I did this buy uncommenting the bean information in dars-jdbc-ctx.xml . And commenting the above bean reference pointing to the shared database connection bean definition in the same context file.
In the dars.properties file I put in the separate (DARS) jdbc information to match the reference the dars-jdbc-ctx.xml mentioned above.
I again attempted to run the security.sql script. I ran into the error that I couldn't insert a specific value into the identity column.
I turned on the identity column feature for each of the security tables (list tables)
i created dcp_program and rmbacl views
i configured the dars settings in the dars.properties (values like comrec, evalws, etc)
audits weren't running properly so i checked values being entered into the dars tables via darwinia. The catlyt seemed to be added an extra character. I changed the term code settings in the dcp-yeartermtemplate-ctx.xml to be a single character (changed 08 to 8). The catlyt terms were off in value as well. Fall term is represented by 7 and not 8. I changed the start month value accordingly.
the security views needed to be moved to the dars database on oracle. i started by logging in as a new schema.
I used the create security sql script to create the tables and views in the dars database.
I updated all the institution specific properties in the dcp.properties file.
I added the institutions database information to jdbc in the dcp.properties file.
I dropped all tables and ran create.sql script
I had an issue where the application would throw a sql grammar on startup. The message read that dcp_cat_crs was an invalid object. I knew that this was a valid object and my guess was that DCP was looking at the wrong database. In my jdbc connection string found in the dcp.properties file I changed the string to specify a database by adding "/DCP2" after the port number.
I attempted to next run the security.sql but ran into another issue. The dcp_program view is made up of fields in the DARS dprog table. At this particular school the dcp database and dars database are seperate instances and platforms. They run sql server and oracle respectively. The dcp_program table is a view from which all the subsequent security tables are populated. I wanted these security tables in the dcp database. I copied over the dprog table from the dars database into the dcp database.
I now needed to configure DCP to handle two separate database connections. I did this buy uncommenting the bean information in dars-jdbc-ctx.xml . And commenting the above bean reference pointing to the shared database connection bean definition in the same context file.
In the dars.properties file I put in the separate (DARS) jdbc information to match the reference the dars-jdbc-ctx.xml mentioned above.
I again attempted to run the security.sql script. I ran into the error that I couldn't insert a specific value into the identity column.
I turned on the identity column feature for each of the security tables (list tables)
i created dcp_program and rmbacl views
i configured the dars settings in the dars.properties (values like comrec, evalws, etc)
audits weren't running properly so i checked values being entered into the dars tables via darwinia. The catlyt seemed to be added an extra character. I changed the term code settings in the dcp-yeartermtemplate-ctx.xml to be a single character (changed 08 to 8). The catlyt terms were off in value as well. Fall term is represented by 7 and not 8. I changed the start month value accordingly.
the security views needed to be moved to the dars database on oracle. i started by logging in as a new schema.
I used the create security sql script to create the tables and views in the dars database.
Labels: Technology
posted by Joe at
10:57 AM
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home