I try to make an application with Spring-Data-JPA on a table in order by ASC but it gives me an error: Invalid derived query! No property asc found for type java.util.Calendar Why ? List …
Tag: java
Replace Parameters in SQL query text with XXXXX
I m writing a small utility that captures and logs SQL statements, but will have to remove sensitive data from the Query text and replace with with some dummy text (i.e:XXXXX). What is a good way to parse the SQL query in java and replace parameters value? for example: replace with Answer Using JSQLParser (V0…
How would I write SELECT TOP 25 sql query in Spring data repository
A quick question, because I am sure this is something silly. I have the following query which I can execute in NetBeans sql command window: My goal is to put put it in my ArcustRepository class: public interface ArcustRepository extends JpaRepository { However, that findBytop query doesn’t seem to work …
What is type 1,2,3 or 4 of a JDBC Driver?
To connect to a database using Java, most of us use JDBC API. We normally include driver like ojdbc14 (Intended for Java 1.4) in class path, and in program we use Class.forName to use it. Unlike …
How to use named parameter in plain sql with jooq
I’m using JOOQ with plain/raw SQL, so that means i’m not using any code generation or the fluid DSL thingy. The following code works: Now let’s say i have a query with multiple parameters like this: How do i use a named parameter with these types of queries? I’m thinking something like…
Getting a date from a form and saving into database and listing products
I’m trying to create a page which can list products which are saved in the database and then the customers can view the list of products that are available.The problem I am having is with the date in …
ORA-00928 missing SELECT keyword in Oracle
I’m using the following code to insert data. But I’m receiving an error as “ORA-00928: missing SELECT keyword” try { Class.forName(“oracle.jdbc.driver.OracleDriver”); java.sql.Connection conn = …
How to process 0000-00-00 date in jdbc MySQL query
I’m getting this exception: java.sql.SQLException: Value ‘0000-00-00’ can not be represented as java.sql.Date Originating from this code: Date internalDate = rs.getDate(idx++); Where rs is a …
Extract SQL statements from Java/SQL files
I have a huge codebase that has a lot of JAVA and .sql files. I intend to extract all the SQL statements from all these files. Here is the way I intend to achieve this – Build a regex file containing patterns like select, insert, delete, update etc that I intend to extract. Parse files line by line in c…
Oracle Sequence Transactionality
I need for a particular business scenario to set a field on an entity (not the PK) a number from a sequence (the sequence has to be a number between min and max I defined the sequence like this : …