james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John S. Gage" <jg...@epo.som.sunysb.edu>
Subject Re: AW: Portability vs. db specific connections
Date Fri, 08 Jun 2001 19:28:53 GMT
I have ported SQL table definitions from Oracle Lite to JBuilder JDataStore 
(admittedly neither one open source).  If one sticks to the data types and 
SQL commands that are plain vanilla, you get cross-platform: one set of SQL 
statements.  Certainly, this should be possible.
John Gage

At 01:36 PM 6/8/01, you wrote:
>
>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>Hi,
>
> >I strongly agree with last proposal,
>
> >Going into specific db's would be a surrender towards non
> >portability. From my point of view a big NO. Let's handle those db
> >specific create statements in SQL script's and stay focused on
> >programming a good inteface for the JDBC connection.
>
>OK ... on the one side we have the UsersJDBCRepository and on the
>other side the tables, columns, ... I think the interface between the
>two are the names of tables, columns, ... I propose to store this
>names into a conf file and create little scriptlets:
>
>build -mysql
>build -oracle
>
>to generate files which contains
>
>CREATE TABLE ....
>
>for specific databases.
>I think it is important to store the names of tables, colums, ...
>only once.
>
>Chris
>
>-----BEGIN PGP SIGNATURE-----
>Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>
>
>iQA/AwUBOyENLkbyo9NuJhiHEQI07ACguwO1WuIIGycBWsQH+fvdvpYRtrQAn2/i
>hchsHDRnN8yciKRtrF2ahaHw
>=UE5q
>-----END PGP SIGNATURE-----
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: james-dev-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: james-dev-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: james-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-dev-help@jakarta.apache.org


Mime
View raw message