DEV Community: cybin

Error: "Unique index or primary key violation:"

cybin — Sun, 12 Mar 2023 20:04:10 +0000

Error due to manual insertion of values setting the primary keys in the data.sql file.

FAILURE example:
INSERT INTO role (id, roleName) VALUES (1, 'admin'), (2, 'user');

WORKING example:
INSERT INTO role (roleName) VALUES ('admin'), ('user');

Setting the ids manually only let us persist data from the last added row, all the previous ones will return you a Unique index or primary key violation: error.
So, for example, if we have 3 rows added in our data.sql, only the 4th persist operation will succeed.

OpenApi Spring 3 NoProviderFoundException

cybin — Mon, 27 Feb 2023 19:02:53 +0000

So I started a simple Java 17 and Spring 3 new project with a couple of endpoints and first thing first, I added a Swagger, instantly I discovered that Swagger is not compatible with the new jakarta source of Spring 3.
Than I decided to use Sprindocs' OpenApi. It works by simply adding the dependencies:
<dependency> <groupId>org.springdoc</groupId> <artifactId>springdoc-openapi-starter-webmvc-ui</artifactId> <version>2.0.2</version> </dependency> <dependency> <groupId>org.springdoc</groupId> <artifactId>springdoc-openapi-starter-webmvc-api</artifactId> <version>2.0.2</version> </dependency>
Source: https://springdoc.org/v2/#javadoc-support

The project was compiling and starting but there were still one exception:
jakarta.validation.NoProviderFoundException: Unable to create a Configuration, because no Jakarta Bean Validation provider could be found. Add a provider like Hibernate Validator (RI) to your classpath.

So to solve this, I had to add a jakarta validation api:

<dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-validation</artifactId> </dependency>

PS: solution found at: https://stackoverflow.com/questions/75418394/spring-boot-3-after-add-openapi-dependency-noproviderfoundexception

Regex pattern to include needed chars only

cybin — Mon, 27 Feb 2023 13:02:28 +0000

I've been asked in a task to make a solution to exclude a list of characters but leaving the normal characters and numbers.

So the following special characters are permitted: "%&$_"

String regexp = "^[a-zA-Z0-9%&$_]*$"; boolean aux = rndmObject.getFileName().matches(regexp);

Hope that this helps someone.