XAResource setTransactionTimeout()

2006-11-28 Thread Prashant Bhagat
Is the setTransactionTimeout() method of XAResource supported by the class org.apache.derby.client.net.NetXAResource? I wrote a sample code to set the timeout to 60 seconds, but the getTransactionTimeout() returns 0. Is there any other way to specify a transaction timeout? Earlier I this as

Re: SQL command to view active locks

2006-11-28 Thread Bryan Pendleton
I tried doing what you said, but the table does not seem to exist. I am running 10.1.1.0 via the NetworkServerControl API. In version 10.1, you have to use the old name for the table. Try: SELECT * FROM NEW org.apache.derby.diag.LockTable() as LOCK_TABLE See DERBY-571 for more info: http://i

Re: SQL command to view active locks

2006-11-28 Thread Xanana Gusmao
Oystein, I tried doing what you said, but the table does not seem to exist. I am running 10.1.1.0 via the NetworkServerControl API. ij> select * from SYSCS_DIAG.LOCK_TABLE; ERROR 42X05: Table 'SYSCS_DIAG.LOCK_TABLE' does not exist. Do I need to configure anything ? Thanks. Xanana

Re: Help! Can't connect to DBase

2006-11-28 Thread David Van Couvering
- Can you send the stack trace for the NullPointerException? I'd be curious to see if it's happening inside Derby or if it's happening in your code because ds.getConnection() returned null - If you're running Derby 10.2, you can go to the lib directory and say 'java -jar derbyrun.jar sysinfo'

Re: Derby.jar file

2006-11-28 Thread David Van Couvering
Hi, Marl. I signed my own jar file using the JDK jarsigner tool. Part of me thinks it would be nice if Apache had an officially signed version of the jar file, but part of me suspects there's something off about this. Anyone else have any opinions on this? If it were the fact that your jar

Re: Derby data types

2006-11-28 Thread David Van Couvering
Beyond just making life easier and developers more productive, it's also a good thing because it makes your app more portable across databases. There are other areas where you can still get locked in, but anything that can help you avoid vendor lockin I think is a good thing. David Daniel Nol

Re: how to migrate mysql to derby

2006-11-28 Thread Jean T. Anderson
Feng Jiang wrote: > Hi, > > I want to use derby to write some testcases in memory. now, i have a mysql > database, and dumped the schema into a script file. Here i want to execute > this script file and create a identitcal database schema with that mysql > database. One option might be to use Ddl

Re: Using Derby as a binary store

2006-11-28 Thread Kasper Nielsen
Kasper Nielsen wrote: Hi, I'm evaluating Derby for a project of mine. I really would like to avoid using SQL and just use Derby as a binary store. Is this possible? My data consists of key -> value pairs where the keys are uniformly distributed 160 bit numbers and the values are byte arrays.

Re: SQL for inserting BLOB data?

2006-11-28 Thread Daniel Noll
Ray Kiddy wrote: Looking at the reference, it seems that one cannot assign any other data type to BLOB. There seems to be no built-in function for, for example, turning a string that represents a uuencoded binary into binary data. Convert the String into byte[] using getBytes(String), and then

Re: Derby data types

2006-11-28 Thread Daniel Noll
Bill Slack wrote: With one of these babies, you won't need to do SQL ever again... Is this a good thing? Do you even have to ask? :-) Any removal of a second language is a good thing. Applications should be able to be developed in a single language (and Java's not even particularly clean

Re: Using Derby as a binary store

2006-11-28 Thread Daniel Noll
Paul J DeCoursey wrote: What is this binary data you are storing? Have you looked at Jackrabbit? Have you thought about just using java.nio and perhaps Lucene fro indexing? Definitely consider the above questions as well, look at the bigger picture. Actually we were initially using plain fil

Derby.jar file

2006-11-28 Thread Marl Atkins
Hi: David Van Couvering gave me an idea that maybe my jar file isn't all that it should be. Can I get an officially signed Derby.jar file? What file are you using for Applets? Can I get a copy of it? Marl K. Atkins Microsoft Certified Professional SoftLink Systems, Inc. (407) 388-1886

RE: Help! Can't connect to DBase

2006-11-28 Thread Marl Atkins
Yea, it's tough for me to pin down. The actual error I'm getting is nullPointerException. I get it when I try to create the connection object: --- public java.sql.Connection openDBase() throws Exception { ds = new EmbeddedDataSource(); ds.setDatabaseName("CTMCDB

SQL for inserting BLOB data?

2006-11-28 Thread Ray Kiddy
If one is writing SQL to create tables and insert data and one has a BLOB column, how can one do this? Looking at the reference, it seems that one cannot assign any other data type to BLOB. There seems to be no built-in function for, for example, turning a string that represents a uuencod

Re: Derby data types

2006-11-28 Thread Bill Slack
- Original Message - From: "David Van Couvering" <[EMAIL PROTECTED]> To: "Derby Discussion" Sent: Monday, November 27, 2006 4:06 PM Subject: Re: Derby data types A newbie question in response to: ... Implementations of the Java standard JSR 220 (my recommendation, this appears to be

Re: Help! Can't connect to DBase

2006-11-28 Thread David Van Couvering
It would be very helpful to provide further information around "can't connect." What's the error message and the stack trace? Also, please run sysinfo and provide that information, knowing which version is key. I have been running Derby in an applet for a sample app I am using, and it's neve

Help! Can't connect to DBase

2006-11-28 Thread Marl Atkins
Hi: I've got an Applet based application that I've been working on for about 3 months. It creates a Derby database from a MySql database. It's been working fine. Today, for no apparent reason, the Applet can't connect to the Derby database. If I use an application with a main proc. in the NetBean

Re: Using Derby as a binary store

2006-11-28 Thread Paul J DeCoursey
Mike wrote: -Original Message- From: Paul J DeCoursey [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 28, 2006 7:45 AM To: Derby Discussion Subject: Re: Using Derby as a binary store [EMAIL PROTECTED] wrote: [mjs] The simplest path would be to write his own from scratch. The q

RE: Using Derby as a binary store

2006-11-28 Thread derby
Hey! Sorry about that. For some reason my Thinkpad's outlook got a bit garbled on thinking that my outbound SMTP server required an SSL. (It doesn't. It will only accept connections from within my network.) So This got sent as I unclogged it. Please ignore cause this thread is old -Mike >

RE: Using Derby as a binary store

2006-11-28 Thread Mike
> -Original Message- > From: Paul J DeCoursey [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 28, 2006 7:45 AM > To: Derby Discussion > Subject: Re: Using Derby as a binary store > > [EMAIL PROTECTED] wrote: > > [mjs] > > The simplest path would be to write his own from scratch. > >

RE: "generated by default" question

2006-11-28 Thread Mike
Craig, I haven't looked at the code which generates an identity value. There are a couple of ways Derby could be doing this and it would be best to clean up that code. The simplest solution would be to write an exception handler that will auto increment the counter at each error and try to insert

Re: Using Derby as a binary store

2006-11-28 Thread Paul J DeCoursey
[EMAIL PROTECTED] wrote: [mjs] The simplest path would be to write his own from scratch. The questions that haven't been asked: 1) Are there other pieces of the application that may benefit from being in a relational database. 2) What is the use case of the application? And what are the future e

RE: Using Derby as a binary store

2006-11-28 Thread derby
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 28, 2006 3:58 AM > To: Derby Discussion > Subject: Re: Using Derby as a binary store > > Kasper Nielsen <[EMAIL PROTECTED]> writes: > > > David Van Couvering wrote: > >> To be honest, this

Re: Using Derby as a binary store

2006-11-28 Thread Dyre . Tjeldvoll
Kasper Nielsen <[EMAIL PROTECTED]> writes: > David Van Couvering wrote: >> To be honest, this looks more like a job for BDB than for Derby. I >> would love to see the Derby store API made public at some point, but >> currently it's not public and I suspect it may be difficult to work >> with. Ar