[Joshua Schricker]

I am fairly frustrated trying to get the security scaffolding to work. The database tables are not being created for some reason. I would like to try and create the tables manually. I found the schema for the users and authorities tables but I can’t find anything on the users_authories table that is being referenced in the queries. Can someone please post the database schema for everything that the scaffolding needs to work?

Thanks,
Josh

[support-swapna]

Josh,

Sorry that you are seeing this issue.

The tables required for security scaffolding will be created but you need to reconnect and refresh the Database connection from the MyEclipse DB Explorer to see the newly created tables.

Once you finish the scaffolding, switch to DB Explorer view, reconnect and refresh the DB connection and then run the application.

If you are still seeing issues, please share the MyEclipse Installation Details from MyEclipse > Installation Summary > Installation Details. If you are working with any other database apart from MyEclipse Derby, please share the DB and version details.

Here is the schema for users_authorities table for your reference :

create table “CLASSICCARS”.”USERS_AUTHORITIES”(
“USER_ID” VARCHAR(255) not null,
“AUTHORITIES_ID” VARCHAR(255) not null,
constraint “SQL140714161524080” primary key (“USER_ID”,”AUTHORITIES_ID”)
);

alter table “CLASSICCARS”.”USERS_AUTHORITIES”
add constraint “FKB3831B2AE5570518”
foreign key (“AUTHORITIES_ID”)
references “CLASSICCARS”.”AUTHORITIES”(“ID”);
alter table “CLASSICCARS”.”USERS_AUTHORITIES”
add constraint “FKB3831B2A813E8595”

Let us know how it works for you.

[Author]

Posts