can't start Derby
Hi! I'm trying for the first time to create a connection pool in J2EE 1.4 Sun Java?System Application Server Platform Edition 8.2, following the Create Connection Pool wizard steps, with the following default parameters:
Resource type: javax.sql.ConnectionPoolDataSource
Data Source Class name: org.apache.derby.jdbc.ClientConnectionPoolDataSource
PortNumber: 1527
ServerName: localhost
But when I try to test the connection pool I've created and start the database using Start-All Programs-Sun Microsystems-ApplicationServer-Start Derby
I get CLI137 start-database command failed
What could be wrong? In the first page of the wizard I entered Database Vendor= Derby
[718 byte] By [
drholiday] at [2007-11-26 6:54:39]
# 2
I am not sure if it is true to say "starting database" has nothing to do with "connection pool".
If the connection pool refers to that database, the database should be up.
In 8.2PE, the log is stored in a file called "db.log" from where the asadmin start-database command was issued. Can you try something like below:
- open as MSDOS prompt window
- cd <82pe-install>\bin
- .\asadmin start-database
Then see what the "db.log" file in the same directory says.
This is the log file where database log is redirected.
Also, is the port 1527 available on the machine?
# 3
What I meant was,starting database has no relation to the connection pool. (I can always create the connection pool, then start the database and test/ping the pool).Yes, connection pool will work only when the database is running.
