All Questions
28 questions
0
votes
1
answer
420
views
Calling Oracle stored procedure from local with native query working fine but when deploy to QA , stored procedure is not found
I am calling a stored procedure in a local environment like
this.em.createNativeQuery("BEGIN DBO.storedProcedurePersonal(); END;").executeUpdate();
And it's working fine totally, Now I have ...
- 111
0
votes
0
answers
152
views
Hibernate session.flush throws java.lang.StackOverflowError
I am using Hibernate 4.3.8.
Oracle Release 12.1.0.2.0 .
I have two entity name as Child and Parent Entity.
They are basically joined entity.
We are using Hibernate batching property for performance ...
- 168
1
vote
1
answer
1k
views
@Transactional rollback session.save() on exception
I've been testing rollbacks with the @Transactional annotation. If an unchecked exception is thrown, session operations should be rolled back.
I am using org.hibernate.dialect.Oracle12cDialect.
I have ...
- 93
1
vote
1
answer
5k
views
JPA generated SQL with "fetch first ? rows only" fails with ORA-00933 in Oracle 11g
In a Spring Boot 2.0 project, I have a JpaRepository object with query methods. One query method returns a paginated resultset.
Page<Model> ...
- 2,845
0
votes
0
answers
324
views
How I can migrate to Oracle 12c If I am using Hibernate 3.3 and spring-orm i.e spring-hibernate bootstrapping?
We want to change our database to Oracle 12c 12.2.0.1 from Sybase.
We are currently using Hibernate 3.3 with Spring 4.3.22, We use spring hibernate bootstrapping mode to connect to database i.e ...
0
votes
1
answer
566
views
Can Hibernate Oracle12c dialect used hibernate 4.3
I see that Oracle12c dialect is available only for hibernate 5.
https://docs.jboss.org/hibernate/orm/5.0/javadocs/org/hibernate/dialect/Oracle12cDialect.html
Sadly I can't upgrade the hibernate from ...
- 5,188
0
votes
3
answers
4k
views
Exception in thread "main" javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
I am using hibernate 5 with orcale 12c and java 9
When i execute this code error occur hibernate could not execute statement
I wrote easy program at Hibernate and caught bunch of exception .
I ...
- 41
1
vote
1
answer
674
views
Getting 'Exception in thread "main" java.lang.IllegalArgumentException: Unknown entity: <entityClass>'
I have created a simple hibernate application and getting the above-mentioned exception while running(I'm using hibernate 5.4.0.Final version). Everything works fine If I use version 4.3.5.Final but ...
- 409
1
vote
1
answer
177
views
Connect to a database dynamically in hibernate
So I have multiple pluggable databases (PDBs) and I want to connect to any one of them dynamically using Hibernate. How do I achieve such functionality?
To connect to PDB1 (and likewise for other ...
- 197
1
vote
1
answer
302
views
Deployment on Wildfly: ClassNotFoundException: Oracle12cDialect
I am having a problem. I am trying to deploy an application on a WildFly server. While trying to do that, I get an error like this:
java.lang.ClassNotFoundException: org.hibernate.dialect....
- 11
1
vote
2
answers
1k
views
How to create a new oracle database with hibernate
I am new to hibernate and I am following a tutorial of hibernate within Java EE application, here is my persistence.xml file:
<persistence xmlns="http://xmlns.jcp.org/xml/ns/persistence"
...
- 2,659
2
votes
1
answer
1k
views
Hibernate : How to prevent SQL injection when the collection elements needs to check with `like` operator?
I am having a query something like this.
StringBuilder sbQry = new StringBuilder();
sbQry.append("select * from tableName where 1=1");
if(!myCollection.isEmpty()){
sbQry.append(" and (");
...
- 1,225
3
votes
1
answer
5k
views
found [nvarchar2 (Types#OTHER)], but expecting [varchar2(255 char) (Types#VARCHAR)]
I am using Oracle database 12c, Hibernate 5.
DDL
CREATE TABLE AUTHORITIES
(
AUTHORITY NVARCHAR2(64) NOT NULL
, USERNAME NVARCHAR2(64)
, CONSTRAINT AUTHORITIES_PK PRIMARY KEY
(
AUTHORITY
...
- 52.9k
1
vote
2
answers
2k
views
hibernate-spatial on oracle12c - sdo_geometry objects become empty on em.merge
there is a table containing a column of type SDO_GEOMETRY representing some points. Later a spatial query like 'show all other points within distance x' shall be executed.
After pumping some data via ...
- 1,363
3
votes
0
answers
3k
views
SQL Error: 17410, SQLState: 08000 with Oracle 12c
I am facing critical issue with Oracle 12c [12.1.0.2.0] from Java application.
It's mainly coming when multiple threads work on table from java application and update row having JSON CLOB field.
...
