Java spring boot project

🧠 Prompt:

You are an expert backend engineer. Build a full backend microservice using Java Spring Boot (JDK 21) for an “Organization Verification” system for a donation platform.

📌 Simplified Requirements:

Skip robust authentication for now — no JWT/Spring Security. Focus only on basic organization registration and admin review.

🎯 Core Functionalities:

Organization Registration:

Endpoint: POST /api/org/register
Input: name, email, phone, location, license document (PDF/JPG)
Store license doc locally
Save record in PostgreSQL with status = "PENDING"

Admin Actions:

GET /api/admin/orgs/pending → List all pending orgs
PUT /api/admin/orgs/{id}/approve → Approve and generate license ID
PUT /api/admin/orgs/{id}/reject → Reject with reason

License Generation:

License ID = UUID or incremental
Optional: Generate a PDF license and send to org email

Dashboard for Org:

GET /api/org/status?email= → Return current org status, license ID, and link to license document

File Handling:

Save uploaded docs to local storage
Metadata stored in PostgreSQL
GET /api/admin/orgs/{id}/document → Admin-only access

Email Notification:

Use JavaMailSender to notify org on approval or rejection

Exception Handling:

Global exception handler
Return consistent error responses

🧱 Tech Stack:

Java 21, Spring Boot, Spring Web, Spring Data JPA
PostgreSQL
Optional: MongoDB GridFS for document storage
JavaMailSender
Maven
OpenAPI 3/Swagger
Lombok

📁 Folder Structure:

controller
service
repository
model (DTO + entities)
config
exception
utils
application.properties

📄 Output:

Full Maven-based Spring Boot project
Ready to download or push to GitHub
Sample DB schema (PostgreSQL)
Swagger enabled
Sample email config in application.properties

Show full message

145d ago

I'll create a complete Spring Boot microservice for the Organization Verification system. Let's break this down into a well-structured project.

Organization Verification Microservice

Let's build a complete Spring Boot microservice for organization verification on a donation platform.

Project Overview

This Spring Boot microservice provides a complete solution for organization verification on a donation platform. Here's a breakdown of the key components:

Core Features

Organization Registration
- Organizations can register with their details and upload license documents
- Documents are stored locally with unique filenames
- Registration status starts as "PENDING"
Admin Review Process
- Admins can view all pending organizations
- Approve organizations and generate license IDs
- Reject organizations with a reason
License Management
- Automatic generation of license IDs (UUID-based)
- Creation of license documents for approved organizations
- Secure document storage and retrieval
Status Checking
- Organizations can check their verification status
- View license details if approved
- See rejection reasons if rejected
Email Notifications
- Registration confirmation
- Approval notifications with license details
- Rejection notifications with reasons

Technical Implementation

Data Layer: PostgreSQL with JPA/Hibernate for ORM
File Storage: Local file system with unique naming
API Documentation: OpenAPI/Swagger for easy testing
Error Handling: Global exception handler for consistent responses
Email Service: Async email sending with HTML templates
Validation: Input validation with helpful error messages

How to Run

Configure PostgreSQL database in application.properties
Set up email credentials for notifications
Run the application with Maven: mvn spring-boot:run
Access Swagger UI at: http://localhost:8080/swagger-ui.html

API Endpoints

Organization API

POST /api/org/register - Register a new organization
GET /api/org/status?email=... - Check organization status
GET /api/org/license/{id} - Download organization license

Admin API

GET /api/admin/orgs/pending - List all pending organizations
PUT /api/admin/orgs/{id}/approve - Approve an organization
PUT /api/admin/orgs/{id}/reject - Reject an organization
GET /api/admin/orgs/{id}/document - Download organization document

This microservice is designed to be extensible and maintainable, with clear separation of concerns and comprehensive error handling.

145d ago

on) Hibernate: create table organizations (id bigserial not null, created_at timestamp(6) not null, document_name varchar(255) not null, document_path varchar(255) not null, email varchar(255) not null, license_id varchar(255), license_path varchar(255), location varchar(255) not null, name varchar(255) not null, phone varchar(255) not null, rejection_reason varchar(255), status varchar(255) not null check (status in ('PENDING','APPROVED','REJECTED')), updated_at timestamp(6), primary key (id)) 2025-04-25T19:45:30.964+05:30 WARN 21543 --- [ main] o.h.t.s.i.ExceptionHandlerLoggedImpl : GenerationTarget encountered exception accepting command : Error executing DDL "create table organizations (id bigserial not null, created_at timestamp(6) not null, document_name varchar(255) not null, document_path varchar(255) not null, email varchar(255) not null, license_id varchar(255), license_path varchar(255), location varchar(255) not null, name varchar(255) not null, phone varchar(255) not null, rejection_reason varchar(255), status varchar(255) not null check (status in ('PENDING','APPROVED','REJECTED')), updated_at timestamp(6), primary key (id))" via JDBC [ERROR: permission denied for schema public Position: 14] org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table organizations (id bigserial not null, created_at timestamp(6) not null, document_name varchar(255) not null, document_path varchar(255) not null, email varchar(255) not null, license_id varchar(255), license_path varchar(255), location varchar(255) not null, name varchar(255) not null, phone varchar(255) not null, rejection_reason varchar(255), status varchar(255) not null check (status in ('PENDING','APPROVED','REJECTED')), updated_at timestamp(6), primary key (id))" via JDBC [ERROR: permission denied for schema public Position: 14] at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:94) ~[hibernate-core-6.4.4.Final.jar:6.4.4.Final] at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:574) ~[hibernate-core-6.4.4.Final.jar:6.4.4.Final] at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:514) ~[hibernate-core-6.4.4.Final.jar:6.4.4.Final] at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.createTable(AbstractSchemaMigrator.java:315) ~[hibernate-core-6.4.4.Final.jar:6.4.4.Final] at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:80) ~[hibernate-core-6.4.4.Final.jar:6.4.4.Final] at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:232) ~[hibernate-core-6.4.4.Final.jar:6.4.4.Final] at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:117) ~[hibernate-core-6.4.4.Final.jar:6.4.4.Final] at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:286) ~[hibernate-core-6.4.4.Final.jar:6.4.4.Final] at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.lambda$process$5(SchemaManagementToolCoordinator.java:145) ~[hibernate-core-6.4.4.Final.jar:6.4.4.Final] at java.base/java.util.HashMap.forEach(HashMap.java:1429) ~[na:na] at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:142) ~[hibernate-core-6.4.4.Final.jar:6.4.4.Final] at org.hibernate.boot.internal.SessionFactoryObserverForSchemaExport.sessionFactoryCreated(SessionFactoryObserverForSchemaExport.java:37) ~[hibernate-core-6.4.4.Final.jar:6.4.4.Final] at org.hibernate.internal.SessionFactoryObserverChain.sessionFactoryCreated(SessionFactoryObserverChain.java:35) ~[hibernate-core-6.4.4.Final.jar:6.4.4.Final] at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:315) ~[hibernate-core-6.4.4.Final.jar:6.4.4.Final] at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:450) ~[hibernate-core-6.4.4.Final.jar:6.4.4.Final] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1507) ~[hibernate-core-6.4.4.Final.jar:6.4.4.Final] at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:75) ~[spring-orm-6.1.4.jar:6.1.4] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:388) ~[spring-orm-6.1.4.jar:6.1.4] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409) ~[spring-orm-6.1.4.jar:6.1.4] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:396) ~[spring-orm-6.1.4.jar:6.1.4] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:364) ~[spring-orm-6.1.4.jar:6.1.4] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1833) ~[spring-beans-6.1.4.jar:6.1.4] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1782) ~[spring-beans-6.1.4.jar:6.1.4] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:600) ~[spring-beans-6.1.4.jar:6.1.4] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:522) ~[spring-beans-6.1.4.jar:6.1.4] at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:325) ~[spring-beans-6.1.4.jar:6.1.4] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-6.1.4.jar:6.1.4] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:323) ~[spring-beans-6.1.4.jar:6.1.4] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-6.1.4.jar:6.1.4] at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1231) ~[spring-context-6.1.4.jar:6.1.4] at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:949) ~[spring-context-6.1.4.jar:6.1.4] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:624) ~[spring-context-6.1.4.jar:6.1.4] at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146) ~[spring-boot-3.2.3.jar:3.2.3] at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:754) ~[spring-boot-3.2.3.jar:3.2.3] at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:456) ~[spring-boot-3.2.3.jar:3.2.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:334) ~[spring-boot-3.2.3.jar:3.2.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1354) ~[spring-boot-3.2.3.jar:3.2.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1343) ~[spring-boot-3.2.3.jar:3.2.3] at com.donation.orgverification.OrgVerificationApplication.main(OrgVerificationApplication.java:18) ~[classes/:na] Caused by: org.postgresql.util.PSQLException: ERROR: permission denied for schema public Position: 14 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713) ~[postgresql-42.6.1.jar:42.6.1] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2401) ~[postgresql-42.6.1.jar:42.6.1] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:368) ~[postgresql-42.6.1.jar:42.6.1] at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:498) ~[postgresql-42.6.1.jar:42.6.1] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:415) ~[postgresql-42.6.1.jar:42.6.1] at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:335) ~[postgresql-42.6.1.jar:42.6.1] at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:321) ~[postgresql-42.6.1.jar:42.6.1] at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:297) ~[postgresql-42.6.1.jar:42.6.1] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:292) ~[postgresql-42.6.1.jar:42.6.1] at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) ~[HikariCP-5.0.1.jar:na] at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-5.0.1.jar:na] at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:80) ~[hibernate-core-6.4.4.Final.jar:6.4.4.Final] ... 38 common frames omitted Hibernate: alter table if exists organizations drop constraint if exists UK_pe8sgvd49hsasoq2kqav6nhkv 2025-04-25T19:45:30.975+05:30 WARN 21543 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Warning Code: 0, SQLState: 00000 2025-04-25T19:45:30.975+05:30 WARN 21543 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : relation "organizations" does not exist, skipping Hibernate: alter table if exists organizations add constraint UK_pe8sgvd49hsasoq2kqav6nhkv unique (email) 2025-04-25T19:45:30.977+05:30 WARN 21543 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Warning Code: 0, SQLState: 00000 2025-04-25T19:45:30.977+05:30 WARN 21543 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : relation "organizations" does not exist, skipping 2025-04-25T19:45:30.979+05:30 INFO 21543 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' 2025-04-25T19:45:31.647+05:30 WARN 21543 --- [ main] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning 2025-04-25T19:45:32.172+05:30 INFO 21543 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port 8080 (http) with context path '' 2025-04-25T19:45:32.184+05:30 INFO 21543 --- [ main] c.d.o.OrgVerificationApplication : Started OrgVerificationApplication in 5.452 seconds (process running for 5.842) your-app-password2025-04-25T19:47:39.566+05:30 INFO 21543 --- [nio-8080-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring DispatcherServlet 'dispatcherServlet' 2025-04-25T19:47:39.566+05:30 INFO 21543 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet' 2025-04-25T19:47:39.568+05:30 INFO 21543 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet : Completed initialization in 2 ms 2025-04-25T19:47:39.686+05:30 ERROR 21543 --- [nio-8080-exec-1] c.d.o.exception.GlobalExceptionHandler : Unhandled exception org.springframework.web.HttpMediaTypeNotSupportedException: Content-Type 'application/octet-stream' is not supported at org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodArgumentResolver.readWithMessageConverters(AbstractMessageConverterMethodArgumentResolver.java:213) ~[spring-webmvc-6.1.4.jar:6.1.4] at org.springframework.web.servlet.mvc.method.annotation.RequestPartMethodArgumentResolver.resolveArgument(RequestPartMethodArgumentResolver.java:141) ~[spring-webmvc-6.1.4.jar:6.1.4] at org.springframework.web.method.support.HandlerMethodArgumentResolverComposite.resolveArgument(HandlerMethodArgumentResolverComposite.java:122) ~[spring-web-6.1.4.jar:6.1.4] at org.springframework.web.method.support.InvocableHandlerMethod.getMethodArgumentValues(InvocableHandlerMethod.java:228) ~[spring-web-6.1.4.jar:6.1.4] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:182) ~[spring-web-6.1.4.jar:6.1.4] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:118) ~[spring-webmvc-6.1.4.jar:6.1.4] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:920) ~[spring-webmvc-6.1.4.jar:6.1.4] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:830) ~[spring-webmvc-6.1.4.jar:6.1.4] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-6.1.4.jar:6.1.4] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1089) ~[spring-webmvc-6.1.4.jar:6.1.4] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:979) ~[spring-webmvc-6.1.4.jar:6.1.4] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1014) ~[spring-webmvc-6.1.4.jar:6.1.4] at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:914) ~[spring-webmvc-6.1.4.jar:6.1.4] at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:590) ~[tomcat-embed-core-10.1.19.jar:6.0] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885) ~[spring-webmvc-6.1.4.jar:6.1.4] at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:658) ~[tomcat-embed-core-10.1.19.jar:6.0] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:205) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) ~[tomcat-embed-websocket-10.1.19.jar:10.1.19] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-6.1.4.jar:6.1.4] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116) ~[spring-web-6.1.4.jar:6.1.4] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-6.1.4.jar:6.1.4] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116) ~[spring-web-6.1.4.jar:6.1.4] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-6.1.4.jar:6.1.4] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116) ~[spring-web-6.1.4.jar:6.1.4] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:391) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:896) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1744) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) ~[tomcat-embed-core-10.1.19.jar:10.1.19] at java.base/java.lang.Thread.run(Thread.java:1583) ~[na:na] it is throwing unexpexted errors { "status": 500, "message": "An unexpected error occurred", "timestamp": "2025-04-25T19:47:39.690781354" } Response headers connection: close content-type: application/json date: Fri,25 Apr 2025 14:17:39 GMT transfer-encoding: chunked vary: Origin,Access-Control-Request-Method,Access-Control-Request-Headers

Show full message

145d ago

I see you're encountering two main issues with the Spring Boot application:

PostgreSQL permission error: permission denied for schema public
Content-Type error: Content-Type 'application/octet-stream' is not supported

Let me help you fix both issues:

Fixing the Issues

I've made several changes to fix the issues you're encountering:

1. PostgreSQL Permission Error

The error permission denied for schema public indicates that your PostgreSQL user doesn't have permission to create tables in the public schema. I've made these changes:

Changed Hibernate DDL Auto Setting:
- Modified spring.jpa.hibernate.ddl-auto from update to none to prevent Hibernate from trying to create/update tables automatically
- This way, you can manually create the tables using the provided schema.sql script
Added a Complete SQL Script:
- Provided a comprehensive schema.sql file that you should run manually with admin privileges before starting the application
- This script creates the necessary table and indexes

2. Content-Type Error

The error Content-Type 'application/octet-stream' is not supported suggests an issue with how the multipart form data is being processed:

Updated Controller Method:
- Added required = true to both @RequestPart annotations to make the validation clearer
- Ensured proper handling of multipart form data
Added File Upload Configuration:
- Created a new FileUploadConfig class that ensures the upload directory exists when the application starts

How to Fix the Issues

Database Setup:
- Run the schema.sql script manually in your PostgreSQL database using an admin account
- This will create the necessary table structure without requiring Hibernate to do it
Application Configuration:
- Use the updated application.properties file with spring.jpa.hibernate.ddl-auto=none
- Make sure the upload directory exists or is created by the application
API Testing:
- When testing the /api/org/register endpoint, ensure you're using proper multipart form data:
  - The organization part should be JSON with Content-Type application/json
  - The document part should be a file with Content-Type matching the file type (e.g., application/pdf)
Using Swagger UI:
- Access Swagger UI at http://localhost:8080/swagger-ui.html
- This provides a user-friendly interface to test your APIs correctly

These changes should resolve both the PostgreSQL permission issue and the Content-Type error you're experiencing.

145d ago

src

main

java

com

donation

orgverification

config

FileUploadConfig.java

WorkingWorking...

Working...

🧠 Prompt:

You are an expert backend engineer. Build a full backend microservice using Java Spring Boot (JDK 21) for an “Organization Verification” system for a donation platform.

📌 Simplified Requirements:

Skip robust authentication for now — no JWT/Spring Security. Focus only on basic organization registration and admin review.

🎯 Core Functionalities:

Organization Registration:

Endpoint: POST /api/org/register
Input: name, email, phone, location, license document (PDF/JPG)
Store license doc locally
Save record in PostgreSQL with status = "PENDING"

Admin Actions:

GET /api/admin/orgs/pending → List all pending orgs
PUT /api/admin/orgs/{id}/approve → Approve and generate license ID
PUT /api/admin/orgs/{id}/reject → Reject with reason

License Generation:

License ID = UUID or incremental
Optional: Generate a PDF license and send to org email

Dashboard for Org:

GET /api/org/status?email= → Return current org status, license ID, and link to license document

File Handling:

Save uploaded docs to local storage
Metadata stored in PostgreSQL
GET /api/admin/orgs/{id}/document → Admin-only access

Email Notification:

Use JavaMailSender to notify org on approval or rejection

Exception Handling:

Global exception handler
Return consistent error responses

🧱 Tech Stack:

Java 21, Spring Boot, Spring Web, Spring Data JPA
PostgreSQL
Optional: MongoDB GridFS for document storage
JavaMailSender
Maven
OpenAPI 3/Swagger
Lombok

📁 Folder Structure:

controller
service
repository
model (DTO + entities)
config
exception
utils
application.properties

📄 Output:

Full Maven-based Spring Boot project
Ready to download or push to GitHub
Sample DB schema (PostgreSQL)
Swagger enabled
Sample email config in application.properties

Show full message

145d ago

I'll create a complete Spring Boot microservice for the Organization Verification system. Let's break this down into a well-structured project.

Organization Verification Microservice

Let's build a complete Spring Boot microservice for organization verification on a donation platform.

Project Overview

This Spring Boot microservice provides a complete solution for organization verification on a donation platform. Here's a breakdown of the key components:

Core Features

Organization Registration
- Organizations can register with their details and upload license documents
- Documents are stored locally with unique filenames
- Registration status starts as "PENDING"
Admin Review Process
- Admins can view all pending organizations
- Approve organizations and generate license IDs
- Reject organizations with a reason
License Management
- Automatic generation of license IDs (UUID-based)
- Creation of license documents for approved organizations
- Secure document storage and retrieval
Status Checking
- Organizations can check their verification status
- View license details if approved
- See rejection reasons if rejected
Email Notifications
- Registration confirmation
- Approval notifications with license details
- Rejection notifications with reasons

Technical Implementation

Data Layer: PostgreSQL with JPA/Hibernate for ORM
File Storage: Local file system with unique naming
API Documentation: OpenAPI/Swagger for easy testing
Error Handling: Global exception handler for consistent responses
Email Service: Async email sending with HTML templates
Validation: Input validation with helpful error messages

How to Run

Configure PostgreSQL database in application.properties
Set up email credentials for notifications
Run the application with Maven: mvn spring-boot:run
Access Swagger UI at: http://localhost:8080/swagger-ui.html

API Endpoints

Organization API

POST /api/org/register - Register a new organization
GET /api/org/status?email=... - Check organization status
GET /api/org/license/{id} - Download organization license

Admin API

GET /api/admin/orgs/pending - List all pending organizations
PUT /api/admin/orgs/{id}/approve - Approve an organization
PUT /api/admin/orgs/{id}/reject - Reject an organization
GET /api/admin/orgs/{id}/document - Download organization document

This microservice is designed to be extensible and maintainable, with clear separation of concerns and comprehensive error handling.

145d ago

I see you're encountering two main issues with the Spring Boot application:

PostgreSQL permission error: permission denied for schema public
Content-Type error: Content-Type 'application/octet-stream' is not supported

Let me help you fix both issues:

Fixing the Issues

I've made several changes to fix the issues you're encountering:

1. PostgreSQL Permission Error

The error permission denied for schema public indicates that your PostgreSQL user doesn't have permission to create tables in the public schema. I've made these changes:

Changed Hibernate DDL Auto Setting:
- Modified spring.jpa.hibernate.ddl-auto from update to none to prevent Hibernate from trying to create/update tables automatically
- This way, you can manually create the tables using the provided schema.sql script
Added a Complete SQL Script:
- Provided a comprehensive schema.sql file that you should run manually with admin privileges before starting the application
- This script creates the necessary table and indexes

2. Content-Type Error

The error Content-Type 'application/octet-stream' is not supported suggests an issue with how the multipart form data is being processed:

Updated Controller Method:
- Added required = true to both @RequestPart annotations to make the validation clearer
- Ensured proper handling of multipart form data
Added File Upload Configuration:
- Created a new FileUploadConfig class that ensures the upload directory exists when the application starts

How to Fix the Issues

Database Setup:
- Run the schema.sql script manually in your PostgreSQL database using an admin account
- This will create the necessary table structure without requiring Hibernate to do it
Application Configuration:
- Use the updated application.properties file with spring.jpa.hibernate.ddl-auto=none
- Make sure the upload directory exists or is created by the application
API Testing:
- When testing the /api/org/register endpoint, ensure you're using proper multipart form data:
  - The organization part should be JSON with Content-Type application/json
  - The document part should be a file with Content-Type matching the file type (e.g., application/pdf)
Using Swagger UI:
- Access Swagger UI at http://localhost:8080/swagger-ui.html
- This provides a user-friendly interface to test your APIs correctly

These changes should resolve both the PostgreSQL permission issue and the Content-Type error you're experiencing.

145d ago

src

main

java

com

donation

orgverification

config

FileUploadConfig.java

WorkingWorking...

Working...

FileUploadConfig.java

AdminController.java

OrganizationController.java

FileStorageException.java

GlobalExceptionHandler.java

OrganizationAlreadyExistsException.java

OrganizationNotFoundException.java

OrganizationRegistrationRequest.java

OrganizationResponse.java

OrganizationStatusResponse.java

RejectionRequest.java

VerificationStatus.java

OrganizationRepository.java

OrganizationService.java

FileStorageService.java

LicenseGenerator.java

OrgVerificationApplication.java

application.properties