Query timeout on 10g thin driver

Advertisement

I'm using the Statement.setQueryTimeout(...) method, but it doesn't seem to work when the server is shutdown.
I do the following:
1) create the statement and set the query timeout to 30 seconds
2) run a query that gets stuck waiting for a lock (ie select for update...)
Now, if I let it run normally I do see the following exception:
ORA-01013: user requested cancel of current operation
However, if I run the same query, but shutdown the database server before releasing the lock I see the client application hang indefinitely. The 30 second timeout never occurs.
If I take a thread dump I see my client is stuck on a socket read, which will never come because the db server was shutdown.
Why isn't the jdbc driver honoring the 30 second timeout if it can't communicate with the server? Does this mean that the timeout is actually controlled on the server-side?
any info is appreciated,
Brett

Advertisement

You didn't say how you were setting the client timeout, but this has worked for me in an adp.
'Temporarily increase query timeout, which is an application-wide setting
'CurrentProject.Connection.CommandTimeout = 60 'Too late to change this setting- no effect
Const cstrTimeoutOptionName As String = "OLE/DDE Timeout (Sec)"
Const clngTimeoutSecondsForQuery As Long = 300
strQueryTimeOutOriginal = Application.GetOption(OptionName:=cstrTimeoutOptionName)
Application.SetOption cstrTimeoutOptionName, CStr(clngTimeoutSecondsForQuery)
Paul

November 30, -0001

Query timeout on 10g thin driver

I'm using the Statement.setQueryTimeout(...) method, but it doesn't seem to work when the server is shutdown. I do the following: 1) create the statement and set the query timeout to 30 seconds 2) run a query that gets stuck waiting for a lock (ie se

Proxy Connection with thin driver

Hello, I am using 10g, and bea 81 sp3, I am trying to setup proxy authetication. All the references I find for proxy authetication are using OCI driver. Is proxy authetication supported using oracle 10g thin driver (ojdbc14.jar)? Can anyone provide m

Setting query timeout in TopLink 10g

The 10g version of OAAM uses TopLink 10g Release 3 (10.1.3.1.0) (Build 061004) and Oracle JDBC Driver 10.2.0.2.0. We are not using TopLink Essentials. I'm trying to make it so that our queries will timeout and throw an exception if they take too long

Thin Driver Connection Timeout

I am having some odd problems with the JDBC thin driver (8.1.6). The problem is that when I attempt to make a connection to a server that isn't available or that has bad login information it takes several minutes to time out. I tried using the Driver

JDBC thin Driver 8.0.X Limit 2k for varchar2?

I am using Oracle JDBC thin driver 8.0.5.0.0 to query Oracle 8.0.5 via SQL net. The problem I met is every time I try to retrieve data for varchar2 (over 2k), it get truncated and only return the first 2k without throwing any warning or exception. I

How does Oracle JDBC thin driver handle numbers via getString?

Hi, I have a query regarding how numbers are handled by the oracle jdbc thin driver. The issue I am facing is with regards to the decimal separator (. is en_US and , in pt_BR) e.g. Consider the below code, Connection conn = DriverManager.getConnectio

Oracle (JDBC) Thin Driver Ora-00600 Error

Hi, I'm using Oracle9i JDeveloper and trying to access an Oracle 9.2.0.2 database using the oracle thin driver. Sometimes I get the error message "SQLException: ORA-00600: internal error code" when I execute queries. When I change the query to s

Oracle JDBC Thin Driver for oracle 9.2.0.4

Hi, It would be nice if someone please guide me to the download of Oracle JDBC Thin Driver for oracle 9.2.0.4. Thanks in anticipationuser566773, As far as I know, all Oracle JDBC drivers are meant to be backward compatible. According to the table on

JDBC & setQueryTimeout - or is there another way to set query timeout?

I am trying to set query timeout for TimesTen using jdbc library. But it seems like TimesTen jdbc library does not support setQueryTimeOut. Is there a way to set it without having to set it statically in the DNS? I tried to set the SqlQueryTimeout in

Oracle 8 JDBC thin driver for tomcat

Hi all, I have tomcat3.3 installed on HP UNIX with java version "HP-UX Java C.01.18.05" I need to connect to an oracle 8 database using a Oracle JDBC thin driver. Where can I obtain this driver? How to install and configure it for the tomcat app

NLS_LANG and the Thin Driver

Does the Java JDBC thin driver make use of the NLS_LANG parameter in the client? As I understood so far, it doesn't (good) - but is the NLS_LANG parameter used on the server? nullThe JDBC Thin driver does not make use of the NLS_LANG on the client, b

Oracle JDBC thin driver on NT vs IBM mainframe Linux

We are develping an Java 3-tier web application on NT platform. The database is Oracle 9i. The JDBC Driver is Oracle thin driver (oracle.jdbc.driver in classes12.jar). Java is JDK1.3. We are told recently that we may need to deploy this application o

Thin driver / 8i / Solaris hangs for 60 seconds

I am having the same problem that I have also seen in these two messages: http://technet.oracle.com:89/ubb/Forum8/HTML/002149.html http://technet.oracle.com:89/ubb/Forum8/HTML/001335.html Using the thin driver to connect to Oracle 8.1.6 on Solaris 7,

Timestem and jdbc Query Timeout

hi all, i have install timesten on one computer and configure there Query Timeout like This: SQLQueryTimeout = 80 and i have JBoss Application Server on another computer and timesten client. i've timesten-xa-ds.xml configuration file configured like

GUYS!! Is there any way to write BLOB's 4K using Oracle thin driver

I've been trying for 3 days to do that but nothing worked ... Not setBinaryStream(x, new ByteArrayInputStream(anArrayWith10KBytes), anArrayWith10KBytes); nor setBytes(x, myArray), or setObject(x, myArray). Is there any way to store Blobs to Oracle 8.

Dbxml query timeout

Does anyone know what the default query timeout is? I beleive it is set by xmlQueryContext::SetQueryTimeoutSeconds( ...). Thanks, CurtForgive me for not thanking you for your help, I got caught up in a deadline and neglected to do so. The problem end

Jdbc thin driver - nls parameters

Hi, Does anyone have the experience on how the Oracle JDBC Thin Driver decide its NLS session related parameters? It looks to us that it will have its own settings which override the instance-level settings? If we want to set some specific settings (

JDBC Thin Driver Won't Honor Autocommit=FALSE

I have the following code, which intializes a JDBC thin driver connection, and sets the autocommit to false. However, as soon as the statement is executed, it commits on its own. What's going wrong here? I can tell that it is committing, because the

Could not connect through thin driver

I am trying to connect to database through thin driver but getting the following exception : Io exception:The Network Adapter could not establish the connection java.sql.SQLException: Io exception : The Network Adapter could not establish the connect

How can I see KSC5602 character set using JDBC thin driver

After I change character set from USASCII7 to KO16KSC5601, I cannot see korean from the clients using JDBC thin driver. But, I can see korean clearly using sqlplus at serer, or application using SQLNet. I use Oracle Enterprise Server 8.0.4.1.0, jdbc