JBossDeveloper

Ok. Some of my mistakes with weak responses/tips from the Tools/IDE component(s).

I right-clicked my project name in the Hibernate Configurations view and selected edit config. What do I need to select for persistence unit? why isn't that a drop-down?? I entered 'boBETS' which is in BETS\resources\META-INF\persistence.xml as follows:

<?xml version="1.0" encoding="UTF-8"?>
<!-- Persistence deployment descriptor for dev profile -->
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"
 version="1.0">

 <persistence-unit name="boBETS">
 <provider>org.hibernate.ejb.HibernatePersistence</provider>
 <jta-data-source>java:/boBETSDatasource</jta-data-source>
 <properties>
 <property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialect"/>
 <!-- <property name="hibernate.hbm2ddl.auto" value="validate"/> -->
 <property name="hibernate.show_sql" value="true"/>
 <property name="hibernate.format_sql" value="true"/>
 <property name="jboss.entity.manager.factory.jndi.name" value="java:/boBETSEntityManagerFactory"/>
 <property name="hibernate.default_catalog" value="boBETS"/>
 <property name="hibernate.default_schema" value="dbo"/>
 </properties>
 </persistence-unit>

</persistence>

severity: error

message: org.hibernate.console.HibernateConsoleRuntimeException: Persistence unit not found: 'boBETS'.

exception stack trace: org.hibernate.console.HibernateConsoleRuntimeException: Persistence unit not found: 'boBETS'.
 at org.hibernate.console.ConsoleConfiguration.buildJPAConfiguration(ConsoleConfiguration.java:148)
 at org.hibernate.console.ConsoleConfiguration.buildConfiguration(ConsoleConfiguration.java:541)
 at org.hibernate.console.ConsoleConfiguration.access$0(ConsoleConfiguration.java:526)
 at org.hibernate.console.ConsoleConfiguration$2.execute(ConsoleConfiguration.java:222)
 at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:64)
 at org.hibernate.console.ConsoleConfiguration.buildWith(ConsoleConfiguration.java:204)
 at org.hibernate.console.ConsoleConfiguration.build(ConsoleConfiguration.java:111)
 at org.hibernate.eclipse.console.workbench.ConsoleConfigurationWorkbenchAdapter.getChildren(ConsoleConfigurationWorkbenchAdapter.java:40)
 at org.hibernate.eclipse.console.workbench.BasicWorkbenchAdapter.getChildren(BasicWorkbenchAdapter.java:99)
 at org.hibernate.eclipse.console.workbench.BasicWorkbenchAdapter.fetchDeferredChildren(BasicWorkbenchAdapter.java:105)
 at org.eclipse.ui.progress.DeferredTreeContentManager$1.run(DeferredTreeContentManager.java:234)
 at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

#File used by hibernate tools to override <datasource> and other container specific settings in persistence.xml
hibernate.connection.password=JavaTestAcct
hibernate.connection.username=_AppUser_JavaTestAcct
hibernate.connection.driver_class=com.microsoft.sqlserver.jdbc.SQLServerDriver
hibernate.dialect=org.hibernate.dialect.SQLServerDialect
hibernate.connection.url=jdbc:sqlserver://CORG0DB901:1433;databaseName=boBETS

hibernate.connection.provider_class=org.hibernate.connection.DriverManagerConnectionProvider
hibernate.datasource=
hibernate.transaction.manager_lookup_class=

I have determined the following:

1) JBDS 2.0.0.CR2 is bundled with Tools 3.0.0.CR2

2) the below link does not cover the JPA version (only Hibernate). Documentation is thus incomplete.

http://docs.jboss.org/tools/3.0.0.CR2/en/hibernatetools/html/plugins.html#console_conf

Please specify how to setup a hibernate config (or JPA config?) and run HQL/JPAQL queries. This is taking way too long as is the problem I'm having with Seam components view (separate thread).

After upgrading these problems are yet to be resolved...

Here: http://docs.jboss.org/tools/3.0.0.CR2/en/hibernatetools/html/plugins.html#console_conf

It states the following for Persistence unit in the main tab:

"No default value (lets Hibernate Entity Manager find the persistence unit)"

So what happens if there is more than one persistence unit in the persistence.xml? I'm assuming then you must specify and that's what I'm doing...

So I commented the other two persistence units and left boBETS. and it still doesn't work.

I get "Persistence unit not found: 'null'" or "Persistence unit not found: 'boBETS'"

What a total disaster. Switch to Microsoft to avoid these stupid small problems that take days to resolve!

ok, i just added the BETS\resources\meta-inf folder to the classpath in the classpath tab of the edit configuration popup window.

still doesn't work!

there has to be a META-INF/persistence.xml on the classpath.

adding resources\meta-inf doesn't make that happen.

should just be resources and in resources should be a persistence.xml

"max.andersen@jboss.com" wrote:
there has to be a META-INF/persistence.xml on the classpath.

adding resources\meta-inf doesn't make that happen.

should just be resources and in resources should be a persistence.xml

if you put BEST\resources in your classpath the persistence.xml should be located in BEST\resources\META-INF\persistence.xml

Note: in 3.1 we will add in support for random located persistence units to avoid all this fuzzyness ;)

"max.andersen@jboss.com" wrote:
if you put BEST\resources in your classpath the persistence.xml should be located in BEST\resources\META-INF\persistence.xml

Note: in 3.1 we will add in support for random located persistence units to avoid all this fuzzyness ;)

Error
Tue Mar 10 16:48:26 PDT 2009
java.lang.IllegalArgumentException: node to traverse cannot be null!

java.lang.IllegalArgumentException: node to traverse cannot be null!
 at org.hibernate.hql.ast.util.NodeTraverser.traverseDepthFirst(NodeTraverser.java:31)
 at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:254)
 at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:157)
 at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
 at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
 at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
 at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
 at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
 at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
 at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
 at org.hibernate.console.HQLQueryPage.setSession(HQLQueryPage.java:106)
 at org.hibernate.console.ConsoleConfiguration$4.execute(ConsoleConfiguration.java:426)
 at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:64)
 at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:421)
 at org.hibernate.eclipse.hqleditor.HQLEditor.executeQuery(HQLEditor.java:416)
 at org.hibernate.eclipse.console.actions.ExecuteQueryAction.execute(ExecuteQueryAction.java:73)
 at org.hibernate.eclipse.console.actions.ExecuteQueryAction.run(ExecuteQueryAction.java:53)
 at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
 at org.hibernate.eclipse.console.actions.ExecuteQueryAction.runWithEvent(ExecuteQueryAction.java:57)
 at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:583)
 at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:500)
 at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:452)
 at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
 at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
 at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3823)
 at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3422)
 at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2384)
 at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2348)
 at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2200)
 at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:495)
 at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:288)
 at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:490)
 at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
 at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:113)
 at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193)
 at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
 at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
 at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:386)
 at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
 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:585)
 at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:549)
 at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)
 at org.eclipse.equinox.launcher.Main.run(Main.java:1236)

select e from Equipment as e

select a from ApplicationSetting a

@Entity
@Table(name = "Equipment", uniqueConstraints = @UniqueConstraint(columnNames = "SerialNumber"))
public class Equipment implements java.io.Serializable {
...
}

what happens if you just type "from Equipment" ?

the error you get is the hql parser in hibernate seeing something it doesn't understand...

"max.andersen@jboss.com" wrote:
what happens if you just type "from Equipment" ?

the error you get is the hql parser in hibernate seeing something it doesn't understand...

Error
Wed Mar 11 08:13:04 PDT 2009
org.hibernate.hql.ast.QuerySyntaxException: Equipment is not mapped [from Equipment]

org.hibernate.hql.ast.QuerySyntaxException: Equipment is not mapped [from Equipment]
 at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:158)
 at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:87)
 at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:70)
 at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:255)
 at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3056)
 at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2945)
 at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:688)
 at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:544)
 at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
 at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
 at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:228)
 at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:160)
 at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
 at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
 at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
 at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
 at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
 at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
 at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
 at org.hibernate.console.HQLQueryPage.setSession(HQLQueryPage.java:106)
 at org.hibernate.console.ConsoleConfiguration$4.execute(ConsoleConfiguration.java:426)
 at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:64)
 at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:421)
 at org.hibernate.eclipse.hqleditor.HQLEditor.executeQuery(HQLEditor.java:416)
 at org.hibernate.eclipse.console.actions.ExecuteQueryAction.execute(ExecuteQueryAction.java:73)
 at org.hibernate.eclipse.console.actions.ExecuteQueryAction.run(ExecuteQueryAction.java:53)
 at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
 at org.hibernate.eclipse.console.actions.ExecuteQueryAction.runWithEvent(ExecuteQueryAction.java:57)
 at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:583)
 at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:500)
 at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:452)
 at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
 at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
 at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3823)
 at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3422)
 at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2384)
 at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2348)
 at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2200)
 at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:495)
 at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:288)
 at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:490)
 at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
 at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:113)
 at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193)
 at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
 at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
 at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:386)
 at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
 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:585)
 at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:549)
 at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)
 at org.eclipse.equinox.launcher.Main.run(Main.java:1236)

Here's the entire Equipment class:

package com.cox.bets.entity;
// Generated Oct 31, 2008 8:53:40 AM by Hibernate Tools 3.2.0.CR1

import java.util.Date;
import java.util.HashSet;
import java.util.Set;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.OneToMany;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
import javax.persistence.UniqueConstraint;

import org.hibernate.validator.Length;
import org.hibernate.validator.NotNull;

/**
 * Equipment generated by hbm2java
 */
@Entity
@Table(name = "Equipment", uniqueConstraints = @UniqueConstraint(columnNames = "SerialNumber"))
public class Equipment implements java.io.Serializable {

 private int equipmentId;
 private ApplicationUser applicationUserByUpdatedByUserId;
 private ApplicationUser applicationUserByAddedByUserId;
 private String serialNumber;
 private String macaddress;
 private Integer equipmentTypeListCode;
 private Date equipmentServiceDate;
 private Date addedDate;
 private Date updatedDate;
 private String modelNumber;
 private Set<EquipmentRepair> equipmentRepairs = new HashSet<EquipmentRepair>(
 0);

 public Equipment() {
 }

 public Equipment(int equipmentId,
 ApplicationUser applicationUserByUpdatedByUserId,
 ApplicationUser applicationUserByAddedByUserId,
 String serialNumber,
 Date addedDate,
 Date updatedDate) {
 this.equipmentId = equipmentId;
 this.applicationUserByUpdatedByUserId = applicationUserByUpdatedByUserId;
 this.applicationUserByAddedByUserId = applicationUserByAddedByUserId;
 this.serialNumber = serialNumber;
 this.addedDate = addedDate;
 this.updatedDate = updatedDate;
 }
 public Equipment(int equipmentId,
 ApplicationUser applicationUserByUpdatedByUserId,
 ApplicationUser applicationUserByAddedByUserId,
 String serialNumber, String macaddress,
 Integer equipmentTypeListCode, Date equipmentServiceDate,
 Date addedDate, Date updatedDate,
 Set<EquipmentRepair> equipmentRepairs) {
 this.equipmentId = equipmentId;
 this.applicationUserByUpdatedByUserId = applicationUserByUpdatedByUserId;
 this.applicationUserByAddedByUserId = applicationUserByAddedByUserId;
 this.serialNumber = serialNumber;
 this.macaddress = macaddress;
 this.equipmentTypeListCode = equipmentTypeListCode;
 this.equipmentServiceDate = equipmentServiceDate;
 this.addedDate = addedDate;
 this.updatedDate = updatedDate;
 this.equipmentRepairs = equipmentRepairs;
 }

 @Id
 @GeneratedValue(strategy=GenerationType.IDENTITY)
 @Column(name = "EquipmentID", unique = true, nullable = false)
 @NotNull
 public int getEquipmentId() {
 return this.equipmentId;
 }

 public void setEquipmentId(int equipmentId) {
 this.equipmentId = equipmentId;
 }
 @ManyToOne(fetch = FetchType.LAZY)
 @JoinColumn(name = "UpdatedByUserID", nullable = false)
 @NotNull
 public ApplicationUser getApplicationUserByUpdatedByUserId() {
 return this.applicationUserByUpdatedByUserId;
 }

 public void setApplicationUserByUpdatedByUserId(
 ApplicationUser applicationUserByUpdatedByUserId) {
 this.applicationUserByUpdatedByUserId = applicationUserByUpdatedByUserId;
 }
 @ManyToOne(fetch = FetchType.LAZY)
 @JoinColumn(name = "AddedByUserID", nullable = false)
 @NotNull
 public ApplicationUser getApplicationUserByAddedByUserId() {
 return this.applicationUserByAddedByUserId;
 }

 public void setApplicationUserByAddedByUserId(
 ApplicationUser applicationUserByAddedByUserId) {
 this.applicationUserByAddedByUserId = applicationUserByAddedByUserId;
 }

 @Column(name = "SerialNumber", unique = true, nullable = false, length = 50)
 @NotNull
 @Length(max = 50)
 public String getSerialNumber() {
 return this.serialNumber;
 }

 public void setSerialNumber(String serialNumber) {
 this.serialNumber = serialNumber;
 }

 @Column(name = "ModelNumber", length = 50)
 @Length(max = 50)
 public String getModelNumber() {
 return this.modelNumber;
 }

 public void setModelNumber(String modelNumber) {
 this.modelNumber = modelNumber;
 }

 @Column(name = "MACAddress", length = 50)
 @Length(max = 50)
 public String getMacaddress() {
 return this.macaddress;
 }

 public void setMacaddress(String macaddress) {
 this.macaddress = macaddress;
 }

 @Column(name = "EquipmentTypeListCode")
 public Integer getEquipmentTypeListCode() {
 return this.equipmentTypeListCode;
 }

 public void setEquipmentTypeListCode(Integer equipmentTypeListCode) {
 this.equipmentTypeListCode = equipmentTypeListCode;
 }
 @Temporal(TemporalType.TIMESTAMP)
 @Column(name = "EquipmentServiceDate", length = 23)
 public Date getEquipmentServiceDate() {
 return this.equipmentServiceDate;
 }

 public void setEquipmentServiceDate(Date equipmentServiceDate) {
 this.equipmentServiceDate = equipmentServiceDate;
 }
 @Temporal(TemporalType.TIMESTAMP)
 @Column(name = "AddedDate", nullable = false, length = 23)
 @NotNull
 public Date getAddedDate() {
 return this.addedDate;
 }

 public void setAddedDate(Date addedDate) {
 this.addedDate = addedDate;
 }
 @Temporal(TemporalType.TIMESTAMP)
 @Column(name = "UpdatedDate", nullable = false, length = 23)
 @NotNull
 public Date getUpdatedDate() {
 return this.updatedDate;
 }

 public void setUpdatedDate(Date updatedDate) {
 this.updatedDate = updatedDate;
 }
 @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY, mappedBy = "equipment")
 public Set<EquipmentRepair> getEquipmentRepairs() {
 return this.equipmentRepairs;
 }

 public void setEquipmentRepairs(Set<EquipmentRepair> equipmentRepairs) {
 this.equipmentRepairs = equipmentRepairs;
 }



}

hibernate-console.properties:

#File used by hibernate tools to override <datasource> and other container specific settings in persistence.xml
hibernate.connection.password=JavaTestAcct
hibernate.connection.username=_AppUser_JavaTestAcct
hibernate.connection.driver_class=com.microsoft.sqlserver.jdbc.SQLServerDriver
hibernate.dialect=org.hibernate.dialect.SQLServerDialect
hibernate.connection.url=jdbc:sqlserver://CORG0DB901:1433;databaseName=boBETS

hibernate.connection.provider_class=org.hibernate.connection.DriverManagerConnectionProvider
hibernate.datasource=
hibernate.transaction.manager_lookup_class=

Looks like it does not pickup the entities.

Is the project build so the classes are actually available on the classpath ?

Have you tried rebuilding the console configuration ?

asookazian, which is type of your Hibernate CC? it seems "Core".
open Edit Configuration dialog and change it to "JPA" - this should help.

also I saw your persistence.xml doesn't contains "Managed Classes" - this is not a reason of HCC exception - just little hint.