Dan, it works for us using 3.23.28-gamma, though we build the database
by doing something like:
mysql < build_slide_repository
as opposed to letting slide build it. i posted the script we use to the
list the other week...
hope this helps
cheers,
jason
Dan Diephouse wrote:
> I'm trying to get slide to work with mysql and have a question or two.
>
> First, I create my database. That goes well, except for:
>
> mysql> create table objects (uri blob not null, primary key uriIndex
> (uri(255)), classname blob);
> ERROR 1073: BLOB column 'uri' can't be used in key specification with
> the used table type
>
> What I found out (thank god for search engines...) was that before
> version 3.23.2 you couldn't index using blobs, so I'm upgrading my
> mysql....I have version 3.22.32. Hopefully this will save others time
> :)
>
> I go ahead and create the tables without the primary keys for the
> moment. But I get a big long thing because slide isn't creating the
> database entries (which it does with ease in hsql) and it wants them
> (see below). So my question is do I need to populate the mysql database
> by hand or am I doing something wrong preventing slide from populating
> it....
>
> Thanks,
>
> Dan Diephouse
>
> 22 Mar 2001 13:57:04 - INFO - Initializing Domain
> 22 Mar 2001 13:57:04 - INFO - Domain configuration :
> {org.apache.slide.security=true}
> 22 Mar 2001 13:57:04 - INFO - Initializing namespace : webdav
> 22 Mar 2001 13:57:04 - INFO - Loading namespace definition
> 22 Mar 2001 13:57:04 - INFO - Registering Data Source name memory of
> class class org.apache.slide.store.StandardStore with parameters {} on
> scope /
> 22 Mar 2001 13:57:05 - INFO - Initializing service
> org.apache.slide.store.StandardStore@d2b7596e
> 22 Mar 2001 13:57:05 - INFO - Loading namespace webdav parameters
> 22 Mar 2001 13:57:05 - INFO - Loading namespace webdav base data
> WARNING: No active transaction
> WARNING: No active transaction
> WARNING: No active transaction
> 22 Mar 2001 13:57:05 - INFO - Loading object /
> Enlist error(Transaction 1 in main) = -3
> slidestore.reference.JDBCDescriptorsStore@db63596e Branch:
> main-985287425647-1-1 Flag: 0
> Enlist error(Transaction 1 in main) = -3
> slidestore.reference.JDBCDescriptorsStore@db63596e Branch:
> main-985287425647-1-2 Flag: 2097152
> Enlist error(Transaction 1 in main) = -3
> slidestore.reference.JDBCDescriptorsStore@db63596e Branch:
> main-985287425647-1-3 Flag: 2097152
> Enlist error(Transaction 1 in main) = -3
> slidestore.reference.JDBCDescriptorsStore@db63596e Branch:
> main-985287425647-1-4 Flag: 2097152
> Enlist error(Transaction 1 in main) = -3
> slidestore.reference.JDBCDescriptorsStore@db63596e Branch:
> main-985287425647-1-5 Flag: 2097152
> Enlist error(Transaction 1 in main) = -3
> slidestore.reference.JDBCDescriptorsStore@db63596e Branch:
> main-985287425647-1-6 Flag: 2097152
> Enlist error(Transaction 1 in main) = -3
> slidestore.reference.JDBCDescriptorsStore@db63596e Branch:
> main-985287425647-1-7 Flag: 2097152
> Enlist error(Transaction 1 in main) = -3
> slidestore.reference.JDBCDescriptorsStore@db63596e Branch:
> main-985287425647-1-8 Flag: 2097152
> Enlist error(Transaction 1 in main) = -3
> slidestore.reference.JDBCDescriptorsStore@db63596e Branch:
> main-985287425647-1-9 Flag: 2097152
> Enlist error(Transaction 1 in main) = -3
> slidestore.reference.JDBCDescriptorsStore@db63596e Branch:
> main-985287425647-1-10 Flag: 2097152
> Enlist error(Transaction 1 in main) = -3
> slidestore.reference.JDBCDescriptorsStore@db63596e Branch:
> main-985287425647-1-11 Flag: 2097152
> Enlist error(Transaction 1 in main) = -3
> slidestore.reference.JDBCDescriptorsStore@db63596e Branch:
> main-985287425647-1-12 Flag: 2097152
> Enlist error(Transaction 1 in main) = -3
> slidestore.reference.JDBCDescriptorsStore@db63596e Branch:
> main-985287425647-1-13 Flag: 2097152
> Enlist error(Transaction 1 in main) = -3
> slidestore.reference.JDBCDescriptorsStore@db63596e Branch:
> main-985287425647-1-14 Flag: 2097152
> Enlist error(Transaction 1 in main) = -3
> slidestore.reference.JDBCDescriptorsStore@db63596e Branch:
> main-985287425647-1-15 Flag: 2097152
> Enlist error(Transaction 1 in main) = -3
> slidestore.reference.JDBCDescriptorsStore@db63596e Branch:
> main-985287425647-1-16 Flag: 2097152
> Enlist error(Transaction 1 in main) = -3
> slidestore.reference.JDBCDescriptorsStore@db63596e Branch:
> main-985287425647-1-17 Flag: 2097152
> Enlist error(Transaction 1 in main) = -3
> slidestore.reference.JDBCDescriptorsStore@db63596e Branch:
> main-985287425647-1-18 Flag: 2097152
> Enlist error(Transaction 1 in main) = -3
> slidestore.reference.JDBCDescriptorsStore@db63596e Branch:
> main-985287425647-1-19 Flag: 2097152
> Enlist error(Transaction 1 in main) = -3
> slidestore.reference.JDBCDescriptorsStore@db63596e Branch:
> main-985287425647-1-20 Flag: 2097152
> 22 Mar 2001 13:57:06 - WARNING -
> org.apache.slide.common.ServiceAccessException
> 22 Mar 2001 13:57:06 - INFO - Namespace base configuration was already
> done before
> 22 Mar 2001 13:57:06 - INFO - Loading namespace webdav configuration
> org.apache.slide.structure.ObjectNotFoundException: No object found at
> /actions
> at
>
>slidestore.reference.JDBCDescriptorsStore.retrieveObject(JDBCDescriptorsStore.java:535)
>
> at
> org.apache.slide.store.StandardStore.retrieveObject(StandardStore.java:170)
>
> at
> org.apache.slide.common.NamespaceConfig.getActionNode(NamespaceConfig.java:989)
>
> at
>
>org.apache.slide.common.NamespaceConfig.initializeNamespaceConfig(NamespaceConfig.java:561)
>
> at
> org.apache.slide.common.Namespace.loadConfiguration(Namespace.java:670)
> at org.apache.slide.common.Domain.initNamespace(Domain.java:580)
>
> at org.apache.slide.common.Domain.init(Domain.java:237)
> at
> org.apache.slide.manager.ManagerServlet.init(ManagerServlet.java:333)
> at javax.servlet.GenericServlet.init(GenericServlet.java:258)
> at
> org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:755)
> at
> org.apache.catalina.core.StandardContext.start(StandardContext.java:2979)
>
> at
> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:816)
> at
> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:334)
> at
> org.apache.catalina.core.StandardHost.deploy(StandardHost.java:545)
> at
> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:294)
> at
> org.apache.catalina.startup.HostConfig.start(HostConfig.java:383)
> at
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:226)
>
> at
>
>org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:155)
>
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1172)
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1160)
> at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:217)
> at
> org.apache.catalina.core.StandardService.start(StandardService.java:353)
>
> at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:454)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:654)
>
> at
> org.apache.catalina.startup.Catalina.execute(Catalina.java:595)
> at
> org.apache.catalina.startup.Catalina.process(Catalina.java:176)
> at java.lang.reflect.Method.invoke(Native Method)
> at
> org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:157)
