finding the correct DataNode

2006-04-06 Thread Tore Halset
Hello! For any given Persistent object, is it possible to find the DataNode used? How? PS: Looking forward to try out B1! - Tore.

Re: java.sql.SQLException: No rows for 'payment_items'

2006-05-02 Thread Tore Halset
On May 2, 2006, at 19:06, Mike Kienenberger wrote: On 4/29/06, Philip Copeland [EMAIL PROTECTED] wrote: Just tracked this down - its very subtle - and I think qualifies as a bug in Cayenne. The problem is that the select for the AutoPKSupport is not using A fully qualified table name

Re: orExp resulting in *fewer* results

2006-05-30 Thread Tore Halset
On May 30, 2006, at 10:25, Øyvind Harboe wrote: If I manually modify the generated query from the orExp() case to use a LEFT OUTER JOIN instead of INNER JOIN, I get the expected result. AFAIK Cayenne does not support outer join yet. Google got me to this one:

Re: Deploying N application with N x 2 databases

2006-06-13 Thread Tore Halset
On Tue, 13 Jun 2006, [UTF-8] Borut Bol?ina wrote: What is the best (most elegant) solution to deploy standalone application on several servers each using two databases. I don't want to manually correct DomainMap (and DomainNode.driver) on each server to point to correct database. Are you

Re: raw dataport

2006-06-14 Thread Tore Halset
On Jun 14, 2006, at 14:15, Bryan Lewis wrote: I would've thought that the commit-based-on-number-of-bytes would've been a sufficient fix. Was it necessary to use jdbc? I will do some more testing with and without jdbc. Maybe that was how you got the byte count. Should be possible with

Re: Generating primary key locally without extra tables

2006-06-21 Thread Tore Halset
On Jun 21, 2006, at 15:16, Øyvind Harboe wrote: If I can have an MSAccess Oracle MS SQL adapter that supports server generated keys, then that will also solve my problems. So, after your MSAccess-work, it does support generated keys. MS SQL Server adapter works with generated keys if you

Re: Database replication and caching

2006-07-31 Thread Tore Halset
Hello. On Jul 31, 2006, at 17:52, Borut Bolčina wrote: I need an advice on using Cayenne in an environment where two PostgeSQL databases are configured to replicate from each other for failover capability. Are you using Sequoia[1] or slony[2] or creating your own solution? I am thinking

Re: Problem with DB2 UDB

2006-08-01 Thread Tore Halset
Hello. Looks like you cayenne does not get access to the database as all at the jdbc-level. Are your connection parameters, username and password correct? Do you have access to the database? - Tore. On Aug 1, 2006, at 10:49, Nikolai Raitsev wrote: Hello all, I have a problem running

Re: MS SQL Server Unicode Support

2006-09-19 Thread Tore Halset
Hello. We are using MS SQL Server with cayenne. nvarchar works with the old (have not tried latest as we moved to jtds) ms jdbc driver and jtds without problems. Perhaps the prepared statement handles it automatically as cayenne creates prepared statements? - Tore. On Sep 19, 2006, at

Re: MS SQL Server Unicode Support

2006-09-20 Thread Tore Halset
On Sep 20, 2006, at 3:24, Dov Rosenberg wrote: This article is a posting I made regarding our issues with EOF: http://lists.apple.com/archives/Webobjects-dev/2006/Jul/msg00743.html I did a quick test here in our live qa-system running cayenne-1.2, tapestry-3.0.1, jtds-1.1, java-5 and MS SQL

[OT] sync large db over slow network

2006-10-02 Thread Tore Halset
Hello. We have a large database for a cayenne server application. The database engine is currently MS SQL Server, but we will perhaps switch over to PostgreSQL at some point in time. For disaster recovery we want to have a mirrored system somewhere else in the world. It is ok if the

Re: [OT] sync large db over slow network

2006-10-03 Thread Tore Halset
this would work for you? http://gborg.postgresql.org/project/slony1/projdisplay.php /dev/mrg PS. I have no hands-on experience with it. I have just heard of it many times. On 10/2/06, Tore Halset [EMAIL PROTECTED] wrote: Hello. We have a large database for a cayenne server application

Re: Problems with Derby, database generated primary keys and dataport

2006-10-04 Thread Tore Halset
On Oct 4, 2006, at 01:38, Øyvind Harboe wrote: Has anyone tried to use Derby dataport for a table that has a database generated primary key in the destination? AFAICT, the primary key is not copied in this case, but rather the database generated primary key is kept. I guess dataport does

context - in thread or session?

2006-10-12 Thread Tore Halset
Hello. Sorry for bringing up this old issue.. I have read this thread and talked to Øyvind Harboe about it. http://mail-archives.apache.org/mod_mbox/incubator-cayenne-user/ 200609.mbox/% [EMAIL PROTECTED] and Mike Kienenbergers solution.

Re: context - in thread or session?

2006-10-14 Thread Tore Halset
for certain applications and may not work for certain other applications. Andrus On Oct 12, 2006, at 3:31 AM, Tore Halset wrote: Hello. Sorry for bringing up this old issue.. I have read this thread and talked to Øyvind Harboe about it. http://mail-archives.apache.org/mod_mbox/incubator

Re: PK as custom Attributed: Always NULL

2006-10-16 Thread Tore Halset
On Oct 16, 2006, at 19:53, Andrea Borgogelli Avveduti wrote: I have upgraded my project, PaghePro (www.iubar.it), the biggest one in italy which use Cayenne to 2.01 version. I have a problem. Sometime I use to map a PK as custom attribute in the Objentity Editor. Now when I try to read them

Re: Table aliases

2006-10-17 Thread Tore Halset
On Oct 17, 2006, at 14:55, Tomi NA wrote: 2006/10/17, Tore Halset [EMAIL PROTECTED]: Hello. I think this can be solved by wrapping the column and table names in []. Take a look at the following issue. http://issues.apache.org/cayenne/browse/CAY-289 Well, it seems it's zero-priority

Re: Cayenne not taking account of PKs created by external SQL script

2006-10-19 Thread Tore Halset
On Oct 19, 2006, at 11:17, Rashid Khan wrote: Is there any way I can make cayenne aware of the records that have been created manually? You can update AUTO_PK_SUPPORT or pk sequence created by cayenne. You should update this before inserting to grap a block of primary key values just as

Re: Get Connection

2006-10-20 Thread Tore Halset
On Oct 20, 2006, at 3:35, Malcolm Edgar wrote: I am using a Jasper reports in a Cayenne project, and I want to obtain a Connection from Cayenne for Japser to use. I am doing something like this: DataDomain domain = Configuration.getSharedConfiguration().getDomain(); DataNode node =

Re: Get Connection

2006-10-20 Thread Tore Halset
On Oct 20, 2006, at 13:24, Tore Halset wrote: On Oct 20, 2006, at 3:35, Malcolm Edgar wrote: I am using a Jasper reports in a Cayenne project, and I want to obtain a Connection from Cayenne for Japser to use. I am doing something like this: DataDomain domain

Re: Get Connection

2006-10-21 Thread Tore Halset
On Oct 21, 2006, at 01:02, Aristedes Maniatis wrote: The end result is that all the customisable reports and images can be managed in the database and edited by the user whenever they want. Pretty simple, but it works well. Interesting. How are your users editing their reports? Using

Re: Docs and some questions

2006-11-12 Thread Tore Halset
On Nov 12, 2006, at 02:25, Aristedes Maniatis wrote: Anyhow, although we haven't done this yet, we would be very interested in collaborating on any work to tie jgroups into Cayenne. Since we use Jetty already, and there is some integration between jgroups and Jetty mentioned, perhaps this

Re: Problems with prepared statements

2006-11-29 Thread Tore Halset
Hello. Perhaps the easiest way is to create a proxy jdbc driver that unprepares all statements? As you know, prepared statements are realy a good thing :) Regards, - Tore. On Nov 28, 2006, at 20:41 , Øyvind Harboe wrote: Is there a way I can disable prepared statements or somehow use

Re: Problems with prepared statements

2006-11-29 Thread Tore Halset
On Nov 29, 2006, at 12:42 , Øyvind Harboe wrote: So the MS Access adapter should contain a proxy jdbc driver that unprepares statements? This is not related to cayenne at all, so it will be independant of the adapter. I've never written a proxy jdbc driver nor have I unprepared

Re: Delete rules

2006-12-03 Thread Tore Halset
Hello. I think Nullify is a better default than No Action as it matches what I want to do in most cases. I sometimes use Cascade, but it is not a good default value :) - Tore. On Dec 3, 2006, at 20:47, Andrus Adamchik wrote: Just like with the outer joins discussion that you initiated

Re: Problem: Ordering.orderList and date-values

2006-12-04 Thread Tore Halset
On Dec 4, 2006, at 15:25 , Juergen Saar wrote: BTW: I'm preparing for Cayenne 2.0.1, but converting all packagenames from org.objectstyle to org.apache is not really fun ... any hints how this can be done without too many keyboard-action? (There are about 2000 Classes in our cayenne

Re: how does cayenne handle java.util.date values ?

2006-12-05 Thread Tore Halset
On Dec 5, 2006, at 14:26 , Lothar Krenzien wrote: I've provided a simple demo class to show what I mean. I used Java 5, cayenne 2.1 and jtds with MS SQL Server 2000. Looks like the attachment are striped by the mail-list software. Could you copy/paste the code into the mail instead of

types.xml, psql and oid/bytea

2006-12-07 Thread Tore Halset
Hello. I want to try out Slony-I replication solution for PostgreSQL. It does not handle oid-blobs, so I must use bytea instead. This is okay as my blobs are not that big. PostgreSQL has a blob problem.. If the blob in the database are bytea, you must use setBytes/getBytes. If it is oid

Re: many to many relation

2006-12-11 Thread Tore Halset
Hello. Read the documentation on flattened many-to-many relationship. http://cwiki.apache.org/CAYDOC/cayennemodeler-flattened- relationships.html http://www.google.com/search?q=cayenne+flattened+relationship+site% 3Acwiki.apache.org - Tore. On Dec 10, 2006, at 18:59 , marco turchi wrote:

Re: many to many relation

2006-12-11 Thread Tore Halset
Hello. On Dec 11, 2006, at 13:01 , marco turchi wrote: I've read the documentation, I created a flattened many-to-many relationship, but any record has been inserted inside the connection table. I have the following tables and relationships: Your mapping is wrong. I have fixed it and

Re: many to many relation

2006-12-11 Thread Tore Halset
On Dec 11, 2006, at 17:36, marco turchi wrote: the problem is that using the moduler I'm not able to create an obj-relationship without create a new db-relationship. It means that I obtain more relationships than the relationships you shown me in the example (I obtain what I wrote in the

does commitChanges lock all other queries?

2006-12-12 Thread Tore Halset
Hello. One of our applications blocked for some time today. It worked out fine after a couple of minutes. It is running cayenne-1.2. We will upgrade to 2.0.1 in the start of january. The attached stacktraces are extracted using JBoss jmx-console. Thread http-0.0.0.0-80-6 are performing a

Re: Represesntation of database NULL as something else than Java null pointer

2006-12-14 Thread Tore Halset
On Dec 14, 2006, at 9:11 , Øyvind Harboe wrote: Could I implement my own NeverNullString datatype where I'm thinking that .toString() returns the either what Cayenne java.lang.String returns today or e.g. for the case where it represents a database null? Or perhaps map java.lang.CharSequence

Re: Represesntation of database NULL as something else than Java null pointer

2006-12-14 Thread Tore Halset
On Dec 14, 2006, at 14:09 , Øyvind Harboe wrote: Q++: Is it a good idea to use ExtendedType to represent database null as something else than Java null pointer? I do not think it is a good idea in my project as I try to use not null as much as possible. The places where I allow null, there

Re: DB2 reengineering error Cp277

2007-01-12 Thread Tore Halset
Den Jan 12, 2007 kl. 14:14 skrev [EMAIL PROTECTED]: When I try to reeng IBM DB2 tables in CayenneModeler I get a pop-up error Unsupported encoding Cp277 for result set column just after I press Continue in Reengineer DB Schema: Connect to Database window. Jdbc config is ok as Test.. in Edit