Empire DB Users Recent threads

Threads	Replies	First post	Last post
re: Add one table from a different schema By: Rainer Döbele Correct. Finding good names for classes, methods and properties to me is one of the most challenging tasks in software engineering. On "Open" the driver may perform tasks on the database, but it's really up to the driver. One thing I regret is…	1	Jan 13 2012 07:02	Jan 13 2012 07:17
re: Add one table from a different schema By: Rainer Döbele Hello Alain, I have investigated you problem and I very much assume, that you missed to open the second database. You need to call db.open(...) for each database you are using since this will attach the driver. However I must admit, that it is a…	1	Jan 13 2012 05:31	Jan 13 2012 06:37
Add one table from a different schema By: Alain Becam Hello, I want to do something like that: SELECT t10.name FROM schema2.person t10 INNER JOIN personInGroup t11 ON t11.ID = t10.group_ID WHERE t11.ID LIKE 'C12' Where the person table in in another schema where I have the "SELECT" rights.…	2	Jan 11 2012 11:11	Jan 13 2012 04:20
Bean handling in 1:n relationships or joins By: Jens Breitenstein Hi all! I have to admit I am pretty new to empire-db but feel quite confortable with it... Finally I got the Bean mapping working for single tables and I now get stuck in how to handle joins correctly... Assume a simple relationship between a…	4	Dec 6 2011 11:07	Dec 7 2011 23:57
retrieve id of auto-inc field after insert By: Jens Breitenstein hi all! I need to retrieve the auto-inc key after an insert. I found a class called DBDatabaseDriver.DBSetGenKeys which seems to be perfect, but unfortunately this is only accessible via DBDatabase. As the comment states it's not recommended to…	1	Dec 7 2011 08:19	Dec 7 2011 11:35
re: Inserting Chinese character record to DB By: Rainer Döbele Hi Francis, I agree but we need a test case for this. It may as well depend on the JDBC-Driver used - in fact I don't know. Also my Chinese is a little rusted ;-) Regards Rainer > from: Francis De Brabandere [mailto:fran### @gmail.com] >…	10	Nov 7 2011 08:26	Nov 9 2011 19:35
re: Inserting Chinese character record to DB By: Rainer Döbele This is a multi-part message in MIME format. Hi Ben, I don't know for sure but it may be a good idea to tell Empire-db to use prepared statements. Simply write: db.setPreparedStatementsEnabled(true); in your initialization code. Please…	2	Nov 7 2011 02:19	Nov 7 2011 04:26
Re: Inserting Chinese character record to DB By: Ben Ng Hi Empire-DB team, I am trying to insert a record with Chinese character from my JSP page. The encoding is set to UTF-8 already and I am trying to insert the record by the code below where "remarks" is a string contain Chinese characters. …	0	Nov 6 2011 19:34	Nov 6 2011 19:34
Apache Empire-db 2.2.0-incubating released By: Francis De Brabandere The Apache Empire-db team is pleased to announce the release of Apache Empire-db version 2.2.0-incubating. Apache Empire-db is a lightweight data access and persistence component for relational databases based on JDBC.…	0	Nov 2 2011 17:30	Nov 2 2011 17:30
Unexpected behaviour while using notIn By: Alain Becam Hello all, I have been trying to write a simple query with a notIn: DBCommand cmdFindPubForPerson = dbPerson.createCommand(); cmdFindPubForPerson.select(publication4Group.C_PUBLICATION_ID); …	2	Sep 29 2011 06:38	Sep 30 2011 02:41
re: UNION and LIMIT(SKIP) support By: Rainer Döbele Hi exxos, yes, you are right- this issue got lost somewhere on the way. As far as I remember I gave you a solution how to solve this in your code - but of course a general solution is preferable. I have now created an issue in Jira (EMPIREDB-115)…	3	Sep 13 2011 04:48	Sep 22 2011 14:12
UNION and LIMIT(SKIP) support By: exxos Hi empire-db team, A year ago, I posted a message about several issues I experienced with UNION. [sta1] UNION [sta2] UNION [sta3] UNION ... 1st issue - DBCommandExpr does not support LIMIT (and SKIP) 2nd issue - Some parentheses are missing in…	0	Sep 12 2011 16:30	Sep 12 2011 16:30
Relationships By: Matt DeHoust Hello, I see that the empire-db model supports relationships (for example DBDatabase.getRelations()), but it doesn't seem that the codegen component sets them up. Am I missing something? (I am using MySQL if that matters.) If not, are there plans…	4	Jun 28 2011 12:38	Jul 2 2011 10:03
How to tell that a rows is UNIQUE ? By: exxos Hello, At the colomn declartion in DBTable, how to tell that a colomn is unique ? (I'm not talking about primaries keys) Regards, exxos.	3	May 18 2011 11:47	May 18 2011 15:37
Re: How to tell that a rows is UNIQUE ? By: exxos Yes it is!... Thank you! The javadoc of the API is sometime hard to browse... Regards, exxos. On Wed, May 18, 2011 at 7:11 PM, <daniel.w### @***> wrote: > Hi, > > in class DBTable there is a method with signature: > >…	0	May 18 2011 14:26	May 18 2011 14:26
Problems in docs for running example-basic By: Tim Colson I managed to get the basic example to run in both Eclipse and Intellij IDEA after some effort troubleshooting. Here are observations on the docs/tutorial info that were confusing or incorrect. I pulled down the distro and expanded into /appdev,…	1	Apr 13 2011 17:21	Apr 17 2011 16:50
RE: DataType for email? By: Tim Colson Thanks again for the reply, Rainer - some more questions/discussion on DataType. Recap: I asked about DataType and if it could be sub-classed and then autowired to a DB column. Rainer replied, saying column object can hold other meta-data, and…	0	Apr 12 2011 18:42	Apr 12 2011 18:42
User/Dev lists - activity and search By: Tim Colson I'm new here. ;-) I saw the discussion about building the community for Empire DB, but browsing the two lists is arduous. Is there a searchable archive and or a digest/summary of what's been happening over the years for newbies to get up to…	2	Apr 11 2011 11:39	Apr 12 2011 18:33
DataType for email? By: Tim Colson I recently found the "What's wrong with..." article while searching for "Hibernate and JPA". I was trying to better understand JPA in an Apache Click example app in Freddy Daoud's book (http://www.fdaoud.com/clickbook/), but like the idea of the…	0	Apr 11 2011 11:25	Apr 11 2011 11:25
LIMIT implemented since 2.0.7 but what about SKIP ? By: exxos Hi, I noticed that since the version 2.0.7, you added the feature "limit" to allow controling the number of row that a query can return. But, now I would like to know about the feature "skip" to skip a number of row? This is a feature offered…	1	Mar 28 2011 09:41	Mar 28 2011 09:57