Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 52297 invoked from network); 9 Nov 2007 12:40:58 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 9 Nov 2007 12:40:58 -0000 Received: (qmail 31244 invoked by uid 500); 9 Nov 2007 12:40:44 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 31226 invoked by uid 500); 9 Nov 2007 12:40:44 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Delivered-To: moderator for derby-user@db.apache.org Received: (qmail 5049 invoked by uid 99); 9 Nov 2007 12:24:04 -0000 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,NORMAL_HTTP_TO_IP,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of moonblade.wolf@gmail.com designates 64.233.184.234 as permitted sender) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=DmKa6kophZ/cqs9XEyRvpV+RYCOF648ed9jdhlvywWk=; b=U0+jIatHxTsm0Qvjr8ag6Un1Z9uTuvmciaHGGiqjuXKSJKNpQLDhMJvkbJ7PcgWZfbNXnuPx75ylA0XTHApmbtuBpAPpw8bHps6b5AhbJ7QUPiAFK8uVT527E+7pQZ6SfNOnQS9lkuLjjxBnBWiNuaRN/L5A0kDAINgpLE+dXek= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=F0DcuFj/pbRTXuv+VgrYHRL1rMz8wltmMfBJWEvpKWh6opiU2ufF6lUEZaV9fCAxEDLaAfQj4OMZuORlOS2qHIuW+Vzlrxrd7LmfZqBFnsTjrnrxcx+pgasi3DR5WqnNHPuYUjb7CNTQH3tXkDwuiLgaEKhauL4z6ERhSNrqJRQ= Message-ID: <7b813ada0711090423m758630a9lc2f92c634ac42fc3@mail.gmail.com> Date: Fri, 9 Nov 2007 19:23:44 +0700 From: "Albert Kam" To: derby-user@db.apache.org Subject: Thank you Derby ! ( was : Error while importing csv files in Pocket PC ) MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_23520_22123431.1194611024895" X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_23520_22123431.1194611024895 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Dear Derby ! This posting was originally for seeking help for my error, but when i re-run it, everything is fine for now ! I was skeptic, and tried running it again, but the problem didnt happen anymore. Thanks derby, i owe you ! Hope to repay it someday. Here is the output of my command : preparing to ask file from server .. sending mydevice:send; to server receiving file from server file received : \sync\receive.zip file fetched from server in 3826 ms connection fetched in 12992 ms processing sql \sync\syncin\create.sql sql processing done in 5718 ms processing csv MST_MENU_STRUCTURE processing csv MST_POSITION processing csv MST_PRODUCT csv processing done in 42406 ms committing connection *Anyway, here goes the original mail i was gonna post, haha :* Dear lively Derby-Community, Hi all, my name is Albert Kam. I've been trying to find posts similar with i experience now, but with no luck. This is my first post. Hope could contribute a question that could be useful in the future >:) I've been trying to embed derby in my cdc java app for ppc, and so far it works great. Anyway, the queries, insert, create tables, etc works very well. The problem comes when trying to import csv files in the ppc device So i ran the program to sync db updates for the ppc using the command : "\J9\PPRO11\bin\j9.exe" "-jcl:ppro11" "-Xbootclasspath/a:\J9\PPRO11\examples\jsr169.jar" "-cp" "\J9\PPRO11\examples\sofco_pda.jar;\J9\PPRO11\examples\derby.jar;." " sync.SyncClient" "get" And these steps occur : 1. the java program in the ppc requests a zip file from a server via java socket 2. the ppc device gets the file, extracts the file 3. the extracted files, which consist of *.sql and *.csv are to be processed by the java 4. the sqls, which are create statements are processed fine by java + derby 5. when processing the csv files, the exception that is logged in derby.log: ---------------------------------------------------------------- 2007-11-09 08:09:50.230 GMT: Booting Derby version The Apache Software Foundation - Apache Derby - 10.3.1.4 - (561794): instance c013800d-0116-2375-2576-000005468cf7 on database directory \sync\distr Database Class Loader started - derby.database.classpath='' 2007-11-09 08:10:02.849 GMT Thread[main,5,main] (XID = 1822), (SESSIONID = 0), (DATABASE = distr), (DRDAID = null), Cleanup action starting 2007-11-09 08:10:02.851 GMT Thread[main,5,main] (XID = 1822), (SESSIONID = 0), (DATABASE = distr), (DRDAID = null), Failed Statement is: CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE (?,?,?,?,?,?,?) java.lang.UnsatisfiedLinkError: j9fdm23 ((14) Not enough storage is available to complete this operation.) at java.lang.ClassLoader.loadLibraryWithPath(Unknown Source) at java.lang.ClassLoader.loadLibraryWithClassLoader(Unknown Source) at java.lang.System.loadLibrary(Unknown Source) at java.lang.StrictMath$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Unknown Source) at java.lang.StrictMath.(Unknown Source) at java.lang.J9VMInternals.initializeImpl(Native Method) at java.lang.J9VMInternals.initialize(Unknown Source) at org.apache.derby.catalog.SystemProcedures.(Unknown Source) at java.lang.J9VMInternals.initializeImpl(Native Method) at java.lang.J9VMInternals.initialize(Unknown Source) at java.lang.Class.forNameImpl(Native Method) at java.lang.Class.forName(Unknown Source) at org.apache.derby.impl.services.reflect.DatabaseClasses.loadApplicationClass(Unknown Source) at org.apache.derby.iapi.services.loader.ClassInspector.getClass(Unknown Source) at org.apache.derby.iapi.services.loader.ClassInspector.accessible(Unknown Source) at org.apache.derby.impl.sql.compile.QueryTreeNode.verifyClassExist(Unknown Source) at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Unknown Source) at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(Unknown Source) at org.apache.derby.impl.sql.compile.CallStatementNode.bindStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.(Unknown Source) at org.apache.derby.jdbc.Driver169.newEmbedPreparedStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at sync.SyncClient.syncFromServerAndUpdate(Unknown Source) at sync.SyncClient.main(Unknown Source) Cleanup action completed I thought the storage is not enough, so i moved my app and derby to the 1G memory card storage, but the error persisted. Could it be the memory problem ? Thank you ! Albert Kam -- Do not pursue the past. Do not lose yourself in the future. The past no longer is. The future has not yet come. Looking deeply at life as it is in the very here and now, the practitioner dwells in stability and freedom. (Thich Nhat Hanh) ------=_Part_23520_22123431.1194611024895 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Dear Derby !
This posting was originally for seeking help for my error, but when i re-run it, everything is fine for now !
I was skeptic, and tried running it again, but the problem didnt happen anymore.
Thanks derby, i owe you ! Hope to repay it someday.

Here is the output of my command :
preparing to ask file from server ..
sending mydevice:send; to server
receiving file from server
file received : \sync\receive.zip file
fetched from server in 3826 ms
connection fetched in 12992 ms
processing sql \sync\syncin\create.sql
sql processing done in 5718 ms
processing csv MST_MENU_STRUCTURE
processing csv MST_POSITION
processing csv MST_PRODUCT csv
processing done in 42406 ms
committing connection

Anyway, here goes the original mail i was gonna post, haha :

Dear lively Derby-Community,

Hi all, my name is Albert Kam. I've been trying to find posts similar with i experience now, but with no luck.
This is my first post. Hope could contribute a question that could be useful in the future >:)

I've been trying to embed derby in my cdc java app for ppc, and so far it works great.
Anyway, the queries, insert, create tables, etc works very well.
The problem comes when trying to import csv files in the ppc device

So i ran the program to sync db updates for the ppc using the command :
"\J9\PPRO11\bin\j9.exe" "-jcl:ppro11" "-Xbootclasspath/a:\J9\PPRO11\examples\jsr169.jar" "-cp" "\J9\PPRO11\examples\sofco_pda.jar;\J9\PPRO11\examples\derby.jar;." " sync.SyncClient" "get"
And these steps occur :
1. the java program in the ppc requests a zip file from a server via java socket
2. the ppc device gets the file, extracts the file
3. the extracted files, which consist of *.sql and *.csv are to be processed by the java
4. the sqls, which are create statements are processed fine by java + derby
5. when processing the csv files, the exception that is logged in derby.log :
----------------------------------------------------------------
2007-11-09 08:09:50.230 GMT:
 Booting Derby version The Apache Software Foundation - Apache Derby - 10.3.1.4 - (561794): instance c013800d-0116-2375-2576-000005468cf7
on database directory \sync\distr 

Database Class Loader started - derby.database.classpath=''
2007-11-09 08:10:02.849 GMT Thread[main,5,main] (XID = 1822), (SESSIONID = 0), (DATABASE = distr), (DRDAID = null), Cleanup action starting
2007-11-09 08:10:02.851 GMT Thread[main,5,main] (XID = 1822), (SESSIONID = 0), (DATABASE = distr), (DRDAID = null), Failed Statement is: CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE (?,?,?,?,?,?,?)
java.lang.UnsatisfiedLinkError : j9fdm23 ((14) Not enough storage is available to complete this operation.)
    at java.lang.ClassLoader.loadLibraryWithPath(Unknown Source)
    at java.lang.ClassLoader.loadLibraryWithClassLoader(Unknown Source)
    at java.lang.System.loadLibrary(Unknown Source)
    at java.lang.StrictMath$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Unknown Source)
    at java.lang.StrictMath.<clinit>(Unknown Source)
    at java.lang.J9VMInternals.initializeImpl(Native Method)
    at java.lang.J9VMInternals.initialize(Unknown Source)
    at org.apache.derby.catalog.SystemProcedures.<clinit>(Unknown Source)
    at java.lang.J9VMInternals.initializeImpl (Native Method)
    at java.lang.J9VMInternals.initialize(Unknown Source)
    at java.lang.Class.forNameImpl(Native Method)
    at java.lang.Class.forName(Unknown Source)
    at org.apache.derby.impl.services.reflect.DatabaseClasses.loadApplicationClass (Unknown Source)
    at org.apache.derby.iapi.services.loader.ClassInspector.getClass(Unknown Source)
    at org.apache.derby.iapi.services.loader.ClassInspector.accessible(Unknown Source)
    at org.apache.derby.impl.sql.compile.QueryTreeNode.verifyClassExist (Unknown Source)
    at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Unknown Source)
    at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(Unknown Source)
    at org.apache.derby.impl.sql.compile.CallStatementNode.bindStatement (Unknown Source)
    at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
    at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
    at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement (Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
    at org.apache.derby.jdbc.Driver169.newEmbedPreparedStatement(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement (Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
    at sync.SyncClient.syncFromServerAndUpdate(Unknown Source)
    at sync.SyncClient.main(Unknown Source)
Cleanup action completed

I thought the storage is not enough, so i moved my app and derby to the 1G memory card storage, but the error persisted.
Could it be the memory problem ?

Thank you !
Albert Kam

--
Do not pursue the past. Do not lose yourself in the future.
The past no longer is. The future has not yet come.
Looking deeply at life as it is in the very here and now,
the practitioner dwells in stability and freedom.
(Thich Nhat Hanh) ------=_Part_23520_22123431.1194611024895--