<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Set up JBPM5.4 Final Installer to use MS SQL Server 2008 using JTDS
</h3>
<span style="margin-bottom: 10px;">
new comment by <a href="https://community.jboss.org/people/lisadesouza89">Lisa DeSouza</a> <a href="https://community.jboss.org/docs/DOC-47975#comment-11480">View all comments on this document</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>ok, thanks a lot. Figured it out. Had the database server running as a local service instead of network service. <span> :) </span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>But still loads of errors on jbpm-console: <span> :( </span></p><ul><li>ERROR [org.reflections.Reflections] (MSC service thread 1-6) could not create Vfs.Dir from url. ignoring the exception and continuing: org.reflections.ReflectionsException: could not create Dir using org.jboss.errai.bus.server.service.metadata.VFSUrlType from url vfs:/E:/CIBIL-JBPM/jbpm-installer/content/jbpm-gwt-console.war/WEB-INF/classes/ <span style="font-size: 10pt;"> at org.reflections.vfs.Vfs.fromURL(Vfs.java:99) </span></li><li>ERROR [org.reflections.Reflections] (MSC service thread 1-6) could not create Vfs.Dir from url. ignoring the exception and continuing: org.reflections.ReflectionsException: could not create Dir using org.jboss.errai.bus.server.service.metadata.VFSUrlType from url vfs:/E:/CIBIL-JBPM/jbpm-installer/content/jbpm-gwt-console.war/WEB-INF/lib/activity-monitor-ui-lib-1.1.1.Final.jar/ <span style="font-size: 10pt;"> at org.reflections.vfs.Vfs.fromURL(Vfs.java:99)</span></li><li>ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (MSC service thread 1-5) HHH000299: Could not complete schema update: java.lang.UnsupportedOperationException: The application must supply JDBC connections  at org.hibernate.service.jdbc.connections.internal.UserSuppliedConnectionProviderImpl.getConnection(UserSuppliedConnectionProviderImpl.java:62) </li><li>ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/jbpm-human-task-war]] (MSC service thread 1-5) StandardWrapper.Throwable: javax.persistence.PersistenceException: No Persistence provider for EntityManager named org.jbpm.task</li><li>ERROR [org.jbpm.integration.console.StatefulKnowledgeSessionUtil] (http-localhost-127.0.0.1-8080-5) Could not initialize stateful knowledge session: No Persistence provider for EntityManager named org.jbpm.persistence.jpa: javax.persistence.PersistenceException: No Persistence provider for EntityManager named org.jbpm.persistence.jpa at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:69)</li><li>ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/gwt-console-server].[Resteasy]] (http-localhost-127.0.0.1-8080-5) Servlet.service() for servlet Resteasy threw exception: org.jboss.resteasy.spi.UnhandledException: java.lang.RuntimeException: Session was not initialized, check previous errors in log at org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:340) [resteasy-jaxrs-2.3.2.Final.jar:]</li></ul><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>But at least with MSSQL the applications deploy. Sorry to be such a pain and keep asking questions. </p></div>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>