1. join tables from different schema in jpa coderanch.comI'm not sure about its use in JPA, but it can be done in general by fully qualifying the schema.table in queries. It will only work if the user has access to all schemas. It's not a good idea though, and the only time I have needed to do it, we found it easier to import the table temporarily, run the ... |
2. Mutliple schema , same database, same table strcture problem forum.hibernate.orgHi, I am implmenting one of the use case with spring and hibernate, I am having problem with mulitple schema of db2. Let me first give some details: Database: DB2 Database name: ABC Schemas: Under database ABC- I have four schemas IL,TX,NJ and CA (for each state different schema) Under every schema I have tables like P,Q,R (same table definition under ... |
3. Copy table A to table B in schema S and Database D ? forum.hibernate.org |
4. How to get All Database schemas and Tables in Hibernate forum.hibernate.org |
5. schemaexport doesn't create tables forum.hibernate.orgHi, I'm a newbie. My schemaexport ant task seems to fail, although no error is reported. The ant task is: |
6. Same table different schemas forum.hibernate.org |
7. SchemaExport create a table twice in a N:N bidirection forum.hibernate.orgUser.hbm.xml: ... |
8. how does hibernate support tables in different schemas forum.hibernate.orgHow does hibernate support table mappings in different schema in general? One way to support it I can think of is to add schema name in the table attribute of the mapping file (.hbm.xml). I haven't tried it so don't know if it will work. Is there any other way to configure it? Thanks, --Jiunjiun [b]Hibernate version:[/b] [b]Mapping documents:[/b] [b]Code between ... |
9. Problem in accessing table data under non-default schema forum.hibernate.orgHibernate version: 3.0.5 Mapping documents: Code: |
10. How to exclude tables from SchemaExport? forum.hibernate.org |
11. Table generated in wrong schema forum.hibernate.org |
12. Table with schema but using "hibernate.default_schema&q forum.hibernate.orgWhile I haven't used Hibernate w/ Oracle, you should be able omit the "hibernate.default_schema" property and then specify the default schema on the JDBC connection. Hibernate will then generate queries of the form "select * from table1" (no schema). Then for your special case table in the other schema, add the "schema=" attribute to the mapping. That will then generate a ... |
13. @Table schema forum.hibernate.orgI have two different database in Sql Server: the first one is a general user / permissions dataBase named userDataBase and the second one is my Application DataBase named aplDataBase I'm using jtds 1.2 with hibernate 3.2.1 and in my persistence.xml I have my url : |
14. Same Domain for same table present in two schema's forum.hibernate.orgI have two schema's in my database. Lets say S1 & S2 S1 is the current production schema. S2 is reporting schema and all old data from S1 is archieved to S2. In the database I have now S1.DOMAIN_OBJECT with current production data and S2.DOMAIN_OBJECT with old data archieved from prod table Requirement: In my portal I have to display both ... |
15. I cant create a table using the hibernate SchemaExport forum.hibernate.orgNewbie Joined: Wed Dec 12, 2007 1:58 pm Posts: 5 Hi all, I try to create a table using the SchemaExport, but i cant. When i run my main code, there is no errors on output console. Anyone can help me? My main code: Code: package br.org.xxxxxxxxxx.hibernate; import org.hibernate.cfg.AnnotationConfiguration; import org.hibernate.cfg.Configuration; import org.hibernate.tool.hbm2ddl.SchemaExport; public class CreateTable { public ... |
16. Data from tables in two different Schemas forum.hibernate.orghi! I am working on migration of BEA Portal to JBoss. I am using Hibernate and the IDE JBoss Developer Studio. In Oracle database I have 2 different schemas I want to fetch data from different tables from these two schemas. Schema 1 : table name ABC Schema 2: table name XYZ Can someone help me in writing an HQL query ... |
17. can I change @table & @schema at runtime? forum.hibernate.orgHi All, I'm using JPA to persist data to a Postgres database. Being a web application I want that for each user which I register (is a private application) a separate schema is created in the database. The EJB layer was designed for a specific schema so is it possible to choose which schema to be used by EJB layer at ... |
18. Add table at runtime to existing db schema forum.hibernate.orgHi, Im a relative beginner with hibernate but Im working on an application that uses hibernate3 annotations. Currently we have a need to add a table to the existing database schema at runtime. My understanding is that hibernate builds up a collection of all the annotated classes as part of the AnnotationConfiguration therefore is it even possible to add classes to ... |
19. Copying data from one table to another with same schema forum.hibernate.orgNewbie Joined: Wed Sep 16, 2009 4:05 pm Posts: 3 Hello, I am working on a web application bases on Spring MVC and uses Hibernate 3.2.6.ga to persist the data in Postgres database. I am trying to copy the data from one table to another with same schema where I have shared the same set of java beans between two sets ... |
20. Add table at runtime to existing db schema forum.hibernate.orgat runtime i create a table in the Database, i generate a java Class corresponding on business object to a new table added , (annotation mapping is described into the Java Class ) and i compile this class; and then i want to use this BO so i got as error class not mapped. |