[JBoss-user] [EJB/JBoss] - EJB-QL query needed

2005-02-17 Thread sbrbot
I have two CMP entity beans AppUser representing user of application and AppRole representing security roles of application. There is bidirectional many-to-many relationship between these two beans. So each user can be assigned to many roles (method appUser.appRoles() returns collection containi

[JBoss-user] [Security & JAAS/JBoss] - Users/Roles managing web application

2004-10-21 Thread sbrbot
If one uses JDBSRealm or DataSourceRealm for user authentication (users/roles stored in database) is there any freeware web application for managing these entities? (Managing in terms of creation/deletion of users/roles, merging users and roles etc.) View the original post : http://www.jboss.or

[JBoss-user] [Persistence & CMP/JBoss] - Not able to create FK-constraints

2004-09-11 Thread sbrbot
Declaring true element in jmbosscmp-jdbc.xml JBoss will try to create foreign key constraints in database model that would be created during first start of server. Why JBoss does not create tables according to their occurence in xml? Actually problem is that JBoss engine tries (and does not succ

[JBoss-user] [Persistence & CMP/JBoss] - Re: Delete Foreign Key Object

2004-09-03 Thread sbrbot
Sorry, Alexey Loubyansky (not Labourney). View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3847158#3847158 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3847158 --- Th

[JBoss-user] [Persistence & CMP/JBoss] - Re: Delete Foreign Key Object

2004-09-03 Thread sbrbot
Although Alexey Labourney (JBoss CMP developer) should answer this question, I can only say that MySQL database with its database type variants (MyISAM, InnoDB, etc.) is not fully supported by JBoss in terms of foreign keys autocreation. As far as you know MySQL is specific in that way that it r

[JBoss-user] [Persistence & CMP/JBoss] - Re: BLOBs and Transactions

2004-08-22 Thread sbrbot
Then something wierd is happenong there, sounds like a bug but send something more ... View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3845847#3845847 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3845847 -

[JBoss-user] [Persistence & CMP/JBoss] - Re: EJB-QL - IS EMPTY

2004-08-22 Thread sbrbot
Standard IS NULL instead of "IS EMPTY" works just fine with EJBQL. BTW, I'm not sure if there exist this "EMPTY" in SQL syntax at all. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3845845#3845845 Reply to the post : http://www.jboss.org/index.html?module=bb

[JBoss-user] [Persistence & CMP/JBoss] - Re: EJB relations an PK fields

2004-08-20 Thread sbrbot
Bidirectional relation between Pricing and PricingService (one-to-many); part of ejb-jar.xml: | | Pricing-has-PricingServices | | pricing | PricingRelationshipRole | One | | pricing | Pricing |

[JBoss-user] [Persistence & CMP/JBoss] - Re: unique constraint & TransactionRolledbackLocalException

2004-08-20 Thread sbrbot
If you want to check before inserting new user whether the user with this alias already exist, you should create home test (finder or even better select) method findByAlias(String Alias) which will use EJBQL fo find user with this alias. Insert your new user only upon FinderException of findByAl

[JBoss-user] [Persistence & CMP/JBoss] - Re: BLOBs and Transactions

2004-08-20 Thread sbrbot
It seems that we're talkink about typo! Look at your column indicies of prepared statement (AFAIK the PreparedStatement is the only way for inserting BLOB/CLOB fields). View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3845695#3845695 Reply to the post : http://

[JBoss-user] [Persistence & CMP/JBoss] - Re: Delete Foreign Key Object

2004-08-20 Thread sbrbot
First of all you have to know that MyISAM table type in MySQL is obsolete because it does NOT support referential integrities! It is strongly recommended to use InnoDB database type where you can implement referentional integrities. Database without referential integrities and without transactio

[JBoss-user] [Persistence & CMP/JBoss] - Re: Cascade delete

2004-08-19 Thread sbrbot
I have read it for more than few times but have no clue what exactly are you pointing on!? From that paragraph I cannot conclude that container should try to destroy relationships before trying to delete bean. Finally, the question stays: how JBoss manages deployment descriptor element (only

[JBoss-user] [Persistence & CMP/JBoss] - Re: jboss ignores datasource directive in jbosscmp-jdbc.xml

2004-08-18 Thread sbrbot
Post what is your datasource configuration (deployment) file of datasource (*-ds.xml). It has to contain definition for two databases or you must have separate datasource configuration file for each database. Then in your JBoss deployment descriptor file you're able to define for each EJB which

[JBoss-user] [Persistence & CMP/JBoss] - Re: Composite key -CMP Bean

2004-08-18 Thread sbrbot
In composite key class one must have exactly the same names of getters/setters as defined in EJB using this composite PK class. So if your SomeEJB has getId1 and getId2 methods which are mapped on PK fields, then your SomePK must have exactly the same getId1 and getId2 methods! View the origina

[JBoss-user] [Persistence & CMP/JBoss] - Re: DB-Independent configuration

2004-08-18 Thread sbrbot
Yes, theoretically specifying database mapping is optional in JBoss deployment descriptor but if you do not specify it, JBoss will take default database mapping from standardjbosscmp-jdbc.xml and it is Hypersonic SQL mapping. So if you do not use Hypersonic DB then practically it is not optional

[JBoss-user] [Persistence & CMP/JBoss] - Re: Cascade delete

2004-08-18 Thread sbrbot
I did exactly that. I read your article on WIKI and found how to use . Without this article I wouldn't even know about DD parameter. (BTW, I tried to do some changes on this article but encountered difficulties to submit it. WIKI editor cripled my response! Something is wrong with this WIKI ed

[JBoss-user] [Persistence & CMP/JBoss] - Cascade delete

2004-08-18 Thread sbrbot
I work with JBoss v3.2.3, MySQL v4.0.20d and MySQL Connector/J 3.0.14 (stable) JDBC driver. I created one-to-many relationship between CustomerEJB-OrderEJB CMP beans. There is referential integrity between CUSTOMERS and ORDERS tables also cascading delete feature is set and it works if I delete

[JBoss-user] [Persistence & CMP/JBoss] - Re: Creating deployment descriptors for relationships

2004-08-16 Thread sbrbot
Sorry, my fault! "batch-cascade-delete" is in JBoss v3.2.3 DTD (jbosscmp-jdbc_3_2.dtd). My daployment dir was v3.2.3 and IDE looked vor XML validation (DTD) in old v3.0.8 dir. Sorry again. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3845218#3845218 Reply t

[JBoss-user] [Persistence & CMP/JBoss] - Re: Creating deployment descriptors for relationships

2004-08-16 Thread sbrbot
This attribute "batch-cascade-delete" is not defined inside DTD of JBoss v3.2.3 View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3845182#3845182 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3845182 -

[JBoss-user] [Security & JAAS/JBoss] - Re: Bug Workaround: Custom 401 error page fails WWW-Authenti

2004-06-18 Thread sbrbot
Exactly I encountered the same stange behaviour in JBoss 3.2.3/Apache 4.1.29 and I would call it a BUG. When one defines 401 custom error message JBoss/Apache does not at all prompt for credentials immidiately showing custom 401.htm page. Comparing 401 custom error message functionality in WebLo

[JBoss-user] [EJB/JBoss] - sqlexception-service.xml

2004-04-23 Thread sbrbot
In documentation there's stated that: sqlexception-service.xml provides a means of identifying non-fatal SQL exceptions for a given JDBC driver. What does it mean? How can I use this service and catch my SQLExceptions with it? View the original post : http://www.jboss.org/index.html?module=bb&

[JBoss-user] [Persistence & CMP/JBoss] - How to catch SQLException in JBoss?

2004-04-19 Thread sbrbot
How to catch SQLException thrown by CMP in JBoss? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3831373#3831373 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3831373 ---

[JBoss-user] [Persistence & CMP/JBoss] - SQLException and RemoveException

2004-04-16 Thread sbrbot
In my database (Oracle 9i,JBoss 3.2.3) I have 1:n relationship between Departments and Employees tables with referential integrity set to prevent deleting Department until there's Employee referencing it. When I call remove method on Department EJB for department being currently referenced with

[JBoss-user] [News & Announcements] - New improved look of JBoss JMX-console

2004-02-21 Thread sbrbot
http://www.open.hr/~sbrbot/JBoss View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3822425#3822425 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3822425 -