DataSource « oracle « Java Database Q&A





1. Oracle Datasource returning null connection    stackoverflow.com

The oracle data source is returning null connection when the no of connection request is more. I have the implict cache enabled.The oracle specs says null is returned only is ConnectionWaitTimeout ...

2. Does the appserver need a bounce everytime the database is bounced?    stackoverflow.com

I have my app server resin and oracle database connected. If the db is bounced for any reason, I have to bounce my app server as well to clear the bad ...

3. How to set Oracle's fixedString property in Orion Application Server?    stackoverflow.com

I want to set the fixedString=true connection property for the Oracle JDBC driver in the datasource definition in Orion Application Server 2.0.7 (latest stable release). I've tried the following but ...

4. Oracle getConnection slow    stackoverflow.com

In a Java project, I am using an ojdbc6 jar

    <dependency>
        <groupId>com.oracle</groupId>
        <artifactId>ojdbc6</artifactId>
  ...

5. Attempting to enable Oracle Transparent Data Encryption on JDBC data source    stackoverflow.com

I am trying to use Oracle TDE to connect to a JDBC data source with the following connection string:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.1.101)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=SECUREDATA)))
Is there a way to specify JDBC properties such that Transparent Data ...

6. JTA Enabled data source on WAS 3.5 with Oracle.    coderanch.com

Your insert statement should auto-commit if you haven't told it otherwise. However I haven't used JTA - perhaps somebody else who has done can help. It's not clear what you mean - does the inserted record never ever turn up again? Your last catch block looks a bit weird too. It should be e.toString() or e.getMessage() Adam

7. Using DataSource with Oracle 10g Application Server results in error    coderanch.com

It seems odd to see a CMT exception but have somebody say they are closing a connection manually in a finally clause. Are you using this data source in some kind of session bean, or did you wrap this in some kind of JTA code? Or maybe the data source is configured for XA when one for local transactions would be ...

8. Oracle XA Datasource    coderanch.com

9. Want to read values from tnsnames.ora file with JDBC thin driver (Oracle Datasource is solution)    coderanch.com

Dear Friends, I want to write a java code that connects with Oracle database using host,pid,address information from tnsnames.ora file using jdbc thin driver. I dont want to hard code any of these values accept SID. As per my findings,JDBC thin driver doesnt reads these values from tnsnames.ora file.The usual Class.forName("oracle.jdbc.driver.OracleDriver"); String url = "jdbcracle:thin:@host:port:SID"; Connection conn = DriverManager.getConnection(url, userName, pwd); ...





10. Want to read values from tnsnames.ora file with JDBC thin driver (Oracle Datasource is solution)    coderanch.com

Dear Friends, I want to write a java code that connects with Oracle database using host,pid,address information from tnsnames.ora file using jdbc thin driver. I dont want to hard code any of these values accept SID. As per my findings,JDBC thin driver doesnt reads these values from tnsnames.ora file.The usual Class.forName("oracle.jdbc.driver.OracleDriver"); String url = "jdbcracle:thin:@host:port:SID"; Connection conn = DriverManager.getConnection(url, userName, pwd); ...

12. configure datasource for Oracle    forums.oracle.com