[Opensource] Problem with DBObjects created by DBTool

[Raul DAVIDOVICH]

Hello,

      I used DBTool for reverse engeenering a database in PostgreSQL. Once
I created the schema and added the DBObjects created by DBTool, when I try
to create the tables in another database (PostgreSQL in the same server)
for testing I get the following message:


A Servlet Exception Has Occurred
Exception Report:
javax.servlet.ServletException: There was no mapping of types from the
expresso type 'int8' to a java.sql.Types type - perhaps there should be a
type mapping entry in expresso-config.xml?
             at
com.jcorporate.expresso.core.servlet.StdServlet.showError(StdServlet.java:280)

             at
com.jcorporate.expresso.services.servlet.DBCreate.doPost(DBCreate.java:325)
             at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
             at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
             at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown
Source)
             at
org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
             at
org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
             at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
             at org.apache.catalina.core.StandardPipeline.invoke(Unknown
Source)
             at org.apache.catalina.core.ContainerBase.invoke(Unknown
Source)
             at
org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
             at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
             at org.apache.catalina.valves.CertificatesValve.invoke(Unknown
Source)
             at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
             at org.apache.catalina.core.StandardPipeline.invoke(Unknown
Source)
             at org.apache.catalina.core.ContainerBase.invoke(Unknown
Source)
             at org.apache.catalina.core.StandardContext.invoke(Unknown
Source)
             at org.apache.catalina.core.StandardHostValve.invoke(Unknown
Source)
             at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
             at org.apache.catalina.valves.AccessLogValve.invoke(Unknown
Source)
             at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
             at org.apache.catalina.core.StandardPipeline.invoke(Unknown
Source)
             at org.apache.catalina.core.ContainerBase.invoke(Unknown
Source)
             at org.apache.catalina.core.StandardEngineValve.invoke(Unknown
Source)
             at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
             at org.apache.catalina.core.StandardPipeline.invoke(Unknown
Source)
             at org.apache.catalina.core.ContainerBase.invoke(Unknown
Source)
             at
org.apache.catalina.connector.http.HttpProcessor.process(Unknown Source)
             at
org.apache.catalina.connector.http.HttpProcessor.run(Unknown Source)
             at java.lang.Thread.run(Thread.java:536)

Root Cause:
com.jcorporate.expresso.core.db.DBException: There was no mapping of types
from the expresso type 'int8' to a java.sql.Types type - perhaps there
should be a type mapping entry in expresso-config.xml?
             at
com.jcorporate.expresso.core.dbobj.Schema.typeForDB(Schema.java:1350)
             at
com.jcorporate.expresso.core.dbobj.Schema.createTable(Schema.java:959)
             at
com.jcorporate.expresso.core.dbobj.Schema.createAsNeeded(Schema.java:474)
             at
com.jcorporate.expresso.core.utility.DBTool.createTables(DBTool.java:1896)
             at
com.jcorporate.expresso.services.servlet.DBCreate.doPost(DBCreate.java:298)
             at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
             at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
             at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown
Source)
             at
org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
             at
org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
             at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
             at org.apache.catalina.core.StandardPipeline.invoke(Unknown
Source)
             at org.apache.catalina.core.ContainerBase.invoke(Unknown
Source)
             at
org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
             at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
             at org.apache.catalina.valves.CertificatesValve.invoke(Unknown
Source)
             at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
             at org.apache.catalina.core.StandardPipeline.invoke(Unknown
Source)
             at org.apache.catalina.core.ContainerBase.invoke(Unknown
Source)
             at org.apache.catalina.core.StandardContext.invoke(Unknown
Source)
             at org.apache.catalina.core.StandardHostValve.invoke(Unknown
Source)
             at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
             at org.apache.catalina.valves.AccessLogValve.invoke(Unknown
Source)
             at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
             at org.apache.catalina.core.StandardPipeline.invoke(Unknown
Source)
             at org.apache.catalina.core.ContainerBase.invoke(Unknown
Source)
             at org.apache.catalina.core.StandardEngineValve.invoke(Unknown
Source)
             at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
             at org.apache.catalina.core.StandardPipeline.invoke(Unknown
Source)
             at org.apache.catalina.core.ContainerBase.invoke(Unknown
Source)
             at
org.apache.catalina.connector.http.HttpProcessor.process(Unknown Source)
             at
org.apache.catalina.connector.http.HttpProcessor.run(Unknown Source)
             at java.lang.Thread.run(Thread.java:536)

any help on this will be very appreciated.


best regards

---------------------------------------------------
Raul Davidovich
Responsable Informatique
Cvitkovic & Associés Consultants

(33) 1 45 15 40 68
(33) 1 45 15 40 41 Fax
-------------------------------------------------------
http://www.caconcology.com