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: David Avendasora <email@hidden>
- Date: Thu, 24 Apr 2014 09:16:23 -0400
Hi Matthaias,
Override the migrationsWillRun method and stick a breakpoint on it. Let’s make sure that it is getting that far.
Something like:
@Override
protected void migrationsWillRun(ERXMigrator migrator) {
super.migrationsWillRun(migrator); <— breakpoint here
}
Dave
On Apr 24, 2014, at 8:59 AM, Matthias Jakob <email@hidden> wrote:
> Hi Theodore,
> thank you for your help!
>
> - WebSphere or Glassfish its the same.
> - Microsoft SQL Server
> - Remote Server
> - second start with deleted Tables - no connection on Startup!!?!?
>
> - Only _dbupdater and my single demo Table was deleted … No Database Drop … its already there ...
>
> ;-(
>
> Its really strange …
>
> Matthias
>
>
> Am 24.04.2014 um 14:52 schrieb Theodore Petrosky <email@hidden>:
>
>> what is the deployment environment?
>> what database?
>> is the database on the same machine?
>> what do the logs of the database say? (can you increase the logging to verbose?)
>> at least then you would know if your app is trying to talk to the backend.
>>
>> migrations can not create the database. it must exist (empty or if not, the migration table should be at the correct level [you are specifying 0])
>>
>>
>>
>> On Apr 24, 2014, at 8:23 AM, Matthias Jakob <email@hidden> wrote:
>>
>>> 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
>>
>
>
> _______________________________________________
> 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