RE: ms access Orion?
I am sure, at one point in time, the same was true with Apache. But now that the kid has grown up, look where it is today. Which is why I make a big distinction between a plain open source, and a mature open source. Things like Apache, Linux, Mysql, and Postgresql are mature open source -- partly due to the fact that they been around for a number of years. Projects like Orion, Resin, Jboss, Tomcat, Enhydra, Openejb, and Jonas have the potential to become mature open source (yes, Orion is not open - piety), some more then others (like Jboss, Tomcat, and Openejb) and they probably will be. People ask, for example -- should they run Jboss in a production environment. The answer depends on how big is the user load in the production environment. Jboss doesn't currently support either horizontal or vertical clustering, and they have plans this year to implement vertical clustering. If the project continues to mature, there may be future plans to add horizontal clustering. A ! ! ! user from this list mentioned Gemstone's ability to work among many distributed VM's. So I am sure, for example, that some environments have no problem running an RDMS like Oracle for large projects and an RDMS like Mysql or Postgresql for small projects. -Original Message- From: Tim Endres [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 11:48 AM To: Orion-Interest Subject: RE: ms access Orion? However, MySQL support has not always been that "first class". I can remember the days when MySQL support was much like Orion support today - you needed the mailing list! Lets hope that Orion can make the same transition to providing strong support. tim. If you use mysql, I think you need to compile the Berkeley engine first to get transaction support. Please query MySQL on this, if you need to use transactions. Their support and documentation is first class (are you taking notes here Orion? There is a quiz next week). -Original Message- From: faisal [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 5:06 PM To: Orion-Interest Subject: Re: ms access Orion? Thank to all of u guys I have not been using BMP before and when i tried ms access it gave me a hard time though i works sometimes Thanks to your advice I am going to try MySQl for the moment Respect what a Great e-mailing list faisal - Original Message - From: Thomas mailto:[EMAIL PROTECTED] Pridham To: Orion-Interest mailto:[EMAIL PROTECTED] Sent: Thursday, February 15, 2001 7:01 PM Subject: RE: ms access Orion? Two other free RDMS's are: 1. Interbase (http:// www.interbase.com http://www.interbase.com ) - originally developed by Borland, now open source. I am using this product in a commercial environment. It is a bit unstable on Linux, but runs great on Win2000. This DB has a JDBC client. This is a cross platform DB. 2. SAP DB ( http://www.sap.com/solutions/technology/sapdb/ http://www.sap.com/solutions/technology/sapdb/ ) - open sourced by SAP. I have not worked with this DB yet, but I will soon. This DB also has a type 4 JDBC driver. This is a cross-platform DB. Both of these databases "appear" to be industrial strength :) -Original Message- From: Kemp Randy-W18971 [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 10:32 AM To: Orion-Interest Subject: RE: ms access Orion? Is ms access considered an RDMS and does it have a JDBC driver? If so, then it should be theoretically possible to have it work with Orion. But why would you want to do this? A better solution would be to work with something like Postgresql ( www.postgresql.org http://www.postgresql.orgom ) or Mysql ( www.mysql.com http://www.mysql.com ), if you don't have a commercial database (like Oracle) available. -Original Message- From: faisal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:55 PM To: Orion-Interest Subject: ms access Orion? does ms access work with Orion ?
RE: ms access Orion?
From: Joseph B. Ottinger [mailto:[EMAIL PROTECTED]] Why do you say "pity?" (I'm assuming you don't mean "piety" here.) Why should it be open source? Do you think you can apply patches faster than the Orion team? (I don't think I could, nor do I think you For me, the value of source is not that I would be able to fix bugs - although I might very well be able to do so. The real value is that source code substitutes reasonably well for documentation. Here's a hypothetical exception for you: com.evermind.server.rmi.OrionRemoteException: CrypticMessage at something.you.recognize.if.you.Are.lucky() at com.evermind.server.http.d3.sw(JAX) at com.evermind.server.http.d3.su(JAX) at com.evermind.server.http.ef.s1(JAX) at com.evermind.server.http.ef.do(JAX) at com.evermind.util.f.run(JAX) We've probably all experienced this at least once. Probably it was a silly mistake in the deployment descriptor, but the error shows up as an exception in the wrapper or somewhere else. I know I've seen posts to this list of exceptions which were obfuscated all the way up to the throw statement. Rare, but annoying as all hell. I've spent a lot of time in trial and error when a quick glance at the source code would have answered my question. Nothing documents like the code. I've even found the JDK source to be necessary - I had to comb through the RMI-IIOP source code to figure out what the error codes I was getting meant.Using RMI-IIOP is like using Orion, but without the (usually) verbose error messages and support community. :-( it, and their model fits them. Going open source means that they get relegated to supplying services only, which may indeed be profitable, but is profit the only motive? (I say no, because if it were, they'd sell Orion for more money.) I should point out that shipping source does not mean the product has to be free. Resin is a good example. It does open up the opportunity for competitors to see potential trade secrets. I don't know what black magic is under the covers, so I have no idea if this is a concern. Given how far ahead of the pack Orion is regarding the emerging j2ee specs, I suspect it might be. Personally, I've never seen a development tool or library documented sufficiently well that I didn't feel a need for source code. I *hate* trial-and-error programming, but it always consumes an inordinate amount of my development time. Believe me, I read manuals cover-to-cover, but even the good ones haven't stood up under fire. And the bad ones have just been plain wrong :-) I'm happy to continue using Orion, even without source code, mostly because I've already gotten over the worst of the learning curve. But there were times when I would have jumped on JBoss in a second if it supported EJB2.0. I wonder how many people who don't need the new spec features or have bigger pocketbooks have bailed because of documentation issues, and I wonder if shipping the source would be a quick half-solution to this problem. Jeff
RE: ms access Orion?
The point I am making is this: I will continue to use Orion, whether or not it is open source. Nor do I feel I am better then the people at Orion or those on this list. However, if the Orion code were open source, perhaps I or you may solve an error they can't, partially due to the environment we are running in or we are not caught in the syndrome of tunnel vision. How many times have you focused on the bigger picture, only to have a coworker look at the problem and point you in the right direction? Many times. The people are Orion are very bright. So are the founders of Jboss and openEJB. Yet I wouldn't expect them to solve all the zillion different combinations of problems, given all the different environmental variables, by themselves. They are happy for the bright people out there -- such as yourself. And yes, you can pat yourself on the back -- as you have made some very good insights in the past into server issues. So whether Orion is open source or not, is a d! ! ! ecision for them to make. I respect what they choose either way, but I still feel open source is better. -Original Message- From: Jeff Schnitzer To: Orion-Interest Sent: 2/17/01 4:25 AM Subject: RE: ms access Orion? From: Joseph B. Ottinger [mailto:[EMAIL PROTECTED]] Why do you say "pity?" (I'm assuming you don't mean "piety" here.) Why should it be open source? Do you think you can apply patches faster than the Orion team? (I don't think I could, nor do I think you For me, the value of source is not that I would be able to fix bugs - although I might very well be able to do so. The real value is that source code substitutes reasonably well for documentation. Here's a hypothetical exception for you: com.evermind.server.rmi.OrionRemoteException: CrypticMessage at something.you.recognize.if.you.Are.lucky() at com.evermind.server.http.d3.sw(JAX) at com.evermind.server.http.d3.su(JAX) at com.evermind.server.http.ef.s1(JAX) at com.evermind.server.http.ef.do(JAX) at com.evermind.util.f.run(JAX) We've probably all experienced this at least once. Probably it was a silly mistake in the deployment descriptor, but the error shows up as an exception in the wrapper or somewhere else. I know I've seen posts to this list of exceptions which were obfuscated all the way up to the throw statement. Rare, but annoying as all hell. I've spent a lot of time in trial and error when a quick glance at the source code would have answered my question. Nothing documents like the code. I've even found the JDK source to be necessary - I had to comb through the RMI-IIOP source code to figure out what the error codes I was getting meant.Using RMI-IIOP is like using Orion, but without the (usually) verbose error messages and support community. :-( it, and their model fits them. Going open source means that they get relegated to supplying services only, which may indeed be profitable, but is profit the only motive? (I say no, because if it were, they'd sell Orion for more money.) I should point out that shipping source does not mean the product has to be free. Resin is a good example. It does open up the opportunity for competitors to see potential trade secrets. I don't know what black magic is under the covers, so I have no idea if this is a concern. Given how far ahead of the pack Orion is regarding the emerging j2ee specs, I suspect it might be. Personally, I've never seen a development tool or library documented sufficiently well that I didn't feel a need for source code. I *hate* trial-and-error programming, but it always consumes an inordinate amount of my development time. Believe me, I read manuals cover-to-cover, but even the good ones haven't stood up under fire. And the bad ones have just been plain wrong :-) I'm happy to continue using Orion, even without source code, mostly because I've already gotten over the worst of the learning curve. But there were times when I would have jumped on JBoss in a second if it supported EJB2.0. I wonder how many people who don't need the new spec features or have bigger pocketbooks have bailed because of documentation issues, and I wonder if shipping the source would be a quick half-solution to this problem. Jeff
RE: ms access Orion?
I will resend this again, since I am not sure I replied to Orion or yoursef. I am not implying I'm better then the people at Orion or those on this list. Orion has some very bright people, but so are the founders of Jboss and openejb, but they would not expect to solve all the different combinations of problems by themselves. Can they recreative all the various combinations of hardware, software, etc., that the different users have put together? And how many times have you or I been caught in tunnel vision -- only to have some friend or coworker say to look here or there? And you need to pat yourself on the back -- since you have made some wonderful insights into the structures of the various servers. Yes, I have seen your great questions and insights at both Orion and openEJB. So what is the point? Whether Orion chooses to become open source or not, is up to them. I continue to use Orion and will do so. However, I think that more problems would be solved by the gre! ! ! at contributions of other bright people on this list if it were open source. -Original Message- From: Jeff Schnitzer To: Orion-Interest Sent: 2/17/01 4:25 AM Subject: RE: ms access Orion? From: Joseph B. Ottinger [mailto:[EMAIL PROTECTED]] Why do you say "pity?" (I'm assuming you don't mean "piety" here.) Why should it be open source? Do you think you can apply patches faster than the Orion team? (I don't think I could, nor do I think you For me, the value of source is not that I would be able to fix bugs - although I might very well be able to do so. The real value is that source code substitutes reasonably well for documentation. Here's a hypothetical exception for you: com.evermind.server.rmi.OrionRemoteException: CrypticMessage at something.you.recognize.if.you.Are.lucky() at com.evermind.server.http.d3.sw(JAX) at com.evermind.server.http.d3.su(JAX) at com.evermind.server.http.ef.s1(JAX) at com.evermind.server.http.ef.do(JAX) at com.evermind.util.f.run(JAX) We've probably all experienced this at least once. Probably it was a silly mistake in the deployment descriptor, but the error shows up as an exception in the wrapper or somewhere else. I know I've seen posts to this list of exceptions which were obfuscated all the way up to the throw statement. Rare, but annoying as all hell. I've spent a lot of time in trial and error when a quick glance at the source code would have answered my question. Nothing documents like the code. I've even found the JDK source to be necessary - I had to comb through the RMI-IIOP source code to figure out what the error codes I was getting meant.Using RMI-IIOP is like using Orion, but without the (usually) verbose error messages and support community. :-( it, and their model fits them. Going open source means that they get relegated to supplying services only, which may indeed be profitable, but is profit the only motive? (I say no, because if it were, they'd sell Orion for more money.) I should point out that shipping source does not mean the product has to be free. Resin is a good example. It does open up the opportunity for competitors to see potential trade secrets. I don't know what black magic is under the covers, so I have no idea if this is a concern. Given how far ahead of the pack Orion is regarding the emerging j2ee specs, I suspect it might be. Personally, I've never seen a development tool or library documented sufficiently well that I didn't feel a need for source code. I *hate* trial-and-error programming, but it always consumes an inordinate amount of my development time. Believe me, I read manuals cover-to-cover, but even the good ones haven't stood up under fire. And the bad ones have just been plain wrong :-) I'm happy to continue using Orion, even without source code, mostly because I've already gotten over the worst of the learning curve. But there were times when I would have jumped on JBoss in a second if it supported EJB2.0. I wonder how many people who don't need the new spec features or have bigger pocketbooks have bailed because of documentation issues, and I wonder if shipping the source would be a quick half-solution to this problem. Jeff
RE: ms access Orion?
I would refer you to my reply to Jeff. I really don't compare myself to others, nor do I want to. Personally, I am an hack fiction writer, but I would never say I am better then those in my class or in the world, for that matter. Yet I do have the potential to make a contribution, as do all the others on this list. Some commercial products choose to become open source, like Resin, and I don't see anyone using their code to copy them, and they are very successful - as far as I can tell. Tomcat is non commercial, but they have Sun, IBM, and Apache taking part in it, as well as other bright people in the Apache community. Whether Orion chooses to become or not become open source, is for them to decide -- I respect that decision either way. However, if they did choose to be open source, then shape people on this list, such as yourself, have the potential to help solve problems and make suggestions they may be too swamped with to do by themselves. -Original Message- From: Joseph B. Ottinger To: Orion-Interest Sent: 2/17/01 1:13 AM Subject: RE: ms access Orion? On Fri, 16 Feb 2001, Kemp Randy-W18971 wrote: I am sure, at one point in time, the same was true with Apache. But now that the kid has grown up, look where it is today. Which is why I Yeah, look where apache is today - used everywhere by people who don't need it to do much, which fits its capabilities really well. make a big distinction between a plain open source, and a mature open source. Things like Apache, Linux, Mysql, and Postgresql are mature open source -- partly due to the fact that they been around for a number of years. Projects like Orion, Resin, Jboss, Tomcat, Enhydra, They've been around for a number of years, meaning "for a while" - 0 is a number, too, after all - and maturity always comes with age. Unfortunately, quality doesn't. Openejb, and Jonas have the potential to become mature open source (yes, Orion is not open - piety), some more then others (like Jboss, Tomcat, and Openejb) and they probably will be. People ask, for Why do you say "pity?" (I'm assuming you don't mean "piety" here.) Why should it be open source? Do you think you can apply patches faster than the Orion team? (I don't think I could, nor do I think you could.) Do you think you understand what the spec is well enough? Do you think you have the discipline to keep to the spec even when it's retarded? I don't think most people are. (I know that I'd be vastly tempted to fix the Servlet API...) And do you REALLY think that the Orion team - which enjoys development more than support - should be forced to change their chosen business model just because YOU think YOU could do better with THEIR source than THEY can? They enjoy what they're doing and how they're doing it, and their model fits them. Going open source means that they get relegated to supplying services only, which may indeed be profitable, but is profit the only motive? (I say no, because if it were, they'd sell Orion for more money.) [SNIP!] Personally, I certainly benefit from open source, but realistically... it's not always the perfect solution. --- Joseph B. Ottinger [EMAIL PROTECTED] http://epesh.com/ IT Consultant
RE: ms access Orion?faisal again
That is a good question, and I think you will probably find them evenly matched, especially if you run mysql with the Berkeley engine. Has anyone out there benchmarked the two with EJB 2.0? -Original Message- From: faisal To: Orion-Interest Sent: 2/16/01 5:13 PM Subject: Re: ms access Orion?faisal again Thank u Last request from u guys Which is of those two MySql or Postegrel is most likely have better performane with EJB PMP ? thanks - Original Message - From: "Tim Endres" [EMAIL PROTECTED] To: "Orion-Interest" [EMAIL PROTECTED] Sent: Friday, February 16, 2001 5:47 PM Subject: RE: ms access Orion? However, MySQL support has not always been that "first class". I can remember the days when MySQL support was much like Orion support today - you needed the mailing list! Lets hope that Orion can make the same transition to providing strong support. tim. If you use mysql, I think you need to compile the Berkeley engine first to get transaction support. Please query MySQL on this, if you need to use transactions. Their support and documentation is first class (are you taking notes here Orion? There is a quiz next week). -Original Message- From: faisal [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 5:06 PM To: Orion-Interest Subject: Re: ms access Orion? Thank to all of u guys I have not been using BMP before and when i tried ms access it gave me a hard time though i works sometimes Thanks to your advice I am going to try MySQl for the moment Respect what a Great e-mailing list faisal - Original Message - From: Thomas mailto:[EMAIL PROTECTED] Pridham To: Orion-Interest mailto:[EMAIL PROTECTED] Sent: Thursday, February 15, 2001 7:01 PM Subject: RE: ms access Orion? Two other free RDMS's are: 1. Interbase (http:// www.interbase.com http://www.interbase.com ) - originally developed by Borland, now open source. I am using this product in a commercial environment. It is a bit unstable on Linux, but runs great on Win2000. This DB has a JDBC client. This is a cross platform DB. 2. SAP DB ( http://www.sap.com/solutions/technology/sapdb/ http://www.sap.com/solutions/technology/sapdb/ ) - open sourced by SAP. I have not worked with this DB yet, but I will soon. This DB also has a type 4 JDBC driver. This is a cross-platform DB. Both of these databases "appear" to be industrial strength :) -Original Message- From: Kemp Randy-W18971 [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 10:32 AM To: Orion-Interest Subject: RE: ms access Orion? Is ms access considered an RDMS and does it have a JDBC driver? If so, then it should be theoretically possible to have it work with Orion. But why would you want to do this? A better solution would be to work with something like Postgresql ( www.postgresql.org http://www.postgresql.orgom ) or Mysql ( www.mysql.com http://www.mysql.com ), if you don't have a commercial database (like Oracle) available. -Original Message- From: faisal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:55 PM To: Orion-Interest Subject: ms access Orion? does ms access work with Orion ?
RE: ms access Orion?faisal again
Sorry, Fascal. I misread your email and you didn't mention EJB 2.0. But I would ask if anyone has done any benchmarks that can shed some light. -Original Message- From: faisal To: Orion-Interest Sent: 2/16/01 5:13 PM Subject: Re: ms access Orion?faisal again Thank u Last request from u guys Which is of those two MySql or Postegrel is most likely have better performane with EJB PMP ? thanks - Original Message - From: "Tim Endres" [EMAIL PROTECTED] To: "Orion-Interest" [EMAIL PROTECTED] Sent: Friday, February 16, 2001 5:47 PM Subject: RE: ms access Orion? However, MySQL support has not always been that "first class". I can remember the days when MySQL support was much like Orion support today - you needed the mailing list! Lets hope that Orion can make the same transition to providing strong support. tim. If you use mysql, I think you need to compile the Berkeley engine first to get transaction support. Please query MySQL on this, if you need to use transactions. Their support and documentation is first class (are you taking notes here Orion? There is a quiz next week). -Original Message- From: faisal [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 5:06 PM To: Orion-Interest Subject: Re: ms access Orion? Thank to all of u guys I have not been using BMP before and when i tried ms access it gave me a hard time though i works sometimes Thanks to your advice I am going to try MySQl for the moment Respect what a Great e-mailing list faisal - Original Message - From: Thomas mailto:[EMAIL PROTECTED] Pridham To: Orion-Interest mailto:[EMAIL PROTECTED] Sent: Thursday, February 15, 2001 7:01 PM Subject: RE: ms access Orion? Two other free RDMS's are: 1. Interbase (http:// www.interbase.com http://www.interbase.com ) - originally developed by Borland, now open source. I am using this product in a commercial environment. It is a bit unstable on Linux, but runs great on Win2000. This DB has a JDBC client. This is a cross platform DB. 2. SAP DB ( http://www.sap.com/solutions/technology/sapdb/ http://www.sap.com/solutions/technology/sapdb/ ) - open sourced by SAP. I have not worked with this DB yet, but I will soon. This DB also has a type 4 JDBC driver. This is a cross-platform DB. Both of these databases "appear" to be industrial strength :) -Original Message- From: Kemp Randy-W18971 [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 10:32 AM To: Orion-Interest Subject: RE: ms access Orion? Is ms access considered an RDMS and does it have a JDBC driver? If so, then it should be theoretically possible to have it work with Orion. But why would you want to do this? A better solution would be to work with something like Postgresql ( www.postgresql.org http://www.postgresql.orgom ) or Mysql ( www.mysql.com http://www.mysql.com ), if you don't have a commercial database (like Oracle) available. -Original Message- From: faisal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:55 PM To: Orion-Interest Subject: ms access Orion? does ms access work with Orion ?
RE: ms access Orion?
If you
use mysql, I think you need to compile the Berkeley engine first to get
transaction support. Please query MySQL on this, if you need to use
transactions. Their support and documentation is first class (are you
taking notes here Orion? There is a quiz next week).
-Original Message-From: faisal
[mailto:[EMAIL PROTECTED]]Sent: Thursday, February 15,
2001 5:06 PMTo: Orion-InterestSubject: Re: ms access
Orion?
Thankto all of u guys
I have not been using BMP before and when i tried
ms access it gave me a hard time though i works sometimes
Thanks to your advice I am going to try MySQl for
the moment
Respect
what a Great e-mailing list
faisal
- Original Message -
From:
Thomas
Pridham
To: Orion-Interest
Sent: Thursday, February 15, 2001 7:01
PM
Subject: RE: ms access
Orion?
Two other free RDMS's are:
1. Interbase (http://www.interbase.com) - originally
developed by Borland, now open source. I am using this product in a
commercial environment. It is a bit unstable on Linux, but runs great
on Win2000. This DB has a JDBC client. This is a cross platform
DB.
2. SAP DB (http://www.sap.com/solutions/technology/sapdb/)
- open sourced by SAP. I have not worked with this DB yet, but I will
soon. This DB also has a type 4 JDBC driver. This is a
cross-platform DB.
Both of these databases "appear" to be industrial
strength :)
-Original Message-From: Kemp Randy-W18971
[mailto:[EMAIL PROTECTED]]Sent: Thursday, February 15,
2001 10:32 AMTo: Orion-InterestSubject: RE: ms
access Orion?
Is ms access considered an RDMS and does it have
a JDBC driver? If so, then it should be theoretically possible to
have it work with Orion. But why would you want to do
this? A better solution would be to work with something like
Postgresql (www.postgresql.org)
orMysql (www.mysql.com), if you
don't have a commercial database (like Oracle) available.
-Original Message-From: faisal
[mailto:[EMAIL PROTECTED]]Sent: Wednesday,
February 14, 2001 9:55 PMTo:
Orion-InterestSubject: ms access
Orion?
does ms access work with Orion
?
RE: ms access Orion?
However, MySQL support has not always been that "first class". I can remember the days when MySQL support was much like Orion support today - you needed the mailing list! Lets hope that Orion can make the same transition to providing strong support. tim. If you use mysql, I think you need to compile the Berkeley engine first to get transaction support. Please query MySQL on this, if you need to use transactions. Their support and documentation is first class (are you taking notes here Orion? There is a quiz next week). -Original Message- From: faisal [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 5:06 PM To: Orion-Interest Subject: Re: ms access Orion? Thank to all of u guys I have not been using BMP before and when i tried ms access it gave me a hard time though i works sometimes Thanks to your advice I am going to try MySQl for the moment Respect what a Great e-mailing list faisal - Original Message - From: Thomas mailto:[EMAIL PROTECTED] Pridham To: Orion-Interest mailto:[EMAIL PROTECTED] Sent: Thursday, February 15, 2001 7:01 PM Subject: RE: ms access Orion? Two other free RDMS's are: 1. Interbase (http:// www.interbase.com http://www.interbase.com ) - originally developed by Borland, now open source. I am using this product in a commercial environment. It is a bit unstable on Linux, but runs great on Win2000. This DB has a JDBC client. This is a cross platform DB. 2. SAP DB ( http://www.sap.com/solutions/technology/sapdb/ http://www.sap.com/solutions/technology/sapdb/ ) - open sourced by SAP. I have not worked with this DB yet, but I will soon. This DB also has a type 4 JDBC driver. This is a cross-platform DB. Both of these databases "appear" to be industrial strength :) -Original Message- From: Kemp Randy-W18971 [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 10:32 AM To: Orion-Interest Subject: RE: ms access Orion? Is ms access considered an RDMS and does it have a JDBC driver? If so, then it should be theoretically possible to have it work with Orion. But why would you want to do this? A better solution would be to work with something like Postgresql ( www.postgresql.org http://www.postgresql.orgom ) or Mysql ( www.mysql.com http://www.mysql.com ), if you don't have a commercial database (like Oracle) available. -Original Message- From: faisal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:55 PM To: Orion-Interest Subject: ms access Orion? does ms access work with Orion ?
Re: ms access Orion?faisal again
Thank u Last request from u guys Which is of those two MySql or Postegrel is most likely have better performane with EJB PMP ? thanks - Original Message - From: "Tim Endres" [EMAIL PROTECTED] To: "Orion-Interest" [EMAIL PROTECTED] Sent: Friday, February 16, 2001 5:47 PM Subject: RE: ms access Orion? However, MySQL support has not always been that "first class". I can remember the days when MySQL support was much like Orion support today - you needed the mailing list! Lets hope that Orion can make the same transition to providing strong support. tim. If you use mysql, I think you need to compile the Berkeley engine first to get transaction support. Please query MySQL on this, if you need to use transactions. Their support and documentation is first class (are you taking notes here Orion? There is a quiz next week). -Original Message- From: faisal [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 5:06 PM To: Orion-Interest Subject: Re: ms access Orion? Thank to all of u guys I have not been using BMP before and when i tried ms access it gave me a hard time though i works sometimes Thanks to your advice I am going to try MySQl for the moment Respect what a Great e-mailing list faisal - Original Message - From: Thomas mailto:[EMAIL PROTECTED] Pridham To: Orion-Interest mailto:[EMAIL PROTECTED] Sent: Thursday, February 15, 2001 7:01 PM Subject: RE: ms access Orion? Two other free RDMS's are: 1. Interbase (http:// www.interbase.com http://www.interbase.com ) - originally developed by Borland, now open source. I am using this product in a commercial environment. It is a bit unstable on Linux, but runs great on Win2000. This DB has a JDBC client. This is a cross platform DB. 2. SAP DB ( http://www.sap.com/solutions/technology/sapdb/ http://www.sap.com/solutions/technology/sapdb/ ) - open sourced by SAP. I have not worked with this DB yet, but I will soon. This DB also has a type 4 JDBC driver. This is a cross-platform DB. Both of these databases "appear" to be industrial strength :) -Original Message- From: Kemp Randy-W18971 [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 10:32 AM To: Orion-Interest Subject: RE: ms access Orion? Is ms access considered an RDMS and does it have a JDBC driver? If so, then it should be theoretically possible to have it work with Orion. But why would you want to do this? A better solution would be to work with something like Postgresql ( www.postgresql.org http://www.postgresql.orgom ) or Mysql ( www.mysql.com http://www.mysql.com ), if you don't have a commercial database (like Oracle) available. -Original Message- From: faisal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:55 PM To: Orion-Interest Subject: ms access Orion? does ms access work with Orion ?
RE: ms access Orion?
On Fri, 16 Feb 2001, Kemp Randy-W18971 wrote: I am sure, at one point in time, the same was true with Apache. But now that the kid has grown up, look where it is today. Which is why I Yeah, look where apache is today - used everywhere by people who don't need it to do much, which fits its capabilities really well. make a big distinction between a plain open source, and a mature open source. Things like Apache, Linux, Mysql, and Postgresql are mature open source -- partly due to the fact that they been around for a number of years. Projects like Orion, Resin, Jboss, Tomcat, Enhydra, They've been around for a number of years, meaning "for a while" - 0 is a number, too, after all - and maturity always comes with age. Unfortunately, quality doesn't. Openejb, and Jonas have the potential to become mature open source (yes, Orion is not open - piety), some more then others (like Jboss, Tomcat, and Openejb) and they probably will be. People ask, for Why do you say "pity?" (I'm assuming you don't mean "piety" here.) Why should it be open source? Do you think you can apply patches faster than the Orion team? (I don't think I could, nor do I think you could.) Do you think you understand what the spec is well enough? Do you think you have the discipline to keep to the spec even when it's retarded? I don't think most people are. (I know that I'd be vastly tempted to fix the Servlet API...) And do you REALLY think that the Orion team - which enjoys development more than support - should be forced to change their chosen business model just because YOU think YOU could do better with THEIR source than THEY can? They enjoy what they're doing and how they're doing it, and their model fits them. Going open source means that they get relegated to supplying services only, which may indeed be profitable, but is profit the only motive? (I say no, because if it were, they'd sell Orion for more money.) [SNIP!] Personally, I certainly benefit from open source, but realistically... it's not always the perfect solution. --- Joseph B. Ottinger [EMAIL PROTECTED] http://epesh.com/ IT Consultant
Re: ms access Orion?
Hello faisal, If you use the jdbc.odbc bridge, yes. But, why do you want to use Ms Access (just curiosity) Wednesday, February 14, 2001, 11:55:05 PM, you wrote: f does ms access work with Orion f ? -- Best regards, Rafaelmailto:[EMAIL PROTECTED]
RE: ms access Orion?
Is ms access considered an RDMS and does it have a JDBC driver? If so, then it should be theoretically possible to have it work with Orion. But why would you want to do this? A better solution would be to work with something like Postgresql (www.postgresql.org) orMysql (www.mysql.com), if you don't have a commercial database (like Oracle) available. -Original Message-From: faisal [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 14, 2001 9:55 PMTo: Orion-InterestSubject: ms access Orion? does ms access work with Orion ?
RE: ms access Orion?
Two other free RDMS's are: 1. Interbase (http://www.interbase.com) - originally developed by Borland, now open source. I am using this product in a commercial environment. It is a bit unstable on Linux, but runs great on Win2000. This DB has a JDBC client. This is a cross platform DB. 2. SAP DB (http://www.sap.com/solutions/technology/sapdb/) - open sourced by SAP. I have not worked with this DB yet, but I will soon. This DB also has a type 4 JDBC driver. This is a cross-platform DB. Both of these databases "appear" to be industrial strength :) -Original Message-From: Kemp Randy-W18971 [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 15, 2001 10:32 AMTo: Orion-InterestSubject: RE: ms access Orion? Is ms access considered an RDMS and does it have a JDBC driver? If so, then it should be theoretically possible to have it work with Orion. But why would you want to do this? A better solution would be to work with something like Postgresql (www.postgresql.org) orMysql (www.mysql.com), if you don't have a commercial database (like Oracle) available. -Original Message-From: faisal [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 14, 2001 9:55 PMTo: Orion-InterestSubject: ms access Orion? does ms access work with Orion ?
RE: ms access Orion?
There is a package that comes with JDK1.3 called "sun.jdbc.odbc", use diver located in that package. First u need to configure ODBC DataSource on your server, its located in Control Panel. Then u can use "sun.jdbc.odbc.JdbcOdbcDriver" to connect to it. If you are using it with Orion, i suggest for you to configure Orion's DataSource, configure it in /config/DataSources.xml, then u can access it from a servlets+ejbs. If you have problem configuring Orion's DataSource go to www.orionsupport.com it has all information/examples you need. Hope this helps -Anton aka sigg- -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kemp Randy-W18971Sent: Thursday, February 15, 2001 10:32 AMTo: Orion-InterestSubject: RE: ms access Orion? Is ms access considered an RDMS and does it have a JDBC driver? If so, then it should be theoretically possible to have it work with Orion. But why would you want to do this? A better solution would be to work with something like Postgresql (www.postgresql.org) orMysql (www.mysql.com), if you don't have a commercial database (like Oracle) available. -Original Message-From: faisal [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 14, 2001 9:55 PMTo: Orion-InterestSubject: ms access Orion? does ms access work with Orion ?
Re: ms access Orion?
Thankto all of u guys I have not been using BMP before and when i tried ms access it gave me a hard time though i works sometimes Thanks to your advice I am going to try MySQl for the moment Respect what a Great e-mailing list faisal - Original Message - From: Thomas Pridham To: Orion-Interest Sent: Thursday, February 15, 2001 7:01 PM Subject: RE: ms access Orion? Two other free RDMS's are: 1. Interbase (http://www.interbase.com) - originally developed by Borland, now open source. I am using this product in a commercial environment. It is a bit unstable on Linux, but runs great on Win2000. This DB has a JDBC client. This is a cross platform DB. 2. SAP DB (http://www.sap.com/solutions/technology/sapdb/) - open sourced by SAP. I have not worked with this DB yet, but I will soon. This DB also has a type 4 JDBC driver. This is a cross-platform DB. Both of these databases "appear" to be industrial strength :) -Original Message-From: Kemp Randy-W18971 [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 15, 2001 10:32 AMTo: Orion-InterestSubject: RE: ms access Orion? Is ms access considered an RDMS and does it have a JDBC driver? If so, then it should be theoretically possible to have it work with Orion. But why would you want to do this? A better solution would be to work with something like Postgresql (www.postgresql.org) orMysql (www.mysql.com), if you don't have a commercial database (like Oracle) available. -Original Message-From: faisal [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 14, 2001 9:55 PMTo: Orion-InterestSubject: ms access Orion? does ms access work with Orion ?
Re: ms access Orion?
ello, Sure it does. Just use JDBC-ODBC driver. Here is an example data-source entry: data-source class="com.evermind.sql.DriverManagerDataSource" name="Workflow" location="jdbc/WorkflowCoreDS" xa-location="jdbc/xa/WorkflowXADS" ejb-location="jdbc/WorkflowDS" connection-driver="sun.jdbc.odbc.JdbcOdbcDriver" username="" password="" url="jdbc:odbc:workflow" inactivity-timeout="30" / /data-sources BTW, since access does not support transaction, the xa-... line above is useless. Also when you deploy your ejb, make sure you don't use transaction. I use it for development and demonstration purposes on my puny lil' Win98 notebook. cheers romen IT Architect, Business And Data Services IBM GSA TEL: 612-84484716 FAX: 612-84484008 TIE: 84716 Rafael Alvarez [EMAIL PROTECTED]@orionserver.com on 16/09/2000 01:12:14 Please respond to Orion-Interest [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Orion-Interest [EMAIL PROTECTED] cc: Subject: Re: ms access Orion? Hello faisal, If you use the jdbc.odbc bridge, yes. But, why do you want to use Ms Access (just curiosity) Wednesday, February 14, 2001, 11:55:05 PM, you wrote: f does ms access work with Orion f ? -- Best regards, Rafaelmailto:[EMAIL PROTECTED]
