Hi Oliver,

Here is an old email thread on this topic: 
http://old.nabble.com/SQL-functions%2C-procedures-and-PSM---a-possible-approach-to1047689.html#a1047689

I think that the short answer to your question is that no-one has 
volunteered to implement the standard SQL procedural language. There is 
very little pressure to start this very big project because the 
alternative Derby approach (writing a Java static method) seems to 
satisfy our users.

Personally, I believe that Java is a better procedural language than SQL 
for several reasons: Java is more expressive, more portable, easier to 
debug, and backed by a larger ecosystem of re-usable code.

However, you are welcome to build SQL/PSM support into Derby. I believe 
that the community would welcome such a contribution.

Hope this helps,
-Rick



Oliver Böhme wrote:
> Hello,
>
> why can't I create "normal" SQL stored procedures for a Derby DB?
> I thought building a string like "create procedure name as select * from ..." and pass
it to Statement.execute (or .executeUpdate) would work but it doesn't.
> Instead of this I can only declare those cryptic java stored procedures...
>
> Am I missing some point or what is the reason for that?
>
> Regards
> ___________________________________________________________
> Preisknaller: WEB.DE DSL Flatrate für nur 16,99 Euro/mtl.! 
> http://produkte.web.de/go/02/
>
>   

malesch wrote:
> I checked again, altough I was quite sure, I only connect as the user
> "app" (I have no other users).
> In every case "values CURRENT_USER" always return "APP" and the second
> query always the
> schema name "APP" with the corresponding "table name".
>
> I realized that I previously wrote nonsense because not tables are
> missing (what would lead to
> a user problem) but rows in a table...
>   

Did you shut down the database properly before jarring it up?
I'm not sure what happens with a JAR database if there are unprocessed 
transaction logs in the log directory, but since access is read-only a 
guess would be that the logs are simply ignored.

If the logs are there, but not processed when the db is in a jar, they 
will be processed on start-up when you unzip the JAR and connect to the 
database.

To make sure the database is in a clean state before you jar it up, shut 
it down properly: 'jdbc:derby:mydb;shutdown=true'


Regards,
-- 
Kristian

>
>
> Kathey Marsden wrote:
>   
>> malesch wrote:
>>     
>>> . I realized that
>>> in my demo with the extracted DB (on the file system) the expected
>>> tables didn't show up (like in the JAR case). Disappointed I opened the
>>> same DB with SquirellSQL and, surprise, the tables were there again.
>>> After this opening with SquirellSQL my demo programm showed again the
>>> previously missing tables.
>>>
>>>   
>>>       
>> I know this was suggested before and perhaps you checked already, but
>> it sounds a lot like you are not connecting with the same user each
>> time.  The schema for the table creation will match the user name.  A
>> couple of queries to get your bearings:
>>
>> values CURRENT_USER
>>
>> select schemaname, tablename  from sys.sysschemas s, sys.systables t
>> where NOT tablename like  'SYS%' and s.schemaid  = t.schemaid;
>>
>> If your table schema and user don't match you can either log in as the
>> matching user or select with the fully qualified name e.g.
>>
>> select * from kathey.t;
>>
>>
>>     
>
>   

I checked again, altough I was quite sure, I only connect as the user
"app" (I have no other users).
In every case "values CURRENT_USER" always return "APP" and the second
query always the
schema name "APP" with the corresponding "table name".

I realized that I previously wrote nonsense because not tables are
missing (what would lead to
a user problem) but rows in a table...



Kathey Marsden wrote:
> malesch wrote:
>> . I realized that
>> in my demo with the extracted DB (on the file system) the expected
>> tables didn't show up (like in the JAR case). Disappointed I opened the
>> same DB with SquirellSQL and, surprise, the tables were there again.
>> After this opening with SquirellSQL my demo programm showed again the
>> previously missing tables.
>>
>>   
> I know this was suggested before and perhaps you checked already, but
> it sounds a lot like you are not connecting with the same user each
> time.  The schema for the table creation will match the user name.  A
> couple of queries to get your bearings:
>
> values CURRENT_USER
>
> select schemaname, tablename  from sys.sysschemas s, sys.systables t
> where NOT tablename like  'SYS%' and s.schemaid  = t.schemaid;
>
> If your table schema and user don't match you can either log in as the
> matching user or select with the fully qualified name e.g.
>
> select * from kathey.t;
>
>

Hello,

why can't I create "normal" SQL stored procedures for a Derby DB?
I thought building a string like "create procedure name as select * from ..." and pass it
to Statement.execute (or .executeUpdate) would work but it doesn't.
Instead of this I can only declare those cryptic java stored procedures...

Am I missing some point or what is the reason for that?

Regards
___________________________________________________________
Preisknaller: WEB.DE DSL Flatrate für nur 16,99 Euro/mtl.! 
http://produkte.web.de/go/02/

malesch wrote:
> . I realized that
> in my demo with the extracted DB (on the file system) the expected
> tables didn't show up (like in the JAR case). Disappointed I opened the
> same DB with SquirellSQL and, surprise, the tables were there again.
> After this opening with SquirellSQL my demo programm showed again the
> previously missing tables.
>
>   
I know this was suggested before and perhaps you checked already, but it 
sounds a lot like you are not connecting with the same user each time.  
The schema for the table creation will match the user name.  A couple of 
queries to get your bearings:

 values CURRENT_USER

 select schemaname, tablename  from sys.sysschemas s, sys.systables t 
where NOT tablename like  'SYS%' and s.schemaid  = t.schemaid;

If your table schema and user don't match you can either log in as the 
matching user or select with the fully qualified name e.g.

 select * from kathey.t;

Hi Dag

I connect to my DB with the same user name with the default schema APP
and, what I forgot to mention last time, the DB is encrypted.

Now while creating a little program to demonstrate the effect I stumbled
over something pointing to a possible explanation :-). I realized that
in my demo with the extracted DB (on the file system) the expected
tables didn't show up (like in the JAR case). Disappointed I opened the
same DB with SquirellSQL and, surprise, the tables were there again.
After this opening with SquirellSQL my demo programm showed again the
previously missing tables.

Is there some transaction log which is not commited and what would be
the reason for this (simply not properly commiting/closing the DB?)

Greetings,
marcus


Dag H. Wanvik wrote:
> malesch <malesch@gmail.com> writes:
> 
>> I am seeing some very strange behavior with my Derby DB
>> (version 10.4.2.0 and 10.5.3.0).
>>
>> If I load my DB from a JAR file, I am missing some table
>> entries, that are existing if I extract the DB from the
>> same JAR file and load it from the file system.
>>
>> How can I understand this behavior, is there an
>> explanation for this?
> 
> That seems weird. Are you connecting with the same user name (or none)
> in the two scenarios? Occasionally we see users miss some tables
> because they end up in an unexpected schema; the default schema is the
> user name (or "APP" if not provided).
> 
> If this is not the issue, are you able to provide a repro for it?
> 
> Thanks,
> Dag

Excellent !  Any command which will do it on a DB base an not just
table by table

B-)

On Tue, Dec 1, 2009 at 8:52 PM, Bryan Pendleton
<bpendleton@amberpoint.com> wrote:
>> Is there any specific command to be run to claim the space deleted ?
>
> Not a command, but a built-in system procedure:
> http://db.apache.org/derby/docs/10.5/ref/rrefaltertablecompress.html
>
> thanks,
>
> bryan
>
>

> Is there any specific command to be run to claim the space deleted ?

Not a command, but a built-in system procedure:
http://db.apache.org/derby/docs/10.5/ref/rrefaltertablecompress.html

thanks,

bryan

I may not have read all docs, but after I run a cascading delete on
200 megs of row data and I check the folder size on disk nothing has
changed ?

Is there any specific command to be run to claim the space deleted ?

Thanx
B-)

Thanks people, you saved my life...CLASSPATH was my problem... 



Bryan Pendleton wrote:
> 
>> When I try to run WwdEmbedded.java there is an error that looks like
>> this:
>> -----------------------------------------------------------------------
>> C:\Documents and Settings\Zoran\Desktop\DERBYTUTOR>java WwdEmbedded
>> Exception in thread "main" java.lang.NoClassDefFoundError: WwdEmbedded
> 
> I suspect this is because you didn't set your CLASSPATH environment
> variable
> carefully, to include "." in the classpath. See step (1) of the
> instructions at:
> http://db.apache.org/derby/docs/dev/getstart/twwdactivity3_Setup.html
> and ensure that you have done:
> 
>    set CLASSPATH=%DERBY_HOME%\lib\derby.jar;.
> 
> thanks,
> 
> bryan
> 
> 
> 
> 
> 

-- 
View this message in context: http://old.nabble.com/Hello-tp26595406p26597029.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

malesch <malesch@gmail.com> writes:

> I am seeing some very strange behavior with my Derby DB
> (version 10.4.2.0 and 10.5.3.0).
>
> If I load my DB from a JAR file, I am missing some table
> entries, that are existing if I extract the DB from the
> same JAR file and load it from the file system.
>
> How can I understand this behavior, is there an
> explanation for this?

That seems weird. Are you connecting with the same user name (or none)
in the two scenarios? Occasionally we see users miss some tables
because they end up in an unexpected schema; the default schema is the
user name (or "APP" if not provided).

If this is not the issue, are you able to provide a repro for it?

Thanks,
Dag

This error can happen if you do not have the current directory in your 
classpath. Did you follow all the instructions in the "Setting up your 
environment" section, including "Manually setting the CLASSPATH 
environment variable"?

Kim Haase

On 12/01/09 12:51, velimzo wrote:
> I am new in Derby. 
> 
> Here is my problem:
> I am following "Getting Started With Java DB" instructions.
> Problem occures when I try to follow instructions for "Run a JDBC program
> using the embedded driver".
> I compiled successfully WwdEmbedded.java, not following instructions but
> with a command javac *.java
> When I try to run WwdEmbedded.java there is an error that looks like this:
> -----------------------------------------------------------------------
> C:\Documents and Settings\Zoran\Desktop\DERBYTUTOR>java WwdEmbedded
> Exception in thread "main" java.lang.NoClassDefFoundError: WwdEmbedded
> Caused by: java.lang.ClassNotFoundException: WwdEmbedded
>         at java.net.URLClassLoader$1.run(Unknown Source)
>         at java.security.AccessController.doPrivileged(Native Method)
>         at java.net.URLClassLoader.findClass(Unknown Source)
>         at java.lang.ClassLoader.loadClass(Unknown Source)
>         at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
>         at java.lang.ClassLoader.loadClass(Unknown Source)
>         at java.lang.ClassLoader.loadClassInternal(Unknown Source)
> Could not find the main class: WwdEmbedded.  Program will exit.
> -------------------------------------------------------------------------
> My version of Java is : Java(TM) SE Runtime Environment (build 1.6.0_17-b04)
> Version of Derby is : Derby 10.5.3.0
> Operating System : Windows XP sp3
> 
> I am thankful on every answer...

> When I try to run WwdEmbedded.java there is an error that looks like this:
> -----------------------------------------------------------------------
> C:\Documents and Settings\Zoran\Desktop\DERBYTUTOR>java WwdEmbedded
> Exception in thread "main" java.lang.NoClassDefFoundError: WwdEmbedded

I suspect this is because you didn't set your CLASSPATH environment variable
carefully, to include "." in the classpath. See step (1) of the instructions at:
http://db.apache.org/derby/docs/dev/getstart/twwdactivity3_Setup.html
and ensure that you have done:

   set CLASSPATH=%DERBY_HOME%\lib\derby.jar;.

thanks,

bryan

I am new in Derby. 

Here is my problem:
I am following "Getting Started With Java DB" instructions.
Problem occures when I try to follow instructions for "Run a JDBC program
using the embedded driver".
I compiled successfully WwdEmbedded.java, not following instructions but
with a command javac *.java
When I try to run WwdEmbedded.java there is an error that looks like this:
-----------------------------------------------------------------------
C:\Documents and Settings\Zoran\Desktop\DERBYTUTOR>java WwdEmbedded
Exception in thread "main" java.lang.NoClassDefFoundError: WwdEmbedded
Caused by: java.lang.ClassNotFoundException: WwdEmbedded
        at java.net.URLClassLoader$1.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at java.lang.ClassLoader.loadClassInternal(Unknown Source)
Could not find the main class: WwdEmbedded.  Program will exit.
-------------------------------------------------------------------------
My version of Java is : Java(TM) SE Runtime Environment (build 1.6.0_17-b04)
Version of Derby is : Derby 10.5.3.0
Operating System : Windows XP sp3

I am thankful on every answer...
-- 
View this message in context: http://old.nabble.com/Hello-tp26595406p26595406.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

I am seeing some very strange behavior with my Derby DB
(version 10.4.2.0 and 10.5.3.0).

If I load my DB from a JAR file, I am missing some table
entries, that are existing if I extract the DB from the
same JAR file and load it from the file system.

How can I understand this behavior, is there an
explanation for this?

Thanks a lot!

Thank you Francois, this helped me.
--
George H
george.dma@gmail.com


On Tue, Dec 1, 2009 at 11:25 AM, Francois Orsini
<francois.orsini@gmail.com>wrote:

> Hi George,
>
> It should be ok to use it - it seems to be similar to the UnicodeConverter
> class found here:
> http://java.sun.com/docs/books/tutorial/i18n/text/string.html
>
> http://java.sun.com/docs/books/tutorial/i18n/text/examples/UnicodeFormatter.java
>
> Cheers,
>
> --Francois
>
>
> On Tue, Dec 1, 2009 at 1:12 AM, George H <george.dma@gmail.com> wrote:
>
>> I seem to have a problem converting the byte array to a string using
>> normal java String class.
>> I read that the key uses a X.509 spec which is encoded in utf-8
>>
>> I also wrote a hex string builder as well and the results are different.
>>
>> KeyGenerator keyGen = KeyGenerator.getInstance("Blowfish", "SunJCE");
>>
>> keyGen.init(256);
>> SecretKey key = keyGen.generateKey();
>> System.out.println(toHexString(key.getEncoded()));
>> System.out.println(new String(key.getEncoded(), "utf8"));
>>
>> private static final char[] HEX_CHARS = {'0', '1', '2' ,'3', '4', '5',
>> '6', '7', '8', '9','a', 'b', 'c', 'd', 'e', 'f'};
>>
>> private String toHexString(byte[] bytes)
>> {
>>     StringBuilder sb = new StringBuilder();
>>     int high = 0;
>>     int low = 0;
>>     for(int i = 0; i < bytes.length; i++) {
>>         high = ((bytes[i] & 0xF0) >> 4);
>>         low = (bytes[i] & 0x0F);
>>         sb.append(HEX_CHARS[high]);
>>         sb.append(HEX_CHARS[low]);
>>     }
>>
>>     return sb.toString();
>> }
>>
>> The results look like this
>> 4a63ea27b46504660cc3c6c2f22de1a35f3eabdc468cc6e64928b369c8ff1681
>> Jc�'�e f ����-�_>��F���I(�i�� �
>>
>> Sorry to trouble you about this as this is not really Derby related.. but
>> is that toHexString method ok to use? or is there an easier way to convert
>> the bytes using String class, because I can't seem to get anywhere with it.
>>
>>
>> Thanks.
>> --
>> George H
>> george.dma@gmail.com
>>
>>
>> On Tue, Dec 1, 2009 at 10:41 AM, Francois Orsini <
>> francois.orsini@gmail.com> wrote:
>>
>>> Hi George,
>>>
>>> key.getEncoded() returns a byte array that is a textual representation of
>>> the external key in Hex.
>>>
>>> Just Stringify the byte array and set it to the 'encryptedKey' JDBC
>>> connection URL attribute - that should work.
>>>
>>> Cheers,
>>>
>>> --Francois
>>>
>>>
>>> On Mon, Nov 30, 2009 at 10:45 PM, George H <george.dma@gmail.com> wrote:
>>>
>>>> Hi,
>>>>
>>>> I am trying to create an embedded derby db using an encryption key that
>>>> I generate before hand. I've read the derby v10.5.3.0 ref guide and the
>>>> developer guide and I still have one question that lingers in my mind.
>>>>
>>>> In the JDBC url where I have to specify the encryption key attribute how
>>>> do we get the key in string form? In the docs they use examples (Dev guide
>>>> page 114 (PDF)) where the key looks like a letters and numbers and in most
>>>> cases just numbers.
>>>>
>>>> Now when I generate my key like
>>>>
>>>> KeyGenerator keyGen = KeyGenerator.getInstance("AES")
>>>> keyGen.init(256);
>>>> SecretKey key = keyGen.generateKey();
>>>>
>>>> I only have the method   key.getEncoded() that I can use which returns
>>>> an array of bytes. I wonder how I can give this key to derby in the jdbc
url
>>>> ? Do I have to convert the byte array to a HEX string ? or to decimals? I
>>>> don't know. If someone could help me out on this specific part it would be
>>>> great.
>>>>
>>>> Thanks
>>>> --
>>>> George H
>>>> george.dma@gmail.com
>>>>
>>>
>>>
>>
>

Hi George,

It should be ok to use it - it seems to be similar to the UnicodeConverter
class found here:
http://java.sun.com/docs/books/tutorial/i18n/text/string.html
http://java.sun.com/docs/books/tutorial/i18n/text/examples/UnicodeFormatter.java

Cheers,

--Francois

On Tue, Dec 1, 2009 at 1:12 AM, George H <george.dma@gmail.com> wrote:

> I seem to have a problem converting the byte array to a string using normal
> java String class.
> I read that the key uses a X.509 spec which is encoded in utf-8
>
> I also wrote a hex string builder as well and the results are different.
>
> KeyGenerator keyGen = KeyGenerator.getInstance("Blowfish", "SunJCE");
>
> keyGen.init(256);
> SecretKey key = keyGen.generateKey();
> System.out.println(toHexString(key.getEncoded()));
> System.out.println(new String(key.getEncoded(), "utf8"));
>
> private static final char[] HEX_CHARS = {'0', '1', '2' ,'3', '4', '5', '6',
> '7', '8', '9','a', 'b', 'c', 'd', 'e', 'f'};
>
> private String toHexString(byte[] bytes)
> {
>     StringBuilder sb = new StringBuilder();
>     int high = 0;
>     int low = 0;
>     for(int i = 0; i < bytes.length; i++) {
>         high = ((bytes[i] & 0xF0) >> 4);
>         low = (bytes[i] & 0x0F);
>         sb.append(HEX_CHARS[high]);
>         sb.append(HEX_CHARS[low]);
>     }
>
>     return sb.toString();
> }
>
> The results look like this
> 4a63ea27b46504660cc3c6c2f22de1a35f3eabdc468cc6e64928b369c8ff1681
> Jc�'�e f ����-�_>��F���I(�i�� �
>
> Sorry to trouble you about this as this is not really Derby related.. but
> is that toHexString method ok to use? or is there an easier way to convert
> the bytes using String class, because I can't seem to get anywhere with it.
>
>
> Thanks.
> --
> George H
> george.dma@gmail.com
>
>
> On Tue, Dec 1, 2009 at 10:41 AM, Francois Orsini <
> francois.orsini@gmail.com> wrote:
>
>> Hi George,
>>
>> key.getEncoded() returns a byte array that is a textual representation of
>> the external key in Hex.
>>
>> Just Stringify the byte array and set it to the 'encryptedKey' JDBC
>> connection URL attribute - that should work.
>>
>> Cheers,
>>
>> --Francois
>>
>>
>> On Mon, Nov 30, 2009 at 10:45 PM, George H <george.dma@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> I am trying to create an embedded derby db using an encryption key that I
>>> generate before hand. I've read the derby v10.5.3.0 ref guide and the
>>> developer guide and I still have one question that lingers in my mind.
>>>
>>> In the JDBC url where I have to specify the encryption key attribute how
>>> do we get the key in string form? In the docs they use examples (Dev guide
>>> page 114 (PDF)) where the key looks like a letters and numbers and in most
>>> cases just numbers.
>>>
>>> Now when I generate my key like
>>>
>>> KeyGenerator keyGen = KeyGenerator.getInstance("AES")
>>> keyGen.init(256);
>>> SecretKey key = keyGen.generateKey();
>>>
>>> I only have the method   key.getEncoded() that I can use which returns an
>>> array of bytes. I wonder how I can give this key to derby in the jdbc url ?
>>> Do I have to convert the byte array to a HEX string ? or to decimals? I
>>> don't know. If someone could help me out on this specific part it would be
>>> great.
>>>
>>> Thanks
>>> --
>>> George H
>>> george.dma@gmail.com
>>>
>>
>>
>

I seem to have a problem converting the byte array to a string using normal
java String class.
I read that the key uses a X.509 spec which is encoded in utf-8

I also wrote a hex string builder as well and the results are different.

KeyGenerator keyGen = KeyGenerator.getInstance("Blowfish", "SunJCE");
keyGen.init(256);
SecretKey key = keyGen.generateKey();
System.out.println(toHexString(key.getEncoded()));
System.out.println(new String(key.getEncoded(), "utf8"));

private static final char[] HEX_CHARS = {'0', '1', '2' ,'3', '4', '5', '6',
'7', '8', '9','a', 'b', 'c', 'd', 'e', 'f'};

private String toHexString(byte[] bytes)
{
    StringBuilder sb = new StringBuilder();
    int high = 0;
    int low = 0;
    for(int i = 0; i < bytes.length; i++) {
        high = ((bytes[i] & 0xF0) >> 4);
        low = (bytes[i] & 0x0F);
        sb.append(HEX_CHARS[high]);
        sb.append(HEX_CHARS[low]);
    }

    return sb.toString();
}

The results look like this
4a63ea27b46504660cc3c6c2f22de1a35f3eabdc468cc6e64928b369c8ff1681
Jc�'�e f ����-�_>��F���I(�i�� �

Sorry to trouble you about this as this is not really Derby related.. but is
that toHexString method ok to use? or is there an easier way to convert the
bytes using String class, because I can't seem to get anywhere with it.

Thanks.
--
George H
george.dma@gmail.com


On Tue, Dec 1, 2009 at 10:41 AM, Francois Orsini
<francois.orsini@gmail.com>wrote:

> Hi George,
>
> key.getEncoded() returns a byte array that is a textual representation of
> the external key in Hex.
>
> Just Stringify the byte array and set it to the 'encryptedKey' JDBC
> connection URL attribute - that should work.
>
> Cheers,
>
> --Francois
>
>
> On Mon, Nov 30, 2009 at 10:45 PM, George H <george.dma@gmail.com> wrote:
>
>> Hi,
>>
>> I am trying to create an embedded derby db using an encryption key that I
>> generate before hand. I've read the derby v10.5.3.0 ref guide and the
>> developer guide and I still have one question that lingers in my mind.
>>
>> In the JDBC url where I have to specify the encryption key attribute how
>> do we get the key in string form? In the docs they use examples (Dev guide
>> page 114 (PDF)) where the key looks like a letters and numbers and in most
>> cases just numbers.
>>
>> Now when I generate my key like
>>
>> KeyGenerator keyGen = KeyGenerator.getInstance("AES")
>> keyGen.init(256);
>> SecretKey key = keyGen.generateKey();
>>
>> I only have the method   key.getEncoded() that I can use which returns an
>> array of bytes. I wonder how I can give this key to derby in the jdbc url ?
>> Do I have to convert the byte array to a HEX string ? or to decimals? I
>> don't know. If someone could help me out on this specific part it would be
>> great.
>>
>> Thanks
>> --
>> George H
>> george.dma@gmail.com
>>
>
>

Hi George,

key.getEncoded() returns a byte array that is a textual representation of
the external key in Hex.

Just Stringify the byte array and set it to the 'encryptedKey' JDBC
connection URL attribute - that should work.

Cheers,

--Francois

On Mon, Nov 30, 2009 at 10:45 PM, George H <george.dma@gmail.com> wrote:

> Hi,
>
> I am trying to create an embedded derby db using an encryption key that I
> generate before hand. I've read the derby v10.5.3.0 ref guide and the
> developer guide and I still have one question that lingers in my mind.
>
> In the JDBC url where I have to specify the encryption key attribute how do
> we get the key in string form? In the docs they use examples (Dev guide page
> 114 (PDF)) where the key looks like a letters and numbers and in most cases
> just numbers.
>
> Now when I generate my key like
>
> KeyGenerator keyGen = KeyGenerator.getInstance("AES")
> keyGen.init(256);
> SecretKey key = keyGen.generateKey();
>
> I only have the method   key.getEncoded() that I can use which returns an
> array of bytes. I wonder how I can give this key to derby in the jdbc url ?
> Do I have to convert the byte array to a HEX string ? or to decimals? I
> don't know. If someone could help me out on this specific part it would be
> great.
>
> Thanks
> --
> George H
> george.dma@gmail.com
>

Hi,

I am trying to create an embedded derby db using an encryption key that I
generate before hand. I've read the derby v10.5.3.0 ref guide and the
developer guide and I still have one question that lingers in my mind.

In the JDBC url where I have to specify the encryption key attribute how do
we get the key in string form? In the docs they use examples (Dev guide page
114 (PDF)) where the key looks like a letters and numbers and in most cases
just numbers.

Now when I generate my key like

KeyGenerator keyGen = KeyGenerator.getInstance("AES")
keyGen.init(256);
SecretKey key = keyGen.generateKey();

I only have the method   key.getEncoded() that I can use which returns an
array of bytes. I wonder how I can give this key to derby in the jdbc url ?
Do I have to convert the byte array to a HEX string ? or to decimals? I
don't know. If someone could help me out on this specific part it would be
great.

Thanks
--
George H
george.dma@gmail.com

> I am following "*Getting Started With Java DB*" instructions.
> Problem occures when I try to follow instructions for "*Run a JDBC 
> program using the embedded driver*".

Hi, Sorry about this. We just fixed these docs in the trunk, so the
docs will be better in the next release.

> When I try to compile *WwdEmbedded.java* there is an error that looks 
> like this:
> 
> --------------------------------------------------------------
> *WwdEmbedded.java:80: cannot find symbol
> symbol  : variable WwdUtils

To avoid this problem, simply compile both classes at the same time:

   javac WwdEmbedded.java WwdUtils.java

thanks,

bryan

I am new in Derby. 

Here is my problem:
I am following "Getting Started With Java DB" instructions.
Problem occures when I try to follow instructions for "Run a JDBC program using the embedded
driver".
When I try to compile WwdEmbedded.java there is an error that looks like this:

--------------------------------------------------------------
WwdEmbedded.java:80: cannot find symbol
symbol  : variable WwdUtils
location: class WwdEmbedded
             if (! WwdUtils.wwdChk4Table(conn))
                   ^
WwdEmbedded.java:92: cannot find symbol
symbol  : variable WwdUtils
location: class WwdEmbedded
                answer = WwdUtils.getWishItem();
                         ^
2 errors
--------------------------------------------------------------

My version of Java is : Java(TM) SE Runtime Environment (build 1.6.0_17-b04)
Version of Derby is : Derby 10.4.2.1
Operating System : Windows XP sp3

------------------------------------------------------------------------------------------------------------------
I am thankful on every answer...

I guess I shouldn't have responded to this directly after waking up.
ODBC-JDBC Sounds like a feasible solution.  I'm going to give it a try.

Thanks much.

On Mon, 30 Nov 2009 07:21:45 -0600
Dan Farrell <dan@danf.us> wrote:

> Hi, and thank you.  My understanding was that I still needed the DB2
> stuff behind odbc. Was I mistaken? I know jdbc works well,  but I
> haven't been able to get my odbc_connect to succeed. Can anyone
> please help me find the proper odbc connection syntax and backend to
> connect to a Derby network server from PHP?
> 
> Thanks again!
> 
> Sylvain Leroux <sylvain@chicoree.fr> wrote:
> 
> >Hi Dan,
> >
> >
> >I don't know if Derby is still compatible with DB2-CLI.
> >
> >Anyway, if it is no longer the case, as an alternative you may use
> >an ODBC-JDBC gateway. Since PHP has support for ODBC, this should
> >work.
> >
> >
> >Please, keep us up to date!
> >Sylvain.
> >
> >
> >Dan Farrell a écrit :
> >> Hi All,
> >> 
> >> i would like to connect to a Derby DB With PHP.  It seems that to
> >> do so I will need the ibm db2 module for PHP.  To build that, in
> >> turn,  I will need db2 header and library files.  But for the life
> >> of me, I can't find a suitable download for these files anywhere.
> >> Many of the links seem to have vanished from IBM's site, but there
> >> are no such links at the Apache Derby site either, from what I can
> >> tell.  
> >> 
> >> Can anyone help me figure out where I can obtain IBM's Client
> >> Driver package so that I can build the db2 module for PHP and
> >> connect to my Derby Database?  
> >> 
> >> Or is there some better solution that doesn't require IBM
> >> libraries? 
> >> 
> >> Thank you very much, I'm stumbling in the dark.  
> >> 
> >> Sincerely, 
> >> 
> >> 	Dan Farrell
> >> 
> >> 
> >
> >
> >-- 
> >sylvain@chicoree.fr
> >http://www.chicoree.fr
> >

Rick Hillegas wrote:
> Hi Dan,
>
> In addition, see the following page for a number of ODBC drivers which 
> work with Derby: 
> http://wiki.apache.org/db-derby/UsesOfDerby#Products_By_Type
The DB2 Runtime client has not been supported with Derby for some time, 
so I removed it from this page to avoid confusion.

Oracle and other databases (including Derby server mode) - the DB runs
as a separate process and the application talks to it over a network
connection. Embedded databases such as Derby the database runs inside
your application, the database is on a local disk and the application
objects talk directly to the DBMS objects via method calls.

Actually doing the embedding basically requires two things:

1. including derby.jar in your classpath

2. connecting to the database using a URL that specifies a local file

Otherwise - what Rick said - the Derby documentation is pretty
straightforward and useful.

Donald

On Mon, Nov 30, 2009 at 10:50 AM, 120113698 <120113698@qq.com> wrote:
> How can I embed the Derby-Database to a Desktop Java Application?
> and what is the deffirence between using Oracle Database in Deaktop Java
> Apps and using derby in desktop java apps?
-- 
Family photographs are a critical legacy for
ourselves and our descendants. Protect that
legacy with a digital backup and recovery plan.

Join the photo preservation advocacy Facebook group:
http://www.facebook.com/home.php?ref=logo#/group.php?gid=148274709288

120113698 wrote:
> How can I embed the Derby-Database to a Desktop Java Application?
> and what is the deffirence between using Oracle Database in Deaktop 
> Java Apps and using derby in desktop java apps?
>  
> 2009-11-30
> 120113698
Hello,

The Getting Started Guide explains how to embed Derby in a desktop 
application: http://db.apache.org/derby/docs/10.5/getstart/


Regards,
-Rick

How can I embed the Derby-Database to a Desktop Java Application?
and what is the deffirence between using Oracle Database in Deaktop Java Apps and using derby
in desktop java apps?

2009-11-30 



120113698 

Hi Dan,

The following old blog may give you some pointers: 
http://coffeecode.net/archives/16-Apache-Derby-tutorial-OSCON-2005-materials.html

In addition, see the following page for a number of ODBC drivers which 
work with Derby: 
http://wiki.apache.org/db-derby/UsesOfDerby#Products_By_Type

Hope this helps,
-Rick

Dan Farrell wrote:
> Hi All,
>
> i would like to connect to a Derby DB With PHP.  It seems that to do
> so I will need the ibm db2 module for PHP.  To build that, in turn,  I
> will need db2 header and library files.  But for the life of me, I
> can't find a suitable download for these files anywhere.  Many of the
> links seem to have vanished from IBM's site, but there are no such
> links at the Apache Derby site either, from what I can tell.  
>
> Can anyone help me figure out where I can obtain IBM's Client Driver
> package so that I can build the db2 module for PHP and connect to my
> Derby Database?  
>
> Or is there some better solution that doesn't require IBM libraries? 
>
> Thank you very much, I'm stumbling in the dark.  
>
> Sincerely, 
>
> 	Dan Farrell
>   

Hi, and thank you.  My understanding was that I still needed the DB2 stuff behind odbc. Was
I mistaken? 
I know jdbc works well,  but I haven't been able to get my odbc_connect to succeed. Can anyone
please help me find the proper odbc connection syntax and backend to connect to a Derby network
server from PHP?

Thanks again!

Sylvain Leroux <sylvain@chicoree.fr> wrote:

>Hi Dan,
>
>
>I don't know if Derby is still compatible with DB2-CLI.
>
>Anyway, if it is no longer the case, as an alternative you may use an ODBC-JDBC 
>gateway. Since PHP has support for ODBC, this should work.
>
>
>Please, keep us up to date!
>Sylvain.
>
>
>Dan Farrell a écrit :
>> Hi All,
>> 
>> i would like to connect to a Derby DB With PHP.  It seems that to do
>> so I will need the ibm db2 module for PHP.  To build that, in turn,  I
>> will need db2 header and library files.  But for the life of me, I
>> can't find a suitable download for these files anywhere.  Many of the
>> links seem to have vanished from IBM's site, but there are no such
>> links at the Apache Derby site either, from what I can tell.  
>> 
>> Can anyone help me figure out where I can obtain IBM's Client Driver
>> package so that I can build the db2 module for PHP and connect to my
>> Derby Database?  
>> 
>> Or is there some better solution that doesn't require IBM libraries? 
>> 
>> Thank you very much, I'm stumbling in the dark.  
>> 
>> Sincerely, 
>> 
>> 	Dan Farrell
>> 
>> 
>
>
>-- 
>sylvain@chicoree.fr
>http://www.chicoree.fr
>

Hi Dan,


I don't know if Derby is still compatible with DB2-CLI.

Anyway, if it is no longer the case, as an alternative you may use an ODBC-JDBC 
gateway. Since PHP has support for ODBC, this should work.


Please, keep us up to date!
Sylvain.


Dan Farrell a écrit :
> Hi All,
> 
> i would like to connect to a Derby DB With PHP.  It seems that to do
> so I will need the ibm db2 module for PHP.  To build that, in turn,  I
> will need db2 header and library files.  But for the life of me, I
> can't find a suitable download for these files anywhere.  Many of the
> links seem to have vanished from IBM's site, but there are no such
> links at the Apache Derby site either, from what I can tell.  
> 
> Can anyone help me figure out where I can obtain IBM's Client Driver
> package so that I can build the db2 module for PHP and connect to my
> Derby Database?  
> 
> Or is there some better solution that doesn't require IBM libraries? 
> 
> Thank you very much, I'm stumbling in the dark.  
> 
> Sincerely, 
> 
> 	Dan Farrell
> 
> 


-- 
sylvain@chicoree.fr
http://www.chicoree.fr

Hi All,

i would like to connect to a Derby DB With PHP.  It seems that to do
so I will need the ibm db2 module for PHP.  To build that, in turn,  I
will need db2 header and library files.  But for the life of me, I
can't find a suitable download for these files anywhere.  Many of the
links seem to have vanished from IBM's site, but there are no such
links at the Apache Derby site either, from what I can tell.  

Can anyone help me figure out where I can obtain IBM's Client Driver
package so that I can build the db2 module for PHP and connect to my
Derby Database?  

Or is there some better solution that doesn't require IBM libraries? 

Thank you very much, I'm stumbling in the dark.  

Sincerely, 

	Dan Farrell

Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable



I am out of the office until 11/30/2009.




Note: This is an automated response to your message  "derby-user Digest=
 29
Nov 2009 04:05:09 -0000 Issue 964" sent on 11/28/09 21:05:09.

This is the only notification you will receive while this person is awa=
y.=

I develop on Windows and deploy to AIX 5.3 using Java 6 (_17 on Windows) and
SR4
http://www.ibm.com/developerworks/java/jdk/aix/j664/Java6_64.fixinfo.html and
never encountered anything unusual.

On Fri, Nov 27, 2009 at 4:30 PM, <Malte.Kempff@de.equens.com> wrote:

> Hi Dag,
> Thanks for your effort. The problem is as far I understand a special
> behavoiour on AIX Java Mashine. Does anybody of the developing or testing
> people got access on something like that?
>
>
> -----Ursprüngliche Nachricht-----
> Von: Dag.Wanvik@Sun.COM [mailto:Dag.Wanvik@Sun.COM]
> Gesendet: Freitag, 27. November 2009 16:15
> An: Derby Discussion
> Betreff: Re: AW: AW: AW: OOM with millions of weakly-referenced Derby
> objects
>
>
> Hi Malte,
>
> Malte.Kempff@de.equens.com writes:
>
>
> > Hi Dag, The problem in my case is, that I don't have access to any
> > AIX-Computer, and that is really a pity, because I cannot
> > reconstruct the scenario on my own and watch it with my own eyes.
> > That all happened on a production system and the provider denies
> > trying it out again.  But attached you can find the SQL-script
> > without being UTF8.  So that Problem should occur in the same way
> > used on AIX (5.3) BTW: is there a way to be kind of independent of
> > the input format?
>
> I converted the script you enclosed to UTF-8 and ran it through ij
> without any problems.
>
> I also tried to run it with the enclosed program, and it gave me no
> errors when the inout file was encoded with UTF-8 (Comments had
> non-ASCII German character), and it printed no errors on my
> OpenSolaris system (I don't have access to AIX).
>
> In any case, should you see this problem again, please feel free to
> file a bug report(*), preferably with a repro and/or logs.
>
> As for independence of the input format, since runScript requires that
> you specify the encoding, you could do some encoding auto-detect logic
> on the script, I guess..
>
> (*) http://db.apache.org/derby/DerbyBugGuidelines.html
>
> Hope this helps,
> Dag
>
>
> import org.apache.derby.tools.ij;
> import java.sql.*;
> import java.io.*;
>
> public class Foo {
>
>    public Foo() {};
>
>    static public void main(String[] args)
>            throws SQLException,
>                   UnsupportedEncodingException,
>                   FileNotFoundException,
>                   ClassNotFoundException {
>        Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
>        Connection c =
> DriverManager.getConnection("jdbc:derby:wombat;create=true");
>
>        FileInputStream fs = new FileInputStream(args[0]);
>
>        int errs = ij.runScript(c,
>                                fs,
>                                "UTF-8",
>                                System.out,
>                                "UTF-8");
>
>        System.out.println("\n\nerrs=" + errs);
>        c.close();
>    }
> }
>
>
>
>
> >
> > Malte
> >
> > -----Ursprüngliche Nachricht-----
> > Von: Dag.Wanvik@Sun.COM [mailto:Dag.Wanvik@Sun.COM]
> > Gesendet: Freitag, 27. November 2009 01:19
> > An: Derby Discussion
> > Betreff: Re: AW: AW: OOM with millions of weakly-referenced Derby objects
> >
> > Malte.Kempff@de.equens.com writes:
> >
> >> Yes this is the API I am reffering to.  Well actually it says that,
> >> but in my case it did not do it.  It needed a long time, several
> >> minutes. Reason as it turned later out, after getting the output in
> >> a file a lot of IOExcceptions. I never got those on windows nor on
> >> Solaris. Thr original logic of the routine calling the runScript
> >> Method was asking for the return code but either it never hit this
> >> if statement and crashed somewhere within ij without giving the
> >> Exception to the caller or ij gave something like 0 so the output
> >> never was given to the logger.  So there is something phony with
> >> ij.runScript using it with AIX 5.3 and a SQL-Script not coded UTF8
> >> but declaring in the parameters as UTF8. Of course that is a fault
> >> by my own, but it should tel me about it.
> >
> > I looked at the implementation for runScript in
> > org.apache.derby.impl.tools.ij.utilMain#runScriptGuts and it does seem
> > to catch exceptions, count them and return them. Are you able to
> > provide a repro script showing that 0 or -1 is returned from runScript
> > for the failing scenario?
> >
> > Thanks,
> > Dag
> >
> >>
> >>
> >>
> >> -----Ursprüngliche Nachricht-----
> >> Von: Dag.Wanvik@Sun.COM [mailto:Dag.Wanvik@Sun.COM]
> >> Gesendet: Freitag, 20. November 2009 19:54
> >> An: Derby Discussion
> >> Betreff: Re: AW: OOM with millions of weakly-referenced Derby objects
> >>
> >> Malte.Kempff@de.equens.com writes:
> >>
> >>> In other words I would count that situation as not nice behaviour of
> ij, since the return code should have been given as I would suppose it
> looking at the method signature.
> >>
> >> Is this the API signature you are referring to?
> >>
> >>
> http://db.apache.org/derby/docs/10.5/publishedapi/jdbc4/org/apache/derby/tools/ij.html#runScript(java.sql.Connection,%20java.io.InputStream,%20java.lang.String,%20java.io.OutputStream,%20java.lang.String)
> >>
> >> It says:
> >>
> >> Returns:h
> >>     Number of SQLExceptions thrown during the execution, -1 if not
> >>     known.
> >>
> >> If so, are you seeing 0 or -1 returned here?
> >>
> >> Dag
>

Ok, seems I have found the problem in the Netbeans IDE. If I execute the
SQL in Java code everything works perfect. So I've written a small SQL
importer for my data ;) I think that Netbeans escapes every data so its
impossible to import that data with the 'SQL Command' tabs.

Sven Skrabal schrieb:
> Hi all,
>
> I'm trying to import data exported via PhpMyAdmin from MySQL. Now my SQL
> Statements contain special characters like \r\n. Apache Derby seems to
> filter them out. If I import that data I just get this characters
> interpreted as normal text. So what I get is a string containing all
> data without the  correct newlines. How can I tell Apache Derby to
> interpret this text as special charaters?
>
> Example:
> INSERT INTO test (test) VALUES ('test\r\ntest');
>
> The column's datatype is LONG VARCHAR. I used the 'Services' tab in
> Netbeans IDE to import this data. A lot of research on google and the
> reference manual didn't help. Please help :-)
>
> Greetings
> Sven S.
>
>
>   

Hi Dag,
Thanks for your effort. The problem is as far I understand a special behavoiour on AIX Java
Mashine. Does anybody of the developing or testing people got access on something like that?


-----Ursprüngliche Nachricht-----
Von: Dag.Wanvik@Sun.COM [mailto:Dag.Wanvik@Sun.COM] 
Gesendet: Freitag, 27. November 2009 16:15
An: Derby Discussion
Betreff: Re: AW: AW: AW: OOM with millions of weakly-referenced Derby objects


Hi Malte,

Malte.Kempff@de.equens.com writes:


> Hi Dag, The problem in my case is, that I don't have access to any
> AIX-Computer, and that is really a pity, because I cannot
> reconstruct the scenario on my own and watch it with my own eyes.
> That all happened on a production system and the provider denies
> trying it out again.  But attached you can find the SQL-script
> without being UTF8.  So that Problem should occur in the same way
> used on AIX (5.3) BTW: is there a way to be kind of independent of
> the input format?

I converted the script you enclosed to UTF-8 and ran it through ij
without any problems. 

I also tried to run it with the enclosed program, and it gave me no
errors when the inout file was encoded with UTF-8 (Comments had
non-ASCII German character), and it printed no errors on my
OpenSolaris system (I don't have access to AIX).

In any case, should you see this problem again, please feel free to
file a bug report(*), preferably with a repro and/or logs.

As for independence of the input format, since runScript requires that
you specify the encoding, you could do some encoding auto-detect logic
on the script, I guess..

(*) http://db.apache.org/derby/DerbyBugGuidelines.html

Hope this helps,
Dag


import org.apache.derby.tools.ij;
import java.sql.*;
import java.io.*;

public class Foo {

    public Foo() {};

    static public void main(String[] args)
            throws SQLException,
                   UnsupportedEncodingException,
                   FileNotFoundException,
                   ClassNotFoundException {
        Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
        Connection c = DriverManager.getConnection("jdbc:derby:wombat;create=true");

        FileInputStream fs = new FileInputStream(args[0]);

        int errs = ij.runScript(c,
                                fs,
                                "UTF-8",
                                System.out,
                                "UTF-8");

        System.out.println("\n\nerrs=" + errs);
        c.close();
    }
}




>
> Malte
>
> -----Ursprüngliche Nachricht-----
> Von: Dag.Wanvik@Sun.COM [mailto:Dag.Wanvik@Sun.COM] 
> Gesendet: Freitag, 27. November 2009 01:19
> An: Derby Discussion
> Betreff: Re: AW: AW: OOM with millions of weakly-referenced Derby objects
>
> Malte.Kempff@de.equens.com writes:
>
>> Yes this is the API I am reffering to.  Well actually it says that,
>> but in my case it did not do it.  It needed a long time, several
>> minutes. Reason as it turned later out, after getting the output in
>> a file a lot of IOExcceptions. I never got those on windows nor on
>> Solaris. Thr original logic of the routine calling the runScript
>> Method was asking for the return code but either it never hit this
>> if statement and crashed somewhere within ij without giving the
>> Exception to the caller or ij gave something like 0 so the output
>> never was given to the logger.  So there is something phony with
>> ij.runScript using it with AIX 5.3 and a SQL-Script not coded UTF8
>> but declaring in the parameters as UTF8. Of course that is a fault
>> by my own, but it should tel me about it.
>
> I looked at the implementation for runScript in
> org.apache.derby.impl.tools.ij.utilMain#runScriptGuts and it does seem
> to catch exceptions, count them and return them. Are you able to
> provide a repro script showing that 0 or -1 is returned from runScript
> for the failing scenario? 
>
> Thanks,
> Dag
>
>>
>>
>>
>> -----Ursprüngliche Nachricht-----
>> Von: Dag.Wanvik@Sun.COM [mailto:Dag.Wanvik@Sun.COM] 
>> Gesendet: Freitag, 20. November 2009 19:54
>> An: Derby Discussion
>> Betreff: Re: AW: OOM with millions of weakly-referenced Derby objects
>>
>> Malte.Kempff@de.equens.com writes:
>>
>>> In other words I would count that situation as not nice behaviour of ij, since
the return code should have been given as I would suppose it looking at the method signature.
>>
>> Is this the API signature you are referring to?
>>
>> http://db.apache.org/derby/docs/10.5/publishedapi/jdbc4/org/apache/derby/tools/ij.html#runScript(java.sql.Connection,%20java.io.InputStream,%20java.lang.String,%20java.io.OutputStream,%20java.lang.String)
>>
>> It says:
>>
>> Returns:h
>>     Number of SQLExceptions thrown during the execution, -1 if not
>>     known. 
>>
>> If so, are you seeing 0 or -1 returned here?
>>
>> Dag

Hi Malte,

Malte.Kempff@de.equens.com writes:


> Hi Dag, The problem in my case is, that I don't have access to any
> AIX-Computer, and that is really a pity, because I cannot
> reconstruct the scenario on my own and watch it with my own eyes.
> That all happened on a production system and the provider denies
> trying it out again.  But attached you can find the SQL-script
> without being UTF8.  So that Problem should occur in the same way
> used on AIX (5.3) BTW: is there a way to be kind of independent of
> the input format?

I converted the script you enclosed to UTF-8 and ran it through ij
without any problems. 

I also tried to run it with the enclosed program, and it gave me no
errors when the inout file was encoded with UTF-8 (Comments had
non-ASCII German character), and it printed no errors on my
OpenSolaris system (I don't have access to AIX).

In any case, should you see this problem again, please feel free to
file a bug report(*), preferably with a repro and/or logs.

As for independence of the input format, since runScript requires that
you specify the encoding, you could do some encoding auto-detect logic
on the script, I guess..

(*) http://db.apache.org/derby/DerbyBugGuidelines.html

Hope this helps,
Dag


import org.apache.derby.tools.ij;
import java.sql.*;
import java.io.*;

public class Foo {

    public Foo() {};

    static public void main(String[] args)
            throws SQLException,
                   UnsupportedEncodingException,
                   FileNotFoundException,
                   ClassNotFoundException {
        Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
        Connection c = DriverManager.getConnection("jdbc:derby:wombat;create=true");

        FileInputStream fs = new FileInputStream(args[0]);

        int errs = ij.runScript(c,
                                fs,
                                "UTF-8",
                                System.out,
                                "UTF-8");

        System.out.println("\n\nerrs=" + errs);
        c.close();
    }
}




>
> Malte
>
> -----Ursprüngliche Nachricht-----
> Von: Dag.Wanvik@Sun.COM [mailto:Dag.Wanvik@Sun.COM] 
> Gesendet: Freitag, 27. November 2009 01:19
> An: Derby Discussion
> Betreff: Re: AW: AW: OOM with millions of weakly-referenced Derby objects
>
> Malte.Kempff@de.equens.com writes:
>
>> Yes this is the API I am reffering to.  Well actually it says that,
>> but in my case it did not do it.  It needed a long time, several
>> minutes. Reason as it turned later out, after getting the output in
>> a file a lot of IOExcceptions. I never got those on windows nor on
>> Solaris. Thr original logic of the routine calling the runScript
>> Method was asking for the return code but either it never hit this
>> if statement and crashed somewhere within ij without giving the
>> Exception to the caller or ij gave something like 0 so the output
>> never was given to the logger.  So there is something phony with
>> ij.runScript using it with AIX 5.3 and a SQL-Script not coded UTF8
>> but declaring in the parameters as UTF8. Of course that is a fault
>> by my own, but it should tel me about it.
>
> I looked at the implementation for runScript in
> org.apache.derby.impl.tools.ij.utilMain#runScriptGuts and it does seem
> to catch exceptions, count them and return them. Are you able to
> provide a repro script showing that 0 or -1 is returned from runScript
> for the failing scenario? 
>
> Thanks,
> Dag
>
>>
>>
>>
>> -----Ursprüngliche Nachricht-----
>> Von: Dag.Wanvik@Sun.COM [mailto:Dag.Wanvik@Sun.COM] 
>> Gesendet: Freitag, 20. November 2009 19:54
>> An: Derby Discussion
>> Betreff: Re: AW: OOM with millions of weakly-referenced Derby objects
>>
>> Malte.Kempff@de.equens.com writes:
>>
>>> In other words I would count that situation as not nice behaviour of ij, since
the return code should have been given as I would suppose it looking at the method signature.
>>
>> Is this the API signature you are referring to?
>>
>> http://db.apache.org/derby/docs/10.5/publishedapi/jdbc4/org/apache/derby/tools/ij.html#runScript(java.sql.Connection,%20java.io.InputStream,%20java.lang.String,%20java.io.OutputStream,%20java.lang.String)
>>
>> It says:
>>
>> Returns:h
>>     Number of SQLExceptions thrown during the execution, -1 if not
>>     known. 
>>
>> If so, are you seeing 0 or -1 returned here?
>>
>> Dag

Hi Dag,
The problem in my case is, that I don't have access to any AIX-Computer, and that is really
a pity, because I cannot reconstruct the scenario on my own and watch it with my own eyes.
That all happened on a production system and the provider denies trying it out again.
But attached you can find the SQL-script without being UTF8.
So that Problem should occur in the same way used on AIX (5.3)
BTW: is there a way to be kind of independent of the input format?

Malte

-----Ursprüngliche Nachricht-----
Von: Dag.Wanvik@Sun.COM [mailto:Dag.Wanvik@Sun.COM] 
Gesendet: Freitag, 27. November 2009 01:19
An: Derby Discussion
Betreff: Re: AW: AW: OOM with millions of weakly-referenced Derby objects

Malte.Kempff@de.equens.com writes:

> Yes this is the API I am reffering to.  Well actually it says that,
> but in my case it did not do it.  It needed a long time, several
> minutes. Reason as it turned later out, after getting the output in
> a file a lot of IOExcceptions. I never got those on windows nor on
> Solaris. Thr original logic of the routine calling the runScript
> Method was asking for the return code but either it never hit this
> if statement and crashed somewhere within ij without giving the
> Exception to the caller or ij gave something like 0 so the output
> never was given to the logger.  So there is something phony with
> ij.runScript using it with AIX 5.3 and a SQL-Script not coded UTF8
> but declaring in the parameters as UTF8. Of course that is a fault
> by my own, but it should tel me about it.

I looked at the implementation for runScript in
org.apache.derby.impl.tools.ij.utilMain#runScriptGuts and it does seem
to catch exceptions, count them and return them. Are you able to
provide a repro script showing that 0 or -1 is returned from runScript
for the failing scenario? 

Thanks,
Dag

>
>
>
> -----Ursprüngliche Nachricht-----
> Von: Dag.Wanvik@Sun.COM [mailto:Dag.Wanvik@Sun.COM] 
> Gesendet: Freitag, 20. November 2009 19:54
> An: Derby Discussion
> Betreff: Re: AW: OOM with millions of weakly-referenced Derby objects
>
> Malte.Kempff@de.equens.com writes:
>
>> In other words I would count that situation as not nice behaviour of ij, since the
return code should have been given as I would suppose it looking at the method signature.
>
> Is this the API signature you are referring to?
>
> http://db.apache.org/derby/docs/10.5/publishedapi/jdbc4/org/apache/derby/tools/ij.html#runScript(java.sql.Connection,%20java.io.InputStream,%20java.lang.String,%20java.io.OutputStream,%20java.lang.String)
>
> It says:
>
> Returns:
>     Number of SQLExceptions thrown during the execution, -1 if not
>     known. 
>
> If so, are you seeing 0 or -1 returned here?
>
> Dag
>

-- 
Dag H. Wanvik, staff engineer
Sun Microsystems, Java Core and Desktop - Java DB/Derby
Haakon VII gt. 7b, N-7485 Trondheim, Norway
Tel: x43496/+47 73842196, Fax:  +47 73842101
Sun IM: dw136674, Yahoo IM: dag_h_wanvik

Hi all,

I'm trying to import data exported via PhpMyAdmin from MySQL. Now my SQL
Statements contain special characters like \r\n. Apache Derby seems to
filter them out. If I import that data I just get this characters
interpreted as normal text. So what I get is a string containing all
data without the  correct newlines. How can I tell Apache Derby to
interpret this text as special charaters?

Example:
INSERT INTO test (test) VALUES ('test\r\ntest');

The column's datatype is LONG VARCHAR. I used the 'Services' tab in
Netbeans IDE to import this data. A lot of research on google and the
reference manual didn't help. Please help :-)

Greetings
Sven S.

Malte.Kempff@de.equens.com writes:

> Yes this is the API I am reffering to.  Well actually it says that,
> but in my case it did not do it.  It needed a long time, several
> minutes. Reason as it turned later out, after getting the output in
> a file a lot of IOExcceptions. I never got those on windows nor on
> Solaris. Thr original logic of the routine calling the runScript
> Method was asking for the return code but either it never hit this
> if statement and crashed somewhere within ij without giving the
> Exception to the caller or ij gave something like 0 so the output
> never was given to the logger.  So there is something phony with
> ij.runScript using it with AIX 5.3 and a SQL-Script not coded UTF8
> but declaring in the parameters as UTF8. Of course that is a fault
> by my own, but it should tel me about it.

I looked at the implementation for runScript in
org.apache.derby.impl.tools.ij.utilMain#runScriptGuts and it does seem
to catch exceptions, count them and return them. Are you able to
provide a repro script showing that 0 or -1 is returned from runScript
for the failing scenario? 

Thanks,
Dag

>
>
>
> -----Ursprüngliche Nachricht-----
> Von: Dag.Wanvik@Sun.COM [mailto:Dag.Wanvik@Sun.COM] 
> Gesendet: Freitag, 20. November 2009 19:54
> An: Derby Discussion
> Betreff: Re: AW: OOM with millions of weakly-referenced Derby objects
>
> Malte.Kempff@de.equens.com writes:
>
>> In other words I would count that situation as not nice behaviour of ij, since the
return code should have been given as I would suppose it looking at the method signature.
>
> Is this the API signature you are referring to?
>
> http://db.apache.org/derby/docs/10.5/publishedapi/jdbc4/org/apache/derby/tools/ij.html#runScript(java.sql.Connection,%20java.io.InputStream,%20java.lang.String,%20java.io.OutputStream,%20java.lang.String)
>
> It says:
>
> Returns:
>     Number of SQLExceptions thrown during the execution, -1 if not
>     known. 
>
> If so, are you seeing 0 or -1 returned here?
>
> Dag
>

-- 
Dag H. Wanvik, staff engineer
Sun Microsystems, Java Core and Desktop - Java DB/Derby
Haakon VII gt. 7b, N-7485 Trondheim, Norway
Tel: x43496/+47 73842196, Fax:  +47 73842101
Sun IM: dw136674, Yahoo IM: dag_h_wanvik

Matt Doran wrote:
> Hi guys,
>
> It's 3 months since 10.5.3.0 and there appears to be a few nice fixes 
> lined up for a 10.5.3.1 (see link below).   Are there any plans for 
> rolling this release?
>
> https://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=true&pid=10594&fixfor=12314182

> <https://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=true&pid=10594&fixfor=12314182>

>
I have not heard of any plans for  an immediate release, but if you want 
to build it yourself to take advantage of the fixes, there should be no 
upgrade issues associated with using it or upgrading to the next release 
and we would appreciate the early feedback.

Thanks

Kathey