Question « Database « JPA Q&A





1. Design Question: Webapp with multiple projects using JEE and Hibernate    stackoverflow.com

I have a general design question that's bothering me for some time now. Goal:

  • Create a web application using Vaadin for the Front End
  • User must be able to create projects during runtime. Every ...

2. Hibernate - Legacy Database Question    coderanch.com

I have a table in my database which is versioned, so each record consists of ID, VERSION, TRADE_DATE, VALUE_DATE, etc where the primary key is a composite of ID and VERSION. So a trade with ID 12345 starts with VERSION 1, and this version number gets incremented on each update. Is there a recommended pattern for handling this in Hibernate? My ...

3. Hibernate made easy question: post relational databases    coderanch.com

Hi, I'm working on a project that uses Cach, a post relational database (in their words). It is a product from InterSystems company where I can manipulate data as objects. Do you think Hibernate is recommended to use with Cach? Have you had any experience connecting Hibernate with this product? Thank you.

4. derby and hibernate db relative path question    coderanch.com

hi- i have a hibernate.cfg.xml and a hibernate.properties file. how can i either make it so hibernate.cfg.xml or hibernate.properties reside outside the fatjar directory structure so a user can edit them to point to their choice of db install location (this would be cool) OR better yet, is there a way to make it so it is coded so that the ...

5. Hibernate and triggers. Novice's question.    forum.hibernate.org

Good day! When I create,modify,delete some object, I must create,modify,delete an another object in my entire application. SQL solves problem by trigger. As, I understand, event system must help. There are two questions. How make event for specific class only? And second - what event I need to use for insert/update? post-insert works fine, but after transaction so nothing writes to ...

6. Newbie question - using Hibernate to detect database changes    forum.hibernate.org

I'm trying to check whether Hibernate would support the following scenario :- I have a standard application that I'm using Hibernate with to manage the persistence layer (a MySQL database). So all CRUD operations from my application are done via Hibernate. However, there are other clients to the database (e.g. users using an SQL query tool session, .NET clients etc). Is ...

7. using db2 function question    forum.hibernate.org

i use hql ' from t1 where locate('s',(color) )>0 ' this works ok. but when use 'from t1 where locate('s',(select color from Atzsoccer where id=2) )>0 ' it does not work :DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=LOCATE;FUNCTION, DRIVER=3.58.82 i think it because the second cotains subquary question is ,how can i using a subquary in hql

8. Hibernate or SAP DB Driver problem/question    forum.hibernate.org

Hi, I have the following mapping Code: ... various properties ... ...

9. only a question about hibernate and several databases    forum.hibernate.org

Hi, It is possible. The only thing you have to do is create to configure two sessions with two "hibernate.cfg.xml" files. In each 'cfg.xml' you list the mapping files to consider and these files don't need to be the same. So, you can map the same classes with different schemas in one database or in different databases... Bye, Charles





10. Question about maintaining model vs. database consistence    forum.hibernate.org

Hi all ! I'm in the process of deciding which of the OR mapping tools to use. Currently I'm deciding between Hibernate, TopLink and Apache OJB. What I need to know is if Hibernate already has functionality/3rd party tools, whatever, to automatically generate DDL files based on the changes in the model, to keep the customers database synchronized with model. Example: ...

11. database procedure/function question    forum.hibernate.org

Hopefully this is another simple question: I have a column in a pre-existing database that is storing an encrypted password. Built into the database is a procedure/function that decrypts this password for me on retrieval. This is an oracle database. The normal sql for this is: select passwordDecrypt(password) from PasswordTable; passwordDecrypt being the procedure/function and password is the column name. Is ...

12. Slightly different multi-database question    forum.hibernate.org

I know the multiple database question has been beat to death on the forums here but I do have an idea / question. We have a use-case on our Spring (1.1.5) + Hibernate (2.1.8) where we need to store the same information into multiple databases. Basically the domain mappings would be the same just the database they pointed to would need ...

13. Questions on database design    forum.hibernate.org

Dear ALL, I have studied CaveatEmptor and wants to have some changes on it. The current CaveatEmptor billing method is by storing asingle bill and issue on individual bias. In which ways I change the database schema, so that a user can receive a monthly statement rather than receive seperated transaction billing. At a specified day of each month, adjustment is ...

14. Question about org.hibernate.dialect.OracleDialect in 3.0.5    forum.hibernate.org

Hibernate version: 3.0.5 Hello, is it intended that there are no break; statementes for the cases Types.TIMESTAMP and Types.TIME, or is this a bug ??? The literal will always be "0" for TIMESTAMP and TIME if there are no breaks !! just wondering, Andreas public String getSelectClauseNullString(int sqlType) { String literal; switch(sqlType) { case Types.VARCHAR: literal = "'x'"; break; case Types.CHAR: ...

15. Question about generating database views    forum.hibernate.org

16. DB Oriented Common Question    forum.hibernate.org





17. Mappping Question Existing DB    forum.hibernate.org

Hibernate Version 3.1.3 I have a situation with existing tables. There is a single table called "business" with a primary key generated by sequence. Then I have types of businesses (8 to be exact) which use "business" tables PK, as a [PK,FK] into their types of tables. The basis is that there are 8 types of businesses we handle, but only ...

18. hibernate + DB + ldap - architecture question - please help    forum.hibernate.org

Hi all, I have a problem which I don't know how to solve efficiently. My situation: I have postgreDB and AD or openLDAP and would like to migrate current application which uses currently just JDBC / JNDI as access methods. I would like utilize hibernate in some way - and work with my data in unified transactional way. I found castor ...

19. Multiple Database Question    forum.hibernate.org

Hi Guys/Gals, I am kind of new to hibernate, and I want to ask what I feel to be a simple question. I have an application that needs to make use of 2 separate sybase database residing on the same server. I would like my persistent class Foo to be mapped to a table in database X. Foo would also have ...

20. Some questions about developing and contributing Dialect    forum.hibernate.org

Hi folks, I am developing a dialect for HiRDB (it is Hitachi's DBMS that is selling only in Japan), and in the end of the day, I would like to contribute it so that HiRDB is counted as one of the supported DBMSs. I have two questions regarding this: 1. I would like to make the dialect configurable by parameters given ...

21. DB2 Hibernate question    forum.hibernate.org

Newbie Joined: Fri Oct 17, 2008 5:08 pm Posts: 2 Hope this is something simple. When I use the following Hibernate configuration to connect to DB2, Code: COM.ibm.db2.jdbc.app.DB2Driver ...

22. Question related to as400 DB2    forum.hibernate.org

HI All, I am new to using hibernate and have a question. After any CRUD operation, I guess I was expecting hibenate to close the session, which would result in the tables also being closed out...But when I view the connection/job on the as400, the tables remain open in a *SHRRD lock (which basically just prevents the table from being move,deleted,etc..). ...