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"
(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
|
