All Questions
26 questions
1
vote
0
answers
112
views
Hibernate Exceptions not propagated to Application deployed in JBoss 7.3
Issue: The Web application uses JPA/Hibernate to communicate with the Oracle database. This application is deployed in JBoss EAP 7.3 and uses its Hibernate modules.
When an org.hibernate.exception....
- 11
1
vote
1
answer
178
views
Is there a way to disable fetching the entire value set for a column in Hibernate?
In our "Process" table there is a "Type" column. This column's valueset is defined in an enum in our code. However there are obsolete rows in this table. Meaning that there are rows where "type" is a ...
- 27
0
votes
0
answers
170
views
JDBC Commit is not reflecting in Oracle DB
My requirement is I have to commit 4Million records to Oracle DB.
For that, I have developed a Java program which starts 10 threads. It's a producer and consumer design. Producer pushes data(Range. ...
- 1,208
0
votes
1
answer
468
views
hibernate problems about configuring oracle sequence
this is the domain object:
package com.hibernate.entity;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence....
- 99
1
vote
1
answer
3k
views
sequence does not exist error in hibernate
I am working on a java application using JSF and hibernate and the database is oracle.
this is my entity class---------
@Entity
@Table(name="docUpload")
@SequenceGenerator(name="seqGen",sequenceName=...
- 75
0
votes
1
answer
861
views
HibernateException: Wrong column type after changing column from number to varchar2 in a Oracle DB
I've got a strange behaviour in Hibernate after changing a column from number to varchar2 in a Oracle Database.
Caused by: org.hibernate.HibernateException: Wrong column type in XXX for column ...
- 505
0
votes
0
answers
2k
views
Hibernate 4.2.21 ORA-00001: unique constraint
I'm working with Hibernate 4.2.21.Final and Oracle Database 12c 12.1.0.2.0 - 64bit Production, we have defined in our Jboss a JNDI for our DataSource, We have a strange problem in one of our Tables - ...
- 439
1
vote
0
answers
446
views
Cannot merge a new element on database, parent key not found
I have been the whole day with one problem and finally I have no other choice than asking here. First of all I must clearify that I am still a junior developer, so expect weird things in my code :P
I ...
- 539
0
votes
0
answers
3k
views
BigDecimal JPA precision lost issue
In java application I use:
Oracle database 11g
JPA with standard jEE implementation as
persistence layer (open jpa)
Wildfly application server
In JPA entity I defined BigDecimal numeric value:
@...
- 617
0
votes
1
answer
2k
views
Querying CLOB column with hibernate criteria
I have a table like
Table Name: ITEMS
Columns :
Name Type
ID Number
Status varchar2
data clob
I have the hibernate mapping like below
@Entity
@Table(name="ITEMS",...
- 2,475
2
votes
2
answers
1k
views
How can I handle/recover a DB Integrity constraint violation exceptions in hibernate?
I'm developing a big web application that uses JSF and hibernate as its ORM.
My hibernate sessions are long (the user can do big amount of modifications on the screen and the changes will only be ...
- 21
2
votes
2
answers
290
views
Should my dev team use Hibernate? [closed]
Intro
I'm the newest guy on my development team. We primarily do Java web development and work with Oracle databases, but on rare occasion we work with other RDMSs. In the interest of expanding my ...
- 498
0
votes
0
answers
195
views
Data Entry stopped by Hibernate Constraint Violation exception
I have an application developed in jsf 1.2 , rich faces 3. Oracle 11gR2 is holding the schema. Deployed on Websphere 7. Application is centrally deployed and several users access it across a WAN. The ...
- 757
4
votes
2
answers
6k
views
how to insert a huge file to BLOB (Oracle) without loading the complete file to memory?
We have a large file stored on our temporary file system, what I would be needing is to read that huge file (probably couple or few gigs) using BufferedInputStream as below
InputStream is = is = new ...
- 541
1
vote
1
answer
1k
views
in hibernate database does not response
I have web application using hibernate for accessing database.
I have an update method in DAO class, when I run this method, I get no error in console but database doesn't response, also after running ...
- 1,575
1
vote
0
answers
1k
views
Junk characters getting inserted into DB Column from Java Application
I am having two different tables.I am fetching the value from a column of Table1 and then inserting it into a Column of Table2.No processing is done for that data in between, before inserting into ...
- 1,094
0
votes
1
answer
2k
views
How to execute Oracle Store procedure and get resultset from ref_cursor in hibernate
I have a oracle Store procedure where is two in parameter varchar2 type
one ref_cursor out parameter and one number out parameter how to call
the procedure using hibernate without obtain JDBC ...
- 693
0
votes
1
answer
240
views
Best pratice to save amount range values in db
I have one account table in that table I need to save the amount range
I have one drop down that has the values like $25k-$30k, $30k-$35k it needs to increase by 5 up to $250k.
I have planed to have ...
- 3,373
1
vote
1
answer
5k
views
Convert java.lang.String to java.sql.Blob using Struts2 and Hibernate Framework
Is there any way convert the java.lang.String to java.sql.Blob ?
please help me ,this is one of my project requirements Ineed to store user password as Blob format into the Database(oracle10g)
...
- 368
4
votes
2
answers
3k
views
Setting context in a JPA connection — is this safe?
I need to set some context before every database operation (I have tried using Oracle's package-level variables, but due to some issues with package recompilation, I will experiment with DBMS_SESSION ...
- 5,179
0
votes
1
answer
5k
views
oracle 11g and integration of hibernate spring and jsf
i am using jsf 2,hibernate 4.1.4,spring 3.1,oracle 11g and maven 3.
but it can not connect to oracle and has error. i downloaded the latest version ojdbc6.
applicationContext.xml
<?xml version="1....
- 1,295
2
votes
1
answer
11k
views
Invalid identifier on a JPA query using Hibernate EntityManager
I've been trying and googling whole day for solution and still have no luck.
I tried to wire up Spring 3.0.5 and JPA 2.0 using hibernate provider. I was testing a simple select query for my entity ...
- 21
-1
votes
1
answer
4k
views
passing a Cursor as a parameter using hibernate query object to a stored procedure
I have a stored procedure which takes a cursor as parameter.
I have a namedquery defined in hibernate mappings to call the stored procedure...
I need to make a call it from a DAO using ...
1
vote
1
answer
748
views
switch from sybase to oracle - considerations?
I am in charge of a large J2EE application that utilizes Hibernate extensively at the DAO layer. I've recently been tasked to consider the repercussions and feasibility of switching from Sybase ASE 15 ...
- 11
27
votes
4
answers
118k
views
Hibernate Criteria for Dates
In oracle I have dates in format
17-April-2011 19:20:23.707000000
I would like to retrieve all orders for 17-04-2011.
SimpleDateFormat formatter = new SimpleDateFormat("dd-MM-YYYY");
String ...
- 18.6k
4
votes
4
answers
13k
views
Hibernate Mapping Two Tables to One Class
I need to map two tables to a single class, having trouble figuring this out. One table is ROOMS, the other is TRAINERS.
The ROOMS table:
OOC_UNIT_ID NUMBER(6,0)
OOC_START_DT ...
- 2,596