You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "John H. Embretsen (JIRA)" <ji...@apache.org> on 2007/11/07 16:03:50 UTC
[jira] Created: (DERBY-3187) SimpleApp (demo) does not work in a
client setting
SimpleApp (demo) does not work in a client setting
--------------------------------------------------
Key: DERBY-3187
URL: https://issues.apache.org/jira/browse/DERBY-3187
Project: Derby
Issue Type: Sub-task
Components: Demos/Scripts
Affects Versions: 10.3.1.4
Environment: derbyclient (no derby.jar in the classpath)
Reporter: John H. Embretsen
Assignee: John H. Embretsen
Since J2ME support was added to the simple demo (bin-releases: demo/programs/simple/SimpleApp.java) in DERBY-2216 (first available in 10.3.1.4), the demo has not worked in a pure client setting as described in the documentation (bin-releases: demo/programs/simple/example.html). This is a regression from 10.2.2.0.
$ export CLASSPATH=.:$DERBY_INSTALL/lib/derbyclient.jar
$ cd $DERBY_INSTALL/demo/programs/simple
10.2.2.0:
$ java SimpleApp derbyclient
SimpleApp starting in derbyclient mode.
Loaded the appropriate driver.
Connected to and created database derbyDB
Created table derbyDB
Inserted 1956 Webster
Inserted 1910 Union
Updated 1956 Webster to 180 Grand
Updated 180 Grand to 300 Lakeshore
Verified the rows
Dropped table derbyDB
Closed result set and statement
Committed transaction and closed connection
SimpleApp finished
10.3.1.4:
$ java SimpleApp derbyclient
Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/derby/jdbc/EmbeddedSimpleDataSource
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (DERBY-3187) SimpleApp (demo) does not work in a
client setting
Posted by "John H. Embretsen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
John H. Embretsen closed DERBY-3187.
------------------------------------
Verified the commit, and that SImpleApp now works in a pure client setting in 10.3. Case closed.
> SimpleApp (demo) does not work in a client setting
> --------------------------------------------------
>
> Key: DERBY-3187
> URL: https://issues.apache.org/jira/browse/DERBY-3187
> Project: Derby
> Issue Type: Sub-task
> Components: Demos/Scripts
> Affects Versions: 10.3.1.4
> Environment: derbyclient (no derby.jar in the classpath)
> Reporter: John H. Embretsen
> Assignee: John H. Embretsen
> Fix For: 10.3.1.5, 10.4.0.0
>
> Attachments: d3187-v01.diff
>
>
> Since J2ME support was added to the simple demo (bin-releases: demo/programs/simple/SimpleApp.java) in DERBY-2216 (first available in 10.3.1.4), the demo has not worked in a pure client setting as described in the documentation (bin-releases: demo/programs/simple/example.html). This is a regression from 10.2.2.0.
> $ export CLASSPATH=.:$DERBY_INSTALL/lib/derbyclient.jar
> $ cd $DERBY_INSTALL/demo/programs/simple
> 10.2.2.0:
> $ java SimpleApp derbyclient
> SimpleApp starting in derbyclient mode.
> Loaded the appropriate driver.
> Connected to and created database derbyDB
> Created table derbyDB
> Inserted 1956 Webster
> Inserted 1910 Union
> Updated 1956 Webster to 180 Grand
> Updated 180 Grand to 300 Lakeshore
> Verified the rows
> Dropped table derbyDB
> Closed result set and statement
> Committed transaction and closed connection
> SimpleApp finished
> 10.3.1.4:
> $ java SimpleApp derbyclient
> Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/derby/jdbc/EmbeddedSimpleDataSource
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DERBY-3187) SimpleApp (demo) does not work in a
client setting
Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Myrna van Lunteren resolved DERBY-3187.
---------------------------------------
Resolution: Fixed
Fix Version/s: 10.4.0.0
10.3.1.5
Backported the fix to 10.3 with revision 596793 (together with the fix for DERBY-3190).
> SimpleApp (demo) does not work in a client setting
> --------------------------------------------------
>
> Key: DERBY-3187
> URL: https://issues.apache.org/jira/browse/DERBY-3187
> Project: Derby
> Issue Type: Sub-task
> Components: Demos/Scripts
> Affects Versions: 10.3.1.4
> Environment: derbyclient (no derby.jar in the classpath)
> Reporter: John H. Embretsen
> Assignee: John H. Embretsen
> Fix For: 10.3.1.5, 10.4.0.0
>
> Attachments: d3187-v01.diff
>
>
> Since J2ME support was added to the simple demo (bin-releases: demo/programs/simple/SimpleApp.java) in DERBY-2216 (first available in 10.3.1.4), the demo has not worked in a pure client setting as described in the documentation (bin-releases: demo/programs/simple/example.html). This is a regression from 10.2.2.0.
> $ export CLASSPATH=.:$DERBY_INSTALL/lib/derbyclient.jar
> $ cd $DERBY_INSTALL/demo/programs/simple
> 10.2.2.0:
> $ java SimpleApp derbyclient
> SimpleApp starting in derbyclient mode.
> Loaded the appropriate driver.
> Connected to and created database derbyDB
> Created table derbyDB
> Inserted 1956 Webster
> Inserted 1910 Union
> Updated 1956 Webster to 180 Grand
> Updated 180 Grand to 300 Lakeshore
> Verified the rows
> Dropped table derbyDB
> Closed result set and statement
> Committed transaction and closed connection
> SimpleApp finished
> 10.3.1.4:
> $ java SimpleApp derbyclient
> Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/derby/jdbc/EmbeddedSimpleDataSource
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3187) SimpleApp (demo) does not work in a
client setting
Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12540820 ]
Myrna van Lunteren commented on DERBY-3187:
-------------------------------------------
I tested that code, with IBM's implementation (weme6.1 - which is CDCFoundation 1.1), and it worked fine.
I don't think an import statement by itself could cause a ClassDefNotFound, but the DriverManager class is referenced in the demo...
I understand it's up to the JVM to delay loading of classes or not.
So, to make this safe in all JVMs, I think a separate simple demo for the mobile platform sounds appropriate.
> SimpleApp (demo) does not work in a client setting
> --------------------------------------------------
>
> Key: DERBY-3187
> URL: https://issues.apache.org/jira/browse/DERBY-3187
> Project: Derby
> Issue Type: Sub-task
> Components: Demos/Scripts
> Affects Versions: 10.3.1.4
> Environment: derbyclient (no derby.jar in the classpath)
> Reporter: John H. Embretsen
> Assignee: John H. Embretsen
>
> Since J2ME support was added to the simple demo (bin-releases: demo/programs/simple/SimpleApp.java) in DERBY-2216 (first available in 10.3.1.4), the demo has not worked in a pure client setting as described in the documentation (bin-releases: demo/programs/simple/example.html). This is a regression from 10.2.2.0.
> $ export CLASSPATH=.:$DERBY_INSTALL/lib/derbyclient.jar
> $ cd $DERBY_INSTALL/demo/programs/simple
> 10.2.2.0:
> $ java SimpleApp derbyclient
> SimpleApp starting in derbyclient mode.
> Loaded the appropriate driver.
> Connected to and created database derbyDB
> Created table derbyDB
> Inserted 1956 Webster
> Inserted 1910 Union
> Updated 1956 Webster to 180 Grand
> Updated 180 Grand to 300 Lakeshore
> Verified the rows
> Dropped table derbyDB
> Closed result set and statement
> Committed transaction and closed connection
> SimpleApp finished
> 10.3.1.4:
> $ java SimpleApp derbyclient
> Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/derby/jdbc/EmbeddedSimpleDataSource
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3187) SimpleApp (demo) does not work in a
client setting
Posted by "John H. Embretsen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12540763 ]
John H. Embretsen commented on DERBY-3187:
------------------------------------------
I'm wondering how the DERBY-2216 J2ME change was tested in a J2ME environment in the first place. Wouldn't the statement "import java.sql.DriverManager" cause an error in a CDC environment? At least it fails (with NoClassDefFoundError: java.sql.DriverManager) with the phoneME cvm (CDC/FP), even if I make sure the check for J2ME (which in its current state is inadequate) is true.
Anyway, I am planning to fix this for 10.3.2 as part of a major overhaul of the simple demo (DERBY-3118). I'm currently considering two options:
1) Revert the J2ME changes introduced in DERBY-2216. Instead, we may create a separate simple demo for the mobile platform.
2) Always keep the datasource's static type as javax.sql.DataSource, which is available in all environments. When access to methods in EmbeddedSimpleDataSource is required (only in Java ME environments), do a cast from DataSource to EmbeddedSimpleDataSource, e.g. like this:
((org.apache.derby.jdbc.EmbeddedSimpleDataSource)ds).setCreateDatabase("create");
instead of this:
ds.setCreateDatabase("create");
Option 2 works (runtime errors in non-mobile environments are avoided), at least in the JVM's I've tried so far, but:
a) I'm not sure it will work in all "supported" JVMs (need to refresh and extend my Java spec knowledge a bit I guess).
b) The code looks less elegant, which partly defeats the purpose of a *simple* demo.
So I'm inclined to go for option 1.
Any opinions? Or does anyone have any other options we could use to solve this?
> SimpleApp (demo) does not work in a client setting
> --------------------------------------------------
>
> Key: DERBY-3187
> URL: https://issues.apache.org/jira/browse/DERBY-3187
> Project: Derby
> Issue Type: Sub-task
> Components: Demos/Scripts
> Affects Versions: 10.3.1.4
> Environment: derbyclient (no derby.jar in the classpath)
> Reporter: John H. Embretsen
> Assignee: John H. Embretsen
>
> Since J2ME support was added to the simple demo (bin-releases: demo/programs/simple/SimpleApp.java) in DERBY-2216 (first available in 10.3.1.4), the demo has not worked in a pure client setting as described in the documentation (bin-releases: demo/programs/simple/example.html). This is a regression from 10.2.2.0.
> $ export CLASSPATH=.:$DERBY_INSTALL/lib/derbyclient.jar
> $ cd $DERBY_INSTALL/demo/programs/simple
> 10.2.2.0:
> $ java SimpleApp derbyclient
> SimpleApp starting in derbyclient mode.
> Loaded the appropriate driver.
> Connected to and created database derbyDB
> Created table derbyDB
> Inserted 1956 Webster
> Inserted 1910 Union
> Updated 1956 Webster to 180 Grand
> Updated 180 Grand to 300 Lakeshore
> Verified the rows
> Dropped table derbyDB
> Closed result set and statement
> Committed transaction and closed connection
> SimpleApp finished
> 10.3.1.4:
> $ java SimpleApp derbyclient
> Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/derby/jdbc/EmbeddedSimpleDataSource
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3187) SimpleApp (demo) does not work in a
client setting
Posted by "John H. Embretsen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
John H. Embretsen updated DERBY-3187:
-------------------------------------
Derby Info: [Patch Available, Regression] (was: [Regression])
Note: The patch is for trunk, but I would like to get this into the 10.3 branch as well.
> SimpleApp (demo) does not work in a client setting
> --------------------------------------------------
>
> Key: DERBY-3187
> URL: https://issues.apache.org/jira/browse/DERBY-3187
> Project: Derby
> Issue Type: Sub-task
> Components: Demos/Scripts
> Affects Versions: 10.3.1.4
> Environment: derbyclient (no derby.jar in the classpath)
> Reporter: John H. Embretsen
> Assignee: John H. Embretsen
> Attachments: d3187-v01.diff
>
>
> Since J2ME support was added to the simple demo (bin-releases: demo/programs/simple/SimpleApp.java) in DERBY-2216 (first available in 10.3.1.4), the demo has not worked in a pure client setting as described in the documentation (bin-releases: demo/programs/simple/example.html). This is a regression from 10.2.2.0.
> $ export CLASSPATH=.:$DERBY_INSTALL/lib/derbyclient.jar
> $ cd $DERBY_INSTALL/demo/programs/simple
> 10.2.2.0:
> $ java SimpleApp derbyclient
> SimpleApp starting in derbyclient mode.
> Loaded the appropriate driver.
> Connected to and created database derbyDB
> Created table derbyDB
> Inserted 1956 Webster
> Inserted 1910 Union
> Updated 1956 Webster to 180 Grand
> Updated 180 Grand to 300 Lakeshore
> Verified the rows
> Dropped table derbyDB
> Closed result set and statement
> Committed transaction and closed connection
> SimpleApp finished
> 10.3.1.4:
> $ java SimpleApp derbyclient
> Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/derby/jdbc/EmbeddedSimpleDataSource
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3187) SimpleApp (demo) does not work in a
client setting
Posted by "John H. Embretsen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12544042 ]
John H. Embretsen commented on DERBY-3187:
------------------------------------------
Awesome, Myrna, thanks! :) I'll verify the commit and (hopefully) close this issue tomorrow. The same goes for DERBY-3190.
> SimpleApp (demo) does not work in a client setting
> --------------------------------------------------
>
> Key: DERBY-3187
> URL: https://issues.apache.org/jira/browse/DERBY-3187
> Project: Derby
> Issue Type: Sub-task
> Components: Demos/Scripts
> Affects Versions: 10.3.1.4
> Environment: derbyclient (no derby.jar in the classpath)
> Reporter: John H. Embretsen
> Assignee: John H. Embretsen
> Fix For: 10.3.1.5, 10.4.0.0
>
> Attachments: d3187-v01.diff
>
>
> Since J2ME support was added to the simple demo (bin-releases: demo/programs/simple/SimpleApp.java) in DERBY-2216 (first available in 10.3.1.4), the demo has not worked in a pure client setting as described in the documentation (bin-releases: demo/programs/simple/example.html). This is a regression from 10.2.2.0.
> $ export CLASSPATH=.:$DERBY_INSTALL/lib/derbyclient.jar
> $ cd $DERBY_INSTALL/demo/programs/simple
> 10.2.2.0:
> $ java SimpleApp derbyclient
> SimpleApp starting in derbyclient mode.
> Loaded the appropriate driver.
> Connected to and created database derbyDB
> Created table derbyDB
> Inserted 1956 Webster
> Inserted 1910 Union
> Updated 1956 Webster to 180 Grand
> Updated 180 Grand to 300 Lakeshore
> Verified the rows
> Dropped table derbyDB
> Closed result set and statement
> Committed transaction and closed connection
> SimpleApp finished
> 10.3.1.4:
> $ java SimpleApp derbyclient
> Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/derby/jdbc/EmbeddedSimpleDataSource
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3187) SimpleApp (demo) does not work in a
client setting
Posted by "John H. Embretsen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
John H. Embretsen updated DERBY-3187:
-------------------------------------
Attachment: d3187-v01.diff
Thanks Myrna for clarifying the difference in behavior between the VMs. Based on this information, I have decided to pursue option 1 for fixing this issue.
Attaching a patch d3187-v01.diff which reverts revision 497686, i.e. the changes introduced in DERBY-2216 to enable J2ME support in SimpleApp.java. The patch also updates LAST-MODIFIED meta information in java/demo/simple/example.html.
With this patch, the simple demo works in both the "embedded" and "derbyclient" environments as described in example.html.
I will create another Jira issue for adding a simple demo suitable for J2ME/Java ME platforms.
Please review/commit :)
> SimpleApp (demo) does not work in a client setting
> --------------------------------------------------
>
> Key: DERBY-3187
> URL: https://issues.apache.org/jira/browse/DERBY-3187
> Project: Derby
> Issue Type: Sub-task
> Components: Demos/Scripts
> Affects Versions: 10.3.1.4
> Environment: derbyclient (no derby.jar in the classpath)
> Reporter: John H. Embretsen
> Assignee: John H. Embretsen
> Attachments: d3187-v01.diff
>
>
> Since J2ME support was added to the simple demo (bin-releases: demo/programs/simple/SimpleApp.java) in DERBY-2216 (first available in 10.3.1.4), the demo has not worked in a pure client setting as described in the documentation (bin-releases: demo/programs/simple/example.html). This is a regression from 10.2.2.0.
> $ export CLASSPATH=.:$DERBY_INSTALL/lib/derbyclient.jar
> $ cd $DERBY_INSTALL/demo/programs/simple
> 10.2.2.0:
> $ java SimpleApp derbyclient
> SimpleApp starting in derbyclient mode.
> Loaded the appropriate driver.
> Connected to and created database derbyDB
> Created table derbyDB
> Inserted 1956 Webster
> Inserted 1910 Union
> Updated 1956 Webster to 180 Grand
> Updated 180 Grand to 300 Lakeshore
> Verified the rows
> Dropped table derbyDB
> Closed result set and statement
> Committed transaction and closed connection
> SimpleApp finished
> 10.3.1.4:
> $ java SimpleApp derbyclient
> Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/derby/jdbc/EmbeddedSimpleDataSource
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3187) SimpleApp (demo) does not work in a
client setting
Posted by "John H. Embretsen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12541574 ]
John H. Embretsen commented on DERBY-3187:
------------------------------------------
Absolutely, I agree that we should have some kind of demo with support for J2ME in 10.3 as well. I have a variant of SimpleApp for J2ME in my sandbox, and expect to attach it as a patch to DERBY-3190 soon. Would it be acceptable to get the new J2ME-demo into both trunk and 10.3, and then apply the modification to SimpleApp (this Jira issue) to 10.3 as well? No need to answer until the patch is posted... ;) Thanks for committing!
> SimpleApp (demo) does not work in a client setting
> --------------------------------------------------
>
> Key: DERBY-3187
> URL: https://issues.apache.org/jira/browse/DERBY-3187
> Project: Derby
> Issue Type: Sub-task
> Components: Demos/Scripts
> Affects Versions: 10.3.1.4
> Environment: derbyclient (no derby.jar in the classpath)
> Reporter: John H. Embretsen
> Assignee: John H. Embretsen
> Attachments: d3187-v01.diff
>
>
> Since J2ME support was added to the simple demo (bin-releases: demo/programs/simple/SimpleApp.java) in DERBY-2216 (first available in 10.3.1.4), the demo has not worked in a pure client setting as described in the documentation (bin-releases: demo/programs/simple/example.html). This is a regression from 10.2.2.0.
> $ export CLASSPATH=.:$DERBY_INSTALL/lib/derbyclient.jar
> $ cd $DERBY_INSTALL/demo/programs/simple
> 10.2.2.0:
> $ java SimpleApp derbyclient
> SimpleApp starting in derbyclient mode.
> Loaded the appropriate driver.
> Connected to and created database derbyDB
> Created table derbyDB
> Inserted 1956 Webster
> Inserted 1910 Union
> Updated 1956 Webster to 180 Grand
> Updated 180 Grand to 300 Lakeshore
> Verified the rows
> Dropped table derbyDB
> Closed result set and statement
> Committed transaction and closed connection
> SimpleApp finished
> 10.3.1.4:
> $ java SimpleApp derbyclient
> Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/derby/jdbc/EmbeddedSimpleDataSource
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3187) SimpleApp (demo) does not work in a
client setting
Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Myrna van Lunteren updated DERBY-3187:
--------------------------------------
Derby Info: [Regression] (was: [Regression, Patch Available])
I applied the patch to trunk with revision 593673, trusting that an overhaul of the demo will also address having a demo for the J2ME platform.
However, I have some concern applying it to 10.3 because the J2ME support was added on request and there's no alternative...
I think documentation on how to do client/server is more readily available than how to do J2ME, and would therefore to leave this in place in 10.3, even though it is not fully working.
> SimpleApp (demo) does not work in a client setting
> --------------------------------------------------
>
> Key: DERBY-3187
> URL: https://issues.apache.org/jira/browse/DERBY-3187
> Project: Derby
> Issue Type: Sub-task
> Components: Demos/Scripts
> Affects Versions: 10.3.1.4
> Environment: derbyclient (no derby.jar in the classpath)
> Reporter: John H. Embretsen
> Assignee: John H. Embretsen
> Attachments: d3187-v01.diff
>
>
> Since J2ME support was added to the simple demo (bin-releases: demo/programs/simple/SimpleApp.java) in DERBY-2216 (first available in 10.3.1.4), the demo has not worked in a pure client setting as described in the documentation (bin-releases: demo/programs/simple/example.html). This is a regression from 10.2.2.0.
> $ export CLASSPATH=.:$DERBY_INSTALL/lib/derbyclient.jar
> $ cd $DERBY_INSTALL/demo/programs/simple
> 10.2.2.0:
> $ java SimpleApp derbyclient
> SimpleApp starting in derbyclient mode.
> Loaded the appropriate driver.
> Connected to and created database derbyDB
> Created table derbyDB
> Inserted 1956 Webster
> Inserted 1910 Union
> Updated 1956 Webster to 180 Grand
> Updated 180 Grand to 300 Lakeshore
> Verified the rows
> Dropped table derbyDB
> Closed result set and statement
> Committed transaction and closed connection
> SimpleApp finished
> 10.3.1.4:
> $ java SimpleApp derbyclient
> Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/derby/jdbc/EmbeddedSimpleDataSource
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.