| Problems using JDeveloper with sybase [message #153849] |
Wed, 04 January 2006 06:51  |
mahendra.wadekar@hcl.in
Messages: 5
Registered: January 2006
Location: India
|
Junior Member |
|
|
Hi
I am using JDeveloper 10.1.2.1.0. When I make an application with JDeveloper using Oracle as Database then it works properly but when I make the same application with Sybase then it gives an error.
I am trying to create an application which simply edit a row of a table. Now when I go on the edit page then this message appears and no updation in data takes place on clicking commit button.
"Validation Error
You must correct the following error(s) before proceeding:
JBO-26044: Error while getting estimated row count for view object Product1View1, statement SELECT count(1) FROM (SELECT Product1.Group_id, Product1.isbn, Product1.Division_id, Product1.team_id, Product1.source_id, Product1.group_id1, Product1.pear_id, Product1.production_status_id, Product1.product_type_id, Product1.Discipline_id, Product1.prev_edition_isbn FROM dbo.product1 Product1) ESTCOUNT.
Incorrect syntax near the keyword 'SELECT'.
JBO-25058: Definition ImprintId of type Attribute not found in Product1View1 "
This problem comes only when I am using Sybase as database but not when Oracle is database.
I am using a table in database as described
Create Table product(
Group_id int Not Null,
Division_id int not null,
team_id int not null,
Discipline_id int not null,
source_id int not null,
group_id int not null,
pear_id int not null,
isbn varchar(13) primary key,
prev_edition_isbn varchar(13)not null,
production_status_id int not null,
product_type_id int not null,
)
Please help me.
Mahendra
|
|
|
|
| Re: Problems using JDeveloper with sybase [message #153851 is a reply to message #153849] |
Wed, 04 January 2006 06:54  |
mahendra.wadekar@hcl.in
Messages: 5
Registered: January 2006
Location: India
|
Junior Member |
|
|
Hi
I got some more problems while using sybase and JDeveloper
1. I had created an application which inserts/update data in to table in database. Now when I run this application then it gives an error that some another user has locked the row and you can not modify it while there is only one instance of the application is running.
2. If I am running an application from several machines then it creates connection with database at run time, perform the operation but doesn’t close the connection with database. So please tell me that how I can close the connection in database.
3. When I run any page by right clicking on it and selecting Run then it gives an error “500 Internal Server Error” and lot more.
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
