You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by Shaista Shekh <sh...@gmail.com> on 2009/08/25 07:25:22 UTC
no DataSourceFactory configured for the connection
I have migrated turbine 2.3.3 with ant.
While I start the webserver/applicationserver everything works fine
i am trying to logged in it is showing below given error in log file.
"There was no DataSourceFactory configured for the connection
DATABASE"
Please guide me in this regard
Thanking you
RE: Fwd: no DataSourceFactory configured for the connection
Posted by Greg Monroe <Gr...@dukece.com>.
Based on the fact that the "no DataSourceFactory configured.." message
is probably using the Torque.getDefaultDB() to get the "DATABASE" string,
I think that you are probably not getting the config file you think your
are.
You mentioned Turbine. I don't use this so there may be some config
file related to this that needs to include or point to your Torque config
file info. The generic word "DATABASE" makes me think this is some
default placeholder in Turbine. I know it's not in Torque.
One thing that might be happening is that the commons Configuration
objects used by Torque (and probably Turbine) may do some searching
thru the classpath and other locations to find a file.
As to the "SQL not complete" message, this is as designed. A Criteria
object is a template for an SQL string. It is combined with the
specific Table object to create the final SQL string. So, a
Criteria.toString() call will show you the template but this
may not be a working SQL string that you can use to test with.
> -----Original Message-----
> From: Emmanuel Bardet [mailto:ebardet@bardet-u2ee.com]
> Sent: Wednesday, August 26, 2009 3:24 AM
> To: Apache Torque Users List
> Subject: Re: Fwd: no DataSourceFactory configured for the connection
>
> Hello there,
>
> As per the criteria not showing any sql statement, this is all fine as
> you
> did not provide any information to the Criteria object. Hence, it does
> not show anything. Have a look at the way you can use it at
> http://db.apache.org/torque/releases/torque-3.3/tutorial/step5.html
>
> Hope that helps.
>
> E
>
> > Sir
> > Very very thanks Greg Monroe to reply
> > I did all changes according to the given doc on below link:
> > http://db.apache.org/torque/releases/torque-
> 3.3/runtime/reference/initialisation-configuration.html
> > Still i am facing that torque is not initialized.
> >
> > torque.properties are as below
> >
> > torque.database.default=brihaspati
> > torque.database.brihaspati.adapter=mysql
> >
> >
> torque.dsfactory.brihaspati.factory=org.apache.torque.dsfactory.SharedPoo
> lDataSourceFactory
> > torque.dsfactory.brihaspati.connection.driver = org.gjt.mm.mysql.Driver
> > torque.dsfactory.brihaspati.connection.url =
> > jdbc:mysql://localhost:3306/brihaspati
> > torque.dsfactory.brihaspati.connection.user = etrg
> > torque.dsfactory.brihaspati.connection.password = brihaspatigroup
> > torque.dsfactory.brihaspati.pool.maxActive=10
> > torque.dsfactory.brihaspati.pool.testOnBorrow=true
> > torque.dsfactory.brihaspati.pool.validationQuery=SELECT 1
> > Second thing is that while i am using and trying to write
> > org.apache.torque.util.Criteria obj to debug like below,
> > Criteria crit = new Criteria();
> > It is showing :
> > crit.........=Criteria::
> > Current Query SQL (may not be complete or applicable):
> >
> >
> > On 8/25/09, Greg Monroe <Gr...@dukece.com> wrote:
> >>
> >> By migrated I assume you mean from an older version of Torque.
> >> Most likely it was a version prior to the properties file revamp
> >> that took place in Version 3.1 (I think).
> >>
> >> If this is true, you will need to modify your Torque runtime
> >> configuration properties file to the new format. See:
> >>
> >>
> >> http://db.apache.org/torque/releases/torque-
> 3.3/runtime/reference/initialisation-configuration.html
> >>
> >> If this isn't the case, please supply more details.
> >>
> >>
> >> > -----Original Message-----
> >> > From: Shaista Shekh [mailto:shaista.shekh@gmail.com]
> >> > Sent: Tuesday, August 25, 2009 1:25 AM
> >> > To: torque-user@db.apache.org
> >> > Subject: no DataSourceFactory configured for the connection
> >> >
> >> > I have migrated turbine 2.3.3 with ant.
> >> > While I start the webserver/applicationserver everything works fine
> >> > i am trying to logged in it is showing below given error in log
> file.
> >> >
> >> > "There was no DataSourceFactory configured for the connection
> >> > DATABASE"
> >> > Please guide me in this regard
> >> > Thanking you
> >>
> >> DukeCE Privacy Statement:
> >> Please be advised that this e-mail and any files transmitted with
> >> it are confidential communication or may otherwise be privileged or
> >> confidential and are intended solely for the individual or entity
> >> to whom they are addressed. If you are not the intended recipient
> >> you may not rely on the contents of this email or any attachments,
> >> and we ask that you please not read, copy or retransmit this
> >> communication, but reply to the sender and destroy the email, its
> >> contents, and all copies thereof immediately. Any unauthorized
> >> dissemination, distribution or copying of this communication is
> >> strictly prohibited.
> >>
> >> ---------------------------------------------------------------------
> >> 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
Re: Fwd: no DataSourceFactory configured for the connection
Posted by Emmanuel Bardet <eb...@bardet-u2ee.com>.
Hello there,
As per the criteria not showing any sql statement, this is all fine as you
did not provide any information to the Criteria object. Hence, it does
not show anything. Have a look at the way you can use it at
http://db.apache.org/torque/releases/torque-3.3/tutorial/step5.html
Hope that helps.
E
> Sir
> Very very thanks Greg Monroe to reply
> I did all changes according to the given doc on below link:
> http://db.apache.org/torque/releases/torque-3.3/runtime/reference/initialisation-configuration.html
> Still i am facing that torque is not initialized.
>
> torque.properties are as below
>
> torque.database.default=brihaspati
> torque.database.brihaspati.adapter=mysql
>
> torque.dsfactory.brihaspati.factory=org.apache.torque.dsfactory.SharedPoolDataSourceFactory
> torque.dsfactory.brihaspati.connection.driver = org.gjt.mm.mysql.Driver
> torque.dsfactory.brihaspati.connection.url =
> jdbc:mysql://localhost:3306/brihaspati
> torque.dsfactory.brihaspati.connection.user = etrg
> torque.dsfactory.brihaspati.connection.password = brihaspatigroup
> torque.dsfactory.brihaspati.pool.maxActive=10
> torque.dsfactory.brihaspati.pool.testOnBorrow=true
> torque.dsfactory.brihaspati.pool.validationQuery=SELECT 1
> Second thing is that while i am using and trying to write
> org.apache.torque.util.Criteria obj to debug like below,
> Criteria crit = new Criteria();
> It is showing :
> crit.........=Criteria::
> Current Query SQL (may not be complete or applicable):
>
>
> On 8/25/09, Greg Monroe <Gr...@dukece.com> wrote:
>>
>> By migrated I assume you mean from an older version of Torque.
>> Most likely it was a version prior to the properties file revamp
>> that took place in Version 3.1 (I think).
>>
>> If this is true, you will need to modify your Torque runtime
>> configuration properties file to the new format. See:
>>
>>
>> http://db.apache.org/torque/releases/torque-3.3/runtime/reference/initialisation-configuration.html
>>
>> If this isn't the case, please supply more details.
>>
>>
>> > -----Original Message-----
>> > From: Shaista Shekh [mailto:shaista.shekh@gmail.com]
>> > Sent: Tuesday, August 25, 2009 1:25 AM
>> > To: torque-user@db.apache.org
>> > Subject: no DataSourceFactory configured for the connection
>> >
>> > I have migrated turbine 2.3.3 with ant.
>> > While I start the webserver/applicationserver everything works fine
>> > i am trying to logged in it is showing below given error in log file.
>> >
>> > "There was no DataSourceFactory configured for the connection
>> > DATABASE"
>> > Please guide me in this regard
>> > Thanking you
>>
>> DukeCE Privacy Statement:
>> Please be advised that this e-mail and any files transmitted with
>> it are confidential communication or may otherwise be privileged or
>> confidential and are intended solely for the individual or entity
>> to whom they are addressed. If you are not the intended recipient
>> you may not rely on the contents of this email or any attachments,
>> and we ask that you please not read, copy or retransmit this
>> communication, but reply to the sender and destroy the email, its
>> contents, and all copies thereof immediately. Any unauthorized
>> dissemination, distribution or copying of this communication is
>> strictly prohibited.
>>
>> ---------------------------------------------------------------------
>> 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
Fwd: no DataSourceFactory configured for the connection
Posted by Shaista Shekh <sh...@gmail.com>.
Sir
Very very thanks Greg Monroe to reply
I did all changes according to the given doc on below link:
http://db.apache.org/torque/releases/torque-3.3/runtime/reference/initialisation-configuration.html
Still i am facing that torque is not initialized.
torque.properties are as below
torque.database.default=brihaspati
torque.database.brihaspati.adapter=mysql
torque.dsfactory.brihaspati.factory=org.apache.torque.dsfactory.SharedPoolDataSourceFactory
torque.dsfactory.brihaspati.connection.driver = org.gjt.mm.mysql.Driver
torque.dsfactory.brihaspati.connection.url =
jdbc:mysql://localhost:3306/brihaspati
torque.dsfactory.brihaspati.connection.user = etrg
torque.dsfactory.brihaspati.connection.password = brihaspatigroup
torque.dsfactory.brihaspati.pool.maxActive=10
torque.dsfactory.brihaspati.pool.testOnBorrow=true
torque.dsfactory.brihaspati.pool.validationQuery=SELECT 1
Second thing is that while i am using and trying to write
org.apache.torque.util.Criteria obj to debug like below,
Criteria crit = new Criteria();
It is showing :
crit.........=Criteria::
Current Query SQL (may not be complete or applicable):
On 8/25/09, Greg Monroe <Gr...@dukece.com> wrote:
>
> By migrated I assume you mean from an older version of Torque.
> Most likely it was a version prior to the properties file revamp
> that took place in Version 3.1 (I think).
>
> If this is true, you will need to modify your Torque runtime
> configuration properties file to the new format. See:
>
>
> http://db.apache.org/torque/releases/torque-3.3/runtime/reference/initialisation-configuration.html
>
> If this isn't the case, please supply more details.
>
>
> > -----Original Message-----
> > From: Shaista Shekh [mailto:shaista.shekh@gmail.com]
> > Sent: Tuesday, August 25, 2009 1:25 AM
> > To: torque-user@db.apache.org
> > Subject: no DataSourceFactory configured for the connection
> >
> > I have migrated turbine 2.3.3 with ant.
> > While I start the webserver/applicationserver everything works fine
> > i am trying to logged in it is showing below given error in log file.
> >
> > "There was no DataSourceFactory configured for the connection
> > DATABASE"
> > Please guide me in this regard
> > Thanking you
>
> DukeCE Privacy Statement:
> Please be advised that this e-mail and any files transmitted with
> it are confidential communication or may otherwise be privileged or
> confidential and are intended solely for the individual or entity
> to whom they are addressed. If you are not the intended recipient
> you may not rely on the contents of this email or any attachments,
> and we ask that you please not read, copy or retransmit this
> communication, but reply to the sender and destroy the email, its
> contents, and all copies thereof immediately. Any unauthorized
> dissemination, distribution or copying of this communication is
> strictly prohibited.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
Re: no DataSourceFactory configured for the connection
Posted by Shaista Shekh <sh...@gmail.com>.
Sir
Very very thanks Greg Monroe to reply
I did all changes according to the given doc on below link:
http://db.apache.org/torque/releases/torque-3.3/runtime/reference/initialisation-configuration.html
Still i am facing that torque is not initialized.
torque.properties are as below
torque.database.default=brihaspati
torque.database.brihaspati.adapter=mysql
torque.dsfactory.brihaspati.factory=org.apache.torque.dsfactory.SharedPoolDataSourceFactory
torque.dsfactory.brihaspati.connection.driver = org.gjt.mm.mysql.Driver
torque.dsfactory.brihaspati.connection.url =
jdbc:mysql://localhost:3306/brihaspati
torque.dsfactory.brihaspati.connection.user = etrg
torque.dsfactory.brihaspati.connection.password = brihaspatigroup
torque.dsfactory.brihaspati.pool.maxActive=10
torque.dsfactory.brihaspati.pool.testOnBorrow=true
torque.dsfactory.brihaspati.pool.validationQuery=SELECT 1
On 8/25/09, Greg Monroe <Gr...@dukece.com> wrote:
>
> By migrated I assume you mean from an older version of Torque.
> Most likely it was a version prior to the properties file revamp
> that took place in Version 3.1 (I think).
>
> If this is true, you will need to modify your Torque runtime
> configuration properties file to the new format. See:
>
>
> http://db.apache.org/torque/releases/torque-3.3/runtime/reference/initialisation-configuration.html
>
> If this isn't the case, please supply more details.
>
>
> > -----Original Message-----
> > From: Shaista Shekh [mailto:shaista.shekh@gmail.com]
> > Sent: Tuesday, August 25, 2009 1:25 AM
> > To: torque-user@db.apache.org
> > Subject: no DataSourceFactory configured for the connection
> >
> > I have migrated turbine 2.3.3 with ant.
> > While I start the webserver/applicationserver everything works fine
> > i am trying to logged in it is showing below given error in log file.
> >
> > "There was no DataSourceFactory configured for the connection
> > DATABASE"
> > Please guide me in this regard
> > Thanking you
>
> DukeCE Privacy Statement:
> Please be advised that this e-mail and any files transmitted with
> it are confidential communication or may otherwise be privileged or
> confidential and are intended solely for the individual or entity
> to whom they are addressed. If you are not the intended recipient
> you may not rely on the contents of this email or any attachments,
> and we ask that you please not read, copy or retransmit this
> communication, but reply to the sender and destroy the email, its
> contents, and all copies thereof immediately. Any unauthorized
> dissemination, distribution or copying of this communication is
> strictly prohibited.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
RE: no DataSourceFactory configured for the connection
Posted by Greg Monroe <Gr...@dukece.com>.
By migrated I assume you mean from an older version of Torque.
Most likely it was a version prior to the properties file revamp
that took place in Version 3.1 (I think).
If this is true, you will need to modify your Torque runtime
configuration properties file to the new format. See:
http://db.apache.org/torque/releases/torque-3.3/runtime/reference/initialisation-configuration.html
If this isn't the case, please supply more details.
> -----Original Message-----
> From: Shaista Shekh [mailto:shaista.shekh@gmail.com]
> Sent: Tuesday, August 25, 2009 1:25 AM
> To: torque-user@db.apache.org
> Subject: no DataSourceFactory configured for the connection
>
> I have migrated turbine 2.3.3 with ant.
> While I start the webserver/applicationserver everything works fine
> i am trying to logged in it is showing below given error in log file.
>
> "There was no DataSourceFactory configured for the connection
> DATABASE"
> Please guide me in this regard
> Thanking you
DukeCE Privacy Statement:
Please be advised that this e-mail and any files transmitted with
it are confidential communication or may otherwise be privileged or
confidential and are intended solely for the individual or entity
to whom they are addressed. If you are not the intended recipient
you may not rely on the contents of this email or any attachments,
and we ask that you please not read, copy or retransmit this
communication, but reply to the sender and destroy the email, its
contents, and all copies thereof immediately. Any unauthorized
dissemination, distribution or copying of this communication is
strictly prohibited.
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org