JDBC batch update error with SAP

glmarsh · **Posted:** Thu Sep 21, 2006 11:32 pm

Hi ;

I am trying to run a test program using MaxDB, a SAP database put out by MySQL. I know that you don't have MaxDB on your supported list but you have SAP and I am using all of the setups for SAP.

In a nutshell, the program is trying to insert into a cutomer table on the SAP database. When the insert executes I get the following error:

Quote:

WARNING: SQL Error: -3019, SQLState: 22003
Sep 21, 2006 6:00:41 PM org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: [-3019]: Invalid exponent(input position 2)

The test code was also tested against MySQL with the normal setups for MySQL and it ran with out errors.

If you have any ideas I would appreciate the help.

thanks,

Hibernate version: 3.1.3

Mapping documents:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="domain.Customer" table="CUSTOMER" lazy="false">
<id name="id" column="ID"/>
<property name="firstName" column="FIRST_NAME"/>
<property name="lastName" column="LAST_NAME"/>
<property name="address" column="ADDRESS"/>
</class>
<class name="domain.Order" table="ORDERS" lazy="false">
<id name="id" column="ID"/>
<property name="custId" column="CUST_ID"/>
<property name="datePlaced" column="DATE_PLACED"/>
<property name="orderAmount" column="AMOUNT"/>
</class>
</hibernate-mapping>

Code between sessionFactory.openSession() and session.close():

Code:

// execute particular hibernate command
   public Object executeHibernateCommand(DatabaseCommand c) throws Exception {
      
      Session session = null;
      try {
         session = getSessionFactory().openSession();
         Object o = c.executeHibernateOperation(session);
         return o;
      } catch (SQLException e) {
         throw e;
      } finally {
         if (session != null) {
            session.flush();
            session.close();
         }
      }
      
   }

Full stack trace of any exception that occurs:
Sep 21, 2006 6:00:41 PM org.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: -3019, SQLState: 22003
Sep 21, 2006 6:00:41 PM org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: [-3019]: Invalid exponent(input position 2)
Sep 21, 2006 6:00:41 PM org.hibernate.event.def.AbstractFlushingEventListener performExecutions
SEVERE: Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:181)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:226)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at command.CreateCustomer.executeHibernateOperation(CreateCustomer.java:36)
at command.CommandExecutor.executeHibernateCommand(CommandExecutor.java:94)
at actions.CreateCustomerAction.performAction(CreateCustomerAction.java:38)
at actions.AbstractAction.execute(AbstractAction.java:28)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
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.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:868)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
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:595)
Caused by: com.sap.dbtech.jdbc.exceptions.BatchUpdateExceptionSapDB: [-3019]: Invalid exponent(input position 2)
at com.sap.dbtech.jdbc.CallableStatementSapDB.executeBatch(CallableStatementSapDB.java:683)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:174)
... 29 more
Sep 21, 2006 6:00:42 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.struts.taglib.html.LocalStrings', returnNull=true
Sep 21, 2006 6:00:42 PM org.apache.struts.util.PropertyMessageResources <init>

Name and version of the database you are using:
MySQL MaxDB 7.6.0

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Quote: