[JBoss jBPM] - Re: Looking for Paid JBPM MySQL Server Setup
by ChuckP
kukeeltje: that would be great, let me give that a shot.
I have two issues, the first is an error on launch that reads:
"--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss.jca:service=DataSourceBinding,name=MySqlDS
State: NOTYETINSTALLED
Depends On Me:
jboss.mq:service=PersistenceManager
ObjectName: jboss.jca:service=DataSourceBinding,name=DefaultDS
State: NOTYETINSTALLED
Depends On Me:
jboss.ejb:service=EJBTimerService,persistencePolicy=database
jboss:service=KeyGeneratorFactory,type=HiLo
jboss.mq:service=StateManager
"
I am almost certian this has something to do with the "mysql-jdbc2-service.xml" and "mysql-jdbc-state-service.xml" files in /server/jbpm/deploy/jms/
then the other error, the one I can never seem to get rid of is:
"00:13:51,701 WARN [JDBCExceptionReporter] SQL Error: 1064, SQLState: 42000
00:13:51,702 ERROR [JDBCExceptionReporter] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1 job0_.ID_ as ID1_26_, job0_.VERSION_ as VERSION3_26_, job0_.DUEDATE_ as DUEDAT' at line 1
00:13:51,702 ERROR [JobSession] org.hibernate.exception.SQLGrammarException: could not execute query
00:13:51,705 ERROR [JobExecutorThread] exception in job executor thread. waiting 5000 milliseconds
org.jbpm.JbpmException: couldn't get acquirable jobs"
This I believe might have something to do with the fact that I have not populated the MySQL database with any data. It did auto create the tables, however there is no data in there. I tried to import the jbpmDB.script file, but I guess that is not formatted for MySQL. Or perhaps I have the library setup incorrectly.
I do have "mysql-connector-java-3.1.14-bin.jar" in /server/jbpm/lib
I have tried multiple tutorials online and the second error always seems to be my result.
Thank you,
Chuck Pearce
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4142691#4142691
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4142691
18 years
[Messaging, JMS & JBossMQ] - (MDB) Authentication issue with JBossMessaging
by lhunath
I've been working on migrating from JBossMQ to JBossMessaging with JBoss AS 4.2.2.GA. I'm using JBossMessaging 1.4.0.SP3.
Our JBoss AS is completely configured through Maven. We put the JBoss AS as a zip artifact in a local repository; extract it from there using the maven-depenency-plugin and do some assembling to get the correct libraries in the correct locations with the maven-assembly-plugin. Configuration is done through maven filtering the JBoss XML configuration files. All this worked perfectly before I started the migration to JBossMessaging from JBossMQ.
Seeing as so much has been customized about our JBoss AS, I went about this manually rather than using the script.
| * I removed the jbossmq.jar from server/default/lib.
| * I moved jms-ds.xml and jms-ra.rar from server/default/deploy/jms into server/default/deploy and removed the server/default/deploy/jms directory.
| * In server/default/conf/standardjboss.xml I toggled CreateJBossMQDestination to false.
| * In server/default/conf/login-config.xml I commented the JBossMQ application-policy and added one for JBossMessaging: http://www.lhunath.lyndir.com/stuff/login-config.xml
| * In server/default/conf/jboss-service.xml I removed jboss.mq:service=DestinationManager
| * Removed server/default/deploy/jboss-messaging.sar/hsqldb-persistence-service.xml and replaced it with the mysql-persistence-service.xml from the examples directory. Modifications made to the mysql-persistence-service.xml include changing of DefaultDS to the DS we use and removed all POPULATE.TABLES.X instances except for the guest ones. See http://www.lhunath.lyndir.com/stuff/mysql-persistence-service.xml.
|
Any files not mentioned are kept at their defaults.
Additionally, the SAR that configures our MDBs has the following done to META-INF/jboss-service.xml:
| * Added the following to the top of the file:
| <loader-repository>jboss.messaging:loader=ScopedLoaderRepository
| | <loader-repository-config>java2ParentDelegation=false</loader-repository-config>
| | </loader-repository>
| * Replaced by <mbean code="org.jboss.jms.server.destination.QueueService" name="safeonline:service=Queue,name=outgoing-email" xmbean-dd = "xmdesc/Queue-xmbean.xml">
| * Replaced the depends of this mbean by <depends optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer and jboss.messaging:service=PostOffice.
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4142685#4142685
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4142685
18 years
[EJB 3.0] - Re: ClassCastException: $Proxy94 cannot be cast ...
by jaikiran
"ttrepper" wrote :
|
| My question now is how an ear-file is best packed and with which structure?
|
| The structure looks similar like this:
|
| test (ear)
| + testEJB (holds EJBs)
| + testWeb (holds JSPs)
| + testUtil (holds Helper-Classes and Utils) (needed by web and ejb)
| + testComponents (holds components - only needed by web)
|
| What is the best structure to pack the libs (incl. third-party like tomahawk) into the ear? What in ear-web-inf/lib, what in web.jar-web-inf/lib, etc?
|
| Thank you very much for the help
|
| Thomas
Going by what you describe about your application, this is how the packaging should look like:
| Test.ear
| |
| |--- META-INF
| | |
| | |--- application.xml
| | |
| | |--- jboss-app.xml
| |
| |
| |--- lib (This will contain all libraries required by both the ejb and web)
| | |
| | |
| | |--- testUtil.jar
| | |
| | |--- tomahawk.jar
| |
| |
| |--- testEjb.jar
| |
| |
| |--- testWeb.war
| | |
| | |--- WEB-INF
| | | |
| | | |--- lib (contains libraries required only by the web)
| | | | |
| | | | |--- testComponents.jar
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4142672#4142672
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4142672
18 years