Re: Tomcat, WOApp and Oracle..
Re: Tomcat, WOApp and Oracle..
- Subject: Re: Tomcat, WOApp and Oracle..
- From: Jonathan Meijer <email@hidden>
- Date: Thu, 10 Mar 2005 15:19:25 -0500
No, i made mine as a standalone WAR, since I deployed on Linux and I
couldn't rely on frameworks. (Note: I had to modify the source of
wonder so it'd work.)
Jonathan Meijer
email@hidden
On 3/10/05 3:05 PM, "James Cicenia" <email@hidden> wrote:
> Hmm,
>
> Have you gentlemen actually got an SSDD War file deployed???????
>
> - James Cicenia
>
> On Mar 10, 2005, at 1:40 PM, Jonathan Meijer wrote:
>
>> Hey Seejo,
>>
>> I had the same issue when I deployed my WO .war on tomcat. It seems
>> that the db connection info must be set in the xml files, as it
>> ignores the settings in the eomodel.
>>
>> I have an app running on mysql, and I had to add a block to
>> conf/server.xml:
>>
>> <Context path="/AppName" docBase="AppName" debug="5"
reloadable="true"
>> crossContext="true">
>> <Resource name="jdbc/someName" auth="Container"
>> type="javax.sql.DataSource" maxActive="100" maxIdle="30"
>> maxWait="10000" username="dbUsername" password="somePassword"
>> driverClassName="com.mysql.jdbc.Driver"
>> url="jdbc:mysql://localhost:3306/dbName?autoReconnect=true"/>
>> </Context>
>>
>> ... within the following clause:
>> <Host name="localhost" appBase="webapps"
>> unpackWARs="true" autoDeploy="true"
>> xmlValidation="false" xmlNamespaceAware="false"> ... </host>
>>
>>
>> I also had to add the following block in
>> webapps/AppName/WEB-INF/web.xml:
>> <resource-ref>
>> <description>Some description</description>
>> <res-ref-name>jdbc/someName</res-ref-name>
>> <res-type>javax.sql.DataSource</res-type>
>> <res-auth>Container</res-auth>
>> </resource-ref>
>>
>> ... within the <web-app> ... </web-app> block.
>>
>> Note that "AppName" is the name of your app according to Tomcat, and
>> that "someName" has to be the same in the 2 blocks. Of course, you
>> will also have to adjust the db parameters in the first block to
>> something that fits Oracle.
>>
>> Hope this helps,
>>
>> Jonathan Meijer
>> email@hidden
>>
>>
>> On 3/10/05 10:54 AM, "Seejo Pylappan" <email@hidden> wrote:
>>
>>> Hi all,
>>> I have a WebObjects app which I am trying to deploy on Tomcat. I had
>>> database issues as it never connects. To isolate the problem. I
>> created
>>> a test case using just the model and I try to establish a db
>>> connection. The app when running normally, connects and returns
>>> results. But when it runs under tomcat I get a JDBC Exception. The
>>> adaptor settings are:
>>>
>>> Username : username
>>> Password : password
>>> URL : jdbc:oracle:thin:@192.192.92.84:1521:prog9i
>>> Driver :
>>> Plugin :
>>>
>>> The app connects, returns information when running normally. Under
>>> tomcat it gives this exception:
>>>
>>> - An exception occurred while trying to open a channel:
>>> com.webobjects.jdbcadaptor.JDBCAdaptorException: Cannot create JDBC
>>> driver of class '' for connect URL 'null'
>>> In Exceptionjava.lang.IllegalStateException: _obtainOpenChannel --
>>> com.webobjects.eoaccess.EODatabaseContext
>>> com.webobjects.eoaccess.EODatabaseContext@1ccc63: failed to open
>>> database channel. Check your connection dictionary, and ensure your
>>> database is correctly configured.
>>> java.lang.IllegalStateException: _obtainOpenChannel --
>>> com.webobjects.eoaccess.EODatabaseContext
>>> com.webobjects.eoaccess.EODatabaseContext@1ccc63: failed to open
>>> database channel. Check your connection dictionary, and ensure your
>>> database is correctly configured.
>>> at
>>>
>>
com.webobjects.eoaccess.EODatabaseContext._obtainOpenChannel(EODatabase
>> C
>>> ontext.java:2132)
>>> at
>>>
>>
com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificatio
>> n
>>> EditingContext(EODatabaseContext.java:3195)
>>>
>>> Any idea why I am seeing this?
>>
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list (email@hidden)
>> Help/Unsubscribe/Update your Subscription:
>> email@hidden
>>
>> 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