Return-Path: Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Delivered-To: mailing list cocoon-users@xml.apache.org Delivered-To: moderator for cocoon-users@xml.apache.org Received: (qmail 50878 invoked from network); 20 Feb 2001 06:24:14 -0000 Received: from oek.dk (HELO mail.oek.dk) (195.215.62.2) by h31.sny.collab.net with SMTP; 20 Feb 2001 06:24:14 -0000 Received: from h504.oek.dk ([10.208.5.32] helo=dyregod.dk) by mail.oek.dk with esmtp (Exim 3.12 #1 (Debian)) id 14V6DK-00048M-00 for ; Tue, 20 Feb 2001 07:23:54 +0100 Message-ID: <3A920E19.7070704@dyregod.dk> Date: Tue, 20 Feb 2001 07:26:33 +0100 From: Ulf Holm Nielsen User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; 0.8) Gecko/20010215 X-Accept-Language: en MIME-Version: 1.0 To: cocoon-users@xml.apache.org Subject: Re: C2 sql examples. References: <3A91845C.5040806@ruc.dk> <3A91DFB6.6FEDF3B2@apache.org> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N hi, i'm using the connection pool. i've specified the driver in the web.xml file and the dburl in the xconf file Ulf Holm Nielsen Berin Loritsch wrote: > Ulf Holm Nielsen wrote: > >> hi, >> >> yep... the following code works just fine... >> >> { >> Class.forName("org.gjt.mm.mysql.Driver"); >> dbcon = >> DriverManager.getConnection("jdbc:mysql://localhost/cocoontest", >> "dullerdaller", "blablabla"); >> dbcon.setAutoCommit(true); >> } >> catch ( Exception e) >> { >> e.printStackTrace(); >> } >> >> what could be wrong? > > > How are you connecting? Are you using the manual SQL connection > (i.e. specifying dburl, class, username, and password every time), > or are you using the Pooling functionality? > > If you are using the Connection Pool functionality, have you specified > the class of your Database Driver in the "load-class" initial parameter > for the servlet? > >> Ulf Holm Nielsen >> >> Donald Ball wrote: >> >>> On Mon, 19 Feb 2001, Ulf Holm Nielsen wrote: >>> >>>> i've succesfully installed cocoon2 but have some troubles getting the >>>> sql examples to work. >>>> >>>> i've created the mentioned tables in mysql downloaded a jdbc driver and >>>> placed it in the tomcat dir. and changed the driver and table/userinfo >>>> in the xconf.. >>>> >>>> however when i run the app simple-sql it gives me (error 1 see below).. >>>> >>>> but when running hte sample forms i get something different. (see error >>>> 2 below) >>>> >>>> anyone got a clue? >>> >>> >>> can you tell me this - does Connection.setAutoCommit(true) fail for you if >>> you call it from a standalone jdbc program? >>> >>> - donald >>> >>> >>> --------------------------------------------------------------------- >>> Please check that your question has not already been answered in the >>> FAQ before posting. >>> >>> To unsubscribe, e-mail: >>> For additional commands, e-mail: >>> >> --------------------------------------------------------------------- >> Please check that your question has not already been answered in the >> FAQ before posting. >> >> To unsubscribe, e-mail: >> For additional commands, e-mail: > > > --------------------------------------------------------------------- > Please check that your question has not already been answered in the > FAQ before posting. > > To unsubscribe, e-mail: > For additional commands, e-mail: >