ora « Oracle « JPA Q&A





1. Hibernate ORA-01747    forum.hibernate.org

I think that one reason is that the behavior of some databases is different if the names are quoted and if they are not. For example, a database may decide to convert all unquoted names to upper or lower case, which may mean that select * from some_table and select * from "some_table" not are equivalent. It can really be a ...

2. Still getting ORA-02396. Please advice.    forum.hibernate.org

Newbie Joined: Wed Nov 25, 2009 11:35 am Posts: 17 Hi, could anybody advice why doesn't c3p0 handle ORA-02396 silently ? I'm very new to c3p0. I thought it has to handle ORA-02396 (exceeded maximum idle time, please connect again) but instead i'm getting: Code: Caused by: java.sql.SQLException: ORA-02396: exceeded maximum idle time, please connect again ...

3. ORA-01849 hour must be between 1 - 12    forum.hibernate.org

4. getting a ora-01747 when using hibernate    forum.hibernate.org

hi, i wanted to get a little bit into hiberante, unfortunatly i've got the following exception: Hibernate: select person0_.UID as UID, person0_.VORNAME as VORNAME, person0_.NACHNAME as NACHNAME, person0_.ALTER as ALTER from PERSONS person0_ SQL Error: 1747, SQLState: 42000 ORA-01747: invalid user.table.column, table.column, or column specification SQL Error: 1747, SQLState: 42000 ORA-01747: invalid user.table.column, table.column, or column specification Could not execute query ...

5. Help!: ORA-01555: snapshot too old    forum.hibernate.org

Beginner Joined: Tue Sep 21, 2004 1:49 pm Posts: 33 Location: Bogota, Colombia Hi, I'm trying to perform a massive update (now there are about 137000 records to update) and I'm doing it following Gavin King's instructions about batch processing (http://blog.hibernate.org/cgi-bin/blosxom.cgi/Gavin%20King/batch.html). I'm trying to commit a block of 10 updates (using batch_size 10) it works nicely until, after a while, I'm ...

6. ORA-00904: "USUARIO0_"."USRID": invalid    forum.hibernate.org

Have problems making a query to an Oracle Database, for an extrange reason it does not recognize a table colum. Thanks... Hibernate version: Hibernate 2.1.6 Mapping documents: -------------------------------------- Mapping for: Usuario.hbm.xml ------------------------------------ USRID_SEC

7. Hibernate Oracle Problem: ORA-00907: missing right parenthes    forum.hibernate.org

Hi all. I'm using JBoss 4.2.1GA, and Oracle 10g, and attempting to perform a query. I've been receiving a "ORA-00907: missing right parenthesis" error when attempting to perform the query. Now this is apparently due to Hibernate using the 'as' keyword in the query - something that has been fixed in Hibernate 3.3.0ga. So I updated these Hibernate libs in \server\default\lib: ...

8. Oracle 10g + ORA-01483 --> YUK    forum.hibernate.org

Hello, I'm trying to update a table where two of the columns are CLOBS. As mentioned by others - I periodically get the below error: nested exception is java.sql.SQLException: ORA-01483: invalid length for DATE or NUMBER bind variable The length of the clobs are both over 4000 chars. When the length is less than 4000 I get no error. The hibernate ...

9. what's the root cause to "ORA-24816"    forum.hibernate.org

Hi all, we have implented two "CLOB" fields in one table since we want to store more details. But when we try to insert, update table. following error was occurred.In the hbm we have mapped those fields like this. we assume that hibernate can handled string to CLOB. Since we are not getting ...