oracle 1 « Database « Spring Q&A





1. Oracle connections in Spring    stackoverflow.com

I am using Oracle 9 JDBC Thin Driver - the connection string I have used for standard JDBC was:

jdbcConn.connect("jdbc:oracle:thin:myDevDb/myDevDb@fooServer:1521:MYSIDNAME");
...just trying to get my head around using this kind of connection in ...

2. Spring JDBC connection pool and InputStream results    stackoverflow.com

I am writing a webservice that allows users to post files and then retrieve them at a URL (basically think of it as the RESTful Amazon S3). The issue I ...

3. Spring JDBC support and large dataset    stackoverflow.com

When using one of the various JDBC template methods I am confused on how to iterate/scroll over large result sets (which won't fit into memory). Even without a direct exposure of ...

4. enterprise with jdbc    stackoverflow.com

I have enterprise project, but all queries are implemented using oracle stored procedures, I use jbdc and Spring framework to get results like this :

 public class HoaDonDAOimpl extends JdbcDaoSupport implements ...

5. Transferring data from Salesforce using Apex Data Loader to Oracle    stackoverflow.com

While attempting to transfer data from Salesforce using Apex Data Loader to Oracle Keep getting the following error:

    26937 [databaseAccountExtract] FATAL com.salesforce.dataloader.dao.database.Data
baseContext  - Error getting value for ...

6. ADF vs. EJB/Spring: Where should I invest my time?    stackoverflow.com

I am a junior Java SE developer, planning to become a Java Standard Edition professional. Which technologies/frameworks will be the smartest thing for me to learn? I will invest a lot ...

7. Inserting large number of hierarchical data using Spring    stackoverflow.com

first of all, let me say that I'm a total JAVA newbie. But I have this problem. I need to insert data in to a set of parent child tables. The ...

8. Spring JMS and Oracle AQ    stackoverflow.com

Has anyone got Spring JMS to work with an Oracle AQ queue? I am trying to connect to AQ based on this article http://blog.nominet.org.uk/tech/2007/10/04/spring-jms-with-oracle-aq/ but i am getting this error now JMS-137: Payload ...

9. JNDI for Oracle 11 doesn't work in TC Server    stackoverflow.com

I'm trying for a few days configure a JNDI for Oracle 11 in TC Server, but no success. The intresting thing is when I do exactly the same thing for the ...





10. Using Oracle's DBMS_APPLICATION_INFO package with Spring JDBC    stackoverflow.com

Our webapps currently make JDBC calls to our Oracle database directly. We tag each connection with calls to the DBMS_APPLICATION_INFO package in a static getConnection(String client) method, e.g.

CallableStatement pstmt = ...

11. Using AbstractTransactionalJUnit4SpringContextTests with Oracle Procs which COMMIT    stackoverflow.com

I'm using AbstractTransactionalJUnit4SpringContextTests to run a simple test:

public class MyTests extends AbstractTransactionalJUnit4SpringContextTests
{
    @Test
    public void simpleProcTest()
    {
      ...

12. Duplicated definition for: 'identifiedType'    stackoverflow.com

I have a web application where i am using spring 3.0 and oracle's XMLTYPE related jar's com.oracle.xdb which in turn depends on com.oracle.xml.xmlparserv2 , iam sure most of you aware of ...

13. Deployed application on Jboss and application throughs the exception Network Adopter    stackoverflow.com

I have deployed the application in Jboss, which is Linux. I have kept the oracle-ds.xml in jboss. Database is pointing to my local machine. Now started the application, Server is up, ...

14. Oracle, utf-8, NVARCHAR2, and a lot of confusion    stackoverflow.com

I have the following "translation" table in an oracle 10g database:

ID  VARCHAR2(100 BYTE)
LANGUAGE    CHAR(2 BYTE)
COUNTRY CHAR(2 BYTE)
TRANSLATION NVARCHAR2(2000 CHAR)
TRACK_TIMESTAMP DATE
TRACK_USER  VARCHAR2(2000 BYTE)
When I try to do ...

15. Issue using Oracle date function with Spring's NamedParamenterJdbcTemplate    stackoverflow.com

I'm having an issue trying to get my SQL query which works fine in SQL Developer (Oracles free database tool) to also work using Spring's NamedParameterJdbcTemplate class. My query is:

String sql = ...

16. Error upon integrating JNDI with Spring    stackoverflow.com

This was my first attempt at Spring with JNDI but getting the below mentioned exception when trying to create the ApplicationContext like:

ApplicationContext context = new ClassPathXmlApplicationContext("master-job.xml");
The Spring configuration file ...





17. JBoss 7 Spring Oralce connection pooling    stackoverflow.com

I want to use Spring framework to create application that uses Oracle 11g to store data. Can you tell me how to configure the Spring framework to use the connection pooling with ...

18. Can Spring persist Oracle SDO_GEOMETRY    forum.springsource.org

All, Is anyone using Spring to persist Oracle Spacial geometries? I am trying to insert geometry data into an Oracle SDO_GEOMETRY column with no luck. My errors are the same as ...

19. DBRE issue with Oracle    forum.springsource.org

20. Using Oracle DBMS_APPLICATION_INFO package    forum.springsource.org

Using Oracle DBMS_APPLICATION_INFO package Hi, We're switching from direct JDBC calls to using Spring JDBC. One of the things we do is to tag our connections with something like this: Code: ...

21. Spring connect to Oracle    forum.springsource.org

I have a problem is how to use Spring 3 connect to Oracle database. Please tell me detail because I'm a newbie I'm use Eclipse Helios and Apache Tomcat Thanks all ...

22. Setting Oracle NLS_TIMESTAMP_FORMAT    forum.springsource.org

All, I need to set the Oracle NLS_TIMESTAMP_FORMAT for my pooled connection. I there a way to specify this value during bean construction or in some properties file? Thx. in advance ...

23. Oracle Long Raw & JDBC    forum.springsource.org

24. StatementCacheSize?:ORACLE:WebsphereAppServer 5.1    forum.springsource.org

Sep 9th, 2004, 08:10 AM #1 mavisakal View Profile View Forum Posts Private Message Member Join Date Sep 2004 Posts 32 StatementCacheSize?:ORACLE:WebsphereAppServer 5.1 Hi everybody, My configuration: - 1 datasource : ...

25. Unable to database introspect with Oracle    forum.springsource.org

When you execute an osgi ps command in Roo, do you see: Code: [ 74] [Active ] [ 1] Java Transaction API (1.1.0) [ 75] [Active ] [ 1] Java Resource ...

26. Problems calling Oracle function with Out param    forum.springsource.org

Problems calling Oracle function with Out param Hello, I am facing a reculiar issue while trying to execute a function using SimpleJdbcCall. This is the function spec: Code: FUNCTION chkFootnoteSym ( ...

27. How to get Long colum oracle datatype    forum.springsource.org

28. Issue with DBRE Oracle JDBC    forum.springsource.org

Issue with DBRE Oracle JDBC I have been trying for a number of hours to get the Oracle JDBC stuff working with no success. I have read a number of posts ...

29. Project status of - "Spring Data JDBC" (Add support for advanced Oracle features)?    forum.springsource.org

Hi there, can somebody update me, about the status of the project mentioned in the subject? "Spring Data JDBC" (Add support for advanced Oracle features)? I can't find that many entries ...

30. Reading Huge Chunks of data from Oracle to a XML file    forum.springsource.org

Reading Huge Chunks of data from Oracle to a XML file Hi, I'm using Spring MVC to recieve RESTFul request with several parameters, fetch a very big chunk of data from ...

31. DBRE and Oracle 10g XE Setup concerns    forum.springsource.org

Thank you for the posts. Did anybody manage to run Roo DBRE on oracle on JDK 1.6 using Oracle 11? I've tried to wrap up ojdbc6.jar from Oracle 11 without success. ...

32. Oracle Connection Error    forum.springsource.org

Hi, I have created a ROO project using database reverse engineering. Database: Oracle 10g The project was created successfully. When I click on any link in the UI, It is showing ...

33. Problems calling an oracle function that returns a tabtype    forum.springsource.org

Problems calling an oracle function that returns a tabtype Hi guys, I'm having problems calling my oracle function that returns a table of records/objects Code: FUNCTION get_cash_txns(p_client_id IN VARCHAR2) RETURN pf_sett_led_records_tabtype ...

34. Does the orcl namespace support Oracle's Universal Connection Pool?    forum.springsource.org

Does the orcl namespace support Oracle's Universal Connection Pool? I just had a look at the orcl namespace in the JDBC Extensions for Oracle, and it seems to always create beans ...

35. Oracle Database unchanged after commit    forum.springsource.org

Oracle Database unchanged after commit Hello all, Thank you for reading. I'm currently facing a really strange problem. I have an application that has to perform some operations and depending on ...

36. Reading Oracle Struct Type    forum.springsource.org

I am new to spring and searched a lot to read data from oracle struct type in spring but couldnt get much help private SimpleJdbcCall _call; //set datasource Code: _call.withCatalogName("ROOT") .withProcedureName("TEST1") ...

37. Need help Oracle    forum.springsource.org

Need help Oracle I am not an expert in Spring and roo but things have been going pretty well until I tried to connect to an Oracle Database (I made my ...

38. Oracle function call fails    forum.springsource.org

Oracle function call fails Hi! We are using Oracle Database and this function call: Code: m_translateProc = createFunc("OUR_FUNCTION"); m_translateProc.addDeclaredRowMapper("p_result", new RowMapper() {...}); ... MapSqlParameterSource params; params = new MapSqlParameterSource(); params.addValue("p_aaa", bar); ...

39. DBRE: Oracle DB introspection hangs    forum.springsource.org

Hello.. after some work i've got working the oracle driver (10.2.0.1) on SpringROO 1.4, now after I give this command: database introspect --schema and then press TAB i get the list ...

40. ORACLE 9 + LOB + Spring Image Database sample application    forum.springsource.org

ORACLE 9 + LOB + Spring Image Database sample application I have this error messages when I am compiling under Eclipse. I created all the tables under ORACLE 9 and follow ...

41. Slow Oracle Query when MapSqlParameterSource added    forum.springsource.org

Slow Oracle Query when MapSqlParameterSource added Hi, I have a query whose performance dramatically degrades when I add a parameter using Spring. As a simple example Code: String searchTerm = "852"; ...

42. Oracle Jdbc invalid url problem    forum.springsource.org

Oracle Jdbc invalid url problem Hallo, I have a problem similar to the one described in this thread but I couldn't fix it so far. http://forum.springframework.org/showthread.php?t=10870 I am running an application ...

43. JDBC & using Oracle "returning into"    forum.springsource.org

I currently have this SQL statement executing: Code: public class MyTestDaoImpl extends SimpleJdbcDaoSupport implements MyTestDao { private static final String INCREMENT_COUNTER = "UPDATE wkf_instance_counter ic SET ic.count=count+:incrementBy " + "WHERE counter_name=:counterName"; ...

44. DataAccessFailure Exception when I want save in DB Oracle    forum.springsource.org

Nov 9th, 2004, 10:25 AM #1 susu80 View Profile View Forum Posts Private Message Junior Member Join Date Nov 2004 Posts 4 DataAccessFailure Exception when I want save in DB Oracle ...

45. DataAccessFailure Exception when I want save in DB Oracle    forum.springsource.org

Nov 9th, 2004, 10:26 AM #1 susu80 View Profile View Forum Posts Private Message Junior Member Join Date Nov 2004 Posts 4 DataAccessFailure Exception when I want save in DB Oracle ...

47. Oracle connection error    forum.springsource.org

Aug 22nd, 2011, 05:39 PM #1 JoeyH View Profile View Forum Posts Private Message Junior Member Join Date Aug 2011 Posts 2 Oracle connection error I've been banging my head against ...

48. Oracle WebLogic Server 11g (v10.3.5) and SPRING (v3.0.x) taglib integration    forum.springsource.org

Oracle WebLogic Server 11g (v10.3.5) and SPRING (v3.0.x) taglib integration Hello, I am newbie...please bear with me. I have a running web application (war file) in WebLogic v9.2 that uses SPRING ...

49. DBRE: Oracle VARCHAR2 lengths    forum.springsource.org

DBRE: Oracle VARCHAR2 lengths Hi, When reverse engineering an Oracle database with VARCHAR2 columns, the length is taken as the number of bytes rather than the number of chars, e.g. CREATE ...

50. Cannot create Oracle Weblogic Server 11G in 2.7.1 or 2.8.1    forum.springsource.org

I have been trying to create an Oracle Weblogic 11G server adapter. The only oracle servers shown in the add new server are the Oracle OC4J Standalone server 10.1.3 and 10.1.2.n. ...

51. How to run oracle procedure in the oracle default schema ?    forum.springsource.org

How to run oracle procedure in the oracle default schema ? Hi all, I'm very new to spring framework and oracle. And I'm currently working on a java program which use ...

52. Problem selecting from views w/db links on Oracle.    forum.springsource.org

I am getting a "ORA-01002: fetch out of sequence" exception while selecting from a view in oracle. This view contains SQL-Server tables through a dblink as well as tables in the ...

53. "Cursor is closed" in Oracle    forum.springsource.org

"Cursor is closed" in Oracle I am calling a Stored Procedure in Oracle 10g and am getting: java.sql.SQLException: Cursor is closed I've seen the post about setDefaultAutoCommit to false, but only ...

54. Oracle Function returning a REF CURSOR    forum.springsource.org

Oracle Function returning a REF CURSOR Hi, I found this example (http://forum.springframework.org/viewtopic.php?t=514) of calling a Postgresql function that returns a ref cursor and people have said it works for Oracle too. ...

55. oracle JDBC throws error while initializing    forum.springsource.org

oracle JDBC throws error while initializing Hello everyone , This is how my config file looks like oracle.jdbc.driver.O racleDriver ...

56. Oracle Lite Warning    forum.springsource.org

Oracle Lite Warning Hi, I'm building an application with Spring and Hibernate, having as DB Oracle Lite. When executing a Query I have the following Warning: Hibernate: select tblcolonne0_.COLONNA_ID as COLONNA_ID0_, ...

57. How to run a Oracle function with CallableStatementCallback    forum.springsource.org

How to run a Oracle function with CallableStatementCallback i want to call an oracle function which takes 5 or 6 input and has a single output. Using the following code, CallableStatementCallback ...

58. Oracle retrieve array of objects    forum.springsource.org

Can someone, preferably from the Spring Team, please tell me if the Spring JDBC framework supports retrieving an array of Oracle objects? There is a paucity of postings on this topic, ...

59. Oracle ADF    forum.springsource.org

Hi I've been using Spring and ADF for a big project. Basically I use Spring for the Business Login integration of Data Sources, DAOs and Business Facades. After this I take ...

60. Passing an ARRAY to Oracle Procedure    forum.springsource.org

Passing an ARRAY to Oracle Procedure I've seen some examples on how to do this and got to the following code, Code: public class ServicePlanCreate extends StoredProcedure { public ServicePlanCreate (DataSource ...

62. Cannot insert time into Oracle?    forum.springsource.org

Cannot insert time into Oracle? Was anyone able to insert date AND time into Oracle when using SqlUpdate (a class that extends it)? In my Object[] arguments, I've tried to pass ...

63. stale Oracle processes    forum.springsource.org

stale Oracle processes Hello, My application uses Oracle 9i, release 2 and is using the DataSourceTransactionManager. My DAO's are using a TransactionProxyFactoryBean with the following transaction attributes: PROPAGATION_REQUIRED (for inserts, updates, ...

64. Spring within oracle.    forum.springsource.org

Spring within oracle. Hi folks, I currently have a standalone app based around spring dao, core and aop... there is a requirement to expose a few static methods to be accessed ...

65. Trying to connect to Oracle 8i,Exception in Spring Framwork    forum.springsource.org

Trying to connect to Oracle 8i,Exception in Spring Framwork Hi, I am new to Spring Framework and I am using Spring Framework with hibernate and Oracle 8.1.5. I am trying to ...

66. Using oracle data-sources.xml    forum.springsource.org

Using oracle data-sources.xml Hi, Up til now on the project I've been using org.springframework.jdbc.datasource.DriverManagerD ataSource for data access eg:- com.evermind.sql.DriverManagerDataSource jdbc:oracle:thin:@xxx.xxx.xx.xx:1521:SIDNEY ...

67. How to install a .EAR in Oracle 10g Application Server??    forum.springsource.org

Hi, Im trying to deploy an application in Oracle 10g Application Server. It seems than this application uses some spring framework libraries, how do I install this frame work over Oracle ...

68. Oracle 10g RAC Issues    forum.springsource.org

Jul 30th, 2005, 01:56 PM #1 exwhyz View Profile View Forum Posts Private Message Junior Member Join Date Jul 2005 Posts 1 Oracle 10g RAC Issues I am using AppFuse framework ...

69. problems creating an oracle LOB object    forum.springsource.org

Aug 16th, 2005, 11:46 AM #1 dencamel View Profile View Forum Posts Private Message Member Join Date Jan 2005 Posts 31 problems creating an oracle LOB object Hello, This forum has ...

70. Oracle, Spring - JDBC exception    forum.springsource.org

Sep 15th, 2005, 02:31 PM #1 jakim8915 View Profile View Forum Posts Private Message Junior Member Join Date Aug 2005 Location Vancouver, Canada Posts 15 Oracle, Spring - JDBC exception Im ...

71. JBoss + Spring+ Hiberante --> Oracle 9i -->An unknown    forum.springsource.org

Sep 16th, 2005, 04:07 PM #1 suresha143 View Profile View Forum Posts Private Message Junior Member Join Date Sep 2005 Posts 3 JBoss + Spring+ Hiberante --> Oracle 9i -->An unknown ...

72. Oracle OC4J 904 and environment variable    forum.springsource.org

Oracle OC4J 904 and environment variable Hi all, we are getting this when trying to run our app in Oracle 904: org.springframework.beans.factory.access.Bootstrap Exception: Define an environment variable [java:comp/env/ejb/BeanFactoryPath] containing the class ...

73. Generic Oracle stored function class    forum.springsource.org

Sep 28th, 2005, 10:04 AM #1 too_many_details View Profile View Forum Posts Private Message Senior Member Join Date Feb 2005 Posts 229 Generic Oracle stored function class Hi all, I would ...

74. JOTM, XAPool, and Oracle    forum.springsource.org

JOTM, XAPool, and Oracle I'm getting a "maximum open cursors exceeded" error when using JOTM, XAPool, and Oracle. I recently went from DBCP to JOTM/XAPool and never had that problem when ...

75. LOB-Handling in Oracle 10g    forum.springsource.org

Hi all, As with Oracle 10g no more special LOB handling is required. If you use still the OracleLobHandler some strange LOB errors (i really don't remeber the precise error) from ...

76. Oracle OC4J & JTATransactions    forum.springsource.org

I'm using Spring JDBC Templates inside the Oracle OC4j 10g container. The JDBC templates are not aware of global JTA Transactions that are running. I've tried configuring a JTATransactionManager in my ...

77. Oracle JDBC Date Problem.    forum.springsource.org

Oracle JDBC Date Problem. I am unable to use Spring JDBC to get dates or times from resultsets. I am pulling my hair out trying to get this to work. It ...

78. Spring and Oracle interaction    forum.springsource.org

Spring and Oracle interaction Hi all, I work exclusively with Oracle and all interaction is via stored procs. All table design is done by hand based on the problem domain (ie ...

79. Oracle RETURNING with Spring    forum.springsource.org

I have SQL BEGIN INSERT INTO MY_TABLE(COL_NAME) VALUES (?) RETURNING RECID INTO ?; END; Which Spring object do I need to use in order to execute and get primary key? I ...

80. Springjdbc + Oracle with foreign characters encoding problem    forum.springsource.org

Springjdbc + Oracle with foreign characters encoding problem Hi all, I have a problem with a standalone java application that uses the Spring libs. This application is moreless like a loading ...

81. LuntBuild Setup for Oracle    forum.springsource.org

Hi All, I am installing the LuntBuild. I have TomCat Server. I tried to access with MySQL, but failed. By serfing I have seen that Oracle Support for LuntBuild is there. ...

82. Problem with Oracle query of the Data Type 'Date'    forum.springsource.org

Problem with Oracle query of the Data Type 'Date' I'm having difficulty with the oracle query using the spring framework. Currently i have a table created within the oracle database with ...

83. Oracle returning incorrect characters    forum.springsource.org

Oracle returning incorrect characters Hi, we are experiencing problems with returning Chinese characters from an Oracle database using Weblogic 8.1 and Spring. Basically, Spring uses the CallableStatement internally to deal with ...

84. JNDI DataSources on Oracle 10g    forum.springsource.org

Hello there! I'm having problems when configuring spring with jndi datasources on oracle AS 10g. Here are my configuration files: applicationContext.xml: Code: java:/comp/env/jdbc/waySOADS Oracle's ...

85. Integrating Spring with Oracle Portlets?    forum.springsource.org

We are in the process of selecting the technologies we'll use in an upcoming project. I would like to know if anyone has successfully integrated Spring with Oracle Portlets. My understanding ...

86. Using Oracle database    forum.springsource.org

Hi, I'm new to Spring and I'm followung the MVC tutorial. I'm now in the 4th point, but instead of using the hsql database, I want to use an Oracle database. ...

87. After Catching DataIntegrityViolationException, Oracle Drops Connection    forum.springsource.org

After Catching DataIntegrityViolationException, Oracle Drops Connection Running: Spring 1.2.5 Oracle 9i with 10g JDBC Driver: 10.2.0.1.0 Basically, I've got a really complicated (5 data source) batch application that shuffle's a customer's ...

88. JDBC journal with oracle, ActiveMQ    forum.springsource.org

JDBC journal with oracle, ActiveMQ I have this configuration for JDBC journal. My broker is running from within the Spring application. ...

89. Not saving in an Oracle Data Base    forum.springsource.org

Not saving in an Oracle Data Base Hi, i have a Spring application with Hibernate data access configuration. Everything works well with my spring-hibernate configuration i can read objects execute querys, ...

90. oracle stored funtion    forum.springsource.org

Hi, Could somebody point me to the syntax for documentation (or an example) of calling an Oracle stored function via the EntityManager:s createNativeQuery? The Query doesn't seem to make any difference ...

91. Oracle Error code question    forum.springsource.org

92. Calling an Oracle SP    forum.springsource.org

Nov 23rd, 2006, 02:16 AM #1 srinivas_1981 View Profile View Forum Posts Private Message Junior Member Join Date Nov 2006 Posts 4 Calling an Oracle SP Dear Friends We are trying ...

93. Oracle functions returning boolean    forum.springsource.org

Is there anything special with Oracle stored functions return the type boolean? I have no problems with varchar but I get complaints about the type when trying to return boolean. I'm ...

94. Need help with passing ARRAY to Oracle SP using AbstractSqlTypeValue    forum.springsource.org

Dec 11th, 2006, 03:51 PM #1 egravel View Profile View Forum Posts Private Message Member Join Date Jan 2005 Location Miami, FL, USA Posts 33 Need help with passing ARRAY to ...

95. oracle connections not closing    forum.springsource.org

oracle connections not closing Hi, I have a simple process which is scheduled to run every minute by Quartz. Access to an Oracle database is provided by a Hibernate DAO which ...

96. Calling Oracle Function from java class    forum.springsource.org

97. Problem with Oracle10g Clobs    forum.springsource.org

Problem with Oracle10g Clobs Hi, I am using Spring2.0,Hibernate3.1,weblogic9.1 and Oracle10g. When iam updating clobs with hibernate it is taking long time.I am using Weblogc Datasource. It is giving following eror ...

98. Connection to Oracle Data Base using SPRING    forum.springsource.org

You need to configure a DataSource. Then you have to decide what flavor of DB tier you prefer; Spring query objects, JdbcTemplate, an ORM-framework.. take your pick. Obviously you need to ...

99. Oracle complains NLS    forum.springsource.org

Oracle complains NLS i use spring 2.0 and oracle if i use Code: ${jdbc.driverClassName} ${jdbc.url} ${jdbc.username} ...

100. help!oracle lob problem    forum.springsource.org

Apr 4th, 2007, 01:37 AM #1 do1doer View Profile View Forum Posts Private Message Junior Member Join Date Nov 2005 Posts 8 help!oracle lob problem I got these exception when writing ...