Re: Tomcat, WOApp and Oracle..
Re: Tomcat, WOApp and Oracle..
- Subject: Re: Tomcat, WOApp and Oracle..
- From: James Cicenia <email@hidden>
- Date: Thu, 10 Mar 2005 14:05:49 -0600
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