[jboss-user] [JBoss jBPM] - Re: JBoss + JBPM + Mysql - Deployment is not going through

[vperez]

I have only one (*.-ds.xml) file, the "mysql-ds.xml" in "c:/JBoss/jbpm-jpdl-3.2.1/server/server/jbpm/deploy"

In this file: C:\JBoss\jbpm-jpdl-3.2.1\server\server\jbpm\conf\login-config.xml, i modify this: (JbpmDS to DefaultDs)

    <application-policy name = "jbpm">
       
         <login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule"
                       flag="required">
           <module-option name="dsJndiName">java:/DefaultDS</module-option>
           <module-option name="principalsQuery">
             SELECT PASSWORD_ FROM JBPM_ID_USER WHERE NAME_=?
           </module-option>
           <module-option name="rolesQuery">
             SELECT g.NAME_ ,'Roles' 
             FROM JBPM_ID_USER u,
                  JBPM_ID_MEMBERSHIP m,
                  JBPM_ID_GROUP g
             WHERE g.TYPE_='security-role'
               AND m.GROUP_ = g.ID_
               AND m.USER_ = u.ID_
               AND u.NAME_=?
           </module-option>
         </login-module>
       
    </application-policy>


Now i have less errors and i can loggin But I haven't yet been able to deploy couse cant find the datasource


12:17:08,515 FATAL [DatasourceConnectionProvider] Could not find datasource: java:/JbpmDS
javax.naming.NameNotFoundException: JbpmDS not bound
        at org.jnp.server.NamingServer.getBinding(NamingServer.java:529)
        at org.jnp.server.NamingServer.getBinding(NamingServer.java:537)
        at org.jnp.server.NamingServer.getObject(NamingServer.java:543)
        at org.jnp.server.NamingServer.lookup(NamingServer.java:296)
        at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:625)
        at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:587)
        at javax.naming.InitialContext.lookup(InitialContext.java:351)
        at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:52)
        at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
        at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
        at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:385)
        at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:61)
        at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1928)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1211)
        at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:91)
        at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:94)
        at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:98)
        at org.jbpm.persistence.db.DbPersistenceService.getJobSession(DbPersistenceService.java:354)
        at org.jbpm.JbpmContext.getJobSession(JbpmContext.java:563)
        at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread.java:109)
        at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:56)
12:17:08,625 ERROR [JobExecutorThread] exception in job executor thread. waiting 5000 milliseconds
org.hibernate.HibernateException: Could not find datasource
        at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:56)
        at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
        at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
        at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:385)
        at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:61)
        at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1928)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1211)
        at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:91)
        at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:94)
        at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:98)
        at org.jbpm.persistence.db.DbPersistenceService.getJobSession(DbPersistenceService.java:354)
        at org.jbpm.JbpmContext.getJobSession(JbpmContext.java:563)
        at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread.java:109)
        at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:56)
Caused by: javax.naming.NameNotFoundException: JbpmDS not bound
        at org.jnp.server.NamingServer.getBinding(NamingServer.java:529)
        at org.jnp.server.NamingServer.getBinding(NamingServer.java:537)
        at org.jnp.server.NamingServer.getObject(NamingServer.java:543)
        at org.jnp.server.NamingServer.lookup(NamingServer.java:296)
        at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:625)
        at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:587)
        at javax.naming.InitialContext.lookup(InitialContext.java:351)
        at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:52)
		
thanks for your help,  Victoria

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4080060#4080060

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4080060