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
Hi, I need to store one variable value and I need to retrieve the same variable value in same program. For this I have written set and get parameter ids in the same program. It is working fine but if I log off the system and if I logon the system it [More]
Hi, I know this has been discussed before. But I could not find an answer. So, I'm putting it again. How can I find out the PID of an application, given the name of the application, on any OS? Regards.Call some operating system command via Runtime.ex [More]
Hello, i have a problem with FR and substitution variable. I create the substitution variable in Essbase for example antYear but i dont'see in dimension layout in FR studio and workspace. Thanks.You'll need to restart FR studio, after you have create [More]
Where to type the name of a song I want to buy, at store page nothing seems to be interactive. Thanks VladimirYou should have a search box at the top right of iTunes : When you are browsing the store that box searches the store, when you are looking [More]
Hi there, My Spotify was working fine on my Mac...however, I haven't been able to use it in about 3+ weeks. I've tried uninstalling and reinstalling. When I download, it always shows up "incomplete" in my "downloads" and, therefore, I [More]
My Daughter dropped her ipod and her screen is cracked!  can this be replaced?Apple will exchange your iPod for a refurbished one for this price. They do not fix yours. Price depends upon model and capacity Apple - iPod Repair price                   [More]
The following code fails in tomcat 6: <c:if test="${not empty requestScope.form && not empty requestScope.form.result}"> </c:if>but this one works fine: <c:if test="${not empty requestScope['form'] && not empt [More]
How do I get photos that are sent through Messages on an ipad mini to anywhere else? If I tap/hold on the photo, it says "Copy" but then I don't know where I could copy it to? Can someone help with this?Obviously the phone numbers must be linked [More]
My time capsule stopped backing up about when I started using Citrix. Is that an issue?No, it should not be.. however it might depend on the computer still being able to "see" local network resources while connected to the citrix server. You can [More]
I am trying to upload xml and xsl files by <xml> tag or by Javascript and never can reach them because of gateway problem. Suppose i have simple portlet.jsp file and them trying to upload XML resource like this: <xml id="source" src=&qu [More]