1. Spring UncategorizedSQLException: ORA-01012 stackoverflow.comI 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.comORA-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.comThis SQL statement works if I run it from my Oracle client (SQL Developer):
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.comIn Oracle 11g I have a stored procedure like this:
where
|
5. ORA-08103: object no longer exists: This error is occuring for Oracle Procedure returning Refcursor from MyBatis stackoverflow.comWhen calling a Stored Procedure in Oracle returning refcursor I am getting an error
|
6. Error ORA-01008 forum.springsource.orgError 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.orgORA-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.orgORA-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.orgJun 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.orgORA-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.orgORA-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.orgError 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.orgOracle 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.orgORA-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.orgORA-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.orgOracle 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.orgMar 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.orgORA-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.orgORA-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.orgHi, 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.orgi 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.orgJun 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.orgORA-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.orgI 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.orgORA-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.orggot 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.orgORA-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 ... |