Re: oracle config
Shash Chatterjee <[email protected]> Wed, 12 Oct 2005 19:14:00 -0500
| Newsgroups | gmane.comp.java.keel.devel |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. --------------030904060408020103070900 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Does anybody have a config file to show Raj how to replace Hsqldb with Oracle as the only DB in the Keel app? I am not sure how to do that with the Xpath config overrides. It may be easier to start with, than to debug a 2-DB app. Raj, in the meantime, you could copy the logkit.xconf file from svc-persist-default into YOURPROJ/conf/overwrite/svc-persist-default/conf/server/, and change the log level in it from "WARN" to "DEBUG". Rebuild and rerun your project and see if you get any extra info. Might have to do the same with log config in svc-persist-base. BTW, "wrapps" is specific to my app, not Keel. If you have changed the "id" attributes in the persistent-factory config from what I sent you, you should modify the URL below accordingly. Shash > > > I'm trying to follow in Shash's footsteps by not remove the hsqldb > references for the "default" DB. Instead use Oracle in addition to > HsqlDB. All the Keel test DBs, default authentication DB, etc, go in > the "default" DB, my own stuff goes in Oracle. I've also added a > dependency in project.xml to pickup oracle driver JAR and package into > WEB-INF/lib. > > To initialize the DB: > http://localhost:8080/default/model.do?model=createdb (initializes the > default HsqlDB table) > http://localhost:8080/default/model.do?model=createdb&db="wrapps" > <http://localhost:8080/default/model.do?model=createdb&db=%22raj-db%22> > (should initialize Oracle table) > > Default HsqlDB gets initialized successfully. > > But when try to initialize Oracle I keep running into: > Could not return a reference to the Component > (Key='org.keel.services.persist.PersistentFactory/wrapps') > org.keel.services.model.ModelException: Could not return a reference > to the Component > (Key='org.keel.services.persist.PersistentFactory/wrapps') > > I'm attaching output from WEB-INF\logs\client.log: > > One thing i noticed is: > Caused by: java.lang.IllegalArgumentException: Unknown java.sql.Types > type -104 > > could someone advise please? > > -raj > > Oct 7, 2005 5:02:47 PM org.keel.clients.KeelClientUtil getLogger > > WARNING: Unable to locate client.properties file - using default settings > > Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientC > onnector logInfo > > INFO: Struts Client Connector starting. > > Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientConnector logDebug > > FINEST: Regular form parameter 'db', '[wrapps]' > > Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientConnector logDebug > > FINEST: Regular form parameter 'model', '[createdb]' > > Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientConnector logDebug > > FINEST: Standard Dyna Form... > > Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientConnector logDebug > > FINEST: Cookie 'JSESSIONID', value '520374FCB62D4226284752B163F12B0C' > > Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientConnector logDebug > > FINEST: Cookie 'keel-domain', value 'ZGVmYXVsdA==' > > Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientConnector logDebug > > FINEST: Cookie 'keel-style', value 'style' > > Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientConnector logDebug > > FINEST: Cookie 'keel-user', value 'cm9vdA==' > > Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientConnector logDebug > > FINEST: Cookie 'keel-password', value 'cm9vdA==' > > Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientConnector logInfo > > INFO: Configuring Client 1 > > Oct 7, 2005 5:02:50 PM org.keel.clients.DefaultClientConnector logDebug > > FINEST: Returned cookies > > Oct 7, 2005 5:02:50 PM org.keel.clients.DefaultClientConnector logDebug > > FINEST: No cookies returned in "cookies" attribute > > Oct 7, 2005 5:02:50 PM org.keel.clients.DefaultClientConnector logError > > SEVERE: No elements in response from server > > Oct 7, 2005 5:02:50 PM org.keel.util.i18n.DynamicMessageSupport > getMessages > > WARNING: [DynamicMessageSupport] null > > Oct 7, 2005 5:02:50 PM org.keel.clients.DefaultClientConnector logError > > SEVERE: Stack for error from createdb, Key: 'Exception during model > execution Message: Could not return a reference to the Component > (Key='org.keel.services.persist.PersistentFactory/wrapps') > org.keel.services.model.ModelException: Could not return a reference > to the Component > (Key='org.keel.services.persist.PersistentFactory/wrapps') > > at > org.keel.services.model.defaultmodel.DefaultModelRequest.getService(DefaultModelRequest.java:451) > > at org.keel.models.util.CreateDB.execute(CreateDB.java:45) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) > > at java.lang.reflect.Method.invoke(Unknown Source) > > at > org.apache.avalon.fortress.impl.factory.PassThroughInvocationHandler.invoke(PassThroughInvocationHandler.java:68) > > at $Proxy3.execute(Unknown Source) > > at > org.keel.services.model.defaultmodel.DefaultModelRequest.execute(DefaultModelRequest.java:198) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) > > at java.lang.reflect.Method.invoke(Unknown Source) > > at > org.apache.avalon.fortress.impl.factory.PassThroughInvocationHandler.invoke(PassThroughInvocationHandler.java:68) > > at $Proxy1.execute(Unknown Source) > > at > org.keel.servers.direct.KeelDirectServer.execute(KeelDirectServer.java:230) > > at > org.keel.servers.direct.KeelDirectServer$MultiThreadedProcessor.run(KeelDirectServer.java:271) > > > ----------------------------------------- > org.apache.avalon.framework.service.ServiceException: Could not return > a reference to the Component > (Key='org.keel.services.persist.PersistentFactory/wrapps') > > at > org.apache.avalon.fortress.impl.lookup.FortressServiceManager.lookup(FortressServiceManager.java:117) > > at > org.keel.core.container.KeelServiceManagerImpl.lookup(KeelServiceManagerImpl.java:95) > > at > org.keel.core.container.AbstractKeelServiceable.getService(AbstractKeelServiceable.java:113) > > at > org.keel.services.model.defaultmodel.DefaultModelRequest.getService(DefaultModelRequest.java:449) > > at org.keel.models.util.CreateDB.execute(CreateDB.java:45) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) > > at java.lang.reflect.Method.invoke(Unknown Source) > > at > org.apache.avalon.fortress.impl.factory.PassThroughInvocationHandler.invoke(PassThroughInvocationHandler.java:68) > > at $Proxy3.execute(Unknown Source) > > at > org.keel.services.model.defaultmodel.DefaultModelRequest.execute(DefaultModelRequest.java:198) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) > > at java.lang.reflect.Method.invoke(Unknown Source) > > at > org.apache.avalon.fortress.impl.factory.PassThroughInvocationHandler.invoke(PassThroughInvocationHandler.java:68) > > at $Proxy1.execute(Unknown Source) > > at > org.keel.servers.direct.KeelDirectServer.execute(KeelDirectServer.java:230) > > at > org.keel.servers.direct.KeelDirectServer$MultiThreadedProcessor.run(KeelDirectServer.java:271) > > Caused by: java.lang.IllegalArgumentException: Unknown java.sql.Types > type -104 > > at > org.keel.services.persist.base.JDBCDatabaseType.typeToString(JDBCDatabaseType.java:1091) > > at > org.keel.services.persist.base.OracleDatabaseType.setDataSource(OracleDatabaseType.java:93) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) > > at java.lang.reflect.Method.invoke(Unknown Source) > > at > org.apache.avalon.fortress.impl.factory.PassThroughInvocationHandler.invoke(PassThroughInvocationHandler.java:68) > > at $Proxy8.setDataSource(Unknown Source) > > at > org.keel.services.persist.base.AbstractPersistentFactory.initialize(AbstractPersistentFactory.java:453) > > at > org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:283) > > at > org.apache.avalon.fortress.impl.handler.ComponentFactory.newInstance(ComponentFactory.java:184) > > at > org.apache.avalon.fortress.impl.factory.ProxyObjectFactory.newInstance(ProxyObjectFactory.java:54) > > at > org.apache.avalon.fortress.impl.handler.AbstractComponentHandler.newComponent(AbstractComponentHandler.java:246) > > at > org.apache.avalon.fortress.impl.handler.ThreadSafeComponentHandler.doPrepare(ThreadSafeComponentHandler.java:40) > > at > org.apache.avalon.fortress.impl.handler.AbstractComponentHandler.prepareHandler(AbstractComponentHandler.java:147) > > at > org.apache.avalon.fortress.impl.handler.AbstractComponentHandler.get(AbstractComponentHandler.java:177) > > at > org.apache.avalon.fortress.impl.handler.LEAwareComponentHandler.get(LEAwareComponentHandler.java:96) > > at > org.apache.avalon.fortress.impl.lookup.FortressServiceManager.lookup(FortressServiceManager.java:99) > > ... 19 more > > > --------------030904060408020103070900 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> <title></title> </head> <body bgcolor="#ffffff" text="#6600cc"> Does anybody have a config file to show Raj how to replace Hsqldb with Oracle as the only DB in the Keel app? I am not sure how to do that with the Xpath config overrides. It may be easier to start with, than to debug a 2-DB app. <br> <br> Raj, in the meantime, you could copy the logkit.xconf file from svc-persist-default into YOURPROJ/conf/overwrite/svc-persist-default/conf/server/, and change the log level in it from "WARN" to "DEBUG". Rebuild and rerun your project and see if you get any extra info. Might have to do the same with log config in svc-persist-base. BTW, "wrapps" is specific to my app, not Keel. If you have changed the "id" attributes in the persistent-factory config from what I sent you, you should modify the URL below accordingly.<br> <br> Shash<br> <blockquote cite="mid19d2c3e30510101334k5d1e78f9sb9503ac2e2cc07ca-JsoAwUIsXosN+BqQ9rBEUg@public.gmane.org" type="cite"><br> <br> I'm trying to follow in Shash's footsteps by not remove the hsqldb references for the "default" DB. Instead use Oracle in addition to HsqlDB. All the Keel test DBs, default authentication DB, etc, go in the "default" DB, my own stuff goes in Oracle. I've also added a dependency in project.xml to pickup oracle driver JAR and package into WEB-INF/lib.<br> <br> To initialize the DB:<br> <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://localhost:8080/default/model.do?model=createdb" target="_blank">http://localhost:8080/default/model.do?model=createdb</a> (initializes the default HsqlDB table) <br> <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://localhost:8080/default/model.do?model=createdb&db=%22raj-db%22" target="_blank">http://localhost:8080/default/model.do?model=createdb&db="wrapps" </a> (should initialize Oracle table)<br> <br> Default HsqlDB gets initialized successfully.<br> <br> But when try to initialize Oracle I keep running into:<br> <span style="font-weight: bold;">Could not return a reference to the Component (Key='org.keel.services.persist.PersistentFactory/wrapps')</span><br style="font-weight: bold;"> <span style="font-weight: bold;"> org.keel.services.model.ModelException: Could not return a reference to the Component (Key='org.keel.services.persist.PersistentFactory/wrapps')</span><br> <br> I'm attaching output from WEB-INF\logs\client.log:<br> <br> One thing i noticed is:<br> <span style="font-weight: bold;">Caused by: java.lang.IllegalArgumentException: Unknown java.sql.Types type -104</span><br> <br> could someone advise please?<br> <br> -raj<br> <br> Oct 7, 2005 5:02:47 PM org.keel.clients.KeelClientUtil getLogger<br> <br> WARNING: Unable to locate client.properties file - using default settings<br> <br> Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientC <div id="mb_3">onnector logInfo<br> <br> INFO: Struts Client Connector starting.<br> <br> Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientConnector logDebug<br> <br> FINEST: Regular form parameter 'db', '[wrapps]'<br> <br> Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientConnector logDebug<br> <br> FINEST: Regular form parameter 'model', '[createdb]'<br> <br> Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientConnector logDebug<br> <br> FINEST: Standard Dyna Form...<br> <br> Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientConnector logDebug<br> <br> FINEST: Cookie 'JSESSIONID', value '520374FCB62D4226284752B163F12B0C'<br> <br> Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientConnector logDebug<br> <br> FINEST: Cookie 'keel-domain', value 'ZGVmYXVsdA=='<br> <br> Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientConnector logDebug<br> <br> FINEST: Cookie 'keel-style', value 'style'<br> <br> Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientConnector logDebug<br> <br> FINEST: Cookie 'keel-user', value 'cm9vdA=='<br> <br> Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientConnector logDebug<br> <br> FINEST: Cookie 'keel-password', value 'cm9vdA=='<br> <br> Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientConnector logInfo<br> <br> INFO: Configuring Client 1<br> <br> Oct 7, 2005 5:02:50 PM org.keel.clients.DefaultClientConnector logDebug<br> <br> FINEST: Returned cookies<br> <br> Oct 7, 2005 5:02:50 PM org.keel.clients.DefaultClientConnector logDebug<br> <br> FINEST: No cookies returned in "cookies" attribute<br> <br> Oct 7, 2005 5:02:50 PM org.keel.clients.DefaultClientConnector logError<br> <br> SEVERE: No elements in response from server<br> <br> Oct 7, 2005 5:02:50 PM org.keel.util.i18n.DynamicMessageSupport getMessages<br> <br> WARNING: [DynamicMessageSupport] null<br> <br> Oct 7, 2005 5:02:50 PM org.keel.clients.DefaultClientConnector logError<br> <br> SEVERE: Stack for error from createdb, Key: 'Exception during model execution Message: Could not return a reference to the Component (Key='org.keel.services.persist.PersistentFactory/wrapps')<br> org.keel.services.model.ModelException: Could not return a reference to the Component (Key='org.keel.services.persist.PersistentFactory/wrapps')<br> <br> at org.keel.services.model.defaultmodel.DefaultModelRequest.getService(DefaultModelRequest.java:451)<br> <br> at org.keel.models.util.CreateDB.execute(CreateDB.java:45)<br> <br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> <br> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)<br> <br> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<br> <br> at java.lang.reflect.Method.invoke(Unknown Source)<br> <br> at org.apache.avalon.fortress.impl.factory.PassThroughInvocationHandler.invoke(PassThroughInvocationHandler.java:68)<br> <br> at $Proxy3.execute(Unknown Source)<br> <br> at org.keel.services.model.defaultmodel.DefaultModelRequest.execute(DefaultModelRequest.java:198)<br> <br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> <br> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)<br> <br> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<br> <br> at java.lang.reflect.Method.invoke(Unknown Source)<br> <br> at org.apache.avalon.fortress.impl.factory.PassThroughInvocationHandler.invoke(PassThroughInvocationHandler.java:68)<br> <br> at $Proxy1.execute(Unknown Source)<br> <br> at org.keel.servers.direct.KeelDirectServer.execute(KeelDirectServer.java:230)<br> <br> at org.keel.servers.direct.KeelDirectServer$MultiThreadedProcessor.run(KeelDirectServer.java:271)<br> <br> <br> -----------------------------------------<br> org.apache.avalon.framework.service.ServiceException: Could not return a reference to the Component (Key='org.keel.services.persist.PersistentFactory/wrapps')<br> <br> at org.apache.avalon.fortress.impl.lookup.FortressServiceManager.lookup(FortressServiceManager.java:117)<br> <br> at org.keel.core.container.KeelServiceManagerImpl.lookup(KeelServiceManagerImpl.java:95)<br> <br> at org.keel.core.container.AbstractKeelServiceable.getService(AbstractKeelServiceable.java:113)<br> <br> at org.keel.services.model.defaultmodel.DefaultModelRequest.getService(DefaultModelRequest.java:449)<br> <br> at org.keel.models.util.CreateDB.execute(CreateDB.java:45)<br> <br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> <br> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)<br> <br> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<br> <br> at java.lang.reflect.Method.invoke(Unknown Source)<br> <br> at org.apache.avalon.fortress.impl.factory.PassThroughInvocationHandler.invoke(PassThroughInvocationHandler.java:68)<br> <br> at $Proxy3.execute(Unknown Source)<br> <br> at org.keel.services.model.defaultmodel.DefaultModelRequest.execute(DefaultModelRequest.java:198)<br> <br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> <br> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)<br> <br> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<br> <br> at java.lang.reflect.Method.invoke(Unknown Source)<br> <br> at org.apache.avalon.fortress.impl.factory.PassThroughInvocationHandler.invoke(PassThroughInvocationHandler.java:68)<br> <br> at $Proxy1.execute(Unknown Source)<br> <br> at org.keel.servers.direct.KeelDirectServer.execute(KeelDirectServer.java:230)<br> <br> at org.keel.servers.direct.KeelDirectServer$MultiThreadedProcessor.run(KeelDirectServer.java:271)<br> <br> Caused by: java.lang.IllegalArgumentException: Unknown java.sql.Types type -104<br> <br> at org.keel.services.persist.base.JDBCDatabaseType.typeToString(JDBCDatabaseType.java:1091)<br> <br> at org.keel.services.persist.base.OracleDatabaseType.setDataSource(OracleDatabaseType.java:93)<br> <br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> <br> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)<br> <br> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<br> <br> at java.lang.reflect.Method.invoke(Unknown Source)<br> <br> at org.apache.avalon.fortress.impl.factory.PassThroughInvocationHandler.invoke(PassThroughInvocationHandler.java:68)<br> <br> at $Proxy8.setDataSource(Unknown Source)<br> <br> at org.keel.services.persist.base.AbstractPersistentFactory.initialize(AbstractPersistentFactory.java:453)<br> <br> at org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:283)<br> <br> at org.apache.avalon.fortress.impl.handler.ComponentFactory.newInstance(ComponentFactory.java:184)<br> <br> at org.apache.avalon.fortress.impl.factory.ProxyObjectFactory.newInstance(ProxyObjectFactory.java:54)<br> <br> at org.apache.avalon.fortress.impl.handler.AbstractComponentHandler.newComponent(AbstractComponentHandler.java:246)<br> <br> at org.apache.avalon.fortress.impl.handler.ThreadSafeComponentHandler.doPrepare(ThreadSafeComponentHandler.java:40)<br> <br> at org.apache.avalon.fortress.impl.handler.AbstractComponentHandler.prepareHandler(AbstractComponentHandler.java:147)<br> <br> at org.apache.avalon.fortress.impl.handler.AbstractComponentHandler.get(AbstractComponentHandler.java:177)<br> <br> at org.apache.avalon.fortress.impl.handler.LEAwareComponentHandler.get(LEAwareComponentHandler.java:96)<br> <br> at org.apache.avalon.fortress.impl.lookup.FortressServiceManager.lookup(FortressServiceManager.java:99)<br> <br> ... 19 more</div> <br> <br> <br> </blockquote> <br> </body> </html> --------------030904060408020103070900-- http://keelframework.org/documentation.shtml Keelgroup mailing list [email protected] http://lists.keelframework.com/listinfo.cgi/keelgroup-keelframework.com