OK, Thanks!!!! This is the solution.
I connect to my as400 with jdbc:as400://<db400 address> and my sql select is, for example <your SQL query>=select * from <db400 library>.<db400 table> I only have one connection with as400. If you do jdbc:as400://<db400 address>/<db400 library> you will do connections for every library. Thanks! --- "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> escribió: > - Add this on Torque.properties under Jetspeed/conf > > torque.database.another=db400conn > > ### DB400 > torque.dsfactory.db400conn.connection.driver = > com.ibm.as400.access.AS400JDBCDriver > torque.dsfactory.db400conn.connection.url = > jdbc:as400://<db400 address>/<db400 library> > torque.dsfactory.db400conn.connection.user = <your > username> > torque.dsfactory.db400conn.connection.password = > <your password> > > torque.dsfactory.db400conn.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory > # The number of database connections to cache per > ConnectionPool instance (specified per database) > torque.dsfactory.db400conn.pool.defaultMaxConnections=10 > torque.dsfactory.db400conn.pool.maxExpiryTime=3600 > torque.dsfactory.db400conn.pool.connectionWaitTimeout=10 > > - Add this on demo-portlets.xreg under Jetspeed/conf > > <portlet-entry name="DatabaseBrowserTestDB400" > hidden="false" type="ref" > parent="DatabaseBrowserPortlet" application="false"> > <meta-info> > <title>DatabaseBrowserTestDB400</title> > <description>Simple Test Database > Browser Portlet Example DB400</description> > </meta-info> > > > <classname>org.apache.jetspeed.portal.portlets.VelocityPortlet</classname> > > <parameter name="sql" value="<your SQL query>" > type="style" hidden="false" cachedOnName="true" > cachedOnValue="true"> > <security-ref parent="admin-only"/> > <meta-info> > <title>SQL Query</title> > </meta-info> > </parameter> > > <parameter name="poolname" value="db400conn" > hidden="false" cachedOnName="true" > cachedOnValue="true"/> > > <parameter name="sql.style" value="TextArea" > hidden="true" cachedOnName="true" > cachedOnValue="true"/> > > <parameter name="windowSize" value="5" > hidden="false" cachedOnName="true" > cachedOnValue="true"> > <meta-info> > <title>Window Size</title> > <description>Number of rows per page > to display</description> > </meta-info> > </parameter> > > <media-type ref="html"/> > > <url cachedOnURL="true"/> > > <category > group="Jetspeed">database</category> > </portlet-entry> > > - Connect to your portal; log in as admin(security > ref has been set on admin only in my example) > Add "DatabaseBrowserTestDB400" choosing it from the > portlet list. > > Then, keep you fingers crossed!! > > Massimiliano Nigrelli ___________________________________________________ Yahoo! Messenger - Nueva versión GRATIS Super Webcam, voz, caritas animadas, y más... http://messenger.yahoo.es --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
