You can subscribe to this list here.
2007 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(3) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(1) |
Dec
(1) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2008 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
(12) |
Jun
(18) |
Jul
(1) |
Aug
(4) |
Sep
|
Oct
(10) |
Nov
|
Dec
|
2009 |
Jan
|
Feb
|
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: <Ca...@us...> - 2008-06-29 11:18:26
|
Revision: 104 http://sql2java.svn.sourceforge.net/sql2java/?rev=104&view=rev Author: Calmera Date: 2008-06-29 04:18:25 -0700 (Sun, 29 Jun 2008) Log Message: ----------- SCP publishing of builds Modified Paths: -------------- core/trunk/build.xml This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <Ca...@us...> - 2008-06-29 10:35:17
|
Revision: 103 http://sql2java.svn.sourceforge.net/sql2java/?rev=103&view=rev Author: Calmera Date: 2008-06-29 03:35:16 -0700 (Sun, 29 Jun 2008) Log Message: ----------- build file optimalisation Modified Paths: -------------- core/trunk/build.xml This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <Ca...@us...> - 2008-06-29 10:28:29
|
Revision: 102 http://sql2java.svn.sourceforge.net/sql2java/?rev=102&view=rev Author: Calmera Date: 2008-06-29 03:28:24 -0700 (Sun, 29 Jun 2008) Log Message: ----------- again, fixed some buildfile typo's Modified Paths: -------------- core/trunk/build.xml This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <Ca...@us...> - 2008-06-29 10:22:53
|
Revision: 101 http://sql2java.svn.sourceforge.net/sql2java/?rev=101&view=rev Author: Calmera Date: 2008-06-29 03:22:51 -0700 (Sun, 29 Jun 2008) Log Message: ----------- build file typo Modified Paths: -------------- core/trunk/build.xml This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <Ca...@us...> - 2008-06-29 10:20:43
|
Revision: 100 http://sql2java.svn.sourceforge.net/sql2java/?rev=100&view=rev Author: Calmera Date: 2008-06-29 03:20:37 -0700 (Sun, 29 Jun 2008) Log Message: ----------- Deleted some deprecated Unit tests. They were still using the old processables instead of the new nodelets Removed Paths: ------------- core/trunk/src/test/java/net/ This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <Ca...@us...> - 2008-06-28 21:46:59
|
Revision: 99 http://sql2java.svn.sourceforge.net/sql2java/?rev=99&view=rev Author: Calmera Date: 2008-06-28 14:46:58 -0700 (Sat, 28 Jun 2008) Log Message: ----------- Made some changes to wrongfully declared tasks Modified Paths: -------------- core/trunk/build.xml core/trunk/environment.properties This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <Ca...@us...> - 2008-06-28 20:50:29
|
Revision: 98 http://sql2java.svn.sourceforge.net/sql2java/?rev=98&view=rev Author: Calmera Date: 2008-06-28 13:50:24 -0700 (Sat, 28 Jun 2008) Log Message: ----------- Modified the build file to make use of hudson's properties. Also supplied two property files holding the settings for the build file. If hudson won't be used for executing, the project.properties file will be read. If hudson will be used, the properties inside the project.properties file will be supplied by hudson Modified Paths: -------------- core/trunk/build.xml Added Paths: ----------- core/trunk/environment.properties core/trunk/project.properties This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <Ca...@us...> - 2008-06-19 20:12:36
|
Revision: 97 http://sql2java.svn.sourceforge.net/sql2java/?rev=97&view=rev Author: Calmera Date: 2008-06-19 13:12:34 -0700 (Thu, 19 Jun 2008) Log Message: ----------- I have made some changes to the templates. We've starting the porting process ... Modified Paths: -------------- core/trunk/src/main/resources/config.cfg.xml core/trunk/src/main/resources/templates/java/descriptor.xml core/trunk/src/main/resources/templates/java/pertable/comparator.java.vm core/trunk/src/main/resources/templates/java/pertable/listener.java.vm This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <Ca...@us...> - 2008-06-19 20:11:23
|
Revision: 96 http://sql2java.svn.sourceforge.net/sql2java/?rev=96&view=rev Author: Calmera Date: 2008-06-19 13:11:21 -0700 (Thu, 19 Jun 2008) Log Message: ----------- Added some basic support for holding database relationship information Added Paths: ----------- core/trunk/src/main/java/net/sf/sql2java/fetching/sql/link/ core/trunk/src/main/java/net/sf/sql2java/fetching/sql/link/DatabaseLink.java core/trunk/src/main/java/net/sf/sql2java/fetching/sql/link/ManyToManyLink.java core/trunk/src/main/java/net/sf/sql2java/fetching/sql/link/OneToManyLink.java core/trunk/src/main/java/net/sf/sql2java/fetching/sql/link/OneToOneLink.java This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <Ca...@us...> - 2008-05-31 11:10:55
|
Revision: 95 http://sql2java.svn.sourceforge.net/sql2java/?rev=95&view=rev Author: Calmera Date: 2008-05-31 04:10:52 -0700 (Sat, 31 May 2008) Log Message: ----------- Port of the Listener Template Added Paths: ----------- core/trunk/src/main/resources/templates/java/pertable/listener.java.vm This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <Ca...@us...> - 2008-05-30 23:21:08
|
Revision: 94 http://sql2java.svn.sourceforge.net/sql2java/?rev=94&view=rev Author: Calmera Date: 2008-05-30 16:21:06 -0700 (Fri, 30 May 2008) Log Message: ----------- Woops, forgot to commit the changes to the launcher. You'll need this if you want to use my configuration. Modified Paths: -------------- core/trunk/src/main/java/net/sf/sql2java/Launcher.java This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <Ca...@us...> - 2008-05-30 23:19:35
|
Revision: 93 http://sql2java.svn.sourceforge.net/sql2java/?rev=93&view=rev Author: Calmera Date: 2008-05-30 16:19:34 -0700 (Fri, 30 May 2008) Log Message: ----------- Ok, maybe it's best if I do submit the already (partially) ported templates. I'm using these to test the new version, looking for any flaws or shortcomings. Maybe interesting to say, I'm using PostgreSQL 8.3 to do my testing. It would be great if someone would have a go with the current version on some other database. Added Paths: ----------- core/trunk/src/main/resources/config.cfg.xml core/trunk/src/main/resources/conversions.cfg.xml core/trunk/src/main/resources/templates/ core/trunk/src/main/resources/templates/java/ core/trunk/src/main/resources/templates/java/descriptor.xml core/trunk/src/main/resources/templates/java/perschema/ core/trunk/src/main/resources/templates/java/perschema/database.properties.vm core/trunk/src/main/resources/templates/java/perschema/exception/ core/trunk/src/main/resources/templates/java/perschema/exception/dao.exception.java.vm core/trunk/src/main/resources/templates/java/perschema/exception/data.access.exception.java.vm core/trunk/src/main/resources/templates/java/perschema/exception/data.retrieval.exception.java.vm core/trunk/src/main/resources/templates/java/perschema/exception/object.retrieval.exception.java.vm core/trunk/src/main/resources/templates/java/perschema/exception/optimistic.locking.exception.java.vm core/trunk/src/main/resources/templates/java/perschema/generated.bean.java.vm core/trunk/src/main/resources/templates/java/perschema/manager.java.vm core/trunk/src/main/resources/templates/java/pertable/ core/trunk/src/main/resources/templates/java/pertable/bean.java.vm core/trunk/src/main/resources/templates/java/pertable/comparator.java.vm core/trunk/src/main/resources/templates/java/scripts/ core/trunk/src/main/resources/templates/java/scripts/default.js This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <Ca...@us...> - 2008-05-30 23:12:45
|
Revision: 92 http://sql2java.svn.sourceforge.net/sql2java/?rev=92&view=rev Author: Calmera Date: 2008-05-30 16:12:44 -0700 (Fri, 30 May 2008) Log Message: ----------- Made some minor modifications while porting the 'java' templates: - JavaDataType : Added a flag which indicates if the datatype can be compared using a compareTo method - Table : Added methods to address the primary keys of the table - Column : Added a fullname property which can be used to retrieve the 'table.column' : Also modified the datatype property. It was holding an int-value while it should hold a SQLDataType. - NodeParameterHandler : When a node is added to the handler, the node's parents will be added too. This comes in very handy while addressing nodes inside the templates as well as inside the package descriptor. Instead of using the current scope as the node to execute the method, the node type should be supplied. - CamelCaseStringReference : Was added to convert underscored names (real_big_number) to camelcased ones (realBigNumber). This is not working atm. Modified Paths: -------------- core/trunk/src/main/java/net/sf/sql2java/common/beans/datatype/JavaDataType.java core/trunk/src/main/java/net/sf/sql2java/common/parameters/handlers/NodeParameterHandler.java core/trunk/src/main/java/net/sf/sql2java/data/holders/Column.java core/trunk/src/main/java/net/sf/sql2java/data/holders/Table.java core/trunk/src/main/java/net/sf/sql2java/data/node/BasicNodelet.java core/trunk/src/main/java/net/sf/sql2java/fetching/sql/SQLFetcher.java core/trunk/src/main/java/net/sf/sql2java/generator/Generator.java core/trunk/src/main/java/net/sf/sql2java/generator/template/Template.java Added Paths: ----------- core/trunk/src/main/java/net/sf/sql2java/generator/events/CamelCaseStringReference.java This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <Ca...@us...> - 2008-05-30 17:57:52
|
Revision: 91 http://sql2java.svn.sourceforge.net/sql2java/?rev=91&view=rev Author: Calmera Date: 2008-05-30 10:57:49 -0700 (Fri, 30 May 2008) Log Message: ----------- Added a Velocity reference injection listener. This listener will make sure references are parsed using the StringParser and the current node before they are injected into the template. Modified Paths: -------------- core/trunk/src/main/java/net/sf/sql2java/generator/Generator.java Added Paths: ----------- core/trunk/src/main/java/net/sf/sql2java/generator/events/ core/trunk/src/main/java/net/sf/sql2java/generator/events/ParameterStringReference.java This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <Ca...@us...> - 2008-05-30 12:39:41
|
Revision: 90 http://sql2java.svn.sourceforge.net/sql2java/?rev=90&view=rev Author: Calmera Date: 2008-05-30 05:39:39 -0700 (Fri, 30 May 2008) Log Message: ----------- I recreated strong-typed dataholders. They are needed because certain functionalities are specific to only one type of dataholder. For example relationships are only a concern of a table. I also rearranged the dataholders. As they used to be located inside the commons.beans package, the are now moved to the data.holders package. One major difference from the previous versions is the availability of nodes. Every dataholder is a node and as such, can be located inside the tree by using a path. We can use this later on to address specific nodes. Modified Paths: -------------- core/trunk/src/main/java/net/sf/sql2java/DatabaseReaderTester.java core/trunk/src/main/java/net/sf/sql2java/Launcher.java core/trunk/src/main/java/net/sf/sql2java/common/beans/Processable.java core/trunk/src/main/java/net/sf/sql2java/common/store/BasicProcessorStore.java core/trunk/src/main/java/net/sf/sql2java/common/store/ProcessorStore.java core/trunk/src/main/java/net/sf/sql2java/fetching/Fetcher.java core/trunk/src/main/java/net/sf/sql2java/fetching/sql/SQLFetcher.java core/trunk/src/main/java/net/sf/sql2java/generator/Generator.java core/trunk/src/main/java/net/sf/sql2java/generator/GeneratorCycle.java core/trunk/src/main/java/net/sf/sql2java/generator/template/Template.java core/trunk/src/main/java/net/sf/sql2java/packages/PackageReader.java core/trunk/src/main/java/net/sf/sql2java/packages/TemplatePack.java core/trunk/src/main/java/net/sf/sql2java/utils/ClassUtils.java Added Paths: ----------- core/trunk/src/main/java/net/sf/sql2java/common/parameters/handlers/NodeParameterHandler.java core/trunk/src/main/java/net/sf/sql2java/data/ core/trunk/src/main/java/net/sf/sql2java/data/MapPointer.java core/trunk/src/main/java/net/sf/sql2java/data/Path.java core/trunk/src/main/java/net/sf/sql2java/data/Pointer.java core/trunk/src/main/java/net/sf/sql2java/data/holders/ core/trunk/src/main/java/net/sf/sql2java/data/holders/Column.java core/trunk/src/main/java/net/sf/sql2java/data/holders/Database.java core/trunk/src/main/java/net/sf/sql2java/data/holders/Index.java core/trunk/src/main/java/net/sf/sql2java/data/holders/IndexColumn.java core/trunk/src/main/java/net/sf/sql2java/data/holders/Schema.java core/trunk/src/main/java/net/sf/sql2java/data/holders/Table.java core/trunk/src/main/java/net/sf/sql2java/data/node/ core/trunk/src/main/java/net/sf/sql2java/data/node/BasicNodelet.java core/trunk/src/main/java/net/sf/sql2java/data/node/Nodelet.java Removed Paths: ------------- core/trunk/src/main/java/net/sf/sql2java/common/beans/Scope.java core/trunk/src/main/java/net/sf/sql2java/common/beans/reference/MapPointer.java core/trunk/src/main/java/net/sf/sql2java/common/beans/reference/Path.java core/trunk/src/main/java/net/sf/sql2java/common/beans/reference/Pointer.java core/trunk/src/main/java/net/sf/sql2java/common/parameters/handlers/ProcessableParameterHandler.java This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <Ca...@us...> - 2008-05-28 14:59:41
|
Revision: 89 http://sql2java.svn.sourceforge.net/sql2java/?rev=89&view=rev Author: Calmera Date: 2008-05-28 07:59:39 -0700 (Wed, 28 May 2008) Log Message: ----------- The 'lister' branch is based on the 3.0 release and as so, it contains all the new features made available in it. It also contains a generic data structure instead of the strong-typed data-holders used in the 2.6 releases. Added Paths: ----------- core/branches/lister/ This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <Ca...@us...> - 2008-05-28 14:48:24
|
Revision: 88 http://sql2java.svn.sourceforge.net/sql2java/?rev=88&view=rev Author: Calmera Date: 2008-05-28 07:48:22 -0700 (Wed, 28 May 2008) Log Message: ----------- Adding latest modifications for the 3.0 release. I noticed it really is too hard to create a generic structure to persist the data fetched from the database. I'll try to use strong-typed objects again, so the code will be easier to understand. We'll keep the generic datastructure for a later release. Modified Paths: -------------- core/trunk/src/main/java/net/sf/sql2java/common/beans/Processable.java core/trunk/src/main/java/net/sf/sql2java/common/resources/Resource.java core/trunk/src/main/java/net/sf/sql2java/common/store/BasicProcessorStore.java core/trunk/src/main/java/net/sf/sql2java/common/store/ProcessorStore.java core/trunk/src/main/java/net/sf/sql2java/conversion/Convertor.java core/trunk/src/main/java/net/sf/sql2java/conversion/ConvertorConfigurer.java core/trunk/src/main/java/net/sf/sql2java/conversion/KeywordGroup.java core/trunk/src/main/java/net/sf/sql2java/fetching/sql/SQLFetcher.java core/trunk/src/main/java/net/sf/sql2java/generator/Generator.java core/trunk/src/main/java/net/sf/sql2java/generator/GeneratorCycle.java core/trunk/src/main/java/net/sf/sql2java/packages/PackageConfigurer.java core/trunk/src/main/java/net/sf/sql2java/packages/TemplatePack.java core/trunk/src/main/java/net/sf/sql2java/utils/StringUtils.java core/trunk/src/test/java/net/sf/sql2java/common/store/BasicProcessorStoreTest.java Added Paths: ----------- core/trunk/src/main/java/net/sf/sql2java/common/parameters/StringParser.java core/trunk/src/main/java/net/sf/sql2java/common/parameters/handlers/ core/trunk/src/main/java/net/sf/sql2java/common/parameters/handlers/ParameterHandler.java core/trunk/src/main/java/net/sf/sql2java/common/parameters/handlers/ProcessableParameterHandler.java This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <ca...@us...> - 2008-05-11 19:21:26
|
Revision: 87 http://sql2java.svn.sourceforge.net/sql2java/?rev=87&view=rev Author: calmera Date: 2008-05-11 12:21:24 -0700 (Sun, 11 May 2008) Log Message: ----------- Added a basic log4j configuration. It isn't perfect yet, but it will do for now Added Paths: ----------- core/trunk/src/main/java/log4j.properties This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <ca...@us...> - 2008-05-11 19:13:43
|
Revision: 86 http://sql2java.svn.sourceforge.net/sql2java/?rev=86&view=rev Author: calmera Date: 2008-05-11 12:13:41 -0700 (Sun, 11 May 2008) Log Message: ----------- Tried to make a first version work. It needed some modifications in the code to get things done. Modified Paths: -------------- core/trunk/src/main/java/net/sf/sql2java/common/beans/Scope.java core/trunk/src/main/java/net/sf/sql2java/common/parameters/ParameterizedString.java core/trunk/src/main/java/net/sf/sql2java/common/resources/Resource.java core/trunk/src/main/java/net/sf/sql2java/common/store/BasicProcessorStore.java core/trunk/src/main/java/net/sf/sql2java/common/store/ProcessorStore.java core/trunk/src/main/java/net/sf/sql2java/conversion/ConvertorConfigurer.java core/trunk/src/main/java/net/sf/sql2java/fetching/sql/SQLFetcher.java core/trunk/src/main/java/net/sf/sql2java/fetching/sql/SQLFetcherConfigurer.java core/trunk/src/main/java/net/sf/sql2java/generator/Generator.java core/trunk/src/main/java/net/sf/sql2java/generator/scripting/ScriptEnvironment.java core/trunk/src/main/java/net/sf/sql2java/packages/DirectoryPackageReader.java core/trunk/src/main/java/net/sf/sql2java/packages/PackageConfigurer.java This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <kam...@us...> - 2008-05-09 20:23:11
|
Revision: 85 http://sql2java.svn.sourceforge.net/sql2java/?rev=85&view=rev Author: kameleono Date: 2008-05-09 13:23:09 -0700 (Fri, 09 May 2008) Log Message: ----------- basic ant build file based on the one contributed by Charl van Jaarsveldt (charlvj) Added Paths: ----------- core/trunk/build.xml This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <ca...@us...> - 2008-05-05 09:12:23
|
Revision: 84 http://sql2java.svn.sourceforge.net/sql2java/?rev=84&view=rev Author: calmera Date: 2008-05-05 02:12:20 -0700 (Mon, 05 May 2008) Log Message: ----------- Added version control structures to for the ui Added Paths: ----------- gui/ gui/branches/ gui/tags/ gui/trunk/ This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: Daan G. <daa...@gm...> - 2008-01-09 07:24:04
|
Hello all, After reading a bit on Catalogs and Schema's, And messing with mysql which doesn't use the schema's, I had the main idea to remove the hierarchy between catalogs, schema's and tables. SQL2Java expects catalogs, schema's and tables to be used in the following way: Catalog + Schema + Table Instead of doing it this way, I suggest making the Catalog and Schema a property of a table. In many JDBC drivers, the Schema includes the creator of the table while the Catalog is a way to combine tables into a logical unit. Therefor converting them to properties of the table is possible. I don't know if I'm right saying the following, but isn't it so, we declare which catalog we'll use when connecting to the database trough the JDBC DSN? Or am I confused by the terms database and catalog? Do you think this is a good idea? Anyway, I am making a lot of changes to the sourcecode inside CVS, including a proper way to define which tables should be generated and which won't. I still need to send a request to the eclipse team to request for a proper plugin to be made. As for now, a Swing gui is being prepared. Filter settings will be defined inside an XML document, allowing us to save it between generations. This functionality is meant to replace the current filter feature using patterns. Again, Do you think this is a good idea? Or do you prefer the pattern way? Maybe the best of both worlds and implement both of them? Please give me some feedback about these issues. Regards, Daan |
From: kristof v. <kri...@gm...> - 2007-12-13 21:10:13
|
Hi @ll, Lately I've been working with the Eclipse framework to develop plugins. Now I'd like to transform this fresh knowledge into something useful by developing an Eclipse plugin for the Sql2Java project. If somebody else might be interested in such a contribution as well, feel free to contact me by Gmail, or even better by Instant Messaging using XMPP (Gtalk ao). I'm in the UTC/GMT +1 hour timezone (Brussels) My gmail, and also Gtalk account is: kri...@gm... happy coding, nkr1pt -- pub 1024D/49518FEF 2007-12-13 Key fingerprint = C6E8 B47C 8BEA 0A36 CA00 3E19 CA72 1A23 4951 8FEF uid Kristof Vanhaeren (nkr1pt) <kri...@gm... > sub 2048g/F9F61BFA 2007-12-13 |
From: Daan G. <daa...@gm...> - 2007-11-21 21:25:10
|
I will try to answer both your mails in this one. Maybe it's time to explain the origin of the 3.0 release. I think it will answer a lot of questions. As a student in my senior year, I took sql2java for a spin during my last term internship. I had to make some changes to it, but ended up re-designing and re-creating the whole application. The company where I was doing the internship was also investigating IBatis and Spring. Therefor I thought it would be nice to add support for these technologies to the project. But there was a problem. While adding support for Spring and IBatis, I kind of 'broke' the regular JDBC support as well as almost every template originally written for sql2java (due to different parameters used inside the templates). Instead of fixing this, I was too focussed on implementing the new features like scripting and template packs, resulting in a major gap in the template support. Finally convinced of my mistake, We (Kristof and me) started to modify the legacy sql2java templates so they can be used inside the 3.0 release. This might seem not so difficult, but it's taking a lot of time. -- So far the history part. To answer your questions: ---------------------------------------------------------------- Another question, looking in one of the files (QueryDefenition.java from package net.sf.sql2java.dal it says:- * To change this template, choose Tools | Template Manager * and open the template in the editor. */ Which, which program it is talking about? ---------------------------------------------------------------- This is actually due to my bad setup of netbeans. It prints a header onto every java file I create. Sorry for the confusion. ---------------------------------------------------------------- I have noticed all manner of stuff with references to Swing around in this project, but I have yet to find a main() that invokes any of it. ---------------------------------------------------------------- Well Alain and I both started creating some sort of GUI, He did it using plain java, I did it using netbeans wonderful GUI editor. You may try this allthough it won't help you much. An effort has been started to create an eclipse plugin, so it would be a lot easier to create templates, manage packs, configure the project, ... The code Alain and I wrote will be isolated and put inside another source folder. ---------------------------------------------------------------- Firstly, I keep using this list of people to send questions to, because there does not seem to be (or if there is I have not spotted it) a developers mailing list. If there is one can someone point me to is, and if there is not would it not be a good idea to have one - and no, a forum is in my view useless in this respect. ---------------------------------------------------------------- There is a mailinglist for developers which can be used for this purpose. Maybe it's also usefull to display a short list of all mailinglist, so everyone knows what to expect. - sql2java-cvs Holds CVS updates. I don't have the password for this list, so I'm unable to administer this. - sql2java-develop The list we should use to post this discussions, as well as others regarding the development of the project onto. - sql2java-eclipse Everything regarding the 'new' eclipse plugin - sql2java-users discussions for the users of the project. ---------------------------------------------------------------- Secondly we seem to have lost the ...Manager classes (I have no problem with this), but we also seem to have lost the Manager class which actually talks to the DB - at least in the common and java5 templates. Has anyone sketched out what this should look like for this time around. ---------------------------------------------------------------- This is a result of me being to stupid to create descent support for plain JDBC. I used Spring to hold all of my database configuration and to handle transactions. The manager classes will return once we have converted the legacy templates. ---------------------------------------------------------------- Finally (for this email) I notice in the dal directory that we still seem to be building strings with direct values in them. This means all manner of complication to avoid things like sql injection attacks and to do escaping correctly. I have offered before, and offer again, a class that I am using in my accounting package which keeps the SQL clauses and their parameters separate but organised, and then provides a means to build proper PreparedStatements with value substitution. It would require a little work to add into it the kind of subclass of ConditionParameter, but could be done. ---------------------------------------------------------------- It seems a very good idea to add your class to the utilities. sql injection attacks could indeed be a problem, although only for certain technologies. I think hibernate, Ibatis as well as others hold some sort of protection against this. But you are right, it is mandatory. As you have noticed reading this email, I made the mistake focussing the project to only a few technologies (IBatis, Spring). Then there is the problem of template dependencies. Imagine the IBatis/Spring example. This would imply using Spring based IBatis mappings, so Spring templates especially for IBatis. When changing the ORM technology, we also need to modify the templates inside the Spring pack. I'm still searching for a descent way to solve this issue. Ideas are always welcome. Daan Op woensdag 21-11-2007 om 15:03 uur [tijdzone +0000], schreef David Goodenough: > On Tuesday 20 November 2007, FAGOT Alain wrote: > > Hi, > > > > Due to the fact the DatabaseMetaData.getIndexInfo() method is returning > > info as well for the indices as for the keys, I suppose both the problems > > you are struggling with may be solved by an integrated approach. > > > > I can only encourage you to exchange your points of view about the issue. > > I keep clear in mind that "nfdavenport" is currently trying to make it work > > in the 2.6 line (mainly indexes), while "dfgdga" would like it to work > > correctly in the 3.0 line (mainly keys). Anyway, I hope that what is good > > design for one, can also be applied by the other. > > > > Many thanks for both your efforts to make a better sql2java, > > Another question, looking in one of the files (QueryDefenition.java from > package net.sf.sql2java.dal it says:- > > * To change this template, choose Tools | Template Manager > * and open the template in the editor. > */ > > Which, which program it is talking about? I have noticed all manner of > stuff with references to Swing around in this project, but I have yet > to find a main() that invokes any of it. > > David |
From: Daan G. <daa...@gm...> - 2007-06-11 11:49:18
|
Team, I will be changing large parts of the configuration. I think we can do better by using XMLBeans (Apache project) to read and write our configuration. Anyway, the document structure will change, which will allow these changes. Regards, Daan |