Derby and string storage details

Hi all. If I have 1,000 of the same string in a table for some reason, is the string stored 1,000 times, or is it only stored once? Daniel

Re: Derby and string storage details

Daniel Noll [EMAIL PROTECTED] writes: Hi all. If I have 1,000 of the same string in a table for some reason, is the string stored 1,000 times, or is it only stored once? Hi Daniel, It's stored 1000 times. If you need that space optimization, I think you'll have to code it yourself with a

Re: jdbc metadata getProcedures does not return newly created proc/funcs

Rick Hillegas [EMAIL PROTECTED] writes: Hi Mike, Try passing in null as the catalog and schema arguments. The javadoc for DatabaseMetaData.getProcedures() is a little vague about this. That shouldn't make any difference since Derby ignores the catalog argument and replaces a null schema

Re: anybody know why the derby alway appear requesting a lock

Templexp Tan wrote: On 9/8/07, *Kristian Waagan* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Templexp Tan skrev: it is under the c/s mode. why the program running a very frenquent inserting operation , it comes requesting a lock and the speed compare to oracle is

Re: Derby 10.3.1.4 not working with ibatis-2.3.0.677

That's the best I can do for free - I can do the work for you if you want, but I'll have to bill you for that. ;-) Larry On 9/8/07, Zsolt Koppany [EMAIL PROTECTED] wrote: Larry, thank you but it means form me approx. 400 statements. Zsolt Zsolt -Original Message- From: [EMAIL

How to restrict external connections

Hi Is there a way to restrict external connection to a Derby Database?. I only want the JVM to be able to connect to the Derby database and no other external processes. Regards, Néstor Boscán

Re: How to restrict external connections

Néstor Boscán wrote: Hi Is there a way to restrict external connection to a Derby Database?. I only want the JVM to be able to connect to the Derby database and no other external processes. Hello, Unless I have misunderstood, sounds like you simply want to use Derby embedded. This is

Re: REMARKS column

Hi Geoff, You're welcome to create a JIRA issue, describing this new feature. Instructions on how to create a JIRA can be found in the Provide Feedback section at the top of the following webpage: http://db.apache.org/derby/derby_comm.html At a minimum, other people may be able to help you

Re: How to restrict external connections

Is there a way to restrict external connection to a Derby Database?. I only want the JVM to be able to connect to the Derby database and no other external processes. Use the embedded configuration, then, not the client/server configuration. In the embedded environment, only the JVM which runs

Re: jdbc metadata getProcedures does not return newly created proc/funcs

Thanks to both Rick Hillegas and Knut Anders Hatlen - I was passing the empty string instead of NULL as the catalog parameter - makes a difference! w.r.t. functions vs. parameters - sigh, another Oracle-vs-the-world issues: Oracle returns StoredFunction info via the JDBC 4.0 'getProcedures()'

Re: Derby 10.3.1.4 not working with ibatis-2.3.0.677

Actually, you can tell iBATIS the type (see page 29 in the user guide) - in an insert or update, user the following notation: #property:JDBCTYPE# You can get a list of the valid JDBC types here: http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Types.html So if your property is named address,

anybody know why the derby alway appear requesting a lock

it is under the c/s mode. why the program running a very frenquent inserting operation , it comes requesting a lock the version: 10.3.1.4

Re: jdbc metadata getProcedures does not return newly created proc/funcs

Mike Norman wrote: latest Derby: Apache Derby 10.3.1.4 - (561794) Apache Derby Network Client JDBC Driver 10.1.2.1 I created 2 very simple stored proc/funcs: [...] No exceptions are thrown but the list is empty - an empty result set was returned. Maybe stating the obvious: but did

RE: How to restrict external connections

Hi Kristian Thanks for the answer. So this means that if I open the database using the EmbeddedDriver driver no one can access the database from an outside connection?. Includiing tools like ij? Regards, Néstor Boscán -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

Re: How to restrict external connections

Néstor, If a tool like ij is started in a new JVM, then it will not be able to connect to an embedded database which has been started by a different JVM. HTH, Mamta On 9/10/07, Néstor Boscán [EMAIL PROTECTED] wrote: Hi Kristian Thanks for the answer. So this means that if I open the

RE: How to restrict external connections

Hi Mamta thanks for the answer. So basically Derby will only be up in one JVM at a time. Correct? Regards, Néstor Boscán _ De: Mamta Satoor [mailto:[EMAIL PROTECTED] Enviado el: Tuesday, September 11, 2007 1:13 AM Para: Derby Discussion Asunto: Re: How to restrict external