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
ADVERTISEMENT
Aug 21, 2012
I have a contract that has several categories with payments in each one. If there is a payment=0, then a category is considered closed. The contract is considered closed when all categories are closed.
Date Category Payments
01/01/07 1 5
01/01/07 2 7.5
01/01/07 3 6
05/01/07 2 0
09/01/07 1 0
11/01/07 3 0
(date here is in mm/dd/yy)
I need a SQL that will return the number of months within the year that contract was open. In the example above, the last category closed on 11/01, so the result should be 10. If the last line was not there, the contract would still be open in 2007 and the result should be 12.
View 33 Replies
View Related
Jul 27, 2012
I've got the following table:
ID.................Date...........................number...period.....termination
434473......2012-04-18 00:00:00.000...............6.......month(s)...end of month
443080......2012-02-26 00:00:00.000...............36......month(s).....end of quarter
Now it's getting complicated. Date is the start date of a contract.
I need to calculate a date when the contract can be terminated and must compare it with the current date. Lets take the first row. In column "termination" is the termination date. A contract can be terminated at "end of month" (I need to check the last day of a month. In order to get the real termination date we need to subtract the column "number".
example 30.01.2012 - 7 month = 30.06. 2011
The thing I can do it, but my logic works only if the date is in the same year. I've been thinking a lot...sql is not important first....Have you got a theoretical solution?
View 11 Replies
View Related
Oct 11, 2012
I need to install Oracle oledb 32 bit driver for delphi application connecting to 11.2.0.3.0 db
do i install driver from oracle client for 11.2.0.3.0 or download from [URL]
are they both the same.
View 1 Replies
View Related
Nov 7, 2013
I can see that some failover events etc aren't supported (Differences between the ODP.NET Managed Driver and Unmanaged Driver), but is failover supported at all? I don't need to get notified, just to get the failover (clustered node switching) working. Is it supported in the managed driver?
View 1 Replies
View Related
Jun 19, 2013
When a database is configured to use AL16UTF16 what character set is sent from DG4ODBC to an ODBC driver when passing in Arabic characters ?
i am using easy soft odbc driver for transfering data from oracle to MS SQL server. English text is going fine, but when i am trying to transfer some arabic text, it is getting corrupted.
View 2 Replies
View Related
Oct 8, 2013
I am trying to use oracle wallet with the new odp.net managed driver, but I am getting
"invalid username/password".
As the wallet itself is ok (it works with the unmanaged client), seems to me that this new provider is not fully compatible with Oracle Wallet. Is this true? I am trying this:
<oracle.manageddataaccess.client> <version number="*"> <settings> <setting name="tns_admin" value="D:oracleproduct11.2.0client_1
etworkadmin" /> <setting name="WALLET_LOCATION" value="D:oraclewallets" /> </settings> </version> </oracle.manageddataaccess.client>
View 9 Replies
View Related
Jul 16, 2012
I'm using following connection string: +connectionString="Driver={Oracle ODBC Driver};Server=someDb;Uid=useruidr;Pwd=password"+
when I call method "Open" on "OdbConnection" I get following exception: +ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified+
"someDb" is specified correctly in tsnames.ora,
"...client" and "...clientin" are added to PATH environmental variable
ORACLE_HOME is set to "...client"
I have Oracle Client 11.2.0.3.0 installed
Operating system is Windows 7 32 bit
When I change Driver to "Microsoft ODBC for Oracle" it works fine. However I want to use Oracle ODBC Driver.
View 2 Replies
View Related
Oct 19, 2013
Earlier I used to connect properly with my Oracle database. But today when I am trying to connect following error is coming
Ora-03121: no interface driver connected - function not performed.
I have not done any changes in my database.
Operating System : Windows XP
Oracle : 9i (SQLPLUS 3.3)
Developer 2000 R2.1
View 2 Replies
View Related
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
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
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
View Related
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
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
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
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
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
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
Sep 25, 2013
how to set connection property "oracle.jdbc.thinLogonCapability"
View 3 Replies
View Related
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
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
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
Sep 25, 2013
I am developing an 64bit And-In software. My OS is windows7 64bit Ultimate. Developer tool is Microsoft Visual Studio 2010 Ultimate 64bit any-CUP.Server is SUN server and Oracle database 10.2.0.5 64bit enterprise edition.I have installed instantclient-odbc-win64-10.2.0.5 on my computer.I am able to connect through the command line sqlplus user/pass@server.In date source(c:windowssystem32odbcad32.exe), ODBC Driver connection successful.But in VS2010 C#, use Tools -> Connect Database,I get an error 193 (Oracle in instantclient10_2,c:ora10_64SQORA32.dll) cann't be loaded.SQORA32.dll is 32bit ODBC Driver or 64bit ODBC Driver?How can I connect database with vs2010 64bit?
View 2 Replies
View Related
Jul 30, 2012
Which is the best driver for java to Oracle database connection ?
View 1 Replies
View Related
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
