Re: JNDI JDBC entry in web.xml Servlet Deployment vs. Migrations
Re: JNDI JDBC entry in web.xml Servlet Deployment vs. Migrations
- Subject: Re: JNDI JDBC entry in web.xml Servlet Deployment vs. Migrations
- From: Matthias Jakob <email@hidden>
- Date: Thu, 24 Apr 2014 14:23:11 +0200
Thank you David, John,
Tested and found out that the first deployment on a fresh server works fine with migrations. Uninstall WAR Application, delete Tables, Install again - start - no migrations are executed ;-(
Glassfish, Websphere same behavior ...
Why? Confused ;-(
Thank you,
Matthias
Am 23.04.2014 um 20:29 schrieb David Avendasora <email@hidden>:
> I may be incorrect, but I don’t think migrations have ever been able to *create* a database. I think you have always needed the DB to exist first, then migrations can create schemas, tables, constraints, etc.
>
> It has been a long time since I tried to start from scratch, so it is entirely possible that I’m completely wrong. :-) (shocking, I know)
>
> Sir Socks
>
>
>
> On Apr 22, 2014, at 6:22 PM, Matthias Jakob <email@hidden> wrote:
>
>> Hi there!
>> I’ve got a problem with my web.xml JNDI JDBC entry in Servlet Deployment and migrations.
>>
>> Using the web.xml entry
>>
>> <resource-ref>
>> <description>MS SQL Server</description>
>> <res-ref-name>jdbc/TEST</res-ref-name>
>> <res-type>javax.sql.DataSource</res-type>
>> <res-auth>Container</res-auth>
>> <res-sharing-scope>Shareable</res-sharing-scope>
>> </resource-ref>
>>
>> It works fine with an already created database and a „Properties" database config.
>> With an already created database and a switch from properties to JNDI JDBC all is fine ;-) (database operations are done ..)
>>
>> But if I clean my DB and start form zero, no migration is done with JNDI/JDBC entry?
>>
>> It’s an ERXApplication, the properties are right I think:
>>
>> # Migrations
>> er.migration.migrateAtStartup=true
>> er.migration.createTablesIfNecessary=true
>> er.migration.modelNames=Test
>> er.extensions.migration.ERXMigration.useDatabaseSpecificMigrations=false
>>
>> Test.InitialMigrationVersion=0
>> Test.MigrationClassPrefix=xx.xx.Test
>>
>> JNDI JDBC is a must have, because of a large deployment environment, properties conf is not an option ;-(
>>
>> What is wrong, what can I do to fix the problem?
>>
>>
>> Please help!
>>
>> Matthias
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list (email@hidden)
>> Help/Unsubscribe/Update your Subscription:
>>
>> This email sent to email@hidden
>
>
> —————————————————————————————
> WebObjects - so easy that even Dave Avendasora can do it!™
> —————————————————————————————
> David Avendasora
> Senior Software Abuser
> Nekesto, Inc.
>
>
>
>
>
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden