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.
