Schema Validation in JBoss 6.0
johndoe- Nov 14, 2012 10:14 AMHi everyone!
I'm new to this, I hope you can all help me with my issue.
I have 2 instances of JBoss Server installed, both on different Servers. One is a Test- Server, and one is for the productive enivornment. On each Server, there is a database installed.
So:
On Server A: Database- name is database_usertest
On Server B: Database- name is database_user
In my persistence.xml, i have defined my persistence-unit, and of course :
<jta-data-source>java:jboss/datasources/MyDataSource</jta-data-source>
So, on the
Server A: the Data- Source (with the JNDI- Name "MyDataSource") points to the data-base user database_usertest
Server B: the Data- Source (with the JNDI- Name "MyDataSource") points to the data-base user database_user
When i deploy my ear- File on JBoss, i get different results for the schema validator.
On Server A, it looks like this:
15:01:30,803 INFO [SchemaValidator] Running schema validator
15:01:30,803 INFO [SchemaValidator] fetching database metadata
15:01:31,216 INFO [DefaultTraversableResolver] Instantiated an instance of org.hibernate.validator.engine.resolver.JPATraversableResolver.
15:01:31,244 INFO [TableMetadata] table found: DATABASE_USERTEST.TABLE_NAME
15:01:31,244 INFO [TableMetadata] columns: [abtname, abtnr, flags, abtkurz]
15:01:31,246 INFO [DatabaseMetadata] table not found: TABLE_NAME_2
On Server B, it looks like this:
12:15:20,832 INFO [SchemaValidator] Running schema validator
12:15:20,832 INFO [SchemaValidator] fetching database metadata
12:15:21,566 INFO [DefaultTraversableResolver] Instantiated an instance of org.hibernate.validator.engine.resolver.JPATraversableResolver.
12:15:21,597 INFO [TableMetadata] table found: DATABASE_USER.TABLE_NAME
12:15:21,597 INFO [TableMetadata] columns: [column1, column2, column3, column4]
12:15:21,604 INFO [TableMetadata] table found: DATABASE_USER.TABLE_NAME_2
12:15:21,604 INFO [TableMetadata] columns: [column1, column2, column3, column4]
So, when i deploy my ear- File on Server A, i get an Deployment- Error, because 15:01:31,246 INFO [DatabaseMetadata] table not found: TABLE_NAME_2. Clearly, the prefix (which in this case is DATABASE_USERTEST) is missing, but only for TABLE_NAME_2. For the Table TABLE_NAME, it is written correctly.
Not only that - on Server B, which points to the database database_user, it deploys without any error...
Anyone, any ideas? Please help ...