Re: Derby/Oracle - single SQL query?

2009-02-04 Thread Brad Berens
25-overpower.html?page=1 You could change their factory to only use the loggable PS when your logger is in debug mode or whatever. Hope this helps! Brad On Wed, Feb 4, 2009 at 1:34 PM, Stephan van Loendersloot (LIST) < step...@republika.nl> wrote: > > Kathey Marsden wrote: > >&

Re: Derby Encryption AND Replication

2009-01-07 Thread Brad
lication properties can't be mixed with bootPassword which I found was required to start the encrypted database. Am I missing something? Is there a way of getting encrypted data without bootPassword? Cheers, Brad.

Re: How to store many large files in the database?

2008-05-23 Thread Brad Berens
Not really specific to derby but I typically find it easier to store the file name as a string in the DB and use code to find the file on the file system. Dunno if that fits your requirements. Good luck. On Thu, May 22, 2008 at 9:31 PM, Christian Gruber <[EMAIL PROTECTED]> wrote: > Hi, > the ma

RE: java.security.AccessControlException doing a file write

2008-02-15 Thread Brad Moore
7;ll keep you posted. Brad > Date: Fri, 15 Feb 2008 15:00:37 -0800 > From: [EMAIL PROTECTED] > To: derby-user@db.apache.org > Subject: Re: java.security.AccessControlException doing a file write > > bradm6406 wrote: > > The problem comes when I try to zip > > the res

RE: Methods for upgrading database and application

2008-02-13 Thread Brad Moore
at allows users to connect to the database. If anyone has any better suggestions than this I am open to ideas. JMX does sound like a great solution but I don't have the time or knowledge to roll my own right now and the Derby JMX support sounds like it is not completed yet. Maybe fo

RE: Methods for upgrading database and application

2008-02-12 Thread Brad Moore
still have a record in it saying that they are currently logged in when they are not. Any other suggestions? Thanks, Brad > From: [EMAIL PROTECTED] > To: derby-user@db.apache.org > Subject: Re: Methods for upgrading database and application >

Methods for upgrading database and application

2008-02-11 Thread Brad Moore
performed? Is there anyone else that has a similar type of situation, and how did you handle it? Thanks, Brad _

RE: Determine which child table a record belongs to

2008-01-29 Thread Brad Moore
No problem. Glad to be of help. If you have a CraneType column in the master table then you could use that to determine which other table has associated data for that Crane. i.e. if CraneType = "ROUGHTERRAIN" then look in the RoughTerrainCrane table. Brad > Date: Tue, 29 Jan

RE: Determine which child table a record belongs to

2008-01-29 Thread Brad Moore
, the same thing could be done with one additional column in the Crane table. That would simplify your database design a lot. Unless I'm missing something. Brad > Date: Tue, 29 Jan 2008 09:46:09 -0800 > From: [EMAIL PROTECTED] > To: derby-user@db.apache.org > Subject: Deter

Re: Two statement in while

2007-12-17 Thread Brad Berens
Just a stab in the dark, but I think you can only have one resultset open in a connection at a time. I suggest using a connection pool and multiple connections. On Dec 17, 2007 1:45 PM, Eduardo S.E. de Castro <[EMAIL PROTECTED]> wrote: > Hello, > > I have a question about using two PreparedSta

Re: newbie question

2007-12-17 Thread Brad Berens
which the db exists. > > Raymond Kroeker > > > On Dec 17, 2007 1:42 AM, < [EMAIL PROTECTED]> wrote: > > > Brad Berens < [EMAIL PROTECTED]> writes: > > > > > I've googled for this but all I can find is create statements so I'm > > hoping

newbie question

2007-12-16 Thread Brad Berens
I've googled for this but all I can find is create statements so I'm hoping someone can just give me a quick answer. I'm trying to write some db creation scripts. Normally in MSSQL I would use an if exists from the system tables to check whether or not to run a drop before creating the table. I

Connecting to encrypted DB using ODBC

2007-11-30 Thread Brad Moore
string. But if I am trying to do the initial boot up of the database then I get the error mentioned above. Any suggestions? Thanks, Brad _ Use fowl language with Chicktionary. Click here to start playing! http://puzzles.sympatico

Updating VARCHAR with NULL

2005-11-07 Thread Brad Balmer
I was hoping that someone here may have also run into this.  My web application was running on on MySQL with no issues.  I am porting it over to now run on Derby and am running into some issues inserting NULL values into simple VARCHAR fields. I'm running iBatis 2.1.6 and when I try an update st

updateable resultsets

2005-09-15 Thread Brad Kennedy
Does Derby 10.1 support updateable resultsets? begin:vcard fn:Brad Kennedy n:Kennedy;Brad email;internet:[EMAIL PROTECTED] tel;home:(902) 673-2317 x-mozilla-html:TRUE version:2.1 end:vcard