Connecting DB2/as400 to Rapid Analytics using jt400 driver
So, I got RA up and running in Ubuntu Linux. Everything seems to be working correctly so far, but for some reason I can't add a connection for our as400s...
I followed the directions in this post as closely as I could:
http://rapid-i.com/rapidforum/index.php/topic,4437.0.html
I ended up putting the jt400.jar into //server/default/lib
I put the db2-400-ds.xml into //server/default/deploy
And it had this text in it (schema, username and password redacted, they are correct in my implementation)
What am I doing wrong? I did change the .xml file a bit so that the connection string more closely matched the working string I have in RapidMiner (after trying it the standard way first), but other than that I feel like I followed the instructions to the letter...
I followed the directions in this post as closely as I could:
http://rapid-i.com/rapidforum/index.php/topic,4437.0.html
I ended up putting the jt400.jar into //server/default/lib
I put the db2-400-ds.xml into //server/default/deploy
And it had this text in it (schema, username and password redacted, they are correct in my implementation)
After doing all of this I go into RapidAnalytics at "localhost:8080" and sign in. I go to Administration > Data Connections > Create New Connection Entry. When I go to the drop down for the different DBs though my DB2/400 doesn't show up?
<datasources>
<local-tx-datasource>
<jndi-name>DB2-400</jndi-name>
<connection-url>jdbc:as400:*********;prompt=false;extended dynamic=true;package=jbpkg;package cache=true;package library=jboss;errors=full</connection-url>
<driver-class>com.ibm.as400.access.AS400JDBCDriver</driver-class>
<user-name>*******</user-name>
<password>*******</password>
<min-pool-size>0</min-pool-size>
<!-- sql to call when connection is created
<new-connection-sql>some arbitrary sql</new-connection-sql>
-->
<!-- sql to call on an existing pooled connection when it is obtained from pool
<check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
-->
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
<metadata>
<type-mapping>DB2/400</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
What am I doing wrong? I did change the .xml file a bit so that the connection string more closely matched the working string I have in RapidMiner (after trying it the standard way first), but other than that I feel like I followed the instructions to the letter...