X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id F19B9D1C9DA for ; Thu, 29 Jan 2004 20:50:59 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 12339-04 for ; Thu, 29 Jan 2004 16:50:29 -0400 (AST) Received: from physics.gmu.edu (physics.gmu.edu [129.174.44.73]) by svr1.postgresql.org (Postfix) with ESMTP id 95D91D1CB56 for ; Thu, 29 Jan 2004 16:50:27 -0400 (AST) Received: from physics.gmu.edu (localhost.localdomain [127.0.0.1]) by physics.gmu.edu (8.12.8/8.12.8) with ESMTP id i0TKoLBp017495; Thu, 29 Jan 2004 15:50:21 -0500 From: mohan@physics.gmu.edu Received: (from apache@localhost) by physics.gmu.edu (8.12.8/8.12.8/Submit) id i0TKoLJX017493; Thu, 29 Jan 2004 15:50:21 -0500 X-Authentication-Warning: physics.gmu.edu: apache set sender to mohan@physics.gmu.edu using -f Received: from 138.88.163.115 (SquirrelMail authenticated user mohan) by physics.gmu.edu with HTTP; Thu, 29 Jan 2004 15:50:21 -0500 (EST) Message-ID: <63509.138.88.163.115.1075409421.squirrel@physics.gmu.edu> Date: Thu, 29 Jan 2004 15:50:21 -0500 (EST) Subject: Re: java.lang.StringIndexOutOfBoundsException: String index To: In-Reply-To: References: <61999.138.88.163.115.1075394099.squirrel@physics.gmu.edu> X-Priority: 3 Importance: Normal Cc: , , X-Mailer: SquirrelMail (version 1.2.11) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/275 X-Sequence-Number: 16668 Now i a get another wierd error DEBUG] Transaction - -called safeRollback with null argument java.sql.SQLException: ERROR: SET AUTOCOMMIT TO OFF is no longer supported at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131) at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:482) at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:461) at org.postgresql.jdbc1.AbstractJdbc1Connection.setAutoCommit(AbstractJdbc1Connection.java:957) They say its a driver problem i think i am having the right driver. I am having RedHat Linux and postgres7.4 and pg73jdbc3.jar and jdbc-2.0.jar in my class path. I donot understand what is going wrong but in my server logs i also see this error for torque [DEBUG] SharedPoolDataSourceFactory - -Starting initJdbc2Pool [DEBUG] TorqueInstance - -getConfiguration() = org.apache.commons.configuration.BaseConfiguration@f96093 [DEBUG] AbstractDataSourceFactory - -applyConfiguration(null, org.apache.commons.dbcp.datasources.SharedPoolDataSource@e046e) [DEBUG] AbstractDataSourceFactory - -applyConfiguration(org.apache.commons.configuration.BaseConfiguration@45105c, org.apache.commons.dbcp.datasources.SharedPoolDataSource@e046e) [DEBUG] ConvertUtils - -Convert string 'SELECT 1' to class 'java.lang.String' [ERROR] AbstractDataSourceFactory - -Property: validationQuery value: SELECT 1 is not supported by DataSource: org.apache.commons.dbcp.datasources.SharedPoolDataSource [ERROR] AbstractDataSourceFactory - -Property: defaultMaxActive value: 16 is not supported by DataSource: org.apache.commons.dbcp.datasources.SharedPoolDataSource please let me know if any has an idea Thanks in Advance --Mohan > O kyrios mohan@physics.gmu.edu egrapse stis Jan 29, 2004 : > >> Hi All >> >> I am having the torque3.1.jar and postgresql-7.4. I have compiled the >> new jdbc driver called as postgresql.jar and have placed it in the lib >> directory from where the ant scripts catch the jars. Whenever i try to >> access through torque >> >> gestList = BaseGestlistPeer.doSelect(new Criteria()); >> >> this error arises >> >> java.lang.StringIndexOutOfBoundsException: String index out of range: >> 23 >> at java.lang.String.charAt(String.java:460) >> at >> org.postgresql.jdbc2.ResultSet.toTimestamp(ResultSet.java:1653) >> at >> org.postgresql.jdbc2.ResultSet.getTimestamp(ResultSet.java:398) > > Just from the above, some one could conclude you are running > a 7.2.x postgresql driver. > > Make sure you havent messed up with the CLASSPATH. > Also after ensuring your 7.4.1 postgresql.jar is in the right location, > make sure you are running a 7.4.1 backend. > >> >> I have searched all the lists and the answer i got is a jdbc driver >> issue. Please let me know what i need to for getting around with this >> problem. This happens only with this method in the whole application. >> But the same method works when i did not use the new torque 3.1 and >> everything happens smoothly.Please let me know if there is a way to >> configure jdbc with torque or any other configuration issue for >> postgres you know might have been creating this problem. I am having >> one heck of a night mare wid this issue. >> >> >> thanks >> >> --Mohan >> >> >> >> ---------------------------(end of >> broadcast)--------------------------- TIP 3: if posting/reading >> through Usenet, please send an appropriate >> subscribe-nomail command to majordomo@postgresql.org so that >> your message can get through to the mailing list cleanly >> > > -- > -Achilleus > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend