bodington-developers

[Bodington-developers] Bodington 2.8.0 incompatible with MS SQL Server 2000

[M T. <m....@gm...>]

SGkgQWxsLAoKSSdtIGNvbmNlcm5lZCwgYXMgaXQgc2VlbXMgdGhhdCBCb2Rpbmd0b24ub3JnIGFy
ZSBubyBsb25nZXIgY2hlY2tpbmcgdGhhdApmdW5jdGlvbmFsaXR5IHdvcmtzIHdpdGggYWxsIHRo
ZSBzdXBwb3J0ZWQgZGF0YWJhc2UgcHJvZHVjdHMuIElmIEknbSBub3QKbWlzdGFrZW4gdGhlcmUg
aGF2ZSBiZWVuIG5vIGFubm91bmNlbWVudHMgcmVnYXJkaW5nIGNoYW5nZXMgdG8gdGhlIHN1cHBv
cnRlZApkYXRhYmFzZSBwcm9kdWN0cyBzaW5jZSB0aGUgYWRkaXRpb24gb2YgTXlTUUwuIFNvIE1T
IFNRTCBzZXJ2ZXIgc2hvdWxkIHN0aWxsCmJlIHN1cHBvcnRlZC4KCldlbGwgSSBkb24ndCB0aGlu
ayBpdCBpc+KApiA6bygKCkFzIEkndmUgaGFkIGdyZWF0IGZ1biB3b3JraW5nIHRocm91Z2ggYWxs
IG9mIHRoZSB1cGdyYWRlIHNjcmlwdHMgYWx0ZXJpbmcKdGhlbSB0byB3b3JrIHdpdGggTVMgU1FM
IHNlcnZlci4gSW4gcGFydGljdWxhciBjb25zdHJhaW50cyB0aGF0IGhhdmUgYmVlbgpzaG9ydGVu
ZWQgZm9yIG90aGVyIGRiIHByb2R1Y3RzIHdpdGggbm8gY29uc2lkZXJhdGlvbiBmb3IgaW5zdGFs
bGF0aW9ucyB0aGF0CmhhdmUgdGhlIGxvbmcgdmVyc2lvbnMuClRoZW4gZHVyaW5nIHRlc3Rpbmcg
SSBmb3VuZCB0aGF0IHRoZSBldmVudCBsb2cgbWV0aG9kIGluIGZhY2lsaXR5IGhhcyBiZWVuCnJl
LWNvZGVkIHRvIHVzZSBMSU1JVCBhbmQgT0ZGU0VUIHdpdGhpbiB0aGUgcXVlcnkuIEFzIEknbSBz
dXJlIG1vc3Qgb2YgeW91CmFyZSBhd2FyZSB0aGVzZSBhcmUgbm90IHN1cHBvcnRlZCBieSBNUyBT
UUwgc2VydmVyLiBJcyB0aGVyZSBhbnkgb3RoZXIKcHJvZHVjdCBzcGVjaWZpYyBTUUwgb3V0IHRo
ZXJlIHRoYXQgSSBzaG91bGQga25vdyBhYm91dD8KCkkga25vdyBpdCBpcyBub3QgdGhlIGVuZCBv
ZiB0aGUgd29ybGQsIHRoZXNlIHRoaW5ncyBjYW4gYmUgZml4ZWQhIEknbSBqdXN0Cmlycml0YXRl
ZC4uLiBTb3JyeSBmb3IgdGhlIHJhbnQhIEp1c3QgbmVlZGVkIHRvIGdldCBpdCBvdXQgb2YgbXkg
c3lzdGVtLCBhcwppdCByZWZsZWN0cyB0aGUgYm9kaW5ndG9uIHByb2R1Y3QgYmFkbHkuCgpGb3Ig
dGhlIDIuMTAgcmVsZWFzZSBJIHRoaW5rIHRoZSBwcm9qZWN0IG5lZWRzIHRvIGNvbnNpZGVyIGlm
IGl0IHNob3VsZApjb250aW51ZSB0byBzdXBwb3J0IE1TIFNRTCBzZXJ2ZXIhCgpCZXN0IFdpc2hl
cwoKLS0gCm0uY2hhM2wK

Re: [Bodington-developers] Bodington 2.8.0 incompatible with MS SQLServer 2000

[Adam M. <ada...@ou...>]

I think Leeds Uni are THE Bodington.org SQLServer test site as nobody else
uses it! 

 

I guess in our defence, we simply haven't had time to cover all the bases,
poor show I agree but such are the pressures of work.

 

You're right though, we should either support SQLServer or remove it from
the list of supported databases!

 

adam

 

  _____  

From: bod...@li...
[mailto:bod...@li...] On Behalf Of M
Thomas
Sent: 14 December 2006 13:49
To: Bodington developers
Subject: [Bodington-developers] Bodington 2.8.0 incompatible with MS
SQLServer 2000

 

Hi All,

I'm concerned, as it seems that Bodington.org are no longer checking that
functionality works with all the supported database products. If I'm not
mistaken there have been no announcements regarding changes to the supported
database products since the addition of MySQL. So MS SQL server should still
be supported. 

Well I don't think it is. :o(

As I've had great fun working through all of the upgrade scripts altering
them to work with MS SQL server. In particular constraints that have been
shortened for other db products with no consideration for installations that
have the long versions. 
Then during testing I found that the event log method in facility has been
re-coded to use LIMIT and OFFSET within the query. As I'm sure most of you
are aware these are not supported by MS SQL server. Is there any other
product specific SQL out there that I should know about? 

I know it is not the end of the world, these things can be fixed! I'm just
irritated... Sorry for the rant! Just needed to get it out of my system, as
it reflects the bodington product badly.

For the 2.10 release I think the project needs to consider if it should
continue to support MS SQL server! 

Best Wishes

-- 
m.cha3l 

Re: [Bodington-developers] Bodington 2.8.0 incompatible with MS SQLServer 2000

[M T. <m....@gm...>]

SW4gdGhlIHBhc3QgSSB3b3VsZCBoYXZlIGFncmVlIHdpdGggeW91IG9uIHlvdXIgZmlyc3QgcG9p
bnQsIGJ1dCBzaW5jZSB0aGUKcmV2aWV3IChhdCBVb0wpIG91ciBpbnZvbHZlbWVudCB3aXRoIHRl
c3RpbmcgYW5kIHJlbGVhc2VzIGhhcyBiZWVuIG1pbmltYWwKdG8gemVyby4gSSB1bmRlcnN0YW5k
IHRoZSBwcmVzc3VyZXMgdGhhdCBldmVyeW9uZSBpcyB1bmRlciwgSSBqdXN0IG5lZWRlZCB0bwpo
aWdobGlnaHQgdGhlIGlzc3VlIDpvKQoKQmVzdCBXaXNoZXMKCi0tIAptLmNoYTNsCgoKT24gMTQv
MTIvMDYsIEFkYW0gTWFyc2hhbGwgPGFkYW0ubWFyc2hhbGxAb3Vjcy5veC5hYy51az4gd3JvdGU6
Cj4KPiAgSSB0aGluayBMZWVkcyBVbmkgYXJlIFRIRSBCb2Rpbmd0b24ub3JnIFNRTFNlcnZlciB0
ZXN0IHNpdGUgYXMgbm9ib2R5Cj4gZWxzZSB1c2VzIGl0IQo+Cj4KPgo+IEkgZ3Vlc3MgaW4gb3Vy
IGRlZmVuY2UsIHdlIHNpbXBseSBoYXZlbid0IGhhZCB0aW1lIHRvIGNvdmVyIGFsbCB0aGUgYmFz
ZXMsCj4gcG9vciBzaG93IEkgYWdyZWUgYnV0IHN1Y2ggYXJlIHRoZSBwcmVzc3VyZXMgb2Ygd29y
ay4KPgo+Cj4KPiBZb3UncmUgcmlnaHQgdGhvdWdoLCB3ZSBzaG91bGQgZWl0aGVyIHN1cHBvcnQg
U1FMU2VydmVyIG9yIHJlbW92ZSBpdCBmcm9tCj4gdGhlIGxpc3Qgb2Ygc3VwcG9ydGVkIGRhdGFi
YXNlcyEKPgo+Cj4KPiBhZGFtCj4KPgo+ICAgLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
Cj4KPiAqRnJvbToqIGJvZGluZ3Rvbi1kZXZlbG9wZXJzLWJvdW5jZXNAbGlzdHMuc291cmNlZm9y
Z2UubmV0IFttYWlsdG86Cj4gYm9kaW5ndG9uLWRldmVsb3BlcnMtYm91bmNlc0BsaXN0cy5zb3Vy
Y2Vmb3JnZS5uZXRdICpPbiBCZWhhbGYgT2YgKk0KPiBUaG9tYXMKPiAqU2VudDoqIDE0IERlY2Vt
YmVyIDIwMDYgMTM6NDkKPiAqVG86KiBCb2Rpbmd0b24gZGV2ZWxvcGVycwo+ICpTdWJqZWN0Oiog
W0JvZGluZ3Rvbi1kZXZlbG9wZXJzXSBCb2Rpbmd0b24gMi44LjAgaW5jb21wYXRpYmxlIHdpdGgg
TVMKPiBTUUxTZXJ2ZXIgMjAwMAo+Cj4KPgo+IEhpIEFsbCwKPgo+IEknbSBjb25jZXJuZWQsIGFz
IGl0IHNlZW1zIHRoYXQgQm9kaW5ndG9uLm9yZyBhcmUgbm8gbG9uZ2VyIGNoZWNraW5nIHRoYXQK
PiBmdW5jdGlvbmFsaXR5IHdvcmtzIHdpdGggYWxsIHRoZSBzdXBwb3J0ZWQgZGF0YWJhc2UgcHJv
ZHVjdHMuIElmIEknbSBub3QKPiBtaXN0YWtlbiB0aGVyZSBoYXZlIGJlZW4gbm8gYW5ub3VuY2Vt
ZW50cyByZWdhcmRpbmcgY2hhbmdlcyB0byB0aGUgc3VwcG9ydGVkCj4gZGF0YWJhc2UgcHJvZHVj
dHMgc2luY2UgdGhlIGFkZGl0aW9uIG9mIE15U1FMLiBTbyBNUyBTUUwgc2VydmVyIHNob3VsZCBz
dGlsbAo+IGJlIHN1cHBvcnRlZC4KPgo+IFdlbGwgSSBkb24ndCB0aGluayBpdCBpc+KApiA6bygK
Pgo+IEFzIEkndmUgaGFkIGdyZWF0IGZ1biB3b3JraW5nIHRocm91Z2ggYWxsIG9mIHRoZSB1cGdy
YWRlIHNjcmlwdHMgYWx0ZXJpbmcKPiB0aGVtIHRvIHdvcmsgd2l0aCBNUyBTUUwgc2VydmVyLiBJ
biBwYXJ0aWN1bGFyIGNvbnN0cmFpbnRzIHRoYXQgaGF2ZSBiZWVuCj4gc2hvcnRlbmVkIGZvciBv
dGhlciBkYiBwcm9kdWN0cyB3aXRoIG5vIGNvbnNpZGVyYXRpb24gZm9yIGluc3RhbGxhdGlvbnMg
dGhhdAo+IGhhdmUgdGhlIGxvbmcgdmVyc2lvbnMuCj4gVGhlbiBkdXJpbmcgdGVzdGluZyBJIGZv
dW5kIHRoYXQgdGhlIGV2ZW50IGxvZyBtZXRob2QgaW4gZmFjaWxpdHkgaGFzIGJlZW4KPiByZS1j
b2RlZCB0byB1c2UgTElNSVQgYW5kIE9GRlNFVCB3aXRoaW4gdGhlIHF1ZXJ5LiBBcyBJJ20gc3Vy
ZSBtb3N0IG9mIHlvdQo+IGFyZSBhd2FyZSB0aGVzZSBhcmUgbm90IHN1cHBvcnRlZCBieSBNUyBT
UUwgc2VydmVyLiBJcyB0aGVyZSBhbnkgb3RoZXIKPiBwcm9kdWN0IHNwZWNpZmljIFNRTCBvdXQg
dGhlcmUgdGhhdCBJIHNob3VsZCBrbm93IGFib3V0Pwo+Cj4gSSBrbm93IGl0IGlzIG5vdCB0aGUg
ZW5kIG9mIHRoZSB3b3JsZCwgdGhlc2UgdGhpbmdzIGNhbiBiZSBmaXhlZCEgSSdtIGp1c3QKPiBp
cnJpdGF0ZWQuLi4gU29ycnkgZm9yIHRoZSByYW50ISBKdXN0IG5lZWRlZCB0byBnZXQgaXQgb3V0
IG9mIG15IHN5c3RlbSwgYXMKPiBpdCByZWZsZWN0cyB0aGUgYm9kaW5ndG9uIHByb2R1Y3QgYmFk
bHkuCj4KPiBGb3IgdGhlIDIuMTAgcmVsZWFzZSBJIHRoaW5rIHRoZSBwcm9qZWN0IG5lZWRzIHRv
IGNvbnNpZGVyIGlmIGl0IHNob3VsZAo+IGNvbnRpbnVlIHRvIHN1cHBvcnQgTVMgU1FMIHNlcnZl
ciEKPgo+IEJlc3QgV2lzaGVzCj4KPiAtLQo+IG0uY2hhM2wKPgo+IC0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0K
PiBUYWtlIFN1cnZleXMuIEVhcm4gQ2FzaC4gSW5mbHVlbmNlIHRoZSBGdXR1cmUgb2YgSVQKPiBK
b2luIFNvdXJjZUZvcmdlLm5ldCdzIFRlY2hzYXkgcGFuZWwgYW5kIHlvdSdsbCBnZXQgdGhlIGNo
YW5jZSB0byBzaGFyZQo+IHlvdXIKPiBvcGluaW9ucyBvbiBJVCAmIGJ1c2luZXNzIHRvcGljcyB0
aHJvdWdoIGJyaWVmIHN1cnZleXMgLSBhbmQgZWFybiBjYXNoCj4gaHR0cDovL3d3dy50ZWNoc2F5
LmNvbS9kZWZhdWx0LnBocD9wYWdlPWpvaW4ucGhwJnA9c291cmNlZm9yZ2UmQ0lEPURFVkRFVgo+
Cj4gX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KPiBCb2Rp
bmd0b24tZGV2ZWxvcGVycyBtYWlsaW5nIGxpc3QKPiBCb2Rpbmd0b24tZGV2ZWxvcGVyc0BsaXN0
cy5zb3VyY2Vmb3JnZS5uZXQKPiBodHRwczovL2xpc3RzLnNvdXJjZWZvcmdlLm5ldC9saXN0cy9s
aXN0aW5mby9ib2Rpbmd0b24tZGV2ZWxvcGVycwo+Cj4KPgo=

Re: [Bodington-developers] Bodington 2.8.0 incompatible with MS SQL Server 2000

[Matthew B. <mat...@ou...>]

M Thomas wrote:
> Hi All,

Afternoon.

> I'm concerned, as it seems that Bodington.org <http://Bodington.org> are
> no longer checking that functionality works with all the supported
> database products. If I'm not mistaken there have been no announcements
> regarding changes to the supported database products since the addition
> of MySQL. So MS SQL server should still be supported.

I believe bodington.org is a community, it relies on contributions from
people. Some people contribute code, some contribute testing, some
contribute advice and experience. Maybe we need more people to
contribute to testing on MS SQL?

I believe that MS SQL is still supported and it seems that you have
found a bug in the released version that should be fixed.

> Well I don't think it is… :o(
> 
> As I've had great fun working through all of the upgrade scripts
> altering them to work with MS SQL server. In particular constraints that
> have been shortened for other db products with no consideration for
> installations that have the long versions.

Could you elaborate on this? I believe that all the installer looks for
are tables. I don't think it does checking on constraint name.

> Then during testing I found that the event log method in facility has
> been re-coded to use LIMIT and OFFSET within the query. As I'm sure most
> of you are aware these are not supported by MS SQL server. Is there any
> other product specific SQL out there that I should know about?

The code is mine. And I wasn't aware that MS SQL didn't support
LIMIT/OFFSET. Is there an alternative way of paging SQL results in MS SQL?

> I know it is not the end of the world, these things can be fixed! I'm
> just irritated... Sorry for the rant! Just needed to get it out of my
> system, as it reflects the bodington product badly.

Having bugs in "released" code is never good and it needs fixing.

> For the 2.10 release I think the project needs to consider if it should
> continue to support MS SQL server!

As a side note I don't do much testing against MS SQL (maybe I should)
as I used HSQLDB (for convenience) during development and perform
additional tests against PostgreSQL as this is what we use in production.

Matthew

Re: [Bodington-developers] Bodington 2.8.0 incompatible with MS SQL Server 2000

[M T. <m....@gm...>]

SSdsbCBoYXZlIHRvIGdvIGJhY2sgYW5kIHJldmlldyBhbGwgdGhlIGVkaXRzIHRoYXQgSSd2ZSBt
YWRlIHRvIHRoZSB1cGdyYWRlCnNjcmlwdHMuCgpJcyB0aGVyZSBhbiBleHBsYW5hdGlvbiBmb3Ig
dGhlIHVzZXJfbmFtZSBub3QgYWNjZXB0aW5nIE5VTExzIGFueW1vcmU/CgpCZXN0IFdpc2hlcwoK
LS0gCm0uY2hhM2wKCgpPbiAxNC8xMi8wNiwgTWF0dGhldyBCdWNrZXR0IDxtYXR0aGV3LmJ1Y2tl
dHRAb3Vjcy5veC5hYy51az4gd3JvdGU6Cj4KPiBNIFRob21hcyB3cm90ZToKPiA+IEhpIEFsbCwK
Pgo+IEFmdGVybm9vbi4KPgo+ID4gSSdtIGNvbmNlcm5lZCwgYXMgaXQgc2VlbXMgdGhhdCBCb2Rp
bmd0b24ub3JnIDxodHRwOi8vQm9kaW5ndG9uLm9yZz4gYXJlCj4gPiBubyBsb25nZXIgY2hlY2tp
bmcgdGhhdCBmdW5jdGlvbmFsaXR5IHdvcmtzIHdpdGggYWxsIHRoZSBzdXBwb3J0ZWQKPiA+IGRh
dGFiYXNlIHByb2R1Y3RzLiBJZiBJJ20gbm90IG1pc3Rha2VuIHRoZXJlIGhhdmUgYmVlbiBubyBh
bm5vdW5jZW1lbnRzCj4gPiByZWdhcmRpbmcgY2hhbmdlcyB0byB0aGUgc3VwcG9ydGVkIGRhdGFi
YXNlIHByb2R1Y3RzIHNpbmNlIHRoZSBhZGRpdGlvbgo+ID4gb2YgTXlTUUwuIFNvIE1TIFNRTCBz
ZXJ2ZXIgc2hvdWxkIHN0aWxsIGJlIHN1cHBvcnRlZC4KPgo+IEkgYmVsaWV2ZSBib2Rpbmd0b24u
b3JnIGlzIGEgY29tbXVuaXR5LCBpdCByZWxpZXMgb24gY29udHJpYnV0aW9ucyBmcm9tCj4gcGVv
cGxlLiBTb21lIHBlb3BsZSBjb250cmlidXRlIGNvZGUsIHNvbWUgY29udHJpYnV0ZSB0ZXN0aW5n
LCBzb21lCj4gY29udHJpYnV0ZSBhZHZpY2UgYW5kIGV4cGVyaWVuY2UuIE1heWJlIHdlIG5lZWQg
bW9yZSBwZW9wbGUgdG8KPiBjb250cmlidXRlIHRvIHRlc3Rpbmcgb24gTVMgU1FMPwo+Cj4gSSBi
ZWxpZXZlIHRoYXQgTVMgU1FMIGlzIHN0aWxsIHN1cHBvcnRlZCBhbmQgaXQgc2VlbXMgdGhhdCB5
b3UgaGF2ZQo+IGZvdW5kIGEgYnVnIGluIHRoZSByZWxlYXNlZCB2ZXJzaW9uIHRoYXQgc2hvdWxk
IGJlIGZpeGVkLgo+Cj4gPiBXZWxsIEkgZG9uJ3QgdGhpbmsgaXQgaXPigKYgOm8oCj4gPgo+ID4g
QXMgSSd2ZSBoYWQgZ3JlYXQgZnVuIHdvcmtpbmcgdGhyb3VnaCBhbGwgb2YgdGhlIHVwZ3JhZGUg
c2NyaXB0cwo+ID4gYWx0ZXJpbmcgdGhlbSB0byB3b3JrIHdpdGggTVMgU1FMIHNlcnZlci4gSW4g
cGFydGljdWxhciBjb25zdHJhaW50cyB0aGF0Cj4gPiBoYXZlIGJlZW4gc2hvcnRlbmVkIGZvciBv
dGhlciBkYiBwcm9kdWN0cyB3aXRoIG5vIGNvbnNpZGVyYXRpb24gZm9yCj4gPiBpbnN0YWxsYXRp
b25zIHRoYXQgaGF2ZSB0aGUgbG9uZyB2ZXJzaW9ucy4KPgo+IENvdWxkIHlvdSBlbGFib3JhdGUg
b24gdGhpcz8gSSBiZWxpZXZlIHRoYXQgYWxsIHRoZSBpbnN0YWxsZXIgbG9va3MgZm9yCj4gYXJl
IHRhYmxlcy4gSSBkb24ndCB0aGluayBpdCBkb2VzIGNoZWNraW5nIG9uIGNvbnN0cmFpbnQgbmFt
ZS4KPgo+ID4gVGhlbiBkdXJpbmcgdGVzdGluZyBJIGZvdW5kIHRoYXQgdGhlIGV2ZW50IGxvZyBt
ZXRob2QgaW4gZmFjaWxpdHkgaGFzCj4gPiBiZWVuIHJlLWNvZGVkIHRvIHVzZSBMSU1JVCBhbmQg
T0ZGU0VUIHdpdGhpbiB0aGUgcXVlcnkuIEFzIEknbSBzdXJlIG1vc3QKPiA+IG9mIHlvdSBhcmUg
YXdhcmUgdGhlc2UgYXJlIG5vdCBzdXBwb3J0ZWQgYnkgTVMgU1FMIHNlcnZlci4gSXMgdGhlcmUg
YW55Cj4gPiBvdGhlciBwcm9kdWN0IHNwZWNpZmljIFNRTCBvdXQgdGhlcmUgdGhhdCBJIHNob3Vs
ZCBrbm93IGFib3V0Pwo+Cj4gVGhlIGNvZGUgaXMgbWluZS4gQW5kIEkgd2Fzbid0IGF3YXJlIHRo
YXQgTVMgU1FMIGRpZG4ndCBzdXBwb3J0Cj4gTElNSVQvT0ZGU0VULiBJcyB0aGVyZSBhbiBhbHRl
cm5hdGl2ZSB3YXkgb2YgcGFnaW5nIFNRTCByZXN1bHRzIGluIE1TIFNRTD8KPgo+ID4gSSBrbm93
IGl0IGlzIG5vdCB0aGUgZW5kIG9mIHRoZSB3b3JsZCwgdGhlc2UgdGhpbmdzIGNhbiBiZSBmaXhl
ZCEgSSdtCj4gPiBqdXN0IGlycml0YXRlZC4uLiBTb3JyeSBmb3IgdGhlIHJhbnQhIEp1c3QgbmVl
ZGVkIHRvIGdldCBpdCBvdXQgb2YgbXkKPiA+IHN5c3RlbSwgYXMgaXQgcmVmbGVjdHMgdGhlIGJv
ZGluZ3RvbiBwcm9kdWN0IGJhZGx5Lgo+Cj4gSGF2aW5nIGJ1Z3MgaW4gInJlbGVhc2VkIiBjb2Rl
IGlzIG5ldmVyIGdvb2QgYW5kIGl0IG5lZWRzIGZpeGluZy4KPgo+ID4gRm9yIHRoZSAyLjEwIHJl
bGVhc2UgSSB0aGluayB0aGUgcHJvamVjdCBuZWVkcyB0byBjb25zaWRlciBpZiBpdCBzaG91bGQK
PiA+IGNvbnRpbnVlIHRvIHN1cHBvcnQgTVMgU1FMIHNlcnZlciEKPgo+IEFzIGEgc2lkZSBub3Rl
IEkgZG9uJ3QgZG8gbXVjaCB0ZXN0aW5nIGFnYWluc3QgTVMgU1FMIChtYXliZSBJIHNob3VsZCkK
PiBhcyBJIHVzZWQgSFNRTERCIChmb3IgY29udmVuaWVuY2UpIGR1cmluZyBkZXZlbG9wbWVudCBh
bmQgcGVyZm9ybQo+IGFkZGl0aW9uYWwgdGVzdHMgYWdhaW5zdCBQb3N0Z3JlU1FMIGFzIHRoaXMg
aXMgd2hhdCB3ZSB1c2UgaW4gcHJvZHVjdGlvbi4KPgo+IE1hdHRoZXcKPgo+Cj4gLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLQo+IFRha2UgU3VydmV5cy4gRWFybiBDYXNoLiBJbmZsdWVuY2UgdGhlIEZ1dHVyZSBv
ZiBJVAo+IEpvaW4gU291cmNlRm9yZ2UubmV0J3MgVGVjaHNheSBwYW5lbCBhbmQgeW91J2xsIGdl
dCB0aGUgY2hhbmNlIHRvIHNoYXJlCj4geW91cgo+IG9waW5pb25zIG9uIElUICYgYnVzaW5lc3Mg
dG9waWNzIHRocm91Z2ggYnJpZWYgc3VydmV5cyAtIGFuZCBlYXJuIGNhc2gKPiBodHRwOi8vd3d3
LnRlY2hzYXkuY29tL2RlZmF1bHQucGhwP3BhZ2U9am9pbi5waHAmcD1zb3VyY2Vmb3JnZSZDSUQ9
REVWREVWCj4KPiBfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
Xwo+IEJvZGluZ3Rvbi1kZXZlbG9wZXJzIG1haWxpbmcgbGlzdAo+IEJvZGluZ3Rvbi1kZXZlbG9w
ZXJzQGxpc3RzLnNvdXJjZWZvcmdlLm5ldAo+IGh0dHBzOi8vbGlzdHMuc291cmNlZm9yZ2UubmV0
L2xpc3RzL2xpc3RpbmZvL2JvZGluZ3Rvbi1kZXZlbG9wZXJzCj4KPgo+Cj4K

Re: [Bodington-developers] Bodington 2.8.0 incompatible with MS SQL Server 2000

[Matthew B. <mat...@ou...>]

M Thomas wrote:
> I'll have to go back and review all the edits that I've made to the
> upgrade scripts.

Cool.

> Is there an explanation for the user_name not accepting NULLs anymore?

user_name in the pass_phrase table?

John is probably the best person to answer that as he changed it at 1:51
on 22nd January 2000.

My guess would be that if the database can never have nulls in it you
never need to check in the Java code to see if PassPhrase.getUserName()
returns null.

Re: [Bodington-developers] Bodington 2.8.0 incompatible with MS SQL Server 2000

[Peter C. <Pet...@me...>]

PiBGcm9tOiBNYXR0aGV3IEJ1Y2tldHQgDQo+IENvdWxkIHlvdSBlbGFib3JhdGUgb24gdGhpcz8g
SSBiZWxpZXZlIHRoYXQgYWxsIHRoZSBpbnN0YWxsZXIgbG9va3MgZm9yIA0KPiBhcmUgdGFibGVz
LiBJIGRvbid0IHRoaW5rIGl0IGRvZXMgY2hlY2tpbmcgb24gY29uc3RyYWludCBuYW1lLiANCg0K
QWZ0ZXIgSSBhZGRlZCBzb21lID4zMC1jaGFyYWN0ZXIgY29uc3RyYWludHMgaW4gMi40LCB5b3Ug
c2hvcnRlbmVkIHRoZWlyIG5hbWVzICh0aGUgbG9uZyBuYW1lcyBmYWlsZWQgb24gUG9zdGdyZVNR
TCBhcyBJIHJlY2FsbCkuICBJbiBhIGxhdGVyIHVwZ3JhZGUgc2NyaXB0IHRvIDIuOCwgdGhlIGNv
bnN0cmFpbnRzIGFyZSByZWZlcmVuY2VkIGJ5IHRoZWlyIHNob3J0ZW5lZCBuYW1lcy4gIEknbSBu
b3QgYXdhcmUgdGhhdCBMZWVkcyBldmVyIHJhbiBhbnl0aGluZyB0byBkcm9wIHRoZSBvcmlnaW5h
bCAobG9uZyBuYW1lZCkgY29uc3RyYWludHMgYW5kIGdldCB0aGUgc2hvcnRlciBvbmVzOyBJJ20g
bm90IHN1cmUgdGhlIGNoYW5nZSBldmVyIG1hZGUgaXRzIHdheSBpbnRvIGFuIHVwZ3JhZGUgc2Ny
aXB0Lg0KDQo+IFRoZSBjb2RlIGlzIG1pbmUuIEFuZCBJIHdhc24ndCBhd2FyZSB0aGF0IE1TIFNR
TCBkaWRuJ3Qgc3VwcG9ydCANCj4gTElNSVQvT0ZGU0VULiBJcyB0aGVyZSBhbiBhbHRlcm5hdGl2
ZSB3YXkgb2YgcGFnaW5nIFNRTCByZXN1bHRzIGluIE1TIFNRTD8gDQoNCk5vdCB0byBteSBrbm93
bGVkZ2UuICBZb3UgY2FuIHNlbGVjdCB0b3AgbiBvciB0b3AgbiUsIGJ1dCBJJ20gbm90IGF3YXJl
IG9mIGFueSBwYWdpbmcgc3VwcG9ydCBhdCBhbGwuDQoNCi0gUGV0ZXINCg0K

Re: [Bodington-developers] Bodington 2.8.0 incompatible with MS SQL Server 2000

[Matthew B. <mat...@ou...>]

Peter Crowther wrote:
>> From: Matthew Buckett Could you elaborate on this? I believe that
>> all the installer looks for are tables. I don't think it does
>> checking on constraint name.
> 
> After I added some >30-character constraints in 2.4, you shortened
> their names (the long names failed on PostgreSQL as I recall).  In a
> later upgrade script to 2.8, the constraints are referenced by their
> shortened names.  I'm not aware that Leeds ever ran anything to drop
> the original (long named) constraints and get the shorter ones; I'm
> not sure the change ever made its way into an upgrade script.

You've got a better memory than me.

I see on LogBookPage.sql there is a commit note that a database column
was shorterned and looking at the diff it was but do you remember what
the constraint that caused problems was?

>> The code is mine. And I wasn't aware that MS SQL didn't support 
>> LIMIT/OFFSET. Is there an alternative way of paging SQL results in
>> MS SQL?
> 
> Not to my knowledge.  You can select top n or top n%, but I'm not
> aware of any paging support at all.

Yeah, after a bit of digging it seems like you have to hack it:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/scalenethowto05.asp

-- 
 Matthew Buckett