Subject: RE: VSAM Redirector Problem
From: Mike Moore (mike.moore@alacourt.gov)
Date: Tue Jun 17 2008 - 14:28:09 EDT
Steve, Can you get to the database with the Mapper to load existing mappings? Mike Moore IT Manager Alabama Judicial Datacenter 300 Dexter Ave Montgomery, AL 36104 334-954-5025 -----Original Message----- From: owner-vse-l@Lehigh.EDU [mailto:owner-vse-l@Lehigh.EDU] On Behalf Of Steve Sheerin Sent: Tuesday, June 17, 2008 1:20 PM To: VSE Discussion List Subject: RE: VSAM Redirector Problem Mike, I checked my classpath against yours. The attached list shows I had mostly the same, but no JAVA, and extra for CICS2WS. Also had duplicate entries. Cleaned it up, but get same results. "Create of database tables failed: java.sql.SQLException: No suitable driver" Steve -----Original Message----- From: owner-vse-l@Lehigh.EDU [mailto:owner-vse-l@Lehigh.EDU] On Behalf Of Mike Moore Sent: Tuesday, June 17, 2008 10:42 AM To: VSE Discussion List Subject: RE: VSAM Redirector Problem Steve, Here is the classpath: ..;VsamRedir.jar;;C:\Program Files\Java\jre1.6.0_05\lib;C:\Program Files\IBM\VSE Connector Client\VSEConnector.jar;C:\Program Files\IBM\VSE Connector Client\cci.jar;C:\Program Files\IBM\VSE Connector Client\ibmjsse.jar;C:\Program Files\IBM\VSE Connector Client\ibmpkcs.jar;C:\Program Files\Java\jre1.5.0_14\lib\charsets.jar;C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.2\enu\sqljdbc.jar Mike Moore IT Manager Alabama Judicial Datacenter 300 Dexter Ave Montgomery, AL 36104 334-954-5025 -----Original Message----- From: owner-vse-l@Lehigh.EDU [mailto:owner-vse-l@Lehigh.EDU] On Behalf Of Steve Sheerin Sent: Tuesday, June 17, 2008 12:05 PM To: VSE Discussion List Subject: RE: VSAM Redirector Problem Yes, 'MSSQL' Steve -----Original Message----- From: owner-vse-l@Lehigh.EDU [mailto:owner-vse-l@Lehigh.EDU] On Behalf Of Mike Moore Sent: Tuesday, June 17, 2008 9:54 AM To: VSE Discussion List Subject: RE: VSAM Redirector Problem Steve, In the 'Target Overview' box where it builds the SQL statements, what do you have in the drop-down box in the lower lefthand corner? Does it say 'MSSQL'? Mike Moore IT Manager Alabama Judicial Datacenter 300 Dexter Ave Montgomery, AL 36104 334-954-5025 -----Original Message----- From: owner-vse-l@Lehigh.EDU [mailto:owner-vse-l@Lehigh.EDU] On Behalf Of Steve Sheerin Sent: Tuesday, June 17, 2008 10:52 AM To: VSE Discussion List Subject: VSAM Redirector Problem I am trying to start using the VSAM Redirector. Connector Server is installed and I ran some of the samples, they worked. Redirector is installed and I am trying to create SQL database tables, using the configuration tool. I've installed the JDBC driver for MS SQL 2005, and when the tool starts is gives me this: C:\Program Files\IBM\VSE VSAM Redirector Server>Rem ---------------------------- ----------------------- C:\Program Files\IBM\VSE VSAM Redirector Server>Rem Startup file for MapperConfi gGui C:\Program Files\IBM\VSE VSAM Redirector Server>Rem ---------------------------- ----------------------- C:\Program Files\IBM\VSE VSAM Redirector Server>set classpath=.;VsamRedir.jar;ma pperconfiggui.jar;C:\Program Files\IBM\VSE Connector Client\VSEConnector.jar;C:\ Program Files\IBM\VSE Connector Client\cci.jar;C:\Program Files\IBM\VSE Connecto r Client\ibmjsse.jar;C:\Program Files\IBM\VSE Connector Client\ibmpkcs.jar;c:Pro gram Files\IBM\cics2ws\cics2ws.jar;C:\Program Files\IBM\VSE Connector Client\VSE Connector.jar;C:\Program Files\IBM\VSE Connector Client\cci.jar;C:\Program Files \IBM\VSE Connector Client\ibmjsse.jar;C:\Program Files\IBM\VSE Connector Client\ ibmpkcs.jar;C:\Program Files\IBM\VSE Connector Client\Navigator.jar;C:\Program F iles\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.2\enu\sqljdbc.jar C:\Program Files\IBM\VSE VSAM Redirector Server>java com.ibm.vse.mapperconfiggui ..MapperConfigGui >>> Registration of JDBC driver classes: Successfully registered class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'. <<< Finished registration of JDBC driver classes. Loaded converter for type: PACKED Loaded converter for type: DATETIME Loaded converter for type: INTEGER Loaded converter for type: FLOAT Loaded converter for type: FIXEDTEXTNUMBER Loaded converter for type: BIT Loaded converter for type: BINARY Loaded converter for type: HEXCHAR Loaded converter for type: STRING Loaded converter for type: FLOATTEXTNUMBER Loaded converter for type: ZONED Loaded converter for type: S2Y Loaded converter for type: TOD Loaded 13 converters. Which is error free, there was the CP1047 issue, but I took care of that. When I try to create the tables I get this: "Create of database tables failed: java.sql.SQLException: No suitable driver" Anyone see this before, and have a fix ?? Steve Sheerin Clark Public Utilities ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________
This archive was generated by hypermail 2b25 : Sun Jul 27 2008 - 05:35:08 EDT