Questions Tagged With database

Using Derby Database in Axon.ivy

TareqK — Wed, 08 Apr 2020 04:49:27 -0400

Hello, Is there any way to use the apache derby database in AxonIvy platform 8.0? I tried adding the driver to the project buildpath and configuring the database, but it isnt working through the editor. Is there something that i need to do for it to work?

Cannot modify the length of ivy task name in the database

ntctuyen — Sat, 02 Nov 2019 03:34:04 -0400

Hi there.

Today, I have a problem with the name of a task. The name of the task is over 200 characters and exceeds the capacity the whole task name can be saved to the database.

My question is how can I change the length of the Ivy task name in the database? I want to make it unlimited.

Thank you

NoSQL In Axon.Ivy

TareqK — Fri, 25 Oct 2019 14:17:17 -0400

Hello, Has anybody had any experiences with Axon.Ivy and NoSQL databases(namely, MongoDB) ? And if so, how did they approach it and what were the benefits/downsides of using NoSQL with Axon.Ivy.

I know that Axon.Ivy Has some NoSQL functionality in it, but we are considering to use a more robust external database rather than relying on the internal one.

For context, I have some experience in NoSQL and java, Namely in MongoDB using the Jongo driver. Anybody who has done java implementations is also welcome to share their knowledge.

Get data from database directly not via ElasticSearch

Phuoc Nguyen — Wed, 28 Aug 2019 08:51:59 -0400

Hi everyone, I have a case can not get data via ElasticSearch, I want to get data from iwa_bussiness in the database directly. Have any Ivy API to support this case?. Thank!

How to count all rows in the database

Phuoc Nguyen — Thu, 06 Jun 2019 06:38:01 -0400

Hi all, Currently, I want to know in the database have many records and I try to use businessDataRepository.search(t.getClass()).execute().count();, but this one just returns for me 10 rows by default. For example: in the database, I have 10.000 records, and I want to return this number.

Do we have any API to do this case?

Huge MySQL/MariaDB System Database has slow response time

SupportIvyTeam — Mon, 04 Feb 2019 10:43:40 -0500

I've got so far some ivy engines running with mysql and mariadb as system database. The databases are huge, with about 10'000'000 tasks. With more and more tasks the responding time will be slower. The more tasks in the database, the worse the response times. Is there anything I can do to optimize this?

How to execute some code at Ivy Project deployment time for upgrading a database ?

Emmanuel Comba — Wed, 12 Dec 2018 09:49:00 -0500

Hi IvyTeam,

We have the following situation: we will have to deploy from time to time an Ivy Application. This application defines a database (MS SQL) for storing the application's data. We would like to create/update this database automatically at Ivy Deployment time with an database updating system like Flyway. (With some SQL Scripts CREATE / UPDATE TABLE ....)

Is that already possible with Ivy? Ivy does it already at Ivy Engine installation or upgrade time with its System database. This would be a great feature if we could create/upgrade our project's databases at application deployment time.
If not we should be able to execute some code at Ivy deployment time. Is there some Ivy Server Extension points allowing this easily?

Thanks a lot in advance Cheers Emmanuel

How can i save bytearrays via the entityclass in a database?

markusinho — Thu, 11 Oct 2018 11:00:01 -0400

Hello,

I am trying to set up an entityclass with a postgres server. I need this database to store some images i upload with the primefaces < p:fileUpload/> tag. With this tag the images are uploaded as a UploadedFile, now I can access the contents via getContents() and I will get the image as a Bytearray (byte[] in Java) .

Now I need to know how can i save this Byte Array via the entityclasses in my postgres database. Postgres allows the datatype bytea for a column for this datatype, but if I add Bytearray as a type for the column in the entityclass AxonIvy throws this error: The field type 'Binary' does not support persistence.

So my question is:
Is there any possibility i can save bytearray or blobs on my postgres server via the entity class?
What are all the classes which support persistence?

Thanks

How to access database in a faces Validator

wesing — Mon, 23 Jul 2018 23:32:38 -0400

Hi all, I am new to AXON IVY. Hope you can be patient with me.

I am trying to use that code here: https://answers.axonivy.com/questions/314/using-db-connection-from-pis (provided by Ivy Support Team) in a Java class in a CustomValidator class to look up a database table. Somehow I could not resolve the Ivy object.

I tried looking up getProcessEngineHook method in https://developer.axonivy.com/doc/latest/PublicAPI but the search doesn't return any results.

My codes as follows:

package trial.facesValidation;
import javax.faces.application.FacesMessage;
import javax.faces.component.UIComponent;
import javax.faces.context.FacesContext;
import javax.faces.validator.FacesValidator;
import javax.faces.validator.Validator;
import javax.faces.validator.ValidatorException;
import  java.sql.Connection;

// To validate if Item Name already existed in Parts table in Database
@FacesValidator("trial.facesValidation.CustomItemValidator")
public class CustomItemValidator implements Validator {

    @Override
    public void validate(FacesContext context, UIComponent component, Object value) throws ValidatorException 
    {
        //connect to the database
        Connection dbconnection = ivy.getProcessEngineHook().getDbConnection("TrialDBConn");

        try
        {
        // execute some sql queries
        } finally {
        // close the connection
              dbconnection.close();
        }

How do I specify the maximum number of connections to the IvySystemDatabase?

SupportIvyTeam — Fri, 06 Jul 2018 09:27:05 -0400

I would like to increase the size of the database connection pool to the system database. I couldn't find a system property that does that so far.

Can I change the connection pool size and if yes, how?