thanks for quick reply, kukeltje :)
well I can login to the console using alex/password which is part of the test
data inserted into the DB. All the other menu tabs seem to work fine and don't
throw any errors.
Once I get to the reporting tab then the error shows up in the log file. A
similar error appeared when I tried JBPM 4.1 + mySQL + Jboss 5.1.0GA. It said
user 'sa'@localhost was not valid, etc. That's when I inserted the jbpmtest
user/pass into the jbpm.hibernate.cfg.xml (overriding the 'sa' user?). That
solved it on mySQL but not for Sybase.
I've attached more of the log, from the point where you click on the Reporting
Tab -> Available Reports -> Processes
2009-09-14 13:01:20,375 INFO
[org.eclipse.birt.report.model.metadata.StructRefPropertyType]
(http-127.0.0.1-8080-4) The value of the structure property is a string
| 2009-09-14 13:01:20,422 INFO
[org.eclipse.birt.report.model.metadata.StructRefPropertyType]
(http-127.0.0.1-8080-4) The value of the structure property is a string
| 2009-09-14 13:01:23,562 INFO
[org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager]
(http-127.0.0.1-8080-4) Found JDBC driverinfo extension:
driverClass=org.apache.derby.jdbc.EmbeddedDriver, connectionFactory=null
| 2009-09-14 13:01:23,578 INFO
[org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager]
(http-127.0.0.1-8080-4) Found JDBC driverinfo extension:
driverClass=org.eclipse.birt.report.data.oda.sampledb.Driver,
connectionFactory=org.eclipse.birt.report.data.oda.sampledb.SampleDBJDBCConnectionFactory
| 2009-09-14 13:01:23,609 WARN
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool]
(http-127.0.0.1-8080-4) Destroying connection that could not be successfully
matched:
org.jboss.resource.connectionmanager.txconnectionmanager$txconnectioneventliste...@1f9f777[state=normal
mc=org.jboss.resource.adapter.jdbc.local.localmanagedconnect...@1a7125b
handles=0 lastUse=1252926080375 permit=false trackByTx=false
mcp=org.jboss.resource.connectionmanager.jbossmanagedconnectionpool$onep...@1a632f5
context=org.jboss.resource.connectionmanager.internalmanagedconnectionp...@5b9ec1
xaresource=org.jboss.resource.connectionmanager.txconnectionmanager$localxaresou...@1e5c671
txSync=null]
| 2009-09-14 13:01:23,625 WARN
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool]
(http-127.0.0.1-8080-4) Destroying connection that could not be successfully
matched:
org.jboss.resource.connectionmanager.txconnectionmanager$txconnectioneventliste...@23cda8[state=normal
mc=org.jboss.resource.adapter.jdbc.local.localmanagedconnect...@1139a51
handles=0 lastUse=1252926071376 permit=false trackByTx=false
mcp=org.jboss.resource.connectionmanager.jbossmanagedconnectionpool$onep...@1a632f5
context=org.jboss.resource.connectionmanager.internalmanagedconnectionp...@5b9ec1
xaresource=org.jboss.resource.connectionmanager.txconnectionmanager$localxaresou...@1b84919
txSync=null]
| 2009-09-14 13:01:23,641 WARN
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool]
(http-127.0.0.1-8080-4) Throwable while attempting to get a new connection: null
| org.jboss.resource.JBossResourceException: Could not create connection; -
nested throwable: (java.sql.SQLException: Login failed)
| at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:225)
| at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:195)
| at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:633)
| at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:267)
| at
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:622)
| at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
| at
org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)
| at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
| at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
| at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:104)
| at
org.eclipse.birt.report.data.oda.jdbc.JndiDataSource.getDataSourceConnection(JndiDataSource.java:159)
| at
org.eclipse.birt.report.data.oda.jdbc.JndiDataSource.getConnection(JndiDataSource.java:133)
| at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getJndiDSConnection(JDBCDriverManager.java:284)
| at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:205)
| at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:179)
| at
org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:220)
| at
org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:151)
| at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:235)
| at
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:157)
| at
org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:236)
| at
org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:223)
| at
org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:209)
| at
org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:390)
| at
org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:309)
| at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:498)
| at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:189)
| at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:177)
| at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:143)
| at
org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:482)
| at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:115)
| at
org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
| at
org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1755)
| at
org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:77)
| at
org.eclipse.birt.report.engine.executor.GridItemExecutor.execute(GridItemExecutor.java:64)
| at
org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
| at
org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
| at
org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:33)
| at
org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
| at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
| at
org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)
| at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:151)
| at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:72)
| at org.jboss.bpm.report.BirtService.render(BirtService.java:163)
| at
org.jboss.bpm.report.ReportFacade.viewReportHtml(ReportFacade.java:139)
| 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:597)
| at
org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:117)
| at
org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:260)
| at
org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:232)
| at
org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:166)
| at
org.jboss.resteasy.core.DispatcherUtilities.getJaxrsResponse(DispatcherUtilities.java:142)
| at
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)
| at
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:173)
| at
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:93)
| at
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:68)
| at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
| at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
| at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
| at
org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)
| at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
| at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
| at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
| at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
| at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
| at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
| at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
| at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
| at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
| at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
| at
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
| at
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
| at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
| at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
| at
org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
| at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
| at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
| at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
| at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
| at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
| at java.lang.Thread.run(Thread.java:619)
| Caused by: java.sql.SQLException: Login failed
| at
net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
| at net.sourceforge.jtds.jdbc.TdsCore.tdsLoginAckToken(TdsCore.java:2952)
| at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2260)
| at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:602)
| at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:344)
| at
net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
| at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
| at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:207)
| ... 81 more
I suspect this line might allude to it being a DTM error:
(http-127.0.0.1-8080-4) Throwable while attempting to get a new connection: null
Here's a shot of the Datasource file: jbpm-sybase-ds.xml file
<datasources>
| <local-tx-datasource>
| <jndi-name>JbpmDS</jndi-name>
| <connection-url>jdbc:jtds:sybase://{servername
edited}:7550/jbpmdb</connection-url>
| <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
| <user-name>jbpmtest</user-name>
| <password>jbpmtest</password>
|
| <!-- reduce isolation from the default level (repeatable read) -->
|
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
| <!-- separate connections used with and without JTA transaction -->
| <no-tx-separate-pools />
| <!-- disable transaction interleaving -->
| <track-connection-by-tx />
| <metadata>
| <type-mapping>Sybase</type-mapping>
| </metadata>
| </local-tx-datasource>
| </datasources>
|
I have tried it with an XA datasource and it doesn't even startup properly:
13:16:54,328 ERROR [JDBCExceptionReporter] Unable to get managed connection for
JbpmDS; - nested thr
| owable: (javax.resource.ResourceException: Unable to get managed connection
for JbpmDS)
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4255055#4255055
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4255055
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user
