Sitemap

Amicuk Programming Answers

RMI & JDBC ResultSet

2015-10-11   Views:1

Advertisement

I am developing a project The basic archeiecture is like this: a reporting tool a virtualDB a real DB the reporting tool request for data from virtualDB, the virtualDB actually fetch the result for it. The virtualDB is a remote object using RMI which

I am developing a project
The basic archeiecture is like this:
a reporting tool
a virtualDB
a real DB
the reporting tool request for data from virtualDB, the virtualDB actually fetch the result for it.
The virtualDB is a remote object using RMI which can be called in the reporting tool(stub)
the virtualDB is connecting to the real DB through JDBC-ODBC driver.
Now comes the problem, when the virtualDB has the ResultSet which is return by JDBC-ODBC. I cannot pass the ResultSet from remote site to my reporting tool, at run time, it will throw NotSerializable Exception, I guess this is because the JDBC-ODBC ResultSet does not implement that interface.
So is there any way I can solve this problem to allow the reporting tool(client) receive the ResultSet that VirtualDB has got???
Thanks in advance, any comment would be a great help for me!!!

The replay answer
Advertisement
I can think of two ways:
I can unpack the resultset at the remote site, and repack them into a new ResultSet which implements the Serializble interface. However, in the case I still dont know how to let me client receive the new ResultSet, quite lost...
Another way, write all datas into XML, and pass the XML from remote site to reporting tool. It can work, but I want it to be efficient. This way is not efficient enough for me, I guess, and I do not want the overhead of creating XML.

Go to See the other 4 answers

RMI & JDBC ResultSet

Category:DefaultRelease time:2015-10-11Views:130

I am developing a project The basic archeiecture is like this: a reporting tool a virtualDB a real DB the reporting tool request for data from virtualDB, the virtualDB actually fetch the result for it. The virtualDB is a remote object using RMI which[More]

Problem with get ResultSet from rmi jdbc method. Help.

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am writing a rmi jdbc server. I got all the rmi methods working, but I am trying to get the data from the ResultSet. After the query, I set the fields in the serialiable class and return it back to the client. However, I noticed that it does ca[More]

BUG JSF h:dataTable with JDBC ResultSet - only last column is updated

Category:DefaultRelease time:2015-10-11Views:130

I tried to create updatable h:dataTable tag with three h:inputText columns with JDBC ResultSet as data source. But what ever I did I have seceded to update only the last column in h:dataTable tag. My JSF page is: <!DOCTYPE HTML PUBLIC "-//W3C//DTD[More]

How to implement paging on SQLSERVER JDBC ResultSet?

Category:DefaultRelease time:2015-10-11Views:130

Dear experts, Please show me somre tips to implement paging on an JDBC resultset? Thanks in advanced.JSP pagination ? how many records per page ?Read other 2 answers[More]

Using objects rather than jdbc resultset to fill reports

Category:DefaultRelease time:-0001-11-30Views:130

Hi buddies! I�m developing a small sample of application that generates reports using values retrieved from objects. The idea is simple, I have an arraylist of objects and want to fill my report which these objects atributes. Jasper Project API has a[More]

Pass a jdbc resultset in to a Stored Procedure

Category:DefaultRelease time:-0001-11-30Views:130

Any answer to the following question would be highly appreciated: How can we pass a jdbc resultset in to a Stored Procedure? Thanks.You could use Oracle's ANYDATASET type or declare schema TYPEs to support passing the data in a known structure. See "[More]

Casting a JDBC resultSet to VO RowSet?

Category:DefaultRelease time:-0001-11-30Views:130

Is it possible to somehow transform a plain vanilla jdbc ResultSet to a VO RowSet? (Of course without iterating!) Either by passing the entire object (with all rows intact) or by casting? Thanks -Nat PS. Rob, you know why I want to do this, right<g>[More]

NPE in com.mysql.jdbc.ResultSet

Category:DefaultRelease time:-0001-11-30Views:130

hi guys, config: Connector/J 3.1.11 - mysql 5.0 - java 1.5 is anybody has ever seen this exception?? Caused by: java.lang.NullPointerException         at com.mysql.jdbc.ResultSet.buildIndexMapping(ResultSet.java:597)         at com.mysql.jdbc.ResultS[More]

Creating XML from JDBC resultset

Category:DefaultRelease time:-0001-11-30Views:130

Can anyone give me a pointer as the best way to create XML from a JDBC resultset. I have told that XSU cannot be used as it is vendor specific and ties us to Oracle (yawn, yawn). Any ideas welcomed.import javax.xml.parsers.*; import org.w3.dom.*; imp[More]

Problem with clloudscape rmi jdbc driver

Category:DefaultRelease time:-0001-11-30Views:130

I am using Cloudscape rmi jdbc driver, where Cloudscape runs as a separate server. I am using WL6.1 running on Red Hat Linux 7.1. I defined a Cloudscape connection pool and data source. I have to start Cloudscape before WebLogic or I get the followin[More]

Problem with JDBC resultset

Category:DefaultRelease time:2015-10-11Views:130

Hello everyone: I'm using JDBC to connect to SQL Server, normally after executeQuery();, it should return me a opened BaseResultSet in order that i can read datas by stream(next(), getColumn(),etc...) but sometimes it returns a BaseResultSet closed.[More]

Hot
I have a Mac Pro OS 10.7.5 and have a DVD+R disc with files on it, but it ejects the disk after about 10 seconds--what to do?  How can I get the data off this disc?  I can see it has been already burned, so files are on there?Try cleaning the lens an [More]
HI gurs,        i want to design tag for pp module with some fields like profile no, order qty, sales order no, cut length etc. i want to take print that tag with data. for that i need to design in module pool or smart form or both. In my knowledge, [More]
Hiii..... !! well after the iOS 5 update , my iphone 4 is suffering some problems and i think they are some kinda bugs like slow processing, false notifications ( after deleting 2 mails from my inbox it still shows 5 mails sometimes), also i can't ac [More]
Hi all, Not sure whether anyone else is getting the same problem or not but I seem to have problems resuming after I installed the 2.0 software upgrade. For example if I am listening to music and I watch a video then return to listening music, the mu [More]
Hi, I need to pass a parameter into a page that will be used in a query inside a report region, e.g report region query is select link_id, page_id, menu_parent_id, link_text, link_url from portal_pages where page_id = :page_id So the page will displa [More]
Connected to internet. MAIL launches and window opens. Click on GET MAIL and a dialog box appears reading, "Enter Password for account(email address) The POP server "mail.accessbee.com" rejected the password for user (me) Please re-enter yo [More]
I'm trying to find intuitive software that will allow me to save to file a web site for future while online or if the host pulls the site and it's materials from the web. I want to use the sites for educational purposes and can't count on having stud [More]
Dear experts, I want to set up a stock transfer order scenario cross two SAP systems (and cross company code). The examples given in SAP documentation point to scenarios using a joint APO system. At the same time the documentation reads: The number o [More]
Hello. Im doing a project where I have to sort a large amount of data. The data is formed by a unique number and a location (a string). Something like this NUMBER .... CITY 1000123 BOSTON 1045333 HOUSTON 5234222 PARIS 2343345 PARIS 6234332 SEATTLE I [More]
HI Experts, I have come across few questions about the Role-based visibility for OBIEE reports and Dashboards. Can anyone please let me what exactly is this and if possible provide some pointers. Thanks in Advance. VRhave a look on page 137 and furth [More]