dumbass --- "Supachai Sukhanindr,Ph.D." <[EMAIL PROTECTED]> wrote: > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Michael > Aldor > Sent: Saturday, December 28, 2002 2:53 AM > To: [EMAIL PROTECTED] > Subject: [cobalt-developers] postgres, cobalt and chiliasp 8k > read/write limit > > > > The following is are some issues I am having with writing and reading > from a postgres 7.2.3 db using ChiliAsp on a Cobalt Raq 4: > I would appreciate any help you can provide. > Hello I need further guidance on resolving this 8k limit. > I created a java class to update the db in cases where the text is > over > 8k, I am now running into a 9k read limit on data coming from the > postgres 7.2.3 database while using chili ASP. Also if I call my java > class though chili asp I get an error saying my SQL statement is too > long. If I call my java class though my java interface then the > database > update is ok (I can successfully update more then 8k). > This database field limit is quite frustrating. I have tried changing > odbc driver references with no luck. I am also curious as to where > the > chilisoft jre has referenced the postgres database as it is not > referencing the correct jdbc driver. I put a Jar reference to the > lastest JDBC in javasetup.sh but it seems to not be referencing that > driver. When I took the jdbc jar classpath reference out of the > javasetup.sh file classpath, my code did not crash but continued with > the too long sql statement error every time I try to update over 8k. > This is quite concerning as when I took out the JDBC reference my > code > should crash as I would not be referencing any JDBC driver JAR file. > I have concluded that this is not a database issue as I can > read/write > more then 8 k using tomcat. This seems to be an issue with chiliASP > or a > ChiliAsp Cobalt thing, and I would appreciate any help on where this > 8k > limit has been configured in the Chiliasp system. > Thank you for your help. > Regards, > Michael Aldor > -----Original Message----- > Sent: December 9, 2002 6:29 PM > Subject: RE: Help - Does Chilisoft have an 8k text field limit with > postgres db? (Tracking #11784) > > We tried the symlink, pointing to the newest odbc driver from > postgresql, but the problem still persists. Is there anything else we > can try? > > -----Original Message----- > Sent: December 6, 2002 3:17 AM > To: Michael Aldor > Subject: RE: Help - Does Chilisoft have an 8k text field limit with > postgres db? (Tracking #11784) > > Michael, > This is actually a bug is the open source code that we compiled the > Postgres driver from. You can try compiling a new Postgres driver > from > an updated > version of the source. Keep in mind this isn't officially supported, > but > it > may help resolve your bug. Here's what to do. > 1. Compile the new driver. > 2. Save it on your RaQ4. > 3. Go to /home/chiliasp/odbc/opensource/lib/ > 4. Change the symlink for libodbcpsql.so so that it points to your > new > driver. > -Prashant > ChiliSoft Product Support > > > Hello, > > > I am having a problem with writing more then 8,141 bytes to my > postgres > > database on a Raq 4 cobalt box with chiliasp. > > > > Is there a limit somewhere in the chili asp config files that I can > > change to get over this hurdle? > > > > Or do I have to configure chiliasp to reference the most recent > postgres > > driver? > > > > If so, how do I modify chiliasp to reference a new driver? > > I tried doing this throught the system dsn interface but I cannot > get > > this to work with postgres. > > > > The following is the error I get when I to submit more then 8 k: > > > > error '80004005' > > > > > > .........../testTextfield.asp, line 24 > > > > > > At first I thought it was the postgres database version, so I > > successfully installed a second instance of postgres (version > 7.2.3). > I > > can now successfully write more than 8k to the db through the psql > > command interface. I also have linked pgadmin II to the db and > again > can > > write more than 8k though a tcp/ip connection. > > > > However I still cannot write over 8k to the db throuh my chili asp > code. > > I have tried switching drivers (through the system DSN interface) > > but I cannot seem to use the system DSN to get a successfull > connection. > > Instead I am using DSN-less connection, but am stuck with whatever > > driver chiliasp is looking at. > > > > The following is the error I get when I try to use the System DSN > > with the one that came with the postgres install (libpsqlodbc.so): > > > > ADODB.Connection.1 error '80020009' > > > > Could not open connection using Connection string dsn=testdb; > > > > ...../textfieldTest.asp, line 5 > > > > I would like to change the driver chiliasp is trying to use, but am > not > > sure where to start. > > > > Any help in resolving this issue is appreciated > > > > the following is the code I am testing this issue with: > > <% > > strConnect = > > > "Driver={PostgreSQL};Server=localhost;Port=9999;Database=testdb;UID=x;PW > > D=x" > > set conn = server.createObject("ADODB.connection") > > conn.open strConnect > > > > function addrNull(strField) > > if strField = "" then > > addrNull = "null" > > else > > addrNull = "'" & strField & "'" > > end if > > end function > > function quoteFixer(strField) > > if InStr(strField, "'") > 0 then > > quoteFixer = Replace(strField, "'", "''") > > else > > quoteFixer = strField > > end if > > end function > > > > if request.form("state") = "update" then > > sqlStr = "update text_test set text_field='" & > > quoteFixer(request.form("content")) & "' where test_id = 1" > > conn.execute(sqlStr) > > response.write("<p align=center>Your site has been updated!</p>") > > conn.CommitTrans > > end if > > set rsTest = conn.Execute("SELECT * FROM text_test where > test_id=1") > > %> > > <html> > > <body> > > My Postgres Test > > <form action="textfieldTest.asp" name="test" method="post"> > > <textarea name="content" rows=10 > > cols=80><%=rsTest("text_field")%></textarea> > > <input type="hidden" name="myid" value="<%=rsTest("test_id")%>"> > > <input type="hidden" name="state" value="update"> > > <br> > > <input type="submit" value="go"> > > </form> > > </body> > > </html> > > > > > > > > Regards, > > Michael Aldor > > _______________________________________________ > cobalt-developers mailing list > [EMAIL PROTECTED] > http://list.cobalt.com/mailman/listinfo/cobalt-developers > > _______________________________________________ > cobalt-developers mailing list > [EMAIL PROTECTED] > http://list.cobalt.com/mailman/listinfo/cobalt-developers === message truncated ===
===== Phil Huff * Diversified Financial Group [EMAIL PROTECTED] * 843-884-9851 A Product Everyone Needs! With an UNPARALLELED Business Opportunity! visit http://ppl.philhuff.net for more! Page me online http://wwp.mirabilis.com/9507752 __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com _______________________________________________ cobalt-developers mailing list [EMAIL PROTECTED] http://list.cobalt.com/mailman/listinfo/cobalt-developers
