I don't believe it to be my error, Jacques. I don't believe that one expects to have to view the source of a web page to get their data. it was not displayed so you could see it.
I have put such an explanation on the page that i am going to submit a patch for. why the error I don't know, I was tracing code when i made the discovery that the entities were generated but I had to do a view of the web page source to see it. So I have not traced any farther. Jacques Le Roux sent the following on 5/2/2009 3:53 PM: > BJ, > > Could you more clear please ? Is it a bug of your own or... ? > > Thks > > Jacques > > From: "BJ Freeman" <[email protected]> >> 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. >> > > -- 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.
