Skip site navigation (1) Skip section navigation (2)

jdbc example datastyle.java

From: Grégory Faruch <gregory(dot)faruch(at)club-internet(dot)fr>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: jdbc example datastyle.java
Date: 2002-08-27 08:11:00
Message-ID: 000b01c24da1$47b346c0$0101a8c0@clubinternet.fr (view raw or flat)
Thread:
Lists: pgsql-bugs
Your name               : Gregory Faruch
Your email address      : gfaruch(at)laposte(dot)net


System Configuration
---------------------
  Architecture (example: Intel Pentium)         : Sparc

  Operating System (example: Linux 2.0.26 ELF)  : Solaris 2.9

  PostgreSQL version (example: PostgreSQL-7.1.1):   PostgreSQL-7.2

  Compiler used (example:  gcc 2.95.2)          :  gcc (GCC) 3.1


Please enter a FULL description of your problem:
------------------------------------------------
I tried to run the  example : datestyle.java of jdbc interface. I have an
exception during the running.




Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
<greg(at)~/postgresqlJavaExample>  java example/datestyle
jdbc:postgresql:corpus greg toto55 trace
PostgreSQL datestyle test v6.3 rev 1

DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
registerDriver:
driver[className=org.postgresql.Driver,org(dot)postgresql(dot)Driver(at)6b97fd]
Connecting to Database URL = jdbc:postgresql:corpus
DriverManager.getConnection("jdbc:postgresql:corpus")
    trying
driver[className=org.postgresql.Driver,org(dot)postgresql(dot)Driver(at)6b97fd]
getConnection returning
driver[className=org.postgresql.Driver,org(dot)postgresql(dot)Driver(at)6b97fd]
Connected...Now creating a statement

Running tests:
Test 0 - postgres,europeanNOTICE:  DateStyle is Postgres with European
conventions

SQLWarning: reason(NOTICE:  DateStyle is Postgres with European conventions
)
 failed, returned 08-01-1998
Test 1 - postgres,usNOTICE:  DateStyle is Postgres with US (NonEuropean)
conventions

SQLWarning: reason(NOTICE:  DateStyle is Postgres with US (NonEuropean)
conventions
)
 failed, returned 01-08-1998
Test 2 - isoNOTICE:  DateStyle is ISO with US (NonEuropean) conventions

SQLWarning: reason(NOTICE:  DateStyle is ISO with US (NonEuropean)
conventions
)
 passed, returned 1998-01-08
Test 3 - sql,europeanNOTICE:  DateStyle is SQL with European conventions

SQLWarning: reason(NOTICE:  DateStyle is SQL with European conventions
)
Exception caught.
java.lang.IllegalArgumentException
java.lang.IllegalArgumentException
 at java.sql.Date.valueOf(Date.java:100)
 at org.postgresql.jdbc2.ResultSet.toDate(Unknown Source)
 at org.postgresql.jdbc2.ResultSet.getDate(Unknown Source)
 at example.datestyle.doexample(datestyle.java:142)
 at example.datestyle.<init>(datestyle.java:54)
 at example.datestyle.main(datestyle.java:179)




If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------




pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-08-27 09:58:33
Subject: Bug #748: Temp tables don't work in functions
Previous:From: Tom LaneDate: 2002-08-27 06:04:21
Subject: Re: Bug #746: Drop user damages security on tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group