just a guess. but Vista change the security system. now when you use mysql in its native form, it handle this. I have a feeling it has to do with permission of the login you are using from ofbiz. this is not, though a ofbiz problem.
Peter Felts sent the following on 1/8/2008 11:01 AM: > That's the strange thing: MySQL is running 'fine' outside of ofbiz. I can use > MySQL without any problems but when I attempt to connect to it through > Java/OfBiz I get these problems. I have included some log info: > > > > 2008-01-07 15:46:10,445 (main) [ GenericDelegator.java:151:INFO ] Doing > entity definition check... > 2008-01-07 15:46:10,451 (main) [ ModelEntityChecker.java:509:INFO ] > [initReservedWords] array length=1023 > 2008-01-07 15:46:10,465 (main) [ UtilXml.java:246:DEBUG] XML Read > 0.0040s: entityengine.xml > 2008-01-07 15:46:10,574 (main) [ GenericDelegator.java:154:WARN ] =-=-=-=-= > Found 1 warnings when checking the entity definitions: > 2008-01-07 15:46:10,574 (main) [ GenericDelegator.java:158:WARN ] > [RelationNameNotUnique] Relation ContentType of entity ContentAndWorkEffort > is not unique for that entity. > 2008-01-07 15:46:10,576 (main) [ GenericDelegator.java:168:INFO ] Delegator > "default" initializing helper "localmysql" for entity group "org.ofbiz". > 2008-01-07 15:46:10,580 (main) [ GenericDelegator.java:185:INFO ] Doing > database check as requested in entityengine.xml with addMissing=false > 2008-01-07 15:46:10,825 (main) [ DatabaseUtil.java:763:INFO ] Database > Product Name is MySQL > 2008-01-07 15:46:10,826 (main) [ DatabaseUtil.java:764:INFO ] Database > Product Version is 5.0.45-community-nt > 2008-01-07 15:46:10,826 (main) [ DatabaseUtil.java:772:INFO ] Database > Driver Name is MySQL-AB JDBC Driver > 2008-01-07 15:46:10,826 (main) [ DatabaseUtil.java:773:INFO ] Database > Driver Version is mysql-connector-java-3.0.17-ga ( $Date: 2005/04/06 14:12:56 > $, $Revision: 1.27.2.47 $ ) > 2008-01-07 15:46:10,826 (main) [ DatabaseUtil.java:774:INFO ] Database > Driver JDBC Version is 3.0 > 2008-01-07 15:46:10,826 (main) [ DatabaseUtil.java:784:INFO ] Database > Setting/Support Information (those with a * should be true): > 2008-01-07 15:46:10,827 (main) [ DatabaseUtil.java:785:INFO ] - > supports transactions [true]* > 2008-01-07 15:46:10,827 (main) [ DatabaseUtil.java:786:INFO ] - > isolation None [false] > 2008-01-07 15:46:10,827 (main) [ DatabaseUtil.java:787:INFO ] - > isolation ReadCommitted [true] > 2008-01-07 15:46:10,827 (main) [ DatabaseUtil.java:788:INFO ] - > isolation ReadUncommitted[true] > 2008-01-07 15:46:10,827 (main) [ DatabaseUtil.java:789:INFO ] - > isolation RepeatableRead [true] > 2008-01-07 15:46:10,828 (main) [ DatabaseUtil.java:790:INFO ] - > isolation Serializable [true] > 2008-01-07 15:46:10,844 (main) [ DatabaseUtil.java:791:INFO ] - default > fetchsize [0] > 2008-01-07 15:46:10,844 (main) [ DatabaseUtil.java:792:INFO ] - forward > only type [false] > 2008-01-07 15:46:10,844 (main) [ DatabaseUtil.java:793:INFO ] - scroll > sensitive type [false] > 2008-01-07 15:46:10,845 (main) [ DatabaseUtil.java:794:INFO ] - scroll > insensitive type [true] > 2008-01-07 15:46:10,845 (main) [ DatabaseUtil.java:795:INFO ] - is case > sensitive [false] > 2008-01-07 15:46:10,845 (main) [ DatabaseUtil.java:796:INFO ] - stores > LowerCase [false] > 2008-01-07 15:46:10,845 (main) [ DatabaseUtil.java:797:INFO ] - stores > MixedCase [true] > 2008-01-07 15:46:10,846 (main) [ DatabaseUtil.java:798:INFO ] - stores > UpperCase [false] > 2008-01-07 15:46:10,846 (main) [ DatabaseUtil.java:799:INFO ] - max > table name length [64] > 2008-01-07 15:46:10,846 (main) [ DatabaseUtil.java:800:INFO ] - max > column name length [64] > 2008-01-07 15:46:10,846 (main) [ DatabaseUtil.java:801:INFO ] - max > schema name length [0] > 2008-01-07 15:46:10,846 (main) [ DatabaseUtil.java:802:INFO ] - > concurrent connections [0] > 2008-01-07 15:46:10,847 (main) [ DatabaseUtil.java:803:INFO ] - > concurrent statements [0] > 2008-01-07 15:46:10,847 (main) [ DatabaseUtil.java:804:INFO ] - ANSI > SQL92 Entry [true] > 2008-01-07 15:46:10,847 (main) [ DatabaseUtil.java:805:INFO ] - ANSI > SQL92 Itermediate [false] > 2008-01-07 15:46:10,847 (main) [ DatabaseUtil.java:806:INFO ] - ANSI > SQL92 Full [false] > 2008-01-07 15:46:10,847 (main) [ DatabaseUtil.java:807:INFO ] - ODBC > SQL Grammar Core [true] > 2008-01-07 15:46:10,848 (main) [ DatabaseUtil.java:808:INFO ] - ODBC > SQL Grammar Extended[false] > 2008-01-07 15:46:10,848 (main) [ DatabaseUtil.java:809:INFO ] - ODBC > SQL Grammar Minimum [true] > 2008-01-07 15:46:10,848 (main) [ DatabaseUtil.java:810:INFO ] - outer > joins [true]* > 2008-01-07 15:46:10,848 (main) [ DatabaseUtil.java:811:INFO ] - limited > outer joins [true] > 2008-01-07 15:46:10,848 (main) [ DatabaseUtil.java:812:INFO ] - full > outer joins [false] > 2008-01-07 15:46:10,849 (main) [ DatabaseUtil.java:813:INFO ] - group > by [true]* > 2008-01-07 15:46:10,849 (main) [ DatabaseUtil.java:814:INFO ] - group > by not in select [false] > 2008-01-07 15:46:10,849 (main) [ DatabaseUtil.java:815:INFO ] - column > aliasing [true] > 2008-01-07 15:46:10,849 (main) [ DatabaseUtil.java:816:INFO ] - order > by not in select [false] > 2008-01-07 15:46:10,850 (main) [ DatabaseUtil.java:818:INFO ] - alter > table add column [true]* > 2008-01-07 15:46:10,850 (main) [ DatabaseUtil.java:819:INFO ] - > non-nullable column [true]* > 2008-01-07 15:46:10,850 (main) [ DatabaseUtil.java:856:INFO ] Getting > Table Info From Database > 2008-01-07 15:46:10,875 (main) [ DatabaseUtil.java:991:INFO ] Getting > Column Info From Database > 2008-01-07 15:46:17,491 (main) [ DatabaseUtil.java:1143:ERROR] Error > getting column meta data for Error was:java.sql.SQLException: General error > message from server: "Can't create/write to file 'C:\Program > Files\MySQL\MySQL Server 5.0\Data\#sql_1cd0_0.MYI' (Errcode: 13)". Not > checking columns. > > ... > > 2008-01-07 15:46:17,494 (main) [ DatabaseUtil.java:333:WARN ] Field > [acctgTransId] of entity [AcctgTrans] is missing its corresponding column > [ACCTG_TRANS_ID] (and it is a PRIMARY KEY FIELD) > 2008-01-07 15:46:17,494 (main) [ DatabaseUtil.java:333:WARN ] Field > [acctgTransTypeId] of entity [AcctgTrans] is missing its corresponding column > [ACCTG_TRANS_TYPE_ID] > 2008-01-07 15:46:17,494 (main) [ DatabaseUtil.java:333:WARN ] Field > [description] of entity [AcctgTrans] is missing its corresponding column > [DESCRIPTION] > 2008-01-07 15:46:17,495 (main) [ DatabaseUtil.java:333:WARN ] Field > [transactionDate] of entity [AcctgTrans] is missing its corresponding column > [TRANSACTION_DATE] > 2008-01-07 15:46:17,495 (main) [ DatabaseUtil.java:333:WARN ] Field > [isPosted] of entity [AcctgTrans] is missing its corresponding column > [IS_POSTED] > > 2008-01-07 15:46:19,374 (main) [ GenericDelegator.java:226:INFO ] > Distributed Cache Clear System disabled for delegator [default] > 2008-01-07 15:46:19,423 (main) [ GenericDispatcher.java:61 :INFO ] Creating > new dispatcher [entity-default] (main) > 2008-01-07 15:46:19,456 (main) [ ServiceDispatcher.java:83 :INFO ] > [ServiceDispatcher] : Creating new instance. > > Thanks! Any help is greatly appreciated. > > > > > > > > > > > > > > > > > > > > > > > > > > > > ----- Original Message ---- > From: BJ Freeman <[EMAIL PROTECTED]> > To: [email protected] > Sent: Tuesday, January 8, 2008 10:12:03 AM > Subject: Re: java.sql.SQLException from Minerva - MySQL 5.0 on Vista > > > this does not look like an error from ofbiz. > if so could you provide more of the ofbiz log. > I believe though that you should check with the Mysql group to see if > they have had any vista issues. > > > Peter Felts sent the following on 1/8/2008 8:52 AM: >> I'm trying to run OpenTaps on OfBiz in Windows Vista using MySQL. >> >> Now for the obligatory specs: >> >> MySQL 5.0.45-community-nt via TCP/IP >> Windows Vista Ultimate >> Java 1.5.0_14_b03 >> Plenty of RAM/HD space >> OpenTaps is installed in my inetpub directory. >> >> Whenever I try to launch opentaps through the startofbiz.bat file I > get >> the following error in console.log: >> >> Error getting column meta data for Error was: java.sql.SQLException: >> General error message from server: "Can't create/write to file >> 'C:\Program Files\MySQL\MySQL Sever 5.0\Data\#sql_1cd0_0.MYI' > (Errcode 13)". Not >> checking columns. >> >> I have read a few similar posts out there but I can't seem to get to >> the bottom of this. I'm thinking that Vista is doing something > strange >> with permissions that is preventing MySQL from creating a temp table > when >> Java is accessing it. >> >> I have granted full permissions to the entire MySQL directory for the >> "Users" account to no avail. Furthermore, I debugged OpenTaps in > Eclipse >> and here is the best exception I could find: >> >> A runtimeException which bubbled up from >> "org.ofbiz.minerva.pool.ObjectPool" in method "createNewObject". >> >> Any thoughts? >> >> >> >> > > > > > > >
