sri ramvaithiyanathan

Hi,

I want to upload excel file from jsp. I have used all the basic things in jsp file such as
1) form type as post
2) enctype="multipart/form-data"
3) action redirects to servlet.

While reading excel file using jexcel im getting below exception, but same code is working fine when I pass parameter as file(tested using local java class).
From this I conclude, the inputstream is having some problem.
Please shed some light to solve this problem.
Getting inputstream using httpservletrequest. InputStream inputFile = httpServletRequest.getInputStream();
jxl.read.biff.BiffException: Unable to recognize OLE stream at jxl.read.biff.CompoundFile.<init>(CompoundFile.java:116) at jxl.read.biff.File.<init>(File.java:127) at jxl.Workbook.getWorkbook(Workbook.java:268) at jxl.Workbook.getWorkbook(Workbook.java:253) at com.xml.WriteXML.readExcelUsingJXL(WriteXML.java:74) at com.xl.jxl.ReadXLAndWriteXML.main(ReadXLAndWriteXML.java:25)

public ArrayList readExcel(InputStream inputFile) throws IOException { ArrayList excelOuput = new ArrayList(); Workbook workbook; try { if(inputFile!=null) { workbook = Workbook.getWorkbook(inputFile); if(workbook!=null && workbook.getNumberOfSheets()>0) { /***Get first worksheet***/ Sheet sheet = workbook.getSheet(0); /***get column values from sheet and add it to exceloutput***/ } } } catch (BiffException e) { e.printStackTrace(); } finally { inputFile.close(); inputFile =null; } return excelOuput; }

Hi jasmi,

welcome to sap world.

There are so many modules in sap, please choose the module accordingly.
I have background in java, so I choose sap netweaver.

how long it does take for changing the mind set?

It depends upon you.

what challenges did you face, How do you feel moving your career? any disappointments?

Initially I felt like fresher, now I feel comfartable in sap.

You told that you have good knowledge in db stuff, so choose module in that area.

All the best.

Hi,

I have two table,
TMP_EMP : empid int pk, empname varchar
TMP_EMP_DETAILS : empid int , deptname varchar, residence varchar, fk reference TMP_EMP(empid)

TMP_EMP Entity
@Entity @Table(name="TMP_EMP") public class TMP_EMP implements Serializable { private static final long serialVersionUID = 1L; @Id @Column(name="empid") @SequenceGenerator(name="empid_seq", sequenceName="seq_emp") @GeneratedValue(generator="empid_seq", strategy=GenerationType.SEQUENCE) private int empid; @Column(name="empname") private String empname; @OneToOne(mappedBy="tmpemp",cascade=CascadeType.PERSIST) private TMP_EMP_DETAILS tmp_emp_details;
TMP_EMP_DETAILS Entity
@Entity @Table(name="TMP_EMP_DETAILS") public class TMP_EMP_DETAILS implements Serializable { private static final long serialVersionUID = 1L; public TMP_EMP_DETAILS() { super(); } @Id @Column(name="empid",insertable=false,updatable=false,nullable=false) private int empid; @Column(name="deptname") private String deptname; @Column(name="residence") private String residence; @Id @OneToOne @JoinColumn(name="empid") private TMP_EMP tmpemp;

DBCaller
EntityManagerFactory emf = Persistence.createEntityManagerFactory("XXCONN"); EntityManager em = emf.createEntityManager(); em.getTransaction().begin(); TMP_EMP tmp_emp = new TMP_EMP(); tmp_emp.setEmpname("Sriram"); TMP_EMP_DETAILS emp_details = new TMP_EMP_DETAILS(); emp_details.setDeptname("fsg"); // emp_details.setEmpid(tmp_emp.getEmpid()); emp_details.setResidence("chennai"); tmp_emp.setTmp_emp_details(emp_details); em.persist(tmp_emp); em.getTransaction().commit();

I am getting below exception, don know where I am going wrong
javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.0.v20110604-r9504): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.sap.dbtech.jdbc.exceptions.DatabaseException: [-5005]: Missing non-NULL value Error Code: -5005 Call: INSERT INTO TMP_EMP_DETAILS (deptname, residence, empid) VALUES (?, ?, ?) bind => [3 parameters bound] Query: InsertObjectQuery(XXENTITY.TMP_EMP_DETAILS@969c29) 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 XXDB.XXDBCONN.testConn(XXDBCONN.java:93) at XXDB.JustJava.main(JustJava.java:15) Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.0.v20110604-r9504): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.sap.dbtech.jdbc.exceptions.DatabaseException: [-5005]: Missing non-NULL value Error Code: -5005 Call: INSERT INTO TMP_EMP_DETAILS (deptname, residence, empid) VALUES (?, ?, ?) bind => [3 parameters bound]

Please help me to solve this issue.

Regards,
Sriram.V

just noticed, While building the ejb project I got following build exception.
Believe this is creating problem

Please ensure a persistence xml file is available either from the CLASS OUTPUT directory [META-INF/persistence.xml] or using the eclipselink.persistence xml property to specify its location.

Any idea, why its creating this exception???

Regards,
Sriram.V

solved the problem by adding required jar file(eclipselink-2.0.0.jar and eclipselink-javax.persistence-2.0.jar)

Regards,
Sriram.V

Hi,

While running below piece of code
EntityManagerFactory emf = Persistence.createEntityManagerFactory("DBConnector");
I am getting following exception
nested exception is: java.util.MissingResourceException: Can't find bundle for base name org.eclipse.persistence.exceptions.i18n.PersistenceUnitLoadingExceptionResource, locale en_US"
Persistence.xml file as follows<?xml version="1.0" encoding="UTF-8"?> <persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"> <persistence-unit name="DBConnector"> <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider> <jta-data-source>SAP/JPA_DEFAULT</jta-data-source> <class>dbentity.TMP_TEST</class> </persistence-unit> </persistence>

Please guide me where I am going wrong.

Regards,
Sriram.V

Hi,

I am using SAP Server and sap maxdb as database.
While trying to create database connection using entitymanager I am getting following error

Exception raised from invocation of public java.lang.String com.dbcaller.DBCaller.callDB() method on bean instance com.dbcaller.DBCaller@22af96 for bean demo.sap.com/dbear*annotation|demo.sap.com~dbejb.jar*annotation| DBCaller in application demo.sap.com/dbear.; nested exception is: javax.persistence.PersistenceException: No Persistence provider for EntityManager named LocalDevelopment~LocalDevelopment~dbejb~demo.sap.com"

I dont know where I am going wrong.

Is there any way to convert jdbc connection to entity manager.

I tried using this way
EntityManager em = (EntityManager)(new InitialContext()).lookup("lookUpName");
but I am getting below error.

class com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl:service:dbpool @com.sap.engine.boot.loader.ResourceMultiParentClassLoader@891d76@alive incompatible with interface javax.persistence.EntityManager:library: javax~persistence~api@com.sap.engine.boot.loader.ResourceMultiParentClassLoader@af9d74@alive



Regards,
Sriram.V

Thanks to all.

Regards,
Sriram.V

Hi,

I used numberformat to get two digit decimal. (Note its return type is string)
In database I need to save this value as double.

So I converted string to double. while converting I am getting decimal value as one digit instead of two.
Is there any way to get two digit decimal point in double.

import java.text.NumberFormat; public class decimalFormatter { public static void main(String args[]) { NumberFormat nf = NumberFormat.getInstance(); nf.setMinimumFractionDigits(2); String stringConversion = nf.format(2.00); System.out.println(stringConversion); Double doubleConversion = Double.parseDouble(stringConversion); System.out.println(doubleConversion); } }
Output:
stringConversion::2.00 doubleConversion::2.0

P.S: I am facing this problem only when the input is of type x.00

Regards,
Sriram.V

Dont ask same question in multiple categories.
This question already asked in Java in General.

Admin please move or remove this post.

Regards,
Sriram.V

Hi Anisha,

Welcome to code ranch.
Do coding inside try block.

executeupdate will return int value.
So replace

stmt=executeUpdate(insert); to int value = executeUpdate(insert);

Use catch block properly, don't leave it empty.
Just place e.printStackTrace();
inside catch block.

It will print error details. So that you will understand the problem clearly.

And finally, paste coding inside code block.

Regards,
Sriram.V

Welcome to coderanch.

What you are trying to achieve and where you got stuck.
Please explain it clearly and Please clear on your question also.

Regards,
Sriram.V

You have to use java mail api to send mail.
Let us know, what you have not understand from the requirement.


Regards,
Sriram.V

Arun,
welcome to java ranch.
As james said dont leave the catch block empty.
Keep e.printStackTrace() in your catch block.
And do let us know the error which you are facing.

James,
I think by default it will commit, if you keep connection.setAutocommit(false) explicitly then you need to do connection.commit() in your code.

Regards,
Sriram.V

Please check the following url for Sending Mail in time interval
For Delivery status notification please check this thread
https://coderanch.com/t/434460/java/java/delivery-status-notification

Finally welcome to coderanch.

Regards,
Sriram.V