oracle « Connection « JPA Q&A





1. How to trace the connection pool in a Java Web application - DBMS_APPLICATION_INFO    stackoverflow.com

I need improve the traceability in a Web Application that usually run on fixed db user. The DBA should have a fast access for the information about the heavy users that ...

2. oracle10g hibernate problem    stackoverflow.com

when my app startup, i get error like below, can anyone elaborate what i missed out? the app running fine when using mysql. do i miss out any extra parameter in ...

3. Can't open connection    stackoverflow.com

I develop an applivation with very load(request). I used following technologies in my appliation:

  1. Jpa/Hibernate as persistense layer
  2. Spring and Spring Dao
  3. C3p0 as connection pooling
my problem is : I run my application , when ...

4. Configuring Hibernate Connection pooling with c3p0 on Oracle10g    stackoverflow.com

I am unable to get a connection pool using c3p0 with Hibernate and Oracle. The database is Oracle 10.2, and hibernate version is 3.6.5. When I take out the ...

5. Hibernate Cannot Open Connection with oracle 11g    stackoverflow.com

I made a basic JUnit test to set up this oracle database on my computer with hibernate. The database works and everything, but trying to hook it up to Hibernate is ...

6. JPA Repository Host Address details for database connection    stackoverflow.com

How can I access database host connection details and print it to log file for each repository method call? I am using Spring with JPARepository and Oracle as database.

public interface BannerRepository extends ...

8. Hibernate-Oracle connection    forum.hibernate.org

9. Hibernate connection pooling, connections not closed Oracle    forum.hibernate.org

Newbie Joined: Tue Dec 14, 2010 2:34 pm Posts: 1 I am new to hibernate and am running into an issue with open connections to the application database (Oracle 10g). It appears that when a new connection is needed, Hibernate is not obtaining a connection from the existing connection pool, but instead opening new connections. Also, once these connections are open, ...





10. Hibernate Spatial : connection to oracle is abruptly closed    forum.hibernate.org

Using hibernate spatial with Oracle Database 11g Release 2, Hibernate 3.6, HibernateSpatial last trunk version, Spring 3.04 I have this problem that I cannot cope to solve : On the hibernate trace I see that the connection to oracle is abruptly closed during the iteration on the result set. This happens only with hql request that contains spatial criteria. The first ...

11. problem with oracle server connection    forum.hibernate.org

Hello Everyone, I'm using Hibernate3, struts2 and oracle server as DB in my web project. I'm facing one problem with DB connection, once it exceeds the Oracle server's session timeout, it shows the following error : "Hibernate exception : Unable to connect ", this problem exist even when i refresh the login page or reopen new login page. But when i ...

12. Connection problem hibernate oracle 10g    forum.hibernate.org

Newbie Joined: Wed Jun 22, 2011 8:59 am Posts: 2 I'm still kinda new to hibernate and am facing some trouble in getting a connection to the DB using java. However I can make a simple connection in Data Source Explorer in Eclipse and view data, as well as via TOAD. I'm using Eclipse Helios to try to connect to Oracle ...

13. Wesphere 5.1, Oracle 9i Datasource Issue    forum.hibernate.org

Hibernate version:2.1 Description of the Problem: The question is regarding configuring a datasource for Oracle 9i in Websphere 5.1 for J2EE application. I am using hibernate 2.1 to access the db. Reads are working fine. When I try to insert a record I get ORA-01002: fetch out of sequence. After research I am narrowing the problem to the fact that somehow ...

14. Problem with Oracle XA data source    forum.hibernate.org

I'm building a web app based on Hibernate, Spring and MDB. I'm using JTA transaction manager on WebLogic 8.1 and Oracle 9i XA data source. WebLogic "Supports Local Transactions" is set to true to enable Hibernate lazy loading. All is fine until I hit a page that renders data that is lazy-loaded by Hibernate. The page itself is loaded fine, however ...

15. Using oracle connection pooling    forum.hibernate.org





17. Missing connection Hibernate 2 + Oracle    forum.hibernate.org

I'm using hibernate 2 for connect web application in oracle9ias and oracle 9 database. When the application this inactive during a period of time, the application loses the connectivity with the database. I have proven to modify the configuration file adding: hibernate.connection.autoReconnect: true hibernate.connection.autoReconnectForPools: true hibernate.connection.is-connection-validation-required: true But it has not given result. Some suggestion? Thank you very much.

18. Oracle Database Connection    forum.hibernate.org

19. jbpm connection oracle    forum.hibernate.org

bonjour, j'ai une application qui tourne sur jbpm et j'ai besoin de me connecter sur oracle, mais aparament j'ai un problme de "pool de connection" le message d'erreur : Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@676437 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@111b910 [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> ...

20. Hibernate,Oracle,c3p0 - connection problem    forum.hibernate.org

Need help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp Hibernate version:3.0 Mapping documents: Code between sessionFactory.openSession() and session.close(): Full stack trace of any exception that occurs: Name and version of the database you are using: oracle 10g The generated SQL (show_sql=true): Debug level Hibernate log excerpt: hi all, i got the following errors : INFO - Hibernate 3.0rc1 INFO - ...

21. BatchUpdate fails With Oracle DataSource + NonUniqueObjectEx    forum.hibernate.org

Hi, Hibernate version:3.1 I am using oracle-ds.xml and getting the datasource and establishing a connection with the Connection object from the datasource of oracle. My Oracle-ds.xml is : - Code: OracleDS false ...

22. Oracle Connection Pooling Questions    forum.hibernate.org

Hi All, I have a couple of questions. One of them is about OracleOCIConnection pool and I understand that this might not be the correct place to ask. But, I am posting it so that you can understand the fix I am in. We have a web-app that uses spring framework and hibernate to connect to an Oracle 8i db. The ...

23. Hibernate + Oracle 9i Connection Closed Problem    forum.hibernate.org

Hello, We are using Hibernate 3 to handle transactions with an Oracle 9i database located on a server somewhere in the country. After a few hours during the night, the connection goes idle and closes, hence we get the following errors 2006-12-30 17:04:36,753 [Thread-2953] WARN - (JDBCExceptionReporter.java:logExceptions:71)- SQL Error: 17002, SQLState: null 2006-12-30 17:04:36,754 [Thread-2953] ERROR - (JDBCExceptionReporter.java:logExceptions:72)- Io exception: Connection ...

24. oracle c3p0 connection pool problem    forum.hibernate.org

Guys, I have deployed a application on resin-3.0.14 version on linux. I am using oracle as db. My application uses hibernate along with c3p0 connection pool. The configuration are as follows:- In hibernate.properties the following is defined : hibernate.c3p0.acquire_increment 3 hibernate.c3p0.idle_test_period 100 hibernate.c3p0.max_size 100 hibernate.c3p0.max_statements 0 hibernate.c3p0.min_size 10 hibernate.c3p0.timeout 100 In c3p0.properties following is defined : c3p0.automaticTestTable=dual #c3p0.idleConnectionTestPeriod=300 #c3p0.preferredTestQuery=SELECT 1 c3p0.testConnectionOnCheckin=true ...

25. Oracle/Hibernate problem closing pooled connection    forum.hibernate.org

Folks, I'm working on a java appication using Hibernate. After switching from MySql to Oracle, I see a large number of warnings org.hibernate.connection.DriverManagerConnectionProvider - problem closing pooled connection. This is not consistent in that sometime a run gives none of these, sometimes more than others. Any idea what might be going on? Do you need anything else from me to help ...

26. Hibernate Closed Connection issue with Oracle 10g    forum.hibernate.org

Newbie Joined: Thu Mar 06, 2008 1:28 am Posts: 2 I am using Hibernate 3.2.2 , Oracle 10g(10.1.3) Application Server and Oracle 10g Database . My App server works fine beginning the day and at the end of the day, when I go through the logs, i find many CLOSED CONNECTION exceptions thrown. why is it? I am not closing the ...

27. trusted oracle connection    forum.hibernate.org

Has anyone used an OS trusted oracle connection with hibernate? I have configured the OS and my oracle accounts are created and have it working with a different connection pooling application but when I replace the thin with oci in the hibernate properties file I get an invalid URL connection error. Just wondering if anyone is using it or if you ...

28. oracle connection pool    forum.hibernate.org

Hello, I'm using oracle 10g and in my cfg.xml file I haven't set any connection pooling properties. when I look at the log I see: INFO [org.hibernate.connection.DriverManagerConnectionProvider] Using Hibernate built-in connection pool (not for production use!) Few questions: 1. I'm using oracle.jdbc.driver.OracleDriver, do I need to use a connection pooling strategy? Doesn't oracle already have a connection pooling strategy? 2. How ...

29. Oracle connection: get tables    forum.hibernate.org

Oracle 8.1.7 Hibernate tools 3.2.2GA I sadly test every drivers: Oracle Database 11g Release 1 Oracle Database 10g Release 2 Oracle Database 10g Oracle9i Release 2 Oracle9i Release 1 Oracle8i Release 2 cfg.xml: Code: oracle.jdbc.driver.OracleDriver ...

30. About the connection to Oracle 11g    forum.hibernate.org

31. cannot get oracle connection    forum.hibernate.org

from SavedItemSearch as sis where (sis.allUsers = '1' or sis.personCreated = :personCreated