com.mizar.persistence.jdbc.convert
Class JdbcOracleToSqlite

java.lang.Object
  extended by com.mizar.persistence.jdbc.convert.JdbcOracleToOtherRDBMS
      extended by com.mizar.persistence.jdbc.convert.JdbcOracleToSqlite

public class JdbcOracleToSqlite
extends JdbcOracleToOtherRDBMS

This class does not yet work because while the jdbc-sqlite.jar is supposed to support Spatial it seems to choke on the Select AddGeometryColumn() function. This will require more research but we'll put it off until we're certain we actually need it for a current project. On further research as of July 2010 there wasn't a driver that would support spatialite in any sort of an adequate fashion. So we'll leave this here until someone creates one.


Field Summary
 
Fields inherited from class com.mizar.persistence.jdbc.convert.JdbcOracleToOtherRDBMS
oraColumnMetaData, oraConn, oraTableMetaData, oraUrl, oraUser, targetColumnMetaData, targetConn, targetTableMetaData, targetTablespaceName, targetUrl, targetUser, targetUsesLowerCaseMetadata, targetUsesMetadata, verbose
 
Constructor Summary
JdbcOracleToSqlite()
           
 
Method Summary
 boolean createTargetTableLike(java.lang.String oraTableName)
           
 org.apache.commons.logging.Log getLogger()
           
static void main(java.lang.String[] args)
           
static void main2(java.lang.String[] args)
           
 java.sql.Connection targetConnect(java.lang.String url, java.lang.String usernameIgnored, java.lang.String passwordIgnored)
           
 
Methods inherited from class com.mizar.persistence.jdbc.convert.JdbcOracleToOtherRDBMS
close, copyTable, findAll, getCount, getOraColumnMetaData, getOraConn, getOraTableMetaData, getOraUrl, getOraUser, getTargetColumnMetaData, getTargetConn, getTargetTableMetaData, getTargetTablespaceName, getTargetUrl, getTargetUser, isTargetUsesLowerCaseMetadata, isTargetUsesMetadata, isVerbose, oracleConnect, setOraConn, setOraUrl, setOraUser, setTargetConn, setTargetTablespaceName, setTargetUrl, setTargetUser, setTargetUsesLowerCaseMetadata, setTargetUsesMetadata, setVerbose
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

JdbcOracleToSqlite

public JdbcOracleToSqlite()
Method Detail

getLogger

public org.apache.commons.logging.Log getLogger()
Specified by:
getLogger in class JdbcOracleToOtherRDBMS

targetConnect

public java.sql.Connection targetConnect(java.lang.String url,
                                         java.lang.String usernameIgnored,
                                         java.lang.String passwordIgnored)
                                  throws java.sql.SQLException,
                                         java.lang.ClassNotFoundException
Specified by:
targetConnect in class JdbcOracleToOtherRDBMS
Parameters:
url - for example "jdbc:sqlite:c:/temp/test.db"
usernameIgnored - required for complience with abstract definition
passwordIgnored - required for complience with abstract definition
Returns:
Throws:
java.sql.SQLException
java.lang.ClassNotFoundException

createTargetTableLike

public boolean createTargetTableLike(java.lang.String oraTableName)
                              throws java.sql.SQLException
Overrides:
createTargetTableLike in class JdbcOracleToOtherRDBMS
Throws:
java.sql.SQLException

main

public static void main(java.lang.String[] args)
                 throws java.lang.Exception
Throws:
java.lang.Exception

main2

public static void main2(java.lang.String[] args)
                  throws java.lang.Exception
Throws:
java.lang.Exception