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. is it possible to make cursor as global or public in the form so i can use its data in more than location for testing like in buttons triggers. for example: if i declare the following cursor in "WHEN-NEW-FORM-INSTANCE" trigger CURSOR cur [More]
Since the "old" calendar will be de-activated next month, I will no longer be able to sync my first generation iPod Touch to the new calendar. I use the old calendar now on my intel iMacs, MacBook Pro, iPad 2 and my old iPod Touch. Everything wo [More]
Since i installed itunes 11.1 my airplay with Apple TV doesn't work properly. Music is only played for a while then nothing? Someone the same problem?The following article(s) may help you. Troubleshooting AirPlay Troubleshooting Wi-Fi networks and co [More]
I need to add namespace xmlns:prx="urn:sap.com:proxy:SB1:/1SAI/TAS04BED82951A661E02EC4:701:2008/06/06" to my xml document after doing a PI message mapping. When I run the following XSLT code in my XML editing software, it works as desired.  When [More]
Hi I am trying to get the smart url for doc attached to item. I reviewed the SDK documentation. However in 9.3.1 there is no getshortcut menu. Also i would like to arrive at the URL by the following method, which the sdk says its possible. http://ser [More]
I am on 8.1.14 SIA with OSES 11g installed on Windows 64-bit. I followed all the instructions. When I am indexing the Service requests, I can see couple of files getting placed in ssc\xmlidata and getting the SUC files to err folder. When I go to sch [More]
I get this error msg when someone tries to share a contact via MMS. Any suggestions?No idea, but post your question [here|http://discussions.apple.com/forum.jspa?forumID=1076].Read other 2 answers [More]
my calendar is synced with my hotmail/outlook account, and all of the Facebook birthdays are showing up as well. I want the Facebook information gone and can not for the life of me find where to do it. I've looked under the settings of the calendar/f [More]
Hi Why is the output of this being shown as 0? Sudnt this be shown as 10? public class AQuestion          private int i = giveMeJ();          private int j = 10;          private int giveMeJ()               return j;          public static void main( [More]
We are trying to open VIs saved in LabView version 5.1 with LabView version 8.5 and we are getting error code 10.  The error message states that version 5.1 is too old to be opened in version 8.5, yet on the knowledge base files seem to indicate that [More]