ORA « Database « Spring Q&A





1. Spring UncategorizedSQLException: ORA-01012    stackoverflow.com

I am trying to retrieve data form an Oracle database using jdbc (ojdbc14.jar). I have a limited number of concurrent connections when connecting to the database and these connections are managed ...

2. Using Spring JDBC for Oracle Stored Procedure I get a ORA-02055 when SP throws ORA-20118    stackoverflow.com

ORA-20118 is a custom exception from the stored procedure. The stored procedure runs just fine from PL-SQL developer, so the problem is in Spring. What I need to do ...

3. Getting inserted ID after INSERT ... SELECT on Oracle    stackoverflow.com

This SQL statement works if I run it from my Oracle client (SQL Developer):

insert into Person (Name) select 'Bob' from dual
It also works if I issue it via Spring JDBC, without ...

4. Can I return a table of custom object as an OUT parameter when calling stored procedure in JDBC    stackoverflow.com

In Oracle 11g I have a stored procedure like this:

PROCEDURE test_params (o_message_tbl OUT core.message_tbl);
where
create or replace TYPE message_tbl AS TABLE OF core.message_obj;
create or replace TYPE message_obj AS OBJECT
   ...

5. ORA-08103: object no longer exists: This error is occuring for Oracle Procedure returning Refcursor from MyBatis    stackoverflow.com

When calling a Stored Procedure in Oracle returning refcursor I am getting an error

2011-05-10 03:36:23 DirtiesContextTestExecutionListener [DEBUG] After test method: context [[TestContext@3a363a36 testClass = AccountActivityServiceTest, locations = array<String>['classpath:/com/bnymellon/pwb/pfdetails/service/test/test-application-context.xml'], testInstance = ...

6. Error ORA-01008    forum.springsource.org

Error ORA-01008 select gusuarios0_.ID_USUARIO as ID1_0_0_, gusuarios0_.ID_EMPRESA as ID2_0_0_, gusuarios0_.LOGIN_USUARIO as LOGIN3_0_0_, gusuarios0_.USUARIO as USUARIO0_0_, gusuarios0_.TELF as TELF0_0_, gusuarios0_.FAX as FAX0_0_, gusuarios0_.E_MAIL as E7_0_0_, gusuarios0_.F_ALTA_REG as F8_0_0_, gusuarios0_.ES_SUPERVISOR as ES9_0_0_ from ...

7. ORA-01008: not all variables bound    forum.springsource.org

ORA-01008: not all variables bound hAI ALL I AM GETTING THE FOLLOWING STRANGE ERROR WHILE RUNNING A PROCUDURE. THE ORACLE PROCEDURE IS CREATE OR REPLACE PROCEDURE LOCCODE IN VARCHAR2, FLAG OUT ...

8. ORA-00054: resource busy and acquire with NOWAIT    forum.springsource.org

ORA-00054: resource busy and acquire with NOWAIT I switched from MySQL to Oracle 10g, and things looked OK until one spot where I create an object, and in the same transaction, ...

9. Spring, Quartz and ORA-01002: fetch out of sequence    forum.springsource.org

Jun 5th, 2006, 04:28 PM #1 nestorjb View Profile View Forum Posts Private Message Member Join Date Apr 2005 Posts 35 Spring, Quartz and ORA-01002: fetch out of sequence Hi I'm ...





10. ORA-01001: Invalid Cursor    forum.springsource.org

ORA-01001: Invalid Cursor Hello there! I know this is *sure* not a spring issue, but as this is a data access forum I'm giving it a try I have a query ...

11. ORA-02396: exceeded maximum idle time    forum.springsource.org

ORA-02396: exceeded maximum idle time I use Spring + Hibernate to complete my project , and use DBCP to maintain my connection pool , but I always get error message as ...

12. Error code ORA-00054    forum.springsource.org

Error code ORA-00054 Hi everyone! I am very new to this forum and this forum sounds good with many members connected...hope this will help us all alot... I am facing this ...

13. Oracle exception: ORA-24816: Expanded non LONG bind data    forum.springsource.org

Oracle exception: ORA-24816: Expanded non LONG bind data Hello I have run into the following problem when saving long string values through a spring/hibernate framework to a varchar2(4000 char) column in ...

14. ORA-01795: maximum number of expressions in a list    forum.springsource.org

ORA-01795: maximum number of expressions in a list Hi Guys, We are having issue with query exceeding maximum number of expressions > 1000. we are using ibatis. It looks the issue ...

15. ORA-01000: maximum open cursors exceeded    forum.springsource.org

ORA-01000: maximum open cursors exceeded Hi, I am using Spring for DAO connectivity import org.springframework.jdbc.core.JdbcOperations; private static JdbcOperations jdbcTemplate; String sql = "select ....."; jdbcTemplate.query(sql, myMapper); This opens a cursor. I ...

16. Oracle 10g + ORA-01483 --> YUK    forum.springsource.org

Oracle 10g + ORA-01483 --> YUK Hello, I posted this on the hibernate forum - but no one replied, so thought I'd try here... I'm trying to update a table where ...





17. ERROR JDBCExceptionReporter:78 - ORA-02289: sequence does not exist    forum.springsource.org

Mar 12th, 2008, 05:26 AM #1 Lavi View Profile View Forum Posts Private Message Junior Member Join Date Jun 2007 Posts 18 ERROR JDBCExceptionReporter:78 - ORA-02289: sequence does not exist Hi, ...

18. ORA-01461 error while running a job    forum.springsource.org

ORA-01461 error while running a job Hi, I run into this error while running my job Code: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSER T into BATCH_STEP_EXECUTION(STEP_EXECUTION_ID, VERSION, STEP_NAME, JOB_EXECUTION_ID, START_TIME, ...

19. ORA-01461: can bind a LONG value only for insert into a LONG column    forum.springsource.org

ORA-01461: can bind a LONG value only for insert into a LONG column I am getting the message below from the batch-framework. I am running a configuration with several steps, - ...

20. Ora-12505    forum.springsource.org

Hi, I have this error: Code: TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: 172.17.194.6:1521:UWTESTW The first problem is that ...

21. ORA-00060 for AbstractTransactionalDataSourceSpringContextTests    forum.springsource.org

i have a series of tests that extend AbstractTransactionalDataSourceSpringContextTests. these tests run some sql to delete some rows from some tables in the integration db in order that i can load ...

22. Ora-01461 ?    forum.springsource.org

Jun 4th, 2009, 08:43 AM #1 goyinho View Profile View Forum Posts Private Message Member Join Date Mar 2009 Posts 38 Ora-01461 ? I'm working on SpringBatch 2.0.0. I've implemented a ...

23. ORA-01000: maximum open cursors exceeded    forum.springsource.org

ORA-01000: maximum open cursors exceeded Hi, We are using Spring JDBC for our project. The application is deployed on JBoss 5.1 app server and the connection pool is managed by JBoss. ...

24. How do I get column name that causing the error ORA-01722: invalid number    forum.springsource.org

I am using NamedParameterJdbcTemplate PreparedStatement for inserting data in Oracle Database 10g Enterprise Edition Release 10.2.0.3.0. The tables are huge and if there is any data issue for a column like ...

25. ORA-00932: inconsistent datatypes: expected MDSYS.SDO_GEOMETRY got CHAR    forum.springsource.org

ORA-00932: inconsistent datatypes: expected MDSYS.SDO_GEOMETRY got CHAR I am using Spring JDBC template in inserting into a table that has a SDO_GEOMETRY data type. However, I am getting the following error: ...

26. got error while connection to Oracle:ORA-00942:table or view does not exist    forum.springsource.org

got error while connection to Oracle:ORA-00942:table or view does not exist Dear all I have written Dao which can connect to oracle database and perform some operations I got the below ...

27. ORA-01002: fetch out of sequence error    forum.springsource.org

ORA-01002: fetch out of sequence error I am getting a java.sql.SQLException: ORA-01002: fetch out of sequence while trying to do a refresh, basically select for update? How do I set autocommit ...