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
23 Comments:
Considerably, the blog post is actually the greatest on this worthy topic. I concur with your decisions and will thirstily look forward to see your approaching updates. Saying thanks will not just be adequate, for the phenomenal lucidity in your writing. I will at once grab your feeds to stay informed of any updates. Delightful work and much success in your business endeavors! Have a nice day
Considerably, the blog post is actually the greatest on this worthy topic. I concur with your decisions and will thirstily look forward to see your approaching updates. Saying thanks will not just be adequate, for the phenomenal lucidity in your writing. I will at once grab your feeds to stay informed of any updates. Delightful work and much success in your business endeavors! Have a nice day
Nice information, many thanks to the author. It is incomprehensible to me now, but in general, the usefulness and significance is overwhelming. Thanks again and good luck!
I’ve turn out to be a devoted admirer of the website for some time but not actually supplied just one thing back, I hope to alter that within the future with more conversation.Thanks for another new addition to the internet website.
Awesome post Jeff! You guys are doing awesome work!
This post is impressive! I’m gonna put this in the bookmarks before I lose the link I don’t believe I’ll ever find my way back here again otherwise
I very adore your own posting choice, very remarkable.
I have been searching for this information and finally found it. Thanks!
Thank you for developing this website. The stories here are worth reading many times over in order to refresh us time and time again to do good and positive things and inspire or influence others to do the same.
Very interesting blog post. Your blog is swiftly getting to be among my top picks.
I am not a person who is easily delighted but I have to say your work blew me away. So much ideas and relevant detaisl that you put into it made me see your point of view. Thanks for communicating your reasonable inputs.
Outstanding article, a bunch of fine knowledge. I am going to point out to my girlftriend and ask them the things they think.
I am not a person who is easily delighted but I have to say your work blew me away. So much ideas and relevant detaisl that you put into it made me see your point of view. Thanks for communicating your reasonable inputs.
Very nice, gives me a lot of inspiration being right in the midst of a redesign. It’s all in the details and comment forms are definitely overlooked more often than not. Time well spent on this post.
What a world we stay in!!?! It just shows us all as much as the fools we are…
Really love all these stories.. have been reading them daily. Please add more if you have any… Thanks a lot again for this awesome work.
I Love You. I really do. I would even buy you flowers and dinner for what you have shared with us! Thanks to you I now have a working blog.
Nice site, I envy it, but it seems a little weird when under mozzila browser, keep it moving:)
Nice site, I envy it, but it seems a little weird when under mozzila browser, keep it moving:)
Only want to say your article is as tonishing. The clearness in your post is simply spectacular and i can take for granted you are an expert on this field. Well with your permission allow me to grab your rss feed to keep up to date with succeeding post. Thanks a million and please keep up the ac complished work.
Very good article I enjoy your website keep up the great blog posts
I’ve bookmarked this because I found it interesting. I would be very interested to hear more news on this. Thanks!
This is the 2nd instance I have encountered your site in the last few weeks. Seems like I ought to take note of it.
Post a Comment
Subscribe to Post Comments [Atom]
<< Home