java.sql.SQLException: java.lang.NumberFormatException with WorkBook

java.sql.SQLException: java.lang.NumberFormatException with WorkBook

Post by Weas » Sat, 09 Mar 2002 04:47:47



Hi!

I'm trying O'reillys WorkBook for "Enterprise JavaBeans 3rd ed".
I'm using Weblogic 6.1 and MySql.
I'm getting the following when running Client_71.jsp:

Client_71 Example Showing Customer/CreditCard Relationship
Creating Customer 71
Creating CreditCard
Linking CreditCard and Customer
EJB Exception:
Stacktrace:
javax.ejb.EJBException: EJB Exception: - with nested exception:
[java.sql.SQLException: java.lang.NumberFormatException] at
weblogic.ejb20.internal.EJBRuntimeUtils.throwEJBException(EJBRuntimeUtils.java:142)
at weblogic.ejb20.internal.BaseEJBLocalHome.handleSystemException(BaseEJBLocalHome.java:202)
at weblogic.ejb20.internal.BaseEJBLocalObject.postInvoke(BaseEJBLocalObject.java:179)
at com.titan.customer.CreditCardBean_tlc7h0_ELOImpl.setCustomer(CreditCardBean_tlc7h0_ELOImpl.java:250)
at jsp_servlet.__client_71._jspService(__client_71.java:180) at
weblogic.servlet.jsp.JspBase.service(JspBase.java:27) at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:265)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:200)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:2495)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2204)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139) at
weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)

Any ideas?

 
 
 

java.sql.SQLException: java.lang.NumberFormatException with WorkBook

Post by Weas » Sat, 09 Mar 2002 18:21:29


I found the error myself. Mysql date type is not enough for date with
time in it so we have to use datetime.

> Hi!

> I'm trying O'reillys WorkBook for "Enterprise JavaBeans 3rd ed".
> I'm using Weblogic 6.1 and MySql.
> I'm getting the following when running Client_71.jsp:

> Client_71 Example Showing Customer/CreditCard Relationship
> Creating Customer 71
> Creating CreditCard
> Linking CreditCard and Customer
> EJB Exception:
> Stacktrace:
> javax.ejb.EJBException: EJB Exception: - with nested exception:
> [java.sql.SQLException: java.lang.NumberFormatException] at
> weblogic.ejb20.internal.EJBRuntimeUtils.throwEJBException(EJBRuntimeUtils.java:142)
> at weblogic.ejb20.internal.BaseEJBLocalHome.handleSystemException(BaseEJBLocalHome.java:202)
> at weblogic.ejb20.internal.BaseEJBLocalObject.postInvoke(BaseEJBLocalObject.java:179)
> at com.titan.customer.CreditCardBean_tlc7h0_ELOImpl.setCustomer(CreditCardBean_tlc7h0_ELOImpl.java:250)
> at jsp_servlet.__client_71._jspService(__client_71.java:180) at
> weblogic.servlet.jsp.JspBase.service(JspBase.java:27) at
> weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:265)
> at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:200)
> at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:2495)
> at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2204)
> at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139) at
> weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)

> Any ideas?