[Installation, Configuration & DEPLOYMENT] - JBOSS JBPM configuration error with mssql 2005
by srufus
Hi all,
I m trying to set JBOSS JBPM configuration on jboss-soa-p.4.3.0.
Im using MSSQL 2005 as DB. I configured Data source in jbpm-ds.xml.Some 32 jbpm tables are created in DB.
I face following error during server start up, not sure ..what could be problem.Thanks for any help...
error stack:
=======
2009-03-10 14:44:29,417 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 102, SQLState: S0001
2009-03-10 14:44:29,417 ERROR [org.hibernate.util.JDBCExceptionReporter] Incorrect syntax near '@P0'.
2009-03-10 14:44:29,417 ERROR [org.jbpm.db.JobSession] org.hibernate.exception.SQLGrammarException: could not execute query
2009-03-10 14:44:29,417 ERROR [org.jbpm.job.executor.JobExecutorThread] exception in job executor thread. waiting 5000 milliseconds
org.jbpm.JbpmException: couldn't get acquirable jobs
at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:44)
at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread.java:114)
at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:58)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:40)
... 2 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '@P0'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:255)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:187)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
... 11 more
2009-03-10 14:44:35,901 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 102, SQLState: S0001
2009-03-10 14:44:35,901 ERROR [org.hibernate.util.JDBCExceptionReporter] Incorrect syntax near '@P0'.
2009-03-10 14:44:35,901 ERROR [org.jbpm.db.JobSession] org.hibernate.exception.SQLGrammarException: could not execute query
2009-03-10 14:44:35,901 ERROR [org.jbpm.job.executor.JobExecutorThread] exception in job executor thread. waiting 10000 milliseconds
org.jbpm.JbpmException: couldn't get acquirable jobs
at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:44)
at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread.java:114)
at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:58)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:40)
... 2 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '@P0'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:255)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:187)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
... 11 more
thanks,
vasu
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4216478#4216478
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4216478
17 years, 1 month
[Beginners Corner] - Re: Urgent => java.lang.NoClassDefFoundError : jboss Startup
by gohil_jigar
JAR & WAR both are separate...
& also the Manifest.mf of the WAR doesn't contain a reference to the EJB JAR...
============================
STRUCTURE OF Deploy Directory of Jboss
============================
\jboss-4.0.new3\server\default\deploy]
|- [http-invoker.sar]
| |- [invoker.war]
| | |- [WEB-INF]
| | |- [classes]
| | | |- [org]
| | | |- [jboss]
| | | |- [invocation]
| | | |- [http]
| | | |- [servlet]
| | | |- InvokerServlet$GetCredentialAction.class
| | | |- InvokerServlet$GetPrincipalAction.class
| | | |- InvokerServlet.class
| | | |- NamingFactoryServlet.class
| | | *- ReadOnlyAccessFilter.class
| | |- jboss-web.xml
| | *- web.xml
| |- [META-INF]
| |- jboss-service.xml
|- [jboss-aop.deployer]
| |- [META-INF]
| | |- jboss-service.xml
| | *- MANIFEST.MF
| |- base-aop.xml
| |- javassist.jar
| |- jboss-aop.jar
| |- jboss-aspect-library.jar
| *- trove.jar
|- [jboss-hibernate.deployer]
| |- cglib-full-2.0.1.jar
| *- hibernate2.jar
|- [jbossweb-tomcat50.sar]
|- [jboss-ws4ee.sar]
|- [jfree_demo.war]
|- [jms]
|- [jmx-console.war]
|- [management]
|- [MoneyMaximizerEJB.jar]
|- [MoneyMaximizerWeb.war]
|- bsh-deployer.xml
|- cache-invalidation-service.xml
|- client-deployer-service.xml
|- ear-deployer.xml
|- ejb-deployer.xml
|- hsqldb-ds.xml
|- jbossjca-service.xml
|- jboss-local-jdbc.rar
|- jboss-xa-jdbc.rar
|- jmx-invoker-service.xml
|- mail-ra.rar
|- mail-service.xml
|- monitoring-service.xml
|- mysql-ds.xml
|- mysql-ds.xml.bak
|- mysqlndb-ds.xml
|- mysqlndb-ds.xml.bak
|- properties-service.xml
|- schedule-manager-service.xml
|- scheduler-service.xml
|- sqlexception-service.xml
*- uuid-key-generator.sar
==============
STRUCTURE => jar
==============
\jboss-4.0.new2\server\default\deploy\MoneyMaximizerEJB.jar]
|- [com]
| |- [moneymax]
| |- [apptier]
| | |- [adminworkflow]
| | | |- [broker]
| | | | |- [ejb]
| | | | | |- Broker.class
| | | | | |- BrokerBean.class
| | | | | *- BrokerHome.class
| | | | *- BrokerBOImpl.class
| | | |- [currency]
| | | | |- [ejb]
| | | | | |- Currency.class
| | | | | |- CurrencyEJB.class
| | | | | *- CurrencyHome.class
| | | | *- CurrencyBOImpl.class
| | | |- [exchange]
| | | | |- [ejb]
| | | | | |- Exchange.class
| | | | | |- ExchangeEJB.class
| | | | | *- ExchangeHome.class
| | | | *- ExchangeBOImpl.class
| | | |- [futuregearing]
| | | | |- [ejb]
| | | | | |- FutureGearing.class
| | | | | |- FutureGearingEJB.class
| | | | | *- FutureGearingHome.class
| | | | *- FutureGearingBOImpl.class
| | | |- [holiday]
| | | | |- [ejb]
| | | | | |- Holiday.class
| | | | | |- HolidayEJB.class
| | | | | *- HolidayHome.class
| | | | *- HolidayBOImpl.class
| | | |- [instrument]
| | | | |- [bonds]
| | | | | |- [ejb]
| | | | | | |- Bonds.class
| | | | | | |- BondsEJB.class
| | | | | | *- BondsHome.class
| | | | | *- BondsBOImpl.class
| | | | |- [equity]
| | | | | |- [ejb]
| | | | | | |- Equity.class
| | | | | | |- EquityEJB.class
| | | | | | *- EquityHome.class
| | | | | *- EquityBOImpl.class
| | | | |- [equityoptions]
| | | | | |- [ejb]
| | | | | | |- EquityOption.class
| | | | | | |- EquityOptionEJB.class
| | | | | | *- EquityOptionHome.class
| | | | | *- EquityOptionBOImpl.class
| | | | |- [forex]
| | | | | |- [ejb]
| | | | | | |- Forex.class
| | | | | | *- ForexEJB.class
| | | | | *- ForexBOImpl.class
| | | | |- [futureoptions]
| | | | |- [futures]
| | | | |- [mutualfunds]
| | | |- [instrumentmasterupload]
| | | |- [stocksplit]
| | | |- [usermaintenance]
| | |- [commonworkflow]
| | |- [fix]
| | |- [onlinepricefeed]
| | |- [riskmath]
| | |- [userworkflow]
| | |- [utility]
| |- [datatier]
| |- [framework]
| |- [hibernate]
| |- [hibernatendb]
| |- [processes]
| |- [riskmath]
| |- [util]
| |- [valueobject]
|- [META-INF]
|- Alerts.properties
|- FIX.properties
|- log4j.properties
*- moneymax.properties
==============================
U can check out the path of UtilityDAO class its correct....
==============================
\jboss-4.0.new2\server\default\deploy\MoneyMaximizerEJB.jar\com\moneymax\datatier]
|- [adminworkflow]
| |- [broker]
| | |- BrokerMasterDAO.class
| | |- CountryMasterDAO.class
| | |- TblBrokerTypeDAO.class
| | |- TblBrokerTypeDetDAO.class
| | *- TblInstrumentMasterDAO.class
| |- [currency]
| | |- CurrencyMasterDAO.class
| |- [exchange]
| | |- ExchangeMasterDAO.class
| |- [futuregearing]
| | |- FutureGearingDAO.class
| |- [holiday]
| | |- HolidayMasterDAO.class
| |- [instrument]
| | |- BondsDAO.class
| | |- EquityDAO.class
| | |- EquityOptionDAO.class
| | |- ForexDAO.class
| | |- FuturesDAO.class
| | *- MutualFundDAO.class
| |- [instrumentmasterupload]
| | |- InstrumentMasterUploadDAO.class
| |- [stocksplit]
| | |- StockSplitDAO.class
| |- [usermaintenance]
| |- UserMainDAO.class
|- [commonworkflow]
| |- [alerts]
| | |- AlertsDAO.class
| |- [audittrail]
| | |- AuditTrailDAO.class
| |- [calculator]
| | |- CalculatorDAO.class
| |- [checkit]
| |- [executionorder]
| | |- ExecutionOrderDAO.class
| | *- ExecutionOrderDao1.class
| |- [newscharts]
| | |- NewsChartsDAO.class
| |- [notes]
| | |- NotesDAO.class
| |- [performance]
| | |- PerformanceReportDAO.class
| |- [protectit]
| | |- ProtectItDAO.class
| |- [risk]
| | |- RiskDAO.class
| |- [riskmath]
| |- [riskmonitor]
| | |- RiskMonitorDAO.class
| |- [riskreport]
| | |- RiskReportDAO.class
| |- [setpricealert]
| | |- SetPriceAlertDAO.class
| |- [sizeit]
| | |- InstrumentMasterDAO.class
| | |- StoporderPerVariantsDAO.class
| | *- TransactionTypesDAO.class
| |- [stopadjuster]
| |- [trackit]
| | |- TrackitDao.class
| |- [tradeit]
| | |- TradeItDAO.class
| | |- TradeItInsertDAO.class
| | *- TradeItNDBDao.class
| |- [traderegister]
| |- [workingorder]
|- [fix]
|- [onlinepricefeed]
|- [reuters]
|- [riskmath]
|- [userworkflow]
*- UtilityDAO.class
===============================
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4216473#4216473
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4216473
17 years, 1 month
[EJB 3.0] - Re: @embedable annotation
by itsme
For the first one (use of @Embaddable and @Embedded) Customer class must be changed to:
| @Entity
| public class Customer implements Serializable {
| // ... your member fields
| private Address address;
| // ... your set-/get-Methods
| @Embedded
| public Address getAddress() {
| return address;
| }
| // ... setter as well
| }
|
For the second one (keeping @Embeddable and building a wrapper):
| @Entity
| public class AddressWrapper implements Serializable {
|
| @Id
| private String id;
|
| @Embedded
| private Address address;
|
| // getter and setter
| }
|
In this case your Customer class must be changed like
| @Entity
| public class Customer implements Serializable {
| // ... your member fields
| private AddressWrapper address;
| // ... your set-/get-Methods
| @OneToOne
| public AddressWrapper getAddress() {
| return address;
| }
| // ... setter as well
| }
|
For the last one you must change the annotation of Address to @Entity and change your Customer class like the above (without Wrapper).
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4216472#4216472
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4216472
17 years, 1 month
[EJB 3.0] - Re: @embedable annotation
by kkangsar
This is what i did
@Embeddable
public class Address implements Serializable{
private static final long serialVersionUID = 1L;
private String addr1;
private String addr2;
private String addr3;
@Column(name="ADDR1", length=30)
public String getAddr1() {
return addr1;
}
public void setAddr1(String addr1) {
this.addr1 = addr1;
}
@Column(name="ADDR2", length=30)
public String getAddr2() {
return addr2;
}
public void setAddr2(String addr2) {
this.addr2 = addr2;
}
@Column(name="ADDR3", length=30)
public String getAddr3() {
return addr3;
}
public void setAddr3(String addr3) {
this.addr3 = addr3;
}
}
@Entity
public class Customer implements java.io.Serializable {
private static final long serialVersionUID = 1L;
private String Id;
private String custName;
@Id
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getCustName() {
return custName;
}
public void setCustName(String custName) {
this.custName = custName;
}
}
I dont know how to embed the address into customer.class. Can you please give some help. Thanks
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4216469#4216469
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4216469
17 years, 1 month