This is a discussion on My Query Report Portlet SQL question - Websphere ; We just installed Websphere Portal V6 for a Proof of Concept project. Everything seems to be working. I've created lots of portlets on pages, etc. I'm attempting to use the My Query Report Portlet to query a SQL db to ...
We just installed Websphere Portal V6 for a Proof of Concept project.
Everything seems to be working. I've created lots of portlets on pages, etc.
I'm attempting to use the My Query Report Portlet to query a SQL db to display some simple data. The default JDBC driver is COM.ibm.db2.jdbc.app.DB2Driver.
my database URL looks like: jdbc:mysql://www.dbserver.com/db
What driver should be used for SQL?
Is there any samples or tutorials for My Query reports portlet for SQL?