Hi!
I am having a very weird problem with Oracle 9.0.1, using OJB 0.9.9 runing under
Solaris, Linux and Windows.
This is the problem:
1 I am inserting a new record on the database, the insert is indeed succesfull,
I can check it using SQL Plus
2. Two fields are the numeric values 1 and 0 -I hard coded the values just for
debug purposes. But the values in Oracle are 1.0000000000786 and the 0 is a
0.0000000000000786 WHY??!!!
3. The fields in the database (assigned_to and message) are NUMBER(5), I even
try with a plain NUMBER and no matter what, I can not fix it!! Other fields of
the same type does not present this problem!
4. The extract of the repository_user.xml and the repository.xml is below .
5. I am using the defaults parameters of OJB 0.9.9
6. I am using the last jdbc driver for Oracle and Java 1.4
Thanks in advance!!
Gerardo
PS. Under Sybase 11.9.2 the system work perfectly!!
PS2. I try to check the user list, but the search is not working properly.
The repository_user is:
<class-descriptor
class="com.unify.webcenter.data.tasksData"
table="tasks"
>
<field-descriptor id="1"
name="owner"
column="owner"
jdbc-type="INTEGER"
/>
<field-descriptor id="2"
name="project"
column="project"
jdbc-type="INTEGER"
/>
bla bla
<field-descriptor id="5"
name="assigned_to"
column="assigned_to"
jdbc-type="INTEGER"
/>
other fields...
<field-descriptor id="26"
name="message"
column="message"
jdbc-type="INTEGER"
/>
<field-descriptor id="27"
name="real_due_date"
column="real_due_date"
jdbc-type="TIMESTAMP"
/>
<field-descriptor id="28"
name="predecessor"
column="predecessor"
jdbc-type="INTEGER"
/>
<field-descriptor id="29"
name="predecessor_required"
column="predecessor_required"
jdbc-type="CHAR"
/>
<reference-descriptor name="parentAssigned"
class-ref="com.unify.webcenter.data.membersData"
refresh="true">
<foreignkey field-id-ref = "5"/>
</reference-descriptor>
<reference-descriptor name="parentProject"
class-ref="com.unify.webcenter.data.projectsData"
refresh="true">
<foreignkey field-id-ref = "2"/>
</reference-descriptor>
<collection-descriptor name="assignmentsList"
element-class-ref="com.unify.webcenter.data.assignmentsData"
refresh="true" auto-delete="true">
<inverse-foreignkey field-id-ref ="2"/>
</collection-descriptor>
</class-descriptor>
The extract of the repository.xml is:
<jdbc-connection-descriptor
platform="Oracle"
jdbc-level="2.0"
driver="oracle.jdbc.driver.OracleDriver"
protocol="jdbc"
subprotocol="oracle"
dbalias="thin:@10.1.1.157:1521:auto"
username="automotriz"
password="re4562"
/>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
