RE: Re: [Newbies] basicPortal V0.9 installation

I tried this and in the end checked the 'test' servlet. I could get this to
work by adding a row to the table with a 'content_id' of 8?

H.
  -----Original Message-----
  From: [email protected]
[mailto:[email protected]]On Behalf Of Aymeric Alibert
  Sent: 24 April 2003 15:38
  To: [email protected]
  Subject: Re: [MVC-Programmers] Re: [Newbies] basicPortal V0.9 installation


  The issue is that the cmnts table is empty but the test servlet tries to
extract the first row (id =1) and fails.
  You should add a row to the cmnts table and that should fix it.
  The application itself (http://localhost) does not have this problem.

  Aymeric.



  >>> [email protected] 04/24/03 09:26AM >>>
  Can you try pruning the localhost/test servelt? That should produce some
  output.

  Also, try  http://squirrel-sql.sourceforge.net/ it is a jdbc connection
  tester for more data.
  .V

  Chris Oberle wrote:

  >Hello again.  One other bit of this issue I'm having
  >that has me quite baffled is that I am able to connect
  >through ODBC to postgresql.  It was the pgAdmin II
  >tool that I used to load the basicportal tables and
  >sample data.  I'm able to "View Data" just fine ( per
  >the instructions ).  Here is the text that comes up
  >when I view the properties of my host, "localhost":
  >
  >Provider=MSDASQL.1;Extended

>Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=localhost;PORT=54
32;UID=bpuser;PWD=********;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOL
UMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096
;UNKNOWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=0;COMMLOG=
0;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVAR
CHAR=1;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_"
  >
  >I've also ensured that my ACL's are wide open in the
  >pg_hba.conf file:
  >
  >#This file was generated by dbExperts.4/23/2003
  >host    all     127.0.0.1       255.255.255.255 trust
  >host    all     192.168.0.0     255.255.255.0   trust
  >host    all     10.0.0.0        255.0.0.0       trust
  >host    all     0.0.0.0 0.0.0.0 trust
  >
  >Since I'm still getting errors when attempting to
  >access http://localhost/test, I must be missing
  >something.  What else can I check?
  >
  >Thanks,
  >
  >Chris
  >
  >--- Vic Cekvenich <[email protected]> wrote:
  >
  >---------------------------------
  >    Its a goal. I would have said PHB but that would
  >be to much. Alibert'sfixes are in CVS so next build
  >will have it.
  >
  >I would still like to Chris to verify that he can
  >connect to pgSQL fromlike ODBC or some other JDBC,
  >just to ping it.
  >Like Chris, you created the tables?
  >
  >The next release will also have some of the new things
  >in cheat sheetson baseBeans.com.... it's a surprise.
  >Also for another hint note a newnews group on
  >news.basebeans.com. (We had Eclipse, Hibrenate,
  >Struts,etc. now there is a brand new one as of this
  >week).
  >
  >I need to use the blogger more, since I will also have
  >forums of mynewsgroups in bp. One thing is I just
  >added them to my personal mozillacalled "Aqua". I feel
  >like I have a new PC, it's great skin.
  >So some of you can check the blog on baseBeans.com.
  >You can comment onmy blogs of course but you need to
  >join to do that. (all this blogstuff is in bp of
  >course).  You can't add a blog yoursleft, that wouldbe
  >a forum, but you can comment, similar to
  >theserverside.
  >
  >.V
  >http://examples.macromedia.com/petmarket/flashstore.html
  >
  >Rick Reumann wrote:
  >
  >On Wed, Apr 23,'03 (08:19 AM GMT-0500), Aymeric wrote:
  >
  >
  >Just changed the name in ContentSQL.xml and it works
  >fine now.
  >
  >But would Anna Nicole Smith have been able to figure
  >that out:)(Just messin' around Vic:)
  >_______________________________________________MVC-Programmers
  >mailing

>[email protected]://www.basebeans.net:8080/mailman/list
info/mvc-programmers
  >
  >
  >__________________________________________________
  >Do you Yahoo!?
  >The New Yahoo! Search - Faster. Easier. Bingo
  >http://search.yahoo.com
  >
  >

  _______________________________________________
  MVC-Programmers mailing list
  [email protected]
  http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.474 / Virus Database: 272 - Release Date: 18/04/2003