db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Catalin Constantin" <cata...@bounce-software.com>
Subject RE: torque webapp dbcp pool
Date Fri, 29 Aug 2003 11:09:03 GMT
10x
it works now !

there was also a small mistake in my code

on .save();
i used
.save("somename");
the "somename" should've been a DB name
and i was using the table name which was wrong !

anyway, 10x again !


Catalin Constantin
Bounce Software
www.bounce-software.com
 

> 
> -----Original Message-----
> From: Ashley Hayes [mailto:ashley.hayes@macalla.com] 
> Sent: Friday, August 29, 2003 1:32 PM
> To: 'Apache Torque Users List'
> 
> your original email stated this was in your web.xml:
>    <resource-ref>
>         <description>DB Connection</description>
>         <res-ref-name>java:comp/env/jdbc/ksi</res-ref-name>
>         <res-type>javax.sql.DataSource</res-type>
>         <res-auth>Container</res-auth>
>     </resource-ref>
> 
> my res-ref-name in the web.xml does not include the 
> java:comp/env/ prefix
> e.g.
>     <resource-ref>
>         <description>PPI datasource</description>
>         <res-ref-name>jdbc/ppi</res-ref-name>
>         <res-type>javax.sql.DataSource</res-type>
>         <res-auth>Container</res-auth>
>     </resource-ref>
> 
> 
> if this does not fix the problem, I suggest testing that 
> tomcat and the web
> app are definitely setup
> correctly by looking up the datasource and doing a query with 
> JDBC code,
> then go back and check your
> Torque.properties ....
> 
> -----Original Message-----
> From: Catalin Constantin [mailto:catalin@bounce-software.com]
> Sent: 29 August 2003 11:08
> To: 'Apache Torque Users List'
> Subject: RE: torque webapp dbcp pool
> 
> 
> k
> did the change but still the same.
> 
> after init i get also some warning:
> 
> Aug 29, 2003 1:04:17 PM org.apache.torque.oid.IDBroker <init>
> WARNING: IDBroker is being used with db 'default', which does 
> not support
> transa
> ctions. IDBroker attempts to use transactions to limit the 
> possibility of
> duplic
> ate key generation.  Without transactions, duplicate key generation is
> possible
> if multiple JVMs are used or other means are used to write to 
> the database.
> 
> the, the same !
> 
> java.lang.NullPointerException: There was no 
> DataSourceFactory configured
> for the connection user_password
>         at
> org.apache.torque.TorqueInstance.getConnection(TorqueInstance.
> java:749)
>         at org.apache.torque.Torque.getConnection(Torque.java:306)
>         at
> org.apache.torque.util.Transaction.beginOptional(Transaction.java:118)
>         at 
> org.apache.torque.util.Transaction.begin(Transaction.java:100)
>         at
> ro.dazoot.ksi.db.torque.BaseUserPassword.save(BaseUserPassword
> .java:1497)
> 	  ......
> 
> 
> my Torque.properties is now:
> torque.database.default=ksi
> 
> torque.database.ksi.adapter=postgresql
> 
> # Jndi location
> torque.dsfactory.ksi.jndi.path=java:comp/env/jdbc/ksi
> torque.dsfactory.ksi.factory=org.apache.torque.dsfactory.JndiD
> ataSourceFacto
> ry
> torque.idbroker.clever.quantity=false
> torque.idbroker.prefetch=true
> 
> still not working !
> 
> any clue ?
> 
> Catalin Constantin
> Bounce Software
> www.bounce-software.com
>  
> 
> > 
> > -----Original Message-----
> > From: Ashley Hayes [mailto:ashley.hayes@macalla.com] 
> > Sent: Friday, August 29, 2003 12:53 PM
> > To: 'Apache Torque Users List'
> > 
> > this is my jndi path line,
> > torque.dsfactory.ppi.jndi.path=java:comp/env/jdbc/ppi
> > 
> > it does not have a "/" before comp
> > java:/comp/env/jdbc/ksi
> > 
> > -----Original Message-----
> > From: Catalin Constantin [mailto:catalin@bounce-software.com]
> > Sent: 29 August 2003 10:47
> > To: 'Apache Torque Users List'
> > Subject: RE: torque webapp dbcp pool
> > 
> > 
> > i have added it now but still the same error:
> > 
> > torque.database.ksi.adapter=postgresql
> > 
> > # Jndi location
> > torque.dsfactory.ksi.jndi.path=java:/comp/env/jdbc/ksi
> > torque.dsfactory.ksi.factory=org.apache.torque.dsfactory.JndiD
> > ataSourceFacto
> > ry
> > torque.idbroker.clever.quantity=false
> > torque.idbroker.prefetch=true
> > 
> > 
> > what else can it be ?
> > 
> > btw: do i have to add something that is here:
> > http://db.apache.org/torque/configuration-howto.html
> > 
> > in my server.xml file
> > or web.xml file ?
> > 
> > eg:
> > something like this:
> >  <Resource name="jdbc/ScarabDB" auth="Container"
> >             type="org.apache.torque.pool.TorqueClassicDataSource"/>
> >   <ResourceParams name="jdbc/bookstore">
> >     <parameter>
> >       <name>factory</name>
> >       <value>org.apache.torque.pool.TorqueClassicDataSource</value>
> >     </parameter>
> >     <parameter>
> >  
> > <name>dataSourceName</name><value>java:comp/env/jdbc/DBbooksto
> > re</value>
> >     </parameter>
> >     <parameter>
> >       <name>defaultMaxConnections</name><value>30</value>
> >     </parameter>
> >     <parameter>
> >       <name>maxExpiryTime</name><value>3600</value>
> >     </parameter>
> >     <parameter>
> >       <name>connectionWaitTimeout</name><value>10</value>
> >     </parameter>
> >     <parameter>
> >       <name>logInterval</name><value>0</value>
> >     </parameter>
> > 
> >   </ResourceParams>
> > 
> > in server.xml
> > and
> > 
> > <resource-ref>
> >   <description>
> >     Resource reference to a factory for java.sql.Connection
> >     instances that may be used for talking to a particular
> >     database that is configured in the server.xml file.
> >   </description>
> >   <res-ref-name>
> >     jdbc/bookstore
> >   </res-ref-name>
> >   <res-type>
> >     org.apache.torque.pool.TorqueClassicDataSource
> >   </res-type>
> >   <res-auth>
> >     Container
> >   </res-auth>
> > </resource-ref>
> > 
> > in web.xml ?
> > 
> > 10x !
> > 
> > Catalin Constantin
> > Bounce Software
> > www.bounce-software.com
> >  
> > 
> > > 
> > > -----Original Message-----
> > > From: Ashley Hayes [mailto:ashley.hayes@macalla.com] 
> > > Sent: Friday, August 29, 2003 12:32 PM
> > > To: 'Apache Torque Users List'
> > > 
> > > have you got this line:
> > > torque.dsfactory.ksi.factory=org.apache.torque.dsfactory.JndiD
> > > ataSourceFacto
> > > ry
> > > ?
> > > 
> > > 
> > 
> > 
> > 
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: torque-user-help@db.apache.org
> > 
> > 
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: torque-user-help@db.apache.org
> > 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message