Connect To Database Through JDBC?

Jul 17, 2013

have a problem while i am trying to connect to database through JDBC here is my code,i am using oracle11g express edition import java.sql.

Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.Statement;    public class connectiontoDB {    public static void main(String[] args) throws Exception {  // TODO Auto-generated method stub  try{  Class.forName("oracle.jdbc.driver.OracleDriver");  Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","citi","citi");        Statement stmt=con.createStatement();        stmt.executeUpdate("create table user(id number(10))");        System.out.println("connected to database successfully");  }  catch(Exception e){       e.printStackTrace();

View 1 Replies


ADVERTISEMENT

NL Exception Trying To Connect To 10g RAC With JDBC

Jan 11, 2005

I'm trying to connect to multiple Oracle 10g databases (failover) over the JDBC thin client, and when I run the following, I get: java.sql. SQLException: Io exception: NL Exception was generated

connection = DriverManager.getConnection("jdbc:oracle:thin:@DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = dbdev) (PORT = 1521))) (CONNECT_DATA = (INSTANCE_NAME = orcldev)))", "scott", "tiger");

I eventually want to put multiple ADDRESSes in that string, but right now I'm trying to get it to work with just one! I've tried multiple variations of this, like changing INSTANCE_NAME to SID or SERVICE_NAME, and using the internal IP address for the HOST dbdev (see below). Here's the tnsnames.ora file used by SQL*Plus on the same client machine:

ORCLDEV.world =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.132)(PORT = 1521))
(CONNECT_DATA =
(SID = orcldev)
)
)

View 7 Replies View Related

Use Scan Name In Tnsfile - Not Able To Connect To DB Through JDBC Connection?

Aug 4, 2010

I have installed 2 node RAC -11gR2 on ORACLE VM Server 2.2.1.now, I want to give tnsentry to my dev team to use this RACDB going forward.I am using scan name in tnsnames.ora file. Also I have make scan name entry in /etc/hosts not in the DNS.

I have below entry in RACDB server...
RACDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = RWCORA-cluster-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
)

now just for testing purpose, I added this tnsentry in my machine to check the connectivity.I have to add scan name with IP address in /etc/hosts --. and try to connect sqlplus sys@rwcdb as sysdba --> not workingI have to add scan name with IP address , and two RAC VIPs (of both nodes) in /etc/hosts -- and try to connect sqlplus sys@rwcdb as sysdba --> then its working...but again SQL*Developer is not able to connect.

I have make below entry in my machine's /etc/hosts file:

10.40.0.51 RWCORARAC1-vip
10.40.0.52 RWCORARAC2-vip
10.40.0.50 RWCORA-cluster-scan

perfect link through which I can connect OCI, JDBC connection from client side.

View 4 Replies View Related

Networking And Gateways :: Unable To Connect To ORACLE ODA 11g - JDBC Connection Error

Aug 21, 2013

I am not able to connect to ORACLE ODA 11g. but using sqlplus its getting connected with below credential.

URL------------------- jdbc:oracle:thin:sacblmdbuser/sacblmdbuser@10.66.12.229:1521:OVPINHA
Oracle JDBC driver loaded ok.
Unable to create connection
java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186647296)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

View 2 Replies View Related

Client Tools :: Cannot Connect Using JDBC Oracle Thin Client With (New Method)?

Feb 21, 2013

The problem is that this connection errors when I try to connect using my SQuirreL client. My developers want to connecting using the SID or the SERVICE_NAME and by using the "New Method" syntax, not the "Old Method" syntax. According to the documentation the "New Method" syntax works with the SERVICE_NAME or the SID. The "Old Method" only works with the SID.

# Host name is vmwwin7634.na.SAS.com
# SID is sting2
# SERVICE_NAME is sting2.na.sas.com

PROBLEM using SID errors ==> jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2
THIS WORKS using SERVICE_NAME ==> jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2.na.sas.com

I am using SQuirreL Client version 3.4.0

# Here is the tnsnames.ora entry on the server.
STING2 =
(DESCRIPTION =

[code]...

# In this documentation it says, "On new syntax SERVICE may be a oracle service name or a SID."You can find this on the orafax wiki under JDBC#Thin_driver.

# I was able to connect with the "old method" using the SID only, SERVICE_NAME errors jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521:sting2.na.sas.com
(SQuirreL client error, "Unexpected Error occurred attempting to open an SQL connection.")
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521:sting2 (this works)

# "New Method"
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2.na.sas.com (this works)
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2 (this errors)
(SQuirreL client error, "Unexpected Error occurred attempting to open an SQL connection.")

View 10 Replies View Related

RAC & Failsafe :: JDBC Connection To A 10g Database?

Mar 30, 2005

The problem i mentioned in my last posting "CRS installation/PRIF-10: failed to initialize the cluster registry" was due to the fact i was using Redhat Linux 9 that seems to have some missing packages. I installed White Box RH 3 and everything worked fine.

if it's possible to connect to a 10g RAC database using the jdbc java thin client. the java thin client requires an ip, and database sid. I am running a two node cluster and i have two ip's and a service name that uses TAF option.

View 5 Replies View Related

SQL & PL/SQL :: Version Of Oracle And JDBC Running On A Remote Database?

Jul 28, 2013

How to know the version of Oracle and JDBC of remote databases that is accessing my database through DBLInk.

For example I have a database A , B database is using my database Through a dblink.Now I want to know the version of oracle and jdbc which working on B.

View 4 Replies View Related

Connect Oracle Database From Delphi - Could Not Resolve Connect Identifier Specified

Oct 6, 2010

I have the following computer/setup:

Acer laptop, Intel Processor w/ Windows 7 Professional (64-bit)
Delphi 2010 Professional
Oracle XE (+ the Oracle XE client that comes with it)

I cannot can't to the Oracle database from Delphi. The error I keep getting is:

Alias is not currently opened. [Oracle][ODBC][Ora]ORA-12154:TNS: could not resolve the connet identifier specified.

Here's what I've done:

1. Create an ODBC connection to my Oracle database

- run C:WindowsSysWOW64odbcad32.exe to open the ODBC administrator.
- Data source name: bt_user
- TNS Server Name: localhost/xe
- user bt_user
- Clicked "test connection" -- Success.

2. Open Delphi and drop a TDatabase component on my main form.

- Set the Alias Name property to "bt_user" (the alias I set up in ODBC)
- Set database name to "bt_user".
- Checked "connected".

Alternatively, I tried using the Delphi ADO components (the dbGo components).

- Drop TADOConnection component on my form.
- Select "connection string" and open the dialog.
- Click "build string".
- Select "Microsoft OLE DB Provider for ODBC Drivers" from the selection.
- In "use data source", select "bt_user" from the drop-down list (my ODBC connection from #1)
- Click "test connection".

Again the same error.

My questions are:

1. Can Delphi work with Oracle XE (Express Edition)?

2. If so, then do I need to install the "Instant Client"?

3. Will the instant client for Oracle 10g work with Oracle 10g XE?

4. Do I need to install any additional ODBC driver(s)?

5. Why was I successful in creating the ODBC connection in Windows, but it failed in Delphi?

6. Will Visual Studio.NET (C#) work with Oracle XE, and what are the steps for setting that up?

View 2 Replies View Related

V$session And Jdbc?

Dec 23, 2009

I am connecting to Oracle 9i using JDBC in my JSP/Servlets web pages. I am closing all my connections in Finally blocks.

Everything works great during the day with JDBC and Oracle.But after a Web crawler runs through our web server at 3 AM the next morning a v$session check shows several lines of JDBC Thin Client inactive status. find exactly what sql statement or program that could be causing the JDBC Thin Client to show up?

View 1 Replies View Related

TimesTen In-Memory :: JDBC Connection - Is It TCP/IP?

Jul 18, 2012

I connection to TimesTen as follow:

String url = "jdbc:timesten:direct:dsn=my_ttdb";
String username = "ADMINISTRATOR";
String password = "";
Connection connection = DriverManager.getConnection(TestTT.url, TestTT.username, TestTT.password);

I wonder if this JDBC Connection is a TCP/IP connection on the backend? If this is not a TCP/IP connection, how can I make a connection with TimesTen via TCP/IP protocol?

dsn:my_ttdb configuration likes:
[my_ttdb]
Driver=/home/tttest/TimesTen/tt1122/lib/libtten.so
DataStore=/home/tttest/ttdata/database/my_ttdb
LogDir=/home/tttest/ttdata/logs
PermSize=40
TempSize=32
DatabaseCharacterSet=ZHS16GBK
OracleNetServiceName=orcl

View 12 Replies View Related

Oracle 10g - Query Is Very Slow In Jdbc But Not In Other Tools

Jan 29, 2013

I'm using PreparedStatement to execute a query with some parameters. in sql developer, it just spends 12 seconds but in jdbc, it's around 140 seconds.

I disabled "_optim_peek_user_binds" parameter already but it didn't work. alter session set "_optim_peek_user_binds"=false;

View 1 Replies View Related

JVM :: JDBC Driver DatabaseMetaData.getCrossReference Contract Not Respected?

Jul 29, 2013

Since JDK 6, DatabaseMetaData.getCrossReference contract is :Retrieves a description of the foreign key columns in the given foreign key table that reference the primary key or the columns representing a unique constraint of the parent table (could be the same or a different table). But the Oracle JDBC Driver executed query is :

SELECT
  NULL AS pktable_cat,
  p.owner as pktable_schem,
  p.table_name as pktable_name,
  pc.column_name as pkcolumn_name,
 
[code]...

View 0 Replies View Related

Can Connect From Database 1 To 3

Nov 10, 2011

For example, I have 3 database, database 1 and database 2 connect together by database link db_link1, database 2 and database 3 connect together by database link db_link2.

I want to ask: Can I connect from database 1 to database 3 ? ( Of course don't use database link between database 1 and 3, just use database db_link1 and db_link2 )

Both db_link1 and db_link2 are public database link.

Can I restrict user access by 2 these public database link ?

View 1 Replies View Related

ORA-257 Not Able To Connect To Database?

Feb 11, 2013

I am not able to connect to database due to ORA-257. So manually i deleted the archivelog files in diskgroup. however it is showing 13gb free space after deletiion. Archive log files generated due to Import job is running.

In below ways i have tried to connect to database.

1) Through SQLPLUS (Not able to Connect)
2) Through RMAN i tried to connect (Not able to connect)
3) I tried to connect impdp to stop the running job. It was also failed

View 7 Replies View Related

Trigger - Delete Account Through A Java Interface Using JDBC - Get Error?

Dec 10, 2012

Here are the relevant tables to the triggers I'm having trouble with.

create table profile
(
userID number(10),
uname varchar2(64),
email varchar2(32),
password varchar2(32),
date_of_birth date,

[code]...

Here's the triggers I currently have that doesn't work.

create or replace trigger DropAccount
after delete on profile
FOR EACH ROW
BEGIN
delete from groupMembership where (userID = :old.userID);
END;

The DropAccount trigger's purpose is to delete all the records from groupMembership that contains the userID of the person deleting his/her own account. It appears to work when I run the following statements in sqlplus:

delete from profile where (userID = '1');
select * from groupMembership where (userID = '1');

But when I try to delete an account through a java interface using JDBC I get the following error:

Machine Error: java.sql.SQLException: ORA-04091: table *****.GROUPMEMBERSHIP is mutating, trigger/function may not see it
ORA-06512: at "*****.DROPACCOUNT", line 2
ORA-04088: error during execution of trigger '*****.DROPACCOUNT'

The java function basically just executes a delete statement.

View 1 Replies View Related

Client Tools :: How To Set Connection Property Oracle.jdbc.thinLogonCapability

Sep 25, 2013

how to set connection property "oracle.jdbc.thinLogonCapability"

View 3 Replies View Related

SQL & PL/SQL :: Error Occurred During Execution Of Simple JDBC Program In Eclipse

Jun 27, 2013

java.sql.SQLException: ORA-04054: database link GMAIL.COM does not exist

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1615)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1580)
at com.jdbc.pack.Lab1.main(Lab1.java:31)

View 7 Replies View Related

How To Connect To SQL Database Server

Feb 23, 2009

I do not know how to create a connection between oracle to SQL server using topology manager on my application. I understand that I must create a logical and physical architecture to create the connection and the logical and physical architecture is running under topology manager.

View 1 Replies View Related

Forms :: How To Connect Database

Jul 18, 2011

while new form open i need to connect the data base.

View 5 Replies View Related

SQL & PL/SQL :: Password To Connect To Database

Oct 24, 2010

I extracted the script of creating user in my database in SQL navigator and Toad tools but it is displaying encrypted password. But I am unable to connect with that password.

To get the original password then I will be able to connect my database.

View 3 Replies View Related

Forms :: How To Connect 6i To Run On SQL Database

Aug 26, 2010

How can I connect forms6i to run on SQL database ?

View 4 Replies View Related

ORA-00604 When Connect To Database

Sep 10, 2008

I'm writing PRO C program with oracle 8i. My process first connect to the database with using ora_connect(), proceed the task then diconnect with using ora_disconnect(). This would always in a loop, recently after few cycle of connect and disconnect, when the next issue connect statement, it was unable to connect and return me ora-00604 and the process end. Even i restart the process, after few cycle also the same return me ora-00604 during the connect.

View 3 Replies View Related

Database 10.2.0.3 - Cannot Connect To Sqlplus?

Aug 29, 2012

My database in on 10.2.0.3 and facing hang problem when I am connecting to sqlplus.

bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Aug 29 00:54:03 2012

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

ERROR:
ORA-01075: you are currently logged on

As per Metalink note(215858.1) suggested in forums I have followed steps and produced results below.

bash-3.00$ sqlplus -prelim

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Aug 28 23:28:02 2012

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Enter user-name: / as sysdba
SYS on test>oradebug help
SYS on test>oradebug setmypid
Statement processed.
SYS on test>oradebug hanganalyze 12

[code]...

Now I have got struck how to analyze above results.

View 3 Replies View Related

ODP.NET :: Connect To Database Oracle With C#

Oct 19, 2012

I am trying to develop a web application with C # VS.net, my application is to connect to an Oracle database on a server (LAN), the problem I want to connect to the database without install oracle or ODP on my client machine.

View 1 Replies View Related

How To Connect D2k Form To Database

Jun 8, 2011

How can i connect my d2k form to database, when i installed d2k it gave an error like :

user1.pin(20):os_error while spawning ifsrv660-install forms60 server port=9000
mode=socket batch=yes

after installation when i want to compile my form it gave tns error like:
ora-12154:tns:could not resolve service name

View 3 Replies View Related

XE :: 11g - Can't Connect To Database After Installation

Jan 31, 2013

I recently installed Oracle database 11g XE onto my home computer running Windows 32 bit, but I can't connect to the database. I also have Oracle 10g R2 installed on my computer, and I can still connect to it finely. When trying to make a connection in SQL DEVELOPER, I get this error

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

I tried to tnsping the XE database and it returns successfully.

C:>tnsping xe
TNS Ping Utility for 32-bit Windows: Version 11.2.0.2.0 - Production on 31-JAN-2
013 07:59:17
Copyright (c) 1997, 2010, Oracle.  All rights reserved.
Used parameter files:
C:oraclexeapporacleproduct11.2.0server
etworkadminsqlnet.ora

[code]....

View 3 Replies View Related

SQL & PL/SQL :: How Many Users Can Connect With Database

Apr 23, 2010

I want to know what will be the performance of my DB before loading data and how many users can connect with my database.

View 7 Replies View Related

Server Administration :: Oracle JDBC Classes12.jar File - Unable To Extract

Apr 21, 2010

Upgrading from 10.1.0.2 to 10.1.0.5. Enterprise Manager requires 'newest' version of Oracle JDBC drive.Downloaded what I believe to the correct file (classes12.jar). I'm unclear what to do with this, my readings have pointed me in the following direction:

1) copy to c:oracleproduct10.1.0db_1jre1.4.1in
2) extract

here is the problem...tried:

1) just clicking on it (nothing)

2) c:program filesjavajre1.6.0_03injavaw -jar classes12.jar
Error:
Failed to load Main-Class manfest atrribute from
c:oracleproduct10.1.0db_1jre1.4.1inclasses12.jar

Is my location correct, I've been hunting everywhere..making no progress.

View 4 Replies View Related

Oracle Database - Cannot Connect From PHP Script

Jul 19, 2010

I have created an Oracle database on my Windows XP system but cannot connect from a php script

CODE

<?php
if (!$db = @ocilogon("big", "big", "s7s"))
    {
    $error = ocierror();
    printf("Error was: %s", $error["message"]);
    die();
    }
$stmt = ociparse($db,"SELECT count(*) FROM members");
ociexecute($stmt);
?>

When I created the database the connection I used was s7s but whether or not I include that name or just use the ID/password that script will not connect.

View 2 Replies View Related

SQL & PL/SQL :: Code To Connect External Database

Apr 8, 2013

How to write a code(procedure) to connect external database through PLsql coding.. I mean,

first, "Create connection like connection string", then "retrieve data from tables inside the database".

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved