All Questions
64 questions
1
vote
1
answer
219
views
Hibernate Exception Failed to load class "org.slf4j.impl.StaticLoggerBinder"
I want to execute an update query in my oracle database. But I'm getting the following error:
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-...
- 31
0
votes
2
answers
568
views
Declare variables and use them in query oracle
I'm in the middle of data migration, converting Sybase query in oracle 11g
I've stuck on this thing from past 2 days
@Declare @myDate Datetime
Select @myDate = workingDate from MyTable
Then there are ...
- 183
0
votes
1
answer
2k
views
ORA-00904: "BOOKORDERS": invalid identifier in Hibernate
I have a problem about insert order information into the oracle database.
When I call createOrder funtion in JUnit class, it throws an error as shown below.
Hibernate: select ORDERS_SEQ.nextval from ...
4
votes
3
answers
7k
views
Oracle select sequence.nextval from dual sounds too slow
A while ago I had a database performance problem for inserting/updating several million records using jdbc. To increase performance I changed the code to use batch. Then I decided to monitor the code ...
- 579
0
votes
0
answers
100
views
open an invalidate DB connection
i have a java function that must be executed every day at midnight, it is like a database update.
problem is i get an error
Exception d'E/S: Connection reset by peer: socket write error; nested ...
- 146
6
votes
2
answers
5k
views
JPA and 1000 ID use in Oracle IN Operator
I use NamedNativeQuery for delete rows, and it's somthing like this:
DELETE from FAKTOR
where ID IN (
select fa.ID
from FAKTOR fa
left join FAKTOR_REASON fars
on fa.FARS_ID = fars....
- 676
2
votes
2
answers
271
views
Error in generating Hibernate configuration with ColdFusion 11 / Oracle 12c
We've just moved to cf11 with oracle 12c.
Some of our Hibernate ORM queries are failing.
One of the errors is
java.io.IOException: Permission denied
"coldfusion.orm.hibernate....
- 83
-2
votes
1
answer
2k
views
Oracle exception
In my java application when I read a record from Oracle database I have this Exception :
SQL Error: 17002, SQLState: 08006
Caused by: java.sql.SQLRecoverableException: Errore di I/O: Checksum fail
...
- 47
1
vote
1
answer
967
views
Update query using JPA Query Annotation to Oracle 11g Hangs
I am trying to update a simple row using Query Annotation with JPA to Oracle 11g
This is my code:
@Transactional()
@Modifying
@Query(value="UPDATE Irregularities SET IRREST_ID = 0 WHERE IRREGS_ID = ...
0
votes
2
answers
480
views
ClassCastException When Casting NewProxyConnection To C3P0ProxyConnection
In our application, we have c3p0 pooled connections configured with hibernate. To call a stored procedure with an input of array type
I have to get the underlying connection by removing all ...
- 663
1
vote
2
answers
2k
views
Add Oracle leading hint to HQL query
i want to add Leading hint to my hql query but , this hints will be like this leading(a alias name), in hibernate i dont know what the alias will be in sql , how can i do this ?
String hql="select ...
0
votes
0
answers
2k
views
Listener refused the connection with the following error: ORA-12505
I am having a problem while configuring a hibernate application. Please could you help me with this. I searched a whole lot of forums but could not find the solution. I know this question has been ...
- 525
1
vote
1
answer
5k
views
Caching properties using Hikaricp in Oracle
I need to know what are the connection caching properties, im using Oracle 11g Enterprise Edition and Express Edition, Hibernate and HikariCP.
I put these properties in my hibernate.cfg but i get an ...
1
vote
2
answers
539
views
Copy new records from one database to another
I have local and remote database.
The local database is a replica of remote database.
I have to insert new records from remote database into local database.
There are 14 tables in remote database, so ...
- 560
0
votes
2
answers
5k
views
java.lang.UnsupportedOperationException: org.hibernate.dialect.Oracle10gDialect does not support resultsets via stored procedures
how to solve the following error I am using JPA 2.1 widfly Application Server 8.0 and Oracle 11g bd
java.lang.UnsupportedOperationException: org.hibernate.dialect.Oracle10gDialect does not support ...
0
votes
1
answer
286
views
Oracle 11g What is recommended charset for international appliaction
What NLS_NCHAR_CHARACTERSET and NLS_CHARACTERSET should I use? I use VARCHAR2 to store text. I want to support Chinese and other characters. Application will be writen in Java and Hibernate. Should I ...
- 3,050
5
votes
1
answer
1k
views
ORA-12705 and ORA-00604 error in production
We have the following ORA error where it prints the error message in different language. This comes very rarely and we will have to restart our application servers.
In my analysis I could figured out ...
- 51
0
votes
1
answer
5k
views
Hibernate @OneToOne References an Unknown Entity Error
I'm having a hard time finding the root cause of an error where my @OneToOne mapping isn't working and is returning a "references an unknown entity" exception.
To start with I ensured that both ...
- 124
2
votes
1
answer
1k
views
Hibernate: SQLGrammarException: Could not execute JDBC batch update AND BatchUpdateException: ORA-00942: table or view does not exist
I follow this tutorial in mkyong.com: http://www.mkyong.com/hibernate/maven-3-hibernate-3-6-oracle-11g-example-xml-mapping/
But when I run file App.java, it show the following log:
Maven + Hibernate ...
0
votes
1
answer
51
views
Need to pull backward records while querying records between date range
Below is the sample table
id date rating
-----------------------
1 15-11-2015 A
1 18-11-2015 A
1 05-12-2015 B
2 05-11-2015 A
2 21-11-2015 A
2 05-12-2015 A
3 ...
- 21
0
votes
1
answer
56
views
How does Oracle 11g Interpreter a Subselect/Query generated by Hibernate and Process it?
I am using hibernate 4.2.18 and Oracle 11g
I have the following query, those tables have indexes, including indexes in the join columns and also, index in the index_column:
/*outer query generated ...
- 944
0
votes
1
answer
454
views
Hibernate 4.2.21 GenerationType.SEQUENCE
I'm working with Hibernate 4.2.21 Final, to generate the ID I use : strategy=GenerationType.SEQUENCE
@Id
@SequenceGenerator(name = "ApplicationSequence", sequenceName =
"application_seq", ...
- 439
1
vote
1
answer
2k
views
French Characters getting converted into Special characters while saving in Database
Saving the text “février.xlsx” in DB is getting saved as “février.xlsx” when saved via J2EE application.
DB Version : Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
NLS_CHARACTERSET - ...
- 1,094
1
vote
1
answer
731
views
Integrating oracle 11g with Grails and Hibernate
I have created a simple grails 3 application. I am trying to connect it to an Oracle database in the datasource configuration.
When I run
SELECT * FROM V$VERSION
in sql developer, the following ...
- 2,270
0
votes
2
answers
1k
views
Wrong results in query with ORDER BY and ROWNUM
I have a problem with a query generated by an ORM framework to limit and order the results in the Oracle Database 11.2.0.1.0 64bit Production. The generated select looks like this:
SELECT *
FROM
...
- 512
1
vote
1
answer
2k
views
How do I optimize batch INSERTs for Oracle 11g and Hibernate?
I have an application that does quite a bit of batch inserts. I'd like to optimize the application to do these as fast as possible.
I see several Hibernate Settings that I think have to do with batch ...
- 44.9k
4
votes
2
answers
2k
views
Inconsistent string length definition between Java String.substring() and Oracle 11g column VARCHAR2 size
I set up my database with a table like this:
CREATE TABLE t_audit_log
(
description VARCHAR2 (2500)
);
In the Java app which uses it, I employ Hibernate to map a data class onto it and to make ...
- 5,425
0
votes
2
answers
4k
views
using JPA how to set parameter in native query when I have PIVOT
q = createQuery( " select * from ( ( SELECT * FROM ( SELECT dt.route_id , dt.amount , dc.card_type_id FROM DDRC_TRANS\n" +
"dt , DDRC_CARD dc WHERE ( dt.card_id = dc.id AND dt....
- 5,623
5
votes
2
answers
134
views
Change PrimaryKey type in model classes of Oracle db, generated with hibernate
I have a database on Oracle 11 XE and all my tables have primary keys that are NUMERIC(22,0). I have generated model classes with Hibernate tools in Eclipse. Unfortunately, all NUMERIC fields have ...
- 15.8k
1
vote
2
answers
604
views
Using existing Database Sequence and creating custom generator
I have created a sequence in my Database as follows:
CREATE SEQUENCE "SCOTT"."ATA_SEQ_USERID"
MINVALUE 1 MAXVALUE 9999999999999999999999999999
INCREMENT BY 1 START WITH 1000 CACHE 20 NOORDER ...
- 306
2
votes
2
answers
2k
views
Oracle DUAL table returns "no rows selected"
I got this query:
insert into biller_onboarding_tbl values(BILLER_ONBOARDING_ID_SEQ.NEXTVAL,'1','blah','j', '1','dsad','das','dasd','dsad','dasd','dasd','dsadsa')
1 rows inserted.
select * from ...
- 21
0
votes
2
answers
546
views
ORA-01652 - Query doen't work with hibernate but it works fine in SQL client
I execute a SQL query with hibernate and the application give the error:
ORA-01652: unable to extend temp segment
The TABLE SPACE has 4 GB.
The strange thing is that the query from the application ...
- 227
0
votes
1
answer
203
views
When will setFetchSize() and setMaxResults() actually filter the result set with Oracle 11g?
If I have a table called ACCOUNTS that has one million records and I issue the following Criteria query, when does the filtering of the number of records returned take place? I'm interested in whether ...
- 466
0
votes
1
answer
3k
views
java.sql.SQLException: Cannot perform fetch on a PLSQL statement: next
I am trying to execute stored procedure in oracle using hibernate.When I call procedure from hibernate the process get called but after that it showing me exception that
ERROR: Cannot perform fetch ...
- 3,414
0
votes
1
answer
44
views
simple join syntax not properly working
I'd like to show the number of records in the history table grouped by name of service
service(code,name)
history(id, code,....)
Please note that there is no relationship between the two table ...
- 63
0
votes
0
answers
102
views
Operations on certain tables won't finish
We have a table TRANSMISSIONS(ID, NAME) which behaves funny in the following ways:
The statement to add a foreign key in another table referencing TRANSMISSIONS.ID won't finish
The statement to add a ...
- 11
0
votes
1
answer
2k
views
Cannot create connection to Oracle 11g with Spring 4 and Hibernate 4
My application is using Spring 4, Hibernate 4, Java 1.7. This is a desktop application rather than a web application, so there is no server involved. I'm trying to create a connection to the ...
- 676
1
vote
3
answers
4k
views
Oracle ORA-00937: not a single-group group function in Subquery
I am working on Hibernate query. This query works fine with MySQL but fails in Oracle and postgreSQL.
SELECT MIN(t.startTime) AS StartTime,
MAX(t.endTime) AS EndTime,
(SELECT SUM(t2.occurances) from ...
- 119
4
votes
0
answers
2k
views
How to set index name on primary key by using @Index JPA annotation?
My tools -> Java 8, JPA 2.1 and Hibernate 4. Im using just JPA2.1 annotations.
The code in the dock ->
@Entity
@Table(indexes = { @Index(name = INDEX_PK, columnList = ID) })
public class Invoice {
...
- 1,627
-1
votes
1
answer
19k
views
Hibernate 4.3.6 Configuration with Oracle 11g
I am trying to configure Hibernate 4.3.6 with Oracle 11g, but i am not able to configure...I am
getting Null Pointer Exception while Creating the Session...i am putting all the configuration
...
- 1,284
2
votes
3
answers
2k
views
Oracle does not use function-based index for regex_replace with bind variables
I have a table in my Oracle 11g database with non formatted text in a column, which shall be displayed as it was entered. Anyway, a user shall be able to search for that text in any possible format (...
- 2,605
0
votes
2
answers
514
views
ORA-00001: unique constraint: 1node vs 3node
We're using ORACLE 11.2.0.3.0, configured as 3 node RAC.
In our application we have hibernate over UCP and OJDBC with compatible version to RAC. Hibernate use some sequence to get ID for any record ...
- 75
0
votes
1
answer
1k
views
getting Hibernate error when using DBMS_RANDOM.value
I would like to achieve same result as the below query using Hibernate SQL, i.e., I would like to get two random records from the table whose ID is not equal to 300. I am using Hibernate 4.1 and ...
- 21
0
votes
2
answers
557
views
What’s wrong with my Hibernate configuration?
I´ve an application with Spring + JSF + PrimeFaces + Hibernate + MySQL, so I was told that I needed to migrate the database from MySQL to Oracle, and I did it.
So when I was testing the app I found ...
- 1,641
0
votes
2
answers
3k
views
SQLGrammarException with Hibernate and Oracle11g
Two problems -
If I query an entity, I get...
ERROR: ORA-00933: SQL command not properly ended
Nov 11, 2013 8:47:36 PM org.hibernate.event.internal.DefaultLoadEventListener onLoad
INFO: HHH000327: ...
- 3,518
1
vote
0
answers
152
views
i18n-friendly enum sorting in Oracle 11g
I have many (30+) Java enums which are mapped to integer ids in the database. I would like to be able to sort by these without modifying many queries, and be able to index on the sort order.
Example -...
- 21
0
votes
2
answers
115
views
Named Parameter with AND/OR in CONTAINS query is not working
I am using Oracle Text for searching in my web application. I have configured Oracle Text by creating Data Store and Index.
This is my query
select * from PROFILE where CONTAINS(FIRST_NAME,:...
3
votes
1
answer
14k
views
Oracle 11g + Hibernate -> ORA-01461: can bind a LONG value only for insert into a LONG column
There is an error in the log that says:
ORA-01461: can bind a LONG value only for insert into a LONG column
no other useful info really. I tried to follow up on the code, google-d the problem and ...
- 155
1
vote
0
answers
414
views
JPA Cast is not working in Oracle
I have a table person{id,personName,birthDate}. In the table I have to get all the person details by their birthDate with out comparing its time. I have the following query
Query q = entitymanager....
- 1,072
64
votes
3
answers
84k
views
Using the DISTINCT keyword causes this error: not a SELECTed expression
I have a query that looks something like this:
SELECT DISTINCT share.rooms
FROM Shares share
left join share.rooms.buildingAdditions.buildings.buildingInfoses as bi
... //where clause omitted
ORDER ...
- 845