You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by rameau rameau1982 <ra...@hotmail.com> on 2007/12/30 10:51:50 UTC
jdbc sql update doesn't work
hi!When trying to do an update on my database via JDBC it doesn't do anything. I give you the sources and if somebody can help me it would be great! thank's!
PS: everything else works perfectly.
_________________________________________________________________
La vida de los famosos al desnudo en MSN Entretenimiento
http://entretenimiento.es.msn.com/
Re: jdbc sql update doesn't work
Posted by Alan Chaney <al...@compulsivecreative.com>.
What steps have you taken to debug this problem?
For example:
1. Enable debug logging.
2. Insert debugging statements into the code and follow the control flow
3. Break down the problem into its components.
- test the SQL statements with a command line program (psql if you
are using Postgresql)
- extract the code which relates to the database and write some
simple test cases
- check that you are actually calling the right thing at the right time.
4. Use a debugger (such as Eclipse or Netbeans)
Part of being to be a software engineer is developing skills in problem
solving.
I respectfully suggest that after you have analyzed the problem if you
can then find a direct relation to Tomcat you post the problem on this list.
If the problem is more connected with JDBC or SQL or Postgresql then
there are other more appropriate lists.
Regards
Alan
Pid wrote:
> rameau rameau1982 wrote:
>
>> hi!
>> When trying to do an update on my database via JDBC it doesn't do
>> anything. I give you the sources and if somebody can help me it would be
>> great! thank's!
>> PS: everything else works perfectly.
>>
>
> What do the logs say?
>
> p
>
>
>
>
>> ------------------------------------------------------------------------
>> Sigue los principales acontecimientos deportivos en directo. MSN Motor
>> <http://video.msn.com/video.aspx?mkt=es-es>
>>
>>
>> ------------------------------------------------------------------------
>>
>> ---------------------------------------------------------------------
>> To start a new topic, e-mail: users@tomcat.apache.org
>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@tomcat.apache.org
>>
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
>
> !DSPAM:47777639118902136417547!
>
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
RE: jdbc sql update doesn't work
Posted by Martin Gainty <mg...@hotmail.com>.
first you need to configure your DataSource in /WEB-INF/web.xml as in this example
<context-param> <param-name> javax.servlet.jsp.jstl.sql.dataSource </param-name> <param-value> jdbc:mysql://hostname:Port/DBName,com.mysql.jdbc.Driver,username,password </param-value> </context-param>Martin ______________________________________________Disclaimer and confidentiality noteEverything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.> From: rameau1982@hotmail.com> To: users@tomcat.apache.org> Subject: RE: jdbc sql update doesn't work> Date: Sun, 30 Dec 2007 14:02:43 +0100> > > The logs don't say anything because there's no errors. It simply doesn't update the database without giving errors.> > Date: Sun, 30 Dec 2007 10:38:45 +0000> From: p@pidster.com> To: users@tomcat.apache.org> Subject: Re: jdbc sql update doesn't work> > rameau rameau1982 wrote:> > hi!> > When trying to do an update on my database via JDBC it doesn't do> > anything. I give you the sources and if somebody can help me it would be> > great! thank's!> > PS: everything else works perfectly.> > What do the logs say?> > p> > > > > ------------------------------------------------------------------------> > Sigue los principales acontecimientos deportivos en directo. MSN Motor> > <http://video.msn.com/video.aspx?mkt=es-es>> > > > > > ------------------------------------------------------------------------> > > > ---------------------------------------------------------------------> > To start a new topic, e-mail: users@tomcat.apache.org> > To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org> > For additional commands, e-mail: users-help@tomcat.apache.org> > > ---------------------------------------------------------------------> To start a new topic, e-mail: users@tomcat.apache.org> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org> For additional commands, e-mail: users-help@tomcat.apache.org> > _________________________________________________________________> Tecnología, moda, motor, viajes,…suscríbete a nuestros boletines para estar siempre a la última> Guapos y guapas, clips musicales y estrenos de cine.
_________________________________________________________________
Don't get caught with egg on your face. Play Chicktionary!
http://club.live.com/chicktionary.aspx?icid=chick_wlhmtextlink1_dec
RE: jdbc sql update doesn't work
Posted by rameau rameau1982 <ra...@hotmail.com>.
The logs don't say anything because there's no errors. It simply doesn't update the database without giving errors.
> Date: Sun, 30 Dec 2007 10:38:45 +0000> From: p@pidster.com> To: users@tomcat.apache.org> Subject: Re: jdbc sql update doesn't work> > rameau rameau1982 wrote:> > hi!> > When trying to do an update on my database via JDBC it doesn't do> > anything. I give you the sources and if somebody can help me it would be> > great! thank's!> > PS: everything else works perfectly.> > What do the logs say?> > p> > > > > ------------------------------------------------------------------------> > Sigue los principales acontecimientos deportivos en directo. MSN Motor> > <http://video.msn.com/video.aspx?mkt=es-es>> > > > > > ------------------------------------------------------------------------> > > > ---------------------------------------------------------------------> > To start a new topic, e-mail: users@tomcat.apache.org> > To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org> > For additional commands, e-mail: users-help@tomcat.apache.org> > > ---------------------------------------------------------------------> To start a new topic, e-mail: users@tomcat.apache.org> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org> For additional commands, e-mail: users-help@tomcat.apache.org>
_________________________________________________________________
Tecnología, moda, motor, viajes,…suscríbete a nuestros boletines para estar siempre a la última
Guapos y guapas, clips musicales y estrenos de cine.
Re: jdbc sql update doesn't work
Posted by Pid <p...@pidster.com>.
rameau rameau1982 wrote:
> hi!
> When trying to do an update on my database via JDBC it doesn't do
> anything. I give you the sources and if somebody can help me it would be
> great! thank's!
> PS: everything else works perfectly.
What do the logs say?
p
> ------------------------------------------------------------------------
> Sigue los principales acontecimientos deportivos en directo. MSN Motor
> <http://video.msn.com/video.aspx?mkt=es-es>
>
>
> ------------------------------------------------------------------------
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org