Eclipse Community Forums: scout » New Derby Database

Help

Home

Home » Eclipse Projects » scout » New Derby Database(unable to access data from newly created database)

Show: Today's Messages :: Show Polls :: Message Navigator

New Derby Database [message #781051]

Fri, 20 January 2012 03:45

Jeff Hoare
Messages: 3
Registered: January 2012

Junior Member

Hi,

I have followed the minicrm tutorial and this works great I can access the database and the application works as expected. I now want to create my own application and have created a new derby database for this purpose.

The problem is that when I try to run the application I just get a general processing error with no detail. If I create the table with data in the minicrm example database and change the connection settings on my project then the application works and I can retrieve data. If I connect to the new database from the command line using the derby tools then I can access data and run a select on the database table and get data back ok.

I have checked all the obvious things I can think of; database name and location is correct as is username/password.

Is it possible to enable more extensive logging other than the console that would perhaps indicate why it's failing, or alternatively are there any common things that I may have overlooked.

I have attached the console log which does have a error, but I'm not familiar with what its referring too by the error "at $Proxy8.getRouterPasswordData(Unknown Source)"

Regards Jeff

Attachment: error.txt
(Size: 4.26KB, Downloaded 107 times)

Report message to a moderator

Re: New Derby Database [message #781066 is a reply to message #781051]

Fri, 20 January 2012 05:13

Bruno Köferli
Messages: 8
Registered: January 2012

Junior Member

Hi Jeff

It seems that something on the server part is wrong. The attached console log is from the client and shows a general error message which normally occures due to server errors during server calls. The "real" exception can be found in the server log.

More details about Scout client - server communication can be found under Concepts/Communication in Scout wiki.

Regards
Bruno

Report message to a moderator

Re: New Derby Database [message #781076 is a reply to message #781066]

Fri, 20 January 2012 07:04

Jeremie Bresson
Messages: 262
Registered: October 2011

Senior Member

Bruno Köferli wrote on Fri, 20 January 2012 11:13

More details about Scout client - server communication can be found under Concepts/Communication in Scout wiki.

Link to the page: http://wiki.eclipse.org/Scout/Concepts/Communication

[Updated on: Fri, 20 January 2012 07:04]

Report message to a moderator

Re: New Derby Database [message #781208 is a reply to message #781076]

Fri, 20 January 2012 15:19

Jeff Hoare
Messages: 3
Registered: January 2012

Junior Member

Hi,

Thanks for the pointers, it seems that the error is caused by the version of derby I have used version 10.8 is the latest, but this is incompatible with the current version of software (Caused by: java.sql.SQLException: Database at C:\configDB has an incompatible format with the current version of the software. The database was created by or upgraded by version 10.8.). Does this mean I must use (I think that the example uses version 10.2) or is there an alternative?

Regards jeff

Report message to a moderator

Re: New Derby Database [message #781248 is a reply to message #781208]

Fri, 20 January 2012 16:33

Jeff Hoare
Messages: 3
Registered: January 2012

Junior Member

Hi,

Ok I found the dependency on version 5.3.0 of derby in the plugin.xml file for the server, so I have recreated the database using this version of the database software and all works as expected. If I want to use the latest version is there a preferred way to accomplish this? Do I simply replace the derby.jar file in the scout derby plugin library (as its seems the version are backward compatible) or is there a better way to do this. Sorry for the confusion on my part I assumed that the derby.jar file I place in the java lib directory was being used.

Regards Jeff

Report message to a moderator

Re: New Derby Database [message #781300 is a reply to message #781248]

Fri, 20 January 2012 17:59

Jeremie Bresson
Messages: 108
Registered: November 2010

Senior Member

Having a lib folder, adding jars like lib/derby.jar and adding them to the class-path is how JAVA SE works.
Eclipse uses OSGi to manage dependencies at runtime.

I do not know why Eclipse Scout uses an old version of derby...

For more information on jdbc connection bundle, read this how-to:
http://wiki.eclipse.org/Scout/HowTo/Write_a_jdbc_connection_bundle

Report message to a moderator

Re: New Derby Database [message #789808 is a reply to message #781248]

Fri, 03 February 2012 07:34

Jeremie Bresson
Messages: 262
Registered: October 2011

Senior Member

Jeff Hoare wrote on Fri, 20 January 2012 22:33

If I want to use the latest version is there a preferred way to accomplish this? Do I simply replace the derby.jar file in the scout derby plugin library (as its seems the version are backward compatible) or is there a better way to do this.

Change request to upgrade the version of Derby: Bugzilla 370544

Report message to a moderator

Re: New Derby Database [message #809462 is a reply to message #789808]

Tue, 28 February 2012 17:44

Andreas Hoegger
Messages: 133
Registered: February 2010

Senior Member

Updated Derby JDBC driver to Version 10.8.2.2.
SVN: http://dev.eclipse.org/svnroot/technology/org.eclipse.scout/scout.rt/trunk/org.apache.derby.jdbc_1082.fragment
Target release: 3.8

For early birds the current new version can be checked out from svn. Do not forget to update your product files with the newer version.

-andreas

Report message to a moderator

Previous Topic:	Hello World Swing Client not showing up?
Next Topic:	Authentication on Tomcat

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 23 11:59:01 EDT 2013