Mailing-List: contact open-jpa-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: open-jpa-dev@incubator.apache.org
Received-SPF: pass (herse.apache.org: domain of ppoddar@bea.com designates
 66.248.192.39 as permitted sender)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Subject: RE: Exception while retrieving the data from database
Date: Mon, 21 May 2007 07:17:47 -0700
Message-ID: <E16AFCEA25688046A54777EE7B8470781B9685@rcpbex01.amer.bea.com>
In-Reply-To: <002701c79a1a$cc5db930$999a020a@emagiahyd.com>
Thread-Topic: Exception while retrieving the data from database
Thread-Index: AceaGlHlj8zfz5AhT7m6UPmylWjS4gBmA3Eg
References: <002701c79a1a$cc5db930$999a020a@emagiahyd.com>
From: "Pinaki Poddar" <ppoddar@bea.com>
To: <open-jpa-dev@incubator.apache.org>,
        "Praveen G" <praveenkumar.gandla@emagia.com>

> @DiscriminatorColumn(discriminatorType=DiscriminatorType.CHAR)
> @DiscriminatorValue(value="S")

The discriminator type is CHAR but the value is a String. How about
declaring the type as STRING of length 1?
 @DiscriminatorColumn(discriminatorType=DiscriminatorType.STRING,
length=1)


Pinaki Poddar
BEA Systems
415.402.7317  


-----Original Message-----
From: Praveen G [mailto:praveenkumar.gandla@emagia.com] 
Sent: Saturday, May 19, 2007 8:37 AM
To: open-jpa-dev@incubator.apache.org
Subject: Re: Exception while retrieving the data from database

Hi,

I am having following two classes, modified the code as follows 

@Entity
@Table(name = "LOG_DB2")
@Inheritance(strategy = InheritanceType.SINGLE_TABLE)
@DiscriminatorColumn(discriminatorType=DiscriminatorType.CHAR)
@DiscriminatorValue(value="S")
public class A {
 @Column(name = "LOG_ID")
 @Id
 @GeneratedValue(strategy=GenerationType.IDENTITY)
 private long id;
 
 @Column(name = "TAG")
 private String tag;
 
 @Column(name = "SUBTAG")
 private String subtag;
 
 @Column(name = "HOST_NAME")
 private String hostName;


@Entity
@Table(name = "LOG_DB2")
@DiscriminatorValue(value="C")
public class B extends A {
 @Column(name = "INSTANCE_NAME")
 private String instanceName;
 
 @Column(name = "DB2_TIMESTAMP")
 private Timestamp db2Timestamp;
 
 @Column(name = "DB_ALIAS")
 private String dbAlias;
 
 @Column(name = "DB_PARTITION")
 private int partitionNum; 

I am facing the problem while retriveing the data from the database, the
following is the code and highlighted the problem area in the code

em=ServiceLocator.getOpenJPASession("audit");
em.getTransaction().begin();

Query q = em.createQuery("select ad from B ad"); List<B> logs =
q.getResultList(); for (B l : logs) { System.out.println("Host Name is :
"+l.getHostName()+" Instance Name is "+l.getInstanceName());
em.remove(l); }

em.getTransaction().commit();
em.close();


The following error occurs

<0.9.7-incubating nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: [IBM][CLI Driver]
CLI0112E  Error in assignment. SQLSTATE=22005  at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.
java:3784)
 at
org.apache.openjpa.jdbc.sql.DB2Dictionary.newStoreException(DB2Dictionar
y.java:373)
 at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:97
)
 at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:83
)
 at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:59
)
 at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreMana
ger.java:260)
 at
org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingSt
oreManager.java:111)
 at
org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreManager.jav
a:57)
 at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:876)
 at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:834)
 at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:756)
 at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.ja
va:776)
 at
org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:257)
 at
org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load(SelectImpl.java
:2152)
 at
org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:251)
 at
org.apache.openjpa.jdbc.kernel.InstanceResultObjectProvider.getResultObj
ect(InstanceResultObjectProvider.java:59)
 at
org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:3
6)
 at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1219)
 at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:987)
 at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:796)
 at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:766)
 at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:762)
 at
org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:5
17)
 at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:230)
 at
org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:26
9)
 at
com.vormetric.server.dao.audit.hibernate.AuditDAOImpl.purgeDebugMessages
(AuditDAOImpl.java:195)
 at
com.vormetric.server.messageanalyzer.MessageAnalyzerManager.purgeDebugMe
ssages(MessageAnalyzerManager.java:113)
 at
com.vormetric.server.mgmt.ConsoleManagement.purgeDebugMessages(ConsoleMa
nagement.java:675)
 at
com.vormetric.server.mgmt.console.log.LogAnalyzerAction.execute(LogAnaly
zerAction.java:217)
 at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
ocessor.java:431)
 at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
 at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
 at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
 at
com.vormetric.server.mgmt.console.access.AuthorizationFilter.doFilter(Au
thorizationFilter.java:70)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
 at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilte
r.java:96)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
 at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
 at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
 at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAs
sociationValve.java:175)
 at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.j
ava:74)
 at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
 at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
 at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)
 at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
 at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86
9)
 at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
essConnection(Http11BaseProtocol.java:664)
 at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:527)
 at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:80)
 at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
 at java.lang.Thread.run(Thread.java:803)
Caused by: 
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0112E  Error in
assignment. SQLSTATE=22005  at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown
Source)  at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown
Source)  at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown
Source)  at COM.ibm.db2.jdbc.app.DB2ResultSet.getInt2(Unknown Source)
at COM.ibm.db2.jdbc.app.DB2ResultSet.getInt(Unknown Source)  at
org.apache.openjpa.lib.jdbc.DelegatingResultSet.getInt(DelegatingResultS
et.java:134)
 at
org.apache.openjpa.jdbc.sql.DBDictionary.getInt(DBDictionary.java:643)
 at
org.apache.openjpa.jdbc.sql.DBDictionary.getChar(DBDictionary.java:545)
 at
org.apache.openjpa.jdbc.sql.ResultSetResult.getCharInternal(ResultSetRes
ult.java:288)
 at
org.apache.openjpa.jdbc.sql.ResultSetResult.getObjectInternal(ResultSetR
esult.java:356)
 at
org.apache.openjpa.jdbc.sql.AbstractResult.getObject(AbstractResult.java
:662)
 at
org.apache.openjpa.jdbc.meta.strats.HandlerStrategies.loadDataStore(Hand
lerStrategies.java:205)
 at
org.apache.openjpa.jdbc.meta.strats.HandlerFieldStrategy.load(HandlerFie
ldStrategy.java:172)
 at
org.apache.openjpa.jdbc.meta.FieldMapping.load(FieldMapping.java:788)
 at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.ja
va:833)
 at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.ja
va:806)
 at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.ja
va:785)
 at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState(JDBCStor
eManager.java:336)
 at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreMana
ger.java:255)

Please help me to resolve the above problem as soon as possible.

Thanks,
Praveen Kumar.

Notice:  This email message, together with any attachments, may contain information  of  BEA Systems,  Inc.,  its subsidiaries  and  affiliated entities,  that may be confidential,  proprietary,  copyrighted  and/or legally privileged, and is intended solely for the use of the individual or entity named in this message. If you are not the intended recipient, and have received this message in error, please immediately return this by email and then delete it.