Is this using the postgresql pod?

Yes

Have you tried using regular jvm jdbc to see if there's a difference?

No.

It might be best to to try this for debugging since the postgres pod might be a bit behind on the version of next.jdbc

But then I can't use Babashka for it?

I wouldn't know why a raw sql query might have capitalization problems, but it would be interesting to see if the JVM version also has this problem

How was the table/column created?

can you show the DDL?

CREATE TABLE table (
  "id" serial,
  "columValue" text NOT NULL
) ;

Ah ha!

It is part of a different service.

Columns that are created using double quotes must be double quoted for all their life...

Quoting an identifier also makes it case-sensitive, whereas unquoted names are always folded to lower case. For example, the identifiers FOO, foo, and "foo" are considered the same by PostgreSQL, but "Foo" and "FOO" are different from these three and each other. (The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard, which says that unquoted names should be folded to upper case. Thus, foo should be equivalent to "FOO" not "foo" according to the standard. If you want to write portable applications you are advised to always quote a particular name or never quote it.)

Yes your right. Thanks for the explanation

You're most welcome! 🙂

@U11EL3P9U Thanks!

np 👍

When I run bb print-deps --format classpath I get this:

Error: Could not find or load main class clojure.main
Caused by: java.lang.ClassNotFoundException: clojure.main
Exception in thread "main" java.io.FileNotFoundException: /Users/john/.clojure/.cpcache/EC75370BCEABA1C0496F6D9CBE1EC430.cp (No such file or directory)

I’ve tried deleting my ~/.clojure/.cpcache but it doesn’t help.

do you happen to have a .cpcache in the dir youre in as well?

No.

And I get a similar error regardless of the directory, although sometimes the specific missing filename is different.

@U0DTSCAUU Just for debugging, can you try:

bb --force print-deps --format classpath

Produces the same error with --force

and what about just bb?

bb and bb print-deps both work fine.

aha, so it's the --format classpath specifically

which bb version

1.0.168

what happens when you do:

bb clojure -Spath -Sdeps "$(bb print-deps)" 

(I expect the same error)

Yep

Well, different missing filename, but still FileNotFoundException

this is interesting, now perhaps you can bisect the contents of bb print-deps until you have something that works and doesn't work

does just bb clojure -Spath work?

Same error

did you erase your .m2 directory or so?

or perhaps some file permission thing?

No, I haven’t done anything manually to my .m2

Can you try:

bash <(curl -s ) --dir /tmp --dev-build

That works fine.

and with print-deps classpath?

Yep, that works. Interestingly, bb clojure -Spath now works (my homebrew-installed bb, not the one in tmp), so something has changed, but bb print-deps --format classpath is still broken.

don't know, without an exact copy of your hard disk... but I'll release a new bb this week or so, so maybe you can use the dev build until then

you could try to debug this with a local checkout of deps.clj

clojure -M -m borkdude.deps -Spath -Sdeps "$(bb print-deps)"

~/ws/deps.clj [master]
λ clojure -M -m borkdude.deps -Spath -Sdeps "$(bb print-deps)"
Error: Could not find or load main class clojure.main
Caused by: java.lang.ClassNotFoundException: clojure.main
src:resources:/Users/john/.m2/repository/org/clojure/clojure/1.11.1/clojure-1.11.1.jar:/Users/john/.m2/repository/org/clojure/core.specs.alpha/0.2.62/core.specs.alpha-0.2.62.jar:/Users/john/.m2/repository/org/clojure/spec.alpha/0.3.218/spec.alpha-0.3.218.jar

I think something’s wrong with my Clojure install.

Maybe you can wipe /Users/john/.m2/repository/org/clojure/clojure/1.11.1

Although this works, using same classpath as above:

λ java -cp /Users/john/.m2/repository/org/clojure/clojure/1.11.1/clojure-1.11.1.jar:/Users/john/.m2/repository/org/clojure/core.specs.alpha/0.2.62/core.specs.alpha-0.2.62.jar:/Users/john/.m2/repository/org/clojure/spec.alpha/0.3.218/spec.alpha-0.3.218.jar clojure.main
Clojure 1.11.1
user=>

OK, I’ll try that…

I’ve wiped 1.11.1 from my .m2 and re-run clojure -M -m borkdude.deps -Spath -Sdeps "$(bb print-deps)". On the first run I see it downloading the new Clojure JARs but the error still occurs, even on subsequent runs.

ok, so if you check out deps.clj locally you could try inserting some printlns, etc to check what's going on

how did you install clojure? And do you have a clj program?

this should not be very relevant to bb btw

I installed Clojure via homebrew (btw macos Ventura on MBA M2)

did you use the clojure tap rather than the homebrew package?

I seem to recall seeing the error after I upgraded to Clojure 1.11.1.1208 from some previous version of 1.11.1.

…although it didn’t really bite me until now

I’m not sure re “tap” vs “homebrew package”. Does this answer the question?

λ brew info clojure
==> clojure: stable 1.11.1.1208 (bottled)

that seems legit

Another data point: bb print-deps had stopped working. It was throwing ClassNotFoundException for clojure.main, which is why clojure -M -m borkdude.deps -Spath -Sdeps "$(bb print-deps)". I changed bb to /tmp/bb , which worked, but it also fixed bb print-deps. The above clojure -M… command now works.

@U04V15CAJ it appears the upgrade to 1.0.169 has somehow fixed my problem. Thanks for your help!