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?
