Unable to complete UserBuild example
The tut warns me of the Reference problems but it asks me for a derbyclient.jar-1 file which I cannot seem to get my hands on
The project builds but when I run it I get this
"""
init:
deps-jar:
compile:
run:
Error on url jdbc:derby://localhost:21527/sample
ERROR: SQLException: java.security.PrivilegedActionException : Error opening socket to server localhost on port 21527 with message : null
org.apache.derby.client.am.DisconnectException: java.security.PrivilegedActionException : Error opening socket to server localhost on port 21527 with message : null
at org.apache.derby.client.net.NetAgent.<init>(Unknown Source)
at org.apache.derby.client.net.NetConnection.newAgent_(Unknown Source)
at org.apache.derby.client.am.Connection.<init>(Unknown Source)
at org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at asg.databuild.DerbyLoginDB.createLoginDatabase(DerbyLoginDB.java:52)
at asg.databuild.DerbyLoginDB.<init>(DerbyLoginDB.java:38)
at asg.databuild.DerbyLoginDB.main(DerbyLoginDB.java:25)
BUILD SUCCESSFUL (total time: 0 seconds)
"""
I suppose to get the ffg output at somepoint "Login database was created" but I don't.
What is the problem?
Thanks!
[1542 byte] By [
new@sun] at [2007-11-26 8:46:01]
# 2
Thanks Sakthi it helped !
But there's sill one problem
Schema 'TRAVEL' does not exist
The ideal validation table exists only for connection validation purposes. Do not use an existing table that has a large number of rows or a table that will be frequently accessed.
i can't expand example database with message like this
any idea?
dElay at 2007-7-6 22:31:00 >
# 3
During Post-Installation the TRAVEL schema is supposed to get created. I don't know why it has failed for you.
By default, Derby has a sample database and APP schema. You could recteate travel schema using these steps:
+ Add a Derby DataSource with un/pw as dbadmin/dbadmin or app/app
+ Right Click and choose View Data
+ Click on Folder-Icon for Importing file containing SQL commands
+ Browse and Choose $Leopard_install/rave2.0/startup/samples/create-schema-Travel-derby.sql and Run SQL
Note: If ';' is the not SQL command terminator, you could set it by click on icon for 'Run Query Option'
+ Similary, you could run $Leopard_install/rave2.0/startup/samples/create-Travel-derby.sql
+ Also, JSC, VIR schema can be created using create-schema-jsc-derby.sql, create-jsc-derby.sql, create-schema-vir-derby.sql and create-vir-derby.sql
HTH,
Sakthi
# 5
Unfortunately I just find the travel database (create-Travel-derby.sql) under the location you explained:
> $Leopard_install/rave2.0/startup/samples/
To use the vehicle incident reporting (VIR) example, I need the create-schema-vir-derby.sql and the create-vir-derby.sql files.
Is there I place where I can download this two sql files?
Many thanks for your help.
Christian
