Sitemap

Amicuk Programming Answers

Catching a particular SQL Exception

-0001-11-30   Views:0

Advertisement

Hi I am getting an SQLException ORA-01653: unable to extend table. Is there any way so that I can catch this particular exception only. If I have a catch block catch(SQLException e) System.out.println(e); The above will be general and for all sql exc

Hi
I am getting an SQLException ORA-01653: unable to extend table.
Is there any way so that I can catch this particular exception only.
If I have a catch block
catch(SQLException e)
System.out.println(e);
The above will be general and for all sql exception, I want to only catch ORA 01653 exception
Thanks

The replay answer
Advertisement
No, but what you can do is to test if this is the exception you want to special case in a local try - catch, then rethrow the exception if it's not a match.

Go to See the other 3 answers

Catching a particular SQL Exception

Category:DefaultRelease time:-0001-11-30Views:130

Hi I am getting an SQLException ORA-01653: unable to extend table. Is there any way so that I can catch this particular exception only. If I have a catch block catch(SQLException e) System.out.println(e); The above will be general and for all sql exc[More]

How to catch SQL Exceptions in JSP

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I wanted to know how do we catch the correct SQL return code in a JSP page ? Based on the return code I wanted to display customised Error messages. But I could'nt figure out a way to get the error message returned by the underlying DB2 database.[More]

Catching  java.sql.SQLException:

Category:DefaultRelease time:-0001-11-30Views:130

ok this might be a stupid question but say i had a dataTable populated by a resultSet, when i update the dataTable how i can catch the java.sql.SQLException's being thrown i.e the PK exception i know i could catch it in the web.xml but was wondering[More]

Error: Partition function can only be created in Enterprise edition of SQL Server

Category:DefaultRelease time:2015-10-11Views:130

By using the Generate Scripts option in SSMS, I've duplicated this DB seven times so far. I do this due to the 10 Gig limit on Sql Express 2012.  I was doing this again today. I generated the script, did a search/replace to provide a new DB name for[More]

Problem with XSU when trying to execute pl/sql package returning ref cursor

Category:DefaultRelease time:2015-10-11Views:130

Hi, I'm exploring xsu with 8i database. I tried running sample program which I took from oracle documentation. Here is the details of these. ------create package returning ref cursor--- CREATE OR REPLACE package testRef is      Type empRef IS REF CUR[More]

SQL 2012 SP1 - How to determine a query that causes Error 8623 in SQL Log: The query processor ran out of internal resources and could not produce a query plan. This is a rare event...

Category:DefaultRelease time:2015-10-11Views:130

We are getting multiple 8623 Errors in SQL Log while running Vendor's software. How can you catch which Query causes the error? I tried to catch it using SQL Profiler Trace but it doesn't show which Query/Sp is the one causing an error.  I also tried[More]

Serial numbers via sql query

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I'm having trouble getting the correct serial numbers via SQL. From PHP I run the following query to get the Delivery Notes: select ODLN.DocEntry,ODLN.CardCode,ODLN.CardName,ODLN.DocDueDate,ODLN.DocDate,ODLN.NumAtCard,NNM1.SeriesName,ODLN.DocNum,[More]

Strange SQL statement

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I can't get the result of this query when I run my application. However, I was able to get the result when I queried it using the SQL Server Query Analyser. Here is part of my code which executes the query. String querystring = "SELECT DISTINCT p[More]

JSTL : problems with sql:query /forEach  tag

Category:DefaultRelease time:-0001-11-30Views:130

I am not able to iterate thru the resultset provided by <sql:query> tag in JSTL. rowcount and columnName works, which means that query does produce a resultset. However, the <c:forEach> tag doesnt display the retrieved data. Code is approx lik[More]

Troubles connecting SQL Server

Category:DefaultRelease time:-0001-11-30Views:130

I do following: 1. Create new web application. 2. Create package and add servlet. 3. Write following code into servlet method protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException[More]

c:catch problem

Category:DefaultRelease time:-0001-11-30Views:130

Hey all, I have been banging my head (and googles) against this problem for a bit. Hopefully someone knows a work around or can point out what I am doing wrong. Here is the block of code that is misbehaving. <c:catch var="sqlError"> <sq[More]

Hot
Hi experts, Due to R/3 refresh the delta load from 0CO_OM_CCA_9 -> 0CCA_C11 is failed on july19, 2008. but on July 20 another delta is successfully loaded in to the cube after the R/3 refresh. My question is I can reinit the cube from R/3 and do a fu [More]
I just installed an external NAS drive from OWC's sister company Newer Tech. It is 500g with ethernet and usb2.0 connections. It works very well with easy setup with Time Machine with no hassle. However, in very fine print that I missed in the ad, it [More]
Apple how can you mess up this release so badly ? I mean come on didn't you test iTunes 7 properly before releasing this crippled piece of software to the masses ? Isn't itunes first and foremost a software for playing music ?? If it cant even do tha [More]
Hi. I have a strange problem When i turn on my computer. The screen is grey bit suddenly turns to otee just for a second and the Apple logo turns pink, after the screen returns grey and everythings is ok. Why happens this? Must i send my computer to [More]
Hello fellow Archers, I recently noticed that XMMS2 was using 40% of my CPU (not sure how I missed it but it no doubt has something to do with my setup) and decided I needed to correct this. My plan was to initially write my own music server, but tha [More]
Hi. I've got Mac Pro dual 2ghz w/ 2gigs of RAM - 250gb main HD for programs. I just picked up a 2nd hard drive that I'm going to use for audio production - basically keep all my sounds/files on it - Using Logic Express 7.2 and Soundtrack pro. I got a [More]
I tried saving it in a new location, changing the name, and saving it in a legacy format. Every time I ended up with the spinning beachball. No other file is having this issue. What could I look for in the file that might be causing this? Interesting [More]
I'm trying to set up mail servives on a server hosted at a host company with a firewall. I think I need to open ports 587 and 465 but the hosting company says I should only open port 465 for this SMTP over SSL. When I try to send email locally thru a [More]
I've encountered a rather unusual problem where I actually have to write directly from a program to an InputStream... I have tried using a PipedInputStream and hooking it up with a PipedOutputStream but whenever I try to do that it seems to deadlock [More]
Does Adobe Premier Elements 8 burn AVCHD DVDs in HD using a standard burner or do you need to have a bluray burner?  I have read comments stating you can't burn HD video straight to DVD.   I need to check this out before I purchase it. ThanksDo not h [More]