Re: [stellation-res] SQLServer

["Mark C. Chu-Carroll" <mcc@xxxxxxxxxxxxxx>]

On Fri, 2002-12-13 at 02:20, dben@xxxxxxxxxxxx wrote:
> Sorry folks, I've found the repository use cases and/or test cases would 
> still be good!

I'm in a major hurry right now, so I can't reply at length; I'll try to
send a more detailed note over the weekend, but I didn't want you to
feel ignored, and I'm one of the principal architects of the database
layer.

Unfortunately, we don't yet have a set of database specific tests. It's
one of the things on our todo list. Right now, the unfortunate situation
is that you have to just go straight ahead and run the full repository
tests with your new database code to test it.

Here's what we really use:
- Types: Integers, Strings (whatever string type makes sense on your
  database. We use mainly TEXT on Postgres, and VARCHAR elsewhere),
  and BLOBs. The BLOB tends to be one of the sticker spots.
- JDBC with full long transaction.
- Primary Key and Foreign key constraints.

	-Mark



> 
> > I'm new to this so let me know if I get the etiquette wrong.
> > 
> > I want to add SQLServer support to Stellation this weekend and wondered 
> if 
> > there are any use cases/test cases written for database connectivity 
> (UML 
> > diagrams would be good too!).  
> > 
> > These probably exist in the repository but I haven't been able to locate 
> > it as yet (found the general eclipse one but no Stellation under it) so 
> am 
> > working with the code downloaded from the Stellation home page.
> > 
> > The code seems straightforward enough, but could you let me know if 
> there 
> > are any traps for new players that I should know about.
> > 
> > Regards,
> > Dale Bennett.
> > _______________________________________________
> > stellation-res mailing list
> > stellation-res@xxxxxxxxxxxxxxx
> > http://dev.eclipse.org/mailman/listinfo/stellation-res
> > 
> _______________________________________________
> stellation-res mailing list
> stellation-res@xxxxxxxxxxxxxxx
> http://dev.eclipse.org/mailman/listinfo/stellation-res
-- 
Mark Craig Chu-Carroll,  IBM T.J. Watson Research Center  
*** The Stellation project: Advanced SCM for Collaboration
***		http://www.eclipse.org/stellation
*** Work Email: mcc@xxxxxxxxxxxxxx  ------- Personal Email: markcc@xxxxxxxxxxx