Are you using springboot data jpa or mybatis

9cf784b6-e7ca-4460-8143-8d0332e36770

springboot

datasource:
url: ${DATABASEURL} username: ${DBUSERNAME}
password: ${DB_PASSWORD}
driver-class-name: org.postgresql.Driver

jpa:
show-sql: true
properties:
hibernate:
format_sql: true
hibernate:
ddl-auto: update

I believe you're missing the spring key before datasource

I have it, it is working on local, it also worked before on railway until I started a new application, I forgot what I used in the variables

spring:
application:
name: Layers

datasource:
url: ${DATABASEURL} username: ${DBUSERNAME}
password: ${DB_PASSWORD}
driver-class-name: org.postgresql.Driver

jpa:
show-sql: true
properties:
hibernate:
format_sql: true
hibernate:
ddl-auto: update

please use code blocks

how

You're setting the DATABASE_URL environmental variable?

```

before and after

I see this in the connect tab

What you need to do is make an environmental variable in your Springboot app called DATABASE_URL

Assign it to the value ${{Postgres.DATABASE_URL}}

I did and this is what I have now:

DATABASE_URL="${{Postgres.DATABASE_URL}}" DB_PASSWORD="hidden" DB_USERNAME="postgres"

That's your raw variables in your Springboot service, correct?

so the URL is from the private tab and the username and password are from the public tab

No idea what that means

Ah sorry that's not going to work because JDBC

Brb

jdbc:postgresql://${{Postgres.RAILWAY_PRIVATE_DOMAIN}}:${{Postgres.PGPORT}}/${{Postgres.PGDATABASE}}

That should do the job

where do I put this

DATABASE_URL value

Replace what you have for it

Java is stupid

what about the DBUSERNAME and DBPASSWORD

let me try that now

so in URL do I put: jdbc:postgresql://${{Postgres.RAILWAYPRIVATEDOMAIN}}:${{Postgres.PGPORT}}/${{Postgres.PGDATABASE}}

or just: ${{Postgres.RAILWAYPRIVATEDOMAIN}}

the first one

the whole thing

DATABASE_URL=jdbc:postgresql://${{Postgres.RAILWAY_PRIVATE_DOMAIN}}:${{Postgres.PGPORT}}/${{Postgres.PGDATABASE}}

java.lang.RuntimeException: Driver org.postgresql.Driver claims to not accept jdbcUrl, jdbc:postgresql://:/

I think there are extra quotation, I'll remove and try again

Yeah that error shows that none of the env variables actually resolved

Your Postgres service is still called what it was up there right

mmm good question

where do I check

Screenshot your architecture page

these one?

Oh nos you have to have them in the same project

Won't work unless you do

Why do you have them in different projects?

I am not sure, let me try move it

or maybe I need to create a new one

You can't move it you'll need to make a new one

But once you do it should immediately all work

Looks like they are all in different projects; it should be in one project.

If you connect them using public URL it will cost you egress so it is efficient in one project and use internal URL.

they aren't doing that anyway

do I use public URL now? 😦

no…

DATABASE_URL="jdbc:postgresql://${{Postgres.RAILWAY_PRIVATE_DOMAIN}}:${{Postgres.PGPORT}}/${{Postgres.PGDATABASE}}" DB_PASSWORD="${{Postgres.PGPASSWORD}}" DB_USERNAME="${{Postgres.PGUSER}}" EMAIL_PASSWORD="okfaezxundjhutyf" EMAIL_USERNAME="layers.app1@gmail.com" JWT_SECRET="MyVeryStrongJWTSecretKey_987654321!@" NIXPACKS_JDK_VERSION="21" PORT="8080"

It will work, but in your case you should use one project.

Then use internal variables

As long as you moved your database over to that project you're golden

(and make sure it's still called Postgres)

Yeah the solution here, just move them in your project then it should work.

this project:

perfect

crashed 😦

what's the error this time

checking

yeah share the error logs

@Loudbook I think the user should delete this? It has secrets and email passwords.

considering it says "MyVeryStrong…" i would assume they're going to change it

2025-06-25T03:15:04.790Z WARN 1 --- [Layers] [ main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'openAIClient': Injection of autowired dependencies failed

That's just an error with your application

Are you sure there isn't more to that

Do you need to provide an open ai key perhaps

I tought I did, let me check

Looks like warning only, it would help if you share the actual error that causes to crash.

That error is going to crash the whole thing

Not sure why it says warning

Agree

I was missing that API_KEY I added it now and I am restarting

yerp

what is the best way to see love logs?

click the service, the deploymeny, and then logs?

yes but now I send a postman request and get 502

and don't see anyting in logs

What port did you give the domain

Set PORT=8080, redeploy your service, and delete the public domain and re-add it

I jave variable PORT:8080

maybe I am not using the right hostname

= or colon

Does your public domain in the server settings show it's pointing to it

And does Springboot show it bound to 8080 in deployment logs

the last thing that I see in logs is:

```2025-06-25T03:21:54.511Z DEBUG 1 --- [Layers] [ main] .m.m.a.ExceptionHandlerExceptionResolver : ControllerAdvice beans: 1 @ExceptionHandler, 0 ResponseBodyAdvice

2025-06-25T03:21:54.723Z INFO 1 --- [Layers] [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port 8080 (http) with context path '/'

2025-06-25T03:21:54.732Z INFO 1 --- [Layers] [ main] c.e.ai.chateldadt.ChatEldadTApplication : Started ChatEldadTApplication in 6.564 seconds (process running for 7.117)```

Screenshot your public domain part of settings

wait I found the domain

it's: layers-production.up.railway.app

now it's working!!!

yay

great!

I mean I get some error but it is expected…

now I have to deal with my own app

but at least it is working

thank you so much!!!!!!

I'm so happy

can I ask how do I write an SQL query in postgres?

from Java…?

no, in the railway postgres itself

I can see the tables

you'll need to use the Railway CLI

then use railway connect

ok I will read about it