pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
java.lang.StringIndexOutOfBoundsException: String index out of range: 23 at java.lang.String.charAt(String.java:460)
7+ messages / 5 participants
[nested] [flat]

* java.lang.StringIndexOutOfBoundsException: String index out of range: 23 at java.lang.String.charAt(String.java:460)
@ 2004-01-29 16:34 mohan@physics.gmu.edu
  2004-01-29 16:50 ` Re: java.lang.StringIndexOutOfBoundsException: String index Achilleus Mantzios <achill@matrix.gatewaynet.com>
  2004-01-30 09:10 ` Re: [SQL] java.lang.StringIndexOutOfBoundsException: String index out of range: 23 at java.lang.String.charAt(String.java:460) Paul Thomas <paul@tmsl.demon.co.uk>
  0 siblings, 2 replies; 7+ messages in thread

From: mohan@physics.gmu.edu @ 2004-01-29 16:34 UTC (permalink / raw)
  To: pgsql-sql; +Cc: torque-user@db.apache.org

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)

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





^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: java.lang.StringIndexOutOfBoundsException: String index
  2004-01-29 16:34 java.lang.StringIndexOutOfBoundsException: String index out of range: 23 at java.lang.String.charAt(String.java:460) mohan@physics.gmu.edu
@ 2004-01-29 16:50 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
  2004-01-29 20:50   ` Re: java.lang.StringIndexOutOfBoundsException: String index mohan@physics.gmu.edu
  1 sibling, 1 reply; 7+ messages in thread

From: Achilleus Mantzios @ 2004-01-29 16:50 UTC (permalink / raw)
  To: mohan@physics.gmu.edu; +Cc: pgsql-sql@postgresql.org, <torque-user@db.apache.org>

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




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: java.lang.StringIndexOutOfBoundsException: String index
  2004-01-29 16:34 java.lang.StringIndexOutOfBoundsException: String index out of range: 23 at java.lang.String.charAt(String.java:460) mohan@physics.gmu.edu
  2004-01-29 16:50 ` Re: java.lang.StringIndexOutOfBoundsException: String index Achilleus Mantzios <achill@matrix.gatewaynet.com>
@ 2004-01-29 20:50   ` mohan@physics.gmu.edu
  2004-01-29 23:22     ` Re: java.lang.StringIndexOutOfBoundsException: String index Josh Berkus <josh@agliodbs.com>
  2004-01-30 09:00     ` Re: java.lang.StringIndexOutOfBoundsException: String index Achilleus Mantzios <achill@matrix.gatewaynet.com>
  0 siblings, 2 replies; 7+ messages in thread

From: mohan@physics.gmu.edu @ 2004-01-29 20:50 UTC (permalink / raw)
  To: achill@matrix.gatewaynet.com; +Cc: mohan@physics.gmu.edu; pgsql-sql; torque-user@db.apache.org

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






^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: java.lang.StringIndexOutOfBoundsException: String index
  2004-01-29 16:34 java.lang.StringIndexOutOfBoundsException: String index out of range: 23 at java.lang.String.charAt(String.java:460) mohan@physics.gmu.edu
  2004-01-29 16:50 ` Re: java.lang.StringIndexOutOfBoundsException: String index Achilleus Mantzios <achill@matrix.gatewaynet.com>
  2004-01-29 20:50   ` Re: java.lang.StringIndexOutOfBoundsException: String index mohan@physics.gmu.edu
@ 2004-01-29 23:22     ` Josh Berkus <josh@agliodbs.com>
  1 sibling, 0 replies; 7+ messages in thread

From: Josh Berkus @ 2004-01-29 23:22 UTC (permalink / raw)
  To: mohan@physics.gmu.edu, <achill@matrix.gatewaynet.com>; +Cc: mohan@physics.gmu.edu; pgsql-sql; torque-user@db.apache.org

Mohan,

> DEBUG] Transaction - -called safeRollback with null argument
> java.sql.SQLException: ERROR:  SET AUTOCOMMIT TO OFF is no longer supported
>         at

This is because "SET AUTOCOMMIT TO OFF" *is* no longer supported.   Are you 
sure that you have the latest JDBC?

Also, this should be on the PGSQL-JDBC mailing list, not this one.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: java.lang.StringIndexOutOfBoundsException: String index
  2004-01-29 16:34 java.lang.StringIndexOutOfBoundsException: String index out of range: 23 at java.lang.String.charAt(String.java:460) mohan@physics.gmu.edu
  2004-01-29 16:50 ` Re: java.lang.StringIndexOutOfBoundsException: String index Achilleus Mantzios <achill@matrix.gatewaynet.com>
  2004-01-29 20:50   ` Re: java.lang.StringIndexOutOfBoundsException: String index mohan@physics.gmu.edu
@ 2004-01-30 09:00     ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
  1 sibling, 0 replies; 7+ messages in thread

From: Achilleus Mantzios @ 2004-01-30 09:00 UTC (permalink / raw)
  To: mohan@physics.gmu.edu; +Cc: pgsql-sql@postgresql.org, <torque-user@db.apache.org>

O kyrios mohan@physics.gmu.edu egrapse stis Jan 29, 2004 :

> 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

What java version (java -version), os (uname -a) are you running?

What is this jdbc-2.0.jar?

In any case postgres7.4 doesnt match (again!) pg73jdbc3.jar.

You better use :
java 1.4.1 (blackdown in linux, native jdk14 in FreeBSD)
postgresql server 7.4.1
postgresql jdbc 7.4.1

Also as i said check your classpath.

> 
> 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
> 
> 
> 

-- 
-Achilleus




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: [SQL] java.lang.StringIndexOutOfBoundsException: String index out of range: 23 at java.lang.String.charAt(String.java:460)
  2004-01-29 16:34 java.lang.StringIndexOutOfBoundsException: String index out of range: 23 at java.lang.String.charAt(String.java:460) mohan@physics.gmu.edu
@ 2004-01-30 09:10 ` Paul Thomas <paul@tmsl.demon.co.uk>
  2004-01-30 09:27   ` Re: [SQL] java.lang.StringIndexOutOfBoundsException: String Kris Jurka <books@ejurka.com>
  1 sibling, 1 reply; 7+ messages in thread

From: Paul Thomas @ 2004-01-30 09:10 UTC (permalink / raw)
  To: mohan@physics.gmu.edu; +Cc: pgsql-jdbc @ postgresql . org <pgsql-jdbc@postgresql.org>


On 29/01/2004 16:34 mohan@physics.gmu.edu wrote:
> 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)
> 
> 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.


You're more likely to get help on the jdbc list.

HTH

-- 
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller 
Business |
| Computer Consultants         | 
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: [SQL] java.lang.StringIndexOutOfBoundsException: String
  2004-01-29 16:34 java.lang.StringIndexOutOfBoundsException: String index out of range: 23 at java.lang.String.charAt(String.java:460) mohan@physics.gmu.edu
  2004-01-30 09:10 ` Re: [SQL] java.lang.StringIndexOutOfBoundsException: String index out of range: 23 at java.lang.String.charAt(String.java:460) Paul Thomas <paul@tmsl.demon.co.uk>
@ 2004-01-30 09:27   ` Kris Jurka <books@ejurka.com>
  0 siblings, 0 replies; 7+ messages in thread

From: Kris Jurka @ 2004-01-30 09:27 UTC (permalink / raw)
  To: Paul Thomas <paul@tmsl.demon.co.uk>; +Cc: mohan@physics.gmu.edu; pgsql-jdbc @ postgresql . org <pgsql-jdbc@postgresql.org>



On Fri, 30 Jan 2004, Paul Thomas wrote:

>
> On 29/01/2004 16:34 mohan@physics.gmu.edu wrote:
> > 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)
> >

This stacktrace is from a 7.2 jar file.  You probably have the old version
somewhere in your classpath.

Kris Jurka




^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2004-01-30 09:27 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-01-29 16:34 java.lang.StringIndexOutOfBoundsException: String index out of range: 23 at java.lang.String.charAt(String.java:460) mohan@physics.gmu.edu
2004-01-29 16:50 ` Re: java.lang.StringIndexOutOfBoundsException: String index Achilleus Mantzios <achill@matrix.gatewaynet.com>
2004-01-29 20:50   ` Re: java.lang.StringIndexOutOfBoundsException: String index mohan@physics.gmu.edu
2004-01-29 23:22     ` Re: java.lang.StringIndexOutOfBoundsException: String index Josh Berkus <josh@agliodbs.com>
2004-01-30 09:00     ` Re: java.lang.StringIndexOutOfBoundsException: String index Achilleus Mantzios <achill@matrix.gatewaynet.com>
2004-01-30 09:10 ` Paul Thomas <paul@tmsl.demon.co.uk>
2004-01-30 09:27   ` Re: [SQL] java.lang.StringIndexOutOfBoundsException: String Kris Jurka <books@ejurka.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox