Stack Overflow
Stack Overflow

Questions tagged [sql2o]

Sql2o is a small Java framework that makes it easy to execute SQL statements on your JDBC compliant database from Java.

About

Sql2o is a small Java library, with the purpose of making database interaction easy. When fetching data from the database, the ResultSet will automatically be filled into you POJO objects, kind of like an ORM, but without the SQL generation capabilities.

Links

33 questions
0
votes
2 answers

Removing row in MySQL DB with java

I'm trying to remove a row based on the id but i keep getting a NullPointerException. My code: public void removePatientsFromDatabase(int id) { String removeSql = "DELETE FROM patienten WHERE idPatient id = idn"; try (Connection con =…
Skupaj
  • 83
  • 9
0
votes
1 answer

PSQLException: ERROR: relation "folder" does not exist

I am using Java, Weblogic, postgressql, and sql2o. I am selecting from a table named folder. select * from folder works fine in pgadmin, however, every variation I try from Java gives me the following exception: Caused by:…
TheCatWhisperer
  • 901
  • 2
  • 12
  • 28
0
votes
2 answers

How do I use createQuery() Method to create JDBC Connection, using sql2o?

The createQuery() method is wanting a cast to a Connection object, but seems that this method would work on a SQL2o object since it is in the package.... I am using sql2o to create my database connection; however, I do not understand why the use of…
dangerouslyCoding
  • 23
  • 9
1 2
3