dleslie 02/01/25 11:41:32
Modified: java/samples/extensions/sql/basic-connection DumpSQL.xsl
dbinfo.xml dbtest.xsl
java/samples/extensions/sql/pquery dbinfo.xml
java/samples/extensions/sql/show-error dbinfo.xml
invalidConn.xsl invalidPQuery.xsl invalidQuery.xsl
java/samples/extensions/sql/streamable cachedNodes.xsl
dbinfo.xml pivot.xsl streamNodes.xsl
Log:
Updated JDBC driver for Lutris InstantDB 4.0
Revision Changes Path
1.2 +1 -1
xml-xalan/java/samples/extensions/sql/basic-connection/DumpSQL.xsl
Index: DumpSQL.xsl
===================================================================
RCS file:
/home/cvs/xml-xalan/java/samples/extensions/sql/basic-connection/DumpSQL.xsl,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- DumpSQL.xsl 19 Apr 2001 19:35:21 -0000 1.1
+++ DumpSQL.xsl 25 Jan 2002 19:41:31 -0000 1.2
@@ -6,7 +6,7 @@
<xsl:output method="html" indent="yes"/>
-<xsl:param name="driver" select="'org.enhydra.instantdb.jdbc.idbDriver'"/>
+<xsl:param name="driver" select="'com.lutris.instantdb.jdbc.idbDriver'"/>
<xsl:param name="datasource" select="'jdbc:idb:../../instantdb/sample.prp'"/>
<xsl:param name="query" select="'SELECT * FROM import1'"/>
1.2 +1 -1
xml-xalan/java/samples/extensions/sql/basic-connection/dbinfo.xml
Index: dbinfo.xml
===================================================================
RCS file:
/home/cvs/xml-xalan/java/samples/extensions/sql/basic-connection/dbinfo.xml,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- dbinfo.xml 19 Apr 2001 04:16:12 -0000 1.1
+++ dbinfo.xml 25 Jan 2002 19:41:31 -0000 1.2
@@ -2,7 +2,7 @@
<description>This file contains information required to make a connection
to the DBMS</description>
<DBINFO>
- <dbdriver>org.enhydra.instantdb.jdbc.idbDriver</dbdriver>
+ <dbdriver>com.lutris.instantdb.jdbc.idbDriver</dbdriver>
<dburl>jdbc:idb:../../instantdb/sample.prp</dburl>
<user />
<password/>
1.5 +120 -60
xml-xalan/java/samples/extensions/sql/basic-connection/dbtest.xsl
Index: dbtest.xsl
===================================================================
RCS file:
/home/cvs/xml-xalan/java/samples/extensions/sql/basic-connection/dbtest.xsl,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- dbtest.xsl 24 Aug 2001 04:44:15 -0000 1.4
+++ dbtest.xsl 25 Jan 2002 19:41:31 -0000 1.5
@@ -1,61 +1,121 @@
-<?xml version="1.0"?>
-<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
- version="1.0"
- xmlns:sql="org.apache.xalan.lib.sql.XConnection"
- extension-element-prefixes="sql">
-
-<xsl:output method="html" indent="yes"/>
-
-<xsl:param name="driver" select="'org.enhydra.instantdb.jdbc.idbDriver'"/>
-<xsl:param name="datasource" select="'jdbc:idb:../../instantdb/sample.prp'"/>
-<xsl:param name="query" select="'SELECT * FROM import1'"/>
-
-<xsl:template match="/">
-
- <xsl:variable name="db" select="sql:new()"/>
-
- <!-- Connect to the database with minimal error detection -->
- <xsl:if test="not(sql:connect($db, $driver, $datasource))" >
- <xsl:message>Error Connecting to the Database</xsl:message>
- <xsl:copy-of select="sql:getError($db)/ext-error" />
- </xsl:if>
-
- <HTML>
- <HEAD>
- <TITLE>List of products</TITLE>
- </HEAD>
- <BODY>
- <TABLE border="1">
- <xsl:variable name="table" select='sql:query($db, $query)'/>
-
- <!--
- Let's include Error Checking, the error is actually stored
- in the connection since $table will be either data or null
- -->
-
- <xsl:if test="not($table)" >
- <xsl:message>Error in Query</xsl:message>
- <xsl:copy-of select="sql:getError($db)/ext-error" />
- </xsl:if>
-
- <TR>
- <xsl:for-each select="$table/sql/metadata/column-header">
- <TH><xsl:value-of select="@column-label"/></TH>
- </xsl:for-each>
- </TR>
- <xsl:apply-templates select="$table/sql/row-set/row"/>
- </TABLE>
- </BODY>
- </HTML>
- <xsl:value-of select="sql:close($db)"/>
-</xsl:template>
-
-<xsl:template match="row">
- <TR><xsl:apply-templates select="col"/></TR>
-</xsl:template>
-
-<xsl:template match="col">
- <TD><xsl:value-of select="text()"/></TD>
-</xsl:template>
-
+<?xml version="1.0"?>
+
+<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
+
+ version="1.0"
+
+ xmlns:sql="org.apache.xalan.lib.sql.XConnection"
+
+ extension-element-prefixes="sql">
+
+
+
+<xsl:output method="html" indent="yes"/>
+
+
+
+<xsl:param name="driver" select="'com.lutris.instantdb.jdbc.idbDriver'"/>
+
+<xsl:param name="datasource" select="'jdbc:idb:../../instantdb/sample.prp'"/>
+
+<xsl:param name="query" select="'SELECT * FROM import1'"/>
+
+
+
+<xsl:template match="/">
+
+
+
+ <xsl:variable name="db" select="sql:new()"/>
+
+
+
+ <!-- Connect to the database with minimal error detection -->
+
+ <xsl:if test="not(sql:connect($db, $driver, $datasource))" >
+
+ <xsl:message>Error Connecting to the Database</xsl:message>
+
+ <xsl:copy-of select="sql:getError($db)/ext-error" />
+
+ </xsl:if>
+
+
+
+ <HTML>
+
+ <HEAD>
+
+ <TITLE>List of products</TITLE>
+
+ </HEAD>
+
+ <BODY>
+
+ <TABLE border="1">
+
+ <xsl:variable name="table" select='sql:query($db, $query)'/>
+
+
+
+ <!--
+
+ Let's include Error Checking, the error is actually stored
+
+ in the connection since $table will be either data or null
+
+ -->
+
+
+
+ <xsl:if test="not($table)" >
+
+ <xsl:message>Error in Query</xsl:message>
+
+ <xsl:copy-of select="sql:getError($db)/ext-error" />
+
+ </xsl:if>
+
+
+
+ <TR>
+
+ <xsl:for-each select="$table/sql/metadata/column-header">
+
+ <TH><xsl:value-of select="@column-label"/></TH>
+
+ </xsl:for-each>
+
+ </TR>
+
+ <xsl:apply-templates select="$table/sql/row-set/row"/>
+
+ </TABLE>
+
+ </BODY>
+
+ </HTML>
+
+ <xsl:value-of select="sql:close($db)"/>
+
+</xsl:template>
+
+
+
+<xsl:template match="row">
+
+ <TR><xsl:apply-templates select="col"/></TR>
+
+</xsl:template>
+
+
+
+<xsl:template match="col">
+
+ <TD><xsl:value-of select="text()"/></TD>
+
+</xsl:template>
+
+
+
</xsl:stylesheet>
1.2 +1 -1 xml-xalan/java/samples/extensions/sql/pquery/dbinfo.xml
Index: dbinfo.xml
===================================================================
RCS file: /home/cvs/xml-xalan/java/samples/extensions/sql/pquery/dbinfo.xml,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- dbinfo.xml 19 Apr 2001 04:16:13 -0000 1.1
+++ dbinfo.xml 25 Jan 2002 19:41:31 -0000 1.2
@@ -5,7 +5,7 @@
</QUERY>
<DBINFO>
- <dbdriver>org.enhydra.instantdb.jdbc.idbDriver</dbdriver>
+ <dbdriver>com.lutris.instantdb.jdbc.idbDriver</dbdriver>
<dburl>jdbc:idb:../../instantdb/sample.prp</dburl>
<user/>
<password/>
1.4 +1 -1
xml-xalan/java/samples/extensions/sql/show-error/dbinfo.xml
Index: dbinfo.xml
===================================================================
RCS file:
/home/cvs/xml-xalan/java/samples/extensions/sql/show-error/dbinfo.xml,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- dbinfo.xml 1 Aug 2001 18:34:57 -0000 1.3
+++ dbinfo.xml 25 Jan 2002 19:41:31 -0000 1.4
@@ -5,7 +5,7 @@
</QUERY>
<DBINFO>
- <dbdriver>org.enhydra.instantdb.jdbc.idbDriver</dbdriver>
+ <dbdriver>com.lutris.instantdb.jdbc.idbDriver</dbdriver>
<dburl>jdbc:idb:../../instantdb/sample.prp</dburl>
<user/>
<password/>
1.3 +1 -1
xml-xalan/java/samples/extensions/sql/show-error/invalidConn.xsl
Index: invalidConn.xsl
===================================================================
RCS file:
/home/cvs/xml-xalan/java/samples/extensions/sql/show-error/invalidConn.xsl,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- invalidConn.xsl 9 Aug 2001 13:50:45 -0000 1.2
+++ invalidConn.xsl 25 Jan 2002 19:41:31 -0000 1.3
@@ -1 +1 @@
-<?xml version="1.0"?><xsl:stylesheet
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"; version="1.0"
xmlns:sql="org.apache.xalan.lib.sql.XConnection"
extension-element-prefixes="sql"><xsl:output method="html"
indent="yes"/><xsl:param name="driver"
select="'org.enhydra.instantdb.jdbc.idbDriver'"/><!-- ERROR ERROR ERROR ERROR
ERROR ERROR ERROR ERROR ERROR ERROR ERROR ERROR We are specifying a
database that does not exist, which will cause a connection
errorERROR ERROR ERROR ERROR ERROR ERROR ERROR ERROR ERROR ERROR ERROR
ERROR--><xsl:param name="datasource"
select="'jdbc:idb:../../instantdb/DoesNotExist.prp'"/><xsl:param name="query"
select="'SELECT * FROM import2'"/><xsl:template match="/"> <xsl:variable
name="db" select="sql:new()"/> <!-- Connect to the database with minimal
error detection --> <xsl:if test="not(sql:connect($db, $driver,
$datasource))" > <xsl:message>Error Connecting to the
Database</xsl:message> <xsl:copy-of select="sql:getError($db)/ext-error"
/> </xsl:if> <HTML> <HEAD> <TITLE>List of
products</TITLE> </HEAD> <BODY> <TABLE border="1">
<xsl:variable name="table" select='sql:query($db, $query)'/>
<!-- Let's include Error Checking, the error is actually stored
in the connection since $table will be either data or null -->
<xsl:if test="not($table)" >
<xsl:message>Error in Query</xsl:message> <xsl:copy-of
select="sql:getError($db)/ext-error" /> </xsl:if>
<TR> <xsl:for-each select="$table/row-set/column-header">
<TH><xsl:value-of select="@column-label"/></TH> </xsl:for-each>
</TR> <xsl:apply-templates select="$table/row-set/row"/>
</TABLE> </BODY> </HTML> <xsl:value-of
select="sql:close($db)"/></xsl:template><xsl:template match="row">
<TR><xsl:apply-templates select="col"/></TR></xsl:template><xsl:template
match="col"> <TD><xsl:value-of
select="text()"/></TD></xsl:template></xsl:stylesheet>
\ No newline at end of file
+<?xml version="1.0"?><xsl:stylesheet
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"; version="1.0"
xmlns:sql="org.apache.xalan.lib.sql.XConnection"
extension-element-prefixes="sql"><xsl:output method="html"
indent="yes"/><xsl:param name="driver"
select="'com.lutris.instantdb.jdbc.idbDriver'"/><!-- ERROR ERROR ERROR ERROR
ERROR ERROR ERROR ERROR ERROR ERROR ERROR ERROR We are specifying a
database that does not exist, which will cause a connection
errorERROR ERROR ERROR ERROR ERROR ERROR ERROR ERROR ERROR ERROR ERROR
ERROR--><xsl:param name="datasource"
select="'jdbc:idb:../../instantdb/DoesNotExist.prp'"/><xsl:param name="query"
select="'SELECT * FROM import2'"/><xsl:template match="/"> <xsl:variable
name="db" select="sql:new()"/> <!-- Connect to the database with minimal
error detection --> <xsl:if test="not(sql:connect($db, $driver,
$datasource))" > <xsl:message>Error Connecting to the
Database</xsl:message> <xsl:copy-of select="sql:getError($db)/ext-error"
/> </xsl:if> <HTML> <HEAD> <TITLE>List of
products</TITLE> </HEAD> <BODY> <TABLE border="1">
<xsl:variable name="table" select='sql:query($db, $query)'/>
<!-- Let's include Error Checking, the error is actually stored
in the connection since $table will be either data or null -->
<xsl:if test="not($table)" >
<xsl:message>Error in Query</xsl:message> <xsl:copy-of
select="sql:getError($db)/ext-error" /> </xsl:if>
<TR> <xsl:for-each select="$table/row-set/column-header">
<TH><xsl:value-of select="@column-label"/></TH> </xsl:for-each>
</TR> <xsl:apply-templates select="$table/row-set/row"/>
</TABLE> </BODY> </HTML> <xsl:value-of
select="sql:close($db)"/></xsl:template><xsl:template match="row">
<TR><xsl:apply-templates select="col"/></TR></xsl:template><xsl:template
match="col"> <TD><xsl:value-of
select="text()"/></TD></xsl:template></xsl:stylesheet>
\ No newline at end of file
1.3 +1 -1
xml-xalan/java/samples/extensions/sql/show-error/invalidPQuery.xsl
Index: invalidPQuery.xsl
===================================================================
RCS file:
/home/cvs/xml-xalan/java/samples/extensions/sql/show-error/invalidPQuery.xsl,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- invalidPQuery.xsl 24 Aug 2001 04:46:07 -0000 1.2
+++ invalidPQuery.xsl 25 Jan 2002 19:41:31 -0000 1.3
@@ -6,7 +6,7 @@
<xsl:output method="html" indent="yes"/>
-<xsl:param name="driver" select="'org.enhydra.instantdb.jdbc.idbDriver'"/>
+<xsl:param name="driver" select="'com.lutris.instantdb.jdbc.idbDriver'"/>
<xsl:param name="datasource" select="'jdbc:idb:../../instantdb/sample.prp'"/>
1.3 +1 -1
xml-xalan/java/samples/extensions/sql/show-error/invalidQuery.xsl
Index: invalidQuery.xsl
===================================================================
RCS file:
/home/cvs/xml-xalan/java/samples/extensions/sql/show-error/invalidQuery.xsl,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- invalidQuery.xsl 24 Aug 2001 04:46:07 -0000 1.2
+++ invalidQuery.xsl 25 Jan 2002 19:41:31 -0000 1.3
@@ -6,7 +6,7 @@
<xsl:output method="html" indent="yes"/>
-<xsl:param name="driver" select="'org.enhydra.instantdb.jdbc.idbDriver'"/>
+<xsl:param name="driver" select="'com.lutris.instantdb.jdbc.idbDriver'"/>
<xsl:param name="datasource" select="'jdbc:idb:../../instantdb/sample.prp'"/>
1.3 +1 -1
xml-xalan/java/samples/extensions/sql/streamable/cachedNodes.xsl
Index: cachedNodes.xsl
===================================================================
RCS file:
/home/cvs/xml-xalan/java/samples/extensions/sql/streamable/cachedNodes.xsl,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- cachedNodes.xsl 6 Aug 2001 05:05:22 -0000 1.2
+++ cachedNodes.xsl 25 Jan 2002 19:41:32 -0000 1.3
@@ -6,7 +6,7 @@
<xsl:output method="html" indent="yes"/>
-<xsl:param name="driver" select="'org.enhydra.instantdb.jdbc.idbDriver'"/>
+<xsl:param name="driver" select="'com.lutris.instantdb.jdbc.idbDriver'"/>
<xsl:param name="datasource" select="'jdbc:idb:../../instantdb/sample.prp'"/>
<xsl:param name="query" select="'SELECT * FROM import1'"/>
1.4 +1 -1
xml-xalan/java/samples/extensions/sql/streamable/dbinfo.xml
Index: dbinfo.xml
===================================================================
RCS file:
/home/cvs/xml-xalan/java/samples/extensions/sql/streamable/dbinfo.xml,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- dbinfo.xml 1 Aug 2001 18:36:09 -0000 1.3
+++ dbinfo.xml 25 Jan 2002 19:41:32 -0000 1.4
@@ -2,7 +2,7 @@
<description>This file contains information required to make a connection
to the DBMS</description>
<DBINFO>
- <dbdriver>org.enhydra.instantdb.jdbc.idbDriver</dbdriver>
+ <dbdriver>com.lutris.instantdb.jdbc.idbDriver</dbdriver>
<dburl>jdbc:idb:../../instantdb/sample.prp</dburl>
<user />
<password/>
1.3 +1 -1
xml-xalan/java/samples/extensions/sql/streamable/pivot.xsl
Index: pivot.xsl
===================================================================
RCS file:
/home/cvs/xml-xalan/java/samples/extensions/sql/streamable/pivot.xsl,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- pivot.xsl 1 Aug 2001 18:32:34 -0000 1.2
+++ pivot.xsl 25 Jan 2002 19:41:32 -0000 1.3
@@ -6,7 +6,7 @@
<xsl:output method="html" indent="yes"/>
-<xsl:param name="driver" select="'org.enhydra.instantdb.jdbc.idbDriver'"/>
+<xsl:param name="driver" select="'com.lutris.instantdb.jdbc.idbDriver'"/>
<xsl:param name="datasource" select="'jdbc:idb:../../instantdb/sample.prp'"/>
<xsl:param name="query" select="'SELECT * FROM import1'"/>
1.3 +1 -1
xml-xalan/java/samples/extensions/sql/streamable/streamNodes.xsl
Index: streamNodes.xsl
===================================================================
RCS file:
/home/cvs/xml-xalan/java/samples/extensions/sql/streamable/streamNodes.xsl,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- streamNodes.xsl 6 Aug 2001 05:03:01 -0000 1.2
+++ streamNodes.xsl 25 Jan 2002 19:41:32 -0000 1.3
@@ -6,7 +6,7 @@
<xsl:output method="html" indent="yes"/>
-<xsl:param name="driver" select="'org.enhydra.instantdb.jdbc.idbDriver'"/>
+<xsl:param name="driver" select="'com.lutris.instantdb.jdbc.idbDriver'"/>
<xsl:param name="datasource" select="'jdbc:idb:../../instantdb/sample.prp'"/>
<xsl:param name="query" select="'SELECT * FROM import1'"/>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
