Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 18-11-2009
Member
 
Join Date: May 2008
Posts: 69
Getting exception in SQL

Hi friends,

I am getting error while running the below sql query:

Quote:
INSERT INTO Stud_Detail(stud_ID,stud_name,stud_address)VALUES(1,'DAJ06TABO.SAM, 'DAJ06TABO.LANA')
When I trying to run below query I get below exception:

"java.sql.SqlException: or A-28115: policy with violation of check option"


but the thing is that the same query is running successfully in DBA.ADMIN.

Please recommend me a way to sort out this exception and correct way to use this in DAJ06TABO.ADMIN.
Reply With Quote
  #2  
Old 18-11-2009
Member
 
Join Date: Apr 2008
Posts: 1,948
Re: Getting exception in SQL

Dear friend,

First I want to ask you a question, Do you have more than one domains? If yes,then let me know which domain is the agent in and which domain you was trying to insert the record to?

I am asking you because I also had similar type of exception while using an agent to act on objects in another domain.

And unfortunately I also haven't got right solution yet.
Reply With Quote
  #3  
Old 18-11-2009
Member
 
Join Date: May 2008
Posts: 2,008
Re: Getting exception in SQL

If you want my suggestion, The actual problem is not in accessing another domains or multiple domains.

The actual cause of this i.e "java.sql.SqlException" exception is that your query is not proper according to the number of fields or formatting of fields in the database table.

If you are trying provide less or more values, you will get the above exception and query won't execute successfully.

I hope this information will work for you............
Reply With Quote
  #4  
Old 18-11-2009
Member
 
Join Date: Apr 2008
Posts: 2,001
Re: Getting exception in SQL

I don't have sound knowledge of the SQL .
But I think you should check the datatype of fields of table with the datatype of values which you wanted to enter.

Because if the this datatypes get mismatched you will definitely get the runtime error.

This may solve your problem..........
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Getting exception in SQL"
Thread Thread Starter Forum Replies Last Post
Exception handling in PL/SQL Ameeryan Software Development 5 25-02-2010 11:04 PM
Exception handling in EJB KennedII Software Development 5 25-02-2010 04:40 AM
Exception Class Triple-X Software Development 3 06-11-2009 12:22 PM
How to handle exception in VBA afidelino Software Development 3 03-09-2009 03:30 PM
Unhandled exception SeCTor 1 Software Development 3 25-10-2008 03:02 PM


All times are GMT +5.5. The time now is 05:25 PM.