You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Fabbri Michele <M....@cedaf.it> on 2007/05/10 18:19:22 UTC
Problem with OJB 1.0.3 and ORACLE 10
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?
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: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: Problem with OJB 1.0.3 and ORACLE 10
Posted by Armin Waibel <ar...@apache.org>.
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: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org