oracle config
Raj Joshi <[email protected]> Mon, 10 Oct 2005 16:34:06 -0400
| Newsgroups | gmane.comp.java.keel.devel |
|---|---|
| Message-ID | <[email protected]> |
------=_Part_3416_833514.1128976446605 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hello, 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.xmlto pickup oracle driver JAR and package into WEB-INF/lib. To initialize the DB: http://localhost:8080/default/model.do?model=3Dcreatedb (initializes the default HsqlDB table) http://localhost:8080/default/model.do?model=3Dcreatedb&db=3D"wrapps"<http:= //localhost:8080/default/model.do?model=3Dcreatedb&db=3D%22raj-db%22>(shoul= d 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=3D' org.keel.services.persist.PersistentFactory/wrapps') org.keel.services.model.ModelException: Could not return a reference to th= e Component (Key=3D'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=3D=3D' 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=3D=3D' Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientConnector logDebug FINEST: Cookie 'keel-password', value 'cm9vdA=3D=3D' 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=3D' org.keel.services.persist.PersistentFactory/wrapps') org.keel.services.model.ModelException: Could not return a reference to the Component (Key=3D'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.PassThroughInvoca tionHandler.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=3D'org.keel.services.persist.PersistentFact= ory /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.newCompone= nt (AbstractComponentHandler.java:246) at org.apache.avalon.fortress.impl.handler.ThreadSafeComponentHandler.doPrepar= e (ThreadSafeComponentHandler.java:40) at org.apache.avalon.fortress.impl.handler.AbstractComponentHandler.prepareHan= dler (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 ------=_Part_3416_833514.1128976446605 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hello,<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 addi= tion to HsqlDB. All the Keel test DBs, default authentication DB, etc, go in the "default" DB, my own stuff goes in Oracle. I've a= lso 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=3D"return top.js.OpenExtLink(window,event,this)" href=3D"http://= localhost:8080/default/model.do?model=3Dcreatedb" target=3D"_blank">http://= localhost:8080/default/model.do?model=3Dcreatedb</a> (initializes the defau= lt HsqlDB table) <br> <a onclick=3D"return top.js.OpenExtLink(window,event,this)" href=3D"http://= localhost:8080/default/model.do?model=3Dcreatedb&db=3D%22raj-db%22" tar= get=3D"_blank">http://localhost:8080/default/model.do?model=3Dcreatedb&= db=3D"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=3D"font-weight: bold;">Could not return a reference to the Comp= onent (Key=3D'org.keel.services.persist.PersistentFactory/wrapps')</span><b= r style=3D"font-weight: bold;"> <span style=3D"font-weight: bold;"> org.keel.services.model.ModelException: Could not return a reference to the Component (Key=3D'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=3D"font-weight: bold;">Caused by: java.lang.IllegalArgumentExce= ption: 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<b= r> <br> Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientC <div id=3D"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=3D=3D'<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=3D=3D'<br> <br> Oct 7, 2005 5:02:47 PM org.keel.clients.DefaultClientConnector logDebug<br> <br> FINEST: Cookie 'keel-password', value 'cm9vdA=3D=3D'<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=3D'org.keel.services.persist.PersistentFactory/wrapps')<br> org.keel.services.model.ModelException: Could not return a reference to the Component (Key=3D'org.keel.services.persist.PersistentFactory/wrapps')<= br> <br> at org.keel.services.model.defaultmodel.DefaultModelRequ= est.getService(DefaultModelRequest.java:451)<br> <br> at org.keel.models.util.CreateDB.execute(CreateDB.java:4= 5)<br> <br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native M= ethod)<br> <br> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown S= ource)<br> <br> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unkno= wn 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.DefaultModelRequ= est.execute(DefaultModelRequest.java:198)<br> <br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native M= ethod)<br> <br> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown S= ource)<br> <br> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unkno= wn 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(Keel= DirectServer.java:230)<br> <br> at org.keel.servers.direct.KeelDirectServer$MultiThreade= dProcessor.run(KeelDirectServer.java:271)<br> <br> <br> -----------------------------------------<br> org.apache.avalon.framework.service.ServiceException: Could not return a reference to the Component (Key=3D'org.keel.services.persist.PersistentFactory/wrapps')<br> <br> at org.apache.avalon.fortress.impl.lookup.FortressServic= eManager.lookup(FortressServiceManager.java:117)<br> <br> at org.keel.core.container.KeelServiceManagerImpl.lookup= (KeelServiceManagerImpl.java:95)<br> <br> at org.keel.core.container.AbstractKeelServiceable.getSe= rvice(AbstractKeelServiceable.java:113)<br> <br> at org.keel.services.model.defaultmodel.DefaultModelRequ= est.getService(DefaultModelRequest.java:449)<br> <br> at org.keel.models.util.CreateDB.execute(CreateDB.java:4= 5)<br> <br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native M= ethod)<br> <br> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown S= ource)<br> <br> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unkno= wn 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.DefaultModelRequ= est.execute(DefaultModelRequest.java:198)<br> <br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native M= ethod)<br> <br> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown S= ource)<br> <br> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unkno= wn 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(Keel= DirectServer.java:230)<br> <br> at org.keel.servers.direct.KeelDirectServer$MultiThreade= dProcessor.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.typeT= oString(JDBCDatabaseType.java:1091)<br> <br> at org.keel.services.persist.base.OracleDatabaseType.set= DataSource(OracleDatabaseType.java:93)<br> <br> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native M= ethod)<br> <br> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown S= ource)<br> <br> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unkno= wn 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.AbstractPersistentFact= ory.initialize(AbstractPersistentFactory.java:453)<br> <br> at org.apache.avalon.framework.container.ContainerUtil.i= nitialize(ContainerUtil.java:283)<br> <br> at org.apache.avalon.fortress.impl.handler.ComponentFact= ory.newInstance(ComponentFactory.java:184)<br> <br> at org.apache.avalon.fortress.impl.factory.ProxyObjectFa= ctory.newInstance(ProxyObjectFactory.java:54)<br> <br> at org.apache.avalon.fortress.impl.handler.AbstractComponentHandler.newCompone= nt(AbstractComponentHandler.java:246)<br> <br> at org.apache.avalon.fortress.impl.handler.ThreadSafeComponentHandler.doPrepar= e(ThreadSafeComponentHandler.java:40)<br> <br> at org.apache.avalon.fortress.impl.handler.AbstractComponentHandler.prepareHan= dler(AbstractComponentHandler.java:147)<br> <br> at org.apache.avalon.fortress.impl.handler.AbstractCompo= nentHandler.get(AbstractComponentHandler.java:177)<br> <br> at org.apache.avalon.fortress.impl.handler.LEAwareCompon= entHandler.get(LEAwareComponentHandler.java:96)<br> <br> at org.apache.avalon.fortress.impl.lookup.FortressServic= eManager.lookup(FortressServiceManager.java:99)<br> <br> ... 19 more</div> <br> <br> <br> ------=_Part_3416_833514.1128976446605-- http://keelframework.org/documentation.shtml Keelgroup mailing list [email protected] http://lists.keelframework.com/listinfo.cgi/keelgroup-keelframework.com