Java class for data type mapper?
in [Java Programming]
|
Prev: jsp/servlet target
Next: How to get an include-path of jni.h that is able to be differenton different platforms.
From: New Java 456 on 29 Jan 2010 09:10 On Jan 29, 8:37 am, Lew <no...(a)lewscanon.com> wrote: > Roedy Green wrote: > > The catch is you will use the JBDC types and Java types in your > > program, but the PostGre [sic] types in your the SQL you use to initially > > define the database. > > It's "Postgres" or "PostreSQL", not "Postgre". > > -- > Lew Thanks Everyone, What I'm more after is somethign that says a varchar2 in Oracle is a varchar in Sybase is a character varying in POstgresql. I've worked with JDBC enough to know the types are represented as integer values in each driver from the viewpoint of Java so mapping even those to the data types of the database is tough. So, some library or class implementing this mapping. As it stands, I'll try to whack out something using the Postgresql notes. Well, if you wonder why, the reason to do this is to migrate date from one database to another adn may possibly include the requirement to create the destination table. Since the client has very large Oracle expertise but ate or was eaten by a company who uses Sybase then the need is to be able to quickly and easily move data between the two for reporting. They do have some ETL tools but these are also not easy to integrate into their existing Java progams, amony other things. Thanks again, Tim
From: Roedy Green on 29 Jan 2010 09:30 On Fri, 29 Jan 2010 08:37:40 -0500, Lew <noone(a)lewscanon.com> wrote, quoted or indirectly quoted someone who said : > >It's "Postgres" or "PostreSQL", not "Postgre". This is amusing. Your spelling correction contains a spelling error. It's official name is: PostgreSQL That is the only name they use on their site. In the history section, they point out it was originally called Postgres. The way I look at it, Postgre is some sort of synthethic adjective modifying SQL, which is a redundant part of its name when discussing SQL engines so I feel no guilt calling by a nickname - PostGre. Many would consider it overly prissy to correct someone for using the term "Ford" instead of "Henry Ford Company" the company's original name. -- Roedy Green Canadian Mind Products http://mindprod.com Computers are useless. They can only give you answers. ~ Pablo Picasso (born: 1881-10-25 died: 1973-04-08 at age: 91)
From: Arne Vajhøj on 29 Jan 2010 18:58
On 29-01-2010 09:30, Roedy Green wrote: > On Fri, 29 Jan 2010 08:37:40 -0500, Lew<noone(a)lewscanon.com> wrote, > quoted or indirectly quoted someone who said : >> It's "Postgres" or "PostreSQL", not "Postgre". > > This is amusing. Your spelling correction contains a spelling error. > > It's official name is: PostgreSQL > > That is the only name they use on their site. > In the history section, they point out it was originally called > Postgres. > > The way I look at it, Postgre is some sort of synthethic adjective > modifying SQL, which is a redundant part of its name when discussing > SQL engines so I feel no guilt calling by a nickname - PostGre. > > Many would consider it overly prissy to correct someone for using the > term "Ford" instead of "Henry Ford Company" the company's original > name. Sure. But that comparison is not relevant. Postgres as short name for PostgreSQL is fine. PostGre is a mysterious abbreviation only used by you. The analogy would be to call the car company for "For". Arne |