Environment Oracle 10g Windows 2003 server IIS 6 .NET 3.5 Oracle client 10.2.0.1.0 ODAC 10.2.0.2.21 odp.net 2.102.2.20 Validate Connection=true;Min Pool Size=0 in connection string All odp.net connection, command and parameter objects are closed/disposed after use. The issue: ORA-03113 is returned to asp.net. ORA-07445 ACCESS_VIOL...
I keep getting this while importing a virtual machine template in Oracle VM Server, via Oracle VM Manager.. anybody has any clue about this? ...
Presently we are using JDBC in the data layer and planning to replace it with hibernate.I am new to Hiberante and not sure how hiberante handles concurrency. Can somebody explain me if we use spring for the transaction management, how concurrent updates will be handled by hibernate (In memory automatic version management of hibernate) or...
I've just made the switch from MS sql server to Oracle. The query tool I am using is Oracle SQL Developer. The problem I am having is that I cannot get the query results window to stick around. The query results window being the Grid view for the results. It seems to show up arbitrarily when I open a new "sql worksheet". But not alwa...
My oracle.dataaccess.dll is not supported on x64 machines. I've looked for it everywhere - but all I could find is the x86 version. Anyone knows where can I get it from? ...
I need to compare two dates using the Oracle decode function to see if one is <= then the other. I found this article - http://www.techonthenet.com/oracle/functions/decode.php Which states (at the bottom) that the below decode function will return date2 if date1 > date2 : decode((date1 - date2) - abs(date1 - date2), 0, date2, date1) ...
According to the ORACLE documentation, the Connection Lifetime attribute is checked when the connection is closed and released back to the connection pool, if the connection was open for longer than the Lifetime setting then it is cleared from the pool. My question is, does the counter for the Connection Lifetime reset after it's releas...
When using ROracle in R, I want to bind some parameters to data, so I do this: > dbh <- dbConnect('Oracle', 'user/[email protected]:port/sid') > st <- dbPrepareStatement(dbh, statement="SELECT x FROM mytab WHERE id=:1", bind="character") > st <- dbExecStatement(st, data.frame(id=c("9ae", "1f3"), stringsAsFactors=F...
In addition to http://stackoverflow.com/questions/852261/how-to-create-a-dump-in-oracle-in-pl-sql-developer Is that possible to create a dump into separated files: I prefer the each stored object has its own file. So as result I want N files with views description (1 view per 1 file), M files with SP, O files with tables, etc Is that p...
I'm looking to find out what kind of 'create table' statement I would need to create a given table from scratch. I'm especially interested in primary key constraints, unique constraints, foreign key constraints and column names. How would I do this in Oracle and/or SQL Server? Oddly enough, the only connection I have to the database i...
I have a db with many tables. Some tables have unit price column, no tax, gst and such columns. What should i do now? Should i create GST table, HST table and PST table separately. In other words, what is the standard schema of designing the tax table? ...
I am using a hibernate sequencegenerator to auto-generate unique values for my primary key column.The sample code is given below. @Entity @Table(name = "REQUEST") @javax.persistence.SequenceGenerator(name = "REQ_SEQ", sequenceName = "REQUEST_SEQ") public class Request { /** * Unique id for this request */ @Id @GeneratedValue(strategy ...
Outer joins seem to me a little bit confusing. Is there anyone can get me a clear picture of outer joins (right, left and full)? ...
Hello, we get problem, while trying to export Oracle DB. OS: CentOS ~ 5.2 DB: Oracle 10g. Exp command exports db files only in location: /home/oracle/OraHome_1/oradata/master/xxx.dbf , but tool can't export files in different location (we know about this files after getting trace) like this: '/disk1/dblog06.dbf', '/home/di...
Hello, I have my app server resin and oracle database connected. If the db is bounced for any reason, I have to bounce my app server as well to clear the bad connections. Is there any way to get around this? Any property set to the datasource? Other than FCF... ...
In Oracle DB: Store Procedure like: procedure getInfo ( p_ids IN IDS_TABLE, p_details OUT cursor ) Type IDS_TABLE is: create or replace type IDS_TABLE as table of IDS create or replace type IDS as object ( id1 NUMBER, id2 NUMBER, id3 NUMBER ) How can I call getInfo in Java? ...
Each row in a cursor should be joined with another table and the whole result should be returned a one cursor Say cursor1 return 5 rows. Each of these 5 rows should be joined with table1. and the final result for all the 5 rows should be returned a 1 row. Plz help ...
Hello everyone, I'm querying an oracle 9i database with: SELECT * FROM table WHERE column LIKE '%' || ‘someText’ || '%' ESCAPE '\'; and it fails with the error "escape character must be character string of length 1" ( ORA-01425 error), while succeeding in an oracle express 10g database. Making it a double backslash (ESCAPE '\\') solv...
Hello, I have a problem with a mapping for this structure that i designed public abstract class A<T> { private int discriminator_value = -1; private T value; //... } public class One extends A<String> { public One(){ setDiscriminatorValue(1); } //... } public class Two extends A<BigDecimal> { public Two(){ setDiscrimina...
Hi, We were trying to deploy Oracle "Coherence*Web and Coherence Cache Cluster" to our web application. And we comparing which of the above methods of using Coherence*Web is better? Coherence*Web SPI or the Webinstaller way? I tried searching oracle blogs, wiki and forums. After some search, this is what i found here: http://coherenc...