I am doing a service that gets data from a source and fetches them into my Database by using JPA. The id is generated by using sequence. I have created the sequence on my DB by using this command: However, I don’t know how to create the sequence directly from my code. Can anyone please help me to figure…
Tag: oracle
Insert Null Struct using EclipseLink JPA
I have an Oracle table with an SDO_GEOMETRY column and I am trying to use EclipseLink JPA2 2.6.1 for persistence. My entity class uses a JTS Geometry for geometry objects and I have written a AttributeConverter to convert from a SDO_GEOMETRY to a JTS Geometry. This works well and I can read and write the geom…
Id of entity is different after hibernate save from oracle database with sequence autogeneration id
Entity with id autogenerated from oracle trigger sequence. Service DAO And When I call service’s saveOrUpdate and then try to reach id of entity I get different value than persisted in database. Values on database with autogeneration all is ok. Any suggestions? prints: 4150 but saved id in database is: …
How to avoid two different threads read the same rows from DB (Hibernate and Oracle 10g)
Let’s suppose I got two different threads, T1 and T2, accessing concurrently the same database and fetching data from the same table. Now on thread startup I need to fetch data from the table and store the rows into a collection, that I will then use to perform some work elsewhere. I don’t want th…
Fetching Oracle DB LONG type through jdbc works very slow
This happens only when the statement return LONG column. Even if i don’t do anything with it such like rs.getString, just execute. sql1: That was: 7593 ms sql2: That was: 530 ms As you can see it’s not about volume of data. When i use OracleConnection:OracleStatement:OracleCachedResultSet result i…
Why does Hibernate throw org.hibernate.exception.LockAcquisitionException?
I have this method : Mapping : Person.hbm.xml Cars.hbm.xml This method works well for a single thread, and on multiple threads, gives me an error: AOP Transaction : NB : When i add Thread.sleep(5000) after update, it is ok. But this solution is not clean. Answer I have Cars -> (1 -n) places. And i have a f…
MyBatis Batch Insert/Update For Oracle
I’ve recently started learning to use myBatis.I am now facing such a scenario, I need to constantly fetch a new list of Objects through WebService, then for this list, I need to insert/update each object into the oracle DB table through myBatis. The tricky part is, I cannot simply do a batch insert ever…
What is the difference between OCI and THIN driver connection with data source connection between java and oracle XE?
I’m writing the below codes for connection between the java and Oracle 10g XE using 3 way(OCI, THIN and data source), the code is running successfully but don’t know difference between the THIN and OCI with data source connection. 1- 2- 3- Answer Oracle provides four types of drivers for their dat…
JDBC ResultSet: I need a getDateTime, but there is only getDate and getTimeStamp
I would like to get the DATETIME column from an Oracle DB Table with JDBC. Here is my code: I have to identify the column type first. The field I am interested in is recognized as a Types.DATE, but it is really a DATETIME in the DB since it has this format: “07.05.2009 13:49:32” getDate truncates …
Invalid operation for read only resultset: updateString
Following is my code(Re-constructed) which select & update STATUS field depending upon the conditions. (Using Servlets, Oracle as Backend and JDBC driver) I am getting the error while updating: Any suggestions will be appreciated. Update 1: The same code was working when select statement was selecting dat…