Tom Z. Smith

Specifically, I'm trying to use a single installation of Tomcat 6 to provide our developers with the ability to use more than 1 instance of Tomcat and the problem I'm having pertains to how the JAR files aren't being loaded inside each instance's "lib" directory.

Example: I have 2 instances of Tomcat running on this machine (i.e. - "test1" and "test2"; both are used for various stages of testing and migration).
To start test1, I would use the following approximate console command: "test1_instance start".
For test2, it would be "test2_instance start", respectively.

Instead of putting all JAR files inside the root Tomcat lib directory, we thought it would be efficient to let each instance directory have their own lib directory and load stage-specific JAR files inside these while leaving all "GLOBAL" JAR files inside the Tomcat root's lib directory. Unfortunately, it's not working and we're pretty lost as to why.

test1 startup script -

#!/bin/bash # # tomcat # # chkconfig: 345 96 30 # description: Start up the Tomcat servlet engine. # Source function library. . /etc/init.d/functions RETVAL=$? export CATALINA_BASE="/usr/tomcat/test1" export CATALINA_HOME="/usr/tomcat/tomcat-home" export CATALINA_OPTS="-Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port=8082 -Dcom.sun.management.jmxremote.ssl=false -Dcom.sun.management.jmxremote.authenticat$ case "$1" in start) if [ -f $CATALINA_HOME/bin/startup.sh ]; then echo $"Starting Tomcat" /bin/su tomcat -c $CATALINA_HOME/bin/startup.sh fi ;; stop) if [ -f $CATALINA_HOME/bin/shutdown.sh ]; then echo $"Stopping Tomcat" /bin/su tomcat -c $CATALINA_HOME/bin/shutdown.sh fi ;; *) echo $"Usage: $0 {start|stop}" exit 1 ;; esac exit $RETVAL

test2 startup script -

#!/bin/bash # # tomcat # # chkconfig: 345 96 30 # description: Start up the Tomcat servlet engine. # Source function library. . /etc/init.d/functions RETVAL=$? export CATALINA_BASE="/usr/tomcat/test2" export CATALINA_HOME="/usr/tomcat/tomcat-home" export CATALINA_OPTS="-Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port=8081 -Dcom.sun.management.jmxremote.ssl=false -Dcom.sun.management.jmxremote.authenticat$ case "$1" in start) if [ -f $CATALINA_HOME/bin/startup.sh ]; then echo $"Starting Tomcat" /bin/su tomcat -c $CATALINA_HOME/bin/startup.sh fi ;; stop) if [ -f $CATALINA_HOME/bin/shutdown.sh ]; then echo $"Stopping Tomcat" /bin/su tomcat -c $CATALINA_HOME/bin/shutdown.sh fi ;; *) echo $"Usage: $0 {start|stop}" exit 1 ;; esac exit $RETVAL


And the "base" startup script that the above tie into has the following:
# Better OS/400 detection: see Bugzilla 31132 os400=false darwin=false case "`uname`" in CYGWIN*) cygwin=true;; OS400*) os400=true;; Darwin*) darwin=true;; esac # resolve links - $0 may be a softlink PRG="$0" while [ -h "$PRG" ] ; do ls=`ls -ld "$PRG"` link=`expr "$ls" : '.*-> \(.*\)$'` if expr "$link" : '/.*' > /dev/null; then PRG="$link" else PRG=`dirname "$PRG"`/"$link" fi done PRGDIR=`dirname "$PRG"` EXECUTABLE=catalina.sh # Check that target executable exists if $os400; then # -x will Only work on the os400 if the files are: # 1. owned by the user # 2. owned by the PRIMARY group of the user # this will not work if the user belongs in secondary groups eval else if [ ! -x "$PRGDIR"/"$EXECUTABLE" ]; then echo "Cannot find $PRGDIR/$EXECUTABLE" echo "This file is needed to run this program" exit 1 fi fi exec "$PRGDIR"/"$EXECUTABLE" start "$@"

Do you have any idea what we're doing wrong here?

Anyone? If you need more info, let me know. This problem is really making me scratch a hole into my head...

So it turns out that my team has installed 2 instances of Tomcat 6 on our Red Hat server. This server is used for testing and each instance represents a layer of testing as it pertains to the migration path of our application development...

Anyway, we're trying to implement a fairly unique approach for class loading. Right now, we have demarcated Tomcat by providing our developers the means to reference "GLOBAL" jar files inside the $CATALINA_HOME/lib directory whereas for each testing stage (i.e. - "test1" and "test2"), we would like to provide the means to reference jar files inside each testing directory.

So to better illustrate our intentions, let's say you're working on our server and need to test it inside "test1" first before deploying into "test2." The only concern is that your application uses a specific jar file that provides some functionality a client needs, but you don't want it available to every instance--just test1.

In other words, how can we make each instance have their own lib? From what I understand, this involves the use of the CATALINA.PROPERTIES file, but I'm uncertain as to how this needs to be configured.

Any insight into this is appreciated.

I'm trying to implement a web service using Eclipse Indigo and CXF 2.x with Java 1.6 and I keep bombing out when I try to run and test the client locally through Eclipse. In the console, I keep getting an error message about "None of the policy alternatives can be satisfied" and so far there has been absolutely nobody capable of both understanding this situation and or fixing it. I'm not even completely sure where it's coming from...

It seems the basic approach to creating a TOP-DOWN web service in Eclipse is as follows:

1.) Create a Dynamic Web Project.
2.) Import your WSDL file.
3.) Create a Web Service.
4.) Create a Client Web Service.

Basic, right? Well, it doesn't seem to properly work this way if you intend on using security features (which, duh, we all want, right?). That said, the addition of security means that one needs to use the following element inside a WSDL:

<wsp:Policy wsu:Id="UsernameTokenSecurityPolicyPasswordOptional" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd"> <wsp:ExactlyOne> <wsp:All> <wsse:SecurityToken wsp:Usage="wsp:Required" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd"> <wsse:TokenType>wsse:UserNameToken</wsse:TokenType> <Claims> <SubjectName MatchType="wsse:Exact" /> <UsePassword wsp:Usage="wsp:Optional" /> </Claims> </wsse:SecurityToken> </wsp:All> </wsp:ExactlyOne> </wsp:Policy>

Unless I'm mistaken, this should basically imply that some form of authentication between the two consuming parties will be used, but is this even right?

We've been trying to get this implemented for the past 2 months and no matter what we tweak, change, edit, or update, it just doesn't work or seem to do a single thing and we've suspected that it has something to do with how the WSDL has been made (we've received it from a client)...

Our entire WSDL is as follows:

<?xml version="1.0" encoding="UTF-8"?> <wsdl:definitions xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:tns="http://soap.membersystems.com/member/MemberCheck.2" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" targetNamespace="http://soap.membersystems.com/member/MemberCheck.2" name="MemberCheck.2"> <wsp:UsagePolicy wsdl:Required="true" /> <wsdl:types> <xsd:schema xmlns:tns="http://soap.membersystems.com/member/MemberCheck.2" xmlns:xsd="http://www.w3.org/2001/XMLSchema" version="1.0" targetNamespace="http://soap.membersystems.com/member/MemberCheck.2"> <xsd:element name="checkMemberRequest" type="tns:checkMemberRequest" /> <xsd:element name="checkMemberResponse" type="tns:checkMemberResponse" /> <xsd:complexType name="checkMemberRequest"> <xsd:sequence> <xsd:choice> <xsd:element name="memberId" type="xsd:string" /> <xsd:element name="memberMatch" type="tns:memberMatch" /> </xsd:choice> </xsd:sequence> </xsd:complexType> <xsd:complexType name="memberMatch"> <xsd:sequence> <xsd:element name="dateOfBirth" type="xsd:date" minOccurs="0" /> <xsd:element name="degree" type="xsd:string" minOccurs="0" /> <xsd:element name="yearGraduated" type="xsd:string" minOccurs="0" /> <xsd:element name="firstYearAttended" type="xsd:string" minOccurs="0" /> <xsd:element name="lastYearAttended" type="xsd:string" minOccurs="0" /> <xsd:element name="ssnLast4" type="xsd:string" minOccurs="0" /> <xsd:element name="previousSchool" type="xsd:string" minOccurs="0" /> <xsd:element name="memberId" type="xsd:string" minOccurs="0" /> <xsd:element name="firstName" type="xsd:string" minOccurs="0" /> <xsd:element name="lastName" type="xsd:string" minOccurs="0" /> <xsd:element name="middleName" type="xsd:string" minOccurs="0" /> <xsd:element name="custom" type="tns:customData" minOccurs="0" maxOccurs="unbounded" /> </xsd:sequence> </xsd:complexType> <xsd:complexType name="customData"> <xsd:sequence> <xsd:element name="name" type="xsd:string" /> <xsd:element name="value" type="xsd:string" /> </xsd:sequence> </xsd:complexType> <xsd:complexType name="checkMemberResponse"> <xsd:sequence> <xsd:element name="memberId" type="xsd:string" minOccurs="0" /> <xsd:element name="memberStatus" type="tns:memberStatus" /> <xsd:element name="memberStatusMessage" type="xsd:string" /> <xsd:element name="ude" type="tns:userDefinedExtension" minOccurs="0" /> </xsd:sequence> </xsd:complexType> <xsd:simpleType name="memberStatus"> <xsd:restriction base="xsd:string"> <xsd:enumeration value="NOMATCH" /> <xsd:enumeration value="HOLD" /> <xsd:enumeration value="OK" /> </xsd:restriction> </xsd:simpleType> <xsd:complexType name="userDefinedExtension"> <xsd:sequence> <xsd:any namespace="##other" processContents="lax"/> </xsd:sequence> </xsd:complexType> </xsd:schema> </wsdl:types> <wsdl:message name="checkMemberRequest"> <wsdl:part name="parameters" element="tns:checkMemberRequest" /> </wsdl:message> <wsdl:message name="checkMemberResponse"> <wsdl:part name="parameters" element="tns:checkMemberResponse" /> </wsdl:message> <wsdl:portType name="MemberCheck"> <wsdl:operation name="checkMember"> <wsdl:input message="tns:checkMemberRequest" /> <wsdl:output message="tns:checkMemberResponse" /> </wsdl:operation> </wsdl:portType> <wsdl:binding name="MemberCheckPortBinding" type="tns:MemberCheck"> <soap:binding transport="http://schemas.xmlsoap.org/soap/http" style="document" /> <wsdl:operation name="checkMember"> <soap:operation soapAction="" style="document" /> <wsp:Policy wsu:Id="UsernameTokenSecurityPolicyPasswordOptional" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd"> <wsp:ExactlyOne> <wsp:All> <wsse:SecurityToken wsp:Usage="wsp:Required" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd"> <wsse:TokenType>wsse:UserNameToken</wsse:TokenType> <Claims> <SubjectName MatchType="wsse:Exact" /> <UsePassword wsp:Usage="wsp:Optional" /> </Claims> </wsse:SecurityToken> </wsp:All> </wsp:ExactlyOne> </wsp:Policy> <wsdl:input> <soap:body encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" use="literal" /> </wsdl:input> <wsdl:output> <soap:body encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" use="literal" /> </wsdl:output> </wsdl:operation> </wsdl:binding> <wsdl:service name="MemberCheck"> <wsdl:port name="MemberCheckPort" binding="tns:MemberCheckPortBinding"> <soap:address location="http://devtest.exmapleblahwhateveretc.com:8080/member/MemberCheck" /> </wsdl:port> </wsdl:service> </wsdl:definitions>

We've had quite the time getting this implemented due to a plethora of reasons. At first, we tried the antiquated version of AXIS and with this, we got it to work but without any kind of security. As soon as we put the security inside the WSDL, it bombed. We then tried AXIS2, but that couldn't get anything generated in the form of a stub. Finally, we tried CXF and in my opinion, this seems to get us further than both but some tiny issue is preventing us from finishing the routine and I'm thinking it's a tiny bottleneck somewhere--just don't know where it's coming from. I'm worried it has something to do with the WSDL, but who knows?

XML is definitely a foreign technology when it comes to WSDL stuff. I've learned a lot, for sure, but truly need help getting all this working. If anyone could shine some light, it would be appreciated.

My apologies everyone, but I solved it...

I had been not only using single-quotes around the replacement token or substitution variable, but also included a semi-colon at the end of the query string! Ha. Hot damn!
(Java Ranch lingo, kiddies.)

Hi everyone... This is my first post, so let me know if you need anything else from me...

Basically, I'm having problems with my database object being able to do setString(). I'm not sure why. I think it's something to do with how I'm trying to use FOREACH logic with a hashmap to swap SQL queries? Who knows, but I do hope that someone around here can help me understand what's causing my woes.

Here's some of the code:
... String st_999 = usr_userData.getUserId(); try{ if(st_id != null){ if(checkPID(ora_conn, st_id)){ st_returnPID = st_id; }else{ throw new NoMatchException("Identifier is invalid."); } }else{ HashMap<String, String> queryMap = new HashMap<String, String>(); queryMap.put("query1", "SELECT table1_id FROM table1, table2 WHERE table1_id = table2_id AND table1_id = '?' AND table1_first_name = 'John' AND table1_last_name = 'Doe' AND table1_change_ind IS NULL;"); queryMap.put("query2", "SELECT DISTINCT(table1_id) FROM table1, table2 WHERE table1_id = TO_CHAR(?) AND table1_first_name = '?' AND table1_last_name = '?' AND table2_birth_date = TO_DATE('?','MM/DD/YYYY') AND table1_change_ind IS NULL"); Set<Map.Entry<String, String>> coll_queries = queryMap.entrySet(); Iterator<Map.Entry<String, String>> itr_queries = coll_queries.iterator(); try{ while(itr_queries.hasNext()){ Map.Entry<String, String> item = itr_queries.next(); if(item.getKey().equals("query1")){ prep_sql_statement = ora_conn.prepareStatement(queryMap.get("query1")); prep_sql_statement.setString(1, st_999); //prep_sql_statement.setString(2, st_firstName); //prep_sql_statement.setString(3, st_lastName); //prep_sql_statement.setDate(4, dt_dob); returnedQuery = prep_sql_statement.executeQuery(); System.out.println("Made it."); if(returnedQuery.next()){ ...

And here's the stack dump it's generating:

java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:207)
at oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:5328)
at oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:5320)
at <mypackage>.UserCheck_2.Authenticate.authenticate(Authenticate.java:153)
at <mypackage>.UserCheck_2.UserCheckPortBindingImpl.checkUser(UserCheckPortBindingImpl.java:40)
at <mypackage>.UserCheckPortBindingSkeleton.checkUser(UserCheckPortBindingSkeleton.java:56)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)

What's causing this? As far as I know, the data types are correct...