Apachecon Feathercast Interview with Taher

[taher]

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

[Craig Parker]

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.

[taher]

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