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)
