crossdb-developers Mailing List for crossdb - Java - database independent co
Status: Beta
Brought to you by:
prophecyslides
Menu
▾
▴
crossdb-developers — for developers
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
(2) |
May
(28) |
Jun
(14) |
Jul
(7) |
Aug
(7) |
Sep
(2) |
Oct
(1) |
Nov
|
Dec
(1) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(9) |
Feb
(2) |
Mar
(6) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
|
| 2004 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(2) |
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Travis R. <tr...@sp...> - 2004-08-22 07:48:46
|
This is fixed now. Travis Jim Clune wrote: >Hello, I am starting to use crossdb and looks like a very nice library. > >I noticed that the returnID for auto-increment is incorrectly implemented >for HsqldbInsertQuery.java (it attempts to use the MySql syntax instead of >the Hsqldb syntax, resulting in a SQLException). Attached is a patch that >fixes the problem. > >Also, if you have a preferred method for submitting patches, please let me >know. Thanks. > >Jim Clune >Parasoft Corporation email: jim...@pa... >101 E. Huntington Ave. voice: (626) 256-3680 >Monrovia, CA. 91016 fax : (626) 256-6884 > > |
|
From: <ji...@pa...> - 2004-08-12 16:14:07
|
Hello, I am starting to use crossdb and looks like a very nice library. I noticed that the returnID for auto-increment is incorrectly implemented for HsqldbInsertQuery.java (it attempts to use the MySql syntax instead of the Hsqldb syntax, resulting in a SQLException). Attached is a patch that fixes the problem. Also, if you have a preferred method for submitting patches, please let me know. Thanks. Jim Clune Parasoft Corporation email: jim...@pa... 101 E. Huntington Ave. voice: (626) 256-3680 Monrovia, CA. 91016 fax : (626) 256-6884 |
|
From: Travis R. <tr...@sp...> - 2003-09-16 05:31:30
|
Hi y'all,
So I've been discussing a crossdb version 2 with a friend and have come
up with some rough ideas:
Please give feedback on the ideas and let us know of any features that
you would like to see in a new release.
Travis
Travis Reeder wrote:
> What do you think of this stuff...
>
>
>
> Some new ideas....
>
> ----------------------------------------------
>
> Read in crossdb.properties file which will contain:
> database type or crossdb driver
> ex:
> database=mysql for standard supported ones
> or
> database=com.spaceprogram.sql.mysql...... for third party impls
>
> ----------------------------------------------
> Select s = SQLFactory.getSelect();
> s.from("tablex")
> s.where(x, s.EQUAL, y); or s.whereEqual(x, y);
> s.orderBy(x);
> s.groupBy(x);
> s.whereNotNull(x);
> s.get("colx"); // get is for columns
> s.whereNull(x);
> s.getDatePart(date, part);
> s.getConcat(List c);
> s.limit(start, offset);
> s.groupBy(x);
> s.sum(x);
> s.count(x);
> etc...
> rs = s.execute(conn);
>
> ----------------------------------------------
>
>
> Insert i = SQLFactory.getInsert();
> i.setTable("t");
> i.auto(colx);
> i.put(coly, val);
> i.execute(conn);
>
>
> // For auto database creation, you can register a table, if not made,
it will be made, if different, it will be altered
> Table t = new Table(name);
> t.addColumn("colx", java.sql.Types.INTEGER, int size);
>
> SQLFactory.register(t); // will call create if doesn't exist or
update if does
>
> or SQLFactory.create(t);
> or SQLFactory.update(t);
>
>
> ----------------------------------------------
> CrossdbResultSet will follow strict rules about date and time, etc,
at least so that every db returns the same results.
>
> ----------------------------------------------
>
> Support for ALL types in java.sql.Types
>
----------------------------------------------
I think it would be super rad if we had a built in layer .... perhaps an
xml configuration that could map the values that you expect in an
application to the actual DB values that a company has.... for example:
- I develop a sweet application that is a Contact Manager
- The appliction requires that I get basic information on the contact...
in my case:
Contact First Name = contact_fname
Contact Last Name = contact_lname
ect ....
- Compnay XYZ sees my contact manager and wants to build it into there
system.... unfortionatly the had a differnt naming scheme setup in there
db ... ie
Contect First Name = fname
Contact Last Name = lname
ect ....
If the was another layer that you could remap the values to a value
PROXY that you use in your app... i think that would be sweet ass.
Let me know if you think this is a wast of time or not.
Corey
----------------------------------------------
Some convenience classes like search(column, value); which would either
just be a select with some LIKE statements or could evolve to something
smarter like splitting the search phrase up and giving the return values
a rank.
|
|
From: <tr...@sp...> - 2003-03-25 04:23:46
|
It's because sourceforge asks what type of license you want on the project. And I chose the apache one because it is a good one. Lots of projects on sourceforge use it, click on it to see. Closed the bug, thanks for fixing, also gave you the ability to close them. Was on vacation, that's why it took so long for response. cheers Travis ---- Original Message ---- From: "Jorge =?ISO-8859-1?Q?P=E9rez?= \"Burgos (Koke)\"" <ko...@er...> Sent: 2003-03-18 To: Crossdb list <Cro...@li...> Subject: [Crossdb-developers] Bug 665290 fixed and question about license Hi, I fixed bug 665290 you can close it. I don't understand why this project has the Apache license, because this is not an apache project and that implies that it can have it. I will relicense with the LGPL license or something similar. - Jorge ------------------------------------------------------- This SF.net email is sponsored by: Does your code think in ink? You could win a Tablet PC. Get a free Tablet PC hat just for playing. What are you waiting for? http://ads.sourceforge.net/cgi-bin/redirect.pl?micr5043en _______________________________________________ Crossdb-developers mailing list Cro...@li... https://lists.sourceforge.net/lists/listinfo/crossdb-developers |
|
From: Jorge B. (Koke) <ko...@er...> - 2003-03-18 12:13:54
|
> I will relicense with the LGPL license or something similar. > This pretended to be a conditional sentence not an obligation ;) - Jorge |
|
From: Jorge B. (Koke) <ko...@er...> - 2003-03-18 12:06:09
|
Hi, I fixed bug 665290 you can close it. I don't understand why this project has the Apache license, because this is not an apache project and that implies that it can have it. I will relicense with the LGPL license or something similar. - Jorge |
|
From: Jorge B. (Koke) <ko...@er...> - 2003-03-11 00:41:11
|
Hi, I have modified this two files to get primary keys and foreign keys support. If you trust me i'll send you the cvs diff files and if you trust me more i'll modify in the CVS directly all i need is a CVS account. I have modified a lot files more, removing unnecesary imports and old comments of code. My next steps will be modified MySQLCreateTableQuery and to provide a PostgresSQLFactory if you want. I will not work in oracle or sqlServer at least at the moment :) Cheers |
|
From: <tr...@th...> - 2003-03-07 17:33:04
|
Yes, definitely interested. Send patches when done or maybe you can just commit to cvs. Travis ---- Original Message ---- From: "Jorge =?ISO-8859-1?Q?P=E9rez?= \"Burgos (Koke)\"" <ko...@er...> Sent: 2003-03-06 To: Crossdb list <Cro...@li...> Subject: [Crossdb-developers] CreateTable lacks of primaries keys and foreign keys Hi, My name is Jorge and i'm using this library for a program. I'm creating the database and i've seen that i can make primary keys and foreig keys and so on. I will modify the sources focus on hypersonic sql database. Are you interested in these changes? Bye ------------------------------------------------------- This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger for complex code. Debugging C/C++ programs can leave you feeling lost and disoriented. TotalView can help you find your way. Available on major UNIX and Linux platforms. Try it free. www.etnus.com _______________________________________________ Crossdb-developers mailing list Cro...@li... https://lists.sourceforge.net/lists/listinfo/crossdb-developers |
|
From: Jorge B. (Koke) <ko...@er...> - 2003-03-06 19:52:05
|
Hi, My name is Jorge and i'm using this library for a program. I'm creating the database and i've seen that i can make primary keys and foreig keys and so on. I will modify the sources focus on hypersonic sql database. Are you interested in these changes? Bye |
|
From: <tr...@th...> - 2003-02-24 17:12:29
|
Good point, i'll change that today. It will be in cvs.
Travis
---- Original Message ----
From: Michael Link <Li...@bt...>
Sent: 2003-02-24
To: cro...@li...
Subject: [Crossdb-developers] Support for long-Values
Hello,
it would be nice to have SelectQuery adjusted to
void addWhereCondition(String s, int i, long i1);
instead of
void addWhereCondition(String s, int i, int i1);
to support the maximum range of numeric values.
Greetings,
Michael
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Crossdb-developers mailing list
Cro...@li...
https://lists.sourceforge.net/lists/listinfo/crossdb-developers
|
|
From: Michael L. <Li...@bt...> - 2003-02-24 12:24:54
|
Hello,
it would be nice to have SelectQuery adjusted to
void addWhereCondition(String s, int i, long i1);
instead of
void addWhereCondition(String s, int i, int i1);
to support the maximum range of numeric values.
Greetings,
Michael
|
|
From: <tr...@th...> - 2003-01-14 17:29:32
|
setLimit() is not supported for the exact reasons you specified (not every db supports it). We started working on the idea of different levels of features that a database supports so you could have Level1SelectQuery that would add extra features, and keep going up, but hte problem is that some database may support limits, but not unions and another may support unions but not limits, so you can't level it. We could have all these features in the base SelectQuery interface and throw UnssupportedException or something, but then you lose the database independence. I'd be open to any suggestions you may have on this. Travis ---- Original Message ---- From: Georg Sendt <510...@t-...> Sent: 2003-01-14 To: CrossDB Mailing <cro...@li...> Subject: [Crossdb-developers] setLimix(x,y)-Support It may be already discussed, but are there any reasons why there is no setLimit(x,y)-Support? I know it is possible for some databases (mySQL, PostgreSQL) directly and there are some workarounds for mssql and oracle available. --Georg ------------------------------------------------------- This SF.NET email is sponsored by: FREE SSL Guide from Thawte are you planning your Web Server Security? Click here to get a FREE Thawte SSL guide and find the answers to all your SSL security issues. http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en _______________________________________________ Crossdb-developers mailing list Cro...@li... https://lists.sourceforge.net/lists/listinfo/crossdb-developers |
|
From: <510...@t-...> - 2003-01-14 13:52:47
|
It may be already discussed, but are there any reasons why there is no setLimit(x,y)-Support? I know it is possible for some databases (mySQL, PostgreSQL) directly and there are some workarounds for mssql and oracle available. --Georg |
|
From: Adam S. <ad...@tr...> - 2003-01-13 22:15:44
|
On Monday 13 January 2003 17:10, Adam Sherman wrote: > On Monday 13 January 2003 16:56, tr...@th... wrote: > > Use the addWhereString method to compare to a string, if you use > > addWhereCondition, it treats the strings as column names. > However, I'm using WhereCondition objects everywhere. Is this not the > proper way? Actually, I realise that I'm using WhereClause objects to build queries l= ike=20 "WHERE (a =3D s AND b =3D s) OR (a =3D s AND b =3D s", how do I do this u= sing=20 SelectQuery.addWhereString()? Thanks, A. --=20 Adam Sherman Tritus CG Inc. http://www.tritus.ca/ +1 (613) 797-6819 |
|
From: Adam S. <ad...@tr...> - 2003-01-13 22:11:55
|
On Monday 13 January 2003 16:56, tr...@th... wrote: > Use the addWhereString method to compare to a string, if you use > addWhereCondition, it treats the strings as column names. Ah! This explains much. However, I'm using WhereCondition objects everywhere. Is this not the pro= per=20 way? Thanks, A. --=20 Adam Sherman Tritus CG Inc. http://www.tritus.ca/ +1 (613) 797-6819 |
|
From: <tr...@th...> - 2003-01-13 22:04:28
|
Hi Adam,
Use the addWhereString method to compare to a string, if you use addWhereCondition, it treats the strings as column names.
Travis
---- Original Message ----
From: Adam Sherman <ad...@tr...>
Sent: 2003-01-13
To: cro...@li...
Subject: [Crossdb-developers] Missing Enclosing Quotes
Using the November 11th release and the hsqldb implementation.
My queries containing comparisons to Strings are missing the quotes:
SELECT id,name,family,location,floorArea,bedrooms,price FROM models WHERE
(location = Adult LifeStyle ) ORDER BY name
^^^^^^^^^^^^^^^
Is this normal behaviour?
Thanks,
A.
P.S. I tried building current CVS, but am not sure how to install Maven to
complete the build process.
--
Adam Sherman
Tritus CG Inc.
http://www.tritus.ca/
+1 (613) 797-6819
-------------------------------------------------------
This SF.NET email is sponsored by: FREE SSL Guide from Thawte
are you planning your Web Server Security? Click here to get a FREE
Thawte SSL guide and find the answers to all your SSL security issues.
http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en
_______________________________________________
Crossdb-developers mailing list
Cro...@li...
https://lists.sourceforge.net/lists/listinfo/crossdb-developers
|
|
From: Adam S. <ad...@tr...> - 2003-01-13 20:49:52
|
Using the November 11th release and the hsqldb implementation.
My queries containing comparisons to Strings are missing the quotes:
SELECT id,name,family,location,floorArea,bedrooms,price FROM models WHERE=
=20
(location =3D Adult LifeStyle ) ORDER BY name
^^^^^^^^^^^^^^^
Is this normal behaviour?
Thanks,
A.
P.S. I tried building current CVS, but am not sure how to install Maven t=
o=20
complete the build process.
--=20
Adam Sherman
Tritus CG Inc.
http://www.tritus.ca/
+1 (613) 797-6819
|
|
From: Travis R. <tr...@th...> - 2003-01-03 21:55:26
|
Hi Otis, There is no postgresql implementation yet, but it could be done fairly quickly depending on how similar it is to another implementation. If you can help us out, we could get one going right away by copying the most similar database in terms of handling identities and query syntax. Travis ----- Original Message ----- From: "otisg" <ot...@ur...> To: <cro...@li...> Sent: Tuesday, December 31, 2002 2:16 PM Subject: [Crossdb-developers] PostgreSQL support > Hello, > > Sorry to be asking this here, it wasn't > really clear from the web site - does > CrossDB support PostgreSQL? It looks like > the abstraction layer for PostgreSQL has not > been implemented yet, although PostgreSQL is > mentioned in a few places on the site. > > Could anyone confirm this please? > If there is indeed no support for PostgreSQL > currently, I was wondering if the support is > planned, and if so, when, roughly? > > Happy NY from NYC! > > Thank you, > Otis > > > ________________________________________________ > Get your own "800" number > Voicemail, fax, email, and a lot more > http://www.ureach.com/reg/tag > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Crossdb-developers mailing list > Cro...@li... > https://lists.sourceforge.net/lists/listinfo/crossdb-developers > |
|
From: otisg <ot...@ur...> - 2003-01-01 01:25:22
|
Thanks. Otis ---- On Tue, 31 Dec 2002, Gunter Sammet (gu...@sa...) wrote: > I had a working version for Interbase/Firebird about 9 months ago. Haven't > had time to update the code recently and I am not 100% familiar if this > would work for PostgreSQL as well. If yes, it shouldn't be too hard to get > it up to speed. Been hoping to do it already but since I am working in PHP > right now, there was no reason. > Still plan on getting it up to date though. Hopefully end of January. > > Happy NY, too from Calgary! > > Gunter > > -----Original Message----- > From: cro...@li... > [mailto:cro...@li...]On Behalf Of > otisg > Sent: December 31, 2002 2:16 PM > To: cro...@li... > Subject: [Crossdb-developers] PostgreSQL support > > > Hello, > > Sorry to be asking this here, it wasn't > really clear from the web site - does > CrossDB support PostgreSQL? It looks like > the abstraction layer for PostgreSQL has not > been implemented yet, although PostgreSQL is > mentioned in a few places on the site. > > Could anyone confirm this please? > If there is indeed no support for PostgreSQL > currently, I was wondering if the support is > planned, and if so, when, roughly? > > Happy NY from NYC! > > Thank you, > Otis > > > ________________________________________________ > Get your own "800" number > Voicemail, fax, email, and a lot more > http://www.ureach.com/reg/tag > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Crossdb-developers mailing list > Cro...@li... > https://lists.sourceforge.net/lists/listinfo/crossdb-developers > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Crossdb-developers mailing list > Cro...@li... > https://lists.sourceforge.net/lists/listinfo/crossdb-developers > > ________________________________________________ Get your own "800" number Voicemail, fax, email, and a lot more http://www.ureach.com/reg/tag |
|
From: Gunter S. <gu...@sa...> - 2003-01-01 00:17:03
|
I had a working version for Interbase/Firebird about 9 months ago. Haven't had time to update the code recently and I am not 100% familiar if this would work for PostgreSQL as well. If yes, it shouldn't be too hard to get it up to speed. Been hoping to do it already but since I am working in PHP right now, there was no reason. Still plan on getting it up to date though. Hopefully end of January. Happy NY, too from Calgary! Gunter -----Original Message----- From: cro...@li... [mailto:cro...@li...]On Behalf Of otisg Sent: December 31, 2002 2:16 PM To: cro...@li... Subject: [Crossdb-developers] PostgreSQL support Hello, Sorry to be asking this here, it wasn't really clear from the web site - does CrossDB support PostgreSQL? It looks like the abstraction layer for PostgreSQL has not been implemented yet, although PostgreSQL is mentioned in a few places on the site. Could anyone confirm this please? If there is indeed no support for PostgreSQL currently, I was wondering if the support is planned, and if so, when, roughly? Happy NY from NYC! Thank you, Otis ________________________________________________ Get your own "800" number Voicemail, fax, email, and a lot more http://www.ureach.com/reg/tag ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Crossdb-developers mailing list Cro...@li... https://lists.sourceforge.net/lists/listinfo/crossdb-developers |
|
From: otisg <ot...@ur...> - 2002-12-31 21:16:16
|
Hello, Sorry to be asking this here, it wasn't really clear from the web site - does CrossDB support PostgreSQL? It looks like the abstraction layer for PostgreSQL has not been implemented yet, although PostgreSQL is mentioned in a few places on the site. Could anyone confirm this please? If there is indeed no support for PostgreSQL currently, I was wondering if the support is planned, and if so, when, roughly? Happy NY from NYC! Thank you, Otis ________________________________________________ Get your own "800" number Voicemail, fax, email, and a lot more http://www.ureach.com/reg/tag |
|
From: <tr...@th...> - 2002-10-21 22:44:13
|
Hi, Just wanted to know what people thought of this for implementing limits: SelectQuery can have a function called setLimit(x, y); x is offset, y is range (or how many returned). Now for databases that support this natively, it's easy. For databases that don't support it, the CrossdbResultSet object could do the best thing possible, like Oracle could do the /*FIRST_ROWS*/ thing (or whatever the syntax is) that returns the results as soon as they come in rather than waiting for the whole set, and the Resultset could initialize itself to the offset and will have a counter that will only allow the user to call rs.next() up to y times. For SQL Server you could use TOP x + y so it will only return what is absolutely necessary then initialize it to start at x. Sound good? Sound crap? Travis Reeder |
|
From: <tr...@th...> - 2002-09-06 17:00:52
|
Not too sure, hasn't really been discussed yet. I'd be open for such a discussion if you have any ideas for it. Travis ---- Original Message ---- From: George Leontiadis <gl...@db...> Sent: 2002-09-06 To: Cro...@li... Subject: [Crossdb-developers] crossdb Transaction Support From what i've red it seems that crossdb does not support transactions I wonder if in a future version of crossdb you are going to implement such a feature Thanx George Leontiadis ------------------------------------------------------- This sf.net email is sponsored by: OSDN - Tired of that same old cell phone? Get a new here for FREE! https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 _______________________________________________ Crossdb-developers mailing list Cro...@li... https://lists.sourceforge.net/lists/listinfo/crossdb-developers |
|
From: George L. <gl...@db...> - 2002-09-06 07:45:18
|
From what i've red it seems that crossdb does not support transactions I wonder if in a future version of crossdb you are going to implement such a feature Thanx George Leontiadis |
|
From: <tr...@th...> - 2002-08-30 19:47:57
|
Ya, I like the idea of that option as well. Especially for people that want to have database independence with programs that are already written. So they don't have to convert to crossdb, they can just replace the jdbc driver with ldbc. And for new code, they can just start using crossdb directly. You should look into what it would require to merge the two like this and we'll go from there. Travis ---- Original Message ---- From: Thomas Mueller <tho...@po...> Sent: 2002-08-29 To: "'cro...@li...'" <cro...@li...> Subject: [Crossdb-developers] CrossDB and LDBC Hi Travis, > Use the ldbc sql parser to parse into a crossdb query/tree, then let crossdb finish off the db specific sql code. What do you think? LDBC is currently using Antlr (www.antlr.org) as the parser, and antlr uses it's own tree representation... not sure how to convert that to crossdb query/tree. I think on the high level it would be a good idea, but there may be some nasty technical problems. But probably nothing we can't solve. I think it would be great if the user can choose the method he would like to use, writing SQL statements and letting LDBC/CrossDB convert then, or only using CrossDB to generate SQL for him (for higher performance). Thomas P.S. I will be on vacation until mid next week. ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Crossdb-developers mailing list Cro...@li... https://lists.sourceforge.net/lists/listinfo/crossdb-developers |
3 messages has been excluded from this view by a project administrator.
