Thanks for the info, Ted
---- Robert Shubert <[email protected]> wrote: > Ted, > > DB2 is not a supported database in the v6 Studio using JDBC. There's no > place to add the JDBC driver. > > I'll make a note of this nd try to get it into the next release. > > ODBC should work as expected. > > Robert > > ---------------------------------------- > > From: [email protected] > Sent: Friday, November 04, 2011 11:43 AM > To: [email protected] > Subject: Witango-Talk: db2 jdbc setup on Windows 2008 > > Hi, > > This is my first attempt to access a DB2 9.7 LUW database with Witango 6 > using JDBC, for that matter first time trying to set up a jdbc connection. > > I was able to set up an ODBC connection to the database successfully and I > am able to connect to the database from Aptana 3 using jdbc. > > The witangoevents.log says: > [ 780] 2011-11-04 10:56:10 START INFO Java Virtual Machine: > Attempting to load C:\Program Files\Java\jre6\bin\client\jvm.dll > [ 780] 2011-11-04 10:56:10 START INFO Java Virtual Machine: > Enabled > [ 780] 2011-11-04 10:56:10 START INFO COM Interface: Enabled > [ 780] 2011-11-04 10:56:10 START INFO JAVABEAN Interface: > Enabled > [ 780] 2011-11-04 10:56:10 START INFO JavaScript-C 1.5 > pre-release 6 2004-01-27 > [ 780] 2011-11-04 10:56:10 START INFO Web Service: Disabled > [ 780] 2011-11-04 10:56:10 START INFO ODBC Interface: Enabled > [ 780] 2011-11-04 10:56:10 START INFO JDBC Interface: Enabled > [ 780] 2011-11-04 10:56:10 START INFO Oracle Call Interface > (OCI): Disabled > [ 780] 2011-11-04 10:56:10 START INFO Listener Address: Any > [ 780] 2011-11-04 10:56:10 START INFO Listener Port: 18160 > [ 780] 2011-11-04 10:56:10 START INFO Worker Threads: 5 > [ 780] 2011-11-04 10:56:11 RUNTIME INFO Startup URL: Skipped empty > URL > [ 780] 2011-11-04 10:56:12 RUNTIME INFO User Requests: Starting > processing > > the jdbc.ini file is set up as: > <?xml version="1.0" encoding="ISO-8859-1" ?> > <!DOCTYPE JDBCINI SYSTEM "jdbcini.dtd"> > <JDBCINI Version="0x00010000"> > <DataSources> > <DataSource ID="Discover"> > <DSN>Discover</DSN> > > <DriverClass>com.ibm.db2.jcc.DB2Driver</DriverClass> > <URL>jdbc:db2://GRRHIODBR:50000/DISCOVER</URL> > <Properties> > <Property ID=""> > <Name></Name> > <Value></Value> > </Property> > </Properties> > </DataSource> > <DataSource ID="Canonical"> > <DSN>Canonical</DSN> > > <DriverClass>com.ibm.db2.jcc.DB2Driver</DriverClass> > <URL>jdbc:db2://10.1.103.75:50000/DISCOVER</URL> > <Properties> > <Property ID=""> > <Name></Name> > <Value></Value> > </Property> > </Properties> > </DataSource> > > </DataSources> > </JDBCINI> > > In the Witango Studio, after I fill in the settings for a new jdbc > datasource, I get the following error: > "Init JAVE error!" > > Am I missing a step? > > Thanks > > Ted > > ---------------------------------------- > > To unsubscribe from this list, please send an email to [email protected] > with "unsubscribe witango-talk" in the body. > > > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to [email protected] > with "unsubscribe witango-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
