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
Dear Gurus We have recently implemented SAP in our company. One problem which we have encountered is at the time of GR of material against Purchase Orders with WBS assignments. Our requirement is that the goods at the time of GR should undergo the QM [More]
When trying to update getting (error surle error domain error-1100). It started yesterday, any help would be great. I have Mountain Lion 10.8.1 on a new macbook pro with retina display.There are many people suffering from this problem right now (incl [More]
I have a 13-inch MacBook Air. I had just downloaded OS X Yosemite with no problem. I then went into the App Store after the download/installation had finished, and went to updates (as there was a notification that there was an update). I then receive [More]
Hello all. These days i've been asked to make a little aplication for a PDA and while looking for information about j2me it says jni its not supported. But the app i need to make needs to use some library written in C, and my question is if there is [More]
All, The help for registerworkflows-mp.xml shows that the following operations are available: 1. register 2. enable 3. disable and in the registerworkflows-mp.xml we have targets to match those along with 1. list-composites 2. help So how do we un-re [More]
I am unable to use the full functionality of 32 bit and 64 bit InDesign CC application, when consulted Adobe they told Application uses same CLSID for both 32 and 64 bit, hence requested to uninstall 32 bit from add or remove programs which will unre [More]
Hi, I've developed a sapscript..... and I want to draw a box arround the date which is in the header..... can anybody help me please..... I'm using this syntax /: BOX FRAME 10 TW  but it is drawing a box on all the header. Thankshi, in print preveiw [More]
I have the Norton 360 antivirus and it has the Norton toolbar on my browser and they put a new update out for 19 a couple days ago. I been having issues having the Toolbar show up for me on 17 and I'm gonna upgrade soon to fix that. (I even asked on [More]
Sorry for the newbie question: Is Oracles Business Rules package the same as ILOG JRules? If not: What are the differences? Where can I download Oracle Business Rules? If it is included in SOA Suite: Where exactly can I find Business Rules inside the [More]
How do I make a free account without credit card information??????Check this one. http://support.apple.com/kb/HT2731Read other 2 answers [More]