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
Bom dia, Estou com um problema no qual eu preciso ativar a BadI - Conversão e validação de numeros de cod de barras boleto brasileiro que esta no SPRO ->Contab. financ.-> contab. clien. fornec. -> trans. contab.-> Saida de pag.-> saida de p [More]
What I want to do is pass into a C dll function a variably sized Array of structs of type TPS_Data. My Code compiles but when I run it in TestStand, I get an error -17001; Program Error. "Cannot allocate 0 size buffer Error in parameter 2, 'OpenFrdDa [More]
I was not clear on the description. I wanted to add a printer but do not think I had enough hard disk memory. Everything loaded and I restarted the computer. the screen came up gray with the apple then after a long time a circle came up with a diagon [More]
Has anyone else had this problem?  I have been unable to update Adobe Reader since sometime in June.  Should I completely removed reader and download and restall program?  Also what exactly is Adobe Air?You might ask in the Reader forum. I have no id [More]
How to send text messages written on my Laptop on my Curve8520 with Orange network?umm... you don't. SMS is a function of the BlackBerry, not your PC. There could a desktop software for SMS, but I don't know what it would be. **edit, well this looks [More]
Hello, I am trying to calculate Goods movement date and used DATE Function "Between" to find out the dates between BUDAT and Current Date/System Date(used date function NOW(). between(BUDAT,AGEING_DATE) Validate syntax doesn't show any error, ho [More]
Hi Guys, I have the following problem - I know I did something wrong, but I cannot figure out how to correct it. Here is my question: I have a table tableA, with composite key (col1, col2, col3, col4). I mapped the table, and create a Toplink named q [More]
itunes says that i need itunes 10.5 to get the new iphone software, but i already have 10.5 itunes.  i cant seem to figure out how to get the new iphone software cause it keeps telling me to download updates, and then it does and update search and sa [More]
Dual 2.7GHrz G5, 2GB RAM, OSX 10.4.5 Previously, InDesign 3 (CS1 version) was installed on this Mac. I needed to install the full CS2 package. Everything installed just fine. The problem I am having is the file type associations. The Mac now sees CS1 [More]
I recently let my computer upgrade my Firefox from 16.0.1 to 16.0.2. Once I did, every single page I went to loaded but came up completely blank. I tried Firefox's suggestions on fixing it and nothing worked so I went back to 15 and then upgraded to [More]