Re: [Hibernate] Urgent - Is this possible through hibernate??

2003-11-19 Thread Juozas Baliuka
You can do it in hebernate without JDBC. Implement stored procedure and use it this way: CREATE FUNCTION myProc() RETURNS INT . CREATE VIEW My_Update( ID, update_count ) as SELECT 'myConstant' , myProc(); Map this view to readonly object. - Original Message - From: "Vivian Fon

[Hibernate] Composite-id Identity Column Problem

2003-11-19 Thread Neema, Devesh (MED, Contractor)
Hi, I got stuck while inserting record in a table which have a Primary key as IDENTITY column and two Foreign Key. In hbm file I have defiend mapping like this: while inserting record it gives me following Exception java.sql.SQLException: [Microsoft][SQLServer 2000 Driver

Re: [Hibernate] Urgent - Is this possible through hibernate??

2003-11-19 Thread Michael Gloegl
Hi, I guess I am not explaining myself clearly. Hibernate fixes extremely well in the whole application except for the following part. So why dont you just use a straight SQL query through session.createSQLQuery() or by obtaining the Connection from Hibernate via session.connection() ? Michae

Re: [Hibernate] hibernate service in jboss

2003-11-19 Thread Christian Bauer
On 19 Nov (14:07), khote wrote: > The problem is: java says the package doesn't exist. Does it only look in > .jar files, is that the problem? Try to simplify your scenario by removing Maven and ask on the User Forum. -- Christian Bauer [EMAIL PROTECTED]

[Hibernate] hibernate service in jboss

2003-11-19 Thread khote
The scene: I've successfully written and implemented my hibernate package and implemented it as a JBoss service archive (.sar) I'd like to be able to import the packages in other parts of my (maven) project. Everything goes into an EAR, so the pathing and such is dealt with, it successfully deplo

[Hibernate] Other attributes in many-to-many relationship

2003-11-19 Thread Austin Rosenfeld
I have a many-to-many relationship in which some extra attributes are stored in the join table. Consider the following tables: Client ( clientId int PK ) Contact ( contactId int PK, attr1, attr2... ) ContactToClient ( clientId FK, contactId FK, relationshipTypeId int ) - I need to retrieve a

[Hibernate] Extending Session

2003-11-19 Thread Ugo Cei
Hi, for an application I'm writing, it would be useful to extend the functionalities of the Session interface via inheritance, with a class that either "implements Session" or "extends SessionImpl". Unfortunately, if I'm not mistaken, the Configuration class is hardwired to return an instance

RE: [Hibernate] Urgent - Is this possible through hibernate??

2003-11-19 Thread Sandeep Dath
Vivian, You shouldn't be using Hibernate for this sort of thing. Either write a simple JDBC-based framework on your own. Or pick something that is publicly available. If you are trying to automate an ETL process, then you could try http://octopus.enhydra.org/ (LGPL). I am not sure this is what y

Re: [Hibernate] Urgent - Is this possible through hibernate??

2003-11-19 Thread Christian Bauer
On 19 Nov (10:38), Vivian Fonger wrote: > involve more than 1 million records sometime. I want to know is there > ANY way that I don't need to select out the data through session.find > and save individual data through session.save into the system table. I For this kind of trivial mass operatio

RE: [Hibernate] Urgent - Is this possible through hibernate??

2003-11-19 Thread Vivian Fonger
Hi Christian, I guess I am not explaining myself clearly. Hibernate fixes extremely well in the whole application except for the following part. Here is the problem: One of the functionalities of my application is allowing users to reduce a set of data from certain tables in the database. The

Re: [Hibernate] Urgent - Is this possible through hibernate??

2003-11-19 Thread Christian Bauer
On 19 Nov (10:02), Vivian Fonger wrote: > Can someone give me some good suggestions on how to perform an efficient > insert-select through using hibernate?? I don't want to use straight SQL > because my application will support multiple database and I don't want > to create individual SQL for each

[Hibernate] Urgent - Is this possible through hibernate??

2003-11-19 Thread Vivian Fonger
Title: Message Hi everyone, Can someone give me some good suggestions on how to perform an efficient insert-select through using hibernate?? I don't want to use straight SQL because my application will support multiple database and I don't want to create individual SQL for each platform plus t