aplaws-devel

[Aplaws-devel] [aplaws - Developing on APLAWS+] Adding supporting for derby (or equivalent)

[Aplaws D. L. <apl...@li...>]

Read and respond to this message at: 
https://sourceforge.net/forum/message.php?msg_id=7409510
By: terry_permeance

A while back, I managed to get Derby integrated to the point of creating the
tables but since it requires stored procedures to be written in Java, I never
finished it.  I also tried hsqldb but it's sql dialect was too limited. I thought
about using Firebird (http://www.firebirdsql.org/) but its not Java so might
require some JNI magic to embed it inside the JVM.

Any volunteers if I commit my preliminary Derby changes?

Terry

______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit: 
https://sourceforge.net/forum/unmonitor.php?forum_id=368401

[Aplaws-devel] [aplaws - Developing on APLAWS+] RE: Adding supporting for derby (or equivalen

[Aplaws D. L. <apl...@li...>]

Read and respond to this message at: 
https://sourceforge.net/forum/message.php?msg_id=7409719
By: terry_permeance

To clarify, I got to creating the tables for ccm-core only.

I've committed what I got up to into /contrib/permeance/derby.

Step 1. Set up ecdc.

Step 2. Add the following to integration.properties:

waf.admin.name.screen=admin
waf.web.server=localhost\:8080
waf.runtime.jdbc_url=jdbc\:derby\:runtime/db/derby/ccm;create=true
waf.kernel.primary_user_identifier=screen_name

Step 3. ant load-bundle

D:\workspaces\aplaws\derby>ant load-bundle
Buildfile: build.xml
     [echo] Project base directory is D:\workspaces\aplaws\derby
     [echo] web.xml file requested: web.xml-aplaws

prepare-load:
     [echo] prepare bundle
D:\workspaces\aplaws\derby/ccm-ldn-aplaws/bundles/devel
     [copy] Copying 1 file to D:\workspaces\aplaws\derby
   [delete] Deleting: D:\workspaces\aplaws\derby\.tmp.applications.cfg

load-bundle:
     [echo] Loading bundle D:\workspaces\aplaws\derby/ccm-ldn-aplaws/bundles/devel
into D:\workspaces\aplaws\derby/runtime/apache-tomcat-6.0.18
     [java] CHECK: The database type is recognized
     [java] CHECK: The Oracle JDBC driver is available
     [java] CHECK: The ccm-core package is configured.
     [java] CHECK: The JDBC URL parameter is set.
     [java] CHECK: The database is accepting connections
     [java] CHECK: JAAS is available
     [java] CHECK: JCE is available
     [java] 2009-05-26 12:46:47,984 [ main] INFO  packaging.Loader - Loading
schema for ccm-core
     [java] 2009-05-26 12:46:53,490 [ main] INFO  runtime.Startup - Initializing
WAF runtime
     [java] 2009-05-26 12:46:53,676 [ull) ] INFO  runtime.Startup - Initialization
complete
     [java] 2009-05-26 12:46:53,676 [ull) ] INFO  packaging.Loader - Running
initializer com.arsdigita.core.Initializer
     [java] com/arsdigita/notification/Notification.pdl: line 37, column 10
[warning]: table already has primary key:
com/arsdigita/notification/Notification.pdl: line 35, column 4
     [java] com/arsdigita/notification/Notification.pdl: line 38, column 10
[warning]: table already has primary key:
com/arsdigita/notification/Notification.pdl: line 35, column 4
     [java]
     [java] java.lang.ExceptionInInitializerError
     [java]    
at com.arsdigita.kernel.Initializer.doStartup(Initializer.java:63)
     [java]    
at com.arsdigita.kernel.BaseInitializer$1.excurse(BaseInitializer.java:53)
     [java]    
at com.arsdigita.kernel.KernelExcursion.run(KernelExcursion.java:60)
     [java]    
at com.arsdigita.kernel.BaseInitializer.startup(BaseInitializer.java:56)
     [java]     at com.arsdigita.initializer.Script.startup(Script.java:236)
     [java]     at com.arsdigita.initializer.Script.startup(Script.java:207)
     [java]    
at com.arsdigita.runtime.LegacyInitializer.init(LegacyInitializer.java:137)
     [java]    
at com.arsdigita.runtime.CompoundInitializer.init(CompoundInitializer.java:142)
     [java]     at com.arsdigita.core.Initializer.init(Initializer.java:163)
     [java]    
at com.arsdigita.runtime.CompoundInitializer.init(CompoundInitializer.java:142)
     [java]     at com.arsdigita.runtime.Startup.run(Startup.java:242)
     [java]     at com.arsdigita.packaging.Loader.loadData(Loader.java:149)
     [java]     at com.arsdigita.packaging.Load.run(Load.java:401)
     [java]     at com.arsdigita.packaging.MasterTool.main(MasterTool.java:119)
     [java] Caused by: java.lang.RuntimeException: Couldn't find column name
for privilege - admin
     [java]    
at com.arsdigita.kernel.permissions.PrivilegeDescriptor.<init>(PrivilegeDescript
or.java:267)
     [java]    
at com.arsdigita.kernel.permissions.PrivilegeDescriptor.<clinit>(PrivilegeDescri
ptor.java:54)
     [java]     ... 14 more
     [java] Java Result: 1

This is expected if you look in ccm-core/sql/ccm-core/derby-create.sql you'll
see quite a few lines commented out, e.g.

--\i default/kernel/package-parties_denormalization.sql
--\i default/kernel/trigger-acs_parties.sql

because we need to rewrite packages and triggers in Java.




______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit: 
https://sourceforge.net/forum/unmonitor.php?forum_id=368401

[Aplaws-devel] [aplaws - Developing on APLAWS+] RE: Adding supporting for derby (or equivalent)

[Aplaws D. L. <apl...@li...>]

Read and respond to this message at: 
https://sourceforge.net/forum/message.php?msg_id=7409821
By: pboy

Hi Terry,

I suppose it is quite a demanding untertaking to get it running. Perhaps Brett
can help out. He managed to implement support for MS SQL for APLAWS (and will
provide his patches as soon as he can spare time) and has experiences with that
problem domain.


Peter



______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge.net and visit: 
https://sourceforge.net/forum/unmonitor.php?forum_id=368401