r/programming • • Sep 15 '20

Java 15 released!

https://jdk.java.net/15/
214 Upvotes

130 comments sorted by

View all comments

50

u/[deleted] Sep 15 '20

I don't use it anymore, but boy am I happy because it finally got multiline strings (text blocks). Writing a raw SQL will be so much easier and readable.

-5

u/x6060x Sep 15 '20

I'm not sure if you are joking. Especially without the /s tag.

1

u/Prod_Is_For_Testing Sep 16 '20

Very useful for database generation and automation.

-1

u/x6060x Sep 16 '20

When I hear "raw sql query" the first question that pops in my mind is sql injection. How do you handle it? I am not saying there shouldn't be sql in the code, I was surprised of the 'raw" part

7

u/[deleted] Sep 16 '20

There are two options, the sql query is static and doesn't change. Or it's a prepared statement and they use bind parameters correctly. Either way, I'm not sure why raw sql immediately means sql injection to you.

6

u/nutrecht Sep 16 '20

He means "SELECT * FROM foo WHERE id =?"

That's raw SQL. But still uses prepared statement. SQL injection was never really a 'thing' in the Java world (unless you really don't know about it obviously) because even the earliest versions had prepared statements.

0

u/[deleted] Sep 16 '20

[deleted]

1

u/josenunocardoso Sep 16 '20

which makes his comment correct?

3

u/Prod_Is_For_Testing Sep 16 '20

The other guy made good points: static queries and argument bindings.

There’s another that many people don’t consider depending on their line of work. Sql injection doesn’t always matter. If you’re making a web facing user portal, then yes it matters. If you’re making a dev tool for sys admins, it doesn’t because they already have the rights to nuke a DB