connect 1 « oracle « Java Database Q&A





1. How to avoid storing credentials to connect to Oracle with JDBC?    stackoverflow.com

Is it possible to setup a JDBC connection to Oracle without providing username/password information in a configuration file (or in any other standard readable location)? Typically applications have a configuration file that ...

2. How to connect to Oracle using JRuby & JDBC    stackoverflow.com

First approach: bare metal

require 'java'
require 'rubygems'
require "c:/ruby/jruby-1.2.0/lib/ojdbc14.jar"  # should be redundant, but tried it anyway
odriver = Java::JavaClass.for_name("oracle.jdbc.driver.OracleDriver")
puts odriver.java_class
url = "jdbc:oracle:thin:@myhost:1521:mydb"
puts "About to connect..."
con = java.sql.DriverManager.getConnection(url, "myuser", "mypassword");
if con
   ...

3. Connect to a secure database using JDBC    stackoverflow.com

How do you specify the username and password for a JDBC connection when acessing a secure database?

4. Requirements for connecting to Oracle with JDBC?    stackoverflow.com

I'm a newbie to Java-related web development, and I can't seem to get a simple program with JDBC working. I'm using off-the-shelf Oracle 10g XE and the Eclipse EE IDE. ...

5. How can I connect to an Oracle database from Ant using the tnsname?    stackoverflow.com

I am looking for something similar to the Ant sql task but that will accept a JDBC url of the format:

jdbc:oracle:thin:@TNS_NAME
One possible approach seems to be to ...

6. How can I connect to a web based Oracle database with Java?    stackoverflow.com

I have an account, password and the URL.

7. Help me connecting java and oracle    stackoverflow.com

Can anybody explain me these classes and methods?

DriverManager.registerDriver
(new oracle.jdbc.driver.OracleDriver());
conn = java.sql.DriverManager.getConnection(
"jdb:ocracle:thin:username/password@machine.us.company.com:1234:dbSID");
Thanks

8. Connect to an Oracle cluster in Java    stackoverflow.com

We have a pair of Oracle servers which are set up as nodes in a cluster (apologies if my terminology is way off). In my tnsnames.ora file, we have an ...

9. connect to oracledb in java    stackoverflow.com

I work in a big company and need to connect to a oracle database. It is set up so that i can connect to it through DSN, but I would like ...





10. Problems connecting to Oracle database from Java classes (ocijdbc11.dll)    stackoverflow.com

I have some database import and export ant scripts that run little java programs to import and export data to and from oracle 11g. The scripts used to work on Vista 32 ...

11. Connect to an oracle db in jdbc over an SSH tunnel    stackoverflow.com

Currently we have to tunnel over SSH to access our Oracle database. In order to do this we have to make sure than putty or an equivalent program/script is running ...

12. Problem in connecting Oracle 11g through JDBC thin driver ( Domino Java )    stackoverflow.com

I'm unable to connect Oracle 11 database remotely using following piece of code. However, same code works fine if I try to connect Oracle 9 database which is installed on my ...

13. problem in connecting to oracle 10g express edition through java    stackoverflow.com

I'm unable to connect Oracle 10g database.I am getting exception java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDriver The code is:

try {
    Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(ClassNotFoundException e) {
    e.printStackTrace();
}

try {
    con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:system","user" ,"pass");
   ...

14. connect to Oracle db with JDBC driver. How set charSet?    stackoverflow.com

I need connect to Oracle database use jdbc driver. I look on structure URL string to connect and not see, where i xan set charSet to connect. Help me please.

15. How to connect to RMAN in Java?    stackoverflow.com

I don't know how to connect to RMAN in Java. Simple request don't work when I use command non-SQL, like RMAN etc... I'm gonna to make program like "ORACLE Secure BackUP", ...

16. How connect to Java program from Oracle    stackoverflow.com

I want to copy a folder and everything that is included in it to a FTP by oracle. I found out this work is a little bit hard with Oracle so I ...





17. Java JDBC - How to connect to Oracle using Service Name instead of SID    stackoverflow.com

I have a Java application that uses JDBC (via JPA) that was connecting to a development database using hostname, port and Oracle SID, like this: jdbc:oracle:thin:@oracle.hostserver1.mydomain.ca:1521:XYZ XYZ was the Oracle SID. Now I ...

18. TNS-12505: TNS:listener does not currently know of SID given in connect descriptor    stackoverflow.com

Hey guys. Looks like im having the same issue all the oracle newbies once experienced. Im trying to connect to Oracle 10.2.0 from NetBeans, using the following connection string:

jdbc:oracle:thin:@localhost:1521:XE
The weirdest part is that ...

19. Problem connecting to Database    stackoverflow.com

I just got a mail from my DB adminstrator with these details The environment is :

Server :      hpsd1805
Listener :    1234
SID :    ...

20. Oracle CONNECT BY in java    stackoverflow.com

I am thinking how would I traverse a resultset in java the data fetched by CONNECT BY caluse to form a tree like structure in java, i.e. populate a tree from ...

21. Connect oracle 11g database using java 1.7    stackoverflow.com

Please help me.I have installed Oracle 11g on Windows 7 (32 bit) and i'm trying to connect database with jdk 1.7 but i get an error saying package oracle.jdbc.driver does not exist ...

22. First test in each test suite fails connecting to the DB    stackoverflow.com

We are running more than 2000 junit, Most of the tests connect to an Oracle database with jdbc calls. We have a problem with very few of the tests that can ...

23. What is the benefit of using java.util.properties while connecting to database?    stackoverflow.com

I was reading Oreilly Java Programming With Oracle JDBC edition and I notice that there was one example using java.util.properties object like below;

public class Connector {


    ...

24. Connecting from Java to Personal Oracle 8    coderanch.com

import java.sql.*; public class auguro { public static void main(String args[]) { String url = "jdbc:inetora"; String login = "scott"; // use your login here String password = "tiger"; // use your password here try { Class.forName("com.inet.ora.OraDriver").newInstance(); Connection connection = DriverManager.getConnection(url,login,password); DatabaseMetaData conMD = connection.getMetaData(); System.out.println("Driver Name:\t" + conMD.getDriverName()); System.out.println("Driver Version:\t" + conMD.getDriverVersion()); Statement st = connection.createStatement(); ResultSet rs = st.executeQuery("SELECT ...

25. How to connect javascript page with Oracle (or any other database) ?    coderanch.com

I have my own home site: http://members.spree.com/fa,ily/acpoxon1 and it have every thing that one need in his/her home site. Now, i wanna make a page were u enter the query and when u prees enter it display the message on the same page (i know how to do this but in that i need to send this information or the message ...

26. Cant Connect to Oracle via JDBC    coderanch.com

Hi, I have a Java app that needs to query an oracle database. I developed the app under JBuilder 4 and it connects the database just fine. But, when I try to run outside of JBuilder I 'm getting the following error: Specified Driver could not be loaded due to system error 126 (Oracle ODBC Driver) TIA, Art

27. Unable to connect to oracle usin type 4 thin    coderanch.com

hi I was trying to connect to oracle Database using type 4 thin drivers on win98. I downloaded the driver from oracle site and also downloaded some more drivers from other sites.While connecting to data base I ran into problems I am working for about two days on this thing but couldn't succeed. I get the following message: Connection refused ........... ...

28. novice: want to connect to oracle    coderanch.com

I'm working with Horton's beginning java book, and can do the examples with Access, but I want to try with oracle. I downloaded the driver from oracle, a zip with about 40 separate files. I am a bit overwhelmed, and just want to repeat what I did with the access database from the Ivor Horton beginning Java book. That was easy ...

29. Connecting to an Oracle 8i Database    coderanch.com

I have searched through Java Ranch with no real answers to this question. So I post it here. I get two errors when trying to connect to my local Oracle 8i Database when compiling my Java program. I am running this database on my laptop, affectionately called "laptop", running Windows 2000 Professional. My database is called "POS" with a username of ...

30. how to connect to Oracle using TNS name    coderanch.com

33. Connecting Oracle 8x    coderanch.com

Hi, i have this code to connect to the Oracle 8.1.7 Database, i'm using JDK 1.2.2, and in my classpath i only have the classes12.zip, this is my code import java.sql.*; import java.text.*; import oracle.jdbc.driver.*; public class TestInsert{ public static void main(String args[]){ Connection dbConnection = conectaDB(); PreparedStatement pstmt = null; try{ pstmt = dbConnection.prepareStatement("INSERT INTO XPASO VALUES('" + args[0] + ...

34. Connect to a local Oracle database    coderanch.com

35. Can't connect to Oracle Server except while on Server?    coderanch.com

I wrote a program which I can use to access an Oracle 9i Database I set up. However, this program will only work when run on my server machine. I cannot get it to work from any client. Can anyone help me out with this? On the client I have set the database and it works where I can login through ...

36. connect JDBC to ORACLE 8i    coderanch.com

38. I have a question on connect to oracle 9i    coderanch.com

I use nt2000 sp3 and I want to use test.java to connnect the oracle 9i which is installed on solaris 2.7 . I have search a lot of the docs about this topic ,but i still have some question not been solved . Now states is I can use the test.java to connect to the other oracle on ntserver ,and the ...

39. Newbie: How doy I connect to Oracle Using JDBC    coderanch.com

The next code tells me that -> " Invalid Oracle URL specified: OracleDriver.connect" import java.sql.*; What is wrong??? Please help!!! public class Cafe { public static void main(String args[]) { try{ Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con = DriverManager.getConnection("jdbc:oracle:oci8@1.2.3.4:1521:O RCL","user","pass"); Statement sta = con.createStatement(); ResultSet rs = sta.executeQuery("select 'hola' from dual;"); } catch(java.lang.ClassNotFoundException e) { System.err.print("Class not Found: "); System.err.println(e.getMessage()); } catch (SQLException ex) ...

40. Connecting to Oracle    coderanch.com

41. How do you connect Java 1.4.1 to Oracle 8i    coderanch.com

Hi all, I have seen similar posts and replies but they are 2-3 years old. Are there any recent instructions on how to connect a Java application to Oracle 8i's Enterprise Edition? I have both installed on my standalone PC running Windows98 at home and am practicing. I already have MS Access and want to move on to Oracle. Thanks in ...

43. I cann't connect the oracle database!    coderanch.com

44. Problem in connecting to oracle 8i from java application    coderanch.com

This could be related to a host of things: a. The app server (or ur machine's app server) is not able to see the oracle database server b. the oracle listener process is not running c. u have used a different service name while setting up the oracle data source Can you connec to the oracle instance from any other program ...

45. How to connect to Oracle db using TNS    coderanch.com

I'm able to use the thin client to connect to the db, but can't figure out the syntax for connecting using TNS. Our db group here has put the TNS files onto a common server, and instucted us to us the TNS name only. It works ok using Toad, and when I write C# programs I don't have a problem. Does ...

47. problem in connecting to oracle through jdbc    coderanch.com

I tried java -classpath "path to class12.zip;path to my java program" CheckOra Still I am getting "Class not found" How do I check I have all the ODBC/JDBC drivers/classes reqd in my system? I have Oracle 8.1.6.0.0 on win 2000 server with sp1 Lakshmi [ April 04, 2004: Message edited by: Sri Lakshmi ]

48. Connecting to Oracle 7 thru jdbc    coderanch.com

Hi there again, Thanks for the reply. I am running Tomcat 4 on Linux Redhat 6. I am not sure how the database administrator set the drivers up or which drivers I am using. I do know that by testing the database connection using a normal java program from the command line does work and does return data from the oracle ...

49. how to connect java with oracle rdb    coderanch.com

Hey! Guys, I am new to this forum. It looked greatly helpful so I thought maybe any one of you might have some information on this. I am developing an application to connect a jsp page to a RDB database which is running on OPENVMS VAX (not ALPHA) platform. It seems like there are JDBC drivers to connect to RDB for ...

50. type 4 driver syntax and how to connect to oracle with type 4 drivers    coderanch.com

i have just been throught the oracle site that it supports type 4 connectivity. so someone please guide me how to connect to oracle from a js page using type 4 drivers. do i have to look for some jar files in the pracle 9 installation that i need to specify in the classpath or is there a different approach to ...

51. Connecting to MS Access using Oracle stored procedures and JDBC    coderanch.com

Simple answer is: you can't. What I'd do, if you are stuck using the poor excuse for a database Access is, is create the model currently held in Access as a schema in Oracle, then use the linked table manager in Access to link to it. Now you can access your data with any Oracle feature, but still have an Access ...

52. connect to oracle without hardcoding IP address    coderanch.com

For connecting to Oracle using the SQL*Plus terminal, Oracle's tnsnames.ora file lets you specify multiple IP addresses that you can connect to (in case one of the machines hosting the database is down--yes, we're setting up a grid in Oracle 10g). However, in our Java web app, we're using the pure Java thin client driver and the only thing I know ...

54. Can't connect to Oracle database    coderanch.com

Hi all, I am having a bit of a problem making a simple database connection. Here is my code: package com.my.example.model; import java.sql.*; import java.io.*; import java.util.*; import javax.sql.*; import javax.servlet.http.*; public class OraConn { public Connection getConn() { Connection oraConn = null; try { //load the driver class - this is where my problem is Class.forName ("oracle.jdbc.OracleDriver"); String sourceURL; sourceURL ...

55. how do i connect java to my oracle server i,m just beginning on jdbc    coderanch.com

I copied this technique from somewhere ... any expert opinions on whether it's good or bad? protected void registerDriver(String DRIVER_CLASS) throws Exception { Driver driver = (Driver) Class.forName(DRIVER_CLASS).newInstance(); DriverManager.registerDriver(driver); } ==== public class DBWrapperOracle extends DBWrapper { private static final String DRIVER_CLASS = "oracle.jdbc.driver.OracleDriver"; protected DBWrapperOracle() throws Exception { super.registerDriver(DRIVER_CLASS); } public void connect(String aUserid, String aPassword, String aName) throws Exception ...

56. unable to connect to oracle database    coderanch.com

The problem is not Java in this case. You are loading the Oracle driver correctly, or you wouldn't be getting an Oracle error message. Here's the description of the error, from the official Oracle documentation at (http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76999/e900.htm#1656): ORA-01034 ORACLE not available Cause: Oracle was not started. Possible causes include the following: The SGA requires more space than was allocated for it. ...

57. connecting to oracle database    coderanch.com

Hi, I was trying to connect to oracle9i Database using type 3 thin drivers on winxp pro.I downloaded the driver from oracle site. While connecting to data base I ran into problems. I'm able to eastablish the connection even if the host name is not given. I'm not sure what may be the problem. I tried the same code on another ...

58. Driver to connect to Oracle    coderanch.com

59. Driver to connect to Oracle    coderanch.com

60. connecting to oracle db problem    coderanch.com

hi all I've written a piece of code to connect to an oracle database. for some reasons I couldn't log on correctly. And I am sure the username and password are both correct for I can log on without a problem in web browser.I've debugged the code and found that the program always stopped on making connection(the line I use bold ...

61. oracle DB not connecting    coderanch.com

TRP prasad, Welcome to JavaRanch! We're pleased to have you here with us in the JDBC forum, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it. In particular, your display name must be a ...

62. how to connect JDBC with oracle 9i    coderanch.com

64. Connecting with Oracle Thin Driver    coderanch.com

65. Cannot connect to Oracle Database No suitable Driver    coderanch.com

All: Any help rendered would be appreciated. (jdk 1.4.2_06, Tomcat 4.0, Oracle DB 9i Windows XP) I have a web app (Jasper report tool) and I cannot connect to a Oracle 9i database. 1)error received: "Apr 2, 2007 2:05:15 PM com.entDB.Enterprise_db connectToDatabase SEVERE: Function connectToDatabase() - Cannot load the driver, reason:java.sql.SQLException: No suitable driverCheck classpath for driver java.sql.SQLException: No suitable driver ...

66. Connecting oracle without creating DSN    coderanch.com

67. connecting with oracle    coderanch.com

68. How can i connect Oracle10g with my webapplication    coderanch.com

Hi every one, I could not able to connect oracle10g with my jsp web application, While i am connecting oracle with jsp, even i could not able to open the homepage of tomcat itself, by giving URL http://localhost:8080/ I do not what happened after my oracle 10g installation in my system, while i am trying to open homepage of tomcat which ...

69. can't connect to oracle database    coderanch.com

Originally posted by Wilbert Reyes: hi paul, i've checked the services (btw, i'm using windows xp) and the TNSListener is running...what i understand here that the 1575 and the 1630 are the ports to be used, right? thanks in advance [ November 05, 2007: Message edited by: Wilbert Reyes ] Not necessarily... you should use the one that is configured with ...

70. Problem in connecting Oracle thru Java    coderanch.com

I have installed Oracle 9i and I want to connect to it using thin driver. I have used the following code,but I am getting the below error I don't know the default database name. How to find the default database name. The tables like emp,bonus,dept are in the default database while installing oracle 9i. How to find the db name. How ...

71. Using JDBC to connect oracle    coderanch.com

Hi everyone, I am using oracle 10g, my jdk is 1.4 and my IDE is eclipse and I am trying to connect the oracle data base with the following code, but I am always getting some exception. I know time is precious. import java.sql.*; import java.io.*; public class NotesDB2 { public static void main(String[] args) throws SQLException, IOException{ System.out.println ("Loading Oracle ...

72. Connecting to Oracle from Java    coderanch.com

Hi All, I am hosting a application which is runnind well on a Unix Dev region to my own local PC. Also the appserver in dev is websphere, but I am now hosting it on Weblogic. I am getting DB connection error as follows. Help is appreciated. The system uses these 2 classes import oracle.jdbc.pool.OracleConnectionCacheImpl; import oracle.jdbc.pool.OracleConnectionPoolDataSource; and sets all the ...

73. how to connect to Oracle through jdbc    coderanch.com

74. Installed Oracle 10g in my Local system and now I am having problem connecting to it    coderanch.com

Hi I HAVE A SAME PROBLEM............ I have the following information in my classpath. C:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14_g.jar;C:\oracle\product\10.2.0\db_1\jdbc\lib\classes12.jar;C:\oracle\product\10.2.0\db_1\jdbc\lib;C:\Program Files\Java\jdk1.5.0_17\bin;C:\Download;C:\;C:\Program Files\Java\jre6\lib\ext\QTJava.zip Following Location where I have classes classes12.jar and classes12.zip files exists. C:\oracle\product\10.2.0\db_1\jdbc\lib What else I have to put it in Classpath? JAVA VERSION java version "1.6.0_13" IF I RUN THE FOLLOWING COMMAND jar tvf C:\oracle\product\10.2.0\db_1\jdbc\lib\classes12.jar oracle\jdbc\driver\OracleDriver.class I get the following line 13666 Wed Jun ...

75. problem in connecting oracle database    coderanch.com

76. Connect to Oracle as dba    coderanch.com

77. oracle9i not being connect    coderanch.com

my program is compiling,after running my program one prompt is opening prompt title is Microsoft odbc for oracle. its saying The Oracle(tm) client and networking components were not found.These components are supplied by Oracle Corporation and are part of the Oracle version 7.3(or greater) client software installation You will be unable to use this driver until these components have been installed. ...

79. connecting jdbc with oracle    coderanch.com

80. Connecting to an Oracle DB    coderanch.com

I have tried this in Netbeans and was able to connect and write data to a table, but not query(kept getting an error on the SQL statement). Anyways I am working on this from scratch not using NetBeand and would like to know how I connect to a DB and get data from it. NetBeans seems to use an entity manager, ...

81. connect oracle database    coderanch.com

82. JDBC connect to Oracle 11g    coderanch.com

83. How to connect Oracle with Java    coderanch.com

ok.i understood that i dont need a server to connect oracle with java. i have created an Oracle database . i have a java program which uses jdbc -odbc driver set for connecting it with Oracle. there are 4 types of jdbc drivers . only one type can be used for connecting with odbc driver. which type should i use and ...

84. Cant connect to oracle.    coderanch.com

85. Which way in JAVA is the best and modern to connect Oracle    coderanch.com

The best way to do this is to try them out. The upsides and downsides become fairly obvious when you get your hands dirty. If you just need to read some opinions other people have, the ORM forum is has discussions about this frequently. A bit of searchign will get you some things to think about quickly enough.

86. problem in connecting to oracle database.    coderanch.com

static String ORA_USERNAME = "hr"; static String ORA_PASSWORD = "phuoc1989"; static String ORA_SERVERNAME = "PhuocNH-PC"; static String ORA_PORTNUMBER = "1521"; static String ORA_DBNAME = "orcl"; String url = "jdbc:oracle:thin:@" + ORA_SERVERNAME + ":" + ORA_PORTNUMBER + ":" + ORA_DBNAME; Connection connection = null; static Statement stm = null; static ResultSet rs = null; static int result = 0 ; public void ...

87. not able to connect to oracle DB    coderanch.com

public class LoginServlet extends HttpServlet { private static final long serialVersionUID = 1L; PrintWriter out; protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { Connection connection = null; Statement statement = null; ResultSet rs = null; response.setContentType("text/html"); out=response.getWriter(); String uname=request.getParameter("username"); String upwd=request.getParameter("password"); try { // connecting to database /*Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); connection=DriverManager.getConnection("jdbc:odbc:rk","system","password");*/ Class.forName("oracle.jdbc.driver.OracleDriver"); connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","password"); statement = connection.createStatement(); rs = statement.executeQuery("SELECT ...

88. connect oracle from java application    coderanch.com

Well if you don't have Aqua Studio, you can use any other tool like Toad or even SQL Plus that comes with Oracle itself. Idea here is to check whether are you able to connect to oracle database. If connection from Toad or SQL Plus is also not working then the problem lies at somewhere else. If connection is fine with ...

89. Connecting Multiple Oracle Databases with one Application    coderanch.com

Hi All, I have to communicate with more then 50 Oracle databases from a single application , how can i achieve this ? If i am succeeded in this then i have to check the performance with several databases by firing the queries to each one. Please share your ideas as i have only worked with MySql . Thanks in advance. ...

90. Connecting to Oracle using JNI    dbforums.com

Hi, I am working on AIX 4.3.3 OS.When i use JNI to connect to the native libraries written in C++ which in turn connects to Oracle 8.1.7, i observe that JDK1.2.2 connects to Oracle as expected but JDK 1.3.1(32 bit) does not connect to Oracle and throws ORA-03114 error and a SQLSTATE of 63000.What can be the reason for the connection ...

91. Help me connecting java and oracle    java-forums.org

92. Oracle Connect thru register driver    java-forums.org

I have been using the Oracle .jar files to connect the IDE (Netbeans and Eclipse). Using the jar files did help me through many personal projects I have accomplished. But I was wondering. 1.) Is there an alternative way to connect the Oracle DB without the use of the .jar files. What I am to avoid is the lib folder created ...

93. cannot connect to oracle DB    java-forums.org

package connection; import java.sql.DriverManager; import java.sql.Connection; import java.sql.*; public class connection { public static void main(String[] args) throws SQLException{ try{ Class.forName("oracle.jdbc.OracleDriver"); System.out.println("Chargement du driver jdbc ds la JVM russie"); Connection con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:GLOBAL","SYSTEM", "manager"); System.out.println("Connexion russite"); Statement stmtCode = con.createStatement(); ResultSet rs = stmtCode.executeQuery("select note1,note2 from T2"); while(rs.next()) System.out.println(rs.getFloat(1) + " " + rs.getFloat(2)); rs.close(); } catch(Exception e) { e.printStackTrace(); } ...

94. unable to connect to oracle db using type 4 driver    java-forums.org

Hi I am ussing oracle BD 11g with netbeans. I hav downloaded ojdbc6.jar and added to the drivers list of netbeans but when I try to load driver via the below code it return classnotfound exception...plz help /* * To change this template, choose Tools | Templates * and open the template in the editor. */ package newpackage; import java.sql.*; /** ...

95. Newby Needs Help Connecting to Oracle Database    forums.oracle.com

If I just run it, this is the output: let's connect I'm connected Unable to connect! So, it looks like it may be connecting, at least it runs the line that establishes the connection then the next line which prints a comment. However, it seems to fail at some point thereafter. I've tried debugging it and as far as I can ...

96. Unable to connect to oracle database    forums.oracle.com

the error returned is [java/sql/Savepoint]: java.lang.NoClassDefFoundError: java/sql/Savepoint at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:547) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:347) at java.sql.DriverManager.getConnection(DriverManager.java:543) at java.sql.DriverManager.getConnection(DriverManager.java:194) at org.apache.jsp._index._jspService(_index.java:76) at com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java:89) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.ibm.ws.webcontainer.jsp.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:357) at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.serviceJspFile(JspServlet.java:675) at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.service(JspServlet.java:773) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174) at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116) at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283) at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42) at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:948) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:530) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:176) at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79) at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:201) at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71) at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182) at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334) at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56) ...

97. Trouble Connecting to Oracle DB    forums.oracle.com

Thank You! I shall read the other threads now. Thats from javac -version C:\Documents and Settings\morrisg\Desktop\Java\myJava\New Folder>javac -version javac: invalid flag: -version Usage: javac where possible options include: -g Generate all debugging info -g:none Generate no debugging info -g:{lines,vars,source} Generate only some debugging info -nowarn Generate no warnings -verbose Output messages about what the compiler is doing -deprecation ...

98. How to connect to oracle jdbc?    forums.oracle.com

I still can't get it. It said: # Thin Driver, a 100% Java driver for client-side use without an Oracle installation, particularly with applets. The Thin driver type is thin. To connect user scott with password tiger to a database with SID (system identifier) orcl through port 1521 of host myhost, using the Thin driver, you would write : Connection conn ...

99. Connect to Oracle    forums.oracle.com

I need your Help in Connect to oracle 10g DataBas my code is : import java.io.*; import java.sql.*; import java.util.Properties; import oracle.jdbc.driver.OracleConnection; public class OraThin { public static void main(String[] args) { try { Connection con=null; Class.forName("oracle.jdbc.driver.OracleDriver"); con=DriverManager.getConnection("jdbc:oracle:thin:@10.0.31.66:1521:ETTST","dbvamalra","dbvamalra"); Statement s=con.createStatement(); s.execute("INSERT INTO BOOKS VALUES('A Tale of Two Cities','William Shakespeare',4567891231,'5-JAN-1962')"); s.close(); con.close(); } catch(Exception e){e.printStackTrace();} } } when i Copile it i ...

100. connecting to a oracle database    forums.oracle.com

I am using Oracle 10g express addition I simply want to connect to and insert a line of data. I have created the table "user" already so the code below should work but i get the error java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver where do i get the oracle driver from? Thanks for any help! import java.util.*; import java.sql.*; public class TestDBOracle { public static ...