Hello! I've just returned from OpenWorld and after attending Paul's session on web development there, I am thoroughly intrigued by FormSpider. The session did make it sound easy to use but I haven't coded in Forms since '97 although I currently write PL/SQL and am an OCP DBA. I know little to nothing about the mid-tier (Apache) and am not sure what I need to do. Here is where I'm starting: Windows 7 client talking to a RHEL 5.x w/ Apache running. Database is Oracle 11gR2. I've just downloaded the FormSpider windows .exe. I plan on installing it on my windows client (it's where I do my development w/ SQL Developer, sqlplus, etc.). What then? Are there step by step instructions on how to install and how to use the API calls that I can use/learn?

Thanks! I hope this works because ApEx and ADF Faces look inefficient for a single DBA/Developer like me.

-Thom

asked 10 Oct '11, 12:33

throwi's gravatar image

throwi
122
accept rate: 0%


Hi Thom,

Thank you very much for your interest in Formspider. After you install Formspider, I recommend you to take a look at our learning center at http://theformspider.com/learningcenter/ . We have many tutorials and videos to get you started. The learning center is by no means complete but we add new tutorials every week. If you have a question that you can't find an answer for just ask us here or email us at support at gerger.co and we will help you immediately.

Welcome to the world of Formspider. I hope you will like it as much as we do. :-)

Best

Yalim

link

answered 10 Oct '11, 22:27

Yalim%20K.%20Gerger's gravatar image

Yalim K. Gerger ♦♦
1914
accept rate: 20%

Thanks Yalim. I know very little about the mid-tier pieces. I'm not sure what I need to do to get Apache Tomcat to communicate w/ the database layer. Any simple advice you can provide to get me going would be great.

Also, is the FormSpider software a client piece or is there a server component?

Thanks,

Thom

link

answered 11 Oct '11, 11:02

throwi's gravatar image

throwi
122
accept rate: 0%

Hi Thom,

There are two ways you can start experimenting with Formspider.

  1. You can download the Formspider Installer from here. This is something I believe you already have done. Run the installer and it will install everything you need to work with Formspider to your PC including an Apache Tomcat Server. The installer will also set everything up correctly and your Tomcat will talk to your Oracle Database. All you need to do is to provide the connection information.

  2. If you want to start immediately, you can sign up to Formspider Online. At Formspider Online, we will set up everything for you instantly. Using the Formspider Online IDE you can build your user interfaces. We will also provide you an online database schema that you can connect with your favorite PL/SQL editor to write your application logic.

Does this answer your question?

link

answered 11 Oct '11, 12:25

Yalim%20K.%20Gerger's gravatar image

Yalim K. Gerger ♦♦
1914
accept rate: 20%

edited 11 Oct '11, 12:27

It does. Thank you. We're building a mid-tier VM to install the Linux FormSpider w/ Tomcat. I think that will get us started! Look for more posts from this newbie later!

Thom

link

answered 11 Oct '11, 13:25

throwi's gravatar image

throwi
122
accept rate: 0%

Cool. Let us know when there is anything we can help with. Looking forward to hearing from you.

link

answered 12 Oct '11, 06:47

Yalim%20K.%20Gerger's gravatar image

Yalim K. Gerger ♦♦
1914
accept rate: 20%

Hello again! I don't want to double post but we're stuck trying to get the IDE to launch. We get errors that we cannot resolve or understand.

We installed Apache Tomcat on a Linux VM. We ran the .jar on the Linux web server (including moving the .war file). We then ran the windows installer on my Windows 7 client and did not check the Mid Tier checkbox (but did the other 3). We successfully ran the Database and DB IDE components as well as installed the IDE locally on my system. Launching the IDE on my Windows 7 PC fails to work.

After reviewing the Linux installation steps, there are a few steps that look like they need manual effort (Installing database components, Installing Formspider IDE sections)... we assumed these were done by the Windows Installer remotely. I did look to see if the Oracle directory was created and it was not. Could it be that we've messed up the steps? what should we do?

Thanks,

Thom

link

answered 13 Oct '11, 15:37

throwi's gravatar image

throwi
122
accept rate: 0%

Hi Thom,

Did you use the Linux Installer to install the middle tier? From what you explained, it seems like you followed the installation guide to install the middle tier and used the Windows Installer to install the Database and the Client. Is this correct? The Linux installation Guide is something we wrote before we released a Linux Installer. So the document is obsolete now except for the curious mind that wants to know how we install Formspider.

We suspect that there is a disconnect between the middle tier and the database or the client and the middle tier. Could you please try the Linux Installer and reinstall the middle tier? The Installer will ask you the connection information for the Database. Similarly, the Windows Installer should ask for the connection information of the middle tier.

link

answered 14 Oct '11, 06:50

Yalim%20K.%20Gerger's gravatar image

Yalim K. Gerger ♦♦
1914
accept rate: 20%

Yalim,

We followed the directions and everything worked as we hoped. The IDE is up and running on the Linux VM and we are walking through the first tutorial right now.

Thanks!

Thom

link

answered 20 Oct '11, 09:20

throwi's gravatar image

throwi
122
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×15

Asked: 10 Oct '11, 12:33

Seen: 5,761 times

Last updated: 20 Oct '11, 09:20


© Copyright Gerger 2017