ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From BJ Freeman <bjf...@free-man.net>
Subject Resolved webtools/control/view/ModelInduceFromDb error
Date Sat, 02 May 2009 22:15:39 GMT
Ok it recovers the one thing not made clear is you have to view source t
see the output.
so all I saw was
ERRORS: Error getting column meta data for Error was:
[java.sql.SQLException: Table 'automation.PHPBB3_ACL_GROUPS' doesn't
exist]. Not checking columns.     None  Copyright 2001-2008 The Apache
Software Foundation  None  1.0

after tracing thru the code and runing it against the default db.
I said I was missing something.
so thought of doing view source,  what do you know there it is.
so updating the page including the virtual year for copy right.

:D

BJ Freeman sent the following on 5/1/2009 8:12 PM:
> here is the log file
> 2009-05-01 19:29:22,023 (TP-Processor3) [
> DatabaseUtil.java:1334:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Error getting column meta data for Error was: [java.sql.SQLException:
> Table 'automation.PHPBB3_ACL_GROUPS' doesn't exist]. Not checking columns.
> Exception: java.sql.SQLException
> Message: Table 'automation.PHPBB3_ACL_GROUPS' doesn't exist
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: Table 'automation.PHPBB3_ACL_GROUPS' doesn't exist
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847)
> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
> com.mysql.jdbc.Connection.execSQL(Connection.java:2370)
> com.mysql.jdbc.Connection.execSQL(Connection.java:2297)
> com.mysql.jdbc.Statement.executeQuery(Statement.java:1183)
> com.mysql.jdbc.DatabaseMetaData.getPrimaryKeys(DatabaseMetaData.java:2404)
> org.ofbiz.entity.jdbc.DatabaseUtil.getColumnInfo(DatabaseUtil.java:1325)
> org.ofbiz.entity.jdbc.DatabaseUtil.induceModelFromDb(DatabaseUtil.java:681)
> org.ofbiz.entity.datasource.GenericDAO.induceModelFromDb(GenericDAO.java:1096)
> org.apache.jsp.entity.ModelInduceFromDb_jsp._jspService(ModelInduceFromDb_jsp.java:101)
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535)
> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472)
> org.ofbiz.webapp.view.JspViewHandler.render(JspViewHandler.java:76)
> org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:781)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:533)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:201)
> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:77)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:259)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
> org.ofbiz.catalina.container.CrossSubdomainSessionValve.invoke(CrossSubdomainSessionValve.java:44)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
> org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
> org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
> java.lang.Thread.run(Thread.java:636)
> 
> 
> BJ Freeman sent the following on 5/1/2009 8:09 PM:
>> I have a database i tried to use
>> webtools/control/view/ModelInduceFromDb
>> on.
>> The db tables are like  phpbb3_acl_groups when viewed through phpmyadmin.
>> I would expect ofbiz to convert it to Phpbb3AclGroups
>> I  am getting this message.
>> ERRORS: Error getting column meta data for Error was:
>> [java.sql.SQLException: Table 'automation.PHPBB3_ACL_GROUPS' doesn't
>> exist]. Not checking columns.     None  Copyright 2001-2008 The Apache
>> Software Foundation  None  1.0
>> using release 9.04
>>
>> any ideas?
> 

-- 
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.


Mime
View raw message