1. Connection to Oracle without a username or password stackoverflow.comOracle has this concept of allowing database users to be identified by the operating system user who is running the program that is connecting to Oracle. See here. This allows ... |
2. How to determine database type for a given JDBC connection? stackoverflow.comi need to handle resultset returning stored procedures/functions for three databases (oracle, sybase, MS-Server). the procedures/functions are generally the same but the call is a little different in oracle. statement.registerOutParameter(1, oracle.jdbc.OracleTypes.CURSOR); . . . statement.execute(); ResultSet ... |
3. programmatically checking for open connection in JDBC stackoverflow.comHow do I check for an open connection in jdbc for oracle database?
Note: |
4. JDBC connection to Oracle Clustered stackoverflow.comI would like to connect to a clustered Oracle database described by this TNS: |
5. How to obtain the list of Oracle's SIDs stackoverflow.comI have the host, port, user id and password but missing SID for connecting to Oracle DBMS. How can I find the list of SIDs on that server? |
6. JDBC Thin Connection stackoverflow.comI have installed NetBeans 6.5 with JDK1.6. And I want to connect between oracle with java in NetBeans 6.5. The question is: How do I configure JDBC to java 1.6? Thanks, Sopolin |
7. Database Connection Always disconnect when Developing on same PC as DB stackoverflow.comI am developing a JSP application and I used Oracle Express 10g as database. I notice when I try to develop in the same PC, I would only be able to ... |
8. How do I make my Java application identify itself to Oracle on connection? stackoverflow.comWhen my application connects to an Oracle database I want to be able to see by looking at the active sessions in the database that it is connected. Currently it identifies ... |
9. Connection timeout for DriverManager getConnection stackoverflow.comI am trying to connect to DB using the standard JDBC way |
10. Oracle connection compression? stackoverflow.comI have an application that uses JDBC to connect to Oracle 11g. Unfortunately, the machine my app is running on and the Oracle machine are connected via a somewhat low ... |
11. Oracle JDBC intermittent Connection Issue stackoverflow.comI am experiencing a very strange problem This is a very simple use of JDBC connecting to an Oracle database OS: Ubuntu Java Version: 1.5.0_16-b02 ... |
12. OracleDataSource connection caching - restarting connections? stackoverflow.comIs it possible to set the Oracle connection cache to restart cached connections after a period of time? |
13. oracle connection manager Java Client example stackoverflow.comI am new to oracle connection manager. Can some help me with a Java Client code example to talk to a oracle database thru oracle connection manager. Thanks Sam. |
14. Java JDBC connections and Oracle stackoverflow.comI have a scenario and the question follows
Application server has two connections pools to DB. |
15. Oracle ODI / Java - Active Directory connection trouble stackoverflow.comI want Oracle Data Integrator 10.1.3 to be able to connect to Active Directory running on a Windows 2003. I'm using SnpsLdapDriver but so far I'm dead unable to make it work. I ... |
16. Database connection encryption and integrity with ColdFusion and Oracle thin client stackoverflow.comAs ColdFusion datasource we are using the Oracle thin client to connect with the database. So, basically we are using a JDBC URL such as jdbc:oracle:thin:@... and as Driver Class oracle.jdbc.OracleDriver ... |
17. How to evict or "kill" open connections when these are above a fixed limit (using dbcp w/ oracle) stackoverflow.comDoes anyone know how to evict or kill open connections (in use or not it doesn't matter) if the number of connections is above of a fixed limit (e.g. maxActive) Currently ... |
18. Oracle connection not closing in Java Application stackoverflow.comI have a connection leak in some older Java web applications which do not utilize connection pooling. Trying to find the leak is hard because IT will not grant me access to ... |
19. IOException : The network adapter could not establish the connection stackoverflow.comI am trying to connect to an Oracle database from my Java application. I am using oracle.jdbc.driver.OracleDriver, Version : 0/1 to connect to the database. But DriverManager.getConnection() is giving me the ... |
20. how to (dynamically) determine optimal db number of connections? stackoverflow.comHow would you go about dynamically configuring the maximum number of connections in a DB connection pool? I've all but given up on using a "hard coded" (configuration file, but still) number ... |
21. Set Oracle 10g database connection timeout in Java stackoverflow.comI tried to set a connection timeout with the following code: |
22. set locale on Oracle connection stackoverflow.comIn my company's product, we retrieve results a page at a time from the database. Because of this all filtering and sorting must be done on the database. ... |
23. Oracle 10g connection with Java stackoverflow.comwhat are the drivers which are used to connect with java for Desktop application. i have found many types like tiny and all but was not able to understand. Please help ... |
24. Oracle java connection stackoverflow.comI have written a connection code with oracle. But still I am getting errors. I'll type the code of mine here. |
25. DriverManager.getConnection() returns null, rather than a connection object stackoverflow.comI am trying to connect to an Oracle database via JDBC. Using the following code: |
26. java.lang.ArrayIndexOutOfBoundsException when creating a connection to an Oracle database stackoverflow.comIt appears that Oracle's java client has a bug - if the |
27. Does Oracle DB support multiple (parallel) operations per connection? stackoverflow.comMy Java application needs to hold cursor to Oracle DB for some time. During it other DB statements have to be made. Does this require separate DB connections or same (cursor's ... |
28. JDBC .net connection possible stackoverflow.comIs it possible to use a JDBC connection in a VB.net application? I am unable to find any example code in order to connect to an Oracle Database using JDBC within ... |
29. scope of the connection object Con in jdbc stackoverflow.com*Syntax Error * I am facing the problem with my JDBC. In this line: |
30. How to reestablish a JDBC connection after a timeout? stackoverflow.comI have a long-running method which executes a large number of native SQL queries through the EntityManager (TopLink Essentials). Each query takes only milliseconds to run, but there are many thousands ... |
31. Closing Oracle connection? stackoverflow.comWe always hear that we should close the connection once we are done with a transaction. My question here is: even if we don't close the connection, the garbage collector will ... |
32. Implicit Connection Cache InactivityTimeout not working stackoverflow.comWe have a Java application which connects to Oracle database. The current issue is database connection created by the application is not cleared for days and this is cleared only after ... |
33. Oracle not providing osuser when there is a connection from a java program stackoverflow.comI am trying to connect to my remote oracle database, and it is locked down and has a white list of users and pc's that they can connect from. However, oracle ... |
34. Problem open scp connection from oracle database with java class stackoverflow.comWe have a java class into oracle database. Our java class opens a scp connection to a remote server to get a file, when the file is readed, the connection is ... |
35. Can jdbc connections be recovered? stackoverflow.comCan jdbc connections which are closed due to database un-availability be recovered. To give back ground I get following errors in sequence. It doesn't look to be manual re-start. The reason ... |
36. When using JDBC with Oracle DB how to find if the connection really timed out or if credentials were wrong? stackoverflow.comI already have the connection string and DBA username. I accept DBA password from the user. To check if the password provided by him is correct, I try to create a connection ... |
37. Is there a way to change an Oracle connection on the fly in Play! Framework? stackoverflow.comI currently work in a project where each user has his own schema in Oracle 11g DB. This design was done because all the security roles and privileges to access the ... |
38. HPC + Oracle Connections = Recipe for disaster? stackoverflow.comI am running a Java application on a HPC (High Performance Computing) cluster. The application makes a JDBC thin connection through to an Oracle 11.2.0 database. Given that this is on ... |
39. Autocommit mode for jdbc connection to Oracle from Java application stackoverflow.comDo I have to call |
40. Connections between java and oracle bytes.comHy, i want to use oracle as my database in my java project. But, i don't know how to make connections between java and oracle. Can anyone give me an example ... |
41. Oracle JDBC Connection Problem bytes.com |
42. JDBC connection to Oracle 8.0.5 coderanch.comBased on what you said, I did a quick view on oci805jdbc.dll. It requires 5 dlls ora805.dll core40.dll nlsrtl33.dll javai.dll kernel32.dll I am not sure how to check the visibility of it. This is the detailed error that I am getting: Exception in thread "main" java.lang.UnsatisfiedLinkError: C:\orawin95\BIN\oci80 5jdbc.dll: One of the library files needed to run this application cannot be found ... |
43. Using CMP, How To Establish Connection to the Oracle Database? coderanch.comI am working on a J2EE Project on the WebLogic 6.0 platform. I use the container managed persistence (CMP) and each table in my Oracle database is an entity bean. This is what I have been thinking: Every time I use an entity bean, I should establish the connection to the database. Therefore, I have written a utility class (DBConnection.java)(see the ... |
44. connection with oracle coderanch.com |
45. Oracle JDBC unable to get connection coderanch.comI just started learning JDBC and I have Oracle 8.1.7 and JDK1.3.1 installed on my computer. This is my autoexec.bat: set path=c:\jdk1.3.1\bin;c:\oracle\ora81\bin;c:\oracle\ora81\jdbc\lib; set classpath=c:\oracle\ora81\jdbc\lib\classes12.zip;c:\oracle\ora81\jdbc\lib\nls_charset12.zip 1. is this the correct setting ? the documentation said that classes12.zip is dedicated for jdk1.2 is there a specific oracle.jdbc.driver for jdk1.3? When I was installing oracle 8.1.7 ( downloaded from oracle site) I was asked ... |
46. Beqeath connection in Oracle coderanch.com |
47. Strange Oracle 9i connection problem coderanch.com |
48. Connection Problem from NAS to oracle 8.1.5 coderanch.comHi, I am facing problem in accessing oracle through NAS 4.0 ServicePack2.I am using oracle_oci driver.I have oracle server 8.1.5 installed on my machine (Windows NT 4.0) and NAS 4.0 on same machine.Is it ok to use oracle server 8.1.5? I can connect to oracle server through sqlplus. I am getting following error from NAS. error: ORCL-002: CreateConnInternal olog(): p [29/Jun/2002 ... |
49. JDBC thin /Oracle - Connection refused coderanch.comThis error appeared for me when the database exceeds the min-num of connections. May be you are making new connections and not releasing/closing it properly.. or you are trying to open&close&open ... in immediate succession.. in such cases .... Oracle has some "latency" in destroying the connections [it is marked inactive].. though Java releases the connection ... Hope you are using ... |
50. oracle connection with jdbc coderanch.com |
51. oracle temp space full?Didn't close JDBC connection coderanch.comDear all: my temp space is keep growing to full after I run some application with JDBC connection to retrieve data. I found sometime after I make the JDBC call then I forgot to close the connection. I am not sure the temp space full is causing the "unclose" JDBC connection or the stupid query I did becasuae I remember temp ... |
52. WSAD to ORACLE 9i connection coderanch.comHi All, I tried posting this in the websphere section but got no response so am trying it out here to see if anybody can help me out with the Websphere aplication Developer behaviour. I am getting a curious behaviour from WSAD when i connect to Oracle under different circumstances. When i create a new connection in WSAD (from DAta perpective... ... |
53. Need help with Jave Oracle Connection coderanch.comunfortunately, I don't think any java or Oracle info is gonna help us on this one from the oracle docs: "ORA-00600 internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string] Cause: This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this message include: ... |
54. Connection and Commit problems between Oracle and Java coderanch.comI have two questions. 1. Suppose an user modifies something on the screen and presses SAVE button and the back end (oracle) commits the data. Oracle passes the message to Java that the data is committed. Just before the java receives this info ... say we lost connection between Oracle and Java (Session between Java and Oracle is closed). Now the ... |
55. Problem with database connections between Java and Oracle coderanch.comRespected Sir, I am facing the problem in registering the driver of Oracle when I run the application from Tomcat 4.0.I have prepared a jsp through which I m sending the values of driver,url,userid and password to servlet which dispatches the request to bean in which I have written the code for connection with the database but when I execute this ... |
56. JDBC Oracle connection...not working coderanch.comOk, so I have just been introduced to the wonderful world of Java, and I am admittedly a little lost. I am trying to set a connection with an Oracle database, i just Tomcat and am running the latest Java SDK. I have copied my classes12.jar file out to every possible folder in the world. I have set up my JAVA_HOME, ... |
57. Connection not working (Oracle and Sun one web server) coderanch.com |
58. Strange problem in Tom CAT + oracle +JDBC connection coderanch.comDear Pallav, pelase provide following information 1. Are you getting any System.out.println on console 2. put your code in try catch block if it is not in try-catch 3. if you are getting any exception what is it 4. verify your classpath if oracle.jdbc.driver.OracleDriver is in your classpath hope after verifying these steps your problem will solve. |
60. Connection Establishment problem with Oracle coderanch.com |
61. Connection to Oracle Database coderanch.comI have oracle installed on my machine . Please any body can mail me a program that is using oracle as a database & performing any SQL query . Please mention also that which file I have to set in class path if any ? Please provide command for setting that file into class path . thanks . god bless you ... |
62. problem with jdbc oracle connection coderanch.comhi i have problem with jdbc connection.iam able to compile the program but iam unable to run it.i have set the classpath to classes102.zip,classes111.zip.and ihave also given correct sid inDriverManager.getConnection.iam getting the following error 1)Exception in thread main java.sql exception.Connection refused |
63. oracle connection problem coderanch.comhi.. i am using windows xp pro, Oracle 10g and jdk1.5. I am not able to connect to database through java program. Code is below: import java.sql.*; import java.io.*; public class matt { public static void main(String args[]) { String uid=args[0]; String pwd=args[1]; String name=args[2]; String age=args[3]; String qty=args[4]; String phno=args[5]; String secq=args[6]; String seca=args[7]; try { Class.forName("Oracle.jdbc.driver.OracleDriver"); Connection con=DriverManager.getConnection("jdbc: oracle:thin:@matt:1521","scott","tiger"); ... |
64. getting underlying oracle connection from Poolable connection coderanch.comHi, Iam want to pass an Array to a oracle procedure for which Iam using ArrayDescriptor. ArrayDescriptor descriptor = ArrayDescriptor.createDescriptor( "NUM_ARRAY", conn ); System.out.println("224"); ARRAY array_to_pass = new ARRAY( descriptor, conn, lRelVersions ); Now the problem is that it is giving me ClassCastException when I pass the Poolabale Connection in the ArrayDescriptor.createDescriptor(), as it requires Oracle Connection. Can anybody tell me ... |
65. JDBC connection in Oracle db coderanch.comHi, I have a simple application; I am not using connection pool & creating connection object on every request & closing the connection after completion of request. Ideally, number of connection at a time should be number of request at a time to the application; but it's not working like that; even if there are 5 users; it shows 60 connections ... |
66. jdbc connection with oracle 10g coderanch.com |
67. jdbc connection with oracle 10g coderanch.complease provide me the code what should i give at class.forName() and what to put in the getConnection() my user is hr and password is also hr as it was given by the product when i installed service name is oracle when i run this program it is throwing ClassNotFoundException and at getConnection method UnReportedException i have set the class path ... |
68. Cam i set catalog on connection with oracle coderanch.comHey, lets say i have a connection that i get from data source. The connection is to user XXX. can i change the user in run time? In my sql i point the data source to localhost:3306 and set the schema (catalog) in run time, can i do something like this in oracle? |
69. How to make connection from eclipse3.2 to oracle10g database? coderanch.comi installed both oracle10g and eclipse3.2... In one System OS->linux --- oracle10g server version installed in these. so i need to access that linux system oracle10g database. In my system eclipse3.2 and oracle10g client version installed, now how to config in eclispe and wht code shall i write...... please give me explain with code..... step in step |
70. jdbc connection with oracle coderanch.com |
71. Connection problem with oracle coderanch.comI am trying to connect to oracle 10 g databas on my local system. operating system is vista. A using netbeans IDE String url="jdbc:oracle:thin:@localhost:1521:orcl"; try { Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con; con=DriverManager.getConnection(url,"system","deepak"); java.sql.Statement stmt= con.createStatement(); java.sql.ResultSet rs= stmt.executeQuery("select * from kbs"); while(rs.next()) { System.out.println("values:"+rs.getInt(1)); } } catch(Exception e) { System.out.println("Error"); e.printStackTrace(); } } I checked tha database name using the following query: SQL> ... |
72. Oracle database connection coderanch.comYou need the driver. The driver is something that takes your makes your jdbc java calls, understandable to database. You will find the oracle driver in folder "jdbc" of oracle isntallation directory. The name of driver is "ojdbc14.jar". Put this driver(jar file), in your classpath, and the above application will run smoothly. |
73. Could not establish connection to Oracle 9i coderanch.comDear all, I met a database connection problem. I'm doing a project offshore, and it's fine while I try to connect to the Oracle 9i database here. But when deliver the code to the on site to have a test. It gives me a java.sql.SQLException: Io exception: The Network Adapter could not establish the connection And I've asked the on site ... |
74. JDBC connection in Oracle db coderanch.comHi, I have a simple application; I am not using connection pool & creating connection object on every request & closing the connection after completion of request. Ideally, number of connection at a time should be number of request at a time to the application; but it's not working like that; even if there are 5 users; it shows 60 connections ... |
75. new connection class to oracle database coderanch.comHi , We are planning to have new application where we are going to have oracle database and here we will have OLS ( ORacle label security ) implemented. Due to this we need to have a connection class which will be responsible for making connection to database based on user credentials . Gere we will have some defined user groups ... |
76. writing connection class to oracle coderanch.comHi , We are planning to have new application where we are going to have oracle database and here we will have OLS ( ORacle label security ) implemented. Due to this we need to have a connection class which will be responsible for making connection to database based on user credentials . Gere we will have some defined user groups ... |
77. Oracle.JDBC Connection Problem coderanch.comHello to everyone, I'm writing for first time at this forum. I have problem with my oracle Db connection. In my project libraries I've loaded ojdbc14.jar. I got 2 oracle errors.Please help. public class OracleDriverLoader { /** * @param args the command line arguments */ public static void main(String[] args) { Connection conn = null; try { Class.forName("oracle.jdbc.OracleDriver"); System.out.println("Oracle driver is ... |
78. JDBC connection in Oracle Application Server 10g coderanch.comHi guys, I have a war file with a simple JDBC connection. I didnt use DATA SOURCE coz im only using one table. I have my application developed using myeclipse and apache tomcat which is perfectly connecting to Oracle 10g Database. But when i uploaded the war file in the application server and tried to run the web app, it seems ... |
79. Oracle RAC intermittent connection coderanch.com |
80. Connection to an Oracle database fails coderanch.com |
81. Oracle JDBC - DSN Connection coderanch.com |
82. Oracle 10g Connection Settings Required coderanch.comHi, I have installed Oracle 10g in my Laptop. Global Database Name: orcl System Identifier(SID): orcl UsrName: scott Password: tiger I have installed Netbeans 6.9 . i have added odbc14 in libraries of Netbeans and in Drivers of Netbeans. I have also created Environment variable for the same. Whn i am trying to establish new database connection using this Oracle thin ... |
83. connection of JDBC with oracle 9i database coderanch.com |
84. JDBC connection with oracle 10g coderanch.comimport java.sql.Connection; import java.sql.Driver; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.Statement; import java.util.Properties; public class OracleConnect { public static void main(String s[]) throws Exception { Driver d = (Driver) Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); Properties p = new Properties(); p.put("user", "scott"); p.put("password", "tiger"); Connection con = d.connect("jdbc:oracle:thin:@oracle:8080:STUDENTINFO",p); Statement st = con.createStatement(); ResultSet rs = st.executeQuery("select * from StudentInfo"); ResultSetMetaData rsmd = rs.getMetaData(); System.out.println("Table Name ... |
85. JDBC - Oracle connection problem dbforums.comI could use some help!!! Java is new to me, so please forgive me.... I'm making my first attempt to access a database. I have Oracle 9.0.1.1.1 database installed locally on my pc (Windows xp). I have J2SDK1.4.2_01 installed. And the classes12.zip file exists in C:\oracle\Ora9iDB\jdbc\lib. The entry in my tnsnames file is LOCAL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = ... |
86. Connection Oracle using Java java-forums.orgConnection Oracle using Java Please, could anyone help me? I cannot connect this code with Oracle database.. Can anyone to check if is there any problem in my code, and if the classes are correct? ===================== Connect Oracle ------------------------- import java.util.SQLTools; import java.sql.*; import java.util.ArrayList; import java.util.Collection; public class ConnectOracle { private static String executeQuery = null; private String ... |
87. Oracle connection and register java-forums.orgI am trying to maek oracle connection , then SP call String sql = begin ? := p_get_Params (?); end; CallableStatement cst con.prepareCall(sql); cst.registerOutParameter(1, OracleTypes.CURSOR); //this is for SP returning Result set cst.registerOutParameter(1, OracleTypes.INTEGER); //this is for SP Performing update The java prorgam does not understand OracleTypes. What do I have to do in such case? Did I missed something? Thanks, ... |
88. JDBC Oracle Connection java-forums.orgI've searched, and tried many things, but cannot get an Oracle connection to work on our server...it works on my developement PC, but I move my .jar to the server and I get: Exception in thread "main" java.lang.NoClassDefFoundError: oracle/jdbc/Oracle Driver I started out with just the JRE installed, but have since installed the JDK in hopes that would solve it. I ... |
89. Java connection to an oracle database forums.oracle.com |
90. Making https: connection from java code loaded into Oracle 8i database forums.oracle.com |
91. Connection session is not closing on Oracle data base forums.oracle.comIt is a very large appl it invoked database connection at several place on of them as below, Vector userTasks = new Vector(); try { Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery( "SELECT * FROM V_USER_TASKS WHERE LOGIN_CODE = '" + getLoginCode() + "' AND COUNTRY_CODE = '" + countryCode + "' AND TASK_CODE= '" + taskCode + "'" ); ... |
92. JDBC connection with Oracle forums.oracle.com |
93. Oracle connection -caching closing connections forums.oracle.comI am using Oracle connection caching mechanism in my java application. There are 4 different process that access same persistence class to get connections from the cache, do db related work and close the connection. Now I am implementing graceful shutdown mechanism that will close the connection if some kill signal is being given to the process. So inside my each ... |
94. problem with connection to oracle dtatabse forums.oracle.com |
95. establishing connection to Oracle forums.oracle.comIn MyEclipse 6, which is based on Eclipse 3.3.0, you do the following: - right click the project and select 'properties from the popup menu or 'project/properties' from the main menu if you have the project open. - in the 'properties for your-project' dialog, choose 'Java Build Path' - use the 'libraries' tab to add and remove libraries. If you have ... |
96. database connection problem with oracle 10g forums.oracle.comHello every body, when connect to oracle 10g with java .am getting these many exceptions. My database is on remote system.i fallowed this steps for connecting database: DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); con=DriverManager.getConnection("jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=indus64.induscorpindia.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)(SERVER = DEDICATED)))", "SYSTEM", "bangaloreindus"); when i run this code: am getting these many exceptions: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection Please help me .. urgent .. ... |
97. What's the best approach for handeling about 1300 connections in Oracle. forums.oracle.comWhat's the best approach for handling about 1300 connections in Oracle 9i/10g through a Java application? 1.Using separate schema s for various type users(We can store only relevant data with a particular schema. Then No. of records per table can be reduced by replicating tables but we have to maintain all data with a another schema Then we need update two ... |
98. Oracle doesn't commit when calling connection.commit() forums.oracle.comThank you Yes, I am sure 99% that is Geronimo server problem as my code is working fine with Websphere . I am looking for the solution in Geronimo. It seems doesn't understand when I directly call commit() . If I just leave the auto commit alone, then it works but how can I be sure that I can roll back ... |