Re: webtools/control/view/ModelInduceFromDb error

[BJ Freeman]

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.