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] > 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 orac

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- > >

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 done

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 y

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()' c

RE: How to restrict external connections

YES!!! that answered my question. Thanks a lot. Regards, Néstor Boscán -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Enviado el: Monday, September 10, 2007 4:27 AM Para: Derby Discussion Asunto: Re: How to restrict external connections Néstor Boscán wrote: > Hi >

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, an

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 th

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 connecti

Re: How to restrict external connections

It is the database that will only be up in one JVM at a time. You could have multiple JVMs running Derby but accessing different databases. In other words, Derby can be up in multiple JVMs but those different JVMs can't access the same database. Of course, this discussion applies to embedded mode.

RE: How to restrict external connections

Thanks Manta for the info _ De: Mamta Satoor [mailto:[EMAIL PROTECTED] Enviado el: Tuesday, September 11, 2007 2:12 AM Para: Derby Discussion Asunto: Re: How to restrict external connections It is the database that will only be up in one JVM at a time. You could have multiple JVMs runn

RE: Derby 10.3.1.4 not working with ibatis-2.3.0.677

Larry, as I described it in a previous email our application does work with oracle-10, oracle-9, mysql-4, mysql-5 and derby 10.2.2.0 and we have this problem only with derby 10.3.1.4. I understand that we could get it running (with huge efforts) also under 10.3.1.4 but we should modify approx. 40