Re: Jetspeed and torque [SOLUTION]

2004-03-09 Thread Sez Sez 
OK, Thanks

This is the solution.

I connect to my as400 with jdbc:as400://
and my sql select is, for example
=select * from .

I only have one connection with as400. If you do
jdbc:as400:/// 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:///
> torque.dsfactory.db400conn.connection.user =  username> 
> torque.dsfactory.db400conn.connection.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
> 
>  hidden="false" type="ref"
> parent="DatabaseBrowserPortlet" application="false">
> 
> DatabaseBrowserTestDB400
> Simple Test Database
> Browser Portlet Example DB400
> 
> 
>
>
org.apache.jetspeed.portal.portlets.VelocityPortlet
> 
>type="style" hidden="false" cachedOnName="true"
> cachedOnValue="true">
> 
> 
> SQL Query
> 
> 
> 
>  hidden="false" cachedOnName="true"
> cachedOnValue="true"/>
> 
>hidden="true" cachedOnName="true"
> cachedOnValue="true"/>
> 
>hidden="false" cachedOnName="true"
> cachedOnValue="true">
> 
> Window Size
> Number of rows per page
> to display
> 
> 
> 
> 
> 
> 
> 
>  group="Jetspeed">database
> 
> 
> - 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]

Jetspeed and torque

2004-02-23 Thread Sez Sez 
Hi!

I have some problems with torque and
DatabaseBrowserPortlet. 
I changed the hypersonic db and i work with
postgresql. Moreover, i must connect to another
database in DB2/AS400.
When I access to postgresql, i don't have any problem.
For example, i can see the coffee example. But, i
cann't connect with db2. Must i create the
project-schema.xml and create all classes for this db?
If someboy send me his torque.properties and i try to
configure for my case.

Moreover, i don't have the archive torque.log. I try
to configure with 

log4j.rootCategory = DEBUG, org.apache.torque
log4j.appender.org.apache.torque =
org.apache.log4j.FileAppender
log4j.appender.org.apache.file =
${webappRoot}/WEB-INF/log/torque.log
log4j.appender.org.apache.layout =
org.apache.log4j.SimpleLayout

in torque.properties but it fail and i don't have
torque.log. Why do it fail?







___
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]