Hi everyone, I am watching some very strange behavior today:

INFO - rManagerConnectionProvider.configure:103 - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://10.10.20.141:3306/profile_migration
INFO - rManagerConnectionProvider.configure:109 - connection properties: {user=epuser, password=****, autocommit=true, release_mode=auto}

Now this is correct. Look what happens after a while...

INFO - SessionFactoryImpl .<init>:199 - building session factory
INFO - essionFactoryObjectFactory.addInstance:105 - Not binding factory to JNDI, no JNDI name configured
INFO - SchemaUpdate .execute:155 - Running hbm2ddl schema update
INFO - SchemaUpdate .execute:167 - fetching database metadata
INFO - SchemaUpdate .execute:179 - updating schema
INFO - DatabaseMetadata .getTableMetadata:119 - table not found: ProfileSequenceNumber
INFO - DatabaseMetadata .getTableMetadata:119 - table not found: lcs_countries
[...]
ERROR - SchemaUpdate .execute:212 - Unsuccessful: create table ProfileSequenceNumber (number bigint not null auto_increment, primary key (number)) ENGINE=InnoDB
ERROR - SchemaUpdate .execute:213 - CREATE command denied to user 'epuser'@'10.10.20.56' for table 'ProfileSequenceNumber'
ERROR - SchemaUpdate .execute:212 - Unsuccessful: create table lcs_countries (id bigint not null auto_increment, code varchar(64) not null, status char(1) not null, primary key (id)) ENGINE=InnoDB
ERROR - SchemaUpdate .execute:213 - CREATE command denied to user 'epuser'@'10.10.20.56' for table 'lcs_countries'


Now, where is 10.10.20.56 coming from?
I have debugged, SchemaUpdate line 204 is

stmt.executeUpdate( formatted );

and here is the value in that moment:

stmt.getConnection().getMetaData().getURL()
(java.lang.String) jdbc:mysql://10.10.20.141:3306/profile_migration


I am confused, at least... any suggestion?

It is the ip address of the computer running your program. It seems like 'epuser' is allowed to log-in from this ip address but doesn't have permission to create new tables.

Thanks, in fact I checked and the privileges was not assigned correctly.