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.

Reply via email to