[opencms-dev] SAPDB reports Missing delimiter in updateAllResourceFlags()

[Scott Newham]

Hi Folks,

On installation, I get a missing delimiter error. There was a msg posted a
long time ago about this, but no solution.

My problem is that I have three installations of OpenCMS, all running
against SAPDB. Two work beautifully, and one fails to complete its
installation with the error (upsidedown as it appears in the status window):

1130:  at
com.opencms.file.genericSql.CmsDbAccess.updateAllResourceFlags(CmsDbAccess.j
ava:12727)
1129: root cause was com.sap.dbtech.jdbc.exceptions.DatabaseException:
[-5016] (at 39): Missing delimiter: =
1128: com.opencms.core.CmsException: 4 Sql exception. Detailed error:
[com.opencms.file.genericSql.CmsDbAccess.updateAllResourceFlags()] [-5016]
(at 39): Missing delimiter: =.
1127:    !!! Exception com.opencms.core.CmsException:
[com.opencms.file.genericSql.CmsDbAccess.updateAllResourceFlags()] [-5016]
(at 39): Missing delimiter: =
1126: ------ Checking filesystem links ...

At this point I can browse the newly created tables and there is data there.
CMS_RESOURCES is, as far as I can see, correct.

The version that does not complete the installation is:

Server 1:
RH Linux ES
Tomcat 4.1.20
Sun JDK 1.4.2
JDBC connection string:
jdbc:sapdb://dbdw1/dwdb?sqlmode=ORACLE&trace=jdbc_trace.log
OpenCMS 5.0.1
(I've also tried this with openCMS5.0 with the same error).

Server 2
RH Linux ES
SAPDB 7.4 (from RPMs)

The difference between this and the other two installations are:
1. They run on other OSes (one Win2000 the other Debian)
2. On the other two installations, the SAPDB and TOMCAT are on the same
machine.

Any suggestions would be most gleefully received. I'm under a very tight
deadline to go to production.

Thanks in advance,

Scott