We are going to implement non-standard DB publishing to MySQL and I have setup the system to do so by adding MySQL driver and seting up the rest of the components (rx-ds.xml mod and tablefactory changes), all works fine with my local instance of MySQL(jnditest.jsp shows my target DB OK), however it throws connection exceptions if I try to connect to the remote MySQL - the problems I face now are:
- None of the MySQL options show in JNDI or Connection fields in Table Definition builder tool nor in Server Admin Datasources tab - this is true for both, local or remote.
- No way (at least what I’ve tried so far) to add connection string that will include both SSH host:22 -/uid/pass and DB host:3306(mysql port) -/db-uid/pass
I’ve tried to set an seperate port - L8555 to accept the dual connection through PuTTy - doesn’t work.
What would you sugggest I do here (ex. from rx-ds.xml):
<local-tx-datasource> <jndi-name>jdbc/MySqlDS</jndi-name> <connection-url>jdbc:mysql://localhost:3306/test</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class> <user-name>root</user-name> <password/> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name> <metadata> <type-mapping>mySQL</type-mapping> </metadata> </local-tx-datasource>
It seems like I’m missing the SSH connection string before connecting to DB itself. Or should we just enable some other port on the Target box (other than default 3306) and open HTTP to it from remote.
Thanks in advance for your help.