[Persistence, JBoss/CMP, Hibernate, Database] - could not insert exception in JBOSS 4.2.2 GA ...
by sajhak
Hi all ,
im testing en Entity ( named as BookBank ) , using MySQL.
I tested with the default database(HSQL) , and it succeeded.
But when i configure the database to MySQL , it throws the following exception ..
( i placed connection pool config file "booksdb-ds.xml" in to the deploy directory of JBOSS and the
mySQL-J connector jar file to the lib directory )
when i used with HSQL the -ds.xml file had following properties
, those properties i didnt include in the booksdb-ds.xml file..
is that the cause of the problem ?
pls help
i have attached my Entity class , persistence.xml and part of the booksdb-ds.xml files for your consideration ...
also please give me a good resource of "EJB3 persistance , how the configurations should be done in JBOSS , etc etc .." for a beginner
thanks in advance
Saji
19:25:30,000 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
19:25:30,000 ERROR [JDBCExceptionReporter] Table 'b04042.bookbank' doesn't exist
19:25:30,062 ERROR [STDERR] javax.ejb.EJBException: javax.persistence.Persistenc
eException: org.hibernate.exception.SQLGrammarException: could not insert: [dev.
saji.ejb.bean.entity.BookBank]
19:25:30,062 ERROR [STDERR] at org.jboss.ejb3.tx.Ejb3TxPolicy.handleExceptio
nInOurTx(Ejb3TxPolicy.java:63)
19:25:30,062 ERROR [STDERR] at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(T
xPolicy.java:83)
19:25:30,062 ERROR [STDERR] at org.jboss.aspects.tx.TxInterceptor$Required.i
nvoke(TxInterceptor.java:191)
19:25:30,062 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invo
keNext(MethodInvocation.java:101)
19:25:30,062 ERROR [STDERR] at org.jboss.aspects.tx.TxPropagationInterceptor
.invoke(TxPropagationInterceptor.java:95)
19:25:30,062 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invo
keNext(MethodInvocation.java:101)
BookBank.java
--------------
package dev.saji.ejb.bean.entity;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.io.Serializable;
@Entity
@Table
public class BookBank implements Serializable {
long id;
String title;
String author;
double price;
public BookBank() {
super();
}
public BookBank (String title , String author , double price) {
super();
this.title = title;
this.author = author;
this.price = price;
}
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
public long getId() {
return id;
}
public void setId(long id) {
this.id = id;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public String getAuthor() {
return author;
}
public void setAuthor(String author) {
this.author = author;
}
public double getPrice() {
return price;
}
public void setPrice(double price) {
this.price = price;
}
}
==============================================
persistence.xml
---------------
<?xml version="1.0" encoding="UTF-8"?>
<persistence-unit name="EntityBean">
<jta-data-source>java:/EntityBean</jta-data-source>
dev.saji.ejb.bean.entity.BookBank
</persistence-unit>
====================================
<local-tx-datasource>
<jndi-name>EntityBean</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/b04042</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
sajith
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4137762#4137762
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4137762
18 years, 1 month
[Performance Tuning] - Re: 100% CPU usage with lots of memory
by DeanoUK
And now this, only some minutes after a restart:
[Unloading class sun.reflect.GeneratedMethodAccessor750]
| 5015999K->5004634K(5126528K), 15.0047050 secs]
| [19 Mar 2008 14:00:38] ERROR org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/csi].[default] - Servlet.service() for servlet default threw exception
| java.lang.OutOfMemoryError: GC overhead limit exceeded
| at org.hibernate.util.ArrayHelper.slice(ArrayHelper.java:114)
| at org.hibernate.type.ComponentType.hydrate(ComponentType.java:559)
| at org.hibernate.type.ComponentType.nullSafeGet(ComponentType.java:275)
| at org.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:1097)
| at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:565)
| at org.hibernate.loader.Loader.doQuery(Loader.java:701)
| at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
| at org.hibernate.loader.Loader.doList(Loader.java:2220)
| 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.ejb.QueryImpl.getResultList(QueryImpl.java:66)
| at com.msp.ejb.csi.admin.performancereport.scoring.persistance.ScoringSessionFacadeBean.getAllDealerPerfRepQuestionSectionCopies(ScoringSessionFacadeBean.java:141)
| 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:597)
| at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
| at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
| at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
| at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
| at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
| at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
| at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
| at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
| at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
| at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195)
| at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
| [Full GC 5015999K->5001537K(5126528K), 10.3796170 secs]
| [Full GC 5015999K->5005969K(5126528K), 10.3035780 secs]
| [Full GC[Unloading class sun.reflect.GeneratedMethodAccessor704]
| [Unloading class sun.reflect.GeneratedMethodAccessor708]
| [Unloading class sun.reflect.GeneratedMethodAccessor702]
| [Unloading class sun.reflect.GeneratedMethodAccessor703]
| [Unloading class sun.reflect.GeneratedMethodAccessor705]
| [Unloading class sun.reflect.GeneratedMethodAccessor707]
| [Unloading class sun.reflect.GeneratedSerializationConstructorAccessor256]
| 5015999K->5010260K(5126528K), 10.3110000 secs]
| [Full GC[Unloading class sun.reflect.GeneratedSerializationConstructorAccessor252]
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4137757#4137757
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4137757
18 years, 1 month