Re: [sqlite] sqlite with Java

[Matthias-Christian Ott]

On 2017-03-21 21:36, Timothy Stack wrote:
> I see that you've got a solution working, but I wanted to mention this
> project which is a JDBC driver that can work with a dynamically linked
> sqlite library so there shouldn't be anything to recompile:

I can confirm that it's possible to dynamically link SQLite in a JDBC
driver without any additional problems.

I created JDBC driver for SQLite because I was disappointed with the
existing drivers. It takes between 30 to 200 person hours to create a
JDBC driver for SQLite, depending on your experience and the number of
features that you want to support. So perhaps that is also an option.

- Matthias

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite with Java

[Timothy Stack]

I see that you've got a solution working, but I wanted to mention this
project which is a JDBC driver that can work with a dynamically linked
sqlite library so there shouldn't be anything to recompile:

  https://github.com/tstack/SqliteJdbcNG

Unfortunately, it hasn't seen updates for a couple years, but I think
it still works.

thanks,

tim stack

On Fri, Mar 17, 2017 at 2:35 PM, Sylvain Pointeau <
sylvain.point...@gmail.com> wrote:

> Dear all,
>
> I would like to use sqlite from Java, but I am also looking to buy SSE.
> however which library would you recommend? how to integrate SSE?
>
> ps: it would be splendid if you could provide the java libs, similar to the
> .net version.
>
> Best regard,
> Sylvain
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite with Java

[Sylvain Pointeau]

> OK yes I agree, where can we discuss about it?
>
>
For information, we continued this discussion privately.

I succeed to build this library and I will use it in my project.
Additionally I would be glad contribute if Christian needs my help.
Furthermore, I will assess my need to have SSE, and if yes, I will buy it
and integrate it (quite easily).

I will also blog on how to compile it and how to use it, sooner or later,
it might help other people having the same need.

Best regards,
Sylvain
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite with Java

[Christian Werner]

On 03/19/2017 06:38 PM, Sylvain Pointeau wrote:


IMO it is no good idea to discuss specific issues of an only indirectly
SQLite related
library on this mailing list



OK yes I agree, where can we discuss about it?


C'mon, you apparently obtained the source code of this dead project, didn't you?

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite with Java

[Sylvain Pointeau]

>
>
> IMO it is no good idea to discuss specific issues of an only indirectly
> SQLite related
> library on this mailing list


OK yes I agree, where can we discuss about it?

>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite with Java

[Christian Werner]

On 03/19/2017 05:38 PM, Sylvain Pointeau wrote:

On Sun, Mar 19, 2017 at 4:57 PM, Sylvain Pointeau <
sylvain.point...@gmail.com> wrote:


Why don't you provide an up-to-date version? this lib seems dead when we

look at the website, also why don't you put the sources on git it would be
easier to contribute or raise a bug if any...



I tried to compile the latest version of sqlite 3.17 with the latest
sources of sqlitejava  (http://www.ch-werner.de/javasqlite) with VS2015
Express Edition
I downloaded the latest jdk-8u121.

I have the following error: SQLite\JDBCDriver.java:9: error: JDBCDriver is
not abstract and does not override abstract method getParentLogger() in
Driver



I just tried with jdk-6u45-x86:


IMO it is no good idea to discuss specific issues of an only indirectly SQLite 
related
library on this mailing list.

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite with Java

[Sylvain Pointeau]

On Sun, Mar 19, 2017 at 5:38 PM, Sylvain Pointeau <
sylvain.point...@gmail.com> wrote:

> On Sun, Mar 19, 2017 at 4:57 PM, Sylvain Pointeau <
> sylvain.point...@gmail.com> wrote:
>
>> Why don't you provide an up-to-date version? this lib seems dead when we
>>> look at the website, also why don't you put the sources on git it would be
>>> easier to contribute or raise a bug if any...
>>>
>>
>> I tried to compile the latest version of sqlite 3.17 with the latest
>> sources of sqlitejava  (http://www.ch-werner.de/javasqlite) with VS2015
>> Express Edition
>> I downloaded the latest jdk-8u121.
>>
>> I have the following error: SQLite\JDBCDriver.java:9: error: JDBCDriver
>> is not abstract and does not override abstract method getParentLogger() in
>> Driver
>>
>
> I just tried with jdk-6u45-x86:
>
> SQLite\JDBC2x\JDBCConnection.java:17: SQLite.JDBC2x.JDBCConnection is not
> abstract and does not override abstract method
> createStruct(java.lang.String,java.lang.Object[]) in java.sql.Connection
> public class JDBCConnection
>^
> .\SQLite\JDBC2x\JDBCDatabaseMetaData.java:10: 
> SQLite.JDBC2x.JDBCDatabaseMetaData
> is not abstract and does not override abstract method
> getFunctionColumns(java.lang.String,java.lang.String,java.lang.String,java.lang.String)
> in java.sql.DatabaseMetaData
> public class JDBCDatabaseMetaData implements DatabaseMetaData {
>^
>

it works with jdk-1_5_0_22

Please could we move this library to compile with the newest JDK and VS2015
without error and warning?

I am ready to help for windows.

Best regards,
Sylvain
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite with Java

[Sylvain Pointeau]

On Sun, Mar 19, 2017 at 4:57 PM, Sylvain Pointeau <
sylvain.point...@gmail.com> wrote:

> Why don't you provide an up-to-date version? this lib seems dead when we
>> look at the website, also why don't you put the sources on git it would be
>> easier to contribute or raise a bug if any...
>>
>
> I tried to compile the latest version of sqlite 3.17 with the latest
> sources of sqlitejava  (http://www.ch-werner.de/javasqlite) with VS2015
> Express Edition
> I downloaded the latest jdk-8u121.
>
> I have the following error: SQLite\JDBCDriver.java:9: error: JDBCDriver is
> not abstract and does not override abstract method getParentLogger() in
> Driver
>

I just tried with jdk-6u45-x86:

SQLite\JDBC2x\JDBCConnection.java:17: SQLite.JDBC2x.JDBCConnection is not
abstract and does not override abstract method
createStruct(java.lang.String,java.lang.Object[]) in java.sql.Connection
public class JDBCConnection
   ^
.\SQLite\JDBC2x\JDBCDatabaseMetaData.java:10:
SQLite.JDBC2x.JDBCDatabaseMetaData is not abstract and does not override
abstract method
getFunctionColumns(java.lang.String,java.lang.String,java.lang.String,java.lang.String)
in java.sql.DatabaseMetaData
public class JDBCDatabaseMetaData implements DatabaseMetaData {
   ^
.\SQLite\JDBC2x\JDBCResultSet.java:12: SQLite.JDBC2x.JDBCResultSet is not
abstract and does not override abstract method
updateNClob(java.lang.String,java.io.Reader) in java.sql.ResultSet
public class JDBCResultSet implements java.sql.ResultSet {
   ^
.\SQLite\JDBC2x\JDBCStatement.java:6: SQLite.JDBC2x.JDBCStatement is not
abstract and does not override abstract method isPoolable() in
java.sql.Statement
public class JDBCStatement implements java.sql.Statement {
   ^
.\SQLite\JDBC2x\JDBCResultSetMetaData.java:5:
SQLite.JDBC2x.JDBCResultSetMetaData is not abstract and does not override
abstract method isWrapperFor(java.lang.Class) in java.sql.Wrapper
public class JDBCResultSetMetaData implements java.sql.ResultSetMetaData {
   ^
.\SQLite\JDBC2x\JDBCPreparedStatement.java:17:
SQLite.JDBC2x.JDBCPreparedStatement is not abstract and does not override
abstract method setNClob(int,java.io.Reader) in java.sql.PreparedStatement
public class JDBCPreparedStatement extends JDBCStatement
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite with Java

[Sylvain Pointeau]

>
> Why don't you provide an up-to-date version? this lib seems dead when we
> look at the website, also why don't you put the sources on git it would be
> easier to contribute or raise a bug if any...
>

I tried to compile the latest version of sqlite 3.17 with the latest
sources of sqlitejava  (http://www.ch-werner.de/javasqlite) with VS2015
Express Edition
I downloaded the latest jdk-8u121.

I have the following error: SQLite\JDBCDriver.java:9: error: JDBCDriver is
not abstract and does not override abstract method getParentLogger() in
Driver
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite with Java

[Sylvain Pointeau]

> Now I'm a little bit confused. You asked for an SEE enabled SQLite Java
> binding. This requires you to 1. obtain your SEE license from DRH's company
> and 2. to use the SEE sources and compile/link them to
> {lib,}sqlite_jni.{dll,so}
> for your target platform.
>

Don't be confused, I know all that, but before to buy the SSE (it is
2'000), I need:
1- to choose a sqlite jdbc driver allowing SSE (done)
2- to test the java driver to see if I can migrate successfully from H2 to
sqlite (I will do that in the next coming week(s))
3- to really assess if I need still need encryption in my project (after
some recent changes)

For now I tested your driver (quicky) and it seems I can use it, so 1 is
done, I need to do 2.


>
> So in any case involving SEE you have to rebuild things from source code
> and deal with deployment on the target environment.
>
>
Yes and I have a compiler on another machine, but for a matter of testing
quickly, I would not like go through the compile cycle.
Anyway, for now I tested with the outdated version (3.7.7.1)

Why don't you provide an up-to-date version? this lib seems dead when we
look at the website, also why don't you put the sources on git it would be
easier to contribute or raise a bug if any...
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite with Java

[Christian Werner]

On 03/18/2017 02:01 PM, Sylvain Pointeau wrote:


If properly installed there should be no need to explicitly set a path.



You mean in the JDK (or JRE)? (if yes -> this is not always possible)

another question, do you confirm that sqlite3 is included into
sqlite_jni.dll?


Now I'm a little bit confused. You asked for an SEE enabled SQLite Java
binding. This requires you to 1. obtain your SEE license from DRH's company
and 2. to use the SEE sources and compile/link them to {lib,}sqlite_jni.{dll,so}
for your target platform.

So in any case involving SEE you have to rebuild things from source code
and deal with deployment on the target environment.

Regarding the {lib,}sqlite_jni.{dll,so}: it depends on the platform,
for Windows the SQLite 3 (and optionally 2) engine usually is directly linked
into that library. For Linuxen many distros have a javasqlite-something
package where the maintainers chose to dynamically link to the system
SQLite 3 library.

HTH,
Christian

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite with Java

[Sylvain Pointeau]

On Sat, Mar 18, 2017 at 1:04 PM, Christian Werner <
christian.wer...@t-online.de> wrote:

> Could it be updated to the latest version of sqlite, seems it is pretty
>> outdated now.
>>
>
> Totally outdated but still compiling even with most recent SQLite 3 (and 2)
> versions and having autoconf OOTB support for SEE. Must be steampunk then
> ;-)
>

I am on a computer without compilers, it would have been good if I could
test with the latest version.

Could it be also improved? not needing to set the path of the native
>> library? like xerial made it, is it possible?
>>
>
> If properly installed there should be no need to explicitly set a path.
>

You mean in the JDK (or JRE)? (if yes -> this is not always possible)

another question, do you confirm that sqlite3 is included into
sqlite_jni.dll?

Best regards,
Sylvain
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite with Java

[Christian Werner]

Could it be updated to the latest version of sqlite, seems it is pretty
outdated now.


Totally outdated but still compiling even with most recent SQLite 3 (and 2)
versions and having autoconf OOTB support for SEE. Must be steampunk then ;-)


Could it be also improved? not needing to set the path of the native
library? like xerial made it, is it possible?


If properly installed there should be no need to explicitly set a path.


does this jdbc driver give the metadata?


Yes.

Best,
Christian

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite with Java

[Sylvain Pointeau]

Le sam. 18 mars 2017 à 09:53, Christian Werner 
a écrit :

> On 03/18/2017 06:21 AM, Sylvain Pointeau wrote:
> > I don't really want to use odbc in Java. I was thinking of
> > https://github.com/xerial/sqlite-jdbc
> > but how to use SSE in this case? seems the build is not so easy.
>
> You could use http://www.ch-werner.de/javasqlite which can be built with
> SEE.


OK I can give it a try.

Could it be updated to the latest version of sqlite, seems it is pretty
outdated now.
Could it be also improved? not needing to set the path of the native
library? like xerial made it, is it possible?

does this jdbc driver give the metadata?

Best regards,
Sylvain


>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite with Java

[Christian Werner]

On 03/18/2017 06:21 AM, Sylvain Pointeau wrote:

I don't really want to use odbc in Java. I was thinking of
https://github.com/xerial/sqlite-jdbc
but how to use SSE in this case? seems the build is not so easy.


You could use http://www.ch-werner.de/javasqlite which can be built with SEE.

Best,
Christian

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite with Java

[Sylvain Pointeau]

I don't really want to use odbc in Java. I was thinking of
https://github.com/xerial/sqlite-jdbc
but how to use SSE in this case? seems the build is not so easy.

with the sqlite odbc module
>
> http://www.ch-werner.de/sqliteodbc
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite with Java

[PICCORO McKAY Lenz]

one solution its use the odbc sqlite brigde

http://www.java2s.com/Tutorial/Java/0340__Database/ConnecttoAccessDatabaseusingJDBCODBCbridge.htm

with the sqlite odbc module

http://www.ch-werner.de/sqliteodbc/

so due i dont see here java (a general great widely use due
portability) facilities, and too much .net facilities

the other its used 3dr party as:
http://www.sqlitetutorial.net/sqlite-java/

that's enough info
Lenz McKAY Gerardo (PICCORO)
http://qgqlochekone.blogspot.com


2017-03-17 17:35 GMT-04:00 Sylvain Pointeau :
> Dear all,
>
> I would like to use sqlite from Java, but I am also looking to buy SSE.
> however which library would you recommend? how to integrate SSE?
>
> ps: it would be splendid if you could provide the java libs, similar to the
> .net version.
>
> Best regard,
> Sylvain
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and Java

[Sylvain Pointeau]

> my program language is Java. And the www.sqlite.org not supply API for
Java. What should I do?

I think this one is the best
http://code.google.com/p/sqlite-jdbc/

Best regards,
Sylvain
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and Java

[Martin Engelschalk]

Yin,

A Google search of "sqlite java api" gives several good hits.

Click on the first http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers 
and scroll down to Java

Martin

Am 02.08.2011 06:01, schrieb yinlijie2011:
> Dear,
>  I want use SQLite, but my program language is Java. And 
> thewww.sqlite.org not supply API for Java. What should I do?
>  Thank you!
>
>  Yin Lijie
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite wrapper Java Linux: No suitable driver

[Joe Wilson]

--- Pasquale Imbemba <[EMAIL PROTECTED]> wrote:
> I am using the sqlite wrapper by Christian Werner for Java on my Linux
> machine. I use eclipse and I have create da new project which contains
> the SQLite.jar stuff.
> 
> Whenever I try to compile, I get the following error:
> java.lang.ClassNotFoundException: SQLite.JDBC2y.JDBCConnection
> Error: java.sql.SQLException: No suitable driver
>
> I found this link from Sun's Java Technology site
> (http://forum.java.sun.com/thread.jspa?threadID=602869=3248193), 
> where it says I can't use this wrapper "as is" for 1.5. (I am using JDK 
> 5.0.6). 

The solution is given in the link you provided:

 "This driver was compiled with JRE 1.4.2 and is working 
 with this version. If you use 1.5.* you must recompile 
 it with this Java version."

So you must either:
(a) run your existing code with JRE 1.4.2, or 
(b) recompile (./configure && make) the SQLite driver from 
source code using JDK 1.5.0 to use it with JRE 1.5.0.

The SQLite.JDBCDriver checks the java version at runtime and 
loads different classes. If you want the same driver sqlite.jar 
file to run under JRE 1.4, JRE 1.5 or higher, I think the following 
untested patch (./configure && make using JDK 1.4.2) should work:

--- javasqlite-20050608/SQLite/JDBCDriver.java-orig 2006-05-11 
20:58:10.0 -0400
+++ javasqlite-20050608/SQLite/JDBCDriver.java  2006-05-11 20:58:56.0 
-0400
@@ -26,10 +26,8 @@
cvers = "SQLite.JDBC1.JDBCConnection";
} else if (jvers.startsWith("1.2") || jvers.startsWith("1.3")) {
cvers = "SQLite.JDBC2.JDBCConnection";
-   } else if (jvers.startsWith("1.4")) {
-   cvers = "SQLite.JDBC2x.JDBCConnection";
} else {
-   cvers = "SQLite.JDBC2y.JDBCConnection";
+   cvers = "SQLite.JDBC2x.JDBCConnection";
}
connClass = Class.forName(cvers);
makeConn = connClass.getConstructor(args);


__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Re: [sqlite] SQLite wrapper Java Linux: No suitable driver

[Pasquale Imbemba]

On 10/05/06, [EMAIL PROTECTED] <[EMAIL PROTECTED] >
wrote:


Make sure the sqlite_jni.dll DLL is in your path!

Andi



I don't have that file, but  this libsqlite_jni.so . I understand I must
have this also in my build path but I don't figure out how to do it in
eclipse. I do Build Path -> Link additional source to project and then point
to the location where the .so is contained. Doesn't work.

Pasquale

RE: [sqlite] SQLite wrapper Java Linux: No suitable driver

[andreas.goetz]

Make sure the sqlite_jni.dll DLL is in your path!

Andi 

-Original Message-
From: Pasquale Imbemba [mailto:[EMAIL PROTECTED] 
Sent: Mittwoch, 10. Mai 2006 18:41
To: SQLite
Subject: [sqlite] SQLite wrapper Java Linux: No suitable driver

Hi,

I am using the sqlite wrapper by Christian Werner for Java on my Linux
machine. I use eclipse and I have create da new project which contains
the SQLite.jar stuff.

My code looks like this:

import SQLite.JDBCDriver;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;



public class JDBCTest {

/**
 * @param args
 */
public static void main(String[] args) {
// TODO Auto-generated method stub
try {
Class.forName("SQLite.JDBCDriver");

String
url="jdbc:sqlite://home/pasquale/test.db";
Connection db =
DriverManager.getConnection(url);
Statement st = db.createStatement();

//Execute query
ResultSet rs = st.executeQuery("SELECT * "+"FROM
tbl1");

System.out.println("Output:");

while (rs.next()){
System.out.println(rs.getString(0)+ " "
+ rs.getString(1));
}
} catch (ClassNotFoundException e){
System.err.println("Error: "+e);
} catch (SQLException e){
System.err.println("Error: "+e );
}
}
}

Whenever I try to compile, I get the following error:
java.lang.ClassNotFoundException: SQLite.JDBC2y.JDBCConnection
Error: java.sql.SQLException: No suitable driver

I found this link from Sun's Java Technology site
(http://forum.java.sun.com/thread.jspa?threadID=602869=3248193
), where it says I can't use this wrapper "as is" for 1.5. (I am using
JDK 5.0.6). But I don't have clear what to do.

Could someone please help?
tia
Pasquale



This message is for the designated recipient only and may contain privileged, 
proprietary, or otherwise private information.  If you have received it in 
error, please notify the sender immediately and delete the original.  Any other 
use of the email by you is prohibited.

Re: [sqlite] RE: [RBL] Re: [sqlite] Sqlite and Java

[John Stanton]

Fred makes a good point.  A well conceived software solution is a good 
investment and a slipshod, makeshift solution not an investment but an 
ongoing liability.  We have some software which was carefully thought 
through initially and has been in constant national use for close to 
twenty years again on generation after generation of hardware, simply 
because the problem did not change.  Surely one's clients deserve to 
have their money spent prudently in the spirit of "If you don't have 
time to do it right you don't have time to do it twice".


I would expect that some of the Sqlite applications being developed 
today will have an inherent simplicity and direct function such that 
they will also be functioning in decades hence despite fashion changes 
and hardware advances.   Sqlite follows Einstein's view "Make it as 
simple as possible but no simpler".  JS


Fred Williams wrote:

You points are understood.  But I've always attempted to use a hammer
for a nail and a screwdriver for a screw.  This extra effort always
produces a much cleaner and professional result.

Good clients know that response time is money and resources they spend
every day and at every seat.  Proper software development is a high cost
one time event.  I have had occasion to see code I have written running
five plus years after implementation.  In that time migrated across
three platforms.

Fred



-Original Message-
From: Steve O'Hara [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 22, 2006 4:06 AM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] RE: [RBL] Re: [sqlite] Sqlite and Java


You're right to a certain extent, but the point I was trying
to address
was the ideal of being able to use an SQLite database from a
variety of
toolsets and environments natively.  If you've ever written JNI you'll
know why this is a pain and a Java only implementation would be sweet.

Also, not all SQL engines work the same way and I'm certain HSQLD is
slower than SQLite architecturally, not because it's implemented in
Java.  After all, there is a non-free variant of HSQLDB
(HyperXtremSQL)
written in Java by the same author that is 50% faster - he didn't get
that by tweaking the code, more like re-architecting the storage.

The language is just a tool, a way of describing a solution to a
machine.  The judgement of performance etc of a language is a little
specious because it implies a generalisation of how the language is
implemented on a particular platform.  I've learned to like
Java because
I've got a beautiful development environment (intelliJ IDEA) and in my
professional life, speed/quality of development is more important than
response times.  My clients would prefer to spend more money
on hardware
than on consultancy - who can blame them.

Steve

-Original Message-
From:
[EMAIL PROTECTED]
[mailto:sqlite-users-return-10034-sohara=pivotal-solutions.co.
[EMAIL PROTECTED]
org] On Behalf Of Fred Williams
Sent: 21 January 2006 15:52
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] RE: [RBL] Re: [sqlite] Sqlite and Java

I think if you will closely read you own analysis of your efforts you
will realize that all of the "down side" issues you have enumerated
relate directly to the implementation language and not the database or
its structure.  In Java there is no such thing as AnythingLite, IMHO.
Java, like so many other languages has grown well beyond its initial
intent, small, simple applets imbedded on a web page.

With all of our advances in programming we still have not evolved that
"perfect" language, and most likely never will.  I spite of what those
"C" guys tell you :-)

Fred



-Original Message-
From: Steve O'Hara [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 21, 2006 7:37 AM
To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
Subject: [sqlite] RE: [RBL] Re: [sqlite] Sqlite and Java



I did loads of research on this and even tinkered with a c to Java
converter, which got me a little bit further forward.  However, I
realised that I would be facing a huge effort to create the


code base


and then have to support it within our projects.  So


despite being an


SQLite zealot, I had to reluctantly nail my colours to one of the
existing Java tools.

I chose HSQLDB, after trying out most of the others, this


was the only


one that got close to the file distribution format of SQLite i.e.
database in a file.  It took quite a bit of tinkering to


get the right


mix of CACHED and MEMORY tables so that performance on start-up was
good.  Also, I had terrible trouble with mass imports causing memory
(what a surprise - Java) problems and it took a good few runs
to get it
to properly index etc.  Also, I had to be much more


specific about the


column definitions than with SQLite, otherwise my database


files grew


horribly.  Also, you can only interact with HSQLDB via


JDBC, not a big


problem in Java obviously.  Performance was nowhere near as good as
SQLite.

RE: [sqlite] RE: [RBL] Re: [sqlite] Sqlite and Java

[Fred Williams]

You points are understood.  But I've always attempted to use a hammer
for a nail and a screwdriver for a screw.  This extra effort always
produces a much cleaner and professional result.

Good clients know that response time is money and resources they spend
every day and at every seat.  Proper software development is a high cost
one time event.  I have had occasion to see code I have written running
five plus years after implementation.  In that time migrated across
three platforms.

Fred

> -Original Message-
> From: Steve O'Hara [mailto:[EMAIL PROTECTED]
> Sent: Sunday, January 22, 2006 4:06 AM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] RE: [RBL] Re: [sqlite] Sqlite and Java
>
>
> You're right to a certain extent, but the point I was trying
> to address
> was the ideal of being able to use an SQLite database from a
> variety of
> toolsets and environments natively.  If you've ever written JNI you'll
> know why this is a pain and a Java only implementation would be sweet.
>
> Also, not all SQL engines work the same way and I'm certain HSQLD is
> slower than SQLite architecturally, not because it's implemented in
> Java.  After all, there is a non-free variant of HSQLDB
> (HyperXtremSQL)
> written in Java by the same author that is 50% faster - he didn't get
> that by tweaking the code, more like re-architecting the storage.
>
> The language is just a tool, a way of describing a solution to a
> machine.  The judgement of performance etc of a language is a little
> specious because it implies a generalisation of how the language is
> implemented on a particular platform.  I've learned to like
> Java because
> I've got a beautiful development environment (intelliJ IDEA) and in my
> professional life, speed/quality of development is more important than
> response times.  My clients would prefer to spend more money
> on hardware
> than on consultancy - who can blame them.
>
> Steve
>
> -Original Message-
> From:
> [EMAIL PROTECTED]
> [mailto:sqlite-users-return-10034-sohara=pivotal-solutions.co.
> [EMAIL PROTECTED]
> org] On Behalf Of Fred Williams
> Sent: 21 January 2006 15:52
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] RE: [RBL] Re: [sqlite] Sqlite and Java
>
> I think if you will closely read you own analysis of your efforts you
> will realize that all of the "down side" issues you have enumerated
> relate directly to the implementation language and not the database or
> its structure.  In Java there is no such thing as AnythingLite, IMHO.
> Java, like so many other languages has grown well beyond its initial
> intent, small, simple applets imbedded on a web page.
>
> With all of our advances in programming we still have not evolved that
> "perfect" language, and most likely never will.  I spite of what those
> "C" guys tell you :-)
>
> Fred
>
> > -----Original Message-
> > From: Steve O'Hara [mailto:[EMAIL PROTECTED]
> > Sent: Saturday, January 21, 2006 7:37 AM
> > To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
> > Subject: [sqlite] RE: [RBL] Re: [sqlite] Sqlite and Java
> >
> >
> >
> > I did loads of research on this and even tinkered with a c to Java
> > converter, which got me a little bit further forward.  However, I
> > realised that I would be facing a huge effort to create the
> code base
> > and then have to support it within our projects.  So
> despite being an
> > SQLite zealot, I had to reluctantly nail my colours to one of the
> > existing Java tools.
> >
> > I chose HSQLDB, after trying out most of the others, this
> was the only
> > one that got close to the file distribution format of SQLite i.e.
> > database in a file.  It took quite a bit of tinkering to
> get the right
> > mix of CACHED and MEMORY tables so that performance on start-up was
> > good.  Also, I had terrible trouble with mass imports causing memory
> > (what a surprise - Java) problems and it took a good few runs
> > to get it
> > to properly index etc.  Also, I had to be much more
> specific about the
> > column definitions than with SQLite, otherwise my database
> files grew
> > horribly.  Also, you can only interact with HSQLDB via
> JDBC, not a big
> > problem in Java obviously.  Performance was nowhere near as good as
> > SQLite.
> >
> > However, the upside is that HSQLDB is free, simple to deploy, has
> > standalone/server/servlet/in-memory deployment versions and is
> > reasonably perfomant.
> >
> > Hope this helps,
> >
> > Steve
> >
> > p.s. I'd still prefer a Java SQLite but there you are
> >
> >
> >
> > -

RE: [sqlite] RE: [RBL] Re: [sqlite] Sqlite and Java

[Steve O'Hara]

You're right to a certain extent, but the point I was trying to address
was the ideal of being able to use an SQLite database from a variety of
toolsets and environments natively.  If you've ever written JNI you'll
know why this is a pain and a Java only implementation would be sweet.

Also, not all SQL engines work the same way and I'm certain HSQLD is
slower than SQLite architecturally, not because it's implemented in
Java.  After all, there is a non-free variant of HSQLDB  (HyperXtremSQL)
written in Java by the same author that is 50% faster - he didn't get
that by tweaking the code, more like re-architecting the storage.

The language is just a tool, a way of describing a solution to a
machine.  The judgement of performance etc of a language is a little
specious because it implies a generalisation of how the language is
implemented on a particular platform.  I've learned to like Java because
I've got a beautiful development environment (intelliJ IDEA) and in my
professional life, speed/quality of development is more important than
response times.  My clients would prefer to spend more money on hardware
than on consultancy - who can blame them.

Steve

-Original Message-
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
org] On Behalf Of Fred Williams
Sent: 21 January 2006 15:52
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] RE: [RBL] Re: [sqlite] Sqlite and Java

I think if you will closely read you own analysis of your efforts you
will realize that all of the "down side" issues you have enumerated
relate directly to the implementation language and not the database or
its structure.  In Java there is no such thing as AnythingLite, IMHO.
Java, like so many other languages has grown well beyond its initial
intent, small, simple applets imbedded on a web page.

With all of our advances in programming we still have not evolved that
"perfect" language, and most likely never will.  I spite of what those
"C" guys tell you :-)

Fred

> -Original Message-
> From: Steve O'Hara [mailto:[EMAIL PROTECTED]
> Sent: Saturday, January 21, 2006 7:37 AM
> To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
> Subject: [sqlite] RE: [RBL] Re: [sqlite] Sqlite and Java
>
>
>
> I did loads of research on this and even tinkered with a c to Java
> converter, which got me a little bit further forward.  However, I
> realised that I would be facing a huge effort to create the code base
> and then have to support it within our projects.  So despite being an
> SQLite zealot, I had to reluctantly nail my colours to one of the
> existing Java tools.
>
> I chose HSQLDB, after trying out most of the others, this was the only
> one that got close to the file distribution format of SQLite i.e.
> database in a file.  It took quite a bit of tinkering to get the right
> mix of CACHED and MEMORY tables so that performance on start-up was
> good.  Also, I had terrible trouble with mass imports causing memory
> (what a surprise - Java) problems and it took a good few runs
> to get it
> to properly index etc.  Also, I had to be much more specific about the
> column definitions than with SQLite, otherwise my database files grew
> horribly.  Also, you can only interact with HSQLDB via JDBC, not a big
> problem in Java obviously.  Performance was nowhere near as good as
> SQLite.
>
> However, the upside is that HSQLDB is free, simple to deploy, has
> standalone/server/servlet/in-memory deployment versions and is
> reasonably perfomant.
>
> Hope this helps,
>
> Steve
>
> p.s. I'd still prefer a Java SQLite but there you are
>
>
>
> -Original Message-
> From:
> [EMAIL PROTECTED]
> [mailto:sqlite-users-return-9982-sohara=pivotal-solutions.co.u
[EMAIL PROTECTED]
rg] On Behalf Of Ran
Sent: 19 January 2006 14:13
To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
Subject: [RBL] Re: [sqlite] Sqlite and Java

If I am not mistaken, the following thread might be relevant:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg11005.html

Ran

On 1/19/06, Nilo Paim <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> Does anybody here knows something about a port of sqlite to java?
>
> Please, note that I'm not talking about java calling sqlite via JNI,
but
> about a real rewrite of sqlite using java. Obviously, a second step
> would be the writing of a JDBC driver.
>
> Would be useful that port?
>
> Comments? Suggestions?
>
> Thanks to all.
>
> Nilo
> Porto Alegre - Brasil
>

RE: [sqlite] RE: [RBL] Re: [sqlite] Sqlite and Java

[Fred Williams]

I think if you will closely read you own analysis of your efforts you
will realize that all of the "down side" issues you have enumerated
relate directly to the implementation language and not the database or
its structure.  In Java there is no such thing as AnythingLite, IMHO.
Java, like so many other languages has grown well beyond its initial
intent, small, simple applets imbedded on a web page.

With all of our advances in programming we still have not evolved that
"perfect" language, and most likely never will.  I spite of what those
"C" guys tell you :-)

Fred

> -Original Message-
> From: Steve O'Hara [mailto:[EMAIL PROTECTED]
> Sent: Saturday, January 21, 2006 7:37 AM
> To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
> Subject: [sqlite] RE: [RBL] Re: [sqlite] Sqlite and Java
>
>
>
> I did loads of research on this and even tinkered with a c to Java
> converter, which got me a little bit further forward.  However, I
> realised that I would be facing a huge effort to create the code base
> and then have to support it within our projects.  So despite being an
> SQLite zealot, I had to reluctantly nail my colours to one of the
> existing Java tools.
>
> I chose HSQLDB, after trying out most of the others, this was the only
> one that got close to the file distribution format of SQLite i.e.
> database in a file.  It took quite a bit of tinkering to get the right
> mix of CACHED and MEMORY tables so that performance on start-up was
> good.  Also, I had terrible trouble with mass imports causing memory
> (what a surprise - Java) problems and it took a good few runs
> to get it
> to properly index etc.  Also, I had to be much more specific about the
> column definitions than with SQLite, otherwise my database files grew
> horribly.  Also, you can only interact with HSQLDB via JDBC, not a big
> problem in Java obviously.  Performance was nowhere near as good as
> SQLite.
>
> However, the upside is that HSQLDB is free, simple to deploy, has
> standalone/server/servlet/in-memory deployment versions and is
> reasonably perfomant.
>
> Hope this helps,
>
> Steve
>
> p.s. I'd still prefer a Java SQLite but there you are
>
>
>
> -Original Message-
> From:
> [EMAIL PROTECTED]
> [mailto:sqlite-users-return-9982-sohara=pivotal-solutions.co.u
[EMAIL PROTECTED]
rg] On Behalf Of Ran
Sent: 19 January 2006 14:13
To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
Subject: [RBL] Re: [sqlite] Sqlite and Java

If I am not mistaken, the following thread might be relevant:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg11005.html

Ran

On 1/19/06, Nilo Paim <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> Does anybody here knows something about a port of sqlite to java?
>
> Please, note that I'm not talking about java calling sqlite via JNI,
but
> about a real rewrite of sqlite using java. Obviously, a second step
> would be the writing of a JDBC driver.
>
> Would be useful that port?
>
> Comments? Suggestions?
>
> Thanks to all.
>
> Nilo
> Porto Alegre - Brasil
>

[sqlite] RE: [RBL] Re: [sqlite] Sqlite and Java

[Steve O'Hara]

I did loads of research on this and even tinkered with a c to Java
converter, which got me a little bit further forward.  However, I
realised that I would be facing a huge effort to create the code base
and then have to support it within our projects.  So despite being an
SQLite zealot, I had to reluctantly nail my colours to one of the
existing Java tools.

I chose HSQLDB, after trying out most of the others, this was the only
one that got close to the file distribution format of SQLite i.e.
database in a file.  It took quite a bit of tinkering to get the right
mix of CACHED and MEMORY tables so that performance on start-up was
good.  Also, I had terrible trouble with mass imports causing memory
(what a surprise - Java) problems and it took a good few runs to get it
to properly index etc.  Also, I had to be much more specific about the
column definitions than with SQLite, otherwise my database files grew
horribly.  Also, you can only interact with HSQLDB via JDBC, not a big
problem in Java obviously.  Performance was nowhere near as good as
SQLite.

However, the upside is that HSQLDB is free, simple to deploy, has
standalone/server/servlet/in-memory deployment versions and is
reasonably perfomant.

Hope this helps,

Steve

p.s. I'd still prefer a Java SQLite but there you are

 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
rg] On Behalf Of Ran
Sent: 19 January 2006 14:13
To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
Subject: [RBL] Re: [sqlite] Sqlite and Java

If I am not mistaken, the following thread might be relevant:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg11005.html

Ran

On 1/19/06, Nilo Paim <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> Does anybody here knows something about a port of sqlite to java?
>
> Please, note that I'm not talking about java calling sqlite via JNI,
but
> about a real rewrite of sqlite using java. Obviously, a second step
> would be the writing of a JDBC driver.
>
> Would be useful that port?
>
> Comments? Suggestions?
>
> Thanks to all.
>
> Nilo
> Porto Alegre - Brasil
>

Re: [sqlite] Sqlite and Java

[Gerhard Häring]

Nilo Paim wrote:
My point is: if I use another sql engine that is written in Java then I 
just inverted the problem: how to access the databases without writing a 
bridge in native code that allows me to access the database from C or 
C++ or... ?


Use a database server with client interfaces then.

-- Gerhard

Re: [sqlite] Sqlite and Java

[Ulrik Petersen]

Jonathan Ballet wrote:


Noel Frankinet wrote:
 


Nilo Paim wrote:

   


Hi Noel,

Maybe slower, maybe memory hungry... but not less portable in my
opinion. Java is machine independent, unless when using native code.
On that scenario ( native code ) Java is not portable.

My point is: I would like to have access to sqlite databases from
java without worrying me about native code, dll's, .so'es, etc...,
just using only pure java code, without lossing the normal access to
the same databases, using the "normal" way, via C, C++ or any other
compiled language.

Thanks for your quick response.

Cheers,

Nilo
Porto Alegre - Brasil

 


Hello Nilo,

I think there a IBM open source sql engine in pure Java. But I don't
rember the name right now.
May be you could use that ?

Regards

   


I think you're talking of http://hsqldb.org/, used among other project
by OpenOffice ...
 



I think Noël may be talking about Apache Derby, formerly IBM Cloudscape:

http://db.apache.org/derby/

Regards,

Ulrik Petersen

Re: [sqlite] Sqlite and Java

[Noel Frankinet]

Kervin L. Pierre wrote:



Cloudscape, which was given to Apache foundation
and is now the Apache Derby Project.
http://db.apache.org/derby/



Yes this is it !

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] Sqlite and Java

[Kervin L. Pierre]

Cloudscape, which was given to Apache foundation
and is now the Apache Derby Project.
http://db.apache.org/derby/

Jonathan Ballet wrote:

I think you're talking of http://hsqldb.org/, used among other project
by OpenOffice ...

Re: [sqlite] Sqlite and Java

[Nilo Paim]

Noel Frankinet wrote:


Nilo Paim wrote:




Hi Noel,

Maybe slower, maybe memory hungry... but not less portable in my 
opinion. Java is machine independent, unless when using native code. 
On that scenario ( native code ) Java is not portable.


My point is: I would like to have access to sqlite databases from 
java without worrying me about native code, dll's, .so'es, etc..., 
just using only pure java code, without lossing the normal access to 
the same databases, using the "normal" way, via C, C++ or any other 
compiled language.


Thanks for your quick response.

Cheers,

Nilo
Porto Alegre - Brasil


Hello Nilo,

I think there a IBM open source sql engine in pure Java. But I don't 
rember the name right now.

May be you could use that ?

Regards


Hi, Noel.

Oh, I got your point now.;-)

Yes, there are some free sql engines in pure Java. The most well known 
is called HSQLDB.


My point is: if I use another sql engine that is written in Java then I 
just inverted the problem: how to access the databases without writing a 
bridge in native code that allows me to access the database from C or 
C++ or... ?


I'm not searching for a specific solution for a specific project. I'm 
trying to got a solution that I could use many times.


And to be honest, I like Sqlite a lot... 8-)

Thanks for your interest.

[]'s
Nilo
Porto Alegre - Brasil

Re: [sqlite] Sqlite and Java

[Ran]

If I am not mistaken, the following thread might be relevant:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg11005.html

Ran

On 1/19/06, Nilo Paim <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> Does anybody here knows something about a port of sqlite to java?
>
> Please, note that I'm not talking about java calling sqlite via JNI, but
> about a real rewrite of sqlite using java. Obviously, a second step
> would be the writing of a JDBC driver.
>
> Would be useful that port?
>
> Comments? Suggestions?
>
> Thanks to all.
>
> Nilo
> Porto Alegre - Brasil
>

Re: [sqlite] Sqlite and Java

[Jonathan Ballet]

Noel Frankinet wrote:
> Nilo Paim wrote:
>
>>>
>> Hi Noel,
>>
>> Maybe slower, maybe memory hungry... but not less portable in my
>> opinion. Java is machine independent, unless when using native code.
>> On that scenario ( native code ) Java is not portable.
>>
>> My point is: I would like to have access to sqlite databases from
>> java without worrying me about native code, dll's, .so'es, etc...,
>> just using only pure java code, without lossing the normal access to
>> the same databases, using the "normal" way, via C, C++ or any other
>> compiled language.
>>
>> Thanks for your quick response.
>>
>> Cheers,
>>
>> Nilo
>> Porto Alegre - Brasil
>>
> Hello Nilo,
>
> I think there a IBM open source sql engine in pure Java. But I don't
> rember the name right now.
> May be you could use that ?
>
> Regards
>
I think you're talking of http://hsqldb.org/, used among other project
by OpenOffice ...

Re: [sqlite] Sqlite and Java

[Noel Frankinet]

Nilo Paim wrote:




Hi Noel,

Maybe slower, maybe memory hungry... but not less portable in my 
opinion. Java is machine independent, unless when using native code. 
On that scenario ( native code ) Java is not portable.


My point is: I would like to have access to sqlite databases from java 
without worrying me about native code, dll's, .so'es, etc..., just 
using only pure java code, without lossing the normal access to the 
same databases, using the "normal" way, via C, C++ or any other 
compiled language.


Thanks for your quick response.

Cheers,

Nilo
Porto Alegre - Brasil


Hello Nilo,

I think there a IBM open source sql engine in pure Java. But I don't 
rember the name right now.

May be you could use that ?

Regards

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] Sqlite and Java

[Nilo Paim]

Noel Frankinet wrote:


Nilo Paim wrote:


Hi all,

Does anybody here knows something about a port of sqlite to java?

Please, note that I'm not talking about java calling sqlite via JNI, but
about a real rewrite of sqlite using java. Obviously, a second step
would be the writing of a JDBC driver.

Would be useful that port?

Comments? Suggestions?

Thanks to all.

Nilo
Porto Alegre - Brasil



Hello Nilo,

What would be the point ?
A slower, memory hungry, less portable sqlite ?

Cheers,


Hi Noel,

Maybe slower, maybe memory hungry... but not less portable in my 
opinion. Java is machine independent, unless when using native code. On 
that scenario ( native code ) Java is not portable.


My point is: I would like to have access to sqlite databases from java 
without worrying me about native code, dll's, .so'es, etc..., just using 
only pure java code, without lossing the normal access to the same 
databases, using the "normal" way, via C, C++ or any other compiled 
language.


Thanks for your quick response.

Cheers,

Nilo
Porto Alegre - Brasil

Re: [sqlite] Sqlite and Java

[Noel Frankinet]

Nilo Paim wrote:


Hi all,

Does anybody here knows something about a port of sqlite to java?

Please, note that I'm not talking about java calling sqlite via JNI, but
about a real rewrite of sqlite using java. Obviously, a second step
would be the writing of a JDBC driver.

Would be useful that port?

Comments? Suggestions?

Thanks to all.

Nilo
Porto Alegre - Brasil



Hello Nilo,

What would be the point ?
A slower, memory hungry, less portable sqlite ?

Cheers,

--
Noël Frankinet
Gistek Software SA
http://www.gistek.net

Re: [sqlite] sqlite with java + hibernate

[Kervin L. Pierre]

SQLite is a great database, but if you're
using Java, why not use something like
Apache Derby ( http://db.apache.org/derby/ )?

Regards,
Kervin

Christoph Langewisch wrote:

Hello,

I'm looking for an embedded SQL database and found SQLite. Now I need some
information I did not found at the page or in documentation.

Is it possible to use this database with Java and in particular with
hibernate?

To integrate a database in hibernate there is the following needed:
hibernate.dialect
hibernate.connection.driver_class
hibernate.connection.url

Best regards

Christoph Langewisch

- - - - -
Dipl.-Inform. Christoph LangewischTel: +49-89-747377-67
TESIS DYNAware GmbH Fax: +49-89-747377-99
Baierbrunner Str. 15   http://www.tesis.de/dynaware
D-81379 München   [EMAIL PROTECTED]