Re: Problem with OJB 1.0.3 and ORACLE 10
Armin Waibel <[email protected]>
| Newsgroups | gmane.comp.jakarta.ojb.user |
|---|---|
| Message-ID | <[email protected]> |
Hi Michele,
Fabbri Michele wrote:
> Hello everybody,
>
> I have a problem with an application using OJB and Oracle 10, the same
> application work fine with Oracle 9.
> OJB doesn't connect to the DBMS, I activate the log and I obtain the log
> under, have you any suggestion?
>
I think it's a typo:
> org.apache.ojb.broker.metadata.JdbcConnectionDescriptor@13ec758[
> jcd-alias=PEOPLE_DB
and
> Obtain broker from pool, used PBKey is org.apache.ojb.broker.PBKey:
> jcdAlias=PEOPLEDB, user=null, password=null
could this be the case?
regards,
Armin
> Thank a lot
>
> Michele Fabbri
>
> 2007-05-10 18:05:35,020 [http-8080-Processor24] DEBUG
> org.apache.ojb.broker.metadata.ConnectionRepository.addDescriptor(Connec
> tionRepository.java:129)
> New descriptor was added:
> org.apache.ojb.broker.metadata.JdbcConnectionDescriptor@13ec758[
> jcd-alias=PEOPLE_DB
> default-connection=true
> dbms=Oracle9i
> jdbc-level=2.0
> driver=oracle.jdbc.driver.OracleDriver
> protocol=jdbc
> sub-protocol=oracle
> db-alias=thin:@10.101.101.209:1521:reference
> user=fedb
> password=*****
> eager-release=false
> ConnectionPoolDescriptor={whenExhaustedAction=2, maxIdle=10,
> maxActive=1000, maxWait=5000, removeAbandoned=false,
> numTestsPerEvictionRun=10, testWhileIdle=false,
> minEvictableIdleTimeMillis=600000, testOnReturn=false,
> logAbandoned=false, removeAbandonedTimeout=300,
> timeBetweenEvictionRunsMillis=5000, testOnBorrow=true}
> batchMode=false
> useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE
> ignoreAutoCommitExceptions=false
>
> sequenceDescriptor=org.apache.ojb.broker.metadata.SequenceDescriptor@917
> cb0[
> sequenceManagerClass=class
> org.apache.ojb.broker.util.sequence.SequenceManagerNextValImpl
> Properties={autoNaming=true}
> ]
> ]
>
> 2007-05-10 18:05:35,021 [http-8080-Processor24] INFO
> org.apache.ojb.broker.metadata.RepositoryPersistor.readConnectionReposit
> ory(RepositoryPersistor.java:203)
> Read connection repository took 91 ms
>
> 2007-05-10 18:05:35,050 [http-8080-Processor24] INFO
> org.apache.ojb.broker.metadata.ConnectionRepository.getDescriptor(Connec
> tionRepository.java:73)
> Could not find org.apache.ojb.broker.metadata.JdbcConnectionDescriptor
> for PBKey org.apache.ojb.broker.PBKey: jcdAlias=PEOPLEDB, user=null,
> password=null
>
> 2007-05-10 18:05:35,055 [http-8080-Processor24] DEBUG
> org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl.createPer
> sistenceBroker(PersistenceBrokerFactoryDefaultImpl.java:86)
> Obtain broker from pool, used PBKey is org.apache.ojb.broker.PBKey:
> jcdAlias=PEOPLEDB, user=null, password=null
>
>
>
>
> The repository xml file is:
>
> <?xml version="1.0" encoding="UTF-8"?>
>
> <!DOCTYPE descriptor-repository PUBLIC
> "-//Apache Software Foundation//DTD OJB Repository//EN"
> "repository.dtd"
> [
>
> <!ENTITY internal SYSTEM "repository_internal.xml">
> ]>
>
>
> <descriptor-repository version="1.0" isolation-level="read-uncommitted">
> <!-- PEOPLE_DB Oracle -->
>
> <jdbc-connection-descriptor
> jcd-alias="PEOPLE_DB"
> default-connection="true"
> platform="Oracle9i"
> jdbc-level="2.0"
> driver="oracle.jdbc.driver.OracleDriver"
> protocol="jdbc"
> subprotocol="oracle"
> dbalias="thin:@10.101.101.209:1521:reference"
> username="fedb"
> password="reference"
> useAutoCommit="1"
> maxWait="20000">
> <connection-pool maxActive="1000" maxIdle="10"
> whenExhaustedAction="2"
> testOnBorrow="true"
> timeBetweenEvictionRunsMillis="5000"/>
> <sequence-manager
> className="org.apache.ojb.broker.util.sequence.SequenceManagerNextValImp
> l">
> <attribute attribute-name="autoNaming"
> attribute-value="true"/>
> </sequence-manager>
> </jdbc-connection-descriptor>
>
> <!--
> ************************************************************************
> ************************************************************************
> ***************************-->
> <!--
> *************************************************************
> Process*****************************************************************
> ***************************-->
> <!--
> ************************************************************************
> ************************************************************************
> ***************************-->
> <class-descriptor
> class="it.people.process.data.PplPersistentData"
> table="PENDING_PROCESS">
> <field-descriptor id="1" name="oid" column="OID"
> jdbc-type="BIGINT"
> primarykey="true"
>
> conversion="it.people.core.persistence.converters.sql.LongConverter"
> autoincrement="true"/>
> <field-descriptor id="2" name="userID" column="USER_ID"
> jdbc-type="VARCHAR"/>
> <field-descriptor id="3" name="commune"
> column="COMMUNE_ID" jdbc-type="VARCHAR"
> conversion="it.people.core.persistence.converters.sql.CommuneConverter"/
> <field-descriptor id="4" name="processData"
> column="PROCESS_VALUE" jdbc-type="CLOB"
> conversion="it.people.core.persistence.converters.sql.ClobConverter"/>
> <field-descriptor id="5" name="processClass"
> column="PROCESS_CLASSNAME" jdbc-type="VARCHAR"
> conversion="it.people.core.persistence.converters.sql.ClassNameConverter
> "/>
> <field-descriptor id="6" name="lastModifiedTime"
> column="LAST_MODIFIED_TIME" jdbc-type="TIMESTAMP"
> conversion="it.people.core.persistence.converters.sql.DateConverter"/>
> <field-descriptor id="7" name="creationTime"
> column="CREATION_TIME" jdbc-type="TIMESTAMP"
> conversion="it.people.core.persistence.converters.sql.DateConverter"/>
> <field-descriptor id="8" name="sent" column="SENT"
> jdbc-type="BIGINT"
> conversion="it.people.core.persistence.converters.sql.BooleanConverter"/
> <field-descriptor id="9" name="status" column="STATUS"
> jdbc-type="BIGINT"
> conversion="it.people.core.persistence.converters.sql.StatusConverter"/>
> <field-descriptor id="10" name="contentName"
> column="CONTENT_NAME" jdbc-type="VARCHAR"/>
> <field-descriptor id="11" name="contentID" column="CONTENT_ID"
> jdbc-type="VARCHAR"/>
> <field-descriptor id="12" name="processName"
> column="PROCESS_NAME" jdbc-type="VARCHAR"/>
> <field-descriptor id="13" name="processDataID"
> column="PROCESS_DATA_ID" jdbc-type="VARCHAR"/>
>
> <collection-descriptor name="principal"
> element-class-ref="it.people.core.PplPrincipal" auto-update="true"
> auto-delete="true">
> <inverse-foreignkey field-id-ref="1"/>
> </collection-descriptor>
>
> <collection-descriptor name="delegate"
> element-class-ref="it.people.core.PplDelegate" auto-update="true"
> auto-delete="true">
> <inverse-foreignkey field-id-ref="1"/>
> </collection-descriptor>
> </class-descriptor>
>
> <!-- PENDING_PROCESS_ACL -> PplPrincipal -->
> <class-descriptor class="it.people.core.PplPrincipal"
> table="PENDING_PROCESS_ACL">
> <field-descriptor id="1" name="oid" column="PROCESS_ID"
> jdbc-type="BIGINT" primarykey="true"
> conversion="it.people.core.persistence.converters.sql.LongConverter"/>
> <field-descriptor id="2" name="userID" column="USER_ID"
> jdbc-type="VARCHAR" primarykey="true"/>
> <field-descriptor id="3" name="role" column="ROLE"
> jdbc-type="VARCHAR" primarykey="true"
> conversion="it.people.core.persistence.converters.sql.PplRoleConverter"/
> </class-descriptor>
>
> <!-- PENDING_PROCESS_DELEGATE -> PplDelegate -->
> <class-descriptor class="it.people.core.PplDelegate"
> table="PENDING_PROCESS_DELEGATE">
> <field-descriptor id="1" name="oid"
> column="PROCESS_ID" jdbc-type="BIGINT" primarykey="true"/>
> <field-descriptor id="2" name="ownerID"
> column="USER_ID" jdbc-type="VARCHAR" primarykey="true"/>
> <field-descriptor id="3" name="delegateID"
> column="DELEGATE_ID" jdbc-type="VARCHAR" primarykey="false"/>
> </class-descriptor>
>
> <!-- PROCESS_DELEGATE -> PplProcessDelegate -->
> <class-descriptor class="it.people.core.PplProcessDelegate"
> table="PROCESS_DELEGATE">
> <field-descriptor id="1" name="oid"
> column="OID" jdbc-type="BIGINT" primarykey="true"
> autoincrement="true"/>
> <field-descriptor id="2" name="processName"
> column="PROCESS_CLASSNAME" jdbc-type="VARCHAR" primarykey="false"/>
> <field-descriptor id="3" name="communeId"
> column="COMMUNE_ID" jdbc-type="VARCHAR" primarykey="false"/>
> <field-descriptor id="4" name="userId"
> column="USER_ID" jdbc-type="VARCHAR" primarykey="false"/>
> <field-descriptor id="5" name="delegateId"
> column="DELEGATE_ID" jdbc-type="VARCHAR" primarykey="false"/>
> <field-descriptor id="6" name="validFrom"
> column="VALID_FROM" jdbc-type="TIMESTAMP" primarykey="false"
> conversion="it.people.core.persistence.converters.sql.DateConverter"/>
> <field-descriptor id="7" name="validTo"
> column="VALID_TO" jdbc-type="TIMESTAMP" primarykey="false"
> conversion="it.people.core.persistence.converters.sql.DateConverter"/>
> </class-descriptor>
>
> <class-descriptor class="it.people.City" table="COMMUNE">
> <field-descriptor id="1" name="oid" column="OID"
> jdbc-type="VARCHAR" primarykey="true"/>
> <field-descriptor id="2" name="name" column="NAME"
> jdbc-type="VARCHAR"/>
> <field-descriptor id="3" name="label" column="LABEL"
> jdbc-type="VARCHAR"/>
> <field-descriptor id="4" name="aooPrefix"
> column="AOOPREFIX" jdbc-type="VARCHAR"/>
> </class-descriptor>
>
> <class-descriptor class="it.people.process.SubmittedProcess"
> table="SUBMITTED_PROCESS">
> <field-descriptor id="1" name="oid" column="OID"
> jdbc-type="BIGINT" primarykey="true"
> conversion="it.people.core.persistence.converters.sql.LongConverter"
> autoincrement="true"/>
> <field-descriptor id="2" name="editableProcessId"
> column="EDITABLE_PROCESS_ID" jdbc-type="BIGINT"
> conversion="it.people.core.persistence.converters.sql.LongConverter"/>
> <field-descriptor id="3" name="user" column="USER_ID"
> jdbc-type="VARCHAR"
> conversion="it.people.core.persistence.converters.sql.UserConverter"/>
> <field-descriptor id="4" name="peopleProtocollId"
> column="PEOPLE_PROTOCOL_ID" jdbc-type="VARCHAR"/>
> <field-descriptor id="5" name="communeProtocollId"
> column="COMMUNE_PROTOCOL_ID" jdbc-type="VARCHAR"/>
> <field-descriptor id="6" name="transportTrackingNumber"
> column="TRANSPORT_TRACKINGNUMBER" jdbc-type="VARCHAR"/>
> <field-descriptor id="7" name="commune"
> column="COMMUNE_ID" jdbc-type="VARCHAR"
> conversion="it.people.core.persistence.converters.sql.CommuneConverter"/
> <field-descriptor id="8" name="submittedTime"
> column="SUBMITTED_TIME" jdbc-type="TIMESTAMP"
> conversion="it.people.core.persistence.converters.sql.DateConverter"/>
> <field-descriptor id="9" name="completed"
> column="COMPLETED" jdbc-type="BIGINT"
> conversion="it.people.core.persistence.converters.sql.BooleanConverter"/
>
> <collection-descriptor name="historyState"
> element-class-ref="it.people.process.SubmittedProcessHistory"
> auto-update="true" auto-delete="true">
> <inverse-foreignkey field-id-ref="1"/>
> </collection-descriptor>
>
> <collection-descriptor name="processInformation"
> element-class-ref="it.people.process.SubmittedProcessInformation"
> auto-update="true" auto-delete="true">
> <inverse-foreignkey field-id-ref="1"/>
> </collection-descriptor>
>
> <reference-descriptor
> name="persistentData"
>
> class-ref="it.people.process.data.PplPersistentData"
> auto-retrieve="true" auto-delete="false"
> auto-update="false" >
> <foreignkey field-id-ref="2" />
> </reference-descriptor>
> </class-descriptor>
>
> <class-descriptor
> class="it.people.process.SubmittedProcessHistory"
> table="SUBMITTED_PROCESS_HISTORY">
> <field-descriptor id="1" name="oid"
> column="SBMT_PROCESS_ID" jdbc-type="BIGINT" primarykey="true"
> conversion="it.people.core.persistence.converters.sql.LongConverter"/>
> <field-descriptor id="2" name="transactionTime"
> column="TRANSACTION_TIME" jdbc-type="TIMESTAMP" primarykey="true"
> conversion="it.people.core.persistence.converters.sql.DateConverter"/>
> <field-descriptor id="3" name="state" column="STATUS_ID"
> jdbc-type="BIGINT"
> conversion="it.people.core.persistence.converters.sql.SubmittedProcessSt
> ateConverter"/>
> </class-descriptor>
>
> <class-descriptor
> class="it.people.process.SubmittedProcessInformation"
> table="SUBMITTED_PROCESS_INFO">
> <field-descriptor id="1" name="oid"
> column="SBMT_PROCESS_ID" jdbc-type="BIGINT" primarykey="true"
> conversion="it.people.core.persistence.converters.sql.LongConverter"/>
> <field-descriptor id="2" name="key"
> column="INFORMATION_KEY" jdbc-type="VARCHAR" primarykey="true"/>
> <field-descriptor id="3" name="path"
> column="INFORMATION_PATH" jdbc-type="VARCHAR" />
> <field-descriptor id="4" name="marshalledData"
> column="INFORMATION_VALUE" jdbc-type="CLOB"
> conversion="it.people.core.persistence.converters.sql.ClobConverter"/>
> </class-descriptor>
>
> <!-- ConfigSenderProcess -->
> <class-descriptor class="it.people.process.config.ConfigSender"
> table="CONFIGSENDERPROCESS">
> <field-descriptor id="1" name="commune"
> column="COMMUNE_ID" jdbc-type="VARCHAR" primarykey="true"/>
> <field-descriptor id="2" name="process"
> column="PROCESS_NAME" jdbc-type="VARCHAR" primarykey="true"/>
> <field-descriptor id="3" name="className"
> column="CLASSNAME" jdbc-type="VARCHAR" primarykey="false"
> conversion="it.people.core.persistence.converters.sql.ClassNameConverter
> "/>
> <field-descriptor id="4" name="mailAddress"
> column="MAILADDRESS" jdbc-type="VARCHAR" primarykey="false"/>
> <field-descriptor id="5" name="pickupPassword"
> column="PICKUPPASSWORD" jdbc-type="VARCHAR" primarykey="false"/>
> <field-descriptor id="6" name="dummyPassword"
> column="DUMMY_PASSWORD" jdbc-type="VARCHAR" primarykey="false"/>
> </class-descriptor>
>
> <!--
> ************************************************************************
> ************** -->
> <!-- Gestione categorie
> **************************************************************
>
> ************************************************************************
> ************** -->
> <class-descriptor class="it.people.content.CategoryImpl"
> table="CATEGORY">
> <field-descriptor id="1" name="oid" column="OID"
> jdbc-type="BIGINT" primarykey="true"
> conversion="it.people.core.persistence.converters.sql.LongConverter"
> autoincrement="true"/>
> <field-descriptor id="2" name="name" column="NAME"
> jdbc-type="VARCHAR" />
> <field-descriptor id="3" name="label" column="LABEL"
> jdbc-type="VARCHAR" />
>
> <collection-descriptor name="child"
> element-class-ref="it.people.content.CategoryAbstractImpl"
> auto-update="true" auto-delete="true" auto-retrieve="true"
> refresh="true" indirection-table="CHILDCATEGORY">
> <inverse-foreignkey field-id-ref="1"/>
> <fk-pointing-to-this-class column="PARENT_ID"/>
> <fk-pointing-to-element-class column="CAT_ID"/>
> </collection-descriptor>
>
> <collection-descriptor name="process"
> element-class-ref="it.people.content.ContentImpl" auto-update="true"
> auto-delete="true" auto-retrieve="true">
> <inverse-foreignkey field-id-ref="1"/>
> </collection-descriptor>
> </class-descriptor>
>
> <class-descriptor class="it.people.content.CategoryAbstractImpl"
> table="CATEGORY">
> <field-descriptor id="1" name="oid" column="OID"
> jdbc-type="BIGINT" primarykey="true"
> conversion="it.people.core.persistence.converters.sql.LongConverter"/>
> </class-descriptor>
>
> <class-descriptor class="it.people.content.ContentImpl"
> table="CONTENTCATEGORY">
> <field-descriptor id="1" name="oid" column="CAT_ID"
> jdbc-type="BIGINT" primarykey="true"
> conversion="it.people.core.persistence.converters.sql.LongConverter"/>
> <field-descriptor id="2" name="key" column="CONTENT_KEY"
> jdbc-type="VARCHAR" primarykey="true"/>
> <field-descriptor id="3" name="name"
> column="CONTENT_NAME" jdbc-type="VARCHAR"/>
> <field-descriptor id="4" name="processClass"
> column="PROCESS_CLASS" jdbc-type="VARCHAR"
> conversion="it.people.core.persistence.converters.sql.ClassNameConverter
> "/>
> <field-descriptor id="5" name="processName"
> column="PROCESS_NAME" jdbc-type="VARCHAR" />
> </class-descriptor>
>
>
> <class-descriptor
> class="it.people.process.sign.SignedDataHolder" table="SIGNSTEPS">
> <field-descriptor id="1" name="stepOid"
> column="STEP_OID" primarykey="true" jdbc-type="VARCHAR"/>
> <field-descriptor id="2" name="parentOid"
> column="PROCESS_OID" jdbc-type="BIGINT" primarykey="true"
> conversion="it.people.core.persistence.converters.sql.LongConverter"/>
> <field-descriptor id="3" name="fileName"
> column="FILE_NAME" jdbc-type="VARCHAR"/>
> <field-descriptor id="4" name="filePath"
> column="FILE_PATH" jdbc-type="VARCHAR"/>
> </class-descriptor>
>
> <!-- puo essere cancellata -->
> <class-descriptor class="it.people.process.sign.StepSign"
> table="PROCESS_STEPS">
> <field-descriptor id="1" name="oid" column="OID"
> primarykey="true" jdbc-type="BIGINT"
> conversion="it.people.core.persistence.converters.sql.LongConverter"/>
> <field-descriptor id="2" name="processName"
> column="PROCESS_NAME" jdbc-type="VARCHAR"/>
> <field-descriptor id="3" name="orderNumber"
> column="ORDER_NUMBER" jdbc-type="BIGINT"
> conversion="it.people.core.persistence.converters.sql.LongConverter"/>
> <field-descriptor id="4" name="jsp" column="JSP_PATH"
> jdbc-type="VARCHAR"/>
> <field-descriptor id="5" name="help" column="HELP_PATH"
> jdbc-type="VARCHAR"/>
> <field-descriptor id="3" name="active" column="ACTIVE"
> jdbc-type="BIGINT"
> conversion="it.people.core.persistence.converters.sql.BooleanConverter"/
> </class-descriptor>
>
>
> <!-- USER_PROFILE -->
> <class-descriptor class="it.people.core.PplUser"
> table="USER_PROFILE">
> <field-descriptor id="1" name="userID" column="USER_ID"
> primarykey="true" jdbc-type="VARCHAR"/>
> <field-descriptor id="2" name="EMail" column="E_MAIL"
> jdbc-type="VARCHAR"/>
> <field-descriptor id="3" name="userName"
> column="USER_NAME" jdbc-type="VARCHAR"/>
>
> <collection-descriptor name="adminCommuni"
> element-class-ref="it.people.core.PplAdminCommune" auto-update="true"
> auto-delete="true" auto-retrieve="true">
> <inverse-foreignkey field-id-ref="1"/>
> </collection-descriptor>
> </class-descriptor>
>
> <!-- AMMINISTRATORE_COMMUNE -->
> <class-descriptor class="it.people.core.PplAdminCommune"
> table="AMMINISTRATORE_COMMUNE">
> <field-descriptor id="1" name="userID" column="USER_ID"
> primarykey="true" jdbc-type="VARCHAR"/>
> <field-descriptor id="2" name="communeID"
> column="COMMUNE_ID" primarykey="true" jdbc-type="VARCHAR"/>
> </class-descriptor>
>
> <!-- SERVICE_PROFILE -->
> <class-descriptor class="it.people.core.ServiceProfileStore"
> table="SERVICE_PROFILE">
> <field-descriptor id="1" name="processName"
> column="PROCESS_NAME" primarykey="true" jdbc-type="VARCHAR"
> autoincrement="false"/>
> <field-descriptor id="2" name="profile" column="PROFILE"
> jdbc-type="CLOB"/>
> </class-descriptor>
>
> <!-- include mappings for JUnit tests here -->
> <!-- include ojb internal mappings here -->
> &internal;
>
> <!-- user data of farAway db -->
> </descriptor-repository>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>