Filip, here is my configuration so far: I have created a test application under the tomcat webapps folder with the following structure:
IDMSTest/ IDMSTest/WEB-INF/ IDMSTest/WEB-INF/classes/ IDMSTest/WEB-INF/lib/ IDMSTest/WEB-INF/web.xml IDMSTest/WEB-INF/test.jsp Here is my IDMSTest/WEB-INF/web.xml file: <?xml version="1.0" encoding="UTF-8"?> <web-app xmlns="http://java.sun.com/xml/ns/j2ee"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"; version="2.4"> <description>IDMS Test App</description> <resource-ref> <description>DB Connection</description> <res-ref-name>jdbc/TestIDMS</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> </web-app> I also added the following to tomcat/conf/server.xml: <!-- Tomcat JDBC to IDMS Test Context --> <Context path="/IDMSTest" docBase="IDMSTest" reloadable="true" crossContext="true"> <Resource name="jdbc/TestIDMS" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="MY_USER" password="MY_PASS" driverClassName="ca.idms.jdbc.IdmsJdbcDriver" url="jdbc:idms://MY.IP.ADDRESS:MY.PORT/MY_DATABASE" /> </Context> Then I have a test.jsp in the IDMSTest/ folder with the following code: <%@ taglib uri="http://java.sun.com/jsp/jstl/sql"; prefix="sql" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/core"; prefix="c" %> <sql:query var="rs" dataSource="jdbc/testIDMS"> select text_message from messages </sql:query> <html> <head> <title>IDMS DB Test</title> </head> <body> <h2>Results</h2> <c:forEach var="i" items="${rs.rows}"> Text Message: <c:out value="${i.text_message}"/><br> </c:forEach> </body> </html> However, I can't actually test anything yet, as the IDMS is not setup to listen to JDBC requests. I just wanted to be clear that my configuration and syntax on the Linux / Tomcat side are correct for when I do come to test a connection. The SQL query and query handling code in the JSP file would differ depending upon the database structure, obviously.....but does everything look like its setup OK? Where would the javax.naming.spi.ObjectFactory implementation come into it? There are some remaining issues I have about how to setup and use the caidms.properties file and the caidms.cfg file. I've uploaded the 2 files as they contain quite a lot of code: http://www.nabble.com/file/p21451684/caidms.cfg caidms.cfg http://www.nabble.com/file/p21451684/caidms.properties caidms.properties regards Jp Filip Hanik - Dev Lists wrote: > > If your JDBC driver has a DataSource, then check to see if it has a > > javax.naming.spi.ObjectFactory implementation, this is the one you would > specify in the factory="some.impl.DataSourceFactory" attribute, for > example. > Some drivers don't have factories, and then you simply use Tomcat's own > factory by omitting the factory attribute. > In this case, Tomcat will provide the DataSource that is a wrapper > around your driver. > > Provide > 1. the configuration (only relevant parts) > 2. the error you get > > > Filip > > jpmad4it wrote: >> Hi there, >> >> I have a rather interesting / complex problem......creating a connection >> to >> CA-IDMS from Tomcat using JDBC type 4 drivers (CA provide the type 4 >> driver). >> >> We have a zSeries 9 IBM mainframe running CA-IDMS r16.1, and I need to >> connect to the IDMS from Tomcat (running on Linux) using the JDBC Type 4 >> drivers provided by CA. >> >> At this stage I am struggling with the actual setup and configuration of >> Tomcat’s server.xml and web.xml files. These are the files where the JDBC >> configuration is set (I think). I have to setup the CA-IDMS part of the >> configuration, but that is a different problem. Basically there is a >> TCP/IP >> listener on the IDMS, waiting for incoming connections from the JDBC type >> 4 >> driver. >> >> I set up a Tomcat to MySQL connection using MySQL Connector / J, which is >> a >> similar kind of process to what I am trying to achieve with IDMS. MySQL >> connector / J came with a jar file which is placed in Tomcat’s lib >> folder, >> and then the JDBC setup for the web application is created in Tomcat's >> server.xml and web.xml files. You can then connect to the MySQL database >> using JSP and the configured JDBC driver / connection. The CA-IDMS Server >> comes with an idmsjdbc.jar file, which I think is the JDBC typr 4 driver. >> I >> think it needs to be placed in the Tomcat /lib folder, but I don’t know >> how >> to set up the configuration. >> >> There is a JDBC DriverManager which allows JDBC drivers to connect to >> CA-IDMS. The DriverManager recognises the following syntax: >> >> jdbc:idms://hostname:port/database >> >> This allows the JDBC driver running within Tomcat to connect to the IDMS >> which is running on the IDM mainframe. CA IDMS r16 supports direct >> connections from the Type 4 JDBC driver to the Central Version on IDMS. >> "hostname" is the DNS name or IP address of the machine where the CV is >> running, and "port" is the IP port that was specified for the listener >> PTERM >> (setup on the IDMS side). >> >> There is a caidms.properties file for the JDBC driver, which is used to >> specify user ID, password, and optional accounting information. It can >> also >> be used to specify physical connection information, allowing an >> application >> to connect to a CA-IDMS database without requiring the definition of an >> ODBC >> style data source. However, I don’t know where to place this file within >> the >> Tomcat setup. >> >> There is also an IdmsDataSource class. I don’t know where to configure >> this >> or how to set it up; the CA-IDMS Server manual states the following: >> >> This class implements the JDBC DataSource interface. It is used with an >> application server (Tomcat) providing Java Naming and Directory Interface >> (JNDI) naming service to establish a connection to a CA IDMS database. >> IdmsDataSource properties conform to the Java Beans naming conventions >> and >> are implicitly defined by public “setter” and “getter” methods. For >> example, >> the “description” property, which is required for all DataSource >> implementations, is set using the setDescription(String) method. The >> application server may use the java.lang.reflection methods to discover >> DataSource properties and provide an interface to set them, or may simply >> require that they are defined in some configuration file. IdmsDataSource >> properties are used to specify the connection parameters. These >> properties >> are the equivalent of the DriverPropertyInfo attributes described in the >> previous section and can be used to completely define the parameters >> needed >> to connect to a database. Like a URL, an IdmsDataSource object can also >> reference an “ODBC” style data source name, where the connection >> parameters >> are defined in the configuration file on Linux. >> >> Is there anyone that can try to point me in the right direction to >> setting >> up the JDBC connection? I am totally new to Java and so the instructions >> are >> not making much sense at the moment. Any help, hints, tips…..anything >> will >> be greatly appreciated as I have just hit a brick wall here. I can't find >> much to do with setting up the CA-IDMS Server JDBC type 4 driver online >> either....if anyone can point me to some resources that would also be >> extremely useful. >> >> Kind regards >> Jp >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > > -- View this message in context: http://www.nabble.com/Help%3A-Connecting-Tomcat-to-CA-IDMS-using-JDBC-Type-4-Drivers-%28JNDI---IDMSDataSource%29-tp21433283p21451684.html Sent from the Tomcat - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
