Re: [JDBC] j2ee compatiable jdbc driver on jdbc.postgresql.org?
* Ned Wolpert <[EMAIL PROTECTED]> wrote: | Humm... are you saying that the class PostgresqlDataSource doesn't work? I | guess I'm not sure what doesn't work with the driver. (Course, I've been using | PoolMan as the datasource to wrap the postgresql default connection rather than | using the datasource object, so I haven't been testing this myself, yet.) I think the datasource class is required to use pgsql with Castor. If I remember correctly I think it was contributed by the main author of Castor. I haven't used it myself for ages though... cheers, Gunnar -- Gunnar Rønning - [EMAIL PROTECTED] Senior Consultant, Polygnosis AS, http://www.polygnosis.com/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [JDBC] Logging in the driver
* "Dave Cramer" <[EMAIL PROTECTED]> wrote: | | This is ok, but it doesn't provide for various levels of debugging. | | One possibility is to use something like log4j, but given the recent | distaste for adding binaries to the download I am reluctant to add a | library. log4j support would have been cool, has we then would have much better mechanism for controlling logging. Have you had a look at log4j micro edition ? The API is drop in replacement for the real thing and the jar file only 25,281 bytes. The size shouldn't scare anybody, but it would be a required runtime component and that warrants some discussion... Check : http://qos.ch/ -- Gunnar Rønning - [EMAIL PROTECTED] Senior Consultant, Polygnosis AS, http://www.polygnosis.com/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: FW: Re: [JDBC] [PATCHES] Ant configuration
* Peter Eisentraut <[EMAIL PROTECTED]> wrote: | | > Seriously would installing GNU Make be enough, or would you need to install | > Cygwin and other packages as well ? | | GNU make runs natively on Windows. I know and I've used GNU Make when working with Windows, but that taught me that you often need alot more than GNU Make to port a makefile to Windows. Maybe maintaining two versions would be the best, ie. Make is used when building the distribution and Ant makefiles are provided for the convenience of users that think Ant works better. Then you could probably setup some very simple Makefile without full dependency graph(if you want that you need rely on a tool like jikes to generate it for you). That basically means that you need to recompile all *.java files when you have edited one Java file. -- Gunnar Rønning - [EMAIL PROTECTED] Senior Consultant, Polygnosis AS, http://www.polygnosis.com/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [JDBC] Ant installation (and other) issues!
* Tom Lane <[EMAIL PROTECTED]> wrote: | | Gunnar =?iso-8859-1?q?R=F8nning?= <[EMAIL PROTECTED]> writes: | > But anyway this off topic, what need to have is a build process that works | > nicely and I think including the ant binaries(around 500k) would be the | > best solution here. | | 500k of binaries? You just lost the argument. That's not an acceptable | amount of overhead to add to the Postgres distribution. Maybe another reason to look into less monolithic approaches. Both in terms of project distribution and release cycles, I still think a decoupling the JDBC interface from the main distribution is a good idea ;-) -- Gunnar Rønning - [EMAIL PROTECTED] Senior Consultant, Polygnosis AS, http://www.polygnosis.com/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [JDBC] Ant installation (and other) issues!
* Peter Eisentraut <[EMAIL PROTECTED]> wrote: | | Per-Olof Norén writes: | | > The Ant build system is making its way to be a "de facto" standard for building |java applications as | > it is built for the purpose. | | Make as been the standard for building any application for about 30 years. | GNU-style configure has been the standard for configuration management for | about 10 years. Windows NT and Visual Basic have been the standard for | enterprise computing for 5 years. Thank you very much. ;-) I can't your point or the joke, please enlighten me ;-) make is AFAIK the most common build program, but that doesn't mean that the tool is ideal everywhere. Progress is possible you know, evolutionary or revolutionary. GNU Make has been evolutionary, Ant is revolutionary. configure management is certainly a lot more than configure. I would argue that CVS is the most important configuration management tool, but the issue is of course broader. But anyway this off topic, what need to have is a build process that works nicely and I think including the ant binaries(around 500k) would be the best solution here. -- Gunnar Rønning - [EMAIL PROTECTED] Senior Consultant, Polygnosis AS, http://www.polygnosis.com/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [JDBC] [PATCHES] Ant configuration
* "Dave Cramer" <[EMAIL PROTECTED]> wrote:
|
|
| There seems to be enough interested parties to support both build tools.
| For the folks that want a Makefile, they can support it. If someone
| wants to support the build.xml file, then we should encourage it. I
| suspect that one of them will become obsolete on it's own.
I think that would be the best as well for time being. Don't remove ant
support as that is very useful for the people working on the JDBC code, and
add standard make files for building the system. Make itself is not designed
to work with a language like Java, so you need third party tools to handle
dependencies.
Gunnar
--
Gunnar Rønning - [EMAIL PROTECTED]
Senior Consultant, Polygnosis AS, http://www.polygnosis.com/
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Re: FW: Re: [JDBC] [PATCHES] Ant configuration
* Peter Eisentraut <[EMAIL PROTECTED]> wrote: | | > compile the JDBC driver via ant if Java and ant are installed. (Or, rather, I | > should be able to) | | You can also install GNU make on Windows. This is how we used to build or apps on Windows before Ant, but we portability issues with respect to scripts invoked from make is a PITA, IMHO ;-) Seriously would installing GNU Make be enough, or would you need to install Cygwin and other packages as well ? Has anybody tested this ? I suspect that something like that would not work painless. -- Gunnar Rønning - [EMAIL PROTECTED] Senior Consultant, Polygnosis AS, http://www.polygnosis.com/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [JDBC] [PATCHES] Ant configuration
* Peter Eisentraut <[EMAIL PROTECTED]> wrote: | | * Ant needs to be installed. Of course this is not that much of a | problem because you can simply install it. However, in automated build | environments this might not be so easy, so people are just going to opt to | leave out the JDBC driver. This can be solved by including the ant binaries. | * Ant doesn't provide an exit status; you have to watch the build to see | if it works. This is unacceptable. Hmm. Anybody with a solution here ? | | * In numerous attempts I have failed to convince Ant to place the built | files in a tree different from the source tree. This really makes it a | pain to build for multiple architectures (in Java, architecture = | different jdk). Is that what you want ? | | * Ant doesn't support gcj last I checked. This is a real tragedy because | gcj is the only free(tm) Java compiler available that seems to have a real | future. Ant doesn't support Kaffe very well, btw. It does support it now according to the documentation. I think open source jikes has a better future as a compiler, but it is not free in the GNU sense. | * The Ant language is not nearly as powerful as the stuff you can do in | Makefiles. Well, make doesn't solve the build problems for Java. Ant is made to remedy the problems with make and create and easier to use build tool for Java apps. The adoption rate of Ant suggests that the developers have been doing something right ;-) | | * Ant is, well, different. I have personally spent a lot of effort to | make all parts of PostgreSQL build the same way. Every new language has | to reinvent configuration and build management: Perl MakeMaker -- total | junk, Python distutils -- no thanks, Tcl -- well, at least they had the | right idea. Ant -- one more thing to go wrong. Currently, everything you | want to switch and change about the build of PostgreSQL you communicate to | the configure script. How do you change the Java compiler? Good question | -- not even the Ant manual can answer that because it depends on your | particular distribution. >From the Ant manual : It is possible to use different compilers. This can be selected with the "build.compiler" property. | | The problem is that Ant is a completely new and different tool that we | have to deal with, but it doesn't actually solve a problem that hasn't | been solved already. It solves some of the problems with make and it runs easily on platforms like Windows and Mac. When Ant 2.0 comes it will be a even more general task/build system as it will allow for scheduling ala cron as well. But that is off-topic ;-) -- Gunnar Rønning - [EMAIL PROTECTED] Senior Consultant, Polygnosis AS, http://www.polygnosis.com/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [JDBC] [PATCHES] Ant configuration
* Ned Wolpert <[EMAIL PROTECTED]> wrote:
|
| > Specifically, if we can include the ANT libraries in our CVS then my
| > objection to ANT (requiring users to trackdown and download ANT) goes
| > away, and I would then suggest we continue to use ANT for the other
| > reasons you mention.
|
| Works for me. As I mentioned in my last email, I'm easy about this one. As
| long as I can build it in Linux/UNIX, I'm happy. Its an added benefit to
| the postgresql community that it can be built on Windows and Mac.
If we can include ant binaries that would be the best I agree. The Apache
license shouldn't cause any trouble here, but mayve the size would ? What
is the minimum required size of the Ant binaries anyway ?
cheers,
Gunnar
--
Gunnar Rønning - [EMAIL PROTECTED]
Senior Consultant, Polygnosis AS, http://www.polygnosis.com/
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Re: FW: Re: [JDBC] [PATCHES] Ant configuration
* Ned Wolpert <[EMAIL PROTECTED]> wrote: | > Win. They can just download it from a web site or we could ship the | > jdbc JAR ourselves. | | True. I was really looking at it from those who wanted to build the jar from | source. If we make the jarfile available from the website, that's good for the | PostgreSQL releases, but it may not help those who want/need the JDBC driver | updated from CVS. And it doesn't help potential _JDBC driver_ developers sitting on Windows platforms either. But me too is usually all Linux or Solaris, but I'm just trying to illuminate the issues. -- Gunnar Rønning - [EMAIL PROTECTED] Senior Consultant, Polygnosis AS, http://www.polygnosis.com/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [JDBC] Whatever ... JDBC build patch
* Marko Kreen <[EMAIL PROTECTED]> wrote: | | * driver type is researched in configure, which is the | right place for it. How do distributors that need to build all driver types proceed ? Compile for each platform in different environments ? -- Gunnar Rønning - [EMAIL PROTECTED] Senior Consultant, Polygnosis AS, http://www.polygnosis.com/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [JDBC] [PATCHES] Ant configuration
* Bruce Momjian <[EMAIL PROTECTED]> wrote: | | I think I can safely at to TODO: | | JDBC | o Move from Ant to Make builds I don't think there is consesus over at the JDBC list yet. We need to get all the pros/cons for both solutions on the table first. Make is not neccesarily better than Ant, I would think a combination would work best. Because then Mac and Windows users could use Ant to compile their JDBC driver, while the compilation of the server on Unices would work seamlessly. -- Gunnar Rønning - [EMAIL PROTECTED] Senior Consultant, Polygnosis AS, http://www.polygnosis.com/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [JDBC] [PATCHES] Ant configuration
* "Dave Cramer" <[EMAIL PROTECTED]> wrote: | | The one issue I have with a non ant based build system is that it makes | it difficult to build the driver on a windows machine. I think is a valid concern, since a lot of clients presumably will be running on other architectures. Maybe a twofold solution ? 1. a very simple make file that doesn't care about dependencies and such. 2. ant as an alternative for developers and users of other platforms. And I think more and more projects are migrating towards using Ant. Even I have done so after 10 years of using make ;-) -- Gunnar Rønning - [EMAIL PROTECTED] Senior Consultant, Polygnosis AS, http://www.polygnosis.com/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [JDBC] [PATCHES] Ant configuration
* Peter Eisentraut <[EMAIL PROTECTED]> wrote: | | The use of Ant originally seemed attractive because it would solve the | detection of the jdk version, the portable invocation of the compiler, and | the dependency generation. However, I must currently consider this | experiment a failure, because for each problem Ant solves it introduces a | load of worse problems into the system. Thus, if we can agree to work out | a configure/make-based system for the next release I would be very much | for it. What are the pro and cons for each approach ? Would it be unfeasible to include the ant binary in the distribution or is there other problems as well ? If we use make I guess we could use jikes to generate dependency files for make, but that does give use much as we then will require jikes for developers. Another alternative is make clean or manual approaches. I would say that we have two primary concerns here : 1. A build process that JDBC developers find convenient and productive to work with. 2. A build process that the users find convenient. Downloading things like Ant is not helping them. -- Gunnar Rønning - [EMAIL PROTECTED] Senior Consultant, Polygnosis AS, http://www.polygnosis.com/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [JDBC] Serialize
| "Dave Cramer" <[EMAIL PROTECTED]> wrote: | | There are much better products out there with much better functionality | | See http://www.ambysoft.com/persistenceLayer.html | | I personally use Artom Rudoy's persistence layer | | www.sourceforge.net/projects/player Turbine at jakarta.apache.org has a persistence layer based on Scott Amblers paper as well. Maybe a list of persistence layers(with a short review of how they work with PostgreSQL) would be a good addon for the JDBC site. -- Gunnar Rønning - [EMAIL PROTECTED] Senior Consultant, Polygnosis AS, http://www.polygnosis.com/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [JDBC] JDBC patch procedures (Re: [PATCHES] Patch for jdbc2 ResultSet.java)
* Tom Lane <[EMAIL PROTECTED]> wrote: | | Of these #3 seems like the solution that will emerge in the long term | anyway; but do we have candidate patch-meisters now? | | Comments, better ideas, nominations, volunteers? I would like to nominate Barry Lind as he has been doing great work for a long time. Maybe 2-3 of the most active JDBC developers should be given commit access, so we're not dependent on one person to merge in patches. -- Gunnar Rønning - [EMAIL PROTECTED] Senior Consultant, Polygnosis AS, http://www.polygnosis.com/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [JDBC] Need help with JDBC driver. Problem, - getExportedKeys
* Keve Müller <[EMAIL PROTECTED]> wrote: | | An initial version for get(Imported|Exported)Keys and getCrossReference is | available in jxDBCon (http://jxbdcon.sf.net) the file can be extracted Do you only concentrate on compliance or is performance important as well ? Have you done any performance test of your driver vs. the driver shipped with the PostgreSQL distribution ? There was also another driver posted here for PostgreSQL about 1.5 years ago by Sverre Huseby, that had interesting performance characteristics. -- Gunnar Rønning - [EMAIL PROTECTED] Senior Consultant, Polygnosis AS, http://www.polygnosis.com/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [JDBC] ? (question mark) characters
* Rene Pijlman <[EMAIL PROTECTED]> wrote: | | Have you tried it with a database which was created with -E | LATIN1 and with an installation configured with | --enable-multibyte? You don't need multibyte for iso-8859-1. A simple test case reproducing the problem would be nice though. I don't have any 7.1 servers in production, but the 7.0 series doesn't have any problems at all with iso-8859-1. -- Gunnar Rønning - [EMAIL PROTECTED] Senior Consultant, Polygnosis AS, http://www.polygnosis.com/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [JDBC] Dúvida
Alan, The language of this list is English. We have a hard time understanding Portuguese. If you don't understand English, but do understand Spanish I would like to suggest that you check out the following website for documentation in Spanish : http://users.servicios.retecal.es/rsantos/ Cheers, Gunnar * [EMAIL PROTECTED] wrote: | | Bom, eu estou com milhões de dúvidas, mas vamos por partes | Eu não sei como instalar o PostgreSQL | Eu baixei o arquivo ZIP " postgresql-7.1.2.tar.zip " | No site da Postgre, extraí o arquivo para uma pasta, mas não vejo | Nenhum executável para instalar ou já começar a editar algo em SQL | Como faço para instalar o PostGreSQL ... e depois onde editar os | Códigos em SQL??? | | Desculpem a minha ignorância, mas eu preciso de ajuda. | | Obrigado pela atenção. | | Alan. | | | ---(end of broadcast)--- | TIP 5: Have you checked our extensive FAQ? | | http://www.postgresql.org/users-lounge/docs/faq.html | -- Gunnar Rønning - [EMAIL PROTECTED] Senior Consultant, Polygnosis AS, http://www.polygnosis.com/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [JDBC] jdbc "proxy" server ...
* "Marc G. Fournier" <[EMAIL PROTECTED]> wrote: | | have a database behind a firewall ... we'd like to make connections | available to that machine through a machine outside of the firewall, so | that its a secure connection to the "proxy", and in-secure from | proxy->database ... | | the 'clients' will be written in java ... What about tunneling your connections through ssh ? -- Gunnar Rønning - [EMAIL PROTECTED] Senior Consultant, Polygnosis AS, http://www.polygnosis.com/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[JDBC] Re: Couple of patches for jdbc driver
* Barry Lind <[EMAIL PROTECTED]> wrote: | | | Now having said that, there isn't any reason that the jdbc code can't | be released more frequently than the server. But without a lot more Maybe there could be sub releases or something, e.g. jdbc version 7.1.2_004 begin release number 4 of the JDBC driver for 7.1.2. We can't keep recommending people to use CVS tip and if we cannot release a quality version of the driver synchronized with the release of the core server, then we will need another release cycle. -- Gunnar Rønning - [EMAIL PROTECTED] Senior Consultant, Polygnosis AS, http://www.polygnosis.com/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [JDBC] Couple of patches for jdbc driver
* Bruce Momjian <[EMAIL PROTECTED]> wrote: | | > release cycles of the core engine from the interfaces. Make them separate | > projects. | | We have sort of done that now by pushing everyone to the CVS version. ;-) I know. The problem is that I wouldn't trust a CVS version of the JDBC driver in any production environment. I want a released version ;-) Maybe something for RedHat to pickup ? -- Gunnar Rønning - [EMAIL PROTECTED] Senior Consultant, Polygnosis AS, http://www.polygnosis.com/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [JDBC] Couple of patches for jdbc driver
* Bruce Momjian <[EMAIL PROTECTED]> wrote:
|
| This issue came up recently in relation to backpatching a python fix,
| and the conclusion was that jdbc 7.1.X is "a hopeless cause" and I tend
| to agree. I had >6 unapplied jdbc patches at the time we released 7.1.
| They are all now in CVS.
I've mentioned it before, but I really think it would nice to decouple the
release cycles of the core engine from the interfaces. Make them separate
projects.
Just my kroner,
Gunnar
--
Gunnar Rønning - [EMAIL PROTECTED]
Senior Consultant, Polygnosis AS, http://www.polygnosis.com/
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [JDBC] Which JDK to build jdbc1 driver on Linux?
* Rene Pijlman <[EMAIL PROTECTED]> wrote: | | What's the recommended JDK to build the jdbc1 version of the | driver on Linux? This is for test driving the driver. | | I guess it will have to be one from | http://www.blackdown.org/java-linux/ports.html, since AFAIK Sun | hasn't released Linux ports of the older JDK's. | | But which one? Should I just take the latest pre-Java2 release | that's available on Linux (1.1.8)? Or should I take the oldest | (1.0.2.) to test the driver for maximum compatibility? I guess the best one to use is the JDK that people is actually using. That is IBM jdk 1.1.8. It is the fastest and most reliable JDK ever released for Linux. We use this one the production platforms where we don't have a Java 2 requirement. -- Gunnar Rønning - [EMAIL PROTECTED] Senior Consultant, Polygnosis AS, http://www.polygnosis.com/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
