[Treebase-devel] Resolving the hibernate_sequence problem & another db instance

[Vladimir G. <vla...@du...>]

On Jan 5, 2010, at 3:12 PM, youjun guo wrote:

> Hi, Vladimir,
>
> There are quit a few unit test failed due to the hibernate sequence  
> problem, do you want to join me and work on them?  What is the plan  
> or solution in your mind?
>


The plan, as Hilmar, you, and I decided at the beginning of the  
conference call on Monday, is to re-direct postgres tables to use  
hibernate_sequence, instead of their individual sequences, for new PK  
IDs.  (The other solution we discussed would be to  change Java code  
(or Hibernate XML mappings?) to use the tables' individual sequences  
instead of hibernate_sequence.)

Since the plan constitutes a significant adjustment to the DB schema,  
we should take care against messing up our only database instance,  
currently treebasedev.  So, Jon is now working on creating and  
populating another database instance (treebaseprod), that we will use  
as an "untouchable" production instance while we proceed with risky  
development work on treebasedev. That is, we started moving towards  
the infrastructure we have earlier outlined at http://sourceforge.net/apps/mediawiki/treebase/index.php?title=Infrastructure_and_Deployment_plan 
.  (There will be changes to names, ports, etc. -- I'll let everyone  
know as soon as they are done.)

So, we have to postpone these particular unit tests until these two db  
instances are in place.

As part of the above work, we are figuring out how to move the DB  
connection info (url, username, password) from the WAR file into  
tomcat's JNDI configuration. I'll be in touch as soon as we are ready  
to make TB code adjustments to achieve that.

--Vladimir