elcool [
http://community.jboss.org/people/elcool] created the discussion
"Error loading DataSources with FileNet CE"
To view the discussion, visit:
http://community.jboss.org/message/570577#570577
--------------------------------------------------------------
I've installed FileNet 4.5 with WAS about 10 times already, but now our client is
using JBoss... so naturally errors are everywhere as I've never used JBoss with
FileNet.
I'm using JBoss 4.2.3.GA on Windows Server 2008 R2 (64-bit)
I used the FileNet Configuration Manager to create the Datasources and I can see that
inside jboss\config\server I have the XMLs describing the DataSources.
Is this the only place they are created?
How can I test the connections are working with the user I specify?
If I go to
http://localhost:8080/P8CE/Health http://localhost:8080/P8CE/Health, it shows
without error.
If I go to
http://localhost:8080/FileNet/Engine http://localhost:8080/FileNet/Engine it
shows the following error:
com.filenet.api.exception.EngineRuntimeException: E_FAILED_TO_GET_DATASOURCE: Failed to
get DataSource FNGCDDS. at
com.filenet.engine.context.ServerCallContext.getConnectionWithRetry(ServerCallContext.java:942)
at com.filenet.engine.context.ServerCallContext.getConnection(ServerCallContext.java:895)
at com.filenet.engine.context.ServerCallContext._getDBContext(ServerCallContext.java:653)
at
com.filenet.engine.context.ServerCallContext.getDBContextFromJNDIValues(ServerCallContext.java:826)
at com.filenet.engine.dbpersist.DBContext.determineDatabaseType(DBContext.java:661) at
com.filenet.engine.gcd.GCDDBPersistence.(GCDDBPersistence.java:130) at
com.filenet.engine.gcd.GCDPersistence.getGCDPersistence(GCDPersistence.java:171) at
com.filenet.engine.gcd.GCD.initialize(GCD.java:226) at
com.filenet.engine.gcd.GCD.domainAvailable(GCD.java:183) at
com.filenet.engine.gcd.GCD.isDomainAvailable(GCD.java:119) at
com.filenet.engine.gcd.GCD.getContextInfo(GCD.java:142) at
com.filenet.engine.init.StartupUtility.start(StartupUtility.java:141) at
com.filenet.engine.init.StartupUtility.access$000(StartupUtility.java:40) at
com.filenet.engine.init.StartupUtility$1.run(StartupUtility.java:68) at
java.security.AccessController.doPrivileged(Native Method) at
javax.security.auth.Subject.doAs(Unknown Source) at
com.filenet.apiimpl.authentication.util.J2EEAuthnUtil.runAs(J2EEAuthnUtil.java:533) at
com.filenet.apiimpl.authentication.util.J2EEAuthnUtilJB.runAs(J2EEAuthnUtilJB.java:280) at
com.filenet.apiimpl.util.J2EEUtilJB.doAs(J2EEUtilJB.java:103) at
com.filenet.engine.context.CallState.doAsSystem(CallState.java:354) at
com.filenet.engine.init.StartupUtility.startASSystem(StartupUtility.java:63) at
com.filenet.engine.jca.impl.ConnectionFactoryImpl.start(ConnectionFactoryImpl.java:120) at
engine.EngineInit._init(EngineInit.java:73) at engine.EngineInit.init(EngineInit.java:145)
at javax.servlet.GenericServlet.init(GenericServlet.java:212) at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1161) at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981) at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4071) at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4375) at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:790) at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:770) at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:553) 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.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296) at
org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164) at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at
org.apache.catalina.core.StandardContext.init(StandardContext.java:5312) 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.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296) at
org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164) at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at
org.jboss.web.tomcat.service.TomcatDeployer.performDeployInternal(TomcatDeployer.java:301)
at org.jboss.web.tomcat.service.TomcatDeployer.performDeploy(TomcatDeployer.java:104) at
org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:375) at
org.jboss.web.WebModule.startModule(WebModule.java:83) at
org.jboss.web.WebModule.startService(WebModule.java:61) at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289) at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at
java.lang.reflect.Method.invoke(Unknown Source) at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at
org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at
org.jboss.mx.server.Invocation.invoke(Invocation.java:86) at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978) at
$Proxy0.start(Unknown Source) at
org.jboss.system.ServiceController.start(ServiceController.java:417) at
sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at
java.lang.reflect.Method.invoke(Unknown Source) at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at
org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at
org.jboss.mx.server.Invocation.invoke(Invocation.java:86) at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at
org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) at $Proxy44.start(Unknown
Source) at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:466) 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.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at
org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133) at
org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97) at
org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorServiceMBeanSupport.java:238)
at org.jboss.wsf.container.jboss42.DeployerInterceptor.start(DeployerInterceptor.java:87)
at
org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188)
at org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:95) at
org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at
org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) at $Proxy45.start(Unknown
Source) at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025) at
org.jboss.deployment.MainDeployer.start(MainDeployer.java:1015) at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819) at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782) at
sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at
java.lang.reflect.Method.invoke(Unknown Source) at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at
org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133) at
org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at
org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) at $Proxy9.deploy(Unknown
Source) at
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421) at
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634) at
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
at
org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at
java.lang.reflect.Method.invoke(Unknown Source) at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at
org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at
org.jboss.mx.server.Invocation.invoke(Invocation.java:86) at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978) at
$Proxy0.start(Unknown Source) at
org.jboss.system.ServiceController.start(ServiceController.java:417) at
sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at
java.lang.reflect.Method.invoke(Unknown Source) at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at
org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at
org.jboss.mx.server.Invocation.invoke(Invocation.java:86) at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at
org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) at $Proxy4.start(Unknown
Source) at org.jboss.deployment.SARDeployer.start(SARDeployer.java:304) at
org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025) at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819) at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782) at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766) 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.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155) at
org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133) at
org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264) at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at
org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) at $Proxy5.deploy(Unknown
Source) at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482) at
org.jboss.system.server.ServerImpl.start(ServerImpl.java:362) at
org.jboss.Main.boot(Main.java:200) at org.jboss.Main$1.run(Main.java:508) at
java.lang.Thread.run(Unknown Source) Caused by: org.jboss.util.NestedSQLException: Could
not create connection; - nested throwable: (org.jboss.resource.JBossResourceException:
Failed to register driver for: com.microsoft.sqlserver.jdbc.SQLServerDriver; - nested
throwable: (java.lang.ClassNotFoundException:
com.microsoft.sqlserver.jdbc.SQLServerDriver)); - nested throwable:
(org.jboss.resource.JBossResourceException: Could not create connection; - nested
throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for:
com.microsoft.sqlserver.jdbc.SQLServerDriver; - nested throwable:
(java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver))) at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
at
com.filenet.engine.context.ServerCallContext$GetConnection.run(ServerCallContext.java:1430)
at
com.filenet.engine.context.ServerCallContext.getConnectionWithRetry(ServerCallContext.java:917)
... 162 more Caused by: org.jboss.resource.JBossResourceException: Could not create
connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to
register driver for: com.microsoft.sqlserver.jdbc.SQLServerDriver; - nested throwable:
(java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver)) at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:190)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:619)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:264)
at
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:575)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:347)
at
org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:330)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:402)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:849)
at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
... 164 more Caused by: org.jboss.resource.JBossResourceException: Failed to register
driver for: com.microsoft.sqlserver.jdbc.SQLServerDriver; - nested throwable:
(java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver) at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getDriver(LocalManagedConnectionFactory.java:298)
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:171)
... 172 more Caused by: java.lang.ClassNotFoundException:
com.microsoft.sqlserver.jdbc.SQLServerDriver at java.net.URLClassLoader$1.run(Unknown
Source) at java.security.AccessController.doPrivileged(Native Method) at
java.net.URLClassLoader.findClass(Unknown Source) at
java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown
Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown
Source) at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getDriver(LocalManagedConnectionFactory.java:283)
... 173 more
Other notes: I haven't set up JAVA_HOME and it gives me the warning, but everything
seems to run well without it. When I did place it, the server wouldnt even start to
run...
Also: Using run.bat -b=192.168.1.45 (ip of server) throws a bunch of errors when starting
and then only some links work. (ie. /web-console doesn't work)
--------------------------------------------------------------
Reply to this message by going to Community
[
http://community.jboss.org/message/570577#570577]
Start a new discussion in Datasource Configuration at Community
[
http://community.jboss.org/choose-container!input.jspa?contentType=1&...]