[Arrowheadasp-users] Hello, I got this ASP Error.

[Leyland C. <irc...@os...>]

Dear All,

	On the JAVA's ASP, How can I write data on database using ADODB? 

IIS/ASP-DSNLESS (It's working) / ChiliASP-DSNLESS (Not Sure, Should Be Work)

<%
NewsConStr = "DRIVER={MySQL Driver};SERVER=10.0.0.1;DATABASE=news;UID=news;PWD=news; OPTION=35"
Set Conn=Server.CreateObject("ADODB.Connection")
Set rs=Server.CreateObject("ADODB.RecordSet")
SQL = "SELECT * From webs where id=1"
Conn.open NewsConStr
rs.open SQL,conn,2,2 ' <--- set 2,2 enable read/write, it will be set read-only without it. (Tested on IIS)

If rs Is Nothing or rs.EOF Then
	Response.Write "News ID NOT FOUND"
	Response.End
End If

rs("clicks")=rs("clicks") +1
rs.update
rs.close
conn.close

%>

On The JAVA's ASP, It contains errors.

<%

Server.CreateObject("java:org.gjt.mm.mysql.Driver")
Set Conn = Server.CreateObject("ADODB.Connection")
SQL = "SELECT * From webs where id=1"
Conn.open "jdbc:mysql://10.0.0.1/news?user=news&password=news"
Set rs = Conn.execute(SQL)

If rs Is Nothing or rs.EOF Then
	Response.Write "News ID NOT FOUND"
	Response.End
End If

rs("clicks")=rs("clicks") +1
rs.update

%>

Error Output Is

java.lang.RuntimeException: Setting value of read-only variable
	at com.tripi.asp.ADODB.RecordSet$FieldsMap.put(RecordSet.java:337)
	at com.tripi.asp.ADODB.RecordSet.put(RecordSet.java:302)
	at com.tripi.asp.JavaObjectNode$JavaAccessorNode.setValue(JavaObjectNode.java:284)
	at com.tripi.asp.SetValueNode.execute(SetValueNode.java:132)
	at com.tripi.asp.BlockNode.execute(BlockNode.java:131)
	at com.tripi.asp.AspThread.run(AspThread.java:74)
	at java.lang.Thread.run(Thread.java:536)
File /var/tomcat4/webapps/aspfiles/news.asp line 14: java.lang.RuntimeException: Setting value of read-only variable

Best Regards,
Leyland Chui