Skip to content

Ofbiz with MaxDB

Finally! I was able to get Ofbiz running with MaxDB.

First impression about MaxDB by MySQL (formerly SAP DB) that it's quite nice. Problems are easier to locate and solve than MySQL (so far). The Database Manager GUI rocks (though I wonder if Database Administrator from MySQL can connect to MaxDB – but perhaps another day for that issue). Still exploring SQL Studio (the Catalogue Manager “Continue” link is awful – I'll try to find some setup to list all the available tables in the database instead of paging those tables with the continue link).

Its support for triggers and stored procedures will sure prove helpful.

I hope I don't run into unsolvable limitations/troubles with MaxDB until I get my feet on solid grounds with Ofbiz.

I plugged Ofbiz to MaxDB after the necessary user creation, RESOURCE user privlege, MaxDB _UNICODE parameter, and rotating log files (after database hung for couple of times).

I loaded the data into the database via the provided functionality in Webtools (run script to load data).

I will soon work on configuring an e-commerce web site (wish me luck).

Eager to hear any experiences with Ofbiz.

Posted in Java.

One Response

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.

  1. Jacob says

    God this is such a pain… I just started using ofbiz and although I am looking forward to being able to say I have a handle on such a powerful program, I am stuck at this point where you have finally succeeded. I have tried using master database accounts and the one specifically designed for the instance I created and no luck… do you recall what you did to get it to connect? Did you need to assign a port? Did you have to keep the GUI for MaxDB running?

Some HTML is OK

or, reply to this post via trackback.