This content has been marked as final.
Show 2 replies
-
1. Re: ORA-01031: insufficient privileges, grant requirements
kuruma45 Apr 17, 2007 5:53 AM (in response to kuruma45)I have ask to DB admin to put the sys privileges to SCH1 schema...
I have a problem to bind my entity and table, i'm newbie on Oracle database,
in my entity :
@Entity
@Table(name="SCH2_TABLE1")
public class SCH2_TABLE1 implements java.io.Serializable
{
...it works in some case, but there are not 2 schema, but a lot and for some table, Jboss don't bind the correct table...
i tried :
@Table(name="SCH2.SCH2_TABLE1")
also
@Table(name="SCH2@SCH2.SCH2_TABLE1")
but jboss don't find any table...
what is the correct syntax to link the correct table??
Thanks -
2. Re: ORA-01031: insufficient privileges, grant requirements
kuruma45 Apr 17, 2007 10:16 AM (in response to kuruma45)it was simple, but hard to find the soluce :
@Entity
@Table(name="SCH2_TABLE1", schema="SCH2")
public class SCH2_TABLE1 implements java.io.Serializable
{
I hope it will help somebody..