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:59:58 +0200
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