initial import

4 files changed, 598 insertions, 0 deletions

diff --git a/connectivity/workben/TT/StartTest.class b/connectivity/workben/TT/StartTest.class
new file mode 100644
index 000000000000..28791c43eb9c
--- /dev/null
+++ b/connectivity/workben/TT/StartTest.class
diff --git a/connectivity/workben/TT/StartTest.java b/connectivity/workben/TT/StartTest.java
new file mode 100644
index 000000000000..b102ca62026a
--- /dev/null
+++ b/connectivity/workben/TT/StartTest.java
@@ -0,0 +1,327 @@
+/*************************************************************************
+ *
+ *  $RCSfile: StartTest.java,v $
+ *
+ *  $Revision: 1.1.1.1 $
+ *
+ *  last change: $Author: hr $ $Date: 2000-09-18 16:14:29 $
+ *
+ *  The Contents of this file are made available subject to the terms of
+ *  either of the following licenses
+ *
+ *         - GNU Lesser General Public License Version 2.1
+ *         - Sun Industry Standards Source License Version 1.1
+ *
+ *  Sun Microsystems Inc., October, 2000
+ *
+ *  GNU Lesser General Public License Version 2.1
+ *  =============================================
+ *  Copyright 2000 by Sun Microsystems, Inc.
+ *  901 San Antonio Road, Palo Alto, CA 94303, USA
+ *
+ *  This library is free software; you can redistribute it and/or
+ *  modify it under the terms of the GNU Lesser General Public
+ *  License version 2.1, as published by the Free Software Foundation.
+ *
+ *  This library is distributed in the hope that it will be useful,
+ *  but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+ *  Lesser General Public License for more details.
+ *
+ *  You should have received a copy of the GNU Lesser General Public
+ *  License along with this library; if not, write to the Free Software
+ *  Foundation, Inc., 59 Temple Place, Suite 330, Boston,
+ *  MA  02111-1307  USA
+ *
+ *
+ *  Sun Industry Standards Source License Version 1.1
+ *  =================================================
+ *  The contents of this file are subject to the Sun Industry Standards
+ *  Source License Version 1.1 (the "License"); You may not use this file
+ *  except in compliance with the License. You may obtain a copy of the
+ *  License at http://www.openoffice.org/license.html.
+ *
+ *  Software provided under this License is provided on an "AS IS" basis,
+ *  WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING,
+ *  WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
+ *  MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
+ *  See the License for the specific provisions governing your rights and
+ *  obligations concerning the Software.
+ *
+ *  The Initial Developer of the Original Code is: Sun Microsystems, Inc.
+ *
+ *  Copyright: 2000 by Sun Microsystems, Inc.
+ *
+ *  All Rights Reserved.
+ *
+ *  Contributor(s): _______________________________________
+ *
+ *
+ ************************************************************************/
+package workben.tt;
+
+import java.lang.Object;
+import java.io.*;
+import workben.odbc.*;
+
+import com.sun.star.comp.servicemanager.ServiceManager;
+//  import java.io.IOException;
+
+//import com.sun.star.beans.PropertyValue;
+//import com.sun.star.beans.PropertyState;
+import com.sun.star.connection.XConnector;
+import com.sun.star.connection.XConnection;
+import com.sun.star.bridge.XBridge;
+
+//  import com.sun.star.comp.bootstrap.Bootstrap;
+
+//  import com.sun.star.io.XInputStream;
+//  import com.sun.star.io.XOutputStream;
+
+//  import com.sun.star.lang.XComponent;
+import com.sun.star.lang.XMultiServiceFactory;
+import com.sun.star.lang.XServiceInfo;
+
+import com.sun.star.uno.IBridge;
+import com.sun.star.uno.UnoRuntime;
+import com.sun.star.uno.XInterface;
+import com.sun.star.uno.XNamingService;
+
+import com.sun.star.sdbc.*;
+//  import com.sun.star.sdbc.XConnection;
+//  import com.sun.star.uno.Enum;
+
+//  import com.sun.star.lib.uno.typeinfo.ParameterTypeInfo;
+//  import com.sun.star.lib.uno.typeinfo.TypeInfo;
+
+public class StartTest
+{
+  //###########################################################
+  //#                   allgemeine Variablen                  #
+  //###########################################################
+  private static java.util.Hashtable ConfigItems = new java.util.Hashtable();
+  //###########################################################
+  //#                   ResultSetToStringBuffer               #
+  //###########################################################
+  static StringBuffer ResultSetToStringBuffer(com.sun.star.sdbc.XResultSet results)
+  {
+          com.sun.star.sdbc.XRow                           Row;
+          com.sun.star.sdbc.XResultSetMetaDataSupplier     rsmds;
+          com.sun.star.sdbc.XResultSetMetaData             rsmd;
+
+          StringBuffer buf = new StringBuffer();
+
+          try
+          {
+            rsmds = (com.sun.star.sdbc.XResultSetMetaDataSupplier)UnoRuntime.queryInterface(com.sun.star.sdbc.XResultSetMetaDataSupplier.class,results);
+            rsmd = rsmds.getMetaData();
+            int numCols = rsmd.getColumnCount();
+            int i;
+
+            // get column header info
+            for (i=1; i <= numCols; i++)
+            {
+                if (i == 1) buf.append("\"");
+                if (i > 1) buf.append("\"\t\"");
+                buf.append(rsmd.getColumnLabel(i));
+            }
+            buf.append("\"\r\n");
+
+
+
+            while (results.next())
+            {
+                Row = (com.sun.star.sdbc.XRow)UnoRuntime.queryInterface(com.sun.star.sdbc.XRow.class, results);
+                for (i=1; i <= numCols; i++)
+                {
+                    if (i == 1) buf.append("\"");
+                    if (i > 1) buf.append("\"\t\"");
+                    buf.append(Row.getString(i));
+                }
+                buf.append("\"\r\n");
+            }
+            return(buf);
+          }
+          catch (Exception e)
+          {
+            System.out.println("Exception at ResultSetToStringBuffer : " + e);
+            return(buf);
+          }
+  }
+
+  //###########################################################
+  //#                   printStringBuffer                     #
+  //###########################################################
+
+  static void printStringBuffer(StringBuffer buf)
+  {
+    FileWriter f1;
+    try
+    {
+      f1 = new FileWriter("d:\\data\\sdbc\\test.log",true);
+      int maxStrings = buf.length() - 1;
+      //System.out.println(maxStrings);
+      for(int i=0 ; i<=maxStrings ; i++)
+      {
+        f1.write(buf.charAt(i));
+      }
+      f1.close();
+    }
+    catch( IOException e )
+    {
+      System.out.println("Error: can't create logfile");
+    }
+  }
+
+  //###########################################################
+  //#                   neededServices                        #
+  //###########################################################
+  static String neededServices[] = new String[] {
+        "com.sun.star.comp.servicemanager.ServiceManager",
+        "com.sun.star.comp.loader.JavaLoader",
+        "com.sun.star.comp.connections.Connector",
+          "com.sun.star.comp.connections.Acceptor"
+    };
+
+  //###########################################################
+  //#                   readConfigFile                        #
+  //###########################################################
+  static void readConfigFile(String sFileName)
+  {
+    BufferedReader confFile;
+    try
+    {
+      confFile = new BufferedReader(new FileReader(sFileName));
+      ConfigItems.put("ConnectString",confFile.readLine());
+      ConfigItems.put("user",confFile.readLine());
+      ConfigItems.put("password",confFile.readLine());
+      ConfigItems.put("ToTest",confFile.readLine());
+      ConfigItems.put("LogFile",confFile.readLine());
+      confFile.close();
+    }
+    catch(Exception e)
+    {
+      System.out.println(e);
+    }
+  }
+
+  //###########################################################
+  //#                   MAIN                                  #
+  //###########################################################
+
+  public static void main(String argv[]) throws Exception
+    {
+
+    //Die Parameter auslesen
+
+//    if(argv.length == 0)
+//    {
+//      System.out.println("missing parameter");
+//      System.exit(0);
+//    }
+
+    //readConfigFile(argv[0]);
+
+    ////////////////////////
+
+    com.sun.star.comp.servicemanager.ServiceManager smgr = new com.sun.star.comp.servicemanager.ServiceManager();
+        smgr.addFactories(neededServices);
+
+        XConnector  xConnector  = (XConnector)smgr.createInstance("com.sun.star.connection.Connector");
+    if(xConnector == null) System.err.println("no connector!");
+
+        XConnection xConn       = xConnector.connect("socket,host=localhost,port=6001");
+    if(xConn == null) System.err.println("no XConnection!");
+
+        IBridge iBridge = UnoRuntime.getBridgeByName("java", null, "remote", null, new Object[]{"iiop", xConn, null});
+
+        Object rInitialObject = iBridge.mapInterfaceFrom("classic_uno", XInterface.class);
+
+        if(rInitialObject != null)
+        {
+            System.err.println("got the remote object");
+      System.out.println("before naming service !");
+      try
+      {
+        XNamingService rName = (XNamingService)UnoRuntime.queryInterface(XNamingService.class, rInitialObject );
+        try
+        {
+          if(rName != null)
+          {
+            System.err.println("got the remote naming service !");
+            Object rXsmgr = rName.getRegisteredObject("StarOffice.ServiceManager");
+            XMultiServiceFactory rSmgr = (XMultiServiceFactory)UnoRuntime.queryInterface(XMultiServiceFactory.class, rXsmgr);
+            if(rSmgr != null)
+            {
+              System.out.println("got the remote service manager !");
+              Object rDriver = rSmgr.createInstance("com.sun.star.sdbc.ADriver");
+              if(rDriver != null)
+              {
+                System.out.println("got a com.sun.star.sdbc.Driver !");
+                com.sun.star.sdbc.XDriver  xDriver  = (XDriver)UnoRuntime.queryInterface(com.sun.star.sdbc.XDriver.class,rDriver);
+                if(xDriver != null)
+                {
+                  com.sun.star.sdbc.XConnection xConnection = null;
+                  try
+                  {
+                    com.sun.star.beans.PropertyValue [] ConInfo = new com.sun.star.beans.PropertyValue[]
+                    {
+                      new com.sun.star.beans.PropertyValue("user",0,"qsuser",com.sun.star.beans.PropertyState.DIRECT_VALUE),
+                      new com.sun.star.beans.PropertyValue("password",0,"qsuser",com.sun.star.beans.PropertyState.DIRECT_VALUE)
+                    };
+                    xConnection = xDriver.connect("sdbc:ado:PROVIDER=SQLOLEDB;DATA SOURCE=sqllab2",ConInfo);
+
+                    if(xConnection != null)
+                    {
+                      System.out.println("got a connection!");
+                      com.sun.star.sdbc.XDatabaseMetaData dmd;
+                      com.sun.star.sdbc.XStatement    stmt;
+                      com.sun.star.sdbc.XResultSet   result;
+                      com.sun.star.sdbc.XRow         row;
+                      try
+                      {
+                        stmt = xConnection.createStatement();
+                        stmt.executeUpdate("insert into testtab values(4,'vier')");
+                        result = stmt.executeQuery("select * from testtab where int = 4");
+                        com.sun.star.sdbc.XResultSetMetaDataSupplier     rsmds;
+
+                        rsmds = (com.sun.star.sdbc.XResultSetMetaDataSupplier)UnoRuntime.queryInterface(com.sun.star.sdbc.XResultSetMetaDataSupplier.class,result);
+                        com.sun.star.sdbc.XResultSetMetaData  xMD = rsmds.getMetaData();
+                        System.out.println("Anzahl Spalten = " + xMD.getColumnCount());
+                        if(result.next())
+                        {
+                            row = (com.sun.star.sdbc.XRow)UnoRuntime.queryInterface(com.sun.star.sdbc.XRow.class,result);
+                            String xx = row.getString(1);
+                        }
+                      }
+                      catch (Exception e)
+                      {
+                      System.out.println("Exception beim Aufruf der Tests");
+                      }
+                    }
+                  }
+                  catch(Exception e)
+                  {
+                    System.out.println("exception while connecting!");
+                    e.printStackTrace();
+                  }
+                  xConnection.close();
+                }
+              }
+            }
+          }
+        }
+        catch(Exception t)
+        {
+        }
+      }
+      catch(Exception e1)
+      {
+        System.err.println("exception from getRegisteredObject!");
+      }
+    }
+    System.out.println("FERTIG");
+    System.exit(0);
+  }
+  }// die Klammer der ganzen Klasse
+
diff --git a/connectivity/workben/little/main.cxx b/connectivity/workben/little/main.cxx
new file mode 100644
index 000000000000..6fb949fe4159
--- /dev/null
+++ b/connectivity/workben/little/main.cxx
@@ -0,0 +1,170 @@
+/*************************************************************************
+ *
+ *  $RCSfile: main.cxx,v $
+ *
+ *  $Revision: 1.1.1.1 $
+ *
+ *  last change: $Author: hr $ $Date: 2000-09-18 16:14:29 $
+ *
+ *  The Contents of this file are made available subject to the terms of
+ *  either of the following licenses
+ *
+ *         - GNU Lesser General Public License Version 2.1
+ *         - Sun Industry Standards Source License Version 1.1
+ *
+ *  Sun Microsystems Inc., October, 2000
+ *
+ *  GNU Lesser General Public License Version 2.1
+ *  =============================================
+ *  Copyright 2000 by Sun Microsystems, Inc.
+ *  901 San Antonio Road, Palo Alto, CA 94303, USA
+ *
+ *  This library is free software; you can redistribute it and/or
+ *  modify it under the terms of the GNU Lesser General Public
+ *  License version 2.1, as published by the Free Software Foundation.
+ *
+ *  This library is distributed in the hope that it will be useful,
+ *  but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+ *  Lesser General Public License for more details.
+ *
+ *  You should have received a copy of the GNU Lesser General Public
+ *  License along with this library; if not, write to the Free Software
+ *  Foundation, Inc., 59 Temple Place, Suite 330, Boston,
+ *  MA  02111-1307  USA
+ *
+ *
+ *  Sun Industry Standards Source License Version 1.1
+ *  =================================================
+ *  The contents of this file are subject to the Sun Industry Standards
+ *  Source License Version 1.1 (the "License"); You may not use this file
+ *  except in compliance with the License. You may obtain a copy of the
+ *  License at http://www.openoffice.org/license.html.
+ *
+ *  Software provided under this License is provided on an "AS IS" basis,
+ *  WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING,
+ *  WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
+ *  MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
+ *  See the License for the specific provisions governing your rights and
+ *  obligations concerning the Software.
+ *
+ *  The Initial Developer of the Original Code is: Sun Microsystems, Inc.
+ *
+ *  Copyright: 2000 by Sun Microsystems, Inc.
+ *
+ *  All Rights Reserved.
+ *
+ *  Contributor(s): _______________________________________
+ *
+ *
+ ************************************************************************/
+#ifndef _CONNECTIVITY_SQLPARSE_HXX
+#include <connectivity/sqlparse.hxx>
+#endif
+
+#ifndef _CONNECTIVITY_PARSE_SQLITERATOR_HXX_
+#include "connectivity/sqliterator.hxx"
+#endif
+#ifndef _COM_SUN_STAR_SDBCX_XTABLESSUPPLIER_HPP_
+#include <com/sun/star/sdbcx/XTablesSupplier.hpp>
+#endif
+#include <com/sun/star/sdbcx/XDataDefinitionSupplier.hpp>
+#include <com/sun/star/sdbc/XResultSet.hpp>
+#include <com/sun/star/sdbc/XResultSetMetaData.hpp>
+#include <com/sun/star/sdbc/XRow.hpp>
+#include <com/sun/star/sdbc/XResultSetMetaDataSupplier.hpp>
+
+#ifndef _COM_SUN_STAR_LANG_XMULTISERVICEFACTORY_HPP_
+#include <com/sun/star/lang/XMultiServiceFactory.hpp>
+#endif
+#ifndef _COM_SUN_STAR_BEANS_PROPERTYSTATE_HPP_
+#include <com/sun/star/beans/PropertyState.hpp>
+#endif
+#ifndef _COM_SUN_STAR_BEANS_PROPERTYVALUE_HPP_
+#include <com/sun/star/beans/PropertyValue.hpp>
+#endif
+#ifndef _UNOTOOLS_PROCESSFACTORY_HXX_
+#include <unotools/processfactory.hxx>
+#endif
+#ifndef _CPPUHELPER_SERVICEFACTORY_HXX_
+#include <cppuhelper/servicefactory.hxx>
+#endif
+#ifndef _COM_SUN_STAR_SDBC_XCONNECTION_HPP_
+#include <com/sun/star/sdbc/XConnection.hpp>
+#endif
+#ifndef _COM_SUN_STAR_SDBC_XDRIVER_HPP_
+#include <com/sun/star/sdbc/XDriver.hpp>
+#endif
+#include "connectivity/sqlnode.hxx"
+
+using namespace connectivity;
+using namespace com::sun::star::sdbc;
+using namespace com::sun::star;
+using namespace com::sun::star::uno;
+using namespace com::sun::star::beans;
+using namespace rtl;
+using namespace cppu;
+
+
+#if (defined UNX) || (defined OS2)
+void main( int argc, char * argv[] )
+#else
+void _cdecl main( int argc, char * argv[] )
+#endif
+
+{
+    ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection>  m_xConnection;
+    ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XDriver>      m_xDriver;
+
+    try{
+        Reference< ::com::sun::star::lang::XMultiServiceFactory > xFac =
+                createRegistryServiceFactory(OUString::createFromAscii("g:\\office50\\program\\applicat.rdb"),OUString());
+        if(!xFac.is())
+            return;
+
+        m_xDriver = Reference<XDriver>(xFac->createInstance(OUString::createFromAscii("com.sun.star.sdbc.driver.dbase.Driver")),UNO_QUERY);
+        if(m_xDriver.is())
+        {
+
+            Sequence<PropertyValue> aValue;
+    //      aValue.getArray()[0] = PropertyValue( OUString::createFromAscii("user"),0,makeAny(OUString::createFromAscii("TEST1")),PropertyState_DIRECT_VALUE);
+    //      aValue.getArray()[1] = PropertyValue( OUString::createFromAscii("password"),0,makeAny(OUString::createFromAscii("TEST1")),PropertyState_DIRECT_VALUE);
+    //
+            m_xConnection = m_xDriver->connect(OUString::createFromAscii("sdbc:dbase:g:\\"),aValue);
+            if(m_xConnection.is())
+            {
+                Reference<XStatement> xStmt = m_xConnection->createStatement();
+                if(xStmt.is())
+                {
+                    Reference<XResultSet> xRes = xStmt->executeQuery(OUString::createFromAscii("SELECT * FROM Tele"));
+                    if(xRes.is())
+                    {
+                        ::rtl::OUString aPat = ::rtl::OUString::createFromAscii("%s\t");
+                        Reference<XRow> xRow(xRes,UNO_QUERY);
+                        Reference<XResultSetMetaData> xMeta = Reference<XResultSetMetaDataSupplier>(xRes,UNO_QUERY)->getMetaData();
+                        for(sal_Int32 i=1;i<xMeta->getColumnCount();++i)
+                        {
+                            wprintf(aPat.getStr(), xMeta->getColumnName(i).getStr());
+                        }
+                        printf("----------------------------------------------------------------------\n");
+                        while(xRes->next())
+                        {
+                            for(sal_Int32 j=1;j<xMeta->getColumnCount();++j)
+                                wprintf(aPat.getStr(), xRow->getString(j).getStr());
+                            printf("\n");
+                        }
+                    }
+                }
+            }
+
+        }
+    }
+    catch(...)
+    {
+        printf("Exception thrown!\n");
+
+    }
+    sal_Int32 d;
+    scanf("%d",&d);
+}
+
diff --git a/connectivity/workben/little/makefile.mk b/connectivity/workben/little/makefile.mk
new file mode 100644
index 000000000000..84825a725377
--- /dev/null
+++ b/connectivity/workben/little/makefile.mk
@@ -0,0 +1,101 @@
+#*************************************************************************
+#
+#   $RCSfile: makefile.mk,v $
+#
+#   $Revision: 1.1.1.1 $
+#
+#   last change: $Author: hr $ $Date: 2000-09-18 16:14:29 $
+#
+#   The Contents of this file are made available subject to the terms of
+#   either of the following licenses
+#
+#          - GNU Lesser General Public License Version 2.1
+#          - Sun Industry Standards Source License Version 1.1
+#
+#   Sun Microsystems Inc., October, 2000
+#
+#   GNU Lesser General Public License Version 2.1
+#   =============================================
+#   Copyright 2000 by Sun Microsystems, Inc.
+#   901 San Antonio Road, Palo Alto, CA 94303, USA
+#
+#   This library is free software; you can redistribute it and/or
+#   modify it under the terms of the GNU Lesser General Public
+#   License version 2.1, as published by the Free Software Foundation.
+#
+#   This library is distributed in the hope that it will be useful,
+#   but WITHOUT ANY WARRANTY; without even the implied warranty of
+#   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+#   Lesser General Public License for more details.
+#
+#   You should have received a copy of the GNU Lesser General Public
+#   License along with this library; if not, write to the Free Software
+#   Foundation, Inc., 59 Temple Place, Suite 330, Boston,
+#   MA  02111-1307  USA
+#
+#
+#   Sun Industry Standards Source License Version 1.1
+#   =================================================
+#   The contents of this file are subject to the Sun Industry Standards
+#   Source License Version 1.1 (the "License"); You may not use this file
+#   except in compliance with the License. You may obtain a copy of the
+#   License at http://www.openoffice.org/license.html.
+#
+#   Software provided under this License is provided on an "AS IS" basis,
+#   WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING,
+#   WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
+#   MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
+#   See the License for the specific provisions governing your rights and
+#   obligations concerning the Software.
+#
+#   The Initial Developer of the Original Code is: Sun Microsystems, Inc.
+#
+#   Copyright: 2000 by Sun Microsystems, Inc.
+#
+#   All Rights Reserved.
+#
+#   Contributor(s): _______________________________________
+#
+#
+#
+#*************************************************************************
+
+PRJ=..\..
+
+PRJNAME=connectivity
+TARGET=little
+TARGETTYPE=CUI
+LIBTARGET=NO
+ENABLE_EXCEPTIONS=TRUE
+
+# --- Settings -----------------------------------------------------
+
+.INCLUDE :      svpre.mk
+.INCLUDE :      settings.mk
+.INCLUDE :      sv.mk
+
+# --- Files --------------------------------------------------------
+OBJFILES=       $(OBJ)$/main.obj 
+
+APP1TARGET= $(TARGET)
+APP1OBJS=       $(OBJFILES)
+APPSTDLIBS=$(SALLIB) \
+            $(VOSLIB) \
+            $(CPPULIB)	\
+            $(CPPUHELPERLIB)	\
+            $(SLB)$/sql.lib
+            
+
+# ... cfgapi ..............................
+APP1STDLIBS = $(APPSTDLIBS)
+
+APP1STDLIBS+=$(STDLIBCPP)
+
+.IF "$(GUI)"=="WNT"
+APP1STDLIBS+=$(LIBCIMT)
+.ENDIF
+
+# --- Targets ------------------------------------------------------
+
+.INCLUDE :      target.mk
+