From torque-dev-return-3228-apmail-db-torque-dev-archive=db.apache.org@db.apache.org Tue Jul 22 10:49:21 2003 Return-Path: Delivered-To: apmail-db-torque-dev-archive@db.apache.org Received: (qmail 35859 invoked by uid 500); 22 Jul 2003 10:49:20 -0000 Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Developers List" Reply-To: "Apache Torque Developers List" Delivered-To: mailing list torque-dev@db.apache.org Received: (qmail 35842 invoked from network); 22 Jul 2003 10:49:19 -0000 Received: from pjcourcouxdsl.claranet.co.uk (HELO pjc.courcoux.biz) (217.158.80.250) by daedalus.apache.org with SMTP; 22 Jul 2003 10:49:19 -0000 Received: (from peter@localhost) by pjc.courcoux.biz (8.11.6/linuxconf) id h6MAnGN12577 for torque-dev@db.apache.org; Tue, 22 Jul 2003 11:49:16 +0100 Subject: Turbine/torque : null idGenerator From: Peter Courcoux To: Apache Torque Developers List Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Organization: Message-Id: <1058870955.10144.39.camel@pjc.courcoux.biz> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.4 Date: 22 Jul 2003 11:49:16 +0100 X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Hi all, I am still having problems with this. If anyone has any thoughts on where to start looking, I would appreciate them.=20 I have now compiled from source postgresql 7.3.3 run all regression tests and installed successfully. added the 7.3.3 jdbc driver to WEB-INF/lib Since doing so while I can read from the db ok all inserts result in the error shown below. At one point I could toggle this behaviour on/off by changing the=20 setting to locale.default.charset=3DUTF-8=20 =20 and back to=20 #locale.default.charset=3D Since installing postgres 7.3.3, I don't seem to be able to insert into the db whatever I do! The schema is validated against database-3.0.1.dtd and all tables have idMethod=3D"native" set. The following message was originally posted to the turbine list. =20 I have just changed my locale settings to en_GB for linux and postgresql and changed the locale settings in tr.props as below. Having done this I get the following error each time i try to insert into the db :- org.apache.torque.TorqueException: IdGenerator for table 'usertenderclass' is null at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:692) at com.ittdirect.tolreg.om.BaseUsertenderclassPeer.doInsert(BaseUsertenderclas= sPeer.java:224) at com.ittdirect.tolreg.om.BaseUsertenderclassPeer.doInsert(BaseUsertenderclas= sPeer.java:576) at com.ittdirect.tolreg.om.BaseUsertenderclass.save(BaseUsertenderclass.java:2= 94) at com.ittdirect.tolreg.om.BaseUsertenderclass.save(BaseUsertenderclass.java:2= 56) at com.ittdirect.tolreg.om.BaseUsertenderclass.save(BaseUsertenderclass.java:2= 36) I guess I must have missed something but I cannot figure out what. Any thoughts would be much appreciated. The reason for mucking about with locale settings ( which I have left at default up until now) is that I need to use =A3 signs and I am having trouble getting them into the db. postgresql accepts them from the command line but not via turbine/torque.=20 Again, if anyone has solved this issue I would very much like to hear how. I've already spent too much time on it :-( System :- RedHat Linux 7.2 postgresql 7.2 turbine 2.3 torque 3.1-alpha2 torque-gen-3.1-alpha2 jvm 1.3.1 tr.props settings :- locale.default.bundle=3DMyBundle locale.default.language=3Den locale.default.country=3DUK # # This will set the charset=3D portion of the ContentType: header. # Leave commented out unless you want to return stuff as a different # charset. # #locale.default.charset=3D Thanks, Peter --=20 Peter Courcoux --------------------------------------------------------------------- To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org For additional commands, e-mail: torque-dev-help@db.apache.org