Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Trouble getting JDBCProxy Servlet to work

 
   Database Help (Home) -> Informix RSS
Next:  SSIS hitting FK violation - need to ignore the er..  
Author Message
Felix_Schäfer

External


Since: Nov 09, 2009
Posts: 1



(Msg. 1) Posted: Mon Nov 09, 2009 4:25 am
Post subject: Trouble getting JDBCProxy Servlet to work
Archived from groups: comp>databases>informix (more info?)

Hello,

We are having trouble deploying the Informix JDBCProxy Servlet, and as
we are neither accustomed to tomcat/other servlet server, nor is the
documentation provided by IBM extensive to the point that it put me on
the right track, I thought maybe some of you people got it working.

Anyway, long story short, the docs can be found here http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp
(search for proxy, click "Using an HTTP Proxy Server", in german
it's the second hit), and they say to put the 3 classes mentioned in a
servlet directory, which already is the point where I'm a little at a
loss. I tried reading some tomcat6 documentation, and even came up
with a context xml file:
"""
<?xml version="1.0" encoding="UTF-8"?>
<Context path="/ProxyTest"
docBase="/srv/tomcat/localhost/ProxyTest"
antiResourceLocking="false" privileged="false" />
"""
The corresponding directory "/srv/tomcat/localhost/ProxyTest" contains
the 3 aforementioned classes, and I even can activate the
"Application" in the tomcat manager, but I get 404s for http://localhost/ProxyTest
and http://localhost/ProxyTest/IfxJDBCProxy.

Now, from the little I understand from servlets, they need to be more
than just a plain directory with some java classes in it, but I
couldn't do more a the point I have come to than trying to copy one of
the example servlets and meddle around with it until it bows to my
will, which really isn't the purpose of the test.

In the end, I think my question would be: Has anyone gotten the
JDBCProxy to work and could share the results? Or if not, is there at
least someone servlet/tomcat-savvy enough to help me out with this one?

Thanks a bunch, and have a nice monday Smile

Felix

 >> Stay informed about: Trouble getting JDBCProxy Servlet to work 
Back to top
Login to vote
Holger de Wall

External


Since: Nov 09, 2009
Posts: 1



(Msg. 2) Posted: Mon Nov 09, 2009 5:25 am
Post subject: Re: Trouble getting JDBCProxy Servlet to work [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

you need a servlet engine for running the servlet IfxJDBCProxy.class.

My configuration with Tomcat 5.5:
1) put the Informix-JDBC driver ifxjdbc.jar in $CATALINA_HOME/common/lib/
2) put the 3 classes IfxJDBCProxy.class,
SessionMgr.class and TimeoutMgr.class in $CATALINA_HOME/common/classes/
3) edit your Tomcat configuration file $CATALINA_HOME/conf/web.xml
- uncomment the block
------------------
<servlet>
<servlet-name>invoker</servlet-name>
<servlet-class>
org.apache.catalina.servlets.InvokerServlet
</servlet-class>
<init-param>
<param-name>debug</param-name>
<param-value>0</param-value>
</init-param>
<load-on-startup>2</load-on-startup>
</servlet>
------------------
- and uncomment the block
------------------
<servlet-mapping>
<servlet-name>invoker</servlet-name>
<url-pattern>/servlet/*</url-pattern>
</servlet-mapping>
------------------

4) (Re)start Tomcat
5) Test the URL http://localhost:8080/servlet/IfxJDBCProxy
- it should show
"-- Informix Proxy Servlet v220 Servlet API 2.5 --"

The configuration with Tomcat 6 is nearly the same. You have to create
the path $CATALINA_HOME/common/lib and $CATALINA_HOME/common/classes.


Felix Schäfer schrieb:
> Hello,
>
> We are having trouble deploying the Informix JDBCProxy Servlet, and as
> we are neither accustomed to tomcat/other servlet server, nor is the
> documentation provided by IBM extensive to the point that it put me on
> the right track, I thought maybe some of you people got it working.
>
> Anyway, long story short, the docs can be found here
> http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp (search
> for proxy, click "Using an HTTP Proxy Server", in german it's the second
> hit), and they say to put the 3 classes mentioned in a servlet
> directory, which already is the point where I'm a little at a loss. I
> tried reading some tomcat6 documentation, and even came up with a
> context xml file:
> """
> <?xml version="1.0" encoding="UTF-8"?>
> <Context path="/ProxyTest"
> docBase="/srv/tomcat/localhost/ProxyTest"
> antiResourceLocking="false" privileged="false" />
> """
> The corresponding directory "/srv/tomcat/localhost/ProxyTest" contains
> the 3 aforementioned classes, and I even can activate the "Application"
> in the tomcat manager, but I get 404s for http://localhost/ProxyTest and
> http://localhost/ProxyTest/IfxJDBCProxy.
>
> Now, from the little I understand from servlets, they need to be more
> than just a plain directory with some java classes in it, but I couldn't
> do more a the point I have come to than trying to copy one of the
> example servlets and meddle around with it until it bows to my will,
> which really isn't the purpose of the test.
>
> In the end, I think my question would be: Has anyone gotten the
> JDBCProxy to work and could share the results? Or if not, is there at
> least someone servlet/tomcat-savvy enough to help me out with this one?
>
> Thanks a bunch, and have a nice monday Smile
>
> Felix

 >> Stay informed about: Trouble getting JDBCProxy Servlet to work 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Trouble with update statistics - We had/have some trouble with update statistics here. Because it's not so simple to describe in short I send the whole story: - IDS 9.40.FC4W2 - Solaris 5.9 Generic_117171-12 sun4u sparc SUNW,Netra-T12 - Table contains about 800,000,000 rows -..

Trouble with the IIUG voting site? - Hey! I was up last night around 11:00pm Central and I just happened to go to the IIUG site. They had a link up for the voting so I thought hey! Why not? (You know what they say about Chicago and voting* ;-) When I clicked on the link, I got a strang...

Informix Shared Library Trouble - I am trying to create a shared library written in C which is using lots of Informix functions such as `ibm_lib4gl_popQuotedStr'. Platform is Linux and compiler is GCC. But I am getting linker error, "undefined reference" for all the Informix f...

Trouble restoring database on test/recovery system - Trouble restoring database on test system (IDS 9.40.HC3 on HP-UX 11i (11v1) Yesterday when I was restoring the production database on the test/recovery server I got some errors I never gotten before. I have done this processes 20-30 times in the last ...

Up Arrow doesn't work on form - I have created my first form and 4GL report, but when navigating the form the up arrow key doesn't put the cursor to the previous field. I can only go forward through the fields with either enter, down arrow or right arrow. Isn't it a default for up..
   Database Help (Home) -> Informix All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]