Sidd Kulk

Hi guys,

I am using java.sql.SQLData interface to map my java objects to Oracle database types.

For example, I have an object type Person in Oracle DB defined as:
CREATE OR REPLACE TYPE PERSON AS OBJECT ( PERSON_ID NUMBER, PERSON_NAME VARCHAR2(100) );

Corresponding Java type is:

public class Person implements SQLData { private String sql_type = "PERSON"; private int personId; private String personName; public int getPersonId() { return personId; } public void setPersonId(int personId) { this.personId = personId; } public String getPersonName() { return personName; } public void setPersonName(String personName) { this.personName = personName; } public void readSQL(SQLInput stream, String typeName) throws SQLException { this.sql_type=typeName; this.personId = stream.readLong(); this.personName = stream.readString(); } public void writeSQL(SQLOutput stream) throws SQLException { stream.writeLong(this.personId); stream.writeString(this.personName); } }

This works fine currently and populates Person Objects from database type.

Now, I have a another type and it's corresponding collection as follows:

CREATE OR REPLACE TYPE SUBJECT AS OBJECT ( SUBJECT_ID NUMBER, SUBJECT_NAME VARCHAR2(100) ); -- Corresponding List CREATE OR REPLACE TYPE SUBJECT_LIST IS TABLE OF SUBJECT;

I have to create a new entry in type PERSON with this collection as follows:

CREATE OR REPLACE TYPE PERSON AS OBJECT ( PERSON_ID NUMBER, PERSON_NAME VARCHAR2(100), SUBJECT_LIST TYPE SUBJECT_LIST );

To make this change I have to change my java Person class. I tried adding java.sql.Array parameter but it is not working.

Can you please help here to map the new PERSON Object type to Java type?

Thanks in advance.

--Siddharth

Hi,

I am struggling with an ORA 21000 which says ORA-21000: error number argument to raise_application_error of 3739 is out of range.

This error is coming intermittently. I am not sure why this is occurring. This worked absolutely fine earlier, but after migrating to Linux from Solaris, this error has suddenly come up. Googling it didn't help. Please help.

Thanks in Advance.

Thanks Krishna. Are these books only for part-1?

I found books for the older exam, but those for the new one is difficult to find. Is the Mark Cade/Simon Roberts book only for part-1? Any help is appreciated.

Regards,
Siddharth

I hereby welcome the guests.

Thanks Deepak. My chief concern is books. I don't have a clue which book to go for.

Hi Javaranch,

I am starting the prep for SCEA 310-052, the latest exam available. What books/material do you suggest? I have done SCJP 1.5 and SCWCD certifications.

Regards,
Siddharth

David, you talked about some cleaner ways, can you please elaborate on that?

Ok, let me explain in detail what I am trying to do...

We are using Subversion as the code repository. What I observed in the large projects, having more than 15 programmers/developers working, that there are a lot of file merge issues. In ideal scenario, one should lock file and work, but that doesn't happen everytime, especially given the tight deadlines to deliver.

I thought of creating a web app, which could bring in the entire Subversion repository, and then users could enter comments at file and folder level to flag that node. The system would not enforce anything, but just show updates for each node. A user can flag a file or folder as locked, but it would be a notional and not a real flag. This is to be integrated in the developer's network. I have the SVN API in place.

The app is to be extended for user machines too, hence needs to be generic. This is more for learning and internal usage, but timelines given to me are like an actual project.

Thanks,
Sid

That would be a client dependent approach, won't it? Is it possible to build it without any client dependency? There is to be no program or configuration on client side.
My requirements sound demanding, but they have to be met!!

David, sorry if I sounded rude.

Web app is the only option I have got here. But what you say sounds interesting.

Can you please elaborate?

Thanks,
Sid

I am building an application to allow comments at file and folder level. This has a larger use in my application. Think of it like a social network for my file system.....

It is not for file upload exactly. It is basically for showing the client machine folder structure from which client can browse the directories and files.

I am not sure if this is the correct forum to post this query

In my Java based Web application, I want to access the client side directory structure. What are my options?

A quick google search suggested ActiveX, Applet etc. Any other options?

I guess I will download it and give it a try..

Anyone here know of some bug related to Tomcat 5 and Struts 2?