|
|
![]() |
| Thread Tools | Search this Thread |
#1
| |||
| |||
Getting exception in SQL Hi friends, I am getting error while running the below sql query: Quote:
"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. |
#2
| |||
| |||
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. |
#3
| |||
| |||
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............ |
#4
| |||
| |||
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.......... |
![]() |
|
Tags: exception, query, sql, sql query |
Thread Tools | Search this Thread |
|
![]() | ||||
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 |