AW: [opencms-dev] (6b3) Parameter index out of bounds

[Michael Moossen]

Hi, Jorge!

   The underlying query has been improved and now it uses more params,
try to use the generic sql query removing the
C_RESOURCES_GET_RESOURCE_WITH_PROPERTYDEF query definition from the
org/opencms/db/postgresql/queries.properties file.

Regards,

Michael Moossen
Alkacon Software - The OpenCms Experts
http://www.alkacon.com



-----Ursprüngliche Nachricht-----
Von: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] Im Auftrag von Jorge González
Gesendet: Freitag, 6. Mai 2005 16:54
An: 'The OpenCms mailing list'
Betreff: [opencms-dev] (6b3) Parameter index out of bounds


Hi list, i've got an exception in the setup process, listed here:

The system seems to work ok, but i can't sleep at night so please help
me...

centos 3
jboss 3.2.7
psql (PostgreSQL) 7.3.9-RH ( Could be because i use 7.3.x instead of
7.4.x ?? )

Thanks


----------------
15:39:20,033 INFO  [CmsFlexCache] Complete FlexCache cleared - clear()
called 15:39:20,041 ERROR [CmsSqlException]
[org.opencms.db.postgresql.CmsVfsDriver] where:
org.opencms.db.generic.CmsVfsDriver.readResourcesWithProperty(CmsVfsDriv
er.j
ava:1497), why: org.postgresql.util.PSQLException: Parameter index out
of
range.query: SELECT DISTINCT
CMS_ONLINE_STRUCTURE.STRUCTURE_ID,CMS_ONLINE_STRUCTURE.RESOURCE_ID,CMS_O
NLIN
E_STRUCTURE.RESOURCE_PATH,CMS_ONLINE_STRUCTURE.STRUCTURE_STATE,CMS_ONLIN
E_ST
RUCTURE.DATE_RELEASED,CMS_ONLINE_STRUCTURE.DATE_EXPIRED,CMS_ONLINE_RESOU
RCES
.RESOURCE_ID,CMS_ONLINE_RESOURCES.RESOURCE_TYPE,CMS_ONLINE_RESOURCES.RES
OURC
E_FLAGS,CMS_ONLINE_RESOURCES.RESOURCE_STATE,CMS_ONLINE_RESOURCES.DATE_CR
EATE
D,CMS_ONLINE_RESOURCES.DATE_LASTMODIFIED,CMS_ONLINE_RESOURCES.USER_CREAT
ED,C
MS_ONLINE_RESOURCES.USER_LASTMODIFIED,CMS_ONLINE_RESOURCES.PROJECT_LASTM
ODIF
IED AS
LOCKED_IN_PROJECT,CMS_ONLINE_RESOURCES.RESOURCE_SIZE,CMS_ONLINE_RESOURCE
S.SI
BLING_COUNT,CMS_ONLINE_RESOURCES.PROJECT_LASTMODIFIED FROM
((CMS_ONLINE_STRUCTURE INNER JOIN CMS_ONLINE_RESOURCES ON
CMS_ONLINE_STRUCTURE.RESOURCE_ID=CMS_ONLINE_RESOURCES.RESOURCE_ID) INNER
JOIN CMS_ONLINE_PROPERTIES ON
(CMS_ONLINE_PROPERTIES.PROPERTY_MAPPING_ID=CMS_ONLINE_STRUCTURE.STRUCTUR
E_ID
OR
CMS_ONLINE_PROPERTIES.PROPERTY_MAPPING_ID=CMS_ONLINE_STRUCTURE.RESOURCE_
ID )
) WHERE
CMS_ONLINE_PROPERTIES.PROPERTYDEF_ID='aa544e6b-be3b-11d9-b9e4-93a9bb63a4
69'
ORDER BY CMS_ONLINE_STRUCTURE.RESOURCE_PATH DESC SQL Exception
org.postgresql.util.PSQLException: Parameter index out of range.
        at
org.postgresql.jdbc1.AbstractJdbc1Statement.bind(AbstractJdbc1Statement.
java
:2090)
        at
org.postgresql.jdbc1.AbstractJdbc1Statement.setString(AbstractJdbc1State
ment
.java:1135)
        at
org.postgresql.jdbc1.AbstractJdbc1Statement.setString(AbstractJdbc1State
ment
.java:1116)
        at
org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegating
Prep
aredStatement.java:131)
        at
org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegating
Prep
aredStatement.java:131)
        at
org.opencms.db.generic.CmsVfsDriver.readResourcesWithProperty(CmsVfsDriv
er.j
ava:1497)
        at
org.opencms.db.CmsDriverManager.readResourcesWithProperty(CmsDriverManag
er.j
ava:5587)
        at
org.opencms.db.CmsSecurityManager.readResourcesWithProperty(CmsSecurityM
anag
er.java:3577)
        at
org.opencms.file.CmsObject.readResourcesWithProperty(CmsObject.java:2593
)
        at
org.opencms.staticexport.CmsStaticExportManager.setExportnames(CmsStatic
Expo
rtManager.java:1974)
        at
org.opencms.staticexport.CmsStaticExportManager.clearCaches(CmsStaticExp
ortM
anager.java:1634)
        at
org.opencms.staticexport.CmsStaticExportManager.cmsEvent(CmsStaticExport
Mana
ger.java:277)
        at
org.opencms.main.OpenCmsCore.fireCmsEventHandler(OpenCmsCore.java:1763)
        at
org.opencms.main.OpenCmsCore.fireCmsEvent(OpenCmsCore.java:353)
        at org.opencms.main.OpenCms.fireCmsEvent(OpenCms.java:125)
        at
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExpo
rtMa
nager.java:422)
        at
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java
:127
2)
        at
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.j
ava:
748)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39
)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl
.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:2
37)
        at org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
        at org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
        at org.opencms.main.CmsShell.start(CmsShell.java:491)
        at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImp
ortT
hread.java:167)
15:39:20,451 INFO  [CmsModuleManager] Creating new module
'com.alkacon.documentation.howto_multisite'
15:39:20,467 INFO  [CmsConfigurationManager] Successfully updated XML
configuration file
/opt/jboss-3.2.7/server/default/deploy/cms.war/WEB-INF/config/opencms-mo
dule
s.xml for class 'org.opencms.configuration.CmsModuleConfiguration'
15:39:20,468 INFO  [init] . Resource type init   : starting
15:39:20,468 INFO  [init] . Resource type init   : adding 14 resource
types
from file opencms-vfs.xml
... continues ok
------------------






_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please
visit http://mail.opencms.org/mailman/listinfo/opencms-dev