I believe this store should never have been placed in slide but rather in the proposals section, since it was never really tested!!
A later version (J2EENodeStore) was never committed but posted to the list works directly with SQLServer and DB2. I have had some really nice performance results with this store! You really should use this store instead! /Jacob -----Original Message----- From: Rob Tomlin [mailto:[EMAIL PROTECTED] Sent: 2. juli 2003 12:47 To: MAIL_Slide Users List (E-mail) Subject: SQL Server 2000, StandardRDBMSAdapter and SQLServerSchema... Hi, I am trying to use StandardRDBMSAdapter and JDBCStore to connect to a SQL Server 2000 database, with the view to move to using the J2EEStore further down the line. I have come across various problems: 1. SQLServerSchema is incomplete. SLIDE_REVISION_LATEST table is missing and SLIDE_PERMISSION is incorrectly named SLIDE_REVISION_PERMISSION. 2. SQL Server 2000 does not have a boolean type and will not except true or false as values for queries. 3. The method removeRevisionDescriptors violates foriegn key constraints. In investigating this problem, it appears to me that the logic in the method is wrong. If the intention is to remove all revision descriptors for a given uri then surely a delete must be performed per revision i.e. sql.setLength(0); sql.append("SELECT REVISION_ID FROM SLIDE_REVISION ") .append("WHERE URI_ID = ").append(uriId); rs = stmt.executeQuery(sql.toString()); stmt2 = conn.createStatement(); while(rs.next()) { <---------------------- is currently if... In fact should the delete not just be performed based on the uri rather that the revision_id... These problems have led me to the following questions: 1. Is there a SQLServerAdapter availiable that I have not found ? 2. Is there a completed script to create a SQL server 2000 database ? 3. Is there discussion/documentation for the new schema. 4. Am I missing something ? Cheers Rob Tomlin --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
