[Users] jdbc errors
Brett Wooldridge
bwooldridge at alterpoint.com
Fri May 23 11:27:24 CDT 2008
Steve,
Are you fixed now?
-Brett
On 5/23/08 3:36 AM, "Steve Eastham" <steve.eastham at gmail.com> wrote:
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 <http://SslSocketConnector@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 <http://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/20080523/304a2237/attachment-0001.html
More information about the Users
mailing list