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 All, Is there any provision for knowing the customer open items by balance of overdue items in the customer line item display in the t-code FBL5N. The standard process is through the S_ALR_87012178 Regards, ArvindDear friend You may not get as ggo [More]
while connecting R12 through front end, i am getting below error 500 Internal Server Error java.lang.NoClassDefFoundError     at oracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:126)     at oracle.apps.fnd.sso.AppsLoginRedirec [More]
Hi All, I have a question. When the supervisor creates an appraisal for an employee, the supervisor is obligated to create Objectives for the employee but creating Competencies are only optional for executives (people group). When the supervisor has [More]
I have a JFrame that it's title bar has several Images. In Order to set these images I used setUndecorated(true) and added the images with panels to the north area of the panel. After this change my Frame has a fixed size. I implementes MouseListener [More]
Everything is in the question.See the actions for that error number here: http://support.apple.com/kb/TS3297 Also maybe here: Backup error (-5000): Apple Support Communities srl7575 wrote: Now it's saying (-5000)Read other 5 answers [More]
My computer recognizes my iPod but tells me I need to unlock it. My problem is I can't because the screen is shattered. Is there some way I can unlock it or get my picturesNone that I know of.  The security feature does work.Read other 2 answers [More]
Hi All, I have 2 fields in the rows of my BEx query designer, when you run the report both of those fields data show in single column of BEx output. Ideally those two fields show  in different columns instead of single. Please review the attached and [More]
My java program is connecting to a dbf (VisualFoxPro) file with JDBC ODBC bridge. I try to truncate the table (delete all records) in the dbf but foxpro does not have the truncate command Then i try "delete from table" with set delete on, but th [More]
I have just partitioned my Mac HD via Boot Camp - with a 42GB Windows XP partition to run a program not available for Mac. The Windows XP (retail version with license) I purchased came with SP1 "upgradeable to SP3 for free" after purchase. Now t [More]
Hello Every one i have a problem with my Monitoring ,the alert which i receive continuously in My SCOM  2012 motoring console is.. The System Center Management Health Service 123-31234  running on host xxx-xxxx.Root.net and serving management group w [More]