Hi, Thanks a lot for the suggestions.
Although it it quit a long way to do. I need to adapt Torque, to be able to create the needed scripts (done part of that now locally) Then I can generate the scripts (mostly working now) I can load the database (exception is the populate user info sql file, which generates a constraint violation on the foreign key) I think that most errors when starting up are causen by the JDBC driver, but i'm still working on it. Is torque somehow used during operating jetspeed, or is it only used for creating the database files? Greetings, Dolf Smits -----Original Message----- From: Shah Amit [mailto:[EMAIL PROTECTED] Sent: Thursday, March 10, 2005 15:03 To: [email protected] Subject: RE: some questions about the database servers Hi Dolf, The way it works is, the schema is defined in XML files. If you go following directory - XXX:\jakarta-jetspeed-2\src\schema\*.xml All the XML files are basically the source for the schemas that you see in the target directory. And then there are OJB plugins I think that generate the sql out of those xml schema files. Hope that helps. Amit ----Original Message Follows---- From: "Smits.Dolf" <[EMAIL PROTECTED]> Reply-To: "Jetspeed Developers List" <[email protected]> To: "'[email protected]'" <[email protected]> Subject: some questions about the database servers Date: Thu, 10 Mar 2005 10:04:39 +0100 Hi all, I was trying to get jetspeed to work with monetDB, which I happen to have already installed on my development system, After some initial problems with the SQL scripts, I do have some working scripts for setting up the database. However, the scripts to setup the datavase are generated from some source into the ./target/sql/<type> directories. I cannot find the place where the sources for this creations live. Can someone enlighten me a bit on this? Another problem, when starting tomcat and deploying jetspeed, tomcat seems to startup OK, but as soon as I request the standard page, the following exception is dumped, and jetspeed won't start. (see below) Can anyone tell me what (strange) SQL operations are used? Or give me some hints about getting the SQL operations, so I can have a look whether these are syntax, JDBC or monet Core problems? Thanks a lot for any help or siggestions. Dolf Smits === 2005-03-10 09:57:45 StandardContext[/jsp-examples]ContextListener: contextInitialized() 2005-03-10 09:57:45 StandardContext[/jsp-examples]SessionListener: contextInitialized() 2005-03-10 09:57:45 StandardContext[/servlets-examples]ContextListener: contextInitialized() 2005-03-10 09:57:45 StandardContext[/servlets-examples]SessionListener: contextInitialized() 2005-03-10 09:58:39 ApplicationDispatcher[/jetspeed] Servlet.service() for servlet jetspeed threw exception org.apache.jetspeed.exception.JetspeedException: Unable to create Engine at org.apache.jetspeed.Jetspeed.createEngine(Jetspeed.java:76) at org.apache.jetspeed.engine.JetspeedServlet.init(JetspeedServlet.java:135) at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:10 44) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:876) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java: 4017) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4337) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:8 23) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595) at org.apache.catalina.core.StandardHostDeployer.addChild(StandardHostDeployer. java:903) 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:585) at org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:216) at org.apache.commons.digester.SetNextRule.end(SetNextRule.java:256) at org.apache.commons.digester.Rule.end(Rule.java:276) at org.apache.commons.digester.Digester.endElement(Digester.java:1058) at org.apache.catalina.util.CatalinaDigester.endElement(CatalinaDigester.java:7 6) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatc her.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.commons.digester.Digester.parse(Digester.java:1567) at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.j ava:488) at org.apache.catalina.core.StandardHost.install(StandardHost.java:863) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:483 ) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:427) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:983) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor t.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091) at org.apache.catalina.core.StandardHost.start(StandardHost.java:789) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478) at org.apache.catalina.core.StandardService.start(StandardService.java:480) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2313) at org.apache.catalina.startup.Catalina.start(Catalina.java:556) 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:585) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:287) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425) Caused by: org.apache.jetspeed.exception.JetspeedException: Jetspeed Initialization exception! at org.apache.jetspeed.engine.AbstractEngine.init(AbstractEngine.java:146) at org.apache.jetspeed.Jetspeed.createEngine(Jetspeed.java:64) ... 47 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'java.util.prefs.PreferencesFactory' defined in URL [file:/C:/apps/Apache_Group/Tomcat 5.0/webapps/jetspeed/WEB-INF/assembly/jetspeed-spring.xml]: Initialization of bean failed; nested exception is org.apache.jetspeed.prefs.PreferencesException: Failed to initialize prefs api. org.springframework.jdbc.UncategorizedSQLException: (OJB operation): encountered SQLException [Operation currently not supported!]; nested exception is java.sql.SQLException: Operation currently not supported! at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory .createBean(AbstractAutowireCapableBeanFactory.java:300) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory .createBean(AbstractAutowireCapableBeanFactory.java:205) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra ctBeanFactory.java:204) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra ctBeanFactory.java:136) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInst antiateSingletons(DefaultListableBeanFactory.java:236) at org.springframework.context.support.AbstractApplicationContext.refresh(Abstr actApplicationContext.java:284) at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(F ileSystemXmlApplicationContext.java:114) at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(F ileSystemXmlApplicationContext.java:96) at org.apache.jetspeed.components.SpringComponentManager.<init>(SpringComponent Manager.java:44) at org.apache.jetspeed.engine.SpringEngine.initComponents(SpringEngine.java:108 ) at org.apache.jetspeed.engine.AbstractEngine.init(AbstractEngine.java:138) ... 48 more Caused by: org.apache.jetspeed.prefs.PreferencesException: Failed to initialize prefs api. org.springframework.jdbc.UncategorizedSQLException: (OJB operation): encountered SQLException [Operation currently not supported!]; nested exception is java.sql.SQLException: Operation currently not supported! at org.apache.jetspeed.prefs.impl.PreferencesFactoryImpl.init(PreferencesFactor yImpl.java:70) 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:585) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory .invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory .invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory .createBean(AbstractAutowireCapableBeanFactory.java:287) ... 58 more =========== Dolf Smits Senior Consultant Meta Directory Solutions Siemens Nederland N.V. Siemens Business Services Bezoekadres Prinses Beatrixlaan 26 Den Haag Correspondentieadres Postbus 16068 NL-2500 BB Den Haag 070 333 3654 070 333 2511 06 55844837 [EMAIL PROTECTED] www.siemens.nl Deze e-mail is uitsluitend bedoeld voor kennisneming door de geadresseerde(n), en mag niet aan anderen worden doorgestuurd of op andere wijze ter kennis worden gebracht. Indien u niet de geadresseerde bent, verzoek ik u om de afzender te waarschuwen en de e-mail direct te verwijderen/vernietigen. De afzender wijst elke aansprakelijkheid voor (de inhoud van) deze e-mail af. --------------------------------------------------------------------- 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]
