[cobalt-developers] UNSUBSCRIBE

["Supachai Sukhanindr,Ph.D." <sidney@xxxxxxxxxxx>]

-----Original Message-----
From: cobalt-developers-admin@xxxxxxxxxxxxxxx [mailto:cobalt-developers-admin@xxxxxxxxxxxxxxx]On Behalf Of Michael Aldor
Sent: Saturday, December 28, 2002 2:53 AM
To: cobalt-developers@xxxxxxxxxxxxxxx
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
cobalt-developers@xxxxxxxxxxxxxxx
http://list.cobalt.com/mailman/listinfo/cobalt-developers