[Users] jdbc errors
Steve Eastham
steve.eastham at gmail.com
Thu May 22 13:36:14 CDT 2008
After building the following build - cvs checkout -r b2008_04 ziptie_2008_04
Looks like it needed a new role named APP - I resolved this so that the
schema build piece is good (see below); I also made the change to the quartz
config.
org.quartz.jobStore.driverDelegateClass =
org.quartz.impl.jdbcjobstore.PostgreSQLDelegate
#org.quartz.jobStore.driverDelegateClass =
org.quartz.impl.jdbcjobstore.StdJDBCDelegate
Now when I try to start the server I'm receiving errors that I'm unable to
connect to the DB although it does exist; something new I need to do
regarding the jdbc connect string with this build?
./server.sh
Starting with Java options: -server -Xmx512m -Djava.io.tmpdir=tmp
-Dderby.system.home=derby -Djava.awt.headless=true
-Djava.library.path=/usr/lib:/usr/lib/jni:/usr/local/lib:/usr/local/lib/jni
Starting with OSGi options: -Dosgi.configuration.area=osgi-config
-Dosgi.noShutdown=true -Dosgi.install.area=./
Starting with arguments:
08-05-22 11:30:56,979 [Activator ] [Start Level Event
Dispatcher] INFO - ****************************************************
08-05-22 11:30:56,981 [Activator ] [Start Level Event
Dispatcher] INFO - * ZipTie Application Platform Starting *
08-05-22 11:30:56,981 [Activator ] [Start Level Event
Dispatcher] INFO - ****************************************************
2008-05-22 18:30:57.429::INFO: Logging to STDERR via
org.mortbay.log.StdErrLog
2008-05-22 18:30:57.460::INFO: jetty-6.1.x
2008-05-22 18:30:57.746::INFO: Started SslSocketConnector at 0.0.0.0:8080
08-05-22 11:30:58,016 [DerbyActivator ] [Start Level Event
Dispatcher] INFO - Starting Apache Derby Server
Apache Derby Network Server - 10.3.2.1 - (599110) started and ready to
accept connections on port 1527 at 2008-05-22 18:30:58.228 GMT
08-05-22 11:30:58,248 [itronixTransactionManager] [Start Level Event
Dispatcher] INFO - Bitronix Transaction Manager version ???
08-05-22 11:30:58,251 [Configuration ] [Start Level Event
Dispatcher] INFO - JVM unique ID: <ziptie-1>
08-05-22 11:30:58,268 [DiskJournal ] [Start Level Event
Dispatcher] WARN - active log file is unclean, previous server crash ?
08-05-22 11:30:58,270 [ResourceLoader ] [Start Level Event
Dispatcher] INFO - reading resources configuration from
osgi-config/bitronix-jta/btm-config.derby.properties
08-05-22 11:30:58,433 [ResourceLoader ] [Start Level Event
Dispatcher] WARN - unable to create resource with unique name ziptie-ds
bitronix.tm.resource.ResourceConfigurationException: cannot create JDBC
datasource named ziptie-ds
at
bitronix.tm.resource.jdbc.PoolingDataSource.init(PoolingDataSource.java:50)
at
bitronix.tm.resource.ResourceLoader.initXAResourceProducers(ResourceLoader.java:162)
at bitronix.tm.resource.ResourceLoader.init(ResourceLoader.java:133)
at bitronix.tm.resource.ResourceLoader.init(ResourceLoader.java:62)
at
bitronix.tm.BitronixTransactionManager.<init>(BitronixTransactionManager.java:47)
at
bitronix.tm.TransactionManagerServices.getTransactionManager(TransactionManagerServices.java:41)
at
org.ziptie.zap.jta.internal.JtaActivator.start(JtaActivator.java:66)
at
org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:999)
at java.security.AccessController.doPrivileged(Native Method)
at
org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:993)
at
org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:974)
at
org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346)
at
org.eclipse.osgi.framework.internal.core.AbstractBundle.start(AbstractBundle.java:260)
at
org.eclipse.osgi.framework.internal.core.AbstractBundle.start(AbstractBundle.java:252)
at org.ziptie.crates.CrateStarterElf.start(CrateStarterElf.java:270)
at
org.ziptie.crates.CrateStarterElf.activateBundles(CrateStarterElf.java:181)
at
org.ziptie.crates.CrateStarterElf.activateBundles(CrateStarterElf.java:207)
at
org.ziptie.zap.bootstrap.internal.Activator.start(Activator.java:90)
at
org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:999)
at java.security.AccessController.doPrivileged(Native Method)
at
org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:993)
at
org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:974)
at
org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346)
at
org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:350)
at
org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1118)
at
org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:634)
at
org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:508)
at
org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:282)
at
org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:468)
at
org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:195)
at
org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:297)
Caused by: java.sql.SQLNonTransientConnectionException: The connection was
refused because the database ziptie was not found.
at
org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown
Source)
at org.apache.derby.client.ClientPooledConnection.<init>(Unknown
Source)
at org.apache.derby.client.ClientXAConnection.<init>(Unknown Source)
at org.apache.derby.client.ClientXAConnection40.<init>(Unknown
Source)
at
org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newClientXAConnection(Unknown
Source)
at org.apache.derby.jdbc.ClientXADataSource.getXAConnectionX(Unknown
Source)
at org.apache.derby.jdbc.ClientXADataSource.getXAConnection(Unknown
Source)
at org.apache.derby.jdbc.ClientXADataSource.getXAConnection(Unknown
Source)
at
bitronix.tm.resource.jdbc.PoolingDataSource.createPooledConnection(PoolingDataSource.java:159)
at
bitronix.tm.resource.common.XAPool.createPooledObject(XAPool.java:200)
at bitronix.tm.resource.common.XAPool.<init>(XAPool.java:49)
at
bitronix.tm.resource.jdbc.PoolingDataSource.buildXAPool(PoolingDataSource.java:59)
at
bitronix.tm.resource.jdbc.PoolingDataSource.init(PoolingDataSource.java:48)
... 30 more
Caused by: org.apache.derby.client.am.DisconnectException: The connection
was refused because the database ziptie was not found.
at
org.apache.derby.client.net.NetConnectionReply.parseRDBNFNRM(Unknown Source)
at
org.apache.derby.client.net.NetConnectionReply.parseAccessRdbError(Unknown
Source)
at
org.apache.derby.client.net.NetConnectionReply.parseACCRDBreply(Unknown
Source)
at
org.apache.derby.client.net.NetConnectionReply.readAccessDatabase(Unknown
Source)
at
org.apache.derby.client.net.NetConnection.readSecurityCheckAndAccessRdb(Unknown
Source)
at
org.apache.derby.client.net.NetConnection.flowSecurityCheckAndAccessRdb(Unknown
Source)
at
org.apache.derby.client.net.NetConnection.flowUSRIDPWDconnect(Unknown
Source)
at org.apache.derby.client.net.NetConnection.flowConnect(Unknown
Source)
at org.apache.derby.client.net.NetConnection.initialize(Unknown
Source)
at org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
at org.apache.derby.client.net.NetConnection40.<init>(Unknown
Source)
at
org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newNetConnection(Unknown
Source)
at
org.apache.derby.client.net.NetXAConnection.createNetConnection(Unknown
Source)
at org.apache.derby.client.net.NetXAConnection.<init>(Unknown
Source)
at
org.apache.derby.client.ClientPooledConnection.getNetXAConnection(Unknown
Source)
[root at dnutlncm01 Build]# ant -Ddatabase=pgsql dbreset
Buildfile: build.xml
dbreset:
dbreset:
[exec] Resetting PostgreSQL database.
[exec] DROP DATABASE ziptie
[exec] DROP DATABASE
[exec] CREATE DATABASE ziptie ENCODING='UTF8'
[exec] CREATE DATABASE
[exec] Processing ../dist/server/sql/pgsql/device.sql.
[exec] psql:../dist/server/sql/pgsql/device.sql:11: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "persistent_key_gen_pkey" for
table "persistent_key_gen"
[exec] psql:../dist/server/sql/pgsql/device.sql:40: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "device_pk" for table
"device"
[exec] psql:../dist/server/sql/pgsql/device.sql:40: NOTICE: CREATE
TABLE / UNIQUE will create implicit index "unique_device" for table "device"
[exec] psql:../dist/server/sql/pgsql/device.sql:66: NOTICE: CREATE
TABLE will create implicit sequence "tag_tag_id_seq" for serial column
"tag.tag_id"
[exec] psql:../dist/server/sql/pgsql/device.sql:66: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "tag_pk" for table "tag"
[exec] psql:../dist/server/sql/pgsql/device.sql:66: NOTICE: CREATE
TABLE / UNIQUE will create implicit index "tag_tag_unique" for table "tag"
[exec] Processing ../dist/server/sql/pgsql/netman.sql.
[exec] psql:../dist/server/sql/pgsql/netman.sql:8: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "netman_pk" for table
"managed_network"
[exec] Processing ../dist/server/sql/pgsql/quartz.sql.
[exec] psql:../dist/server/sql/pgsql/quartz.sql:18: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "execution_history_pkey" for
table "execution_history"
[exec] psql:../dist/server/sql/pgsql/quartz.sql:37: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "qrtz_job_details_pkey" for
table "qrtz_job_details"
[exec] psql:../dist/server/sql/pgsql/quartz.sql:47: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "qrtz_job_listeners_pkey" for
table "qrtz_job_listeners"
[exec] psql:../dist/server/sql/pgsql/quartz.sql:70: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "qrtz_triggers_pkey" for
table "qrtz_triggers"
[exec] psql:../dist/server/sql/pgsql/quartz.sql:82: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "qrtz_simple_triggers_pkey"
for table "qrtz_simple_triggers"
[exec] psql:../dist/server/sql/pgsql/quartz.sql:93: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "qrtz_cron_triggers_pkey" for
table "qrtz_cron_triggers"
[exec] psql:../dist/server/sql/pgsql/quartz.sql:103: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "qrtz_blob_triggers_pkey" for
table "qrtz_blob_triggers"
[exec] psql:../dist/server/sql/pgsql/quartz.sql:113: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "qrtz_trigger_listeners_pkey"
for table "qrtz_trigger_listeners"
[exec] psql:../dist/server/sql/pgsql/quartz.sql:121: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "qrtz_calendars_pkey" for
table "qrtz_calendars"
[exec] psql:../dist/server/sql/pgsql/quartz.sql:128: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index
"qrtz_paused_trigger_grps_pkey" for table "qrtz_paused_trigger_grps"
[exec] psql:../dist/server/sql/pgsql/quartz.sql:145: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "qrtz_fired_triggers_pkey"
for table "qrtz_fired_triggers"
[exec] psql:../dist/server/sql/pgsql/quartz.sql:153: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "qrtz_scheduler_state_pkey"
for table "qrtz_scheduler_state"
[exec] psql:../dist/server/sql/pgsql/quartz.sql:159: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "qrtz_locks_pkey" for table
"qrtz_locks"
[exec] Processing ../dist/server/sql/pgsql/creds.sql.
[exec] psql:../dist/server/sql/pgsql/creds.sql:12: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "address_set_pkey" for table
"address_set"
[exec] psql:../dist/server/sql/pgsql/creds.sql:37: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "cred_config_pkey" for table
"cred_config"
[exec] psql:../dist/server/sql/pgsql/creds.sql:49: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "cred_set_pkey" for table
"cred_set"
[exec] psql:../dist/server/sql/pgsql/creds.sql:61: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index
"device_to_cred_set_mappings_pkey" for table "device_to_cred_set_mappings"
[exec] psql:../dist/server/sql/pgsql/creds.sql:73: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "creds_pkey" for table
"creds"
[exec] psql:../dist/server/sql/pgsql/creds.sql:91: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "protocol_config_pkey" for
table "protocol_config"
[exec] psql:../dist/server/sql/pgsql/creds.sql:106: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "protocols_pkey" for table
"protocols"
[exec] psql:../dist/server/sql/pgsql/creds.sql:118: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "protocol_props_pkey" for
table "protocol_props"
[exec] psql:../dist/server/sql/pgsql/creds.sql:132: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index
"device_to_protocol_mappings_pkey" for table "device_to_protocol_mappings"
[exec] Processing ../dist/server/sql/pgsql/tools.sql.
[exec] psql:../dist/server/sql/pgsql/tools.sql:17: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "tool_details_pkey" for table
"tool_details"
[exec] psql:../dist/server/sql/pgsql/tools.sql:29: NOTICE: CREATE
TABLE / PRIMARY KEY will create implicit index "plugin_exec_record_pkey" for
table "plugin_exec_record"
[exec] Processing ../dist/server/sql/pgsql/birt.sql.
[exec] Setting database property to pgsql.
[delete] Deleting directory /var/ziptie/dist/server/repository
[delete] Deleting directory /var/ziptie/dist/server/lucene
BUILD SUCCESSFUL
Total time: 1 second
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ziptie.org/pipermail/users/attachments/20080522/fd56398f/attachment-0001.html
More information about the Users
mailing list