You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Craig Parker <cr...@fossfolks.com> on 2017/01/12 02:47:15 UTC

MySQL connector

Where does this go these days? Last I knew (13.x) it was 
framework/entity/lib/jdbc/ but there's no lib in the entity directory 
any more. Make one, or is there somewhere else I should stick it? Does 
it matter, as long as framework/entity/config/entityengine.xml specifies 
the right spot?


Re: MySQL connector, again

Posted by Taher Alkhateeb <sl...@gmail.com>.
Hi Craig,

The dbPlatform is a flag passed by the user in the command line using the
syntax: ./gradlew createTenant -PtenantId=whatever -PdbPlatform=P etc ...
For more information you can visit the README.md file in the createTenant
documentation section

So in order to change the database for tenants, this involves multiple
steps including changing the database in entityengine.xml and also
selecting it for tenant creation.

Cheers,

Taher Alkhateeb

On Sun, Jan 22, 2017 at 4:24 AM, Craig Parker <cr...@fossfolks.com> wrote:

> At about line 400 of build.gradle, I've got:
>
> if (project.hasProperty('dbPlatform')) {
>   if (dbPlatform == 'D') {
>
> Where is build.gradle finding dbPlatform declared?
>
> My previous runtime issue (last week) was simply a dash instead of a colon
> in the relevant line
> runtime 'mysql:mysql-connector-java-5.1.40' doesn't work (dash after the
> word java) Not sure where I got that, but thanks Tahur -- your 1/15 email
> put me over the edge. However, OFBiz is still using derby, not MySQL.
>
>
> I also went hunting through past threads and want to make sure... Is this:
>
> https://ofbiz-vm2.apache.org:8443/cmssite/cms/APACHE_OFBIZ_HTML
>
> still the latest and greatest documentation? I thought I remembered seeing
> a different quick start guide somewhere, but I can't find the link.
>
>
>

MySQL connector, again

Posted by Craig Parker <cr...@fossfolks.com>.
At about line 400 of build.gradle, I've got:

if (project.hasProperty('dbPlatform')) {
   if (dbPlatform == 'D') {

Where is build.gradle finding dbPlatform declared?

My previous runtime issue (last week) was simply a dash instead of a 
colon in the relevant line
runtime 'mysql:mysql-connector-java-5.1.40' doesn't work (dash after the 
word java) Not sure where I got that, but thanks Tahur -- your 1/15 
email put me over the edge. However, OFBiz is still using derby, not MySQL.


I also went hunting through past threads and want to make sure... Is this:

https://ofbiz-vm2.apache.org:8443/cmssite/cms/APACHE_OFBIZ_HTML

still the latest and greatest documentation? I thought I remembered 
seeing a different quick start guide somewhere, but I can't find the link.



Re: MySQL connector

Posted by Taher Alkhateeb <sl...@gmail.com>.
Hi Craig,

A little bit of searching would go a long way. Just go to
https://bintray.com/bintray/jcenter/mysql%3Amysql-connector-java and pick
whatever version you like. The latest version I see is 6.0.5 so the runtime
declaration would be the one below. Also, make sure you are declaring the
dependency in the correct location in build.gradle along with the rest of
the dependencies under the dependencies block.

runtime 'mysql:mysql-connector-java:6.0.5'

Cheers,

Taher Alkhateeb

On Sun, Jan 15, 2017 at 1:53 AM, Craig Parker <cr...@fossfolks.com> wrote:

> I'm getting the same kind of error. just:
>
> runtime 'mysql:mysql-connector-java:5.1.40'
>
> Could not find mysql:mysql-connector-java-5.1.40:.
>      Searched in the following locations:
> https://jcenter.bintray.com/mysql/mysql-connector-java-5.1.
> 40//mysql-connector-java-5.1.40-.pom
> https://jcenter.bintray.com/mysql/mysql-connector-java-5.1.
> 40//mysql-connector-java-5.1.40-.jar
> file:/home/ofbiz/.m2/repository/mysql/mysql-connector-java-
> 5.1.40//mysql-connector-java-5.1.40-.pom
> file:/home/ofbiz/.m2/repository/mysql/mysql-connector-java-
> 5.1.40//mysql-connector-java-5.1.40-.jar
>      Required by:
>          :ofbiz:unspecified
>
> Other than it looking in strange places, what looks real weird to me is
> the double forward slash in every one of those lines ahead of the
> mysql-connector... near the end.
>
> There's no way to just say "Hey, here's the mysql-connector jar file --
> use it" anywhere?
>
>
> On 01/12/2017 11:11 PM, james yong wrote:
>
>> Hi Craig,
>>
>> Should be something like this:
>> runtime 'mysql:mysql-connector-java:5.1.40'
>>
>> Regards,
>> James
>>
>>
>> Craig Parker wrote
>>
>>> I added this:
>>>
>>> runtime 'mysql:mysql-connector-java-5.1.40-bin.jar'
>>>
>>> to build.gradle, and tried a few other varyations, but get essentially
>>> the same error. I've run it with info, debug, and stacktrace, but still
>>> can't make heads or tails of it. Not sure how to specify a file path.
>>> I've copied it over to the /home/ofbiz directory referenced with a file:
>>> line, but it's also sitting in framework/entity, which is where I'd
>>> rather stick it.
>>>
>>>
>>> * What went wrong:
>>> A problem occurred evaluating root project 'ofbiz'.
>>>   > Could not resolve all dependencies for configuration ':runtime'.
>>>      > Could not find mysql:mysql-connector-java-5.1.40-bin.jar:.
>>>        Searched in the following locations:
>>> https://jcenter.bintray.com/mysql/mysql-connector-java-5.1.
>>> 40-bin.jar//mysql-connector-java-5.1.40-bin.jar-.pom
>>> https://jcenter.bintray.com/mysql/mysql-connector-java-5.1.
>>> 40-bin.jar//mysql-connector-java-5.1.40-bin.jar-.jar
>>> file:/home/ofbiz/.m2/repository/mysql/mysql-connector-java-
>>> 5.1.40-bin.jar//mysql-connector-java-5.1.40-bin.jar-.pom
>>> file:/home/ofbiz/.m2/repository/mysql/mysql-connector-java-
>>> 5.1.40-bin.jar//mysql-connector-java-5.1.40-bin.jar-.jar
>>>        Required by:
>>>            :ofbiz:unspecified
>>>
>>>
>>>
>>> On 01/12/2017 12:34 AM, Taher Alkhateeb wrote:
>>>
>>>> http://markmail.org/message/5qjjnxvvkyp7cxax
>>>>
>>>> On Jan 12, 2017 5:47 AM, "Craig Parker" &lt;
>>>>
>>> craig@
>>> &gt; wrote:
>>>
>>>> Where does this go these days? Last I knew (13.x) it was
>>>>> framework/entity/lib/jdbc/ but there's no lib in the entity directory
>>>>> any
>>>>> more. Make one, or is there somewhere else I should stick it? Does it
>>>>> matter, as long as framework/entity/config/entityengine.xml specifies
>>>>> the
>>>>> right spot?
>>>>>
>>>>>
>>>>>
>>
>>
>>
>> --
>> View this message in context: http://ofbiz.135035.n4.nabble.
>> com/Apachecon-Feathercast-Interview-with-Taher-tp4699219p4701005.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>
>

Re: MySQL connector

Posted by Craig Parker <cr...@fossfolks.com>.
I'm getting the same kind of error. just:

runtime 'mysql:mysql-connector-java:5.1.40'

Could not find mysql:mysql-connector-java-5.1.40:.
      Searched in the following locations:
https://jcenter.bintray.com/mysql/mysql-connector-java-5.1.40//mysql-connector-java-5.1.40-.pom
https://jcenter.bintray.com/mysql/mysql-connector-java-5.1.40//mysql-connector-java-5.1.40-.jar
file:/home/ofbiz/.m2/repository/mysql/mysql-connector-java-5.1.40//mysql-connector-java-5.1.40-.pom
file:/home/ofbiz/.m2/repository/mysql/mysql-connector-java-5.1.40//mysql-connector-java-5.1.40-.jar
      Required by:
          :ofbiz:unspecified

Other than it looking in strange places, what looks real weird to me is 
the double forward slash in every one of those lines ahead of the 
mysql-connector... near the end.

There's no way to just say "Hey, here's the mysql-connector jar file -- 
use it" anywhere?


On 01/12/2017 11:11 PM, james yong wrote:
> Hi Craig,
>
> Should be something like this:
> runtime 'mysql:mysql-connector-java:5.1.40'
>
> Regards,
> James
>
>
> Craig Parker wrote
>> I added this:
>>
>> runtime 'mysql:mysql-connector-java-5.1.40-bin.jar'
>>
>> to build.gradle, and tried a few other varyations, but get essentially
>> the same error. I've run it with info, debug, and stacktrace, but still
>> can't make heads or tails of it. Not sure how to specify a file path.
>> I've copied it over to the /home/ofbiz directory referenced with a file:
>> line, but it's also sitting in framework/entity, which is where I'd
>> rather stick it.
>>
>>
>> * What went wrong:
>> A problem occurred evaluating root project 'ofbiz'.
>>   > Could not resolve all dependencies for configuration ':runtime'.
>>      > Could not find mysql:mysql-connector-java-5.1.40-bin.jar:.
>>        Searched in the following locations:
>> https://jcenter.bintray.com/mysql/mysql-connector-java-5.1.40-bin.jar//mysql-connector-java-5.1.40-bin.jar-.pom
>> https://jcenter.bintray.com/mysql/mysql-connector-java-5.1.40-bin.jar//mysql-connector-java-5.1.40-bin.jar-.jar
>> file:/home/ofbiz/.m2/repository/mysql/mysql-connector-java-5.1.40-bin.jar//mysql-connector-java-5.1.40-bin.jar-.pom
>> file:/home/ofbiz/.m2/repository/mysql/mysql-connector-java-5.1.40-bin.jar//mysql-connector-java-5.1.40-bin.jar-.jar
>>        Required by:
>>            :ofbiz:unspecified
>>
>>
>>
>> On 01/12/2017 12:34 AM, Taher Alkhateeb wrote:
>>> http://markmail.org/message/5qjjnxvvkyp7cxax
>>>
>>> On Jan 12, 2017 5:47 AM, "Craig Parker" &lt;
>> craig@
>> &gt; wrote:
>>>> Where does this go these days? Last I knew (13.x) it was
>>>> framework/entity/lib/jdbc/ but there's no lib in the entity directory
>>>> any
>>>> more. Make one, or is there somewhere else I should stick it? Does it
>>>> matter, as long as framework/entity/config/entityengine.xml specifies
>>>> the
>>>> right spot?
>>>>
>>>>
>
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Apachecon-Feathercast-Interview-with-Taher-tp4699219p4701005.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.


Re: MySQL connector

Posted by james yong <i_...@yahoo.com.sg>.
Hi Craig,

Should be something like this:
runtime 'mysql:mysql-connector-java:5.1.40'

Regards,
James


Craig Parker wrote
> I added this:
> 
> runtime 'mysql:mysql-connector-java-5.1.40-bin.jar'
> 
> to build.gradle, and tried a few other varyations, but get essentially 
> the same error. I've run it with info, debug, and stacktrace, but still 
> can't make heads or tails of it. Not sure how to specify a file path. 
> I've copied it over to the /home/ofbiz directory referenced with a file: 
> line, but it's also sitting in framework/entity, which is where I'd 
> rather stick it.
> 
> 
> * What went wrong:
> A problem occurred evaluating root project 'ofbiz'.
>  > Could not resolve all dependencies for configuration ':runtime'.
>     > Could not find mysql:mysql-connector-java-5.1.40-bin.jar:.
>       Searched in the following locations:
> https://jcenter.bintray.com/mysql/mysql-connector-java-5.1.40-bin.jar//mysql-connector-java-5.1.40-bin.jar-.pom
> https://jcenter.bintray.com/mysql/mysql-connector-java-5.1.40-bin.jar//mysql-connector-java-5.1.40-bin.jar-.jar
> file:/home/ofbiz/.m2/repository/mysql/mysql-connector-java-5.1.40-bin.jar//mysql-connector-java-5.1.40-bin.jar-.pom
> file:/home/ofbiz/.m2/repository/mysql/mysql-connector-java-5.1.40-bin.jar//mysql-connector-java-5.1.40-bin.jar-.jar
>       Required by:
>           :ofbiz:unspecified
> 
> 
> 
> On 01/12/2017 12:34 AM, Taher Alkhateeb wrote:
>> http://markmail.org/message/5qjjnxvvkyp7cxax
>>
>> On Jan 12, 2017 5:47 AM, "Craig Parker" &lt;

> craig@

> &gt; wrote:
>>
>>> Where does this go these days? Last I knew (13.x) it was
>>> framework/entity/lib/jdbc/ but there's no lib in the entity directory
>>> any
>>> more. Make one, or is there somewhere else I should stick it? Does it
>>> matter, as long as framework/entity/config/entityengine.xml specifies
>>> the
>>> right spot?
>>>
>>>





--
View this message in context: http://ofbiz.135035.n4.nabble.com/Apachecon-Feathercast-Interview-with-Taher-tp4699219p4701005.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: MySQL connector

Posted by Scott Gray <sc...@hotwaxsystems.com>.
Hi Craig,

Based on the output, you probably don't want to be including the .jar
suffix, looks like gradle adds that itself.

Regards
Scott

On 13 January 2017 at 14:51, Craig Parker <cr...@fossfolks.com> wrote:

> I added this:
>
> runtime 'mysql:mysql-connector-java-5.1.40-bin.jar'
>
> to build.gradle, and tried a few other varyations, but get essentially the
> same error. I've run it with info, debug, and stacktrace, but still can't
> make heads or tails of it. Not sure how to specify a file path. I've copied
> it over to the /home/ofbiz directory referenced with a file: line, but it's
> also sitting in framework/entity, which is where I'd rather stick it.
>
>
> * What went wrong:
> A problem occurred evaluating root project 'ofbiz'.
> > Could not resolve all dependencies for configuration ':runtime'.
>    > Could not find mysql:mysql-connector-java-5.1.40-bin.jar:.
>      Searched in the following locations:
> https://jcenter.bintray.com/mysql/mysql-connector-java-5.1.
> 40-bin.jar//mysql-connector-java-5.1.40-bin.jar-.pom
> https://jcenter.bintray.com/mysql/mysql-connector-java-5.1.
> 40-bin.jar//mysql-connector-java-5.1.40-bin.jar-.jar
> file:/home/ofbiz/.m2/repository/mysql/mysql-connector-java-
> 5.1.40-bin.jar//mysql-connector-java-5.1.40-bin.jar-.pom
> file:/home/ofbiz/.m2/repository/mysql/mysql-connector-java-
> 5.1.40-bin.jar//mysql-connector-java-5.1.40-bin.jar-.jar
>      Required by:
>          :ofbiz:unspecified
>
>
>
>
> On 01/12/2017 12:34 AM, Taher Alkhateeb wrote:
>
>> http://markmail.org/message/5qjjnxvvkyp7cxax
>>
>> On Jan 12, 2017 5:47 AM, "Craig Parker" <cr...@fossfolks.com> wrote:
>>
>> Where does this go these days? Last I knew (13.x) it was
>>> framework/entity/lib/jdbc/ but there's no lib in the entity directory any
>>> more. Make one, or is there somewhere else I should stick it? Does it
>>> matter, as long as framework/entity/config/entityengine.xml specifies
>>> the
>>> right spot?
>>>
>>>
>>>
>

Re: MySQL connector

Posted by Craig Parker <cr...@fossfolks.com>.
I added this:

runtime 'mysql:mysql-connector-java-5.1.40-bin.jar'

to build.gradle, and tried a few other varyations, but get essentially 
the same error. I've run it with info, debug, and stacktrace, but still 
can't make heads or tails of it. Not sure how to specify a file path. 
I've copied it over to the /home/ofbiz directory referenced with a file: 
line, but it's also sitting in framework/entity, which is where I'd 
rather stick it.


* What went wrong:
A problem occurred evaluating root project 'ofbiz'.
 > Could not resolve all dependencies for configuration ':runtime'.
    > Could not find mysql:mysql-connector-java-5.1.40-bin.jar:.
      Searched in the following locations:
https://jcenter.bintray.com/mysql/mysql-connector-java-5.1.40-bin.jar//mysql-connector-java-5.1.40-bin.jar-.pom
https://jcenter.bintray.com/mysql/mysql-connector-java-5.1.40-bin.jar//mysql-connector-java-5.1.40-bin.jar-.jar
file:/home/ofbiz/.m2/repository/mysql/mysql-connector-java-5.1.40-bin.jar//mysql-connector-java-5.1.40-bin.jar-.pom
file:/home/ofbiz/.m2/repository/mysql/mysql-connector-java-5.1.40-bin.jar//mysql-connector-java-5.1.40-bin.jar-.jar
      Required by:
          :ofbiz:unspecified



On 01/12/2017 12:34 AM, Taher Alkhateeb wrote:
> http://markmail.org/message/5qjjnxvvkyp7cxax
>
> On Jan 12, 2017 5:47 AM, "Craig Parker" <cr...@fossfolks.com> wrote:
>
>> Where does this go these days? Last I knew (13.x) it was
>> framework/entity/lib/jdbc/ but there's no lib in the entity directory any
>> more. Make one, or is there somewhere else I should stick it? Does it
>> matter, as long as framework/entity/config/entityengine.xml specifies the
>> right spot?
>>
>>


Re: MySQL connector

Posted by Taher Alkhateeb <sl...@gmail.com>.
http://markmail.org/message/5qjjnxvvkyp7cxax

On Jan 12, 2017 5:47 AM, "Craig Parker" <cr...@fossfolks.com> wrote:

> Where does this go these days? Last I knew (13.x) it was
> framework/entity/lib/jdbc/ but there's no lib in the entity directory any
> more. Make one, or is there somewhere else I should stick it? Does it
> matter, as long as framework/entity/config/entityengine.xml specifies the
> right spot?
>
>