Runing the JAR file hitting postgresql error

I am following this https://developer.nearbyshops.org/installation/installation-guide.html - to install it on latest ubuntu 18 - however i am getting this error - Not sure whats going on with this.
ramadocker@ramakrishp-XPS-15-9560:~/nearbyshop$ java -jar nearbyshops-api-latest.jar
Dec 19, 2019 4:08:11 PM org.apache.commons.beanutils.FluentPropertyBeanIntrospector introspect
INFO: Error when creating PropertyDescriptor for public final void org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)! Ignoring this property.
Printing API Configuration :
Base URI : http://localhost:5436
Postgres Connection URL : jdbc:postgresql://localhost:5432/nearbyshop
SMTP URL : null
SMTP PORT : 1234
SMTP USERNAME : null
SMTP PASSWORD : null
Email Sender Name : null
Email Address : null
Postgres Username : rama
Postgres Password : rama
MSG91_KEY : 123456789
REFERRAL CREDIT FOR DRIVER REGISTRATION : 10
REFERRAL CREDIT FOR END USER REGISTRATION : 11
Joining Credit For End-User : 13
Joining Credit For Shop-Owner : 10
Token Duration Minutes : 1440
Email Verification Code Expiry Minutes : 10
Phone OTP Expiry Minutes : 10
Password Reset Code Expiry Minutes : 10
MAX LIMIT : 100
Tables Created … !
Admin Username : null | Admin Password : null
SLF4J: Failed to load class “org.slf4j.impl.StaticLoggerBinder”.
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
Checked User Role : 1
org.postgresql.util.PSQLException: ERROR: null value in column “password” violates not-null constraint
Detail: Failing row contains (4, null, null, null, 2019-12-19 16:08:12.148934+00, null, null, null, null, null, 1, t, null, null, 2019-12-19 16:08:12.148934+00, 2019-12-19 16:08:12.148934+00, null, null, 0, 0, 0, null, f, f).
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2427)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2169)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:132)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
at org.nearbyshops.DAORoles.DAOUserSignUp.createAdmin(DAOUserSignUp.java:1692)
at org.nearbyshops.Main.createTables(Main.java:200)
at org.nearbyshops.Main.main(Main.java:80)
Base URL : http://localhost:5436

Thanks in Advance.

hi @ramakrishp … Welcome to the forum !

Thank you for your feedback !

It is showing you an error that admin password field is null ! You must put some value in admin username and password field !

1 Like