I have also set up the Jetty/OpenBD, and have it running against SQL
Server and MySQL. My goal is a true xCopy installation of my
application, and I am getting closer. I installed Sqlite 3.6.4, and
the sqlitejdbc-v053.jar driver. I verified the SQLite works using the
SQLite2008Pro manager. I am able to perform select statement OK.
When I run an Update or Insert statement, the SQL executes, but throws
a CF error, "no ResultSet available". This actually makes sense, as
there are no results on an update or insert. Any advice?
Here is the error I get on an update.
Type:Database
Query Error:no ResultSet available
Datasource:SAIL
Native Error Code:0
SQL StateSQLupdate manufacturers
set name = ?,
comments = ?
where PK_ManufacturerID = ?Tag ContextCFIF: Line=2; Column=1
|
+-- CFQUERY: Line=3; Column=2Source
1: <!--- 1234<cfdump> --->
2: <cfif action is "Edit">
3: <cfquery datasource="#dsn_name#" name="update">
4: update manufacturers
5: set name = <cfqueryparam cfsqltype="cf_sql_varchar"
value="#form.name#">,
^ Snippet from underlying CFML source
In the bluedragon.xml, under the query section I have:
<datasource name="sail">
<name>sail</name>
<logintimeout>120</logintimeout>
<databasename>sail</databasename>
<initstring></initstring>
<connectionretries>0</connectionretries>
<connectiontimeout>120</connectiontimeout>
<username></username>
<sqlstoredprocedures>true</sqlstoredprocedures>
<hoststring>jdbc:sqlite:/jetty/webroot_cfmlapps/log/sail/
sail.sqlite</hoststring>
<sqlupdate>true</sqlupdate>
<perrequestconnections>true</perrequestconnections>
<drivername>org.sqlite.JDBC</drivername>
<sqlinsert>true</sqlinsert>
<sqldelete>true</sqldelete>
<password>******</password>
<maxconnections>24</maxconnections>
<sqlselect>true</sqlselect>
</datasource>
Thanks in advance for your time,
Rob
On Aug 28, 10:27 pm, David <[EMAIL PROTECTED]> wrote:
> I did not have the datasource section within a <cfquery> block. I
> missed that when copying and pasting from the commented example.
> Adding this got it going. Thanks for the reply and good suggestion.
>
> I am looking forward to the admin console.
>
> David
>
> > Did you restart Jetty after dropping the jar file in the lib directory?
> > You're probably already aware of this, but when you edit the XML config
> > file manually you also need to restart Jetty for the changes to be
> > picked up. And I assume that the datasource node you pasted in your
> > email is nested in a cfquery node? Do you have databases of other types
> > that are working OK?
>
> > It sounds like the jar file is in the right place, but the "need to
> > specify class name" error sounds to me like it isn't finding the classes
> > it needs.sqliteis one of the databases I'm probably going to add to
> > the admin console so I'll give it a shot before long, but I haven't ever
> > used it before, so my apologies that I can't be of more assistance at
> > the moment.
>
> > --
> > Matt Woodward
> > [EMAIL PROTECTED]://www.mattwoodward.com/blog
>
> > Please do not send me proprietary file formats such as Word, PowerPoint,
> > etc. as attachments.http://www.gnu.org/philosophy/no-word-attachments.html
>
>
--~--~---------~--~----~------------~-------~--~----~
Open BlueDragon Public Mailing List
http://groups.google.com/group/openbd?hl=en
official blog @ http://blog.openbluedragon.org/
!! save a network - trim replies before posting !!
-~----------~----~----~----~------~----~------~--~---
