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 All, I am creating a SQL Server datasource in BW, the DB informaiton on sql server is:    Server : 10.58.0.28    DB Name:  master I have a user "dongb" created in that DB with administration authority. What I input by creating data source in [More]
An error pops up saying that the file isn't found and then when I link it to the file, the error says it isn't a valid itunes.msi file.  I had iTunes on my PC but it won't work properly so I am trying to re-install or update it.  Neither works.So I t [More]
  I am Purchasing a new MacBook Pro 13 2.5 Dual Core i5 with 8GB of Ram. My work is buying this so I get what I am getting.  I will be uploading Sporting events and editing them into 2 to 3 minute Highlight Videos. Should I use Imovie or Final cut Pr [More]
Hello, I am trying to update delta modification of replicated vendors vendor from R/3 to SRM via BBPGETVD. When we go to SLG1, there is an error stating "PSR : Function module ‘BBP_REMOTE_CLNT_CHECK’ is not available" where PSR is system name. I [More]
I 'upgraded' from Vista to Windows 7 and now iTunes won't recognize my phone or iPad. I have tried uninstalling and reinstalling iTunes; I have gone into device manager to check that the drivers for the phone are up-to-date and, apparently, they are. [More]
 Occurs only when using copy mode!Please follow the troubleshooting steps here: http://h10025.www1.hp.com/ewfrf/wc/document?docname=c02507634&tmp_task=solveCategory&cc=au&dlc=en&la... Although I am working on behalf of HP, I am speaking fo [More]
Is there any Database variable or function, which would return, whether a specific code is being called from a Workflow process or not ? For Ex: if the function fnd_global.user_id return a value other than -1, then the code is being executed from Ora [More]
Although my computer is set to and shows the 24-hour clock system, in the Calender it will only show 12 hour system. How can I change this? thanks for any help with this.Hope this helps. http://hints.macworld.com/article.php?story=20100810131325943 h [More]
There are four text feilds on a page with a search button and are all linked to a table. I am able to search data using these text feilds now, but what i want the application to do is, when i move the cursor from one field to anpther one the previous [More]
Hello, I am doing a proof of concept on IDM and am trying to import user data from MySQL table into IDM. I wrote an active sync adapter to do this so that whenever a new row is added to the MySQL table, the information is automatically fetched into I [More]