Skip to Content
author's profile photo Former Member
Former Member

How to use a cofigured JDBC iView?

Hello,

I ghave configured an iView which implements a JDBC connection to my SQLServer, let's call it "myJDBC".

Can someone please show me a simple code example

(including relevant descriptors)of another iView which uses the JDBC iView in order to Query the Database and display the results?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 02, 2005 at 01:19 AM

    Hi Roy,

    If you want to display the results you can do that using table. Use PageProcessorComponent and JSP's.

    Have a method in the main java class which gets you the data from SQL Server. Create a system dsn and use the code

    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

    Connection con = DriverManager.getConnection( "jdbc:odbc:mydsn,"servername","poassword");

    Statement stmt = con.createStatement();

    ResultSet rs = stmt.executeQuery("select * from table");

    populate the values in the tableview model and display them in JSP.

    follow the examples in PDK, under TABLEVIEW control. Let me know if you need anything else.

    Thanks,

    Praveen

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 02, 2005 at 04:26 AM

    Hi,

    I assume by JDBC iView you mean that you have created a system that points to a database. <i>Not</i> JDBC iView as if you had created one of these you would already be able to configure the output at the time of the iView creation.

    What Praveen has said is correct one way is to do a custom development using JSP. (He makes it sound easy!).

    There are a number of options using the standard iViews provided out of the box rather than getting into java code.

    There are two types that are quite basic but easily configurable.

    They are JDBC Stored Procedure iView & Query iView.

    The stored procedure iView obviously requires a stored procedure on the database that provides a response.

    The iView creation wizard will enable you to be able to browse and select your stored procedure and for the query iView you should be able to select the tables etc and organise there output inside the wizard.

    If you have difficulty when creating these iViews check you configured the system correctly so make sure you follow the steps of:

    Create Alias on the system and Test connection

    Provided usrpwd details to DQE on the system.

    Configured your user mapping to the Alias using the personalize option on the portal header.

    Once you have this all working you might like to look at a bigger challenge and get unification iViews working...

    See Weblog :

    1-2-3 Drag&Relate (or D&R for dummies)

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Roy,

      In the system landscape editor open the system object that you have created on this object you have the options to display the property category of Distributed Query Engine. Select this option and enter the user/password for the database that you are connecting to (I suggest using sa access for initial testing.)

      Next select the User Management option and ensure that it is set to Admin\User.

      Now test the connection again from the system. If this still fails then post your connection string to the forum for me to see.

      What version\SP of the portal are you running?

      Cheers

      Daniel

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.