hsql datasource - can't make it work
Hi All... I'm sorry to ask such a basic question, but I have searched the archive with no luck. I can't make Hypersonic SQL work. I have downloaded hsql version 142 and Orion 1.2.0. I believe my problem is confusion about where everything goes. The docs say: 2. Put the hSql directory under /orion/lib/ When I examine the hsql distribution, I see the top level directory is "hypersonicsql", not hsql. So, I unzipped the hypersonic distribution below the orion/lib directory (which I suspect is wrong). I then modified the data-sorces.xml as indicated by the doc, changing the username and password attributes. When I restart Orion, I get: C:\orionjava -jar orion.jar Error initializing server: DriverManagerDataSource driver 'hSql.hDriver' not found I expect this is a simple problem, but I can't find the solution and would appreciate any help offered. What should it say when it does work? Thanks in advance... Alex
RE: please please please include change list with new releases
developers creating documentation that is useful to users? You must be kidding ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Karl Avedal Sent: Wednesday, August 16, 2000 23:26 To: Orion-Interest Subject: Re: please please please include change list with new releases Hello Ari, All I can say is that I couldn't agree more, we really need that and I'm internally pushing developers to write good notes meant for users, for every change they make :) Hopefully it will help. However, changes.txt will be updated to 1.2 when it's released (it's just experimental so far). Regards, Karl Avedal Ari Halberstadt wrote: I have no idea what has been changed in each version. Does version X fix some bug? What are the new features I can use? Anything cool and fun to play with? The changes.txt file included with v1.2.0 only goes up to v1.1.16, which is woefully out of date. Configuration management and bug tracking software can be used to automatically generate complete release notes, or you could have your engineers keep notes and include them with the distribution.
AW: MySql?
Just to drop in a line: We successfully use Interbase 6 as database server for our entity beans (BMP, so do not ask for a database scheme ;-). It should fit all the needs the people have that want to use MySQL - first of all, it's now free... (and, astonishingly, it seems even faster, although i did no real benchmarking). The JDBC drivers seem stable, but they do not support long and timestamp values in the database yet (that means, they only use Interbase dialect 1, not the new one, 3). Regards Jens Stutte -Ursprüngliche Nachricht- Von: Richard Woodward [mailto:[EMAIL PROTECTED]] Gesendet am: Donnerstag, 17. August 2000 02:30 An: Orion-Interest Cc: Orion-Interest Betreff: RE: MySql? MySQL can be used with EJB's, but entities will have to be written in such a way as to get around the lack of transaction support, ie. using table locks (Yuck!). THis however alone does not guarantee data integrity, as a connection that is dropped in the middle of a set of queries, will result in the locks being dropped, meaning table locks are only useful when two concurrect connections are trying to write/ read to the same table, and locks will ensure that one connection blocks till the other drops the lock. So, you can still do session beans, but not standard entity beans. MaxSQL is MySQL with Berkeley DB support for transactions. THis has been announced, but not released yet. I think they are waiting till the existing Berkeley DB transactions mod is more stable before they release it. You could have a preview by getting the Mod and installing it with MySQL and seeing how it goes with EJB's under Orion. Have not had too much of a play with EJB support on Orion yet, but i understand you have to create a schema for particular databases to use them as EJB datasources ?? cheers, Richard. ps. I have been using MySQL for some time on Orion, as a standard datasource, but have not tried it with EJB's yet. It is fine as a standard datasource, the JDBC drivers ( the mm variety ) even have transaction handling routines. (commit, rollback, etc... ) They just dont work, ie. The transaction gets fired through query by query without regard for data integrity. --- Richard Woodward G8 Labs Ltd. Wellington New Zealand Direct Dial (04) 9393414 --- On Wed, 16 Aug 2000, Michael Bushe wrote: Since MySQL doesn't support transactions (hence IMHO is a toy like MSAccess), so I would be surprised if it would work with any EJB server. If you want an open source solution I'd try PostgreSQL or Inprise's Interbase. I'm starting with Oracle and moving to one of those. I did try PostgreSQL with the RI and that worked, so I bet Orion would work too. Let us know or I'll let y'all know in a couple of months. Michael -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Steven Punte Sent: Wednesday, August 16, 2000 1:01 PM To: Orion-Interest Subject: MySql? Has anyone ever use the database "mysql" successfully with Orion? Steve STeve Punte e-Business Software Architect Technologent Inc [EMAIL PROTECTED]
Re: Different data-sources for different applications?
Karl Avedal wrote: Hello Anders, I see you've gotten good answers already, just wanted to point that if you want to use different defaults per application rather than per ejb, you can set the default-data-source attribute in the orion-application.xml file. Yeah, there lots of good and quick feedback on this list. Thanks, everyone! /Anders A n d e r s B e n g t s s o n[EMAIL PROTECTED] http://www.lecando.com
RE: MySql?
Interbase 6 is great, when you don't mind the shortcomings in the JDBC driver (a fix for it is now in testing, though): it does not support renaming columns using AS. So "select count(*) AS userCount from users" will not allow getInt("userCount"), though getInt(1) works fine, so there is a simple workaround. I find Interbase stable and fast as well. Maybe not quite as good there as Oracle, but at the price (and the footprint, full install is under 25MB, where Oracle has a minimum install of about 250MB). Jeroen T. Wenting [EMAIL PROTECTED] Murphy was wrong, things that can't go wrong will anyway -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jens Stutte Sent: Thursday, August 17, 2000 09:32 To: Orion-Interest Subject: AW: MySql? Just to drop in a line: We successfully use Interbase 6 as database server for our entity beans (BMP, so do not ask for a database scheme ;-). It should fit all the needs the people have that want to use MySQL - first of all, it's now free... (and, astonishingly, it seems even faster, although i did no real benchmarking). The JDBC drivers seem stable, but they do not support long and timestamp values in the database yet (that means, they only use Interbase dialect 1, not the new one, 3). Regards Jens Stutte -Ursprüngliche Nachricht- Von: Richard Woodward [mailto:[EMAIL PROTECTED]] Gesendet am: Donnerstag, 17. August 2000 02:30 An: Orion-Interest Cc: Orion-Interest Betreff: RE: MySql? MySQL can be used with EJB's, but entities will have to be written in such a way as to get around the lack of transaction support, ie. using table locks (Yuck!). THis however alone does not guarantee data integrity, as a connection that is dropped in the middle of a set of queries, will result in the locks being dropped, meaning table locks are only useful when two concurrect connections are trying to write/ read to the same table, and locks will ensure that one connection blocks till the other drops the lock. So, you can still do session beans, but not standard entity beans. MaxSQL is MySQL with Berkeley DB support for transactions. THis has been announced, but not released yet. I think they are waiting till the existing Berkeley DB transactions mod is more stable before they release it. You could have a preview by getting the Mod and installing it with MySQL and seeing how it goes with EJB's under Orion. Have not had too much of a play with EJB support on Orion yet, but i understand you have to create a schema for particular databases to use them as EJB datasources ?? cheers, Richard. ps. I have been using MySQL for some time on Orion, as a standard datasource, but have not tried it with EJB's yet. It is fine as a standard datasource, the JDBC drivers ( the mm variety ) even have transaction handling routines. (commit, rollback, etc... ) They just dont work, ie. The transaction gets fired through query by query without regard for data integrity. --- Richard Woodward G8 Labs Ltd. Wellington New Zealand Direct Dial (04) 9393414 --- On Wed, 16 Aug 2000, Michael Bushe wrote: Since MySQL doesn't support transactions (hence IMHO is a toy like MSAccess), so I would be surprised if it would work with any EJB server. If you want an open source solution I'd try PostgreSQL or Inprise's Interbase. I'm starting with Oracle and moving to one of those. I did try PostgreSQL with the RI and that worked, so I bet Orion would work too. Let us know or I'll let y'all know in a couple of months. Michael -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Steven Punte Sent: Wednesday, August 16, 2000 1:01 PM To: Orion-Interest Subject: MySql? Has anyone ever use the database "mysql" successfully with Orion? Steve STeve Punte e-Business Software Architect Technologent Inc [EMAIL PROTECTED]
JavaBean Introspection
Hi! I've come across a bit of a problem when using jsp:setProperty ... on a JavaBean using Orion. I have a HTML form with 3 input fields thats named: action, amount and productId. The form calls a .jsp page like : FORM action="processing/processCart.jsp" method="POST" ... and this JSP page uses the jsp:useBean id="cartBean" class... jsp:setProperty name="cartBean property="*"/ and so on.. At first it seemed to work because every set method was called on the JavaBean, but then it suddently stopped to work. Strange I though, and started going through the whole process checking that every was as it should be. But I just can't get it to work now.. Its the amont set method thats NOT being called anymore.. I tried with different parameters instead of String like: public void setAmount(Long _amount) but nothing happens.. It doesn't call it. So I changed the name in the INPUT field to nr and declared a method like: public void setNr(String _nr) and this gets called OK... Hasany1 ever experienced something like this??? Lars Borup JensenSoftware Developer ConsciusBådehavnsvej 159000 Aalborg+45 98 16 46 63[EMAIL PROTECTED]www.conscius.com
Help: Mapping roles to users.
Hi all, I have created an set of Enterprise beans and in the assembly descriptor I have defined a set of roles that have some permissions to run methods ( in ejb-jar.xml). When I deploy the application and the modify orion-ejb-jar.xml to map the roles to different groups in the assembly descriptor and than re-start or re-deploy the application (using orionconsole.jar) orion overwrites the changes I've made in orion-ejb-jar.xml (see below for the deployment descriptors ejb-jar.xml, orion-ejb-jar.xml and orion-ejb-jar.xml after re-starting/re-deploying). Has anybody done this in orion (with ejb 2.0 on orion 1.2.0) ? If so can you sent me the deployment descriptors ? Have I made an error ? (The groups are defined in principals.xml and the role-mappings aren't being overwritten in orion-application.xml). Does the default-method-acces tag in orion-ejb-jar.xml means that all the methods that aren't tied to a method permission in ejb-jar.xml can be called by the group/user and that all the methods that are can't be called ? Thanks in advance, Greetings Wim Veninga In ejb-jar.xml: ?xml version="1.0"?> !DOCTYPE ejb-jar PUBLIC "-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 1.1//EN" "http://java.sun.com/j2ee/dtds/ejb-jar_2_0.dtd"> !-- KOZIJNCALC BEANS --> ejb-jar> description>The deployment descriptor for the com.fnv.kozijncalc beans/description> enterprise-beans> entity> description>/description> ejb-name>Klant/ejb-name> home>com.fnv.kozijncalc.entities.klanten.KlantHome/home> remote>com.fnv.kozijncalc.entities.klanten.Klant/remote> ejb-class>com.fnv.kozijncalc.entities.klanten.KlantEJB/ejb-class> persistence-type>Container/persistence-type> prim-key-class>java.lang.Integer/prim-key-class> reentrant>False/reentrant> cmp-field>field-name>klantNr/field-name>/cmp-field> cmp-field>field-name>klantNaam/field-name>/cmp-field> cmp-field>field-name>klantAdres/field-name>/cmp-field> cmp-field>field-name>klantPostcode/field-name>/cmp-field> cmp-field>field-name>klantPlaats/field-name>/cmp-field> cmp-field>field-name>klantLand/field-name>/cmp-field> cmp-field>field-name>klantTelefoon/field-name>/cmp-field> cmp-field>field-name>klantContactPersoon/field-name>/cmp-field> primkey-field>klantNr/primkey-field> /entity> session> ejb-name>KlantSession/ejb-name> home>com.fnv.kozijncalc.sessions.klanten.KlantSessionHome/home> remote>com.fnv.kozijncalc.sessions.klanten.KlantSession/remote> ejb-class>com.fnv.kozijncalc.sessions.klanten.KlantSessionBean/ejb-class> session-type>Stateless/session-type> transaction-type>Container/transaction-type> ejb-ref> ejb-ref-name>kozijn/ejb/KlantHome/ejb-ref-name> ejb-ref-type>Entity/ejb-ref-type> home>com.fnv.kozijncalc.entities.klanten.KlantHome/home> remote>com.fnv.kozijncalc.entities.klanten.Klant/remote> ejb-link>Klant/ejb-link> /ejb-ref> /session> /enterprise-beans> assembly-descriptor> !-- Security roles --> security-role> role-name>calculator/role-name> /security-role> security-role> role-name>hoofd_calculator/role-name> /security-role> security-role> role-name>werkvoorbereiding/role-name> /security-role> !-- The method permissions that the different roles have to call methods --> !-- The method permissions for the werkvoorbereiding role, currently not any methods--> method-permission> role-name>werkvoorbereiding/role-name> /method-permission> !-- The calculator method permissions --> method-permission> description>The permissions of the calculator role/description> role-name>calculator/role-name> method> description>The permissions for the klant entity bean remote/description> ejb-name>Klant/ejb-name> method-intf>Remote/method-intf> method-name>*/method-name> /method> method> description>A permission for the klant entity bean home/description> ejb-name>Klant/ejb-name> method-intf>Home/method-intf> method-name>findAll/method-name> /method> method> description>A permission for the klant entity bean home/description> ejb-name>Klant/ejb-name> method-intf>Home/method-intf> method-name>findByKlantNaam/method-name> method-params> method-param>java.lang.String/method-param> /method-params> /method> method> description>A permission for the klant entity bean home/description> ejb-name>Klant/ejb-name> method-intf>Home/method-intf> method-name>findByPrimaryKey/method-name> method-params> method-param>java.lang.Integer/method-param> /method-params> /method> method> description>The permissions for the klant session bean /description> ejb-name>KlantSession/ejb-name> method-name>create/method-name> /method> method> description>The permissions for the klant session bean /description> ejb-name>KlantSession/ejb-name> method-name>findAllKlanten/method-name> /method> /method-permission> !-- The hoofd calculator method permissions --> method-permission> description>The permissions of the hoofd calculator role/description> role-name>hoofd_calculator/role-name> method> description>The permissions for the klant
Re: Orion and Cloudscape
Hi Ishpal, Thanks for the help. I'll try it out later (already have interbase working with orion and interbase is free(opensource since version 6), so the choice is obvious.) Workaround for your error: Use cloudscape with rmijdbc or cloudconnector so you have to start and shutdown the database server and not orion. Ishpal wrote: wim veninga wrote: JavierG wrote: Hi all: Can I make Orion and Clouscape run in the same VM? In that case, how? Wrapping Cloudscape in a servlet and running it within Orion? Any particular measure I should take in that case? All suggestions would be very welcome. Thanks J. Hi Javier, What do you mean with running cloudscape in the same VM. Are you just using cloudscape or do you have a framework (rmijdbc or cloud connector) that you want to run cloudscape in. If you just want to use cloudscape as an embedded db you can use it with orion and run it in the same VM as orion. You have to supply an datasource in datasources.xml and provide a schema for cloudscape and set the cloudscape.system.home property in orion.properties or at the command line when starting orion. Put the cloudscape.jar in the orion/lib directory and the client.jar in the client classpath (for exception etc..) What would be the purpose of wrapping cloudscape in an servlet ? Do you mean that you want to program the acces to the database yourself in the servet? Note I couldn't get cloudscape working with CMP, with BMP there were no problems but with cmp I get an strange error at the client side (object was null but still part of the cache). So if you get cloudscape working with CMP will you please let me know how you did it ? The xml files are supplied as an zip attachment. Hope this helps. Greetings Wim Veninga Name: cloudscapeXML.zip cloudscapeXML.zipType: Zip Compressed Data (application/x-zip-compressed) Encoding: base64 Hello, I can now get Cloudscape running with CMP. You can try the URL as ... url="jdbc:cloudscape:HelloWorldDB;autocommit=false" in the data-sources.xml file... It works pretty cool. The problem now is that when i try to shutdown the server using "admin.jar -shutdown" , the database instance is not shutdown... so next time I get a message like... WARNING: Cloudscape (instance c013800d-00e1-0894-8651-007f0100) is attempting to boot the database /home/ishpal/projects/Cloudscape/system_databases/HelloWorldDB even though cloudscape (instance c013800d-00e1-0880-1eb6-0 Which is scary and I dont want to end up destroying the database... Is there a way I can shutdown the database instance when the server is shutdown Thanks, Ishpal.
RE: Help: Mapping roles to users.
This week I only have 11am EST (8am here in California) open Mark LussierChief Software ArchitectGE Power Systems eBusinessDC 8*433-2232 -Original Message-From: wim veninga [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 17, 2000 11:05 AMTo: Orion-InterestSubject: Help: Mapping roles to users.Hi all, I have created an set of Enterprise beans and in the assembly descriptor I have defined a set of roles that have some permissions to run methods ( in ejb-jar.xml). When I deploy the application and the modify orion-ejb-jar.xml to map the roles to different groups in the assembly descriptor and than re-start or re-deploy the application (using orionconsole.jar) orion overwrites the changes I've made in orion-ejb-jar.xml (see below for the deployment descriptors ejb-jar.xml, orion-ejb-jar.xml and orion-ejb-jar.xml after re-starting/re-deploying). Has anybody done this in orion (with ejb 2.0 on orion 1.2.0) ? If so can you sent me the deployment descriptors ? Have I made an error ? (The groups are defined in principals.xml and the role-mappings aren't being overwritten in orion-application.xml). Does the default-method-acces tag in orion-ejb-jar.xml means that all the methods that aren't tied to a method permission in ejb-jar.xml can be called by the group/user and that all the methods that are can't be called ? Thanks in advance, Greetings Wim Veninga In ejb-jar.xml: ?xml version="1.0"? !DOCTYPE ejb-jar PUBLIC "-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 1.1//EN" "http://java.sun.com/j2ee/dtds/ejb-jar_2_0.dtd" !-- KOZIJNCALC BEANS -- ejb-jar descriptionThe deployment descriptor for the com.fnv.kozijncalc beans/description enterprise-beans entity description/description ejb-nameKlant/ejb-name homecom.fnv.kozijncalc.entities.klanten.KlantHome/home remotecom.fnv.kozijncalc.entities.klanten.Klant/remote ejb-classcom.fnv.kozijncalc.entities.klanten.KlantEJB/ejb-class persistence-typeContainer/persistence-type prim-key-classjava.lang.Integer/prim-key-class reentrantFalse/reentrant cmp-fieldfield-nameklantNr/field-name/cmp-field cmp-fieldfield-nameklantNaam/field-name/cmp-field cmp-fieldfield-nameklantAdres/field-name/cmp-field cmp-fieldfield-nameklantPostcode/field-name/cmp-field cmp-fieldfield-nameklantPlaats/field-name/cmp-field cmp-fieldfield-nameklantLand/field-name/cmp-field cmp-fieldfield-nameklantTelefoon/field-name/cmp-field cmp-fieldfield-nameklantContactPersoon/field-name/cmp-field primkey-fieldklantNr/primkey-field /entity session ejb-nameKlantSession/ejb-name homecom.fnv.kozijncalc.sessions.klanten.KlantSessionHome/home remotecom.fnv.kozijncalc.sessions.klanten.KlantSession/remote ejb-classcom.fnv.kozijncalc.sessions.klanten.KlantSessionBean/ejb-class session-typeStateless/session-type transaction-typeContainer/transaction-type ejb-ref ejb-ref-namekozijn/ejb/KlantHome/ejb-ref-name ejb-ref-typeEntity/ejb-ref-type homecom.fnv.kozijncalc.entities.klanten.KlantHome/home remotecom.fnv.kozijncalc.entities.klanten.Klant/remote ejb-linkKlant/ejb-link /ejb-ref /session /enterprise-beans assembly-descriptor !-- Security roles -- security-role role-namecalculator/role-name /security-role security-role role-namehoofd_calculator/role-name /security-role security-role role-namewerkvoorbereiding/role-name /security-role !-- The method permissions that the different roles have to call methods -- !-- The method permissions for the werkvoorbereiding role, currently not any methods-- method-permission role-namewerkvoorbereiding/role-name /method-permission !-- The calculator method permissions -- method-permission descriptionThe permissions of the calculator role/description role-namecalculator/role-name method descriptionThe permissions for the klant entity bean remote/description ejb-nameKlant/ejb-name method-intfRemote/method-intf method-name*/method-name /method method descriptionA permission for the klant entity bean home/description ejb-nameKlant/ejb-name method-intfHome/method-intf method-namefindAll/method-name /method method descriptionA permission for the klant entity bean home/description ejb-nameKlant/ejb-name method-intfHome/method-intf method-namefindByKlantNaam/method-name method-params method-paramjava.lang.String/method-param /method-params /method method descriptionA permission for the klant entity bean home/description ejb-nameKlant/ejb-name method-intfHome/method-intf method-namefindByPrimaryKey/method-name
Minimum orion-ejb-jar.xml?
Hello, does anyone know what fields in orion-ejb-jar.xml have to be defined for it to work? It seems to be a strange mix of user- and Orion-controlled fields, with no documentation about which fields that are needed. The attribute "wrapper" is of course filled out by Orion, but what about the rest? When my file consists of only orion-ejb-jar/orion-ejb-jar things work fine. But using empty "entity-deployment"-tags, with only attributes defined, Orion gives the strange error: java.lang.NullPointerException: length was zero at com.evermind.xml.XMLConfig.ax(JAX) at com.evermind.server.ServerComponent.aiu(JAX) at com.evermind.server.ServerComponent.initDeployment(JAX) at com.evermind.server.ejb.EJBPackageDeployment.aa2(JAX) at com.evermind.server.ejb.EJBContainer.b0(JAX) at com.evermind.server.Application.b0(JAX) at com.evermind.server.Application.f8(JAX) at com.evermind.server.ApplicationServer.o2(JAX) at com.evermind.server.ApplicationServer.alv(JAX) at com.evermind.server.ApplicationServer.f8(JAX) at com.evermind.server.gi.run(JAX) at java.lang.Thread.run(Thread.java:484) at com.evermind.util.f.run(JAX) Maybe this Orion trying to tell me that I need some more tag defined?.. /Anders A n d e r s B e n g t s s o n[EMAIL PROTECTED] http://www.lecando.com
Re: Help: Mapping roles to users.
This has been a long running problem that I never received an answer to, despite much discussion on this list. wim veninga wrote: Hi all, I have created an set of Enterprise beans and in the assembly descriptor I have defined a set of roles that have some permissions to run methods ( in ejb-jar.xml). When I deploy the application and the modify orion-ejb-jar.xml to map the roles to different groups in the assembly descriptor and than re-start or re-deploy the application (using orionconsole.jar) orion overwrites the changes I've made in orion-ejb-jar.xml (see below for the deployment descriptors ejb-jar.xml, orion-ejb-jar.xml and orion-ejb-jar.xml after re-starting/re-deploying). Has anybody done this in orion (with ejb 2.0 on orion 1.2.0) ? If so can you sent me the deployment descriptors ? Have I made an error ? (The groups are defined in principals.xml and the role-mappings aren't being overwritten in orion-application.xml). Does the default-method-acces tag in orion-ejb-jar.xml means that all the methods that aren't tied to a method permission in ejb-jar.xml can be called by the group/user and that all the methods that are can't be called ? Thanks in advance, Greetings Wim Veninga In ejb-jar.xml: ?xml version="1.0"?> !DOCTYPE ejb-jar PUBLIC "-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 1.1//EN" "http://java.sun.com/j2ee/dtds/ejb-jar_2_0.dtd"> !-- KOZIJNCALC BEANS --> ejb-jar> description>The deployment descriptor for the com.fnv.kozijncalc beans/description> enterprise-beans> entity> description>/description> ejb-name>Klant/ejb-name> home>com.fnv.kozijncalc.entities.klanten.KlantHome/home> remote>com.fnv.kozijncalc.entities.klanten.Klant/remote> ejb-class>com.fnv.kozijncalc.entities.klanten.KlantEJB/ejb-class> persistence-type>Container/persistence-type> prim-key-class>java.lang.Integer/prim-key-class> reentrant>False/reentrant> cmp-field>field-name>klantNr/field-name>/cmp-field> cmp-field>field-name>klantNaam/field-name>/cmp-field> cmp-field>field-name>klantAdres/field-name>/cmp-field> cmp-field>field-name>klantPostcode/field-name>/cmp-field> cmp-field>field-name>klantPlaats/field-name>/cmp-field> cmp-field>field-name>klantLand/field-name>/cmp-field> cmp-field>field-name>klantTelefoon/field-name>/cmp-field> cmp-field>field-name>klantContactPersoon/field-name>/cmp-field> primkey-field>klantNr/primkey-field> /entity> session> ejb-name>KlantSession/ejb-name> home>com.fnv.kozijncalc.sessions.klanten.KlantSessionHome/home> remote>com.fnv.kozijncalc.sessions.klanten.KlantSession/remote> ejb-class>com.fnv.kozijncalc.sessions.klanten.KlantSessionBean/ejb-class> session-type>Stateless/session-type> transaction-type>Container/transaction-type> ejb-ref> ejb-ref-name>kozijn/ejb/KlantHome/ejb-ref-name> ejb-ref-type>Entity/ejb-ref-type> home>com.fnv.kozijncalc.entities.klanten.KlantHome/home> remote>com.fnv.kozijncalc.entities.klanten.Klant/remote> ejb-link>Klant/ejb-link> /ejb-ref> /session> /enterprise-beans> assembly-descriptor> !-- Security roles --> security-role> role-name>calculator/role-name> /security-role> security-role> role-name>hoofd_calculator/role-name> /security-role> security-role> role-name>werkvoorbereiding/role-name> /security-role> !-- The method permissions that the different roles have to call methods --> !-- The method permissions for the werkvoorbereiding role, currently not any methods--> method-permission> role-name>werkvoorbereiding/role-name> /method-permission> !-- The calculator method permissions --> method-permission> description>The permissions of the calculator role/description> role-name>calculator/role-name> method> description>The permissions for the klant entity bean remote/description> ejb-name>Klant/ejb-name> method-intf>Remote/method-intf> method-name>*/method-name> /method> method> description>A permission for the klant entity bean home/description> ejb-name>Klant/ejb-name> method-intf>Home/method-intf> method-name>findAll/method-name> /method> method> description>A permission for the klant entity bean home/description> ejb-name>Klant/ejb-name> method-intf>Home/method-intf> method-name>findByKlantNaam/method-name> method-params> method-param>java.lang.String/method-param> /method-params> /method> method> description>A permission for the klant entity bean home/description> ejb-name>Klant/ejb-name> method-intf>Home/method-intf> method-name>findByPrimaryKey/method-name> method-params> method-param>java.lang.Integer/method-param> /method-params> /method> method> description>The permissions for the klant session bean /description> ejb-name>KlantSession/ejb-name> method-name>create/method-name> /method> method> description>The permissions for the klant session bean /description> ejb-name>KlantSession/ejb-name> method-name>findAllKlanten/method-name> /method> /method-permission> !-- The hoofd calculator method permissions --> method-permission> description>The permissions of
Re: Clustering in Orion
If I had any information about it, sure. I only have one machine; clustering isn't really an option for me. On Thu, 17 Aug 2000, Pedro Garcia Lopez wrote: Hello Joseph, Congratulation for your interesting site about Orion. My question is about clustering ? Do you plan to include some help in this issue ? Regards, Pedro --- Joseph B. Ottinger [EMAIL PROTECTED] http://cupid.suninternet.com/~joeo HOMES.COM Developer
Number of connections opened
I am creating an application that uses both CMP and BMP entity beans to connect to a database. There is only one database in the application. The development version of the Ingres database only allows five connections to be open. I am always running out of connections in Orion. Is there a way to set the number of connections being opened ? Also, what is the proper way get a Connection inside CMP entity bean ? I have been using: ds = (DataSource ) jndiContext.lookup("java:comp/env/jdbc/apsdev"); where I have resource-ref descriptionData source for WebEOL/description res-ref-namejdbc/apsdev/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref in my ejb-jar.xml. Thanks.
FEDERATION IN ORION
Hi, I need to stablish a federation between two servers and thus stablish a security context. For example Case 1: I authenticate against server A accesing a Web page, afterwards I connect to a protected web page in server B. I would like that my user information would be propagated to server B.This would avoid double authentication. Case 2: My application client connects and authenticates to a EJB in server A. It then connects to a EJB in server B and user information is propagated, no need for authentication again. Is this possible in Orion ? How ? Regards, Pedro
Need help retrieving EJB env values (fwd)
This is something sent to me that the list is more appropriate for. --- Joseph B. Ottinger [EMAIL PROTECTED] http://cupid.suninternet.com/~joeo HOMES.COM Developer -- Forwarded message -- Date: Thu, 17 Aug 2000 14:55:21 -0400 From: Otis Jinks [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Subject: Need help retrieving EJB env values Hi Joseph, I am having problems retrieving environment values for EJB's. The attached EAR deployment file and Java client file illustrates my problem. The deployment file contains a session bean with an environment entry 'EnvName1'. The client invokes the getEnvValue(String key) method on the session bean causing the session bean to try to read the value for the specified key from its environment. However, 'EnvName1' is not found in the bean's environment although it is specified in both ejb-jar.xml and orion-ejb-jar.xml. Am I doing something wrong, or is there a bug in the Orion server? Thanks, Otis Jinks NetVendor, Inc. [EMAIL PROTECTED] (404) 836-6676 test.ear TestOrionClient.java application-client.xml test.ear TestOrionClient.java application-client.xml
Re: hsql datasource - can't make it work
Thanks Richard. Unfortunatly, I get the very same error when I do this... --On Thursday, August 17, 2000 6:30 PM +1200 Richard Woodward [EMAIL PROTECTED] wrote: Alex, Only put the jar file (hsql.jar) in your lib dir. --- Richard Woodward G8 Labs Ltd. Direct Dial (04) 9393414 --- On Thu, 17 Aug 2000, Alex Johnson wrote: Hi All... I'm sorry to ask such a basic question, but I have searched the archive with no luck. I can't make Hypersonic SQL work. I have downloaded hsql version 142 and Orion 1.2.0. I believe my problem is confusion about where everything goes. The docs say: 2. Put the hSql directory under /orion/lib/ When I examine the hsql distribution, I see the top level directory is "hypersonicsql", not hsql. So, I unzipped the hypersonic distribution below the orion/lib directory (which I suspect is wrong). I then modified the data-sorces.xml as indicated by the doc, changing the username and password attributes. When I restart Orion, I get: C:\orionjava -jar orion.jar Error initializing server: DriverManagerDataSource driver 'hSql.hDriver' not found I expect this is a simple problem, but I can't find the solution and would appreciate any help offered. What should it say when it does work? Thanks in advance... Alex
Overriding Server response header
I would like to be able to customize the name of the header returned in the HTTP response headers, by using res.setHeader("Server","MyCompanyServer"). Using Resin standalone, I can get this to work. Using Resin with Apache, nothing happens - my server header is ignored or overridden by the default Apache header. Using Orion, however, I get two header entries - one identifying the server as Orion/1.0.3, and the other correctly identifying it as I intended. Is it possible to make this just the one Server header (i.e., mine)? John John Moore Senior Developer, Bizfinity API Bizfinity, Inc 1601 South De Anza Boulevard Suite 255 Cupertino, CA 95014-5351 T (408) 863-7300 x604 F (408) 863 7310 E [EMAIL PROTECTED]
Re: hsql datasource - can't make it work
Oh, right. Might need to see your data-source config file then. If you are going to post it to the group, dont forget to replace any sensitive info like passwords etc... with bogus ones ;-) --- Richard Woodward G8 Labs Ltd. Direct Dial (04) 9393414 --- On Thu, 17 Aug 2000, Alex Johnson wrote: Thanks Richard. Unfortunatly, I get the very same error when I do this... --On Thursday, August 17, 2000 6:30 PM +1200 Richard Woodward [EMAIL PROTECTED] wrote: Alex, Only put the jar file (hsql.jar) in your lib dir. --- Richard Woodward G8 Labs Ltd. Direct Dial (04) 9393414 --- On Thu, 17 Aug 2000, Alex Johnson wrote: Hi All... I'm sorry to ask such a basic question, but I have searched the archive with no luck. I can't make Hypersonic SQL work. I have downloaded hsql version 142 and Orion 1.2.0. I believe my problem is confusion about where everything goes. The docs say: 2. Put the hSql directory under /orion/lib/ When I examine the hsql distribution, I see the top level directory is "hypersonicsql", not hsql. So, I unzipped the hypersonic distribution below the orion/lib directory (which I suspect is wrong). I then modified the data-sorces.xml as indicated by the doc, changing the username and password attributes. When I restart Orion, I get: C:\orionjava -jar orion.jar Error initializing server: DriverManagerDataSource driver 'hSql.hDriver' not found I expect this is a simple problem, but I can't find the solution and would appreciate any help offered. What should it say when it does work? Thanks in advance... Alex
Re: Clustering in Orion
I have clustered Orion, but there is alot I don't know about it. I have learned that Orion does session replication to every server in the cluster farm. I have not been able to test it with a load-balancer yet. Anyone happen to know of a "free" software load-balancer that can be used to test multiple servers with? Clustering with Orion is easy. You just add a cluster id="x" / to server.xml on each server in the Orion/config dir. x is equal to a unique number on each server. then you add a cluster-config / to each orion-web.xml in the WEB-INF dir of a web app. That should cluster it. There are a number of issues I am not sure of however. If you run orion with the -console2 option, it brings up a SWING based admin console, and you can open the http tree and see the web-apps running, then look at sessions in each of those apps. When I cluster two servers, and hit one, the session data appears in both servers. However, on the server that the session was not created on, the values of the objects in the session are not available. This confuses me because I figured if I hit the other server that has been replicated to, and passed along the session ID (jsessionid=xxx), that it would automatically make that session available to me. However, one of our engineers mentioned that a session is stored via the ip address being hit. Thus, even though the session data is saved on two servers, trying to access the same session from two different ip addresses won't work. My only dilema here is..if a server goes down (say the one the session data was created on), so only one is left, does that automatically take over? I can't get this to work because I don't have a load balancer. I assume using a load-balancer is easy enough and this would work. Anyone from the Orion team care to respond..that would be great if you could explain how this is done. Thanks. - Original Message - From: "Joseph B. Ottinger" [EMAIL PROTECTED] To: "Orion-Interest" [EMAIL PROTECTED] Cc: "Orion-Interest" [EMAIL PROTECTED] Sent: Thursday, August 17, 2000 9:55 AM Subject: Re: Clustering in Orion If I had any information about it, sure. I only have one machine; clustering isn't really an option for me. On Thu, 17 Aug 2000, Pedro Garcia Lopez wrote: Hello Joseph, Congratulation for your interesting site about Orion. My question is about clustering ? Do you plan to include some help in this issue ? Regards, Pedro --- Joseph B. Ottinger [EMAIL PROTECTED] http://cupid.suninternet.com/~joeo HOMES.COM Developer
Re: hsql datasource - can't make it work
Thanks, Richard. I have pasted it below. ?xml version="1.0"? !DOCTYPE data-sources PUBLIC "Orion data-sources" "http://www.orionserver.com/dtds/data-sources.dtd" data-sources data-source name="Default data-source" class="com.evermind.sql.ConnectionDataSource" location="jdbc/DefaultDS" pooled-location="jdbc/DefaultPooledDS" xa-location="jdbc/xa/DefaultXADS" ejb-location="jdbc/DefaultEJBDS" url="jdbc:HypersonicSQL:defaultdb" connection-driver="hSql.hDriver" username="username" password="password" schema="database-schemas/hypersonic.xml" / /data-sources --On Friday, August 18, 2000 8:12 AM +1200 Richard Woodward [EMAIL PROTECTED] wrote: Oh, right. Might need to see your data-source config file then. If you are going to post it to the group, dont forget to replace any sensitive info like passwords etc... with bogus ones ;-) --- Richard Woodward G8 Labs Ltd. Direct Dial (04) 9393414 --- On Thu, 17 Aug 2000, Alex Johnson wrote: Thanks Richard. Unfortunatly, I get the very same error when I do this... --On Thursday, August 17, 2000 6:30 PM +1200 Richard Woodward [EMAIL PROTECTED] wrote: Alex, Only put the jar file (hsql.jar) in your lib dir. --- Richard Woodward G8 Labs Ltd. Direct Dial (04) 9393414 --- On Thu, 17 Aug 2000, Alex Johnson wrote: Hi All... I'm sorry to ask such a basic question, but I have searched the archive with no luck. I can't make Hypersonic SQL work. I have downloaded hsql version 142 and Orion 1.2.0. I believe my problem is confusion about where everything goes. The docs say: 2. Put the hSql directory under /orion/lib/ When I examine the hsql distribution, I see the top level directory is "hypersonicsql", not hsql. So, I unzipped the hypersonic distribution below the orion/lib directory (which I suspect is wrong). I then modified the data-sorces.xml as indicated by the doc, changing the username and password attributes. When I restart Orion, I get: C:\orionjava -jar orion.jar Error initializing server: DriverManagerDataSource driver 'hSql.hDriver' not found I expect this is a simple problem, but I can't find the solution and would appreciate any help offered. What should it say when it does work? Thanks in advance... Alex
Problem creating entities narrowed down
I've figured out part of my problem (at least I have a workaround): My entity contains three Date fields. If those fields are not given an explicit value (something other than null), then the ejbCreate fails. Here is a partial stack trace: Nested exception is: java.sql.SQLException: [Microsoft][ODBC Driver Manager] SQL data type out of range at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:4089) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:4246) at sun.jdbc.odbc.JdbcOdbc.SQLBindInParameterNull(JdbcOdbc.java:444) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setNull(JdbcOdbcPreparedStatement.ja va:303) at com.evermind.sql.am.setNull(JAX, Compiled Code) at com.evermind.sql.am.setNull(JAX, Compiled Code) at ContentHome_EntityHomeWrapper23.create(ContentHome_EntityHomeWrapper23.java, Compiled Code) Something in the system can't handle null dates, even though the table itself can handle null dates. I guess I could try a different JDBC driver and see if there are different results, but if I give values to the dates in ejbCreate, all goes well. Kurt in Seattle
Re: hsql datasource - can't make it work
Thanks Richard. That did it. It wanted: org.hsql.jdbcDriver I appreiate your help very much. Orion team, if your reading, do you think you could correct your docs/FAQ? Alex --On Friday, August 18, 2000 10:57 AM +1200 Richard Woodward [EMAIL PROTECTED] wrote: I just re-examined the contents of the jar file, and the class you are after is in org/hsql/jdbcDriver.class So try changing the driver line to "org.hsql.jdbcDriver" if that does not work, try org.hsql.Driver I will have a closer look when i am home from work in about 4 or 5 hours. Richard. --- Richard Woodward G8 Labs Ltd. Direct Dial (04) 9393414 --- On Thu, 17 Aug 2000, Alex Johnson wrote: tatus: RO X-Status: X-Keywords: X-UID: 394 Thanks, Richard. I have pasted it below. ?xml version="1.0"? !DOCTYPE data-sources PUBLIC "Orion data-sources" "http://www.orionserver.com/dtds/data-sources.dtd" data-sources data-source name="Default data-source" class="com.evermind.sql.ConnectionDataSource" location="jdbc/DefaultDS" pooled-location="jdbc/DefaultPooledDS" xa-location="jdbc/xa/DefaultXADS" ejb-location="jdbc/DefaultEJBDS" url="jdbc:HypersonicSQL:defaultdb" connection-driver="hSql.hDriver" username="username" password="password" schema="database-schemas/hypersonic.xml" / /data-sources --On Friday, August 18, 2000 8:12 AM +1200 Richard Woodward [EMAIL PROTECTED] wrote: Oh, right. Might need to see your data-source config file then. If you are going to post it to the group, dont forget to replace any sensitive info like passwords etc... with bogus ones ;-) --- Richard Woodward G8 Labs Ltd. Direct Dial (04) 9393414 --- On Thu, 17 Aug 2000, Alex Johnson wrote: Thanks Richard. Unfortunatly, I get the very same error when I do this... --On Thursday, August 17, 2000 6:30 PM +1200 Richard Woodward [EMAIL PROTECTED] wrote: Alex, Only put the jar file (hsql.jar) in your lib dir. --- Richard Woodward G8 Labs Ltd. Direct Dial (04) 9393414 --- On Thu, 17 Aug 2000, Alex Johnson wrote: Hi All... I'm sorry to ask such a basic question, but I have searched the archive with no luck. I can't make Hypersonic SQL work. I have downloaded hsql version 142 and Orion 1.2.0. I believe my problem is confusion about where everything goes. The docs say: 2. Put the hSql directory under /orion/lib/ When I examine the hsql distribution, I see the top level directory is "hypersonicsql", not hsql. So, I unzipped the hypersonic distribution below the orion/lib directory (which I suspect is wrong). I then modified the data-sorces.xml as indicated by the doc, changing the username and password attributes. When I restart Orion, I get: C:\orionjava -jar orion.jar Error initializing server: DriverManagerDataSource driver 'hSql.hDriver' not found I expect this is a simple problem, but I can't find the solution and would appreciate any help offered. What should it say when it does work? Thanks in advance... Alex
Re: Clustering in Orion
Quick and dirty "load balancing" is round robin DNS. I just did a quick test the other day and set up two machines with our app. Hit the URL once and logged in (keeps object in session). Killed the app on one machine and hit reload. I was still logged in on the other machine. I got some errors as Netscape didn't choose to look at the other IP (in RR DNS you specify multiple IPs for a single domain name) right off. But it did show that session failover worked. -- Joel Shellman Chief Software Architect The virally-driven B2B marketplace for outsourcing projects http://www.ants.com/90589781 Kevin Duffey wrote: I have clustered Orion, but there is alot I don't know about it. I have learned that Orion does session replication to every server in the cluster farm. I have not been able to test it with a load-balancer yet. Anyone happen to know of a "free" software load-balancer that can be used to test multiple servers with? Clustering with Orion is easy. You just add a cluster id="x" / to server.xml on each server in the Orion/config dir. x is equal to a unique number on each server. then you add a cluster-config / to each orion-web.xml in the WEB-INF dir of a web app. That should cluster it. There are a number of issues I am not sure of however. If you run orion with the -console2 option, it brings up a SWING based admin console, and you can open the http tree and see the web-apps running, then look at sessions in each of those apps. When I cluster two servers, and hit one, the session data appears in both servers. However, on the server that the session was not created on, the values of the objects in the session are not available. This confuses me because I figured if I hit the other server that has been replicated to, and passed along the session ID (jsessionid=xxx), that it would automatically make that session available to me. However, one of our engineers mentioned that a session is stored via the ip address being hit. Thus, even though the session data is saved on two servers, trying to access the same session from two different ip addresses won't work. My only dilema here is..if a server goes down (say the one the session data was created on), so only one is left, does that automatically take over? I can't get this to work because I don't have a load balancer. I assume using a load-balancer is easy enough and this would work. Anyone from the Orion team care to respond..that would be great if you could explain how this is done.
RE: hsql datasource - can't make it work
Using the latest version: hsql_142.zip (1.42 from June 2000), I had to change the value of: connection-driver="hSql.hDriver" to connection-driver="org.hsql.jdbcDriver" -Original Message- From: Alex Johnson [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 17, 2000 4:19 PM To: Orion-Interest Cc: Orion-Interest Subject: Re: hsql datasource - can't make it work Thanks, Richard. I have pasted it below. ?xml version="1.0"? !DOCTYPE data-sources PUBLIC "Orion data-sources" "http://www.orionserver.com/dtds/data-sources.dtd" data-sources data-source name="Default data-source" class="com.evermind.sql.ConnectionDataSource" location="jdbc/DefaultDS" pooled-location="jdbc/DefaultPooledDS" xa-location="jdbc/xa/DefaultXADS" ejb-location="jdbc/DefaultEJBDS" url="jdbc:HypersonicSQL:defaultdb" connection-driver="hSql.hDriver" username="username" password="password" schema="database-schemas/hypersonic.xml" / /data-sources --On Friday, August 18, 2000 8:12 AM +1200 Richard Woodward [EMAIL PROTECTED] wrote: Oh, right. Might need to see your data-source config file then. If you are going to post it to the group, dont forget to replace any sensitive info like passwords etc... with bogus ones ;-) --- Richard Woodward G8 Labs Ltd. Direct Dial (04) 9393414 --- On Thu, 17 Aug 2000, Alex Johnson wrote: Thanks Richard. Unfortunatly, I get the very same error when I do this... --On Thursday, August 17, 2000 6:30 PM +1200 Richard Woodward [EMAIL PROTECTED] wrote: Alex, Only put the jar file (hsql.jar) in your lib dir. --- Richard Woodward G8 Labs Ltd. Direct Dial (04) 9393414 --- On Thu, 17 Aug 2000, Alex Johnson wrote: Hi All... I'm sorry to ask such a basic question, but I have searched the archive with no luck. I can't make Hypersonic SQL work. I have downloaded hsql version 142 and Orion 1.2.0. I believe my problem is confusion about where everything goes. The docs say: 2. Put the hSql directory under /orion/lib/ When I examine the hsql distribution, I see the top level directory is "hypersonicsql", not hsql. So, I unzipped the hypersonic distribution below the orion/lib directory (which I suspect is wrong). I then modified the data-sorces.xml as indicated by the doc, changing the username and password attributes. When I restart Orion, I get: C:\orionjava -jar orion.jar Error initializing server: DriverManagerDataSource driver 'hSql.hDriver' not found I expect this is a simple problem, but I can't find the solution and would appreciate any help offered. What should it say when it does work? Thanks in advance... Alex
Basic security....
I'm probably missing something obvious, but... how does one set up security for URL's in Orion. For example, if I want to protect /foo/*, how can I do that?
Trouble with Rmi-Cloudscape from Orion
Hi, I'm having trouble connecting to cloudscape database from orion. Using the same driver, host and the port I can connect to the Cloudscape using RmiJdbcDriver from an application running in a different JVM, but when I try the same from orion I get an error like Auto-deploying hello-ejb... SQL error: The database driver (COM.cloudscape.core.RmiJdbcDriver@bb1928df) returned refused to connect to the URL jdbc:cloudscape:rmi://ishpal2:5/HelloWorldDB;create=true Warning: Error creating table: The database driver (COM.cloudscape.core.RmiJdbcDriver@bb1928df) returned refused to connect to the URL jdbc:cloudscape:rmi://ishpal2:5/HelloWorldDB;create=true Its driving me nuts... Is there some kind of setting to be done in some xml file in orion...??? I have to get this thing up or I might be forced to try with other products... please help Ishpal.