http://cvs.apache.org/viewcvs.cgi/jakarta-slide/src/conf/schema/
and the one for MySQL
http://cvs.apache.org/viewcvs.cgi/*checkout*/jakarta-slide/src/conf/schema/MySqlSchema.sql?rev=1.1.2.1
Oliver
Ryan Rhodes wrote:
I am trying to setup a JDBC store for the first time using mysql. I copied the domain.xml from a copy a found online, but I get Exceptions when I start the server. It looks like it is failing to create the initial tables in the database.
Can anyone help out with this problem?
Can anyone confirm for me that slide creates it's own tables and that I don't need to create them manually?
Here is the domain.xml:
<definition>
<store name="jdbc">
<nodestore classname="org.apache.slide.store.impl.rdbms.JDBCStore">
<parameter name="adapter">org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter</parameter>
<parameter name="driver">com.mysql.jdbc.Driver</parameter>
<parameter name="url">jdbc:mysql://192.168.1.15/piefinger</parameter>
<parameter name="user">auser</parameter>
<parameter name="password">apassword</parameter>
<parameter name="dbcpPooling">true</parameter>
<parameter name="maxPooledConnections">10</parameter>
<parameter name="isolation">SERIALIZABLE</parameter>
<parameter name="compress">false</parameter>
</nodestore>
<securitystore>
<reference store="nodestore" />
</securitystore>
<lockstore>
<reference store="nodestore" />
</lockstore>
<revisiondescriptorsstore>
<reference store="nodestore" />
</revisiondescriptorsstore>
<revisiondescriptorstore>
<reference store="nodestore" />
</revisiondescriptorstore>
<contentstore classname="org.apache.slide.store.txfile.TxFileContentStore">
<parameter name="rootpath">/blarg_contentstore</parameter>
<parameter name="workpath">/blarg_workingresource</parameter>
<parameter name="version">false</parameter>
<parameter name="resetBeforeStarting">false</parameter>
</contentstore>
</store>
<scope match="/" store="jdbc" />
</definition>
Here is the server log:
29 Mar 2004 16:43:13 - org.apache.slide.common.Domain - INFO - Initializing Domain
29 Mar 2004 16:43:13 - org.apache.slide.common.Domain - INFO - Domain configuration : {org.apache.slide.lock=true, org.apache.slide.versioncontrol=true, org.apache.slide.debug=false, org.apache.slide.search=true, org.apache.slide.security=true, org.apache.slide.domain=E:/tmp/Slide 2.0b1 Tomcat 5.0/slide/Domain.xml}
29 Mar 2004 16:43:13 - org.apache.slide.common.Domain - INFO - Domain parameters: {logger-level=6, versioncontrol-exclude=, auto-version=checkout-checkin, historypath=/history, checkin-fork=forbidden, workingresourcepath=/workingresource, workspacepath=/workspace, default=slide, auto-version-control=false, logger=org.apache.slide.util.logger.SimpleLogger, checkout-fork=forbidden}
29 Mar 2004 16:43:13 - org.apache.slide.common.Domain - INFO - Initializing namespace : slide
29 Mar 2004 16:43:13 - org.apache.slide.common.Namespace - INFO - Loading namespace slide parameters
29 Mar 2004 16:43:14 - org.apache.slide.common.Namespace - INFO - Loading namespace definition
29 Mar 2004 16:43:14 - org.apache.slide.common.Namespace - INFO - Node store: org.apache.slide.store.impl.rdbms.JDBCStore
29 Mar 2004 16:43:14 - org.apache.slide.store.impl.rdbms.JDBCStore - INFO - Loading and registering driver 'com.mysql.jdbc.Driver'
29 Mar 2004 16:43:14 - org.apache.slide.store.impl.rdbms.JDBCStore - INFO - Setting isolation level 'SERIALIZABLE'
29 Mar 2004 16:43:14 - org.apache.slide.store.impl.rdbms.JDBCStore - INFO - Using DBCP pooling
29 Mar 2004 16:43:14 - org.apache.slide.store.impl.rdbms.JDBCStore - INFO - Number of connections set to 10
29 Mar 2004 16:43:14 - org.apache.slide.common.Namespace - INFO - Security store references nodestore
29 Mar 2004 16:43:14 - org.apache.slide.common.Namespace - INFO - Lock store store references nodestore
29 Mar 2004 16:43:14 - org.apache.slide.common.Namespace - INFO - Revision descriptors store references nodestore
29 Mar 2004 16:43:14 - org.apache.slide.common.Namespace - INFO - Revision descriptor store references nodestore
29 Mar 2004 16:43:14 - org.apache.slide.common.Namespace - INFO - Content store: org.apache.slide.store.txfile.TxFileContentStore
29 Mar 2004 16:43:14 - org.apache.slide.store.txfile.AbstractTxFileStoreService - INFO - File Store configured to /blarg_contentstore, working directory /blarg_workingresource
29 Mar 2004 16:43:14 - INFO - Setting object cache size for store jdbc to 10000
29 Mar 2004 16:43:14 - org.apache.slide.store.ExtendedStore - INFO - Setting permission cache size for store jdbc to 10000
29 Mar 2004 16:43:14 - org.apache.slide.store.ExtendedStore - INFO - Setting lock cache size for store jdbc to 100
29 Mar 2004 16:43:14 - org.apache.slide.store.ExtendedStore - INFO - Setting descriptors cache size for store jdbc to 10000
29 Mar 2004 16:43:14 - org.apache.slide.store.ExtendedStore - INFO - Setting descriptor cache size for store jdbc to 10000
29 Mar 2004 16:43:14 - org.apache.slide.store.ExtendedStore - INFO - Setting content caching for store jdbc to false
29 Mar 2004 16:43:14 - org.apache.slide.store.ExtendedStore - INFO - Setting content cache size for store jdbc to 10000
29 Mar 2004 16:43:14 - org.apache.slide.store.ExtendedStore - INFO - Setting content cache byte size for store jdbc to 10000000
29 Mar 2004 16:43:14 - org.apache.slide.store.ExtendedStore - INFO - Setting transaction content cache size for store jdbc to 1000
29 Mar 2004 16:43:14 - org.apache.slide.store.ExtendedStore - INFO - Setting transaction content cache byte size for store jdbc to 1000000
29 Mar 2004 16:43:14 - org.apache.slide.store.ExtendedStore - INFO - Setting maximum byte size for content cache entry for store jdbc to 50000
29 Mar 2004 16:43:14 - org.apache.slide.common.Namespace - INFO - Registering Store jdbc (class org.apache.slide.store.ExtendedStore) with parameters {} on scope /
29 Mar 2004 16:43:14 - org.apache.slide.common.Namespace - INFO - Initializing Store jdbc(org.apache.slide.store.ExtendedStore)
29 Mar 2004 16:43:14 - org.apache.slide.store.txfile.rm.impl.FileResourceManager - INFO - Starting RM at '/blarg_contentstore' / '/blarg_workingresource'
29 Mar 2004 16:43:14 - org.apache.slide.store.txfile.rm.impl.FileResourceManager - INFO - Started RM
29 Mar 2004 16:43:15 - org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter - ERROR - SQL error 1146 on /actions: General error, message from server: "Table 'piefinger.OBJECT' doesn't exist"
29 Mar 2004 16:43:15 - org.apache.slide.common.Namespace - INFO - Loading namespace slide base data
29 Mar 2004 16:43:15 - org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter - ERROR - SQL error 1146 on /: General error, message from server: "Table 'piefinger.URI' doesn't exist"
org.apache.slide.common.ServiceAccessException: Service [EMAIL PROTECTED] access error : General error, message from server: "Table 'piefinger.URI' doesn't exist"
at org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter.createException(MySqlRDBMSAdapter.java:60)
at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeObject(StandardRDBMSAdapter.java:197)
at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createObject(StandardRDBMSAdapter.java:89)
at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.createObject(AbstractRDBMSStore.java:476)
at org.apache.slide.store.AbstractStore.createObject(AbstractStore.java:557)
at org.apache.slide.store.ExtendedStore.createObject(ExtendedStore.java:436)
at org.apache.slide.common.Namespace.loadBaseData(Namespace.java:752)
at org.apache.slide.common.Domain.initNamespace(Domain.java:814)
at org.apache.slide.common.Domain.init(Domain.java:433)
at org.apache.slide.common.Domain.init(Domain.java:367)
at org.apache.slide.common.Domain.init(Domain.java:330)
at org.apache.slide.webdav.WebdavServlet.init(WebdavServlet.java:255)
at javax.servlet.GenericServlet.init(GenericServlet.java:256)
at org.apache.slide.webdav.WebdavServlet.init(WebdavServlet.java:197)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1044)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:887)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3960)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4283)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:866)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:850)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:638)
at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:320)
at org.apache.catalina.core.StandardHost.install(StandardHost.java:875)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:657)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:476)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1008)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:394)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1133)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:832)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1125)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:518)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:2345)
at org.apache.catalina.startup.Catalina.start(Catalina.java:598)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:297)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:398)
29 Mar 2004 16:43:15 - org.apache.slide.common.Namespace - INFO - Namespace base configuration was already done before
29 Mar 2004 16:43:15 - org.apache.slide.common.Namespace - INFO - Loading namespace slide configuration
29 Mar 2004 16:43:15 - org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter - ERROR - SQL error 1146 on /actions/read: General error, message from server: "Table 'piefinger.OBJECT' doesn't exist"
29 Mar 2004 16:43:15 - org.apache.slide.common.Domain - ERROR - org.apache.slide.common.ServiceAccessException: Service [EMAIL PROTECTED] access error : General error, message from server: "Table 'piefinger.OBJECT' doesn't exist"
org.apache.slide.common.ServiceAccessException: Service [EMAIL PROTECTED] access error : General error, message from server: "Table 'piefinger.OBJECT' doesn't exist"
at org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter.createException(MySqlRDBMSAdapter.java:60)
at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.retrieveObject(StandardRDBMSAdapter.java:356)
at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.retrieveObject(AbstractRDBMSStore.java:436)
at org.apache.slide.store.AbstractStore.retrieveObject(AbstractStore.java:498)
at org.apache.slide.store.ExtendedStore.retrieveObject(ExtendedStore.java:408)
at org.apache.slide.common.NamespaceConfig.getActionNode(NamespaceConfig.java:1057)
at org.apache.slide.common.NamespaceConfig.getConfiguredNode(NamespaceConfig.java:805)
at org.apache.slide.common.NamespaceConfig.initializeNamespaceConfig(NamespaceConfig.java:675)
at org.apache.slide.common.Namespace.loadConfiguration(Namespace.java:836)
at org.apache.slide.common.Domain.initNamespace(Domain.java:819)
at org.apache.slide.common.Domain.init(Domain.java:433)
at org.apache.slide.common.Domain.init(Domain.java:367)
at org.apache.slide.common.Domain.init(Domain.java:330)
at org.apache.slide.webdav.WebdavServlet.init(WebdavServlet.java:255)
at javax.servlet.GenericServlet.init(GenericServlet.java:256)
at org.apache.slide.webdav.WebdavServlet.init(WebdavServlet.java:197)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1044)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:887)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3960)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4283)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:866)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:850)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:638)
at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:320)
at org.apache.catalina.core.StandardHost.install(StandardHost.java:875)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:657)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:476)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1008)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:394)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1133)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:832)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1125)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:518)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:2345)
at org.apache.catalina.startup.Catalina.start(Catalina.java:598)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:297)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:398)
java.lang.NullPointerException
at org.apache.slide.common.NamespaceConfig.getParameter(NamespaceConfig.java:569)
at org.apache.slide.common.NamespaceAccessTokenImpl.<init>(NamespaceAccessTokenImpl.java:83)
at org.apache.slide.common.Domain.accessNamespace(Domain.java:244)
at org.apache.slide.webdav.WebdavServlet.init(WebdavServlet.java:265)
at javax.servlet.GenericServlet.init(GenericServlet.java:256)
at org.apache.slide.webdav.WebdavServlet.init(WebdavServlet.java:197)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1044)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:887)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3960)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4283)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:866)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:850)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:638)
at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:320)
at org.apache.catalina.core.StandardHost.install(StandardHost.java:875)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:657)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:476)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1008)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:394)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:166)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1133)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:832)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1125)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:518)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:2345)
at org.apache.catalina.startup.Catalina.start(Catalina.java:598)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:297) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:398)
_________________________________________________________________
All the action. All the drama. Get NCAA hoops coverage at MSN Sports by ESPN. http://msn.espn.go.com/index.html?partnersite=espn
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]