Topic
  • 1 reply
  • Latest Post - ‏2012-04-30T15:07:08Z by SystemAdmin
PrafullPandey
PrafullPandey
1 Post

Pinned topic Unable to use krakatoa/jdbc.jar with Eclipselink in JAVA UDR of informix DB

‏2012-04-30T01:44:53Z |
Unable to use krakatoa/jdbc.jar with Eclipselink JPA in UDR written in JAVA for informix DB.
(Testing of UDR written in Java and running in informix DB on Unix Platform )

Problem is :
I am able to run UDR if using ifxjdbc.jar but it fails if using informix/extend/krakatoa/jdbc.jar.

I am placing the below entry for driver in persistent.xml file

<property name="eclipselink.jdbc.driver" value="com.informix.jdbc.IfxDriver"/>

Note: My requirement is to use only krakatoa/jdbc.jar and not ifxjdbc.jar due to IBM recommendations.

*******Code of unit test program is attached.

The drivers are same in both jar:
unzip -l /informix/extend/krakatoa/jdbc.jar | grep -i driver
11860 05-11-11 17:52 com/informix/jdbc/IfxDriver.class
unzip -l /informix/testjar/ifxjdbc.jar | grep -i driver
10527 02-15-00 18:06 com/informix/jdbc/IfxDriver.class

Facing below error while using /informix/extend/krakatoa/jdbc.jar in my CLASSPATH of informix JVP for UDR,
can any please help to understand the difference in IfxDriver of mentioned jar and why one is working with Eclipselink JPA and other is not ?
EL Info: 2012-04-24 03:52:32.643--ServerSession(1860215686)--property eclipselink.jdbc.password is deprecated, property javax.persistence.jdbc.password should be used instead.
EL Info: 2012-04-24 03:52:37.634--ServerSession(1860215686)--EclipseLink, version: Eclipse Persistence Services - 2.1.2.v20101206-r8635
EL Info: 2012-04-24 03:52:38.915--ServerSession(1860215686)--file:/app/GFXDB_QA/Informix_11.70.FC4/prafull_testjar/chkpocMyInsert.jar_DALPOCService login successful
Entity Object : Employee@54083e1e
EL Warning: 2012-04-24 03:52:39.352--UnitOfWork(876281732)--Exception EclipseLink-4002 (Eclipse Persistence Services - 2.1.2.v20101206-r8635): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: System or internal error java.lang.NullPointerException
Error Code: -79716
Call: INSERT INTO employee (NAME, AGE, ACTIVE_STATUS) VALUES (?, ?, ?)
bind => Prafull test1, 10, A
Query: InsertObjectQuery(Employee@54083e1e)
Here Exception in setListByWssctrlNo : Exception EclipseLink-4002 (Eclipse Persistence Services - 2.1.2.v20101206-r8635): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: System or internal error java.lang.NullPointerException
Error Code: -79716
Call: INSERT INTO employee (NAME, AGE, ACTIVE_STATUS) VALUES (?, ?, ?)
bind => Prafull test1, 10, A
Query: InsertObjectQuery(Employee@54083e1e)
javax.persistence.RollbackException: Exception EclipseLink-4002 (Eclipse Persistence Services - 2.1.2.v20101206-r8635): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: System or internal error java.lang.NullPointerException
Error Code: -79716
Call: INSERT INTO employee (NAME, AGE, ACTIVE_STATUS) VALUES (?, ?, ?)
bind => Prafull test1, 10, A
Query: InsertObjectQuery(Employee@54083e1e)
at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:102)
at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:63)
at EmpDaoImpl.insertRow(EmpDaoImpl.java:26)
at POCInsert.checkMyInsert(POCInsert.java:14)
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 informix.jvp.dbapplet.impl.SQLJParamImpl.invoke(SQLJParamImpl.java:960)
at informix.jvp.dbapplet.impl.PerJavaUDRContext.invokeUDR(PerJavaUDRContext.java:249)
at informix.jvp.dbapplet.impl.DBAThreadImpl.runDBApplet(DBAThreadImpl.java:479)
at informix.jvp.dbapplet.impl.DBAThreadImpl.runDBWork(DBAThreadImpl.java:376)
at informix.jvp.dbapplet.impl.DBAThreadImpl.run(DBAThreadImpl.java:324)
Caused by: Exception EclipseLink-4002 (Eclipse Persistence Services - 2.1.2.v20101206-r8635): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: System or internal error java.lang.NullPointerException
Error Code: -79716
Call: INSERT INTO employee (NAME, AGE, ACTIVE_STATUS) VALUES (?, ?, ?)
Updated on 2012-04-30T15:07:08Z at 2012-04-30T15:07:08Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    1143 Posts

    Re: Unable to use krakatoa/jdbc.jar with Eclipselink in JAVA UDR of informix DB

    ‏2012-04-30T15:07:08Z  
    The krakatoa/jdbc.jar should be the right JDBC driver for Informix Java UDR. According to what you described, I would suggest that you open a PMR for support.