Hi,
I have InterBase at home (Used to work for Borland on the C++Builder 4
application..got a free copy of it..which comes with InterBase Server 5.5,
Type IV driver, etc). I want to start creating some "generic" SQL scripts
that will work on all databases. These would be to create a database, create
a table(s), and insert data, search, update, delete, etc. Is it possible to
use InterBase at home, but deploy using IBM DB2, Oracle 8i, or even mysql.
The main reason is I want to set up a way to apply schema changes as needed
to any database in a generic standard way.
So, can I set up my site using InterBase, and easily move the schema to any
other database? IS that what JDBC 2.0 does for you. Not sure what the whole
DataSources if for, and how it applies to various app servers. Also, does
the DataSource stuff that Orion is using work on other app servers, or is it
strictly for Orion to work its connection pooling?
Thanks.
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of J.T. Wenting
> Sent: Monday, August 28, 2000 11:31 AM
> To: Orion-Interest
> Subject: RE: Orion and InterBase
>
>
> it works fine. Just copy interclient.jar to /orion/lib
> I use the following schema-xml:
>
> <?xml version="1.0"?>
> <!DOCTYPE database-schema PUBLIC "-//Evermind//- Database schema"
> "http://www.orionserver.com/dtds/database-schema.dtd">
>
> <database-schema name="Interbase" not-null="not null" null="default null"
> primary-key="primary key" max-table-name-lenght="30">
> <type-mapping type="java.lang.String" name="varchar(255)" />
> <type-mapping type="int" name="number(20,0)" />
> <type-mapping type="long" name="number(20,0)" />
> <type-mapping type="float" name="number(20,5)" />
> <type-mapping type="double" name="number(30,0)" />
> <type-mapping type="byte" name="number(10,0)" />
> <type-mapping type="char" name="char(1)" />
> <type-mapping type="short" name="number(10,0)" />
> <type-mapping type="boolean" name="number(1,0)" />
> <type-mapping type="java.util.Date" name="date" />
> <type-mapping type="java.io.Serializable" name="blob" />
>
> <disallowed-field name="password" />
> <disallowed-field name="date" />
> </database-schema>
>
>
> which seems to work. Any improvements are welcome ;)
>
> Jeroen T Wenting
> [EMAIL PROTECTED]
> ICQ UIN #9191966
>
> It's the end of the world as we know it and I feel fine (Michael Stipe)
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]On Behalf Of A. Gregory
> > Rabil
> > Sent: 28 August 2000 15:35
> > To: Orion-Interest
> > Subject: Orion and InterBase
> >
> >
> > Has anyone experienced connecting Orion to InterBase 6.0. I've been
> > successful hooking Orion up to several RDBMS via the
> > JDBC-ODBC bridge. With
> > InterBase, the InterClient package provides the connectivity
> > and the JDBC
> > driver. My data-sources.xml file looks something like the following:
> >
> > <data-source name="Default data-source"
> > class="com.evermind.sql.ConnectionDataSource"
> > location="jdbc/DefaultDS"
> > pooled-location="jdbc/DefaultPooledDS"
> > xa-location="jdbc/xa/DefaultXADS"
> > ejb-location="jdbc/DefaultEJBDS"
> > url="jdbc:interbase://localhost/E:/Inprise/InterBase/data/mydb.gdb"
> > connection-driver="interbase.interclient.Driver" username="user"
> > password="password" />
> > </data-sources>
> >
> > The interclient.jar file is in my classpath, but I get an
> > error when I start
> > Orion that it cannot locate the DriverManager
> > "interbase.interclient.Driver".
> >
> > Any ideas?
> >
> > Thanks,
> > Greg
> >
> >
> >
>
>
