Getting exception in SQL

[beelow]

Hi friends,

I am getting error while running the below sql query:

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.

[Praetor]

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.

[Katty]

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............

[kelfro]

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..........