Subject: RE: VSAM Redirector Problem
From: Mike Moore (mike.moore@alacourt.gov)
Date: Tue Jun 17 2008 - 13:19:03 EDT
Here is my startup: 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 ---------------------------- ----------------------- >>> Registration of JDBC driver classes: Class 'org.hsqldb.jdbcDriver' not found. Class 'com.ibm.db2.jcc.DB2Driver' not found. Class 'COM.ibm.db2.jdbc.net.DB2Driver' not found. Class 'com.microsoft.jdbc.sqlserver.SQLServerDriver' not found. Class 'com.ibm.db2.jdbc.app.DB2Driver' not found. Class 'COM.ibm.db2.jdbc.app.DB2Driver' not found. Class 'oracle.jdbc.driver.OracleDriver' not found. Class 'com.informix.jdbc.IfxDriver' not found. Class 'com.mysql.jdbc.Driver' not found. 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. 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 archive was generated by hypermail 2b25 : Mon Jun 30 2008 - 23:50:12 EDT