|
|
|
|
|
|
|
Re: Preview Pane can't find jt400.jar [message #760267 is a reply to message #760239] |
Thu, 01 December 2011 17:42 |
Joe Pluta Messages: 62 Registered: November 2011 |
Member |
|
|
I changed my jar file. Here's what I see in my binding file (t1sql-bnd.xml in .metadata\.plugins\org.eclipse.datatools.connectivity). Names and passwords have been changed to protect the guilty. jt400_7.5.1.jar is the new one I just downloaded. I continue to receive the "no suitable driver" message both in the preview pane and in the deployed project.
<?xml version="1.0" encoding="UTF-8"?>
<egldd>
<bindings>
<binding name="DB2DEVTESTCCIWEB" type="edt.binding.sql" uri="workspace://DB2 DEVTEST CCIWEB" useURI="false">
<parameters>
<parameter name="jarList" value="C:\util\jars\jt400_7.5.1.jar"/>
<parameter name="sqlDB" value="jdbc:as400:MYI;prompt=false"/>
<parameter name="sqlJDBCDriverClass" value="com.ibm.as400.access.AS400JDBCDriver"/>
<parameter name="sqlPassword" value="MYPASSWORD"/>
<parameter name="dbms" value="DB2 UDB iSeries V5R3"/>
<parameter name="sqlSchema" value="MYSCHEMA"/>
<parameter name="sqlID" value="MYUSER"/>
</parameters>
</binding>
</bindings>
<includes>
</includes>
</egldd>
[Updated on: Thu, 01 December 2011 17:50] Report message to a moderator
|
|
|
Re: Preview Pane can't find jt400.jar [message #760274 is a reply to message #760267] |
Thu, 01 December 2011 18:00 |
Joe Pluta Messages: 62 Registered: November 2011 |
Member |
|
|
Okay, I changed the project to use a connection named DB2CONN1, and then exported it to an archive which I attached to this post. If you want to see if you can get it to work, you should be able to just import the project and either create DB2CONN1 as a connection or modify the library part (DataLib) to point to an existing connection.
It will certainly fail, but the point is whether it will fail with "no suitable driver" or with some sort of schema or table not found message. The latter would indicate that I have some sort of severe and fatal configuration problem.
(I had to attach a new version of the archive; the old one did not point to DB2CONN1.)
[Updated on: Thu, 01 December 2011 18:34] Report message to a moderator
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03712 seconds