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
It appears that accessing the USB port in the Airport Express is not very open and is only intended for printers. What I would like, and I would think would be nice for a lot of people, is to be able to put a usb-rs232 converter there and have softwa [More]
Hi, Every few requests, the proxy plugin seg faults. The following backtrace is logged: [Sun Sep 26 06:26:16 2010] [notice] child pid 28254 exit signal Segmentation fault (11) *** glibc detected *** /usr/sbin/httpd: free(): invalid pointer: 0x00002b2 [More]
Can we block the sales order after creating ? If how to do. Thanks nareshHi Naresh If you want to block the sales order then go to >Header -- shipping tab There u will find the column of delivery block there u put any reason. This way u block the sal [More]
Auteur : Corinne Ribeyre-F085785 à _CARPO04 I need help with OLE Automation implementation (Excel, CrystalReport,Word ...) I generate Excel project with OleGen but no documentation exist for this project. So I made severals tests (with Excel). I can [More]
Instead of making it into the dialouge box i am currently doing, how would i switch it to show in the actual output field area? import java.awt.*; import java.awt.event.*; import javax.swing.*; public class untitled1 extends JFrame private int alpha, [More]
I try to export it in many different ways, but evertime I try either iMovie shots down or the progress ends up with an error. I am using the latest version of iMovie 11 version 9.0.8. How can I solve this? I even tried deleting a few iMovie files fro [More]
I use Outlook for my contacts. Evidently, I changed something and now my computer no longer has my contacts. They are on my iphone and iCloud. Any ideas? I am new to this cloud stuff.I was seeing a similar issue and what I found was that iCloud was s [More]
Hi, if is possible I want know how to get data from MySQL DB to Adobe Edge....Thx a millionIs it possible to get the data from the database into something else first? It seems that you will have to do a database query first using coldfusion or php. I [More]
All, Whether any report is there is std SAP where I can get , Actual delivery period for a certain item and PO due period for that particular material .? In ME2M , I searched , but this report is not there . Can anyone suggest a better way of finding [More]
Hi, for some reason, i have created many frames but this particular one displays the title (information) puts a jbutton next to it and then 2 more underneath and 2 more under that. I wanted it sort of list form where title appears at top then 2 next [More]