RE: slide 1.0.10 - different DB schema: Column count doesn't match value count at row 1

[Ma...@ubsw.com]

I found the problem: the permission table now has 6 columns. 


old:

create table permissions(object blob, subject blob, action blob, 
  inheritable int, negative int);

new:

create table permissions(object blob, revisionnumber varchar(20), 
  subject blob, action blob, inheritable int, negative int);

Regards,
Mark

-----Original Message-----
From: Papiani, Mark 
Sent: 31 May 2001 13:13
To: 'slide-user@jakarta.apache.org'
Subject: slide 1.0.10 - different DB schema: Column count doesn't match
value count at row 1


Hi,

Has the database schema changed for Slide 1.0.10?

I get an error from my previously working MySQL store. I emptied the 
database and started up the new version of slide and got:



31 May 2001 13:05:45 - WARNING - 
org.apache.slide.common.ServiceAccessException
java.sql.SQLException: Error during query: Unexpected Exception: 
java.sql.SQLException message given: General error: Column count 
doesn't match value count at row 1
        at java.lang.Throwable.fillInStackTrace(Native Method)
        at java.lang.Throwable.fillInStackTrace(Compiled Code)
        at java.lang.Throwable.<init>(Compiled Code)
        at java.lang.Exception.<init>(Compiled Code)
        at java.sql.SQLException.<init>(SQLException.java:64)
        at org.gjt.mm.mysql.Connection.execSQL(Compiled Code)
        at org.gjt.mm.mysql.PreparedStatement.execute(Compiled Code)
        at 
slidestore.reference.JDBCDescriptorsStore.grantPermission(JDBCDescriptor
sStore.java:884)
        at 
org.apache.slide.store.AbstractStore.grantPermission(AbstractStore.java:
582)
        at 
org.apache.slide.store.StandardStore.grantPermission(StandardStore.java:
238)
        at 
org.apache.slide.common.Namespace.loadBaseData(Namespace.java:657)
        at org.apache.slide.common.Domain.initNamespace(Compiled Code)
        at org.apache.slide.common.Domain.init(Compiled Code)
        at org.apache.slide.common.Domain.init(Domain.java:255)
        at org.apache.slide.common.Domain.init(Domain.java:233)
        at 
org.apache.slide.manager.ManagerServlet.init(ManagerServlet.java:316)
        at javax.servlet.GenericServlet.init(GenericServlet.java:258)
        at 
org.apache.tomcat.core.ServletWrapper.doInit(ServletWrapper.java:317)
        at org.apache.tomcat.core.Handler.init(Handler.java:215)
        at org.apache.tomcat.core.ServletWrapper.init(Compiled Code)
        at 
org.apache.tomcat.context.LoadOnStartupInterceptor.contextInit(Compiled 
Code)
        at org.apache.tomcat.core.ContextManager.initContext(Compiled 
Code)
        at org.apache.tomcat.core.ContextManager.init(Compiled Code)
        at org.apache.tomcat.startup.Tomcat.execute(Tomcat.java:195)
        at org.apache.tomcat.startup.Tomcat.main(Tomcat.java:235)
31 May 2001 13:05:45 - INFO - Namespace base configuration was already 
done before
31 May 2001 13:05:45 - INFO - Loading namespace webdav configuration
org.apache.slide.structure.ObjectNotFoundException: No object found at 
/actions
        at java.lang.Throwable.fillInStackTrace(Native Method)
        at java.lang.Throwable.fillInStackTrace(Compiled Code)
        at java.lang.Throwable.<init>(Compiled Code)
        at java.lang.Exception.<init>(Compiled Code)
        at 
org.apache.slide.common.SlideException.<init>(SlideException.java:95)
        at 
org.apache.slide.structure.StructureException.<init>(StructureException.
java:86)
        at 
org.apache.slide.structure.ObjectNotFoundException.<init>(ObjectNotFound
Exception.java:87)
        at 
slidestore.reference.JDBCDescriptorsStore.retrieveObject(Compiled Code)
        at 
org.apache.slide.store.StandardStore.retrieveObject(StandardStore.java:1
69)
        at 
org.apache.slide.common.NamespaceConfig.getActionNode(NamespaceConfig.ja
va:1031)
        at 
org.apache.slide.common.NamespaceConfig.initializeNamespaceConfig(Compil
ed Code)
        at 
org.apache.slide.common.Namespace.loadConfiguration(Namespace.java:721)
        at org.apache.slide.common.Domain.initNamespace(Compiled Code)
        at org.apache.slide.common.Domain.init(Compiled Code)
        at org.apache.slide.common.Domain.init(Domain.java:255)
        at org.apache.slide.common.Domain.init(Domain.java:233)
        at 
org.apache.slide.manager.ManagerServlet.init(ManagerServlet.java:316)
        at javax.servlet.GenericServlet.init(GenericServlet.java:258)
        at 
org.apache.tomcat.core.ServletWrapper.doInit(ServletWrapper.java:317)
        at org.apache.tomcat.core.Handler.init(Handler.java:215)
        at org.apache.tomcat.core.ServletWrapper.init(Compiled Code)
        at 
org.apache.tomcat.context.LoadOnStartupInterceptor.contextInit(Compiled 
Code)
        at org.apache.tomcat.core.ContextManager.initContext(Compiled 
Code)
        at org.apache.tomcat.core.ContextManager.init(Compiled Code)
        at org.apache.tomcat.startup.Tomcat.execute(Tomcat.java:195)
        at org.apache.tomcat.startup.Tomcat.main(Tomcat.java:235)
2001-05-31 01:05:47 - PoolTcpConnector: Starting HttpConnectionHandler 
on 9058
2001-05-31 01:05:47 - PoolTcpConnector: Starting Ajp12ConnectionHandler 
on 9059


Thanks
Mark


Visit our website at http://www.ubswarburg.com

This message contains confidential information and is intended only 
for the individual named.  If you are not the named addressee you 
should not disseminate, distribute or copy this e-mail.  Please 
notify the sender immediately by e-mail if you have received this 
e-mail by mistake and delete this e-mail from your system.

E-mail transmission cannot be guaranteed to be secure or error-free 
as information could be intercepted, corrupted, lost, destroyed, 
arrive late or incomplete, or contain viruses.  The sender therefore 
does not accept liability for any errors or omissions in the contents 
of this message which arise as a result of e-mail transmission.  If 
verification is required please request a hard-copy version.  This 
message is provided for informational purposes and should not be 
construed as a solicitation or offer to buy or sell any securities or 
related financial instruments.

Re: slide 1.0.10 - different DB schema: Column count doesn't match value count at row 1

[Remy Maucherat <re...@apache.org>]

> I found the problem: the permission table now has 6 columns.
>
>
> old:
>
> create table permissions(object blob, subject blob, action blob,
>   inheritable int, negative int);
>
> new:
>
> create table permissions(object blob, revisionnumber varchar(20),
>   subject blob, action blob, inheritable int, negative int);

Yes, sorry for the non backward compatible change.
It should be easy to transfer old data, since the new revisionnumber column
should have a null value in most cases (indicating that the ACL applies to
all the versions of the resource).

Remy