OFBiz › OFBiz - User

java.sql.SQLException from Minerva - MySQL 5.0 on Vista

‹ Previous Topic Next Topic ›
 
classic Classic list List threaded Threaded
♦
♦
 5 messages Options
Peter Felts
Reply | Threaded
Open this post in threaded view
♦
♦
|

java.sql.SQLException from Minerva - MySQL 5.0 on Vista

Peter Felts

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?

BJ Freeman
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: java.sql.SQLException from Minerva - MySQL 5.0 on Vista

BJ Freeman
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?
>
>
>
>

Peter Felts
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: java.sql.SQLException from Minerva - MySQL 5.0 on Vista

Peter Felts
In reply to this post by Peter Felts
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 <[hidden email]>
To: [hidden email]
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?
>
>
>
>




Adrian Crum
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: java.sql.SQLException from Minerva - MySQL 5.0 on Vista

Adrian Crum
http://dev.mysql.com/doc/refman/5.0/en/cannot-create.html

Peter Felts wrote:

> 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 <[hidden email]>
> To: [hidden email]
> 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?
>>
>>
>>
>>
>
>
>
>
>
>

BJ Freeman
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: java.sql.SQLException from Minerva - MySQL 5.0 on Vista

BJ Freeman
In reply to this post by Peter Felts
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 <[hidden email]>
> To: [hidden email]
> 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?
>>
>>
>>
>>
>
>
>
>
>
>
>

Free forum by Nabble Edit this page