oracle 2 « Database « Spring Q&A





1. OptimisticLocking problem with Oracle 10g.    forum.springsource.org

OptimisticLocking problem with Oracle 10g. Hi, I am using Oracle10g, Spring 1.2.x and Hibernate 3.1.x. We are using optimistic locking with hibernate. The problem I am running into is that every ...

3. Help with Opening Cursors in Spring with Oracle    forum.springsource.org

Help with Opening Cursors in Spring with Oracle Hi, I am using Hibernate with Spring on OracleXE Database. I have implemented the Spring transaction Manager. The problem i face is that ...

4. Oracle XMLType and Hibenate with Spring framework    forum.springsource.org

Oracle XMLType and Hibenate with Spring framework We are facing one issue while using Hibernate with Oracle XMLType Data type. Development Environment: Weblogic 8.1 SP4, Oracle 10g Hibernate 3.0 Spring 2.0.4 ...

5. configure JBoss 4.2.0 jdbc connectivity using oracle database    forum.springsource.org

May 31st, 2007, 04:38 AM #1 jomar View Profile View Forum Posts Private Message Junior Member Join Date May 2007 Posts 1 configure JBoss 4.2.0 jdbc connectivity using oracle database hello ...

6. problem with ScrollableResults and ORACLE    forum.springsource.org

7. Spring Oracle issue    forum.springsource.org

Jun 20th, 2007, 08:30 PM #1 vishwajit View Profile View Forum Posts Private Message Junior Member Join Date May 2007 Posts 8 Spring Oracle issue Hello, We have Database product version ...

8. Working with Oracle Objects    forum.springsource.org

Working with Oracle Objects Hi, I'm working on an application which has the following configuration JBoss 4 server Spring 2 Hibernate 3.2.4.GA Oracle 10g database (10.2.0.2.0) JDK 1.5 I want to ...

9. Sprong and Oracle SP's    forum.springsource.org

I was wondering if anyone could point me in the right direction, or maybe give some sample code for using Spring's org.springframework.jdbc.object.SqlFunction Class to return a cursor from an Oracle DB? ...





10. Oracle "Invalid query size" on cachedrowset    forum.springsource.org

This is to point out the issue uncovered in this thread: http://forum.springframework.org/sho...35&postcount=7 Which is directly related to the issue reported at the sun forums here: http://forum.java.sun.com/thread.jsp...712&tstart=165 The quick summary is that ...

11. Error when accessing EJBs remotely - deployed on Oracle AS 10g (rel. 10.1.3).    forum.springsource.org

Hi, I'm using Spring 2.0.2 in a Web application. When I try to access EJBs remotely (installed on Oracle Application Server 10g rel. 10.1.3), I receive a javax.naming.NameNotFoundException. The cause is ...

12. DataIntegrityViolationException during insert - Oracle    forum.springsource.org

DataIntegrityViolationException during insert - Oracle Hi all... hoping for some help here. I've read through several of the posts dealing with transactions, etc and have patterned my configs after those successful ...

13. Insert Clobs Spring 1.28 Oracle 9i    forum.springsource.org

Insert Clobs Spring 1.28 Oracle 9i I am trying to insert a Clob into an Oracle database. I configured my datasource in spring using the BasicDataSource wrapper. Code:

14. problem when using StroedPrecedure with Oracle    forum.springsource.org

problem when using StroedPrecedure with Oracle My table: create table BASEAUTH ( ID NUMBER(12) not null, AUTHCODE VARCHAR2(50) not null, AUTHNAME VARCHAR2(50) not null, AUTHMEMO VARCHAR2(255) ) My Precedure: CREATE OR ...

15. Oracle package state with MQ    forum.springsource.org

Oracle package state with MQ Hello I have an MDP which consumes messages from MQ and loads them into an Oracle 10g database via a stored procedure. All of this works ...

16. Possible to override Oracle dialect properties, like "useInputStreamToInsertBlob"?    forum.springsource.org

Possible to override Oracle dialect properties, like "useInputStreamToInsertBlob"? I'm using Spring 1.2.8, Hibernate 3.2.5, and JDK 1.4.2. I'm having some odd trouble inserting Clobs through Hibernate into Oracle. I have a ...





17. Oracle Object Types and SqlInOutParameter ?    forum.springsource.org

Hi, Here is my requirement - call Oracle 10g stored procedure with the following declaration: PROCEDURE action (req_obj IN OUT REQUEST_T , ins_obj IN OUT INSTRUCTION_T1); Note that both params are ...

18. oracle ref cursor return with null    forum.springsource.org

oracle ref cursor return with null i am new with spring and i am migration from our old jdbc connection to springframework jdbc . our old jdbc connection class is using ...

19. Deploy application with Spring 2.0.7 on Oracle 10.1.3.3    forum.springsource.org

Deploy application with Spring 2.0.7 on Oracle 10.1.3.3 Hi, I have application using Spring Framework 2.0.7, and when I try deploy it on Oracle 10.1.3.3.0, running on JDK 1.5.0_12, I failed ...

20. Connecting to an Oracle DB through SID    forum.springsource.org

I want to connect to an Oracle database, through a SID. The problem is, I can't find a configuration to do it. We used to connect to an Oracle DB on ...

21. what jar should i use to acess oracle 8 ?    forum.springsource.org

what jar should i use to acess oracle 8 ? hi! Im using spring the last 6 mouths. I always used it with MySql and never had a problem with connection ...

22. Spring JDBC 2.5: metadata issue when calling stored function inside an Oracle package    forum.springsource.org

Spring JDBC 2.5: metadata issue when calling stored function inside an Oracle package hi all, I have an issue with Spring JDBC 2.5 when I want to use the metadatas returned ...

23. Cant connect to oracle database    forum.springsource.org

Cant connect to oracle database hi all: I have a servlet that will receive the http messages from client.Then the servlet pass the message to a handler classe.The handler class first ...

24. echo sample: deployment problems in Oracle AS    forum.springsource.org

Dec 10th, 2007, 09:08 AM #1 BooberFraggle View Profile View Forum Posts Private Message Junior Member Join Date Oct 2007 Posts 5 echo sample: deployment problems in Oracle AS Hello, I'm ...

25. Committing Updates To Oracle Database    forum.springsource.org

Committing Updates To Oracle Database All of our database interactions are via stored procedures. I am trying to insert data into a table with the StoredProcedure object but the data is ...

26. How to mapping oracle date field?    forum.springsource.org

27. SQLErrorCodes DataIntegrityViolation Oracle    forum.springsource.org

The error codes defined in sql-error-codes.xml for Oracle does not include the error code 2292 for data integrity violations. Could this be added in Spring by default? Code: ...

28. The SpringSource Advanced Pack for Oracle Database    forum.springsource.org

The SpringSource Advanced Pack for Oracle Database SpringSource announced Spring Integration and several other offerings at the The Spring Experience conference in Hollywood, Fla. One of such things is the SpringSource ...

29. can't deploy ear on Oracle AS 10.1.2    forum.springsource.org

can't deploy ear on Oracle AS 10.1.2 Hi all, I can't deploy an ear on Oracle AS 10.1.2. My application is an j2ee web based application and when i try do ...

30. How to mapping oracle date with format 'yyyy-mm-dd'    forum.springsource.org

I use oracle,it has a date column,so I mapping following code Code: Then I extract data by ...

31. Oracle Streams support    forum.springsource.org

From the initial press release about this project, it was mention that Oracle AQ Streams support was an initial design goal. Is this still the case and is there documentation on ...

32. Jsp and oracle    forum.springsource.org

Hi: I have a jsp that connects to a class and the browser send me a internal error. Curiosly from a main() i can use the same class. My class connects ...

33. Problem while deploying spring framework WAR in Oracle AppServer    forum.springsource.org

Problem while deploying spring framework WAR in Oracle AppServer I am getting the following error when I try to deploy WAR in Oracle Appserver , although it works fine in JDeveloper ...

34. setting up oracle with spring    forum.springsource.org

setting up oracle with spring Hi all, I am hitting a brick wall with this problem. I developed a test application with spring/hibernate that ran well on my apache server when ...

35. problems with Oracle's schemas and ComboPooledDataSource    forum.springsource.org

problems with Oracle's schemas and ComboPooledDataSource Hi, all i have a very hard problem trying to configure the C3P0 conexion pool, i'm sure that the problem is in the automaticTestTable property ...

36. oracle sequence gets updated during unit test.    forum.springsource.org

Apr 25th, 2008, 04:50 PM #1 cablepuff View Profile View Forum Posts Private Message Senior Member Join Date Feb 2007 Posts 283 oracle sequence gets updated during unit test. Hi for ...

37. Spring with oracle types    forum.springsource.org

I am using spring with struts... and oracle as backend. I am in need of inserting a array (2 dimentional) of datas into db. For that we have handled using oracle ...

38. Spring with oracle types    forum.springsource.org

Spring with oracle types Hi am new to springts .... I am using spring with struts... and oracle as backend. I am in need of inserting a array (2 dimentional) of ...

39. Spring with oracle types    forum.springsource.org

Spring with oracle types I am using spring with struts... and oracle as backend. I am in need of inserting a array (2 dimentional) of datas into db. For that we ...

40. Job Runtime JDBC exception: Missing Defines Exception from Oracle    forum.springsource.org

May 15th, 2008, 02:36 PM #1 cgi_spring View Profile View Forum Posts Private Message Junior Member Join Date Apr 2008 Posts 3 Job Runtime JDBC exception: Missing Defines Exception from Oracle ...

41. Easiest way to deal with nested oracle types?    forum.springsource.org

Easiest way to deal with nested oracle types? Hi everyone. I'm attempting to build a Java wrapper around some Oracle 10g stored procedures. The inputs to these are all types, and ...

42. How to run petportal example on Oracle portal    forum.springsource.org

43. Problem querying Oracle XMLType Using Spring Query Methods    forum.springsource.org

Problem querying Oracle XMLType Using Spring Query Methods Hello, I have a class that extends JdbcDaoSupport. When I query an Oracle table for XML data (in a column of type XMLTYPE) ...

44. spring portlet sample to Oracle OAS oc4j Error(17):    forum.springsource.org

spring portlet sample to Oracle OAS oc4j Error(17): I'm trying to do my first spring portlet project into Oracle OAS oc4j. Cross forum post thinking it was orginally jdeveloper & OAS ...

45. Error Calling Oracle StoreProc that takes an Array    forum.springsource.org

46. How to use a returned Oracle Cursor with ItemReader?    forum.springsource.org

How to use a returned Oracle Cursor with ItemReader? Hi, Is that any way to call a stored procedure that return a REF CURSOR and iterate over the returned cursor to ...

47. Spring LDAP with Oracle Internet Directory    forum.springsource.org

Hello folks, I am configuring Spring LDAP with Oracle Internet Directory. I am getting an exception WARNING: BADCREDENTIALS. I am using Namespace-based security configuration. what could be the possible code mistakes ...

48. Java Calendar to Oracle Date issues    forum.springsource.org

Java Calendar to Oracle Date issues Hi, I am having an issue with the following scenario: Code: Calendar calendar = Calendar.getInstance(); calendar.setTimeZome(TimeZone.getTimeZome(MY_TIMEZOME)); Timestamp now = new Timestamp(calendar.getTimeInMillis()); String updateSql = "UPDATE ...

49. Problem with connect Oracle database in Spring!    forum.springsource.org

Problem with connect Oracle database in Spring! Hi all ! I'm getting a problem with connect database .I combined Spring with Hibernate to create a destop application use Oracle database. My ...

50. Spring-DM on Oracle AS    forum.springsource.org

Spring-DM on Oracle AS Hi there, I am currently in the process to evaluate OSGI to get some form of modularization into our web application development process. Our stack looks like ...

51. Error Getting Metadata With Oracle    forum.springsource.org

Error Getting Metadata With Oracle Hi Every One, I'm in really big troubles, I've been programming some metadata accessing classes, they're pretty good but I was using MysQL and Now I ...

52. Oracle rownum on Mapping    forum.springsource.org

have a table that there is no primary key, what ive done on my mapping file is I refer the ID to the column rownum so that I get a primary ...

53. Oracle RETURNING clause    forum.springsource.org

I am trying to insert a record into an oracle table with an ID column that is generated by a sequence. In my INSERT statement I have "RETURNING ID into ID" ...

54. Advanced Pack for Oracle Questions    forum.springsource.org

Advanced Pack for Oracle Questions Hi I am in the process of evaluating the Advanced Pack for Oracle, but find no other suitable forum for asking some questions. If no one ...

55. DispatcherServlet - Looping and Error with Spring on Oracle Application Server 10.1.2    forum.springsource.org

Oct 15th, 2008, 01:22 AM #1 bjt5150 View Profile View Forum Posts Private Message Junior Member Join Date Oct 2008 Posts 1 DispatcherServlet - Looping and Error with Spring on Oracle ...

56. Oracle ADF Business Components Vs Spring    forum.springsource.org

Hi, Has anybody used Oracle Application Development Framework's Business Components (ADF BC)? What are the disadvantages and issues that you faced? Can anyone compare EJB/Spring with ADF BC? We are planning ...

57. Oracle ADF Business Components Vs Spring    forum.springsource.org

Hi, Has anybody used Oracle Application Development Framework's Business Components (ADF BC)? What are the disadvantages and issues that you faced? Can anyone compare EJB/Spring with ADF BC? We are planning ...

58. Meta-Data Scripts for Oracle    forum.springsource.org

Meta-Data Scripts for Oracle Hi, I am using Spring Batch 1.1.2.RELEASE. I wanted to configure the meta data scripts for oracle database. I was going through the spring batch documentation. But ...

59. oracle weblogic 10.3 Spring 2.5.1 - java.lang.NoSuchMethodError    forum.springsource.org

oracle weblogic 10.3 Spring 2.5.1 - java.lang.NoSuchMethodError Hi, I try to deploy web application into weblogic server (WLS) 10.3 on RedHat linux ( kernel 2.6.18-92.el5xen), but I'am facing the following error. ...

60. JNDI DataSources and Oracle RAC FCF    forum.springsource.org

JNDI DataSources and Oracle RAC FCF I am interested in using the Oracle RAC and FCF support, but all the examples are predicated around the datasource being defined in the spring ...

61. Oracle RMI Stub    forum.springsource.org

Spring DM RMI Stub Hello! I'm deploying my ear application (not OSGI) on Oracle AS 10.1.3. And i trying to connect to server from client (OSGI). But i have this exception ...

62. Upgrading to Oracle 11g (ojdbc6) & KeyHolder    forum.springsource.org

Upgrading to Oracle 11g (ojdbc6) & KeyHolder Hello, I'm attempting to upgrade code from Oracle 10g to Oracle 11g (v. 11.1.0.7.0 using ojdbc6.jar). I am currently using Spring 2.5.6 and Java ...

63. Oracle TIMESTAMP(6) WITH LOCAL TIME ZONE Problems    forum.springsource.org

Oracle TIMESTAMP(6) WITH LOCAL TIME ZONE Problems I am relatively new to spring data access and am struggling with time zone fields in oracle. I've spent many hours searching this forum ...

64. Oracle Identy Manager / SecureId - Where to start...    forum.springsource.org

Oracle Identy Manager / SecureId - Where to start... Hi. I expect Im entering in to a whole world of confusion here, but since this is my first foray with spring ...

65. class path issue with spring when deploy in oracle app server    forum.springsource.org

class path issue with spring when deploy in oracle app server Hi there, i am using spring in an web application using jdeveloper. it is working perfectly for me in jdeveloper. ...

66. Newbie Question - Difficulty configuring app to work with Oracle DB    forum.springsource.org

Newbie Question - Difficulty configuring app to work with Oracle DB Hi, Really new to Spring - and have tried to work through the Spring Ref Docs (esp. Section 3) - ...

67. UpdatableSqlQuery error with Oracle 10g    forum.springsource.org

I am trying to do an update method using an UpdatableSqlQuery and I am getting an error that I can't figure out, I'm hoping you guys can help me out a ...

68. Oracle Thin Client with wallet config    forum.springsource.org

Oracle Thin Client with wallet config Our database turned on SSL, so I have had to change my connection. I have everything working with a thick client, but I can't get ...

69. Oracle connections issues    forum.springsource.org

Mar 10th, 2009, 03:24 PM #1 zbhiwandiwala View Profile View Forum Posts Private Message Member Join Date Apr 2007 Posts 50 Oracle connections issues We are using hibernate 3.0, spring 2.0.6 ...

70. Oracle Lob problem in weblogic cluster and JNDI DataSource    forum.springsource.org

Apr 9th, 2009, 11:14 AM #1 hajunma View Profile View Forum Posts Private Message Junior Member Join Date Apr 2009 Posts 4 Oracle Lob problem in weblogic cluster and JNDI DataSource ...

71. problem of Oracle LOB in weblogic cluster+JNDI DS    forum.springsource.org

Apr 9th, 2009, 11:24 AM #1 hajunma View Profile View Forum Posts Private Message Junior Member Join Date Apr 2009 Posts 4 problem of Oracle LOB in weblogic cluster+JNDI DS I ...

72. Cannot connect to Oracle    forum.springsource.org

Cannot connect to Oracle Hey all, Just wondering if anyone using oracle might be able to help here. My situation is that I have been using my application with a MySQL ...

73. Routing Datasource configuration for Oracle RAC    forum.springsource.org

Routing Datasource configuration for Oracle RAC I have an application deployed in JBoss 4.0.2. The database is a 4 Node Oracle RAC. The application is multi tenant . Requests from a ...

74. Contact App - Oracle schema    forum.springsource.org

Hello, Does anyone have the Oracle database schema for the Spring Security's Contacts sample application? The ref doc says its been tested under Oracle but I'm unable to locate the Oracle ...

75. Help Please! - Contact App (ACL)and Oracle DB problem!    forum.springsource.org

Help Please! - Contact App (ACL)and Oracle DB problem! Hello, As we all know Oracle does not auto-generate unique keys. So when I run the DataSourcePopulator of the Contacts application against ...

76. Oracle TIMESTAMP and NamedJdbcTemplate    forum.springsource.org

Oracle TIMESTAMP and NamedJdbcTemplate I'm using a NamedJdbcTemplate exclusively throughout my DAO code. I'm using an Oracle 11g database with the ojdbc6 driver. I have several tables with columns of TIMESTAMP(6). ...

77. Spring initialization error deploying application to Oracle Application Server    forum.springsource.org

Jun 25th, 2009, 08:48 AM #1 andypb View Profile View Forum Posts Private Message Junior Member Join Date Jun 2009 Location London Posts 6 Spring initialization error deploying application to Oracle ...

78. Oracle RAC Connection String    forum.springsource.org

Oracle RAC Connection String Have a SB application that uses Placeholder Properties file crm.properties Code: # Placeholders crm.* # for ORACLE 10g: crm.jdbc.driver=oracle.jdbc.driver.OracleDriver crm.jdbc.url=jdbc:oracle:thin:@(description=(load_balance=on)(address=(protocol=tcp)(host=crmdb3a.isus.emc.com)(port=1521))(address=(protocol=tcp)(host=crmdb3b.isus.emc.com)(port=1521))(connect_data=(service_name=CRM03.isus.emc.com))) #crm.jdbc.url=jdbc:oracle:thin:@crmdb3a.isus.emc.com:1521:crm03a crm.jdbc.user=SPRINGBATCH crm.jdbc.password=supersafe crm.schema= crm.schema.script= Note the ...

79. jboss server hangs when publishing data to Oracle 9i.    forum.springsource.org

jboss server hangs when publishing data to Oracle 9i. Hi, We deployed Spring enabled Application on jboss 4.02 and when we try to publish data to Oracle9i .. we observed that ...

80. Spring initialization error deploying application to Oracle Application Server    forum.springsource.org

Spring initialization error deploying application to Oracle Application Server Hello, we have a web application using Spring, Struts and Hibernate3 deploying to Jboss1.4. I would deployed the file *.war to Oracle ...

81. Oracle Weblogic Server Tools Won't install on STS 2.1 SR01 for E3.5    forum.springsource.org

Oracle Weblogic Server Tools Won't install on STS 2.1 SR01 for E3.5 Hiyas, I just downloaded the new STS 2.1 SR01 based on Eclipse 3.5 and got the following error when ...

82. oracle    forum.springsource.org

hi im new to roo i created a project in roo an i use install jpa -provider HIBERNATE -database ORACLE when i tried to deploy in maven it says than the ...

83. Calling Oracle Function from the package    forum.springsource.org

Sep 4th, 2009, 03:59 PM #1 bhasar.sunlaksol View Profile View Forum Posts Private Message Junior Member Join Date Aug 2009 Posts 2 Calling Oracle Function from the package Hi, I have ...

84. Oracle xml parser delimma    forum.springsource.org

Oracle xml parser delimma I need to use Oracle XML DB feature in my item reader. In the batch configuration: class="org.springframework.batch.item.database.Jdb cCursorItemReader">

85. Problem in deploying spring from Jdev to Oracle Application Server    forum.springsource.org

Problem in deploying spring from Jdev to Oracle Application Server Hello, I'm new here and also for spring. I been developing some simple form and using the JNDI with tomcat but ...

86. Problem with calling an oracle stored function from java with Spring    forum.springsource.org

Problem with calling an oracle stored function from java with Spring Hi everyone, I'm trying to access an Oracle stored function from Java code. I'm able to access the function and ...

87. Integrating Oracle BIP in Spring Framework    forum.springsource.org

Hi everyone, Is it possible to integrate Oracle Business Integration Publisher with spring framework? I want to get the reports generated using Oracle BI Publisher but our project s spring framework ...

88. Updation issue in oracle    forum.springsource.org

Updation issue in oracle Code : String sql = "INSERT INTO reg VALUES (?,?,?,?,?,?)"; Object[]params = {""+user.getRegid(),user.getName(),user.getEmail() ,user.getPass(),user.getMobile(),user.getAddress() }; JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource); result = jdbcTemplate.update(sql, params); Error log : ...

89. Oracle XML Parser used to parse spring 3 files    forum.springsource.org

Oracle XML Parser used to parse spring 3 files Hi to all, I've tried to switch from Spring 2.5.6 to 3.0.0 and, surprise!, the Spring container is no more able to ...

90. Spring Portlet under Oracle Portal    forum.springsource.org

Spring Portlet under Oracle Portal Hi I'm using this environment: Spring 2.5.6 Spring 2.5.6 MVC Spring 2.5.6 portlet Oracle Portal 10.1.4.0 I have a simple 3 steps portlet; in the first ...

91. Oracle XML Parser Error NOT on OC4J    forum.springsource.org

Oracle XML Parser Error NOT on OC4J I recently upgraded my codebase to Spring 3.0 by a simple edit to my Maven pom. When I did so and ran my TestNG ...

92. Connecting to Oracle    forum.springsource.org

Jan 12th, 2010, 12:44 PM #3 olona View Profile View Forum Posts Private Message Junior Member Join Date Oct 2007 Posts 7 Thanks. The reasons why i have the backslash is ...

93. Oracle issue based on a field named 'number'    forum.springsource.org

Oracle issue based on a field named 'number' FYI... I made the switch from my desktop MySql database to our oracle RAC environment and noticed that Oracle has issues with the ...

94. Using Fast Connect Failover (FCF) functionality of Oracle10g in Spring    forum.springsource.org

Hello Experts, I want to use fastConnectionFailover functionality of Oracle10g in my project. The old configuration of project is using BasicDataSource, but to use fastConnectionFailover functionaliy I have to use OracleDataSource. ...

95. configure datasource for Oracle in Spring Framework    forum.springsource.org

configure datasource for Oracle in Spring Framework How do I configure datasource for Oracle in Spring Framework ? I have searched the forum for the oracle datasource configuration xml but not ...

96. Oracle db    forum.springsource.org

We have chosen the current up-to-date version of the Oracle driver. If you need a different version please change this in the pom.xml file which should be easy. There are also ...

97. Problems withs Data Source Oracle    forum.springsource.org

Mar 29th, 2010, 08:54 PM #1 dokannon View Profile View Forum Posts Private Message Junior Member Join Date Mar 2010 Posts 1 Problems withs Data Source Oracle Hi , i have ...

98. Meta-Data Schema with Oracle UTF8 support    forum.springsource.org

I am using Spring Batch 2.0 with Orcale 10g as database for Meta-data. We are planning to convert the oracle to support UTF-8 character format. I have following questions with this ...

99. Connection Not Closed Errors in JBoss when setting Oracle End To End Metrics    forum.springsource.org

Apr 14th, 2010, 09:47 AM #1 cstepnitz View Profile View Forum Posts Private Message Junior Member Join Date Jan 2010 Location Maryland Posts 14 Connection Not Closed Errors in JBoss when ...

100. Oracle Tuxedo Question    forum.springsource.org