Resolved webtools/control/view/ModelInduceFromDb error

[BJ Freeman]

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.

[Jacques Le Roux]

BJ,

Could you more clear please ? Is it a bug of your own or... ?

Thks

Jacques

From: "BJ Freeman" <[hidden email]>

> 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]

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" <[hidden email]>
>> 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.

[Jacques Le Roux]

Hi BJ,

A bit late, sorry. Did you open a page for that finally ?

Thanks

Jacques

From: "BJ Freeman" <[hidden email]>

>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" <[hidden email]>
>>> 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.
>

[BJ Freeman]

got side tracked by trying to do something fancy.
guess I will just make it simple and put in the jira.
:D

Jacques Le Roux sent the following on 5/7/2009 4:03 PM:

> Hi BJ,
>
> A bit late, sorry. Did you open a page for that finally ?
>
> Thanks
>
> Jacques
>
> From: "BJ Freeman" <[hidden email]>
>> 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" <[hidden email]>
>>>> 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.
>>
>
>

--
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]

done
https://issues.apache.org/jira/browse/OFBIZ-2432

BJ Freeman sent the following on 5/7/2009 4:50 PM:

> got side tracked by trying to do something fancy.
> guess I will just make it simple and put in the jira.
> :D
>
> Jacques Le Roux sent the following on 5/7/2009 4:03 PM:
>> Hi BJ,
>>
>> A bit late, sorry. Did you open a page for that finally ?
>>
>> Thanks
>>
>> Jacques
>>
>> From: "BJ Freeman" <[hidden email]>
>>> 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" <[hidden email]>
>>>>> 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.
>>>
>>
>

--
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.