Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Newcomers » Newcomers » Eclipselink persistence is not working using krakatoa/jdbc.jar for informix JVP:
Eclipselink persistence is not working using krakatoa/jdbc.jar for informix JVP: [message #854824] Tue, 24 April 2012 09:08
Prafull Pandey is currently offline Prafull PandeyFriend
Messages: 1
Registered: April 2012
Junior Member
(Testing of UDR written in Java and running in informix DB on Unix Platform )
Problem is :
While using the ifxjdbc.jar I am able to run my UDR program (written in JAVA) in informix DB JVP using Eclipselink JPA and able to insert the row in table employee,
but same programe is failing if I am using the /app/informix/extend/krakatoa/jdbc.jar inplace of ifxjdbc.jar in JVM classpath.

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 /app/informix/extend/krakatoa/jdbc.jar | grep -i driver
11860 05-11-11 17:52 com/informix/jdbc/IfxDriver.class
unzip -l /app/informix/testjar/ifxjdbc.jar | grep -i driver
10527 02-15-00 18:06 com/informix/jdbc/IfxDriver.class

Facing below error, any help on that will be highly appreciated.


**********Facing belowException **********
[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: Wed, 25 April 2012 09:11]

Report message to a moderator

Previous Topic:Open a new page inside an editor
Next Topic:How to invoke DOS commands with PHOTRAN
Goto Forum:
  


Current Time: Fri Apr 19 02:50:43 GMT 2024

Powered by FUDForum. Page generated in 0.04049 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top