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 mprudhomapache@gmail.com
 designates 209.85.146.179 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:in-reply-to:references:mime-version:x-priority:content-type:message-id:content-transfer-encoding:from:subject:date:to:x-mailer:sender;
        b=if3pbKtDn4GdLvazYrFSy0LhLAgQ7iRFCDY6eAI7+x7ebQWXRPeBxi0Ownf2rgHIh6dzNUFjToc7rPR8cPXcYeMwn2lqOJ59AUQTfnUjm/X3dinotUOsvkPyG9O7zP7Kys/Agh2816S2cmbwM9YE7sanM7+ZHQdzh5LTx1tDyn4=
In-Reply-To: <002701c79a1a$cc5db930$999a020a@emagiahyd.com>
References: <002701c79a1a$cc5db930$999a020a@emagiahyd.com>
Mime-Version: 1.0 (Apple Message framework v752.3)
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <D224F94A-4BA2-41D1-ADE5-2C35765A0F32@apache.org>
Content-Transfer-Encoding: 7bit
From: Marc Prud'hommeaux <mprudhom@apache.org>
Subject: Re: Exception while retrieving the data from database
Date: Sat, 19 May 2007 09:59:43 -0700
To: open-jpa-dev@incubator.apache.org
Sender: Marc Prud'hommeaux <mprudhomapache@gmail.com>

Praveen-

It looks like we might be calling getInt() on a column type that  
isn't compatible. How are the columns defined for your tables? For  
example, if "DB_PARTITION" is really a VARCHAR, then I can see this  
happening.

If that is the case, then you might be able to get around it by  
specifying @org.apache.openjpa.persistence.Type(String.class) on the  
offending field.


On May 19, 2007, at 6:37 AM, Praveen G wrote:

> 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 
> (DB2Dictionary.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 
> (JDBCStoreManager.java:260)
>  at org.apache.openjpa.kernel.DelegatingStoreManager.initialize 
> (DelegatingStoreManager.java:111)
>  at org.apache.openjpa.kernel.ROPStoreManager.initialize 
> (ROPStoreManager.java: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.java: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.getResultO 
> bject(InstanceResultObjectProvider.java:59)
>  at org.apache.openjpa.lib.rop.EagerResultList.<init> 
> (EagerResultList.java:36)
>  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:517)
>  at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java: 
> 230)
>  at org.apache.openjpa.persistence.QueryImpl.getResultList 
> (QueryImpl.java:269)
>  at  
> com.vormetric.server.dao.audit.hibernate.AuditDAOImpl.purgeDebugMessag 
> es(AuditDAOImpl.java:195)
>  at  
> com.vormetric.server.messageanalyzer.MessageAnalyzerManager.purgeDebug 
> Messages(MessageAnalyzerManager.java:113)
>  at com.vormetric.server.mgmt.ConsoleManagement.purgeDebugMessages 
> (ConsoleManagement.java:675)
>  at com.vormetric.server.mgmt.console.log.LogAnalyzerAction.execute 
> (LogAnalyzerAction.java:217)
>  at org.apache.struts.action.RequestProcessor.processActionPerform 
> (RequestProcessor.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 
> (ApplicationFilterChain.java:252)
>  at org.apache.catalina.core.ApplicationFilterChain.doFilter 
> (ApplicationFilterChain.java:173)
>  at  
> com.vormetric.server.mgmt.console.access.AuthorizationFilter.doFilter( 
> AuthorizationFilter.java:70)
>  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter 
> (ApplicationFilterChain.java:202)
>  at org.apache.catalina.core.ApplicationFilterChain.doFilter 
> (ApplicationFilterChain.java:173)
>  at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter 
> (ReplyHeaderFilter.java:96)
>  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter 
> (ApplicationFilterChain.java:202)
>  at org.apache.catalina.core.ApplicationFilterChain.doFilter 
> (ApplicationFilterChain.java:173)
>  at org.apache.catalina.core.StandardWrapperValve.invoke 
> (StandardWrapperValve.java:213)
>  at org.apache.catalina.core.StandardContextValve.invoke 
> (StandardContextValve.java:178)
>  at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke 
> (SecurityAssociationValve.java:175)
>  at org.jboss.web.tomcat.security.JaccContextValve.invoke 
> (JaccContextValve.java: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:148)
>  at org.apache.coyote.http11.Http11Processor.process 
> (Http11Processor.java:869)
>  at org.apache.coyote.http11.Http11BaseProtocol 
> $Http11ConnectionHandler.processConnection(Http11BaseProtocol.java: 
> 664)
>  at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket 
> (PoolTcpEndpoint.java:527)
>  at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt 
> (LeaderFollowerWorkerThread.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 
> (DelegatingResultSet.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 
> (ResultSetResult.java:288)
>  at org.apache.openjpa.jdbc.sql.ResultSetResult.getObjectInternal 
> (ResultSetResult.java:356)
>  at org.apache.openjpa.jdbc.sql.AbstractResult.getObject 
> (AbstractResult.java:662)
>  at  
> org.apache.openjpa.jdbc.meta.strats.HandlerStrategies.loadDataStore 
> (HandlerStrategies.java:205)
>  at org.apache.openjpa.jdbc.meta.strats.HandlerFieldStrategy.load 
> (HandlerFieldStrategy.java:172)
>  at org.apache.openjpa.jdbc.meta.FieldMapping.load 
> (FieldMapping.java:788)
>  at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load 
> (JDBCStoreManager.java:833)
>  at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load 
> (JDBCStoreManager.java:806)
>  at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load 
> (JDBCStoreManager.java:785)
>  at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState 
> (JDBCStoreManager.java:336)
>  at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize 
> (JDBCStoreManager.java:255)
>
> Please help me to resolve the above problem as soon as possible.
>
> Thanks,
> Praveen Kumar.