The Oracle Lite Blog

I have recently started coding for the sync process and have determined that the packaging wizard will not fulfil my needs. I have to use a hybrid approach combining the packaging wizard with the Consolidator API to get my application deployed. The first hurdle I have was to determine table weight. I completed that using a table weight utility. Second step was to identify all the tables. Have done that too. I have counted 485 so far. I need to come up with the snapshots for all of those tables and I also need to determine which ones are shared map candidates. Anyhow, 485 tables is a lot of tables for the packaging wizard to load. It takes over 30 minutes to add the tables for snapshot definition. On top of that, since we are still in development mode of our online application, the database consitently changes. Tables are added, tables are dropped, and tables are altered. So I need to come up with a way to hit a moving target. Now I am writing an application that will query a table that I maintain that will hold all the information for a particular snapshot. I was thinking of using XML for this but decided the table would be a lot quicker for me to maintain. That table will hold publication item name, base table reference, DML enable, refresh mode, and conflict resolution. I have also added a table for all the regular indexes used. Using these two tables, I have come up with a dynamic way to build the application repository. So, whenever the DBAs go through a database rebuild exercises, I use the packaging wizard, actually just the jar file to deploy web files (class, jsp, jar, etc). Then I run a couple of java applications that will determine tables, weights and build my two tables that the consolidator will require to build the Web-to-go application. When I am finished coding the procedure, I will post the application here.I have been working on customizing the workspace for our project this week. Some things that I am adding to the workspace are:

• Expired passwords
• Password history
• Password encryption
• Locking accounts after n number of failed attempts
• Next week I will be working on using language specific property files.